Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
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 42 OWNED PV panels, 4 bedrooms in the main area and a recently renovated fully furnished 2 bedroom dwelling w/a legal separate entry, 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. Make an appointment 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(1181) "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 42 OWNED PV panels, 4 bedrooms in the main area and a recently renovated fully furnished 2 bedroom dwelling w/a legal separate entry, 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. Make an appointment 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-11-13T15:55:36.380"
}
["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 42 OWNED PV panels, 4 bedrooms in the main area and a recently renovated fully furnished 2 bedroom dwelling w/a legal separate entry, 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. Make an appointment 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-11-13T15:55:36.380
)
[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
)
)
