95-252 Kailiula Loop Mililani, HI 96789

Take a Virtual Tour

Listing
Overview

Price: $1,125,000
Area: MILILANI AREA
Status: Active

Come see this beautifully renovated home, fully remodeled in 2024! The contemporary kitchen boasts new sleek gray cabinetry, stainless steel appliances, and quartz countertops, perfectly complemented by an open-concept layout that flows into a bright and airy living space. Vaulted ceilings and large new windows invite natural light, offering stunning views of the lush backyard. The chic bathrooms are upgraded with modern fixtures and stylish tilework, providing a spa-like retreat. Enjoy outdoor living in the expansive, private yard, perfect for relaxing or entertaining. The thoughtful design merges comfort with elegance, making it the perfect blend of style and functionality. Located in a peaceful community not far from freeway access and close to local amenities like golfing, parks, schools, shopping, and groceries, offering the ideal balance of convenience and comfort. This home is part of Mililani Town Association (HOA fee ~$48/month), a community designed to offer its residents a high quality of life. The Association oversees the management of the community’s parks, recreation centers, and other amenities, ensuring the neighborhood maintains a clean and appealing environment. Listing by: Real Broker, LLC (808) 518-0288

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202421004"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "95-252"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Kailiula"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Loop"
  }
  ["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(45) "https://my.matterport.com/show/?m=gj7XgwYixKA"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1125000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1125000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(13) "MILILANI AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1200) "Come see this beautifully renovated home, fully remodeled in 2024! The contemporary kitchen boasts new sleek gray cabinetry, stainless steel appliances, and quartz countertops, perfectly complemented by an open-concept layout that flows into a bright and airy living space. Vaulted ceilings and large new windows invite natural light, offering stunning views of the lush backyard. The chic bathrooms are upgraded with modern fixtures and stylish tilework, providing a spa-like retreat. Enjoy outdoor living in the expansive, private yard, perfect for relaxing or entertaining. The thoughtful design merges comfort with elegance, making it the perfect blend of style and functionality. Located in a peaceful community not far from freeway access and close to local amenities like golfing, parks, schools, shopping, and groceries, offering the ideal balance of convenience and comfort. This home is part of Mililani Town Association (HOA fee ~$48/month), a community designed to offer its residents a high quality of life. The Association oversees the management of the community’s parks, recreation centers, and other amenities, ensuring the neighborhood maintains a clean and appealing environment."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(16) "Real Broker, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5961.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1290"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1970"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["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) "RBLL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "juliet@julietrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 518-0288"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Juliet Lalouel"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-18T10:30:02.580"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18259907"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-13T06:41:28.537"
  }
  ["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) "26693038"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26693038"
    [1]=>
    string(8) "26693039"
    [2]=>
    string(8) "26693040"
    [3]=>
    string(8) "26693041"
    [4]=>
    string(8) "26693042"
    [5]=>
    string(8) "26693043"
    [6]=>
    string(8) "26693044"
    [7]=>
    string(8) "26693045"
    [8]=>
    string(8) "26693046"
    [9]=>
    string(8) "26693047"
    [10]=>
    string(8) "26693048"
    [11]=>
    string(8) "26693049"
    [12]=>
    string(8) "26693050"
    [13]=>
    string(8) "26693051"
    [14]=>
    string(8) "26693052"
    [15]=>
    string(8) "26693053"
    [16]=>
    string(8) "26693054"
    [17]=>
    string(8) "26693055"
    [18]=>
    string(8) "26693056"
    [19]=>
    string(8) "26693057"
    [20]=>
    string(8) "26693058"
    [21]=>
    string(8) "26693059"
    [22]=>
    string(8) "26693060"
    [23]=>
    string(8) "26693061"
    [24]=>
    string(8) "26693062"
    [25]=>
    string(8) "26693063"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202421004
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://my.matterport.com/show/?m=gj7XgwYixKA
        )

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

    [CurrentPrice] => Array
        (
            [0] => 1125000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Come see this beautifully renovated home, fully remodeled in 2024! The contemporary kitchen boasts new sleek gray cabinetry, stainless steel appliances, and quartz countertops, perfectly complemented by an open-concept layout that flows into a bright and airy living space. Vaulted ceilings and large new windows invite natural light, offering stunning views of the lush backyard. The chic bathrooms are upgraded with modern fixtures and stylish tilework, providing a spa-like retreat. Enjoy outdoor living in the expansive, private yard, perfect for relaxing or entertaining. The thoughtful design merges comfort with elegance, making it the perfect blend of style and functionality. Located in a peaceful community not far from freeway access and close to local amenities like golfing, parks, schools, shopping, and groceries, offering the ideal balance of convenience and comfort. This home is part of Mililani Town Association (HOA fee ~$48/month), a community designed to offer its residents a high quality of life. The Association oversees the management of the community’s parks, recreation centers, and other amenities, ensuring the neighborhood maintains a clean and appealing environment.
        )

    [ListOfficeName] => Array
        (
            [0] => Real Broker, LLC
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => juliet@julietrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 518-0288
        )

    [ListAgentFullName] => Array
        (
            [0] => Juliet Lalouel
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-18T10:30:02.580
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-09-13T06:41:28.537
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26693038
            [1] => 26693039
            [2] => 26693040
            [3] => 26693041
            [4] => 26693042
            [5] => 26693043
            [6] => 26693044
            [7] => 26693045
            [8] => 26693046
            [9] => 26693047
            [10] => 26693048
            [11] => 26693049
            [12] => 26693050
            [13] => 26693051
            [14] => 26693052
            [15] => 26693053
            [16] => 26693054
            [17] => 26693055
            [18] => 26693056
            [19] => 26693057
            [20] => 26693058
            [21] => 26693059
            [22] => 26693060
            [23] => 26693061
            [24] => 26693062
            [25] => 26693063
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Land Area (sf): 5,961
  • Living (sf): 1,290
  • Year Built: 1970

  • Property Condition: Excellent
  • Number of Parking Spaces: 4
  • View: Other
  • Listing Office: Real Broker, LLC

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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