Listing
Overview
Price: $1,240,000
Area: MAILI
Status: Active
Welcome to your mountain retreat in Maili, where contemporary elegance meets breathtaking natural beauty. This stunning brand new build 5 bedroom 3 bath home boasts soaring ceilings that amplify the sense of space and light, creating a grand and inviting atmosphere from the moment you enter. The main living area is a masterpiece of design, with expansive windows that frame panoramic views of the surrounding mountains, bring the outdoor in and providing a constant connection to nature. The open-concept layout seamlessly integrates the living room, dinning area, and gourmet kitchen, making it ideal for both entertaining and everyday living. The kitchen is featuring new appliances, sleek countertops, and ample storage space. The main suite is a luxurious retreat, offering a spacious bedroom with high ceilings, a spa-like ensuite bathroom with a soaking tub and walk-in shower, and a private balcony where you can enjoy your morning coffee while taking in the serene mountain view. For guests or extended family, the legal ADU adds versatility and value to the property, whether used as a rental, a home office or a guest suite.
Come experience this comfort living at its finest! Listing by: Luxury Homes International (808) 797-3344
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202409026"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "87-150"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Alapaki"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Waianae"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96792"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(79) "https://listings.hetproductions.com/videos/018f3aee-d2f0-7294-a7da-067f1fe64951"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1240000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1240000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(5) "MAILI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1188) "Welcome to your mountain retreat in Maili, where contemporary elegance meets breathtaking natural beauty. This stunning brand new build 5 bedroom 3 bath home boasts soaring ceilings that amplify the sense of space and light, creating a grand and inviting atmosphere from the moment you enter. The main living area is a masterpiece of design, with expansive windows that frame panoramic views of the surrounding mountains, bring the outdoor in and providing a constant connection to nature. The open-concept layout seamlessly integrates the living room, dinning area, and gourmet kitchen, making it ideal for both entertaining and everyday living. The kitchen is featuring new appliances, sleek countertops, and ample storage space. The main suite is a luxurious retreat, offering a spacious bedroom with high ceilings, a spa-like ensuite bathroom with a soaking tub and walk-in shower, and a private balcony where you can enjoy your morning coffee while taking in the serene mountain view. For guests or extended family, the legal ADU adds versatility and value to the property, whether used as a rental, a home office or a guest suite.
Come experience this comfort living at its finest!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(26) "Luxury Homes International"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3001"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2024"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Ocean"
}
["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) "LXHM"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(17) "fred@luxuryhm.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 797-3344"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Fred Zheng"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-22T17:00:01.720"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17961390"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-26T00:02:44.670"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Leeward"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26180058"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26180058"
[1]=>
string(8) "26180059"
[2]=>
string(8) "26180060"
[3]=>
string(8) "26180061"
[4]=>
string(8) "26180062"
[5]=>
string(8) "26180063"
[6]=>
string(8) "26180064"
[7]=>
string(8) "26180065"
[8]=>
string(8) "26180066"
[9]=>
string(8) "26180067"
[10]=>
string(8) "26180068"
[11]=>
string(8) "26180069"
[12]=>
string(8) "26180070"
[13]=>
string(8) "26180071"
[14]=>
string(8) "26180072"
[15]=>
string(8) "26180073"
[16]=>
string(8) "26180074"
[17]=>
string(8) "26180075"
[18]=>
string(8) "26180076"
[19]=>
string(8) "26180077"
[20]=>
string(8) "26180078"
[21]=>
string(8) "26180079"
[22]=>
string(8) "26180080"
[23]=>
string(8) "26180081"
[24]=>
string(8) "26180082"
[25]=>
string(8) "26180083"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202409026
)
[StreetNumber] => Array
(
[0] => 87-150
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Alapaki
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waianae
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96792
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/videos/018f3aee-d2f0-7294-a7da-067f1fe64951
)
[ListPrice] => Array
(
[0] => 1240000.00
)
[CurrentPrice] => Array
(
[0] => 1240000.00
)
[Neighbourhood] => Array
(
[0] => MAILI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your mountain retreat in Maili, where contemporary elegance meets breathtaking natural beauty. This stunning brand new build 5 bedroom 3 bath home boasts soaring ceilings that amplify the sense of space and light, creating a grand and inviting atmosphere from the moment you enter. The main living area is a masterpiece of design, with expansive windows that frame panoramic views of the surrounding mountains, bring the outdoor in and providing a constant connection to nature. The open-concept layout seamlessly integrates the living room, dinning area, and gourmet kitchen, making it ideal for both entertaining and everyday living. The kitchen is featuring new appliances, sleek countertops, and ample storage space. The main suite is a luxurious retreat, offering a spacious bedroom with high ceilings, a spa-like ensuite bathroom with a soaking tub and walk-in shower, and a private balcony where you can enjoy your morning coffee while taking in the serene mountain view. For guests or extended family, the legal ADU adds versatility and value to the property, whether used as a rental, a home office or a guest suite.
Come experience this comfort living at its finest!
)
[ListOfficeName] => Array
(
[0] => Luxury Homes International
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5000.00
)
[SqftTotal] => Array
(
[0] => 3001
)
[YearBuilt] => Array
(
[0] => 2024
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => LXHM
)
[ListAgentEmail] => Array
(
[0] => fred@luxuryhm.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 797-3344
)
[ListAgentFullName] => Array
(
[0] => Fred Zheng
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-22T17:00:01.720
)
[Matrix_Unique_ID] => Array
(
[0] => 17961390
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-26T00:02:44.670
)
[MLSAreaMajor] => Array
(
[0] => Leeward
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26180058
)
[listing_image] => Array
(
[0] => 26180058
[1] => 26180059
[2] => 26180060
[3] => 26180061
[4] => 26180062
[5] => 26180063
[6] => 26180064
[7] => 26180065
[8] => 26180066
[9] => 26180067
[10] => 26180068
[11] => 26180069
[12] => 26180070
[13] => 26180071
[14] => 26180072
[15] => 26180073
[16] => 26180074
[17] => 26180075
[18] => 26180076
[19] => 26180077
[20] => 26180078
[21] => 26180079
[22] => 26180080
[23] => 26180081
[24] => 26180082
[25] => 26180083
)
)
- BedsTotal: 5
- Full Baths: 3
- Land Area (sf): 5,000
- Living (sf): 3,001
- Year Built: 2024
- Property Condition: Excellent
- Number of Parking Spaces: 3
- View: Mountain,Ocean
- Listing Office: Luxury Homes International
- Land Tenure: FS - Fee Simple
