Listing
Overview
Price: $495,000
Area: WAIPIO GENTRY
Status: Active Under Contract
Your Home Search Stops Here! Rarely available, this first-floor, single-story corner-end unit offers two parking stalls and is located in the highly desirable Royal Palm at Waipio community. Bright and inviting, this home boasts new carpet and paint throughout and the benefit of no upstairs neighbors. The large private courtyard is a rare find—perfect for entertaining or unwinding, with peaceful views of the Waianae Mountain Range. Enjoy the spacious lanai, ideal for relaxing outdoors. The community is safe and welcoming, with an on-site property manager and security patrol, offering peace of mind. Conveniently located near military bases, Kanoelani Elementary, Costco, shops, and restaurants, with quick access to H1, H2, and Kam Hwy. Step inside to find natural light pouring in through large windows, creating an airy, open atmosphere. The unit features a full-size washer/dryer and ample storage. The community includes a pool, clubhouse, BBQ areas, and jogging paths. With water and sewer included in the maintenance fee, this move-in-ready gem offers excellent value. Act fast—this one won’t last long! Listing by: eXp Realty (808) 282-7703
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202427141"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "94-1428"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Kulewa"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Loop"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "36A"
}
["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/1039079298"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "495000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPIO GENTRY"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1122) "Your Home Search Stops Here! Rarely available, this first-floor, single-story corner-end unit offers two parking stalls and is located in the highly desirable Royal Palm at Waipio community. Bright and inviting, this home boasts new carpet and paint throughout and the benefit of no upstairs neighbors. The large private courtyard is a rare find—perfect for entertaining or unwinding, with peaceful views of the Waianae Mountain Range. Enjoy the spacious lanai, ideal for relaxing outdoors. The community is safe and welcoming, with an on-site property manager and security patrol, offering peace of mind. Conveniently located near military bases, Kanoelani Elementary, Costco, shops, and restaurants, with quick access to H1, H2, and Kam Hwy. Step inside to find natural light pouring in through large windows, creating an airy, open atmosphere. The unit features a full-size washer/dryer and ample storage. The community includes a pool, clubhouse, BBQ areas, and jogging paths. With water and sewer included in the maintenance fee, this move-in-ready gem offers excellent value. Act fast—this one won’t last long!"
}
["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(9) "185871.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "769"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1987"
}
["BuildingName"]=>
array(1) {
[0]=>
string(23) "Royal Palm at Waipio IV"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "868.11"
}
["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(33) "jasmin.davis.realestate@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 282-7703"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Jasmin Maria Davis"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-18T08:15:01.390"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18396912"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-13"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26806571"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26806571"
[1]=>
string(8) "26806572"
[2]=>
string(8) "26806573"
[3]=>
string(8) "26806574"
[4]=>
string(8) "26806575"
[5]=>
string(8) "26806576"
[6]=>
string(8) "26806577"
[7]=>
string(8) "26806578"
[8]=>
string(8) "26806579"
[9]=>
string(8) "26806580"
[10]=>
string(8) "26806581"
[11]=>
string(8) "26806582"
[12]=>
string(8) "26806583"
[13]=>
string(8) "26806584"
[14]=>
string(8) "26806585"
[15]=>
string(8) "26806586"
[16]=>
string(8) "26806587"
[17]=>
string(8) "26806588"
[18]=>
string(8) "26806589"
[19]=>
string(8) "26806590"
[20]=>
string(8) "26806591"
[21]=>
string(8) "26806592"
[22]=>
string(8) "26806593"
[23]=>
string(8) "26806594"
[24]=>
string(8) "26806595"
[25]=>
string(8) "26806596"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202427141
)
[StreetNumber] => Array
(
[0] => 94-1428
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Kulewa
)
[StreetSuffix] => Array
(
[0] => Loop
)
[UnitNumber] => Array
(
[0] => 36A
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1039079298
)
[ListPrice] => Array
(
[0] => 495000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => WAIPIO GENTRY
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Your Home Search Stops Here! Rarely available, this first-floor, single-story corner-end unit offers two parking stalls and is located in the highly desirable Royal Palm at Waipio community. Bright and inviting, this home boasts new carpet and paint throughout and the benefit of no upstairs neighbors. The large private courtyard is a rare find—perfect for entertaining or unwinding, with peaceful views of the Waianae Mountain Range. Enjoy the spacious lanai, ideal for relaxing outdoors. The community is safe and welcoming, with an on-site property manager and security patrol, offering peace of mind. Conveniently located near military bases, Kanoelani Elementary, Costco, shops, and restaurants, with quick access to H1, H2, and Kam Hwy. Step inside to find natural light pouring in through large windows, creating an airy, open atmosphere. The unit features a full-size washer/dryer and ample storage. The community includes a pool, clubhouse, BBQ areas, and jogging paths. With water and sewer included in the maintenance fee, this move-in-ready gem offers excellent value. Act fast—this one won’t last long!
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 185871.00
)
[SqftTotal] => Array
(
[0] => 769
)
[YearBuilt] => Array
(
[0] => 1987
)
[BuildingName] => Array
(
[0] => Royal Palm at Waipio IV
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 868.11
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => jasmin.davis.realestate@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 282-7703
)
[ListAgentFullName] => Array
(
[0] => Jasmin Maria Davis
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-18T08:15:01.390
)
[Matrix_Unique_ID] => Array
(
[0] => 18396912
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[ListingContractDate] => Array
(
[0] => 2024-12-13
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26806571
)
[listing_image] => Array
(
[0] => 26806571
[1] => 26806572
[2] => 26806573
[3] => 26806574
[4] => 26806575
[5] => 26806576
[6] => 26806577
[7] => 26806578
[8] => 26806579
[9] => 26806580
[10] => 26806581
[11] => 26806582
[12] => 26806583
[13] => 26806584
[14] => 26806585
[15] => 26806586
[16] => 26806587
[17] => 26806588
[18] => 26806589
[19] => 26806590
[20] => 26806591
[21] => 26806592
[22] => 26806593
[23] => 26806594
[24] => 26806595
[25] => 26806596
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 185,871 sf
- Living (sf): 769
- Year Built: 1987
- Building Name: Royal Palm at Waipio IV
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Mountain
- Listing Office: eXp Realty
- Maintenance Fees: $868
- Land Tenure: FS - Fee Simple
