Listing
Overview
Price: $449,999
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
Discover this beautiful, newly upgraded two-bedroom, one-bathroom top-floor unit in Mililani, offering a quiet oasis with lush green views. Enjoy the privacy of an end unit with no neighbors above and the convenience of two assigned parking stalls located right outside the unit, eliminating any stairs to enter. Step inside to find new flooring, fresh paint, a stylishly upgraded bathroom, and a recently upgraded kitchen featuring a brand-new appliances. The lanai overlooks gorgeous greenery, tall trees, and expansive open spaces, creating a peaceful retreat in a highly desirable community. Located near Schofield Barracks and Wheeler Army Airfield, this home is move-in ready for anyone seeking tranquility with easy access to amenities. Enjoy the pool, playground, pickleball court, and basketball courts, all within the community. Don’t miss this opportunity to own a beautiful, move-in-ready home in a quiet and serene setting. Listing by: eXp Realty (808) 861-9643
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202515665"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "95-2039"
}
["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) "C403"
}
["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(50) "https://hommati.tours/tour/2403052?play=no&mls=yes"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "449999.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(939) "Discover this beautiful, newly upgraded two-bedroom, one-bathroom top-floor unit in Mililani, offering a quiet oasis with lush green views. Enjoy the privacy of an end unit with no neighbors above and the convenience of two assigned parking stalls located right outside the unit, eliminating any stairs to enter. Step inside to find new flooring, fresh paint, a stylishly upgraded bathroom, and a recently upgraded kitchen featuring a brand-new appliances. The lanai overlooks gorgeous greenery, tall trees, and expansive open spaces, creating a peaceful retreat in a highly desirable community. Located near Schofield Barracks and Wheeler Army Airfield, this home is move-in ready for anyone seeking tranquility with easy access to amenities. Enjoy the pool, playground, pickleball court, and basketball courts, all within the community. Don’t miss this opportunity to own a beautiful, move-in-ready home in a quiet and serene setting."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["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(3) "4-7"
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1018.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) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "MaryMoralez718@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 861-9643"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Marilou G Moralez"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18853928"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-07-08T11:30:01.537"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-07-08"
}
["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) "11:30:01.537"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27060791"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "27060791"
[1]=>
string(8) "27060792"
[2]=>
string(8) "27060793"
[3]=>
string(8) "27060794"
[4]=>
string(8) "27060795"
[5]=>
string(8) "27060796"
[6]=>
string(8) "27060797"
[7]=>
string(8) "27060798"
[8]=>
string(8) "27060799"
[9]=>
string(8) "27060800"
[10]=>
string(8) "27060801"
[11]=>
string(8) "27060802"
[12]=>
string(8) "27060803"
[13]=>
string(8) "27060804"
[14]=>
string(8) "27060805"
[15]=>
string(8) "27060806"
[16]=>
string(8) "27060807"
[17]=>
string(8) "27060808"
[18]=>
string(8) "27060809"
[19]=>
string(8) "27060810"
[20]=>
string(8) "27060811"
[21]=>
string(8) "27060812"
[22]=>
string(8) "27060813"
[23]=>
string(8) "27060814"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202515665
)
[StreetNumber] => Array
(
[0] => 95-2039
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => C403
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://hommati.tours/tour/2403052?play=no&mls=yes
)
[ListPrice] => Array
(
[0] => 449999.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover this beautiful, newly upgraded two-bedroom, one-bathroom top-floor unit in Mililani, offering a quiet oasis with lush green views. Enjoy the privacy of an end unit with no neighbors above and the convenience of two assigned parking stalls located right outside the unit, eliminating any stairs to enter. Step inside to find new flooring, fresh paint, a stylishly upgraded bathroom, and a recently upgraded kitchen featuring a brand-new appliances. The lanai overlooks gorgeous greenery, tall trees, and expansive open spaces, creating a peaceful retreat in a highly desirable community. Located near Schofield Barracks and Wheeler Army Airfield, this home is move-in ready for anyone seeking tranquility with easy access to amenities. Enjoy the pool, playground, pickleball court, and basketball courts, all within the community. Don’t miss this opportunity to own a beautiful, move-in-ready home in a quiet and serene setting.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[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] => 4-7
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] => 1018.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => MaryMoralez718@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 861-9643
)
[ListAgentFullName] => Array
(
[0] => Marilou G Moralez
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18853928
)
[MatrixModifiedDT] => Array
(
[0] => 2025-07-08T11:30:01.537
)
[ListingContractDate] => Array
(
[0] => 2025-07-08
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:30:01.537
)
[_thumbnail_id] => Array
(
[0] => 27060791
)
[listing_image] => Array
(
[0] => 27060791
[1] => 27060792
[2] => 27060793
[3] => 27060794
[4] => 27060795
[5] => 27060796
[6] => 27060797
[7] => 27060798
[8] => 27060799
[9] => 27060800
[10] => 27060801
[11] => 27060802
[12] => 27060803
[13] => 27060804
[14] => 27060805
[15] => 27060806
[16] => 27060807
[17] => 27060808
[18] => 27060809
[19] => 27060810
[20] => 27060811
[21] => 27060812
[22] => 27060813
[23] => 27060814
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 170,145 sf
- Living (sf): 896
- Year Built: 1973
- Building Name: Northbrook-Melemanu
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Garden
- Listing Office: eXp Realty
- Maintenance Fees: $1,018
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 8, 2025 - 11:30 AM
Information is deemed reliable but not guaranteed.
Copyright: 2025 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.