Listing
Overview
Price: $13,985,000
Area: SUNSET AREA
Status: Active
AN AWE-INSPIRING MODERN BEACHFRONT RESORT… Enjoy front row seats to unparalleled ocean, coastline & sunset views year-round from this spectacular beachfront estate located on sought after Sunset Beach, home to one of the greatest Triple Crown surfing events in the world. From the moment of arrival, one is spellbound by tropical landscaped grounds, plunge pool w/water feature & pathways leading to one of Oahu’s most remarkable residences. Welcome to a contemporary masterpiece w/vast open living spaces, soaring ceilings, sun filled walls of glass that open to a sprawling seaside patio revealing panoramic ocean vistas & the true meaning of indoor/outdoor living. Enjoy numerous lounge & entertaining spaces w/warm tones of inlaid hardwood ceilings which compliment magnificent poured in place concrete walls w/cast moldings & intricate details throughout. The Primary Suite offers amazing seascapes, dual dressing areas, walk in shower, soaking tub & private balcony. Sizeable library, hm office, multiple outdoor lanais + a spa/wellness rm, are just a sampling of what life at this striking coastal residence offers. Sep. caretaker’s apt + storage for all of your favorite beach gear & more! Listing by: Coldwell Banker Realty (808) 596-0456
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202225419"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-069"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Hoalua"
}
["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(53) "https://player.vimeo.com/video/765184241?h=c3267b4074"
}
["ListPrice"]=>
array(1) {
[0]=>
string(11) "13985000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(11) "13985000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1204) "AN AWE-INSPIRING MODERN BEACHFRONT RESORT… Enjoy front row seats to unparalleled ocean, coastline & sunset views year-round from this spectacular beachfront estate located on sought after Sunset Beach, home to one of the greatest Triple Crown surfing events in the world. From the moment of arrival, one is spellbound by tropical landscaped grounds, plunge pool w/water feature & pathways leading to one of Oahu’s most remarkable residences. Welcome to a contemporary masterpiece w/vast open living spaces, soaring ceilings, sun filled walls of glass that open to a sprawling seaside patio revealing panoramic ocean vistas & the true meaning of indoor/outdoor living. Enjoy numerous lounge & entertaining spaces w/warm tones of inlaid hardwood ceilings which compliment magnificent poured in place concrete walls w/cast moldings & intricate details throughout. The Primary Suite offers amazing seascapes, dual dressing areas, walk in shower, soaking tub & private balcony. Sizeable library, hm office, multiple outdoor lanais + a spa/wellness rm, are just a sampling of what life at this striking coastal residence offers. Sep. caretaker’s apt + storage for all of your favorite beach gear & more!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "2"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "21206.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(5) "13623"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2000"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(31) "Coastline,Garden,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) "CBPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "Tracy@TracyAllenHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 596-0456"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Tracy Allen"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-11-08T09:09:36.947"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17035301"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-12-12T17:56:02.653"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25834817"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25834817"
[1]=>
string(8) "25834818"
[2]=>
string(8) "25834819"
[3]=>
string(8) "25834820"
[4]=>
string(8) "25834821"
[5]=>
string(8) "25834822"
[6]=>
string(8) "25834823"
[7]=>
string(8) "25834824"
[8]=>
string(8) "25834825"
[9]=>
string(8) "25834826"
[10]=>
string(8) "25834827"
[11]=>
string(8) "25834828"
[12]=>
string(8) "25834829"
[13]=>
string(8) "25834830"
[14]=>
string(8) "25834831"
[15]=>
string(8) "25834832"
[16]=>
string(8) "25834833"
[17]=>
string(8) "25834834"
[18]=>
string(8) "25834835"
[19]=>
string(8) "25834836"
[20]=>
string(8) "25834837"
[21]=>
string(8) "25834838"
[22]=>
string(8) "25834839"
[23]=>
string(8) "25834840"
[24]=>
string(8) "25834841"
[25]=>
string(8) "25834842"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(28) "Ocean,Sandy Beach,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202225419
)
[StreetNumber] => Array
(
[0] => 59-069
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hoalua
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/765184241?h=c3267b4074
)
[ListPrice] => Array
(
[0] => 13985000.00
)
[CurrentPrice] => Array
(
[0] => 13985000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => AN AWE-INSPIRING MODERN BEACHFRONT RESORT… Enjoy front row seats to unparalleled ocean, coastline & sunset views year-round from this spectacular beachfront estate located on sought after Sunset Beach, home to one of the greatest Triple Crown surfing events in the world. From the moment of arrival, one is spellbound by tropical landscaped grounds, plunge pool w/water feature & pathways leading to one of Oahu’s most remarkable residences. Welcome to a contemporary masterpiece w/vast open living spaces, soaring ceilings, sun filled walls of glass that open to a sprawling seaside patio revealing panoramic ocean vistas & the true meaning of indoor/outdoor living. Enjoy numerous lounge & entertaining spaces w/warm tones of inlaid hardwood ceilings which compliment magnificent poured in place concrete walls w/cast moldings & intricate details throughout. The Primary Suite offers amazing seascapes, dual dressing areas, walk in shower, soaking tub & private balcony. Sizeable library, hm office, multiple outdoor lanais + a spa/wellness rm, are just a sampling of what life at this striking coastal residence offers. Sep. caretaker’s apt + storage for all of your favorite beach gear & more!
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 6
)
[BathsHalf] => Array
(
[0] => 2
)
[LotSizeArea] => Array
(
[0] => 21206.00
)
[SqftTotal] => Array
(
[0] => 13623
)
[YearBuilt] => Array
(
[0] => 2000
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP
)
[ListAgentEmail] => Array
(
[0] => Tracy@TracyAllenHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 596-0456
)
[ListAgentFullName] => Array
(
[0] => Tracy Allen
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-11-08T09:09:36.947
)
[Matrix_Unique_ID] => Array
(
[0] => 17035301
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-12-12T17:56:02.653
)
[_thumbnail_id] => Array
(
[0] => 25834817
)
[listing_image] => Array
(
[0] => 25834817
[1] => 25834818
[2] => 25834819
[3] => 25834820
[4] => 25834821
[5] => 25834822
[6] => 25834823
[7] => 25834824
[8] => 25834825
[9] => 25834826
[10] => 25834827
[11] => 25834828
[12] => 25834829
[13] => 25834830
[14] => 25834831
[15] => 25834832
[16] => 25834833
[17] => 25834834
[18] => 25834835
[19] => 25834836
[20] => 25834837
[21] => 25834838
[22] => 25834839
[23] => 25834840
[24] => 25834841
[25] => 25834842
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 5
- Full Baths: 6
- Half Baths: 2
- Land Area (sf): 21,206
- Living (sf): 13,623
- Year Built: 2000
- Property Condition: Above Average
- Number of Parking Spaces: 6
- View: Coastline,Garden,Mountain,Ocean
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
