Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
Price: $2,399,000 Area: KAWAILOA-NORTH SHORE Status: Active
This stunning beachfront home offers direct access to some of the most famous surf and swim spots, making it a paradise for ocean lovers. With breathtaking panoramic views from both levels and two spacious lanais, you’ll enjoy spectacular sunrises, sunsets, and the soothing sound of the waves. The layout includes a separate entrance, perfect for extended family or guests, while ample parking ensures convenience. Nestled in the heart of the beach, you'll share the shoreline with sea turtles, playful dolphins, and majestic whales. Plus, you're less than a mile from a grocery store and just a seven-minute drive from historic Haleiwa Town, where you can explore amazing restaurants, charming shops, and vibrant farmers' markets. This is the ultimate blend of coastal beauty and island convenience. Listing by: Compass (808) 825-4277
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202507049"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "61-275"
}
["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(7) "Haleiwa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96712"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(61) "https://www.youtube.com/embed/r36Hhm9Ms94?si=L_3uk_BZL0nMqRAG"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2399000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(20) "KAWAILOA-NORTH SHORE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(803) "This stunning beachfront home offers direct access to some of the most famous surf and swim spots, making it a paradise for ocean lovers. With breathtaking panoramic views from both levels and two spacious lanais, you’ll enjoy spectacular sunrises, sunsets, and the soothing sound of the waves. The layout includes a separate entrance, perfect for extended family or guests, while ample parking ensures convenience. Nestled in the heart of the beach, you'll share the shoreline with sea turtles, playful dolphins, and majestic whales. Plus, you're less than a mile from a grocery store and just a seven-minute drive from historic Haleiwa Town, where you can explore amazing restaurants, charming shops, and vibrant farmers' markets. This is the ultimate blend of coastal beauty and island convenience."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5690.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1936"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1966"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(31) "Coastline,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["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) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18623847"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-18T11:39:06.920"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-03-17"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(28) "Ocean,Sandy Beach,Waterfront"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "11:39:06.920"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26929090"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26929090"
[1]=>
string(8) "26929091"
[2]=>
string(8) "26929092"
[3]=>
string(8) "26929093"
[4]=>
string(8) "26929094"
[5]=>
string(8) "26929095"
[6]=>
string(8) "26929096"
[7]=>
string(8) "26929097"
[8]=>
string(8) "26929098"
[9]=>
string(8) "26929099"
[10]=>
string(8) "26929100"
[11]=>
string(8) "26929101"
[12]=>
string(8) "26929102"
[13]=>
string(8) "26929103"
[14]=>
string(8) "26929104"
[15]=>
string(8) "26929105"
[16]=>
string(8) "26929106"
[17]=>
string(8) "26929107"
[18]=>
string(8) "26929108"
[19]=>
string(8) "26929109"
[20]=>
string(8) "26929110"
[21]=>
string(8) "26929111"
[22]=>
string(8) "26929112"
[23]=>
string(8) "26929113"
[24]=>
string(8) "26929114"
[25]=>
string(8) "26929115"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202507049
)
[StreetNumber] => Array
(
[0] => 61-275
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/r36Hhm9Ms94?si=L_3uk_BZL0nMqRAG
)
[ListPrice] => Array
(
[0] => 2399000.00
)
[Neighbourhood] => Array
(
[0] => KAWAILOA-NORTH SHORE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This stunning beachfront home offers direct access to some of the most famous surf and swim spots, making it a paradise for ocean lovers. With breathtaking panoramic views from both levels and two spacious lanais, you’ll enjoy spectacular sunrises, sunsets, and the soothing sound of the waves. The layout includes a separate entrance, perfect for extended family or guests, while ample parking ensures convenience. Nestled in the heart of the beach, you'll share the shoreline with sea turtles, playful dolphins, and majestic whales. Plus, you're less than a mile from a grocery store and just a seven-minute drive from historic Haleiwa Town, where you can explore amazing restaurants, charming shops, and vibrant farmers' markets. This is the ultimate blend of coastal beauty and island convenience.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5690.00
)
[SqftTotal] => Array
(
[0] => 1936
)
[YearBuilt] => Array
(
[0] => 1966
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Haleiwa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => swingate808@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 825-4277
)
[ListAgentFullName] => Array
(
[0] => Sean Wingate
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18623847
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-18T11:39:06.920
)
[ListingContractDate] => Array
(
[0] => 2025-03-17
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:39:06.920
)
[_thumbnail_id] => Array
(
[0] => 26929090
)
[listing_image] => Array
(
[0] => 26929090
[1] => 26929091
[2] => 26929092
[3] => 26929093
[4] => 26929094
[5] => 26929095
[6] => 26929096
[7] => 26929097
[8] => 26929098
[9] => 26929099
[10] => 26929100
[11] => 26929101
[12] => 26929102
[13] => 26929103
[14] => 26929104
[15] => 26929105
[16] => 26929106
[17] => 26929107
[18] => 26929108
[19] => 26929109
[20] => 26929110
[21] => 26929111
[22] => 26929112
[23] => 26929113
[24] => 26929114
[25] => 26929115
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 18, 2025 - 11:39 AM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
