Listing
Overview
Price: $499,000
Area: WAIPIO GENTRY
Status: Active Under Contract
Welcome Home! Step into this breathtaking property, where every detail has been thoughtfully upgraded to create a space that’s as stylish as it is inviting. From the moment you walk through the door, you'll be captivated by the fresh, vibrant paint that breathes new life into every room. Feel the cool breeze of the brand-new ceiling fans as they spin above you, and admire the sleek, modern lighting in the kitchen, perfectly highlighting the stunning new stainless steel appliances, including a state-of-the-art range/oven that is ready to elevate your culinary adventures. The bathroom is a true retreat, showcasing a chic, upgraded design. Picture yourself unwinding in the freshly reglazed tub, surrounded by the glow of the sophisticated new vanity light and enjoying the elegance of the new bathroom faucet. This is more than just a home; it’s an incredible opportunity you won’t want to let slip by! With all these fresh upgrades and designer touches, this gem is sure to be snapped up quickly. Get ready to make this home yours and experience a lifestyle upgrade! Listing by: eXp Realty (808) 349-6499
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202418008"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "94-1398"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Polani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "28S"
}
["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(67) "https://tour.giraffe360.com/9cd96c366f0f4e8c8bf3e04400fe88cb/?lsf=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "499000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "499000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPIO GENTRY"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1079) "Welcome Home! Step into this breathtaking property, where every detail has been thoughtfully upgraded to create a space that’s as stylish as it is inviting. From the moment you walk through the door, you'll be captivated by the fresh, vibrant paint that breathes new life into every room. Feel the cool breeze of the brand-new ceiling fans as they spin above you, and admire the sleek, modern lighting in the kitchen, perfectly highlighting the stunning new stainless steel appliances, including a state-of-the-art range/oven that is ready to elevate your culinary adventures. The bathroom is a true retreat, showcasing a chic, upgraded design. Picture yourself unwinding in the freshly reglazed tub, surrounded by the glow of the sophisticated new vanity light and enjoying the elegance of the new bathroom faucet. This is more than just a home; it’s an incredible opportunity you won’t want to let slip by! With all these fresh upgrades and designer touches, this gem is sure to be snapped up quickly. Get ready to make this home yours and experience a lifestyle upgrade!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "708"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1987"
}
["BuildingName"]=>
array(1) {
[0]=>
string(22) "Royal Palm at Waipio 3"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(15) "Mountain,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "566.81"
}
["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) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "justin@teamtaparra.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 349-6499"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Justin K Taparra"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-28T21:33:29.493"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18194291"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-21T21:27:43.530"
}
["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) "26668100"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26668100"
[1]=>
string(8) "26668101"
[2]=>
string(8) "26668102"
[3]=>
string(8) "26668103"
[4]=>
string(8) "26668104"
[5]=>
string(8) "26668105"
[6]=>
string(8) "26668106"
[7]=>
string(8) "26668107"
[8]=>
string(8) "26668108"
[9]=>
string(8) "26668109"
[10]=>
string(8) "26668110"
[11]=>
string(8) "26668111"
[12]=>
string(8) "26668112"
[13]=>
string(8) "26668113"
[14]=>
string(8) "26668114"
[15]=>
string(8) "26668115"
[16]=>
string(8) "26668116"
[17]=>
string(8) "26668117"
[18]=>
string(8) "26668118"
[19]=>
string(8) "26668119"
[20]=>
string(8) "26668120"
[21]=>
string(8) "26668121"
[22]=>
string(8) "26668122"
[23]=>
string(8) "26668123"
[24]=>
string(8) "26668494"
[25]=>
string(8) "26668495"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202418008
)
[StreetNumber] => Array
(
[0] => 94-1398
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Polani
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 28S
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://tour.giraffe360.com/9cd96c366f0f4e8c8bf3e04400fe88cb/?lsf=1
)
[ListPrice] => Array
(
[0] => 499000.00
)
[CurrentPrice] => Array
(
[0] => 499000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO GENTRY
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Welcome Home! Step into this breathtaking property, where every detail has been thoughtfully upgraded to create a space that’s as stylish as it is inviting. From the moment you walk through the door, you'll be captivated by the fresh, vibrant paint that breathes new life into every room. Feel the cool breeze of the brand-new ceiling fans as they spin above you, and admire the sleek, modern lighting in the kitchen, perfectly highlighting the stunning new stainless steel appliances, including a state-of-the-art range/oven that is ready to elevate your culinary adventures. The bathroom is a true retreat, showcasing a chic, upgraded design. Picture yourself unwinding in the freshly reglazed tub, surrounded by the glow of the sophisticated new vanity light and enjoying the elegance of the new bathroom faucet. This is more than just a home; it’s an incredible opportunity you won’t want to let slip by! With all these fresh upgrades and designer touches, this gem is sure to be snapped up quickly. Get ready to make this home yours and experience a lifestyle upgrade!
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 708
)
[YearBuilt] => Array
(
[0] => 1987
)
[BuildingName] => Array
(
[0] => Royal Palm at Waipio 3
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 566.81
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => justin@teamtaparra.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 349-6499
)
[ListAgentFullName] => Array
(
[0] => Justin K Taparra
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-28T21:33:29.493
)
[Matrix_Unique_ID] => Array
(
[0] => 18194291
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-21T21:27:43.530
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26668100
)
[listing_image] => Array
(
[0] => 26668100
[1] => 26668101
[2] => 26668102
[3] => 26668103
[4] => 26668104
[5] => 26668105
[6] => 26668106
[7] => 26668107
[8] => 26668108
[9] => 26668109
[10] => 26668110
[11] => 26668111
[12] => 26668112
[13] => 26668113
[14] => 26668114
[15] => 26668115
[16] => 26668116
[17] => 26668117
[18] => 26668118
[19] => 26668119
[20] => 26668120
[21] => 26668121
[22] => 26668122
[23] => 26668123
[24] => 26668494
[25] => 26668495
)
)
- BedsTotal: 2
- Full Baths: 1
- Living (sf): 708
- Year Built: 1987
- Building Name: Royal Palm at Waipio 3
- Property Condition: Average
- Number of Parking Spaces: 2
- View: Mountain,Sunset
- Listing Office: eXp Realty
- Maintenance Fees: $567
- Land Tenure: FS - Fee Simple
