54-223 Kamehameha Highway Hauula, HI 96717
Listing
Overview
Price: $3,999,000
Area: HAUULA
Status: Active
Discover the ultimate coastal retreat in this oceanfront, two-story home. With nine bedrooms, six and a half bathrooms, and five kitchens across two dwellings, it's perfect for large families or entertaining guests. The Ocean Reef coral stone flooring, topaz-adorned bathrooms, and anthracite limestone exude luxury, complemented by rich African mahogany trim throughout. Enjoy over 800 sq ft of second-story decking with unobstructed ocean views, perfect for soaking in the beauty of the horizon. French drains ensure efficient water management, preserving the home's pristine condition. This home offers seamless indoor-outdoor flow, creating an unparalleled living experience. It's not just a residence; it's a lifestyle. Embrace the perfect blend of elegance and nature—make this dream home yours today. Listing by: eXp Realty (808) 725-2794
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202416607"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-223"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(6) "Hauula"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96717"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3999000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3999000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(809) "Discover the ultimate coastal retreat in this oceanfront, two-story home. With nine bedrooms, six and a half bathrooms, and five kitchens across two dwellings, it's perfect for large families or entertaining guests. The Ocean Reef coral stone flooring, topaz-adorned bathrooms, and anthracite limestone exude luxury, complemented by rich African mahogany trim throughout. Enjoy over 800 sq ft of second-story decking with unobstructed ocean views, perfect for soaking in the beauty of the horizon. French drains ensure efficient water management, preserving the home's pristine condition. This home offers seamless indoor-outdoor flow, creating an unparalleled living experience. It's not just a residence; it's a lifestyle. Embrace the perfect blend of elegance and nature—make this dream home yours today."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "9"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10309.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "4951"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1950"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(46) "Coastline,Garden,Mountain,Ocean,Sunrise,Sunset"
}
["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) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "717krlst8@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Troy D Krill"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-16T11:51:56.433"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18143331"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-22T09:31:31.963"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26631469"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26631469"
[1]=>
string(8) "26631470"
[2]=>
string(8) "26631471"
[3]=>
string(8) "26631472"
[4]=>
string(8) "26631473"
[5]=>
string(8) "26631474"
[6]=>
string(8) "26631475"
[7]=>
string(8) "26631476"
[8]=>
string(8) "26631477"
[9]=>
string(8) "26631478"
[10]=>
string(8) "26631479"
[11]=>
string(8) "26631480"
[12]=>
string(8) "26631481"
[13]=>
string(8) "26631482"
[14]=>
string(8) "26631483"
[15]=>
string(8) "26631484"
[16]=>
string(8) "26631485"
[17]=>
string(8) "26631486"
[18]=>
string(8) "26631487"
[19]=>
string(8) "26631488"
[20]=>
string(8) "26631489"
[21]=>
string(8) "26631490"
[22]=>
string(8) "26631491"
[23]=>
string(8) "26631492"
[24]=>
string(8) "26631493"
[25]=>
string(8) "26631515"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202416607
)
[StreetNumber] => Array
(
[0] => 54-223
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 3999000.00
)
[CurrentPrice] => Array
(
[0] => 3999000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover the ultimate coastal retreat in this oceanfront, two-story home. With nine bedrooms, six and a half bathrooms, and five kitchens across two dwellings, it's perfect for large families or entertaining guests. The Ocean Reef coral stone flooring, topaz-adorned bathrooms, and anthracite limestone exude luxury, complemented by rich African mahogany trim throughout. Enjoy over 800 sq ft of second-story decking with unobstructed ocean views, perfect for soaking in the beauty of the horizon. French drains ensure efficient water management, preserving the home's pristine condition. This home offers seamless indoor-outdoor flow, creating an unparalleled living experience. It's not just a residence; it's a lifestyle. Embrace the perfect blend of elegance and nature—make this dream home yours today.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 9
)
[BathsFull] => Array
(
[0] => 6
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 10309.00
)
[SqftTotal] => Array
(
[0] => 4951
)
[YearBuilt] => Array
(
[0] => 1950
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => 717krlst8@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 725-2794
)
[ListAgentFullName] => Array
(
[0] => Troy D Krill
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-16T11:51:56.433
)
[Matrix_Unique_ID] => Array
(
[0] => 18143331
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-22T09:31:31.963
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26631469
)
[listing_image] => Array
(
[0] => 26631469
[1] => 26631470
[2] => 26631471
[3] => 26631472
[4] => 26631473
[5] => 26631474
[6] => 26631475
[7] => 26631476
[8] => 26631477
[9] => 26631478
[10] => 26631479
[11] => 26631480
[12] => 26631481
[13] => 26631482
[14] => 26631483
[15] => 26631484
[16] => 26631485
[17] => 26631486
[18] => 26631487
[19] => 26631488
[20] => 26631489
[21] => 26631490
[22] => 26631491
[23] => 26631492
[24] => 26631493
[25] => 26631515
)
)
- BedsTotal: 9
- Full Baths: 6
- Half Baths: 1
- Land Area (sf): 10,309
- Living (sf): 4,951
- Year Built: 1950
- Property Condition: Excellent
- Number of Parking Spaces: 6
- View: Coastline,Garden,Mountain,Ocean,Sunrise,Sunset
- Listing Office: eXp Realty
- Land Tenure: FS - Fee Simple
