Listing
Overview
Price: $849,000
Area: WAIPIO GENTRY
Status: Pending
Bring your vision and unlock the full potential of this diamond in the rough! Located in the highly-desirable Waipio Gentry community with an incredibly low $18/month HOA, this spacious 3-bedroom, 2.5-bath home offers just under 1,800 sq ft of living space and endless opportunity. Featuring brand new exterior paint and a unique, functional layout with all bedrooms and full bathrooms downstairs, plus a massive upstairs family room with a half bath powder room. Enjoy high vaulted ceilings, a private, fully-enclosed courtyard, and a balcony showcasing stunning Diamond Head, ocean, city, and mountain views. While other homes in the community are zero lot line, this incredible corner lot stands on it's own! Conveniently located near freeway access, Costco, shopping, schools, and more, this home offers 4 total parking, including a 2-car garage and extended driveway to fit two additional vehicles. The interior of the home is original and ready for your personal touch - sold As-Is. Don’t miss your chance to create something truly special! Call your favorite local Realtor to schedule your private showing today! Listing by: eXp Realty (808) 312-7556
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202606116"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "94-1154"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(4) "Pohu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["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/1172704376"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "849000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPIO GENTRY"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1121) "Bring your vision and unlock the full potential of this diamond in the rough! Located in the highly-desirable Waipio Gentry community with an incredibly low $18/month HOA, this spacious 3-bedroom, 2.5-bath home offers just under 1,800 sq ft of living space and endless opportunity. Featuring brand new exterior paint and a unique, functional layout with all bedrooms and full bathrooms downstairs, plus a massive upstairs family room with a half bath powder room. Enjoy high vaulted ceilings, a private, fully-enclosed courtyard, and a balcony showcasing stunning Diamond Head, ocean, city, and mountain views. While other homes in the community are zero lot line, this incredible corner lot stands on it's own! Conveniently located near freeway access, Costco, shopping, schools, and more, this home offers 4 total parking, including a 2-car garage and extended driveway to fit two additional vehicles. The interior of the home is original and ready for your personal touch - sold As-Is. Don’t miss your chance to create something truly special! Call your favorite local Realtor to schedule your private showing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "3486.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1867"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1980"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(12) "Average,Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(40) "City,Diamond Head,Mountain,Other,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Kanoelani"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(9) "Highlands"
}
["HighSchool"]=>
array(1) {
[0]=>
string(10) "Pearl City"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "jenniferhaole@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 312-7556"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Jennifer Haole"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19349100"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-04-22T15:34:32.773"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-04-15"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "15:34:32.773"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27360245"
}
["listing_image"]=>
array(18) {
[0]=>
string(8) "27360245"
[1]=>
string(8) "27360246"
[2]=>
string(8) "27360247"
[3]=>
string(8) "27360248"
[4]=>
string(8) "27360249"
[5]=>
string(8) "27360250"
[6]=>
string(8) "27360251"
[7]=>
string(8) "27360252"
[8]=>
string(8) "27360253"
[9]=>
string(8) "27360254"
[10]=>
string(8) "27360255"
[11]=>
string(8) "27360256"
[12]=>
string(8) "27360257"
[13]=>
string(8) "27360258"
[14]=>
string(8) "27360259"
[15]=>
string(8) "27360260"
[16]=>
string(8) "27360261"
[17]=>
string(8) "27360262"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202606116
)
[StreetNumber] => Array
(
[0] => 94-1154
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Pohu
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1172704376
)
[ListPrice] => Array
(
[0] => 849000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO GENTRY
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Bring your vision and unlock the full potential of this diamond in the rough! Located in the highly-desirable Waipio Gentry community with an incredibly low $18/month HOA, this spacious 3-bedroom, 2.5-bath home offers just under 1,800 sq ft of living space and endless opportunity. Featuring brand new exterior paint and a unique, functional layout with all bedrooms and full bathrooms downstairs, plus a massive upstairs family room with a half bath powder room. Enjoy high vaulted ceilings, a private, fully-enclosed courtyard, and a balcony showcasing stunning Diamond Head, ocean, city, and mountain views. While other homes in the community are zero lot line, this incredible corner lot stands on it's own! Conveniently located near freeway access, Costco, shopping, schools, and more, this home offers 4 total parking, including a 2-car garage and extended driveway to fit two additional vehicles. The interior of the home is original and ready for your personal touch - sold As-Is. Don’t miss your chance to create something truly special! Call your favorite local Realtor to schedule your private showing today!
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 3486.00
)
[SqftTotal] => Array
(
[0] => 1867
)
[YearBuilt] => Array
(
[0] => 1980
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average,Fair
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => City,Diamond Head,Mountain,Other,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kanoelani
)
[MiddleOrJuniorSchool] => Array
(
[0] => Highlands
)
[HighSchool] => Array
(
[0] => Pearl City
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => jenniferhaole@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 312-7556
)
[ListAgentFullName] => Array
(
[0] => Jennifer Haole
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19349100
)
[MatrixModifiedDT] => Array
(
[0] => 2026-04-22T15:34:32.773
)
[ListingContractDate] => Array
(
[0] => 2026-04-15
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 15:34:32.773
)
[_thumbnail_id] => Array
(
[0] => 27360245
)
[listing_image] => Array
(
[0] => 27360245
[1] => 27360246
[2] => 27360247
[3] => 27360248
[4] => 27360249
[5] => 27360250
[6] => 27360251
[7] => 27360252
[8] => 27360253
[9] => 27360254
[10] => 27360255
[11] => 27360256
[12] => 27360257
[13] => 27360258
[14] => 27360259
[15] => 27360260
[16] => 27360261
[17] => 27360262
)
)
- BedsTotal: 3
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 3,486 sf
- Living (sf): 1,867
- Year Built: 1980
- Property Condition: Average,Fair
- Number of Parking Spaces: 4
- View: City,Diamond Head,Mountain,Other,Sunrise
- Listing Office: eXp Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Kanoelani
- Middle School: Highlands
- High School: Pearl City
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on April 22, 2026 - 3:34 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.