Listing
Overview
Price: $307,500
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
Experience the inviting charm of the tranquil valley lifestyle in Mililani, where convenience meets comfort just moments from the freeway and nearby shopping. Come home to this freshly cleaned and beautifully painted corner unit, now featuring brand new appliances to enhance your living experience. Enjoy the cozy patio with roll-up gates that offer you the privacy you desire, all while showcasing lovely garden views. You’ll appreciate the ease of a covered parking stall and ample guest parking for your entertaining needs. With the added convenience of an in-unit washer and dryer and a spacious bedroom, this home is truly a perfect haven for relaxed, convenient living. Listing by: Engel & Volkers Honolulu (808) 479-2031
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202501828"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "95-2031"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Waikalani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "D404"
}
["City"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96789"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(41) "https://player.vimeo.com/video/1046989909"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "307500.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(678) "Experience the inviting charm of the tranquil valley lifestyle in Mililani, where convenience meets comfort just moments from the freeway and nearby shopping. Come home to this freshly cleaned and beautifully painted corner unit, now featuring brand new appliances to enhance your living experience. Enjoy the cozy patio with roll-up gates that offer you the privacy you desire, all while showcasing lovely garden views. You’ll appreciate the ease of a covered parking stall and ample guest parking for your entertaining needs. With the added convenience of an in-unit washer and dryer and a spacious bedroom, this home is truly a perfect haven for relaxed, convenient living."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Engel & Volkers Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "607"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "Northbrook-Melemanu"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "773.62"
}
["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) "PPRO"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(34) "Kendelle.Yamamoto@evrealestate.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 479-2031"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(23) "Kendelle Yamamoto-Moran"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18487961"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-02T17:00:01.510"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-14"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.510"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26839296"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "26839296"
[1]=>
string(8) "26839297"
[2]=>
string(8) "26839298"
[3]=>
string(8) "26839299"
[4]=>
string(8) "26839300"
[5]=>
string(8) "26839301"
[6]=>
string(8) "26839302"
[7]=>
string(8) "26839303"
[8]=>
string(8) "26839304"
[9]=>
string(8) "26839305"
[10]=>
string(8) "26839306"
[11]=>
string(8) "26839307"
[12]=>
string(8) "26839308"
[13]=>
string(8) "26839309"
[14]=>
string(8) "26839310"
[15]=>
string(8) "26839311"
[16]=>
string(8) "26839312"
[17]=>
string(8) "26839313"
[18]=>
string(8) "26839314"
[19]=>
string(8) "26839315"
[20]=>
string(8) "26839316"
[21]=>
string(8) "26839317"
[22]=>
string(8) "26839318"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202501828
)
[StreetNumber] => Array
(
[0] => 95-2031
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => D404
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1046989909
)
[ListPrice] => Array
(
[0] => 307500.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Experience the inviting charm of the tranquil valley lifestyle in Mililani, where convenience meets comfort just moments from the freeway and nearby shopping. Come home to this freshly cleaned and beautifully painted corner unit, now featuring brand new appliances to enhance your living experience. Enjoy the cozy patio with roll-up gates that offer you the privacy you desire, all while showcasing lovely garden views. You’ll appreciate the ease of a covered parking stall and ample guest parking for your entertaining needs. With the added convenience of an in-unit washer and dryer and a spacious bedroom, this home is truly a perfect haven for relaxed, convenient living.
)
[ListOfficeName] => Array
(
[0] => Engel & Volkers Honolulu
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 607
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Northbrook-Melemanu
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] => 773.62
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => PPRO
)
[ListAgentEmail] => Array
(
[0] => Kendelle.Yamamoto@evrealestate.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 479-2031
)
[ListAgentFullName] => Array
(
[0] => Kendelle Yamamoto-Moran
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18487961
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-02T17:00:01.510
)
[ListingContractDate] => Array
(
[0] => 2025-01-14
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.510
)
[_thumbnail_id] => Array
(
[0] => 26839296
)
[listing_image] => Array
(
[0] => 26839296
[1] => 26839297
[2] => 26839298
[3] => 26839299
[4] => 26839300
[5] => 26839301
[6] => 26839302
[7] => 26839303
[8] => 26839304
[9] => 26839305
[10] => 26839306
[11] => 26839307
[12] => 26839308
[13] => 26839309
[14] => 26839310
[15] => 26839311
[16] => 26839312
[17] => 26839313
[18] => 26839314
[19] => 26839315
[20] => 26839316
[21] => 26839317
[22] => 26839318
)
)
- BedsTotal: 1
- Full Baths: 1
- Living (sf): 607
- Year Built: 1973
- Building Name: Northbrook-Melemanu
- Property Condition: Average
- Number of Parking Spaces: 1
- View: Garden
- Listing Office: Engel & Volkers Honolulu
- Maintenance Fees: $774
- Land Tenure: FS - Fee Simple
