Listing
Overview
Price: $498,000
Area: WAIPIO GENTRY
Status: Pending
Rarely available ground floor, single level 2 bedroom, 2 bathroom townhome in the pet friendly Villages at Waipio! This move in ready home features a beautifully updated kitchen with granite countertops, stainless steel appliances, porcelain tile flooring, and ample cabinet space. Enjoy newer luxury vinyl plank flooring throughout the main living areas and an open floor plan that flows to your own private, fenced backyard with a spacious patio, perfect for relaxing, entertaining, or letting your pets play. Includes one assigned parking stall with abundant nearby street parking for guests and additional vehicles. Residents enjoy access to the community pool and playground, all conveniently located near Costco, Waikele Shopping Center, restaurants, parks, schools, freeway access, and military bases. Don't miss this wonderful opportunity! One or more photos have been enhanced. Listing by: Redfin Corporation (808) 755-5052
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202614638"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "94-1451"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Waipio Uka"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "L106"
}
["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(51) "https://my.matterport.com/show/?m=6DVXGDvQqti&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "498000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPIO GENTRY"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(886) "Rarely available ground floor, single level 2 bedroom, 2 bathroom townhome in the pet friendly Villages at Waipio! This move in ready home features a beautifully updated kitchen with granite countertops, stainless steel appliances, porcelain tile flooring, and ample cabinet space. Enjoy newer luxury vinyl plank flooring throughout the main living areas and an open floor plan that flows to your own private, fenced backyard with a spacious patio, perfect for relaxing, entertaining, or letting your pets play. Includes one assigned parking stall with abundant nearby street parking for guests and additional vehicles. Residents enjoy access to the community pool and playground, all conveniently located near Costco, Waikele Shopping Center, restaurants, parks, schools, freeway access, and military bases. Don't miss this wonderful opportunity! One or more photos have been enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["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) "470230.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "849"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1987"
}
["BuildingName"]=>
array(1) {
[0]=>
string(22) "Villages At Waipio The"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "739.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(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) "19608516"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-08-24T18:31:53.960"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-08-05"
}
["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) "18:31:53.960"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27480789"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27480789"
[1]=>
string(8) "27480790"
[2]=>
string(8) "27480791"
[3]=>
string(8) "27480792"
[4]=>
string(8) "27480793"
[5]=>
string(8) "27480794"
[6]=>
string(8) "27480795"
[7]=>
string(8) "27480796"
[8]=>
string(8) "27480797"
[9]=>
string(8) "27480798"
[10]=>
string(8) "27480799"
[11]=>
string(8) "27480800"
[12]=>
string(8) "27480801"
[13]=>
string(8) "27480802"
[14]=>
string(8) "27480803"
[15]=>
string(8) "27480804"
[16]=>
string(8) "27480805"
[17]=>
string(8) "27480806"
[18]=>
string(8) "27480807"
[19]=>
string(8) "27480808"
[20]=>
string(8) "27480809"
[21]=>
string(8) "27480810"
[22]=>
string(8) "27480811"
[23]=>
string(8) "27480812"
[24]=>
string(8) "27480813"
[25]=>
string(8) "27480814"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202614638
)
[StreetNumber] => Array
(
[0] => 94-1451
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waipio Uka
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => L106
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=6DVXGDvQqti&mls=1
)
[ListPrice] => Array
(
[0] => 498000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO GENTRY
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Rarely available ground floor, single level 2 bedroom, 2 bathroom townhome in the pet friendly Villages at Waipio! This move in ready home features a beautifully updated kitchen with granite countertops, stainless steel appliances, porcelain tile flooring, and ample cabinet space. Enjoy newer luxury vinyl plank flooring throughout the main living areas and an open floor plan that flows to your own private, fenced backyard with a spacious patio, perfect for relaxing, entertaining, or letting your pets play. Includes one assigned parking stall with abundant nearby street parking for guests and additional vehicles. Residents enjoy access to the community pool and playground, all conveniently located near Costco, Waikele Shopping Center, restaurants, parks, schools, freeway access, and military bases. Don't miss this wonderful opportunity! One or more photos have been enhanced.
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 470230.00
)
[SqftTotal] => Array
(
[0] => 849
)
[YearBuilt] => Array
(
[0] => 1987
)
[BuildingName] => Array
(
[0] => Villages At Waipio The
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 739.86
)
[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] => 19608516
)
[MatrixModifiedDT] => Array
(
[0] => 2026-08-24T18:31:53.960
)
[ListingContractDate] => Array
(
[0] => 2026-08-05
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 18:31:53.960
)
[_thumbnail_id] => Array
(
[0] => 27480789
)
[listing_image] => Array
(
[0] => 27480789
[1] => 27480790
[2] => 27480791
[3] => 27480792
[4] => 27480793
[5] => 27480794
[6] => 27480795
[7] => 27480796
[8] => 27480797
[9] => 27480798
[10] => 27480799
[11] => 27480800
[12] => 27480801
[13] => 27480802
[14] => 27480803
[15] => 27480804
[16] => 27480805
[17] => 27480806
[18] => 27480807
[19] => 27480808
[20] => 27480809
[21] => 27480810
[22] => 27480811
[23] => 27480812
[24] => 27480813
[25] => 27480814
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 470,230 sf
- Living (sf): 849
- Year Built: 1987
- Building Name: Villages At Waipio The
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 1
- View: None
- Listing Office: Redfin Corporation
- Maintenance Fees: $740
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 24, 2026 - 6:31 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.