95-188 Waikalani Drive Mililani, HI 96789
Listing
Overview
Price: $2,200,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
Welcome to a one of a kind home nestled in the gated hidden community of Melemanu (songbird) Woodlands. This meticulously renovated gem offers serenity like no other! Enjoy unobstructed views of both the Ko'olau/Waianae mountain ranges from your private spacious sky deck. Have the option of big sky sunrises, beautiful sunsets, or the majestical starry filled nights at your pleasure. Why travel to the outer islands to escape from city life when you can just exit H2 after work & enter your own tropical oasis. This "o'l Hawaii style" home is surrounded by lush vegetation such as hayden mango, lemon & lime trees + more local favorites. The home includes 44 OWNED PV panels, recently renovated w/a legal separate entry (fully furnished), a separate workshop/storage, a sleek vintage fireplace, multiple rock walls & a driveway to fit 9+ cars for those family/friend nights. High vaulted ceilings w/solid open beams, elegant 1.16" lap redwood walls, and a spacious wrap around upper/lower decks make this home an architectural masterpiece! ASSUMABLE LOAN w/ 2.25% Rate, approx. 844K balance. Come down and see this home today! Listing by: HI Roots Realty LLC (808) 292-8071
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423777"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "95-188"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Waikalani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["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(10) "2200000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2200000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1138) "Welcome to a one of a kind home nestled in the gated hidden community of Melemanu (songbird) Woodlands. This meticulously renovated gem offers serenity like no other! Enjoy unobstructed views of both the Ko'olau/Waianae mountain ranges from your private spacious sky deck. Have the option of big sky sunrises, beautiful sunsets, or the majestical starry filled nights at your pleasure. Why travel to the outer islands to escape from city life when you can just exit H2 after work & enter your own tropical oasis. This "o'l Hawaii style" home is surrounded by lush vegetation such as hayden mango, lemon & lime trees + more local favorites. The home includes 44 OWNED PV panels, recently renovated w/a legal separate entry (fully furnished), a separate workshop/storage, a sleek vintage fireplace, multiple rock walls & a driveway to fit 9+ cars for those family/friend nights. High vaulted ceilings w/solid open beams, elegant 1.16" lap redwood walls, and a spacious wrap around upper/lower decks make this home an architectural masterpiece! ASSUMABLE LOAN w/ 2.25% Rate, approx. 844K balance. Come down and see this home today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(19) "HI Roots Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "44431.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2719"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "9"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(28) "Garden,Mountain,Other,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Kipapa"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ROOT"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "peter@hirootsrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 292-8071"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Peter Enomoto-Hahn"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-25T15:02:02.627"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18320459"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-18T11:06:56.277"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26736602"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26736602"
[1]=>
string(8) "26736603"
[2]=>
string(8) "26736604"
[3]=>
string(8) "26736605"
[4]=>
string(8) "26736606"
[5]=>
string(8) "26736607"
[6]=>
string(8) "26736608"
[7]=>
string(8) "26736609"
[8]=>
string(8) "26736610"
[9]=>
string(8) "26736611"
[10]=>
string(8) "26736612"
[11]=>
string(8) "26736613"
[12]=>
string(8) "26736614"
[13]=>
string(8) "26736615"
[14]=>
string(8) "26736616"
[15]=>
string(8) "26736617"
[16]=>
string(8) "26736618"
[17]=>
string(8) "26736619"
[18]=>
string(8) "26736620"
[19]=>
string(8) "26736621"
[20]=>
string(8) "26736622"
[21]=>
string(8) "26736623"
[22]=>
string(8) "26736624"
[23]=>
string(8) "26736625"
[24]=>
string(8) "26736626"
[25]=>
string(8) "26736627"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423777
)
[StreetNumber] => Array
(
[0] => 95-188
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 2200000.00
)
[CurrentPrice] => Array
(
[0] => 2200000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to a one of a kind home nestled in the gated hidden community of Melemanu (songbird) Woodlands. This meticulously renovated gem offers serenity like no other! Enjoy unobstructed views of both the Ko'olau/Waianae mountain ranges from your private spacious sky deck. Have the option of big sky sunrises, beautiful sunsets, or the majestical starry filled nights at your pleasure. Why travel to the outer islands to escape from city life when you can just exit H2 after work & enter your own tropical oasis. This "o'l Hawaii style" home is surrounded by lush vegetation such as hayden mango, lemon & lime trees + more local favorites. The home includes 44 OWNED PV panels, recently renovated w/a legal separate entry (fully furnished), a separate workshop/storage, a sleek vintage fireplace, multiple rock walls & a driveway to fit 9+ cars for those family/friend nights. High vaulted ceilings w/solid open beams, elegant 1.16" lap redwood walls, and a spacious wrap around upper/lower decks make this home an architectural masterpiece! ASSUMABLE LOAN w/ 2.25% Rate, approx. 844K balance. Come down and see this home today!
)
[ListOfficeName] => Array
(
[0] => HI Roots Realty LLC
)
[BedsTotal] => Array
(
[0] => 6
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 44431.00
)
[SqftTotal] => Array
(
[0] => 2719
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 9
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Mountain,Other,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 0.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kipapa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Mililani
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => ROOT
)
[ListAgentEmail] => Array
(
[0] => peter@hirootsrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 292-8071
)
[ListAgentFullName] => Array
(
[0] => Peter Enomoto-Hahn
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-25T15:02:02.627
)
[Matrix_Unique_ID] => Array
(
[0] => 18320459
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-18T11:06:56.277
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26736602
)
[listing_image] => Array
(
[0] => 26736602
[1] => 26736603
[2] => 26736604
[3] => 26736605
[4] => 26736606
[5] => 26736607
[6] => 26736608
[7] => 26736609
[8] => 26736610
[9] => 26736611
[10] => 26736612
[11] => 26736613
[12] => 26736614
[13] => 26736615
[14] => 26736616
[15] => 26736617
[16] => 26736618
[17] => 26736619
[18] => 26736620
[19] => 26736621
[20] => 26736622
[21] => 26736623
[22] => 26736624
[23] => 26736625
[24] => 26736626
[25] => 26736627
)
)
- BedsTotal: 6
- Full Baths: 4
- Land Area (sf): 44,431
- Living (sf): 2,719
- Year Built: 1973
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 9
- View: Garden,Mountain,Other,Sunset
- Listing Office: HI Roots Realty LLC
- Maintenance Fees: $0
- Land Tenure: FS - Fee Simple
- Elementary School: Kipapa
- Middle School: Mililani
- High School: Mililani