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
        )

)

  • 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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446