Listing
Overview
Price: $480,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
*OPEN HOUSE SUNDAY 2/15/26, 2:00-5:00 P.M.* NEW WOW PRICE! NORTHBROOK MELEMANU WOODLANDS, 3 PARKING STALLS! LARGE 1,224 sq. ft. total, 3/2/3 RARE THREE parking stalls - 1 Open and 2 Covered Tandem! Great value for 3/2 and 3 parking, in peaceful Mililani setting. Amenities such as Pool and an open park with Kid-friendly Playground, just a 3-5 minute walk around the corner. Beautiful views of nature and green Treetops, no Unit above! Uniquely designed condo of solid concrete, all low-rise and with lots of open landscaped spaces. Everyday feels like walking through a tropical atrium and into your 1,030 interior square feet and 97 square foot open Lanai. ALOT of cool breezes and natural light flows through the Unit, creating a very comfortable experience. Hard to find anything 3/2 and 3 parking anywhere for this price point! Presents unique "once-in-lifetime" chance for Buyer to enter market at unbelievable price, get involved with the AOAO/Board, and help improve/make positive changes to increase property value(s). Seller willing to give financial Credit(s) to both VA and non-VA Buyers to pay for Loan & Escrow fees. Vacant and Very Easy to See, but by Appointment only. MAHALO! Listing by: Rainbow Realty International (808) 330-0301
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202524789"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "95-2027"
}
["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) "A403"
}
["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(82) "https://drive.google.com/file/d/1_9aK3TxbSN1CNJKyjeGwg0BUuNUQPvHP/view?usp=sharing"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "480000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "*OPEN HOUSE SUNDAY 2/15/26, 2:00-5:00 P.M.* NEW WOW PRICE! NORTHBROOK MELEMANU WOODLANDS, 3 PARKING STALLS! LARGE 1,224 sq. ft. total, 3/2/3 RARE THREE parking stalls - 1 Open and 2 Covered Tandem! Great value for 3/2 and 3 parking, in peaceful Mililani setting. Amenities such as Pool and an open park with Kid-friendly Playground, just a 3-5 minute walk around the corner. Beautiful views of nature and green Treetops, no Unit above! Uniquely designed condo of solid concrete, all low-rise and with lots of open landscaped spaces. Everyday feels like walking through a tropical atrium and into your 1,030 interior square feet and 97 square foot open Lanai. ALOT of cool breezes and natural light flows through the Unit, creating a very comfortable experience. Hard to find anything 3/2 and 3 parking anywhere for this price point! Presents unique "once-in-lifetime" chance for Buyer to enter market at unbelievable price, get involved with the AOAO/Board, and help improve/make positive changes to increase property value(s). Seller willing to give financial Credit(s) to both VA and non-VA Buyers to pay for Loan & Escrow fees. Vacant and Very Easy to See, but by Appointment only. MAHALO!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(28) "Rainbow Realty International"
}
["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(9) "170145.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1127"
}
["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) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(12) "Garden,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1312.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) "LOVE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(17) "rmberris@live.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 330-0301"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(21) "Robert Michael Berris"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19079664"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-02-15T17:00:02.033"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-21"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:02.033"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27228058"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "27228058"
[1]=>
string(8) "27228059"
[2]=>
string(8) "27228060"
[3]=>
string(8) "27228061"
[4]=>
string(8) "27228062"
[5]=>
string(8) "27228063"
[6]=>
string(8) "27228064"
[7]=>
string(8) "27228065"
[8]=>
string(8) "27228066"
[9]=>
string(8) "27228067"
[10]=>
string(8) "27228068"
[11]=>
string(8) "27228069"
[12]=>
string(8) "27228070"
[13]=>
string(8) "27228071"
[14]=>
string(8) "27228072"
[15]=>
string(8) "27228073"
[16]=>
string(8) "27228074"
[17]=>
string(8) "27228075"
[18]=>
string(8) "27228076"
[19]=>
string(8) "27275163"
[20]=>
string(8) "27275164"
[21]=>
string(8) "27275165"
[22]=>
string(8) "27275166"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202524789
)
[StreetNumber] => Array
(
[0] => 95-2027
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => A403
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://drive.google.com/file/d/1_9aK3TxbSN1CNJKyjeGwg0BUuNUQPvHP/view?usp=sharing
)
[ListPrice] => Array
(
[0] => 480000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => *OPEN HOUSE SUNDAY 2/15/26, 2:00-5:00 P.M.* NEW WOW PRICE! NORTHBROOK MELEMANU WOODLANDS, 3 PARKING STALLS! LARGE 1,224 sq. ft. total, 3/2/3 RARE THREE parking stalls - 1 Open and 2 Covered Tandem! Great value for 3/2 and 3 parking, in peaceful Mililani setting. Amenities such as Pool and an open park with Kid-friendly Playground, just a 3-5 minute walk around the corner. Beautiful views of nature and green Treetops, no Unit above! Uniquely designed condo of solid concrete, all low-rise and with lots of open landscaped spaces. Everyday feels like walking through a tropical atrium and into your 1,030 interior square feet and 97 square foot open Lanai. ALOT of cool breezes and natural light flows through the Unit, creating a very comfortable experience. Hard to find anything 3/2 and 3 parking anywhere for this price point! Presents unique "once-in-lifetime" chance for Buyer to enter market at unbelievable price, get involved with the AOAO/Board, and help improve/make positive changes to increase property value(s). Seller willing to give financial Credit(s) to both VA and non-VA Buyers to pay for Loan & Escrow fees. Vacant and Very Easy to See, but by Appointment only. MAHALO!
)
[ListOfficeName] => Array
(
[0] => Rainbow Realty International
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 170145.00
)
[SqftTotal] => Array
(
[0] => 1127
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Northbrook-Melemanu
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,Other
)
[MaintenanceExpense] => Array
(
[0] => 1312.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => LOVE
)
[ListAgentEmail] => Array
(
[0] => rmberris@live.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 330-0301
)
[ListAgentFullName] => Array
(
[0] => Robert Michael Berris
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19079664
)
[MatrixModifiedDT] => Array
(
[0] => 2026-02-15T17:00:02.033
)
[ListingContractDate] => Array
(
[0] => 2025-11-21
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:02.033
)
[_thumbnail_id] => Array
(
[0] => 27228058
)
[listing_image] => Array
(
[0] => 27228058
[1] => 27228059
[2] => 27228060
[3] => 27228061
[4] => 27228062
[5] => 27228063
[6] => 27228064
[7] => 27228065
[8] => 27228066
[9] => 27228067
[10] => 27228068
[11] => 27228069
[12] => 27228070
[13] => 27228071
[14] => 27228072
[15] => 27228073
[16] => 27228074
[17] => 27228075
[18] => 27228076
[19] => 27275163
[20] => 27275164
[21] => 27275165
[22] => 27275166
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 170,145 sf
- Living (sf): 1,127
- Year Built: 1973
- Building Name: Northbrook-Melemanu
- Property Condition: Average
- Number of Parking Spaces: 3
- View: Garden,Other
- Listing Office: Rainbow Realty International
- Maintenance Fees: $1,312
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on February 15, 2026 - 5:00 PM
Information is deemed reliable but not guaranteed.
Copyright: 2026 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
© Marcus Realty. All Rights Reserved.
