NEWLY RENOVATED & SINGLE LEVEL HOME…This stunning newly renovated single-family home is located in one of the most sought-after neighborhoods. Come see this 3 bed, 2 full bath home with over 10,000 land sqft that sits across of Koko Head Neighborhood Park. The home has new fresh interior and exterior paint, new vinyl flooring, freshly painted cabinets, quartz countertops, split ACs in every room, and a sprinkler system for added convenience. The open-concept kitchen flows to your living/dining room & peaceful yard on both sides. Available upon request: architectural plans for a new single family home w/ ADU & Pool worth over $60K. Less than a 10 minute drive from Koko Head Marina Center, Safeway, Costco, and more! You don’t want to miss this opportunity!!! Listing by: BHGRE Advantage Realty (808) 753-3923
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202515467"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "464"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Poipu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96825"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://listings.hetproductions.com/sites/pnpvawq/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2325000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "TRIANGLE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(770) "NEWLY RENOVATED & SINGLE LEVEL HOME…This stunning newly renovated single-family home is located in one of the most sought-after neighborhoods. Come see this 3 bed, 2 full bath home with over 10,000 land sqft that sits across of Koko Head Neighborhood Park. The home has new fresh interior and exterior paint, new vinyl flooring, freshly painted cabinets, quartz countertops, split ACs in every room, and a sprinkler system for added convenience. The open-concept kitchen flows to your living/dining room & peaceful yard on both sides. Available upon request: architectural plans for a new single family home w/ ADU & Pool worth over $60K. Less than a 10 minute drive from Koko Head Marina Center, Safeway, Costco, and more! You don’t want to miss this opportunity!!!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10132.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2307"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1962"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Koko Head"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kaiser"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "BrettA@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 753-3923"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Brett K Aka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18848382"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-07-04T20:59:53.373"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-07-04"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "HawaiiKai"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "20:59:53.373"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27057147"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27057147"
[1]=>
string(8) "27057148"
[2]=>
string(8) "27057149"
[3]=>
string(8) "27057150"
[4]=>
string(8) "27057151"
[5]=>
string(8) "27057152"
[6]=>
string(8) "27057153"
[7]=>
string(8) "27057154"
[8]=>
string(8) "27057155"
[9]=>
string(8) "27057156"
[10]=>
string(8) "27057157"
[11]=>
string(8) "27057158"
[12]=>
string(8) "27057159"
[13]=>
string(8) "27057160"
[14]=>
string(8) "27057161"
[15]=>
string(8) "27057162"
[16]=>
string(8) "27057163"
[17]=>
string(8) "27057164"
[18]=>
string(8) "27057165"
[19]=>
string(8) "27057166"
[20]=>
string(8) "27057167"
[21]=>
string(8) "27057168"
[22]=>
string(8) "27057169"
[23]=>
string(8) "27057170"
[24]=>
string(8) "27057171"
[25]=>
string(8) "27057172"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202515467
)
[StreetNumber] => Array
(
[0] => 464
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Poipu
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96825
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/pnpvawq/unbranded
)
[ListPrice] => Array
(
[0] => 2325000.00
)
[Neighbourhood] => Array
(
[0] => TRIANGLE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => NEWLY RENOVATED & SINGLE LEVEL HOME…This stunning newly renovated single-family home is located in one of the most sought-after neighborhoods. Come see this 3 bed, 2 full bath home with over 10,000 land sqft that sits across of Koko Head Neighborhood Park. The home has new fresh interior and exterior paint, new vinyl flooring, freshly painted cabinets, quartz countertops, split ACs in every room, and a sprinkler system for added convenience. The open-concept kitchen flows to your living/dining room & peaceful yard on both sides. Available upon request: architectural plans for a new single family home w/ ADU & Pool worth over $60K. Less than a 10 minute drive from Koko Head Marina Center, Safeway, Costco, and more! You don’t want to miss this opportunity!!!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 10132.00
)
[SqftTotal] => Array
(
[0] => 2307
)
[YearBuilt] => Array
(
[0] => 1962
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Koko Head
)
[MiddleOrJuniorSchool] => Array
(
[0] => Niu Valley
)
[HighSchool] => Array
(
[0] => Kaiser
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => BrettA@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 753-3923
)
[ListAgentFullName] => Array
(
[0] => Brett K Aka
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18848382
)
[MatrixModifiedDT] => Array
(
[0] => 2025-07-04T20:59:53.373
)
[ListingContractDate] => Array
(
[0] => 2025-07-04
)
[MLSAreaMajor] => Array
(
[0] => HawaiiKai
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 20:59:53.373
)
[_thumbnail_id] => Array
(
[0] => 27057147
)
[listing_image] => Array
(
[0] => 27057147
[1] => 27057148
[2] => 27057149
[3] => 27057150
[4] => 27057151
[5] => 27057152
[6] => 27057153
[7] => 27057154
[8] => 27057155
[9] => 27057156
[10] => 27057157
[11] => 27057158
[12] => 27057159
[13] => 27057160
[14] => 27057161
[15] => 27057162
[16] => 27057163
[17] => 27057164
[18] => 27057165
[19] => 27057166
[20] => 27057167
[21] => 27057168
[22] => 27057169
[23] => 27057170
[24] => 27057171
[25] => 27057172
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 4, 2025 - 8:59 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 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.
