Listing
Overview
Price: $2,400,000
Area: TRIANGLE
Status: Active
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. 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) 284-0172
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202510000"
}
["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) "2400000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "TRIANGLE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(671) "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. 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) "GlennI@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 284-0172"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Glenn A Ikeda"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18689349"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-04-20T17:00:01.877"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-04-17"
}
["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) "17:00:01.877"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26962888"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26962888"
[1]=>
string(8) "26962889"
[2]=>
string(8) "26962890"
[3]=>
string(8) "26962891"
[4]=>
string(8) "26962892"
[5]=>
string(8) "26962893"
[6]=>
string(8) "26962894"
[7]=>
string(8) "26962895"
[8]=>
string(8) "26962896"
[9]=>
string(8) "26962897"
[10]=>
string(8) "26962898"
[11]=>
string(8) "26962899"
[12]=>
string(8) "26962900"
[13]=>
string(8) "26962901"
[14]=>
string(8) "26962902"
[15]=>
string(8) "26962903"
[16]=>
string(8) "26962904"
[17]=>
string(8) "26962905"
[18]=>
string(8) "26962906"
[19]=>
string(8) "26962907"
[20]=>
string(8) "26962908"
[21]=>
string(8) "26962909"
[22]=>
string(8) "26962910"
[23]=>
string(8) "26962911"
[24]=>
string(8) "26962912"
[25]=>
string(8) "26962913"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202510000
)
[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] => 2400000.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. 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] => GlennI@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 284-0172
)
[ListAgentFullName] => Array
(
[0] => Glenn A Ikeda
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18689349
)
[MatrixModifiedDT] => Array
(
[0] => 2025-04-20T17:00:01.877
)
[ListingContractDate] => Array
(
[0] => 2025-04-17
)
[MLSAreaMajor] => Array
(
[0] => HawaiiKai
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.877
)
[_thumbnail_id] => Array
(
[0] => 26962888
)
[listing_image] => Array
(
[0] => 26962888
[1] => 26962889
[2] => 26962890
[3] => 26962891
[4] => 26962892
[5] => 26962893
[6] => 26962894
[7] => 26962895
[8] => 26962896
[9] => 26962897
[10] => 26962898
[11] => 26962899
[12] => 26962900
[13] => 26962901
[14] => 26962902
[15] => 26962903
[16] => 26962904
[17] => 26962905
[18] => 26962906
[19] => 26962907
[20] => 26962908
[21] => 26962909
[22] => 26962910
[23] => 26962911
[24] => 26962912
[25] => 26962913
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 10,132 sf
- Living (sf): 2,307
- Year Built: 1962
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Mountain,Other
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Koko Head
- Middle School: Niu Valley
- High School: Kaiser
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on April 20, 2025 - 5:00 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.
© Marcus Realty. All Rights Reserved.
