Listing
Overview
Price: $480,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
Introducing the condo you've been waiting for at Northbrook-Melemanu Woodlands, nestled in the sought-after Mililani community. This fully renovated, high-floor corner unit offers enhanced privacy and breathtaking mountain views from your private balcony, complete with refreshing breezes and beautiful scenery.
Step into a brand-new kitchen featuring elegant shaker-style wood cabinets, gleaming quartz countertops, and modern appliances. Enjoy the stylish laminate plank flooring and a beautifully tiled shower surround, along with a contemporary vanity and updated plumbing fixtures—all complemented by fresh interior paint. ideally located just minutes from Kam Highway, shopping centers, parks, Wheeler Air Force Base, and Schofield Barracks. Don’t miss this opportunity. Listing by: Keller Williams Honolulu (808) 888-9532
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428329"
}
["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) "D906"
}
["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(85) "https://media.akphawaii.com/order/5b1bcb07-384e-4e2e-8e2c-08dd19ca0adc?branding=false"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "480000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(784) "Introducing the condo you've been waiting for at Northbrook-Melemanu Woodlands, nestled in the sought-after Mililani community. This fully renovated, high-floor corner unit offers enhanced privacy and breathtaking mountain views from your private balcony, complete with refreshing breezes and beautiful scenery.
Step into a brand-new kitchen featuring elegant shaker-style wood cabinets, gleaming quartz countertops, and modern appliances. Enjoy the stylish laminate plank flooring and a beautifully tiled shower surround, along with a contemporary vanity and updated plumbing fixtures—all complemented by fresh interior paint. ideally located just minutes from Kam Highway, shopping centers, parks, Wheeler Air Force Base, and Schofield Barracks. Don’t miss this opportunity."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["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) "993"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "Northbrook-Melemanu"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(4) "8-14"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "520.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(6) "KWPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "maria@arrietarealestate.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 888-9532"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Maria Elisa Arrieta"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-22T17:00:02.410"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18440056"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-15"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26808589"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26808589"
[1]=>
string(8) "26808590"
[2]=>
string(8) "26808591"
[3]=>
string(8) "26808592"
[4]=>
string(8) "26808593"
[5]=>
string(8) "26808594"
[6]=>
string(8) "26808595"
[7]=>
string(8) "26808596"
[8]=>
string(8) "26808597"
[9]=>
string(8) "26808598"
[10]=>
string(8) "26808599"
[11]=>
string(8) "26808600"
[12]=>
string(8) "26808601"
[13]=>
string(8) "26808602"
[14]=>
string(8) "26808603"
[15]=>
string(8) "26808604"
[16]=>
string(8) "26808605"
[17]=>
string(8) "26808606"
[18]=>
string(8) "26808607"
[19]=>
string(8) "26808608"
[20]=>
string(8) "26808609"
[21]=>
string(8) "26808610"
[22]=>
string(8) "26808611"
[23]=>
string(8) "26808612"
[24]=>
string(8) "26808613"
[25]=>
string(8) "26808614"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428329
)
[StreetNumber] => Array
(
[0] => 95-2031
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => D906
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://media.akphawaii.com/order/5b1bcb07-384e-4e2e-8e2c-08dd19ca0adc?branding=false
)
[ListPrice] => Array
(
[0] => 480000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Introducing the condo you've been waiting for at Northbrook-Melemanu Woodlands, nestled in the sought-after Mililani community. This fully renovated, high-floor corner unit offers enhanced privacy and breathtaking mountain views from your private balcony, complete with refreshing breezes and beautiful scenery.
Step into a brand-new kitchen featuring elegant shaker-style wood cabinets, gleaming quartz countertops, and modern appliances. Enjoy the stylish laminate plank flooring and a beautifully tiled shower surround, along with a contemporary vanity and updated plumbing fixtures—all complemented by fresh interior paint. ideally located just minutes from Kam Highway, shopping centers, parks, Wheeler Air Force Base, and Schofield Barracks. Don’t miss this opportunity.
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 170145.00
)
[SqftTotal] => Array
(
[0] => 993
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Northbrook-Melemanu
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 8-14
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 520.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KWPP02
)
[ListAgentEmail] => Array
(
[0] => maria@arrietarealestate.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 888-9532
)
[ListAgentFullName] => Array
(
[0] => Maria Elisa Arrieta
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-22T17:00:02.410
)
[Matrix_Unique_ID] => Array
(
[0] => 18440056
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[ListingContractDate] => Array
(
[0] => 2024-12-15
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26808589
)
[listing_image] => Array
(
[0] => 26808589
[1] => 26808590
[2] => 26808591
[3] => 26808592
[4] => 26808593
[5] => 26808594
[6] => 26808595
[7] => 26808596
[8] => 26808597
[9] => 26808598
[10] => 26808599
[11] => 26808600
[12] => 26808601
[13] => 26808602
[14] => 26808603
[15] => 26808604
[16] => 26808605
[17] => 26808606
[18] => 26808607
[19] => 26808608
[20] => 26808609
[21] => 26808610
[22] => 26808611
[23] => 26808612
[24] => 26808613
[25] => 26808614
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 170,145 sf
- Living (sf): 993
- Year Built: 1973
- Building Name: Northbrook-Melemanu
- Property Condition: Above Average
- Number of Parking Spaces: 1
- View: Mountain
- Listing Office: Keller Williams Honolulu
- Maintenance Fees: $520
- Land Tenure: FS - Fee Simple
