Listing
Overview
Price: $450,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
WELL PRICED CORNER UNIT. This spacious 3-bedroom, 2-bathroom single-level unit offers 1,030 square feet of spacious living space + 2 covered parking stalls in Ridgecrest-Melemanu. Step inside to find freshly updated luxury vinyl plank floors + other modern updates, creating a bright and welcoming atmosphere. The corner unit location ensures added privacy and tranquility with the living area seamlessly connecting to the outdoor lanai, where you can enjoy pleasant views and fresh breezes. You'll appreciate the convenience of having two covered parking stalls, including a desirable corner stall closest to the building. The pet-friendly community offers a range of amenities, including a refreshing pool and a rec room for gatherings and relaxation. In-unit laundry with a washer and dryer adds to the ease of living, while low maintenance fees make this a very attractive building. Conveniently located near Schofield Barracks, golf courses, shopping centers + freeway access. Listing by: Compass (808) 386-4487
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424268"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "95-2056"
}
["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) "A201"
}
["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(98) "https://player.vimeo.com/video/1022218685?badge=0&autopause=0&player_id=0&app_id=58479"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "450000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "450000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(981) "WELL PRICED CORNER UNIT. This spacious 3-bedroom, 2-bathroom single-level unit offers 1,030 square feet of spacious living space + 2 covered parking stalls in Ridgecrest-Melemanu. Step inside to find freshly updated luxury vinyl plank floors + other modern updates, creating a bright and welcoming atmosphere. The corner unit location ensures added privacy and tranquility with the living area seamlessly connecting to the outdoor lanai, where you can enjoy pleasant views and fresh breezes. You'll appreciate the convenience of having two covered parking stalls, including a desirable corner stall closest to the building. The pet-friendly community offers a range of amenities, including a refreshing pool and a rec room for gatherings and relaxation. In-unit laundry with a washer and dryer adds to the ease of living, while low maintenance fees make this a very attractive building. Conveniently located near Schofield Barracks, golf courses, shopping centers + freeway access."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1127"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "Ridgecrest-Melemanu"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "4-7"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "535.45"
}
["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) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "sean@yanogroup.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 386-4487"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Sean S Yano"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-27T17:00:01.670"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18335019"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-22T07:48:36.923"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26740743"
}
["listing_image"]=>
array(17) {
[0]=>
string(8) "26740743"
[1]=>
string(8) "26740744"
[2]=>
string(8) "26740745"
[3]=>
string(8) "26740746"
[4]=>
string(8) "26740747"
[5]=>
string(8) "26740748"
[6]=>
string(8) "26740749"
[7]=>
string(8) "26740750"
[8]=>
string(8) "26740751"
[9]=>
string(8) "26740752"
[10]=>
string(8) "26740753"
[11]=>
string(8) "26740754"
[12]=>
string(8) "26740755"
[13]=>
string(8) "26740756"
[14]=>
string(8) "26740757"
[15]=>
string(8) "26740758"
[16]=>
string(8) "26741039"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424268
)
[StreetNumber] => Array
(
[0] => 95-2056
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => A201
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1022218685?badge=0&autopause=0&player_id=0&app_id=58479
)
[ListPrice] => Array
(
[0] => 450000.00
)
[CurrentPrice] => Array
(
[0] => 450000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => WELL PRICED CORNER UNIT. This spacious 3-bedroom, 2-bathroom single-level unit offers 1,030 square feet of spacious living space + 2 covered parking stalls in Ridgecrest-Melemanu. Step inside to find freshly updated luxury vinyl plank floors + other modern updates, creating a bright and welcoming atmosphere. The corner unit location ensures added privacy and tranquility with the living area seamlessly connecting to the outdoor lanai, where you can enjoy pleasant views and fresh breezes. You'll appreciate the convenience of having two covered parking stalls, including a desirable corner stall closest to the building. The pet-friendly community offers a range of amenities, including a refreshing pool and a rec room for gatherings and relaxation. In-unit laundry with a washer and dryer adds to the ease of living, while low maintenance fees make this a very attractive building. Conveniently located near Schofield Barracks, golf courses, shopping centers + freeway access.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1127
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Ridgecrest-Melemanu
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 4-7
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 535.45
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => sean@yanogroup.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 386-4487
)
[ListAgentFullName] => Array
(
[0] => Sean S Yano
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-27T17:00:01.670
)
[Matrix_Unique_ID] => Array
(
[0] => 18335019
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-22T07:48:36.923
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26740743
)
[listing_image] => Array
(
[0] => 26740743
[1] => 26740744
[2] => 26740745
[3] => 26740746
[4] => 26740747
[5] => 26740748
[6] => 26740749
[7] => 26740750
[8] => 26740751
[9] => 26740752
[10] => 26740753
[11] => 26740754
[12] => 26740755
[13] => 26740756
[14] => 26740757
[15] => 26740758
[16] => 26741039
)
)
- BedsTotal: 3
- Full Baths: 2
- Living (sf): 1,127
- Year Built: 1973
- Building Name: Ridgecrest-Melemanu
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: None
- Listing Office: Compass
- Maintenance Fees: $535
- Land Tenure: FS - Fee Simple
