Listing
Overview
Price: $3,200,000
Area: SUNSET AREA
Status: Active Under Contract
Nestled in a private, gated retreat surrounded by lush tropical landscaping, this charming 3-bedroom, 2-bath oceanfront cottage offers breathtaking ocean and sunset views. Located just 100 feet from iconic Three Tables Beach and only 100 yards from Waimea Bay, you'll enjoy world-class kayaking, snorkeling, surfing, swimming, and more just outside your door. The home features granite countertops, stained oak floors, and a Sub-Zero refrigerator, blending timeless island charm with modern comforts. The oceanfront primary suite includes a spa-inspired bath with a sunken soaking tub perfectly positioned to capture the ocean views. Perched above the shoreline on a solid rocky outcropping, the home enjoys an exceptional oceanfront setting. Just steps from Waimea Valley's botanical gardens and minutes from the North Shore's best beaches, hiking, dining, and recreation, this rare property is ideal as a primary residence, vacation home or investment opportunity. Enjoy year-round whale watching, spectacular sunsets and the soothing sound of the surf from the comfort of your own private oceanfront retreat. Experience the beauty, privacy, and lifestyle of one of Hawaii's most coveted locations. Listing by: eXp Realty (808) 725-2794
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202612500"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-781"
}
["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(1) "1"
}
["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(41) "https://www.youtube.com/embed/NBHN4W2a9yQ"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3200000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "Nestled in a private, gated retreat surrounded by lush tropical landscaping, this charming 3-bedroom, 2-bath oceanfront cottage offers breathtaking ocean and sunset views. Located just 100 feet from iconic Three Tables Beach and only 100 yards from Waimea Bay, you'll enjoy world-class kayaking, snorkeling, surfing, swimming, and more just outside your door. The home features granite countertops, stained oak floors, and a Sub-Zero refrigerator, blending timeless island charm with modern comforts. The oceanfront primary suite includes a spa-inspired bath with a sunken soaking tub perfectly positioned to capture the ocean views. Perched above the shoreline on a solid rocky outcropping, the home enjoys an exceptional oceanfront setting. Just steps from Waimea Valley's botanical gardens and minutes from the North Shore's best beaches, hiking, dining, and recreation, this rare property is ideal as a primary residence, vacation home or investment opportunity. Enjoy year-round whale watching, spectacular sunsets and the soothing sound of the surf from the comfort of your own private oceanfront retreat. Experience the beauty, privacy, and lifestyle of one of Hawaii's most coveted locations."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1049"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["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) "One"
}
["View"]=>
array(1) {
[0]=>
string(38) "Coastline,Garden,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["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(15) "bgwvrdr@aol.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Ralph S Gray"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19546362"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-07-18T16:12:37.390"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-06-28"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(16) "Ocean,Waterfront"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "16:12:37.390"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27438831"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27438831"
[1]=>
string(8) "27438832"
[2]=>
string(8) "27438833"
[3]=>
string(8) "27438834"
[4]=>
string(8) "27438835"
[5]=>
string(8) "27438836"
[6]=>
string(8) "27438837"
[7]=>
string(8) "27438838"
[8]=>
string(8) "27438839"
[9]=>
string(8) "27438840"
[10]=>
string(8) "27438841"
[11]=>
string(8) "27438842"
[12]=>
string(8) "27438843"
[13]=>
string(8) "27438844"
[14]=>
string(8) "27438845"
[15]=>
string(8) "27438846"
[16]=>
string(8) "27438847"
[17]=>
string(8) "27438848"
[18]=>
string(8) "27438849"
[19]=>
string(8) "27438850"
[20]=>
string(8) "27438851"
[21]=>
string(8) "27438852"
[22]=>
string(8) "27438853"
[23]=>
string(8) "27438854"
[24]=>
string(8) "27438855"
[25]=>
string(8) "27438856"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202612500
)
[StreetNumber] => Array
(
[0] => 59-781
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 1
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/NBHN4W2a9yQ
)
[ListPrice] => Array
(
[0] => 3200000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Nestled in a private, gated retreat surrounded by lush tropical landscaping, this charming 3-bedroom, 2-bath oceanfront cottage offers breathtaking ocean and sunset views. Located just 100 feet from iconic Three Tables Beach and only 100 yards from Waimea Bay, you'll enjoy world-class kayaking, snorkeling, surfing, swimming, and more just outside your door. The home features granite countertops, stained oak floors, and a Sub-Zero refrigerator, blending timeless island charm with modern comforts. The oceanfront primary suite includes a spa-inspired bath with a sunken soaking tub perfectly positioned to capture the ocean views. Perched above the shoreline on a solid rocky outcropping, the home enjoys an exceptional oceanfront setting. Just steps from Waimea Valley's botanical gardens and minutes from the North Shore's best beaches, hiking, dining, and recreation, this rare property is ideal as a primary residence, vacation home or investment opportunity. Enjoy year-round whale watching, spectacular sunsets and the soothing sound of the surf from the comfort of your own private oceanfront retreat. Experience the beauty, privacy, and lifestyle of one of Hawaii's most coveted locations.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6000.00
)
[SqftTotal] => Array
(
[0] => 1049
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 0.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => bgwvrdr@aol.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 725-2794
)
[ListAgentFullName] => Array
(
[0] => Ralph S Gray
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19546362
)
[MatrixModifiedDT] => Array
(
[0] => 2026-07-18T16:12:37.390
)
[ListingContractDate] => Array
(
[0] => 2026-06-28
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:12:37.390
)
[_thumbnail_id] => Array
(
[0] => 27438831
)
[listing_image] => Array
(
[0] => 27438831
[1] => 27438832
[2] => 27438833
[3] => 27438834
[4] => 27438835
[5] => 27438836
[6] => 27438837
[7] => 27438838
[8] => 27438839
[9] => 27438840
[10] => 27438841
[11] => 27438842
[12] => 27438843
[13] => 27438844
[14] => 27438845
[15] => 27438846
[16] => 27438847
[17] => 27438848
[18] => 27438849
[19] => 27438850
[20] => 27438851
[21] => 27438852
[22] => 27438853
[23] => 27438854
[24] => 27438855
[25] => 27438856
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 6,000 sf
- Living (sf): 1,049
- Year Built: 1973
- Property Condition: Above Average
- Number of Parking Spaces: 3
- View: Coastline,Garden,Mountain,Ocean,Sunset
- Listing Office: eXp Realty
- Maintenance Fees: $0
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 18, 2026 - 4:12 PM
Information is deemed reliable but not guaranteed.
Copyright: 2026 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.
© Marcus Realty. All Rights Reserved.
