1564 Ulupuni Street Kailua, HI 96734
Listing
Overview
Price: $1,683,000
Area: OLOMANA
Status: Pending
Discover this spacious 7-bedroom, 4-bath home in the desirable Olomana neighborhood. With ample living space for families or guests, this residence is perfect for your needs. It's conveniently located just minutes from Kailua Town, Castle Hospital, and highway access, making commuting a breeze. Listing by: SC Realty, LLC (808) 591-6277
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202425946"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1564"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Ulupuni"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96734"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1683000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "OLOMANA"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(295) "Discover this spacious 7-bedroom, 4-bath home in the desirable Olomana neighborhood. With ample living space for families or guests, this residence is perfect for your needs. It's conveniently located just minutes from Kailua Town, Castle Hospital, and highway access, making commuting a breeze."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "SC Realty, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7500.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3556"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1961"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Maunawili"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "SCRE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "mchow@screaltyhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 591-6277"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Michael W Chow"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-04T15:07:03.693"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18364316"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26754381"
}
["listing_image"]=>
array(22) {
[0]=>
string(8) "26754381"
[1]=>
string(8) "26754382"
[2]=>
string(8) "26763187"
[3]=>
string(8) "26763188"
[4]=>
string(8) "26763189"
[5]=>
string(8) "26763190"
[6]=>
string(8) "26763191"
[7]=>
string(8) "26763192"
[8]=>
string(8) "26763193"
[9]=>
string(8) "26763194"
[10]=>
string(8) "26763195"
[11]=>
string(8) "26763196"
[12]=>
string(8) "26763197"
[13]=>
string(8) "26763198"
[14]=>
string(8) "26763199"
[15]=>
string(8) "26763200"
[16]=>
string(8) "26763201"
[17]=>
string(8) "26763202"
[18]=>
string(8) "26763203"
[19]=>
string(8) "26763204"
[20]=>
string(8) "26763205"
[21]=>
string(8) "26763206"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-11-02"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "15:07:03.693"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202425946
)
[StreetNumber] => Array
(
[0] => 1564
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ulupuni
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kailua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96734
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1683000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => OLOMANA
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Discover this spacious 7-bedroom, 4-bath home in the desirable Olomana neighborhood. With ample living space for families or guests, this residence is perfect for your needs. It's conveniently located just minutes from Kailua Town, Castle Hospital, and highway access, making commuting a breeze.
)
[ListOfficeName] => Array
(
[0] => SC Realty, LLC
)
[BedsTotal] => Array
(
[0] => 7
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7500.00
)
[SqftTotal] => Array
(
[0] => 3556
)
[YearBuilt] => Array
(
[0] => 1961
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Maunawili
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kailua
)
[HighSchool] => Array
(
[0] => Kailua
)
[ListOfficeMLSID] => Array
(
[0] => SCRE
)
[ListAgentEmail] => Array
(
[0] => mchow@screaltyhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 591-6277
)
[ListAgentFullName] => Array
(
[0] => Michael W Chow
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-04T15:07:03.693
)
[Matrix_Unique_ID] => Array
(
[0] => 18364316
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => Kailua
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26754381
)
[listing_image] => Array
(
[0] => 26754381
[1] => 26754382
[2] => 26763187
[3] => 26763188
[4] => 26763189
[5] => 26763190
[6] => 26763191
[7] => 26763192
[8] => 26763193
[9] => 26763194
[10] => 26763195
[11] => 26763196
[12] => 26763197
[13] => 26763198
[14] => 26763199
[15] => 26763200
[16] => 26763201
[17] => 26763202
[18] => 26763203
[19] => 26763204
[20] => 26763205
[21] => 26763206
)
[ListingContractDate] => Array
(
[0] => 2024-11-02
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 15:07:03.693
)
)
- BedsTotal: 7
- Full Baths: 4
- Land Area (sf): 7,500 sf
- Living (sf): 3,556
- Year Built: 1961
- Property Condition: Average
- Number of Parking Spaces: 4
- View: Mountain
- Listing Office: SC Realty, LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Maunawili
- Middle School: Kailua
- High School: Kailua
