Listing
Overview
Price: $1,699,000
Area: POHAKUPU
Status: Active
Beautifully renovated single level home tucked away from the main roads, offering privacy and serenity. A spacious entry welcomes you into the bright living room featuring beautiful porcelain tile flooring. The gorgeous eat in kitchen boasts Quartz countertops, a tile backsplash, pendant lighting, and new stainless steel appliances. Stay comfortable year round with split A/C in every room. Numerous windows, replaced in 2016, provide abundant natural light, cool breezes, and lovely views of the fully fenced backyard with room to expand. Enjoy the shade and fruit of the mature mango tree and the irrigation system for the Palms. The large covered lanai is perfect for entertaining family and friends. Additional features include an extra-large storage unit. Conveniently located near world famous Kailua beaches, parks, shopping, and restaurants, with easy access to H3 and the Pali Highway without having to fight Kailua town traffic. Put this home on your must see list! One or more photos have been enhanced. Listing by: Redfin Corporation (808) 755-5052
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202615259"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "558"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Ulumu"
}
["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(51) "https://my.matterport.com/show/?m=96zmcnHxsPw&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1699000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "POHAKUPU"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1016) "Beautifully renovated single level home tucked away from the main roads, offering privacy and serenity. A spacious entry welcomes you into the bright living room featuring beautiful porcelain tile flooring. The gorgeous eat in kitchen boasts Quartz countertops, a tile backsplash, pendant lighting, and new stainless steel appliances. Stay comfortable year round with split A/C in every room. Numerous windows, replaced in 2016, provide abundant natural light, cool breezes, and lovely views of the fully fenced backyard with room to expand. Enjoy the shade and fruit of the mature mango tree and the irrigation system for the Palms. The large covered lanai is perfect for entertaining family and friends. Additional features include an extra-large storage unit. Conveniently located near world famous Kailua beaches, parks, shopping, and restaurants, with easy access to H3 and the Pali Highway without having to fight Kailua town traffic. Put this home on your must see list! One or more photos have been enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7500.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1684"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1959"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "RFIN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "mike.demello@redfin.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 755-5052"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Michael D DeMello"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19636504"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-09-08T14:15:01.487"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-08-19"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "14:15:01.487"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27496972"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27496972"
[1]=>
string(8) "27496973"
[2]=>
string(8) "27496974"
[3]=>
string(8) "27496975"
[4]=>
string(8) "27496976"
[5]=>
string(8) "27496977"
[6]=>
string(8) "27496978"
[7]=>
string(8) "27496979"
[8]=>
string(8) "27496980"
[9]=>
string(8) "27496981"
[10]=>
string(8) "27496982"
[11]=>
string(8) "27496983"
[12]=>
string(8) "27496984"
[13]=>
string(8) "27496985"
[14]=>
string(8) "27496986"
[15]=>
string(8) "27496987"
[16]=>
string(8) "27496988"
[17]=>
string(8) "27496989"
[18]=>
string(8) "27496990"
[19]=>
string(8) "27496991"
[20]=>
string(8) "27496992"
[21]=>
string(8) "27496993"
[22]=>
string(8) "27496994"
[23]=>
string(8) "27496995"
[24]=>
string(8) "27496996"
[25]=>
string(8) "27496997"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202615259
)
[StreetNumber] => Array
(
[0] => 558
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ulumu
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kailua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96734
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=96zmcnHxsPw&mls=1
)
[ListPrice] => Array
(
[0] => 1699000.00
)
[Neighbourhood] => Array
(
[0] => POHAKUPU
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Beautifully renovated single level home tucked away from the main roads, offering privacy and serenity. A spacious entry welcomes you into the bright living room featuring beautiful porcelain tile flooring. The gorgeous eat in kitchen boasts Quartz countertops, a tile backsplash, pendant lighting, and new stainless steel appliances. Stay comfortable year round with split A/C in every room. Numerous windows, replaced in 2016, provide abundant natural light, cool breezes, and lovely views of the fully fenced backyard with room to expand. Enjoy the shade and fruit of the mature mango tree and the irrigation system for the Palms. The large covered lanai is perfect for entertaining family and friends. Additional features include an extra-large storage unit. Conveniently located near world famous Kailua beaches, parks, shopping, and restaurants, with easy access to H3 and the Pali Highway without having to fight Kailua town traffic. Put this home on your must see list! One or more photos have been enhanced.
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7500.00
)
[SqftTotal] => Array
(
[0] => 1684
)
[YearBuilt] => Array
(
[0] => 1959
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RFIN
)
[ListAgentEmail] => Array
(
[0] => mike.demello@redfin.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 755-5052
)
[ListAgentFullName] => Array
(
[0] => Michael D DeMello
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19636504
)
[MatrixModifiedDT] => Array
(
[0] => 2026-09-08T14:15:01.487
)
[ListingContractDate] => Array
(
[0] => 2026-08-19
)
[MLSAreaMajor] => Array
(
[0] => Kailua
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 14:15:01.487
)
[_thumbnail_id] => Array
(
[0] => 27496972
)
[listing_image] => Array
(
[0] => 27496972
[1] => 27496973
[2] => 27496974
[3] => 27496975
[4] => 27496976
[5] => 27496977
[6] => 27496978
[7] => 27496979
[8] => 27496980
[9] => 27496981
[10] => 27496982
[11] => 27496983
[12] => 27496984
[13] => 27496985
[14] => 27496986
[15] => 27496987
[16] => 27496988
[17] => 27496989
[18] => 27496990
[19] => 27496991
[20] => 27496992
[21] => 27496993
[22] => 27496994
[23] => 27496995
[24] => 27496996
[25] => 27496997
)
)
- BedsTotal: 4
- Full Baths: 2
- Land Area (sf): 7,500 sf
- Living (sf): 1,684
- Year Built: 1959
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 4
- View: Garden
- Listing Office: Redfin Corporation
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on September 8, 2026 - 2:15 PM
Information is deemed reliable but not guaranteed.
Copyright: 2026 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
© Marcus Realty. All Rights Reserved.
