Listing
Overview
Price: $875,000
Area: WAIPIO GENTRY
Status: Active Under Contract
Price Improvement! Why pay high homeowners association fees when you can own a 3-bedroom, 2/1-bath single-family home in Waipio Gentry with current association dues of only $18 monthly? This move-in-ready hidden gem is your chance to own a piece of paradise in a desirable neighborhood. Conveniently located near the freeway, it offers easy access to Waikele Outlets, Costco, a sports complex, fantastic restaurants, and grocery stores. Recently renovated in 2023-2024, this home features a new Rustic Aluminum Shake roof from 2021 and Carrara Italian Marble floors downstairs. The living room opens to a back lanai adorned with a beautiful plumeria tree, a wrap-around lanai, and a shed in the backyard. This charming two-story home is in a cul-de-sac, with all three bedrooms conveniently located on the upper level. Enjoy mountain views in one of the bedrooms and island breezes throughout. Freshly painted inside and out in 2023 and 2024, this property presents a fantastic opportunity to customize and transform this house into the home of your dreams. Don’t miss out on this incredible opportunity to own a single-family residence at an affordable price! Some photos have been color-enhanced. Listing by: Sandra Sagisi HI Realty Serv. (808) 492-8187
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202420684"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-679"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Noheaiki"
}
["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(83) "https://drive.google.com/file/d/1KkK0qO7HfArf7rnysgFbqcnTM-fbsVoW/view?usp=drivesdk"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "875000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "875000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPIO GENTRY"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "Price Improvement! Why pay high homeowners association fees when you can own a 3-bedroom, 2/1-bath single-family home in Waipio Gentry with current association dues of only $18 monthly? This move-in-ready hidden gem is your chance to own a piece of paradise in a desirable neighborhood. Conveniently located near the freeway, it offers easy access to Waikele Outlets, Costco, a sports complex, fantastic restaurants, and grocery stores. Recently renovated in 2023-2024, this home features a new Rustic Aluminum Shake roof from 2021 and Carrara Italian Marble floors downstairs. The living room opens to a back lanai adorned with a beautiful plumeria tree, a wrap-around lanai, and a shed in the backyard. This charming two-story home is in a cul-de-sac, with all three bedrooms conveniently located on the upper level. Enjoy mountain views in one of the bedrooms and island breezes throughout. Freshly painted inside and out in 2023 and 2024, this property presents a fantastic opportunity to customize and transform this house into the home of your dreams. Don’t miss out on this incredible opportunity to own a single-family residence at an affordable price! Some photos have been color-enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(29) "Sandra Sagisi HI Realty Serv."
}
["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) "3150.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1441"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1984"
}
["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) "Two"
}
["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(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "SSHR"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(31) "sandrasagisimarketing@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 492-8187"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Sandra Sagisi Moser"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-05T07:50:38.167"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18251528"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-13T17:06:51.673"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26694162"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26694162"
[1]=>
string(8) "26694163"
[2]=>
string(8) "26694164"
[3]=>
string(8) "26694165"
[4]=>
string(8) "26694166"
[5]=>
string(8) "26694167"
[6]=>
string(8) "26694168"
[7]=>
string(8) "26694169"
[8]=>
string(8) "26694170"
[9]=>
string(8) "26694171"
[10]=>
string(8) "26694172"
[11]=>
string(8) "26694173"
[12]=>
string(8) "26694174"
[13]=>
string(8) "26694175"
[14]=>
string(8) "26694176"
[15]=>
string(8) "26694177"
[16]=>
string(8) "26694178"
[17]=>
string(8) "26694179"
[18]=>
string(8) "26694180"
[19]=>
string(8) "26694181"
[20]=>
string(8) "26694182"
[21]=>
string(8) "26694183"
[22]=>
string(8) "26694184"
[23]=>
string(8) "26694185"
[24]=>
string(8) "26694186"
[25]=>
string(8) "26694187"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202420684
)
[StreetNumber] => Array
(
[0] => 94-679
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Noheaiki
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://drive.google.com/file/d/1KkK0qO7HfArf7rnysgFbqcnTM-fbsVoW/view?usp=drivesdk
)
[ListPrice] => Array
(
[0] => 875000.00
)
[CurrentPrice] => Array
(
[0] => 875000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO GENTRY
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Price Improvement! Why pay high homeowners association fees when you can own a 3-bedroom, 2/1-bath single-family home in Waipio Gentry with current association dues of only $18 monthly? This move-in-ready hidden gem is your chance to own a piece of paradise in a desirable neighborhood. Conveniently located near the freeway, it offers easy access to Waikele Outlets, Costco, a sports complex, fantastic restaurants, and grocery stores. Recently renovated in 2023-2024, this home features a new Rustic Aluminum Shake roof from 2021 and Carrara Italian Marble floors downstairs. The living room opens to a back lanai adorned with a beautiful plumeria tree, a wrap-around lanai, and a shed in the backyard. This charming two-story home is in a cul-de-sac, with all three bedrooms conveniently located on the upper level. Enjoy mountain views in one of the bedrooms and island breezes throughout. Freshly painted inside and out in 2023 and 2024, this property presents a fantastic opportunity to customize and transform this house into the home of your dreams. Don’t miss out on this incredible opportunity to own a single-family residence at an affordable price! Some photos have been color-enhanced.
)
[ListOfficeName] => Array
(
[0] => Sandra Sagisi HI Realty Serv.
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 3150.00
)
[SqftTotal] => Array
(
[0] => 1441
)
[YearBuilt] => Array
(
[0] => 1984
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => SSHR
)
[ListAgentEmail] => Array
(
[0] => sandrasagisimarketing@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 492-8187
)
[ListAgentFullName] => Array
(
[0] => Sandra Sagisi Moser
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-05T07:50:38.167
)
[Matrix_Unique_ID] => Array
(
[0] => 18251528
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-13T17:06:51.673
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26694162
)
[listing_image] => Array
(
[0] => 26694162
[1] => 26694163
[2] => 26694164
[3] => 26694165
[4] => 26694166
[5] => 26694167
[6] => 26694168
[7] => 26694169
[8] => 26694170
[9] => 26694171
[10] => 26694172
[11] => 26694173
[12] => 26694174
[13] => 26694175
[14] => 26694176
[15] => 26694177
[16] => 26694178
[17] => 26694179
[18] => 26694180
[19] => 26694181
[20] => 26694182
[21] => 26694183
[22] => 26694184
[23] => 26694185
[24] => 26694186
[25] => 26694187
)
)
- BedsTotal: 3
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 3,150
- Living (sf): 1,441
- Year Built: 1984
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Mountain,Other
- Listing Office: Sandra Sagisi HI Realty Serv.
- Land Tenure: FS - Fee Simple
