Listing
Overview
Price: $1,195,000
Area: WAIKELE-RENAISSANCE
Status: Active
Immaculate two-story 4 bedroom, 2.5 bath single family home with two family rooms. It is situated on a corner lot in the Renaissance subdivision. Conveniently located to on/off freeway access, close to Waikele Shopping Outlets, Safeway, and Lowe’s. Centrally located on the island with easy commutes to military bases, downtown Waikiki, and the Daniel K. Inouye International Airport. Brand new custom kitchen with Rev-A-Shelf inserts, all new appliances, and new ceramic tile. Brand new hot water/solar heater, 27 owned photovoltaic panels, new whole-house water softener, and HVAC unit. Brand new bathroom renovations for all 3; to include new custom wood cabinets, countertops, lighted crown molding, new vanities, sinks, faucets, and light fixtures. Luxury vinyl planks throughout the main floor. Brand-new paint interior and exterior, and new outdoor wired security lighting. Additionally, upgraded garage with flooring, stainless steel utility sink, and Gladiator wall cabinets, with both hanging and outside storage. Feel the comfort of living in this convenient, and great neighborhood with a park directly across the street for children to play. A must-see! Assumable VA loan at 2.625%. Listing by: OahuRE.com (808) 425-7887
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202427519"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-871"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Hiapo"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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(92) "https://oahurealestatevirtualtours.net/SellYourHome.php?MLSNumber=202427519&PropertyType=RES"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1195000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(19) "WAIKELE-RENAISSANCE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1198) "Immaculate two-story 4 bedroom, 2.5 bath single family home with two family rooms. It is situated on a corner lot in the Renaissance subdivision. Conveniently located to on/off freeway access, close to Waikele Shopping Outlets, Safeway, and Lowe’s. Centrally located on the island with easy commutes to military bases, downtown Waikiki, and the Daniel K. Inouye International Airport. Brand new custom kitchen with Rev-A-Shelf inserts, all new appliances, and new ceramic tile. Brand new hot water/solar heater, 27 owned photovoltaic panels, new whole-house water softener, and HVAC unit. Brand new bathroom renovations for all 3; to include new custom wood cabinets, countertops, lighted crown molding, new vanities, sinks, faucets, and light fixtures. Luxury vinyl planks throughout the main floor. Brand-new paint interior and exterior, and new outdoor wired security lighting. Additionally, upgraded garage with flooring, stainless steel utility sink, and Gladiator wall cabinets, with both hanging and outside storage. Feel the comfort of living in this convenient, and great neighborhood with a park directly across the street for children to play. A must-see! Assumable VA loan at 2.625%."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "OahuRE.com"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "4191.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2185"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2005"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waikele"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "GIVE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(15) "bryn@oahure.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 425-7887"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Bryn W Kaufman"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-16T18:21:32.007"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18407880"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26790243"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26790243"
[1]=>
string(8) "26790244"
[2]=>
string(8) "26790245"
[3]=>
string(8) "26790246"
[4]=>
string(8) "26790247"
[5]=>
string(8) "26790248"
[6]=>
string(8) "26790249"
[7]=>
string(8) "26790250"
[8]=>
string(8) "26790251"
[9]=>
string(8) "26790252"
[10]=>
string(8) "26790253"
[11]=>
string(8) "26790254"
[12]=>
string(8) "26790255"
[13]=>
string(8) "26790256"
[14]=>
string(8) "26790257"
[15]=>
string(8) "26790258"
[16]=>
string(8) "26790259"
[17]=>
string(8) "26790260"
[18]=>
string(8) "26790261"
[19]=>
string(8) "26790262"
[20]=>
string(8) "26790263"
[21]=>
string(8) "26790264"
[22]=>
string(8) "26790265"
[23]=>
string(8) "26790266"
[24]=>
string(8) "26790267"
[25]=>
string(8) "26790268"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-11-30"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "18:21:32.007"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202427519
)
[StreetNumber] => Array
(
[0] => 94-871
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hiapo
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://oahurealestatevirtualtours.net/SellYourHome.php?MLSNumber=202427519&PropertyType=RES
)
[ListPrice] => Array
(
[0] => 1195000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => WAIKELE-RENAISSANCE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Immaculate two-story 4 bedroom, 2.5 bath single family home with two family rooms. It is situated on a corner lot in the Renaissance subdivision. Conveniently located to on/off freeway access, close to Waikele Shopping Outlets, Safeway, and Lowe’s. Centrally located on the island with easy commutes to military bases, downtown Waikiki, and the Daniel K. Inouye International Airport. Brand new custom kitchen with Rev-A-Shelf inserts, all new appliances, and new ceramic tile. Brand new hot water/solar heater, 27 owned photovoltaic panels, new whole-house water softener, and HVAC unit. Brand new bathroom renovations for all 3; to include new custom wood cabinets, countertops, lighted crown molding, new vanities, sinks, faucets, and light fixtures. Luxury vinyl planks throughout the main floor. Brand-new paint interior and exterior, and new outdoor wired security lighting. Additionally, upgraded garage with flooring, stainless steel utility sink, and Gladiator wall cabinets, with both hanging and outside storage. Feel the comfort of living in this convenient, and great neighborhood with a park directly across the street for children to play. A must-see! Assumable VA loan at 2.625%.
)
[ListOfficeName] => Array
(
[0] => OahuRE.com
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 4191.00
)
[SqftTotal] => Array
(
[0] => 2185
)
[YearBuilt] => Array
(
[0] => 2005
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waikele
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waipahu
)
[HighSchool] => Array
(
[0] => Waipahu
)
[ListOfficeMLSID] => Array
(
[0] => GIVE
)
[ListAgentEmail] => Array
(
[0] => bryn@oahure.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 425-7887
)
[ListAgentFullName] => Array
(
[0] => Bryn W Kaufman
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-16T18:21:32.007
)
[Matrix_Unique_ID] => Array
(
[0] => 18407880
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26790243
)
[listing_image] => Array
(
[0] => 26790243
[1] => 26790244
[2] => 26790245
[3] => 26790246
[4] => 26790247
[5] => 26790248
[6] => 26790249
[7] => 26790250
[8] => 26790251
[9] => 26790252
[10] => 26790253
[11] => 26790254
[12] => 26790255
[13] => 26790256
[14] => 26790257
[15] => 26790258
[16] => 26790259
[17] => 26790260
[18] => 26790261
[19] => 26790262
[20] => 26790263
[21] => 26790264
[22] => 26790265
[23] => 26790266
[24] => 26790267
[25] => 26790268
)
[ListingContractDate] => Array
(
[0] => 2024-11-30
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 18:21:32.007
)
)
- BedsTotal: 4
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 4,191 sf
- Living (sf): 2,185
- Year Built: 2005
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Mountain
- Listing Office: OahuRE.com
- Land Tenure: FS - Fee Simple
- Elementary School: Waikele
- Middle School: Waipahu
- High School: Waipahu
