1564 Ulupuni Street Kailua, HI 96734
Listing
Overview
Price: $1,683,000
Area: OLOMANA
Status: Active
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(45) {
["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]=>
string(10) "1683000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "OLOMANA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["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) "2024-11-10T12:58:58.713"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18364316"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-02T13:23:33.333"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_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"
}
}
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] => 1683000.00
)
[Neighbourhood] => Array
(
[0] => OLOMANA
)
[Status] => Array
(
[0] => Active
)
[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] => 2024-11-10T12:58:58.713
)
[Matrix_Unique_ID] => Array
(
[0] => 18364316
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-02T13:23:33.333
)
[MLSAreaMajor] => Array
(
[0] => Kailua
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_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
)
)
- BedsTotal: 7
- Full Baths: 4
- Land Area (sf): 7,500
- 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
