95-1018 Puukoa Street Unit 48 Mililani, HI 96789

Take a Virtual Tour

Listing
Overview

Price: $1,300,000
Area: MILILANI MAUKA
Status: Active Under Contract

Discover your dream home in Mililani Mauka, where modern elegance meets serene outdoor spaces. For the first time on the market, get ready to transport yourself into an inviting space that has been updated throughout. The gourmet kitchen features custom Italian cabinets, luxurious Viatera quartz countertops, and exquisite Moooi lighting. Enjoy your suite of high-end Thermador appliances and a built-in Miele whole bean coffee system. The bathrooms have also been tastefully remodeled with custom cabinetry, Kohler sinks, and sleek Staron countertops. Arrive to a stunning landscaped yard showcasing exceptional curb appeal complete with water features and solar lights. Enjoy outdoor living with a large, extended, and covered lanai, ideal for entertaining or simply relaxing in your manicured surroundings. Utilize your attached 2-car garage as a workspace--complete with metal storage cabinets and pegboard. Don't miss this exciting opportunity to own a home in Mililani Mauka! Listing by: Refined Real Estate Hawaii LLC (808) 260-9888

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202428757"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "95-1018"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Puukoa"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(2) "48"
  }
  ["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(41) "https://player.vimeo.com/video/1025003442"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1300000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(14) "MILILANI MAUKA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(990) "Discover your dream home in Mililani Mauka, where modern elegance meets serene outdoor spaces.  For the first time on the market, get ready to transport yourself into an inviting space that has been updated throughout.  The gourmet kitchen features custom Italian cabinets, luxurious Viatera quartz countertops, and exquisite Moooi lighting.  Enjoy your suite of high-end Thermador appliances and a built-in Miele whole bean coffee system.  The bathrooms have also been tastefully remodeled with custom cabinetry, Kohler sinks, and sleek Staron countertops.  Arrive to a stunning landscaped yard showcasing exceptional curb appeal complete with water features and solar lights.  Enjoy outdoor living with a large, extended, and covered lanai, ideal for entertaining or simply relaxing in your manicured surroundings.  Utilize your attached 2-car garage as a workspace--complete with metal storage cabinets and pegboard.  Don't miss this exciting opportunity to own a home in Mililani Mauka!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(30) "Refined Real Estate Hawaii LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "3475.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1904"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2002"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(21) "Destiny At Mililani 1"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "395.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) "RREH"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "dennis@refinedhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 260-9888"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(21) "Dennis L Noah-Casison"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18451750"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-04T16:45:28.690"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-01-27"
  }
  ["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) "16:45:28.690"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26856135"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26856135"
    [1]=>
    string(8) "26856136"
    [2]=>
    string(8) "26856137"
    [3]=>
    string(8) "26856138"
    [4]=>
    string(8) "26856139"
    [5]=>
    string(8) "26856140"
    [6]=>
    string(8) "26856141"
    [7]=>
    string(8) "26856142"
    [8]=>
    string(8) "26856143"
    [9]=>
    string(8) "26856144"
    [10]=>
    string(8) "26856145"
    [11]=>
    string(8) "26856146"
    [12]=>
    string(8) "26856147"
    [13]=>
    string(8) "26856148"
    [14]=>
    string(8) "26856149"
    [15]=>
    string(8) "26856150"
    [16]=>
    string(8) "26856151"
    [17]=>
    string(8) "26856152"
    [18]=>
    string(8) "26856153"
    [19]=>
    string(8) "26856154"
    [20]=>
    string(8) "26856155"
    [21]=>
    string(8) "26856156"
    [22]=>
    string(8) "26856157"
    [23]=>
    string(8) "26856158"
    [24]=>
    string(8) "26856159"
    [25]=>
    string(8) "26856160"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202428757
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://player.vimeo.com/video/1025003442
        )

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

    [Neighbourhood] => Array
        (
            [0] => MILILANI MAUKA
        )

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

    [PublicRemarks] => Array
        (
            [0] => Discover your dream home in Mililani Mauka, where modern elegance meets serene outdoor spaces.  For the first time on the market, get ready to transport yourself into an inviting space that has been updated throughout.  The gourmet kitchen features custom Italian cabinets, luxurious Viatera quartz countertops, and exquisite Moooi lighting.  Enjoy your suite of high-end Thermador appliances and a built-in Miele whole bean coffee system.  The bathrooms have also been tastefully remodeled with custom cabinetry, Kohler sinks, and sleek Staron countertops.  Arrive to a stunning landscaped yard showcasing exceptional curb appeal complete with water features and solar lights.  Enjoy outdoor living with a large, extended, and covered lanai, ideal for entertaining or simply relaxing in your manicured surroundings.  Utilize your attached 2-car garage as a workspace--complete with metal storage cabinets and pegboard.  Don't miss this exciting opportunity to own a home in Mililani Mauka!
        )

    [ListOfficeName] => Array
        (
            [0] => Refined Real Estate Hawaii LLC
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Destiny At Mililani 1
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => dennis@refinedhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 260-9888
        )

    [ListAgentFullName] => Array
        (
            [0] => Dennis L Noah-Casison
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-04T16:45:28.690
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-01-27
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:45:28.690
        )

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

    [listing_image] => Array
        (
            [0] => 26856135
            [1] => 26856136
            [2] => 26856137
            [3] => 26856138
            [4] => 26856139
            [5] => 26856140
            [6] => 26856141
            [7] => 26856142
            [8] => 26856143
            [9] => 26856144
            [10] => 26856145
            [11] => 26856146
            [12] => 26856147
            [13] => 26856148
            [14] => 26856149
            [15] => 26856150
            [16] => 26856151
            [17] => 26856152
            [18] => 26856153
            [19] => 26856154
            [20] => 26856155
            [21] => 26856156
            [22] => 26856157
            [23] => 26856158
            [24] => 26856159
            [25] => 26856160
        )

)

  • BedsTotal: 4
  • Full Baths: 2
  • Half Baths: 1
  • Land Area (sf): 3,475 sf
  • Living (sf): 1,904
  • Year Built: 2002
  • Building Name: Destiny At Mililani 1

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: None
  • Listing Office: Refined Real Estate Hawaii LLC

  • Maintenance Fees: $395
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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