Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
95-2035 Waikalani Place Unit B306 Mililani, HI 96789
Listing Overview
Price: $449,000 Area: WAIPIO ACRES/WAIKALANI WOODLANDS Status: Active
Nestled in the heart of Waipio Acres, your new home awaits in the tranquil hideaway, Northbrook Melemanu Woodlands! This 2 bedroom, 1 bathroom was carefully upgraded in 2024 and features luxury vinyl plank flooring, stainless steel kitchen appliances, and a full-size, in-unit washer and dryer! Relax on your sofa with unobstructed views of the nearby garden, or take your 'Me Time' outside to your covered lanai, basking in the warm Oahu sunshine. Both bedrooms feature ample storage space, and the extra counter space in the bathroom is perfect for making cohabitating a breeze. Located just a few minutes away from Mililani Golf Club, Mililani Shopping Center, Melemanu Neighborhood Park, and Wheeler Army Airfield, this is truly a hidden gem! Must see to fully appreciate all this unit has to offer. Listing by: Vesta Hawaii Real Estate (808) 561-8200
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423838"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "95-2035"
}
["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) "B306"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "449000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "449000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(803) "Nestled in the heart of Waipio Acres, your new home awaits in the tranquil hideaway, Northbrook Melemanu Woodlands! This 2 bedroom, 1 bathroom was carefully upgraded in 2024 and features luxury vinyl plank flooring, stainless steel kitchen appliances, and a full-size, in-unit washer and dryer! Relax on your sofa with unobstructed views of the nearby garden, or take your 'Me Time' outside to your covered lanai, basking in the warm Oahu sunshine. Both bedrooms feature ample storage space, and the extra counter space in the bathroom is perfect for making cohabitating a breeze. Located just a few minutes away from Mililani Golf Club, Mililani Shopping Center, Melemanu Neighborhood Park, and Wheeler Army Airfield, this is truly a hidden gem! Must see to fully appreciate all this unit has to offer."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Vesta Hawaii Real Estate"
}
["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) "170145.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "896"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "Northbrook-Melemanu"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(9) "15-20,21+"
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "782.00"
}
["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) "VEST"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "courtney@vestahawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 561-8200"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Courtney J Takai"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-24T07:27:40.877"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18322306"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-14T12:28:13.027"
}
["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) "26730423"
}
["listing_image"]=>
array(22) {
[0]=>
string(8) "26730423"
[1]=>
string(8) "26730424"
[2]=>
string(8) "26730425"
[3]=>
string(8) "26730426"
[4]=>
string(8) "26730427"
[5]=>
string(8) "26730428"
[6]=>
string(8) "26730429"
[7]=>
string(8) "26730430"
[8]=>
string(8) "26730431"
[9]=>
string(8) "26730432"
[10]=>
string(8) "26730433"
[11]=>
string(8) "26730434"
[12]=>
string(8) "26730435"
[13]=>
string(8) "26730436"
[14]=>
string(8) "26730437"
[15]=>
string(8) "26730438"
[16]=>
string(8) "26730439"
[17]=>
string(8) "26730440"
[18]=>
string(8) "26730441"
[19]=>
string(8) "26730442"
[20]=>
string(8) "26730443"
[21]=>
string(8) "26730444"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423838
)
[StreetNumber] => Array
(
[0] => 95-2035
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => B306
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 449000.00
)
[CurrentPrice] => Array
(
[0] => 449000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Nestled in the heart of Waipio Acres, your new home awaits in the tranquil hideaway, Northbrook Melemanu Woodlands! This 2 bedroom, 1 bathroom was carefully upgraded in 2024 and features luxury vinyl plank flooring, stainless steel kitchen appliances, and a full-size, in-unit washer and dryer! Relax on your sofa with unobstructed views of the nearby garden, or take your 'Me Time' outside to your covered lanai, basking in the warm Oahu sunshine. Both bedrooms feature ample storage space, and the extra counter space in the bathroom is perfect for making cohabitating a breeze. Located just a few minutes away from Mililani Golf Club, Mililani Shopping Center, Melemanu Neighborhood Park, and Wheeler Army Airfield, this is truly a hidden gem! Must see to fully appreciate all this unit has to offer.
)
[ListOfficeName] => Array
(
[0] => Vesta Hawaii Real Estate
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 170145.00
)
[SqftTotal] => Array
(
[0] => 896
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Northbrook-Melemanu
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 15-20,21+
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] => 782.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => VEST
)
[ListAgentEmail] => Array
(
[0] => courtney@vestahawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 561-8200
)
[ListAgentFullName] => Array
(
[0] => Courtney J Takai
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-24T07:27:40.877
)
[Matrix_Unique_ID] => Array
(
[0] => 18322306
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-14T12:28:13.027
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26730423
)
[listing_image] => Array
(
[0] => 26730423
[1] => 26730424
[2] => 26730425
[3] => 26730426
[4] => 26730427
[5] => 26730428
[6] => 26730429
[7] => 26730430
[8] => 26730431
[9] => 26730432
[10] => 26730433
[11] => 26730434
[12] => 26730435
[13] => 26730436
[14] => 26730437
[15] => 26730438
[16] => 26730439
[17] => 26730440
[18] => 26730441
[19] => 26730442
[20] => 26730443
[21] => 26730444
)
)