Listing
Overview
Price: $2,985,000
Area: SUNSET AREA
Status: Active
Location, location, location! Beautifully renovated legal duplex with deeded beach access in the desirable Rocky Pt neighborhood. Tucked off the main road on a quiet private beachside lane, it’s somehow both hidden and central to one of the North Shore’s most versatile beaches. Whether you surf, paddle, snorkel, or stroll the sand, Rocky Pt offers it all. Walk to world-famous waves like Sunset Beach and Pipeline, or to lesser-known, uncrowded spots. Adjacent bike path provides safe access to school, neighborhood park, Ted’s Bakery, Foodland, Sharks Cove, and more. In 2016, the original home was lifted, expanded, and renovated with thoughtful, eco-friendly finishing touches throughout. Designed to harness cooling trade winds and scenic views, the primary home has 3 beds, 1.5 baths, and a covered deck that's perfect for relaxing and entertaining. The second unit is a charming 1 bed, 1 bath—ideal for guests, in-laws, or rental income. Covered parking under the house, office area, outdoor showers, and ample room for home gym, workshop, surfboard storage, etc. Embrace the laidback North Shore lifestyle at this exceptional Rocky Point home where comfort and coastal living come together. Listing by: Team Real Estate, Inc. (808) 497-0036
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202521375"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(14) "59-199 A and B"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Ke Nui"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["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(41) "https://player.vimeo.com/video/1126054237"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2985000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1207) "Location, location, location! Beautifully renovated legal duplex with deeded beach access in the desirable Rocky Pt neighborhood. Tucked off the main road on a quiet private beachside lane, it’s somehow both hidden and central to one of the North Shore’s most versatile beaches. Whether you surf, paddle, snorkel, or stroll the sand, Rocky Pt offers it all. Walk to world-famous waves like Sunset Beach and Pipeline, or to lesser-known, uncrowded spots. Adjacent bike path provides safe access to school, neighborhood park, Ted’s Bakery, Foodland, Sharks Cove, and more. In 2016, the original home was lifted, expanded, and renovated with thoughtful, eco-friendly finishing touches throughout. Designed to harness cooling trade winds and scenic views, the primary home has 3 beds, 1.5 baths, and a covered deck that's perfect for relaxing and entertaining. The second unit is a charming 1 bed, 1 bath—ideal for guests, in-laws, or rental income. Covered parking under the house, office area, outdoor showers, and ample room for home gym, workshop, surfboard storage, etc. Embrace the laidback North Shore lifestyle at this exceptional Rocky Point home where comfort and coastal living come together."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Team Real Estate, Inc."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "4250.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2198"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1949"
}
["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(22) "Garden,Mountain,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) "TEAM"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "dougcole@hawaii.rr.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 497-0036"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(9) "Doug Cole"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19007668"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-15T13:37:27.980"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-10-13"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "13:37:27.980"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27184827"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27184827"
[1]=>
string(8) "27184828"
[2]=>
string(8) "27184829"
[3]=>
string(8) "27184830"
[4]=>
string(8) "27184831"
[5]=>
string(8) "27184832"
[6]=>
string(8) "27184833"
[7]=>
string(8) "27184834"
[8]=>
string(8) "27184835"
[9]=>
string(8) "27184836"
[10]=>
string(8) "27184837"
[11]=>
string(8) "27184838"
[12]=>
string(8) "27184839"
[13]=>
string(8) "27184840"
[14]=>
string(8) "27184841"
[15]=>
string(8) "27184842"
[16]=>
string(8) "27184843"
[17]=>
string(8) "27184844"
[18]=>
string(8) "27184845"
[19]=>
string(8) "27184846"
[20]=>
string(8) "27184847"
[21]=>
string(8) "27184848"
[22]=>
string(8) "27184849"
[23]=>
string(8) "27184850"
[24]=>
string(8) "27184851"
[25]=>
string(8) "27184852"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202521375
)
[StreetNumber] => Array
(
[0] => 59-199 A and B
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ke Nui
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1126054237
)
[ListPrice] => Array
(
[0] => 2985000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Location, location, location! Beautifully renovated legal duplex with deeded beach access in the desirable Rocky Pt neighborhood. Tucked off the main road on a quiet private beachside lane, it’s somehow both hidden and central to one of the North Shore’s most versatile beaches. Whether you surf, paddle, snorkel, or stroll the sand, Rocky Pt offers it all. Walk to world-famous waves like Sunset Beach and Pipeline, or to lesser-known, uncrowded spots. Adjacent bike path provides safe access to school, neighborhood park, Ted’s Bakery, Foodland, Sharks Cove, and more. In 2016, the original home was lifted, expanded, and renovated with thoughtful, eco-friendly finishing touches throughout. Designed to harness cooling trade winds and scenic views, the primary home has 3 beds, 1.5 baths, and a covered deck that's perfect for relaxing and entertaining. The second unit is a charming 1 bed, 1 bath—ideal for guests, in-laws, or rental income. Covered parking under the house, office area, outdoor showers, and ample room for home gym, workshop, surfboard storage, etc. Embrace the laidback North Shore lifestyle at this exceptional Rocky Point home where comfort and coastal living come together.
)
[ListOfficeName] => Array
(
[0] => Team Real Estate, Inc.
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 4250.00
)
[SqftTotal] => Array
(
[0] => 2198
)
[YearBuilt] => Array
(
[0] => 1949
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Mountain,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => TEAM
)
[ListAgentEmail] => Array
(
[0] => dougcole@hawaii.rr.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 497-0036
)
[ListAgentFullName] => Array
(
[0] => Doug Cole
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19007668
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-15T13:37:27.980
)
[ListingContractDate] => Array
(
[0] => 2025-10-13
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 13:37:27.980
)
[_thumbnail_id] => Array
(
[0] => 27184827
)
[listing_image] => Array
(
[0] => 27184827
[1] => 27184828
[2] => 27184829
[3] => 27184830
[4] => 27184831
[5] => 27184832
[6] => 27184833
[7] => 27184834
[8] => 27184835
[9] => 27184836
[10] => 27184837
[11] => 27184838
[12] => 27184839
[13] => 27184840
[14] => 27184841
[15] => 27184842
[16] => 27184843
[17] => 27184844
[18] => 27184845
[19] => 27184846
[20] => 27184847
[21] => 27184848
[22] => 27184849
[23] => 27184850
[24] => 27184851
[25] => 27184852
)
)
- BedsTotal: 4
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 4,250 sf
- Living (sf): 2,198
- Year Built: 1949
- Property Condition: Above Average
- Number of Parking Spaces: 6
- View: Garden,Mountain,Sunset
- Listing Office: Team Real Estate, Inc.
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 15, 2025 - 1:37 PM
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.
© Marcus Realty. All Rights Reserved.