Previous Next

95-152 Waimakua Drive Mililani, HI 96789

Take a Virtual Tour

Listing
Overview

Price: $1,580,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202613121"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "95-152"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Waimakua"
  }
  ["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(51) "https://my.matterport.com/show/?m=tMNrst4AH8m&mls=1"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1580000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(867) "Rarely available in Waipio Acres—a true multi-generational (Ohana) masterpiece! This expansive residence boasts a flexible floor plan perfectly tailored for extended family or shared living, featuring two separate private-entry living areas on the ground floor. The upper level serves as the heart of the home, offering a bright, open-concept living space, a modern chefinspired kitchen, and three spacious bedrooms, including a serene primary suite. Step outside into your private
island retreat: a lushly landscaped sanctuary featuring a tranquil waterfall, a peaceful fishpond, and a terraced garden brimming with lychee and papaya. With a sprawling 10,012 sq. ft. lot, ample parking, and extensive storage, this versatile estate combines luxury with functionality in a prime central location. Don't miss this one-ofa-kind opportunity! Tax records do not match."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "Team Lally"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "10012.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2669"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2012"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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) "LALY"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "adrienne@teamlally.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 227-2703"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Adrienne W Lally"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19564343"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-07-20T02:28:36.690"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-07-07"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Central"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "02:28:36.690"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27449457"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27449457"
    [1]=>
    string(8) "27449458"
    [2]=>
    string(8) "27449459"
    [3]=>
    string(8) "27449460"
    [4]=>
    string(8) "27449461"
    [5]=>
    string(8) "27449462"
    [6]=>
    string(8) "27449463"
    [7]=>
    string(8) "27449464"
    [8]=>
    string(8) "27449465"
    [9]=>
    string(8) "27449466"
    [10]=>
    string(8) "27449467"
    [11]=>
    string(8) "27449468"
    [12]=>
    string(8) "27449469"
    [13]=>
    string(8) "27449470"
    [14]=>
    string(8) "27449471"
    [15]=>
    string(8) "27449472"
    [16]=>
    string(8) "27449473"
    [17]=>
    string(8) "27449474"
    [18]=>
    string(8) "27449475"
    [19]=>
    string(8) "27449476"
    [20]=>
    string(8) "27449477"
    [21]=>
    string(8) "27449478"
    [22]=>
    string(8) "27449479"
    [23]=>
    string(8) "27449480"
    [24]=>
    string(8) "27449481"
    [25]=>
    string(8) "27449482"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202613121
        )

    [StreetNumber] => Array
        (
            [0] => 95-152
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Waimakua
        )

    [StreetSuffix] => Array
        (
            [0] => Drive
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Mililani
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96789
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://my.matterport.com/show/?m=tMNrst4AH8m&mls=1
        )

    [ListPrice] => Array
        (
            [0] => 1580000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WAIPIO ACRES/WAIKALANI WOODLANDS
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Rarely available in Waipio Acres—a true multi-generational (Ohana) masterpiece! This expansive residence boasts a flexible floor plan perfectly tailored for extended family or shared living, featuring two separate private-entry living areas on the ground floor. The upper level serves as the heart of the home, offering a bright, open-concept living space, a modern chefinspired kitchen, and three spacious bedrooms, including a serene primary suite. Step outside into your private
island retreat: a lushly landscaped sanctuary featuring a tranquil waterfall, a peaceful fishpond, and a terraced garden brimming with lychee and papaya. With a sprawling 10,012 sq. ft. lot, ample parking, and extensive storage, this versatile estate combines luxury with functionality in a prime central location. Don't miss this one-ofa-kind opportunity! Tax records do not match.
        )

    [ListOfficeName] => Array
        (
            [0] => Team Lally
        )

    [BedsTotal] => Array
        (
            [0] => 6
        )

    [BathsFull] => Array
        (
            [0] => 5
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 10012.00
        )

    [SqftTotal] => Array
        (
            [0] => 2669
        )

    [YearBuilt] => Array
        (
            [0] => 2012
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

    [ParkingTotal] => Array
        (
            [0] => 4
        )

    [StoriesType] => Array
        (
            [0] => Two
        )

    [View] => Array
        (
            [0] => None
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => LALY
        )

    [ListAgentEmail] => Array
        (
            [0] => adrienne@teamlally.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 227-2703
        )

    [ListAgentFullName] => Array
        (
            [0] => Adrienne W Lally
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 19564343
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-07-20T02:28:36.690
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-07-07
        )

    [MLSAreaMajor] => Array
        (
            [0] => Central
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 02:28:36.690
        )

    [_thumbnail_id] => Array
        (
            [0] => 27449457
        )

    [listing_image] => Array
        (
            [0] => 27449457
            [1] => 27449458
            [2] => 27449459
            [3] => 27449460
            [4] => 27449461
            [5] => 27449462
            [6] => 27449463
            [7] => 27449464
            [8] => 27449465
            [9] => 27449466
            [10] => 27449467
            [11] => 27449468
            [12] => 27449469
            [13] => 27449470
            [14] => 27449471
            [15] => 27449472
            [16] => 27449473
            [17] => 27449474
            [18] => 27449475
            [19] => 27449476
            [20] => 27449477
            [21] => 27449478
            [22] => 27449479
            [23] => 27449480
            [24] => 27449481
            [25] => 27449482
        )

)

PROPERTY INFO

• BedsTotal: 6
• Full Baths: 5
• Land Area (sf): 10,012 sf
• Living (sf): 2,669
• Year Built: 2012

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 4
• View: None
• Listing Office: Team Lally

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on July 20, 2026 - 2:28 AM 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.