Listing
Overview
Price: $1,210,000
Area: KOA RIDGE
Status: Active
Step into this beautifully move-in-ready 4-bedroom & 3-bath home in Koa Ridge, where the open-concept living and dining area flows seamlessly into a modern kitchen with quartz countertops, custom cabinetry, and stainless-steel appliances. The kitchen door leads you to the fenced-in yard perfect for pets and get-togethers. Downstairs also features a full bathroom and a bedroom—perfect for guests or a home office. Upstairs, enjoy a spacious bonus room that can be used as a home office, movie theater or game room. There are three additional bedrooms, all with split A/Cs for year-round comfort. This resale offers a huge advantage: all upgrades are completed, including luxury vinyl plank flooring, 30 leased PV panels with Tesla Powerwall installed, split AC units, and your lawn! Enjoy community parks, walking/bike paths, and the future Village Center—all just minutes from Costco, shopping, and freeway access. VA loan assumption available at 5.875% w/ a balance of $1.045M! A few photos have been enhanced. Listing by: BHGRE Advantage Realty (808) 738-3600
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202505785"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "94-1251"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(12) "Hale Halawai"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "6"
}
["City"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96797"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://listings.hetproductions.com/sites/enkrzap/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1210000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "KOA RIDGE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1018) "Step into this beautifully move-in-ready 4-bedroom & 3-bath home in Koa Ridge, where the open-concept living and dining area flows seamlessly into a modern kitchen with quartz countertops, custom cabinetry, and stainless-steel appliances. The kitchen door leads you to the fenced-in yard perfect for pets and get-togethers. Downstairs also features a full bathroom and a bedroom—perfect for guests or a home office. Upstairs, enjoy a spacious bonus room that can be used as a home office, movie theater or game room. There are three additional bedrooms, all with split A/Cs for year-round comfort. This resale offers a huge advantage: all upgrades are completed, including luxury vinyl plank flooring, 30 leased PV panels with Tesla Powerwall installed, split AC units, and your lawn! Enjoy community parks, walking/bike paths, and the future Village Center—all just minutes from Costco, shopping, and freeway access. VA loan assumption available at 5.875% w/ a balance of $1.045M! A few photos have been enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "3589.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1444"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2023"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "200.50"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(5) "Lehua"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(9) "Highlands"
}
["HighSchool"]=>
array(1) {
[0]=>
string(10) "Pearl City"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "rolandar@betterhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Rolanda Li Racoma"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18578183"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-07-16T17:30:01.987"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-06-06"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:30:01.987"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27021748"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27021748"
[1]=>
string(8) "27021749"
[2]=>
string(8) "27021750"
[3]=>
string(8) "27021751"
[4]=>
string(8) "27021752"
[5]=>
string(8) "27021753"
[6]=>
string(8) "27021754"
[7]=>
string(8) "27021755"
[8]=>
string(8) "27021756"
[9]=>
string(8) "27021757"
[10]=>
string(8) "27021758"
[11]=>
string(8) "27021759"
[12]=>
string(8) "27021760"
[13]=>
string(8) "27021761"
[14]=>
string(8) "27021762"
[15]=>
string(8) "27021763"
[16]=>
string(8) "27021764"
[17]=>
string(8) "27021765"
[18]=>
string(8) "27021766"
[19]=>
string(8) "27021767"
[20]=>
string(8) "27021768"
[21]=>
string(8) "27021769"
[22]=>
string(8) "27021770"
[23]=>
string(8) "27021771"
[24]=>
string(8) "27021772"
[25]=>
string(8) "27021773"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202505785
)
[StreetNumber] => Array
(
[0] => 94-1251
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hale Halawai
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] => 6
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/enkrzap/unbranded
)
[ListPrice] => Array
(
[0] => 1210000.00
)
[Neighbourhood] => Array
(
[0] => KOA RIDGE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Step into this beautifully move-in-ready 4-bedroom & 3-bath home in Koa Ridge, where the open-concept living and dining area flows seamlessly into a modern kitchen with quartz countertops, custom cabinetry, and stainless-steel appliances. The kitchen door leads you to the fenced-in yard perfect for pets and get-togethers. Downstairs also features a full bathroom and a bedroom—perfect for guests or a home office. Upstairs, enjoy a spacious bonus room that can be used as a home office, movie theater or game room. There are three additional bedrooms, all with split A/Cs for year-round comfort. This resale offers a huge advantage: all upgrades are completed, including luxury vinyl plank flooring, 30 leased PV panels with Tesla Powerwall installed, split AC units, and your lawn! Enjoy community parks, walking/bike paths, and the future Village Center—all just minutes from Costco, shopping, and freeway access. VA loan assumption available at 5.875% w/ a balance of $1.045M! A few photos have been enhanced.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 3589.00
)
[SqftTotal] => Array
(
[0] => 1444
)
[YearBuilt] => Array
(
[0] => 2023
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 200.50
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Lehua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Highlands
)
[HighSchool] => Array
(
[0] => Pearl City
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => rolandar@betterhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3600
)
[ListAgentFullName] => Array
(
[0] => Rolanda Li Racoma
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18578183
)
[MatrixModifiedDT] => Array
(
[0] => 2025-07-16T17:30:01.987
)
[ListingContractDate] => Array
(
[0] => 2025-06-06
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:30:01.987
)
[_thumbnail_id] => Array
(
[0] => 27021748
)
[listing_image] => Array
(
[0] => 27021748
[1] => 27021749
[2] => 27021750
[3] => 27021751
[4] => 27021752
[5] => 27021753
[6] => 27021754
[7] => 27021755
[8] => 27021756
[9] => 27021757
[10] => 27021758
[11] => 27021759
[12] => 27021760
[13] => 27021761
[14] => 27021762
[15] => 27021763
[16] => 27021764
[17] => 27021765
[18] => 27021766
[19] => 27021767
[20] => 27021768
[21] => 27021769
[22] => 27021770
[23] => 27021771
[24] => 27021772
[25] => 27021773
)
)
- BedsTotal: 4
- Full Baths: 3
- Land Area (sf): 3,589 sf
- Living (sf): 1,444
- Year Built: 2023
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: None
- Listing Office: BHGRE Advantage Realty
- Maintenance Fees: $201
- Land Tenure: FS - Fee Simple
- Elementary School: Lehua
- Middle School: Highlands
- High School: Pearl City
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 16, 2025 - 5:30 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.
