Listing
Overview
Price: $529,000
Area: WAIPIO GENTRY
Status: Active Under Contract
Welcome home to this rarely available, corner-end residence of Cliffside Villages at Waipio! Offering the ideal blend of space, privacy, breathtaking views, and modern updates, this immaculate 2-bedroom, 2-bath home with 2 conveniently located parking stalls is truly a standout. Step inside and immediately appreciate the fresh, inviting feel created by new carpet, fresh paint, and new appliances. The renovated kitchen and updated bathrooms add a stylish touch, while abundant natural light and cool breezes flow throughout the home. The spacious primary suite provides a peaceful retreat with two closets, an en-suite bathroom with shower, and a convenient in-unit washer and dryer. Step outside onto your large, private lanai balcony to take in mountain, city, and ocean views. Enjoy the added convenience of two side-by-side parking stalls located close to the residence, plus a dedicated car wash area. Ideally positioned in the heart of Central Oahu, just minutes from freeway access, Costco, Foodland, shopping, dining, parks, military bases, and more. Move-in ready, thoughtfully upgraded, and perfectly positioned, this is the home you've been waiting for! **CLICK ON VIDEO TOUR LINK** Listing by: Coldwell Banker Realty (808) 351-4194
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202614910"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-100"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(4) "Huki"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "201"
}
["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(41) "https://player.vimeo.com/video/1218408484"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "529000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPIO GENTRY"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1196) "Welcome home to this rarely available, corner-end residence of Cliffside Villages at Waipio! Offering the ideal blend of space, privacy, breathtaking views, and modern updates, this immaculate 2-bedroom, 2-bath home with 2 conveniently located parking stalls is truly a standout. Step inside and immediately appreciate the fresh, inviting feel created by new carpet, fresh paint, and new appliances. The renovated kitchen and updated bathrooms add a stylish touch, while abundant natural light and cool breezes flow throughout the home. The spacious primary suite provides a peaceful retreat with two closets, an en-suite bathroom with shower, and a convenient in-unit washer and dryer. Step outside onto your large, private lanai balcony to take in mountain, city, and ocean views. Enjoy the added convenience of two side-by-side parking stalls located close to the residence, plus a dedicated car wash area. Ideally positioned in the heart of Central Oahu, just minutes from freeway access, Costco, Foodland, shopping, dining, parks, military bases, and more. Move-in ready, thoughtfully upgraded, and perfectly positioned, this is the home you've been waiting for! **CLICK ON VIDEO TOUR LINK**"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "144053.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "792"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1989"
}
["BuildingName"]=>
array(1) {
[0]=>
string(27) "Cliffside Village at Waipio"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(25) "City,Mountain,Ocean,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "516.86"
}
["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(6) "CBPP15"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "realtorrjg@aol.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 351-4194"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(20) "Robert Jensen Garces"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19616795"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-08-30T17:30:37.227"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-08-13"
}
["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:37.227"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27491225"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "27491225"
[1]=>
string(8) "27491226"
[2]=>
string(8) "27491227"
[3]=>
string(8) "27491228"
[4]=>
string(8) "27491229"
[5]=>
string(8) "27491230"
[6]=>
string(8) "27491231"
[7]=>
string(8) "27491232"
[8]=>
string(8) "27491233"
[9]=>
string(8) "27491234"
[10]=>
string(8) "27491235"
[11]=>
string(8) "27491236"
[12]=>
string(8) "27491237"
[13]=>
string(8) "27491238"
[14]=>
string(8) "27491239"
[15]=>
string(8) "27491240"
[16]=>
string(8) "27491241"
[17]=>
string(8) "27491242"
[18]=>
string(8) "27491243"
[19]=>
string(8) "27497632"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202614910
)
[StreetNumber] => Array
(
[0] => 94-100
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Huki
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => 201
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1218408484
)
[ListPrice] => Array
(
[0] => 529000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO GENTRY
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Welcome home to this rarely available, corner-end residence of Cliffside Villages at Waipio! Offering the ideal blend of space, privacy, breathtaking views, and modern updates, this immaculate 2-bedroom, 2-bath home with 2 conveniently located parking stalls is truly a standout. Step inside and immediately appreciate the fresh, inviting feel created by new carpet, fresh paint, and new appliances. The renovated kitchen and updated bathrooms add a stylish touch, while abundant natural light and cool breezes flow throughout the home. The spacious primary suite provides a peaceful retreat with two closets, an en-suite bathroom with shower, and a convenient in-unit washer and dryer. Step outside onto your large, private lanai balcony to take in mountain, city, and ocean views. Enjoy the added convenience of two side-by-side parking stalls located close to the residence, plus a dedicated car wash area. Ideally positioned in the heart of Central Oahu, just minutes from freeway access, Costco, Foodland, shopping, dining, parks, military bases, and more. Move-in ready, thoughtfully upgraded, and perfectly positioned, this is the home you've been waiting for! **CLICK ON VIDEO TOUR LINK**
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 144053.00
)
[SqftTotal] => Array
(
[0] => 792
)
[YearBuilt] => Array
(
[0] => 1989
)
[BuildingName] => Array
(
[0] => Cliffside Village at Waipio
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => City,Mountain,Ocean,Other
)
[MaintenanceExpense] => Array
(
[0] => 516.86
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP15
)
[ListAgentEmail] => Array
(
[0] => realtorrjg@aol.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 351-4194
)
[ListAgentFullName] => Array
(
[0] => Robert Jensen Garces
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19616795
)
[MatrixModifiedDT] => Array
(
[0] => 2026-08-30T17:30:37.227
)
[ListingContractDate] => Array
(
[0] => 2026-08-13
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:30:37.227
)
[_thumbnail_id] => Array
(
[0] => 27491225
)
[listing_image] => Array
(
[0] => 27491225
[1] => 27491226
[2] => 27491227
[3] => 27491228
[4] => 27491229
[5] => 27491230
[6] => 27491231
[7] => 27491232
[8] => 27491233
[9] => 27491234
[10] => 27491235
[11] => 27491236
[12] => 27491237
[13] => 27491238
[14] => 27491239
[15] => 27491240
[16] => 27491241
[17] => 27491242
[18] => 27491243
[19] => 27497632
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 144,053 sf
- Living (sf): 792
- Year Built: 1989
- Building Name: Cliffside Village at Waipio
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: City,Mountain,Ocean,Other
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $517
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 30, 2026 - 5:30 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.