Our office will be closed on Monday, November 11th, 2024.
59-021 Holawa Street Haleiwa, HI 96712
Listing Overview
Price: $5,400,000 Area: SUNSET AREA Status: Active
This custom-built beachfront home at Sunset Beach offers the perfect blend of privacy and convenience. Located three blocks from Kam Highway, residents enjoy easy access to Sunset Elementary School, and the nearby Foodland Supermarket. Boasting 3 bedrooms, 3 baths, and a unique Balinese-inspired design. Meticulously crafted and designed to maximize its stunning oceanfront location and the cooling trade wind breeze. Situated on a generous 10,372 sq ft lot, the property faces west, providing breathtaking views of the vast Pacific Ocean. The interior spans 2,869 sq ft, complemented by an additional 1,1715 sq ft of garage and deck space for indoor/outdoor living. There's a custom-built Balinese pergola with retractable chaise lounge backrests to relax on and soak in the spectacular views. Balinese stone carvings and architectural details further enhance the tropical ambiance. The lush garden showcases vibrant flowers. Enjoy the sweet low-growing coconuts, papayas, figs and herbs. Swim, snorkel, fish & surf right in front of your home. Immerse yourself in awe-inspiring sunsets and glowing rainbows of this spectacular beachfront paradise. Listing by: Compass (808) 825-4277
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202422274"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-021"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Holawa"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96712"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "5400000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "5400000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1150) "This custom-built beachfront home at Sunset Beach offers the perfect blend of privacy and convenience. Located three blocks from Kam Highway, residents enjoy easy access to Sunset Elementary School, and the nearby Foodland Supermarket. Boasting 3 bedrooms, 3 baths, and a unique Balinese-inspired design. Meticulously crafted and designed to maximize its stunning oceanfront location and the cooling trade wind breeze. Situated on a generous 10,372 sq ft lot, the property faces west, providing breathtaking views of the vast Pacific Ocean. The interior spans 2,869 sq ft, complemented by an additional 1,1715 sq ft of garage and deck space for indoor/outdoor living. There's a custom-built Balinese pergola with retractable chaise lounge backrests to relax on and soak in the spectacular views. Balinese stone carvings and architectural details further enhance the tropical ambiance. The lush garden showcases vibrant flowers. Enjoy the sweet low-growing coconuts, papayas, figs and herbs. Swim, snorkel, fish & surf right in front of your home. Immerse yourself in awe-inspiring sunsets and glowing rainbows of this spectacular beachfront paradise."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10378.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "4584"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2003"
}
["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(39) "Coastline,Mountain,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(12) "Sunset Beach"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "swingate808@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Sean Wingate"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-27T17:00:01.670"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18295503"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-02T17:48:01.373"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26716748"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26716748"
[1]=>
string(8) "26716749"
[2]=>
string(8) "26716750"
[3]=>
string(8) "26716751"
[4]=>
string(8) "26716752"
[5]=>
string(8) "26716753"
[6]=>
string(8) "26716754"
[7]=>
string(8) "26716755"
[8]=>
string(8) "26716756"
[9]=>
string(8) "26716757"
[10]=>
string(8) "26716758"
[11]=>
string(8) "26716759"
[12]=>
string(8) "26716760"
[13]=>
string(8) "26716761"
[14]=>
string(8) "26716762"
[15]=>
string(8) "26716763"
[16]=>
string(8) "26716764"
[17]=>
string(8) "26716765"
[18]=>
string(8) "26716766"
[19]=>
string(8) "26716767"
[20]=>
string(8) "26716768"
[21]=>
string(8) "26716769"
[22]=>
string(8) "26716770"
[23]=>
string(8) "26716771"
[24]=>
string(8) "26716772"
[25]=>
string(8) "26716773"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202422274
)
[StreetNumber] => Array
(
[0] => 59-021
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Holawa
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 5400000.00
)
[CurrentPrice] => Array
(
[0] => 5400000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This custom-built beachfront home at Sunset Beach offers the perfect blend of privacy and convenience. Located three blocks from Kam Highway, residents enjoy easy access to Sunset Elementary School, and the nearby Foodland Supermarket. Boasting 3 bedrooms, 3 baths, and a unique Balinese-inspired design. Meticulously crafted and designed to maximize its stunning oceanfront location and the cooling trade wind breeze. Situated on a generous 10,372 sq ft lot, the property faces west, providing breathtaking views of the vast Pacific Ocean. The interior spans 2,869 sq ft, complemented by an additional 1,1715 sq ft of garage and deck space for indoor/outdoor living. There's a custom-built Balinese pergola with retractable chaise lounge backrests to relax on and soak in the spectacular views. Balinese stone carvings and architectural details further enhance the tropical ambiance. The lush garden showcases vibrant flowers. Enjoy the sweet low-growing coconuts, papayas, figs and herbs. Swim, snorkel, fish & surf right in front of your home. Immerse yourself in awe-inspiring sunsets and glowing rainbows of this spectacular beachfront paradise.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 10378.00
)
[SqftTotal] => Array
(
[0] => 4584
)
[YearBuilt] => Array
(
[0] => 2003
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Sunset Beach
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => swingate808@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 825-4277
)
[ListAgentFullName] => Array
(
[0] => Sean Wingate
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-27T17:00:01.670
)
[Matrix_Unique_ID] => Array
(
[0] => 18295503
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-02T17:48:01.373
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26716748
)
[listing_image] => Array
(
[0] => 26716748
[1] => 26716749
[2] => 26716750
[3] => 26716751
[4] => 26716752
[5] => 26716753
[6] => 26716754
[7] => 26716755
[8] => 26716756
[9] => 26716757
[10] => 26716758
[11] => 26716759
[12] => 26716760
[13] => 26716761
[14] => 26716762
[15] => 26716763
[16] => 26716764
[17] => 26716765
[18] => 26716766
[19] => 26716767
[20] => 26716768
[21] => 26716769
[22] => 26716770
[23] => 26716771
[24] => 26716772
[25] => 26716773
)
)
