59-495 Ke Waena Road Haleiwa, HI 96712
Listing
Overview
Price: $4,270,000
Area: SUNSET AREA
Status: Active
Location, location, LOCATION! Situated at Log Cabins, which is arguably one of the best stretches of beach on the "7-Mile Miracle", you don't need to look any further for your ideal North Shore beach house. Surfing, swimming, white sand beaches, and stunning year-round sunsets are just outside your door. The main level of the home consists of 2 bedrooms and 1 full bathroom, plus there is a bonus studio downstairs with an additional full bathroom and kitchenette, all of which has been immaculately renovated and well maintained. With a modern kitchen and spacious living room with breathtaking ocean views, a large lanai ideal for hosting BBQs, a beautifully landscaped yard, an outside shower, and more for maximum comfortability, this is the perfect island retreat!
In the summertime, snorkel and swim out front or just enjoy your day basking on the beach. During the winter, watch the surfers from the deck and catch a glimpse of the passing whales! Enjoy strolling the bike path, which passes in front of the home and stretches for 3.5 shady, lush miles.
This is truly paradise found! Listing by: Sterman Realty (808) 780-5673
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202408680"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-495"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Ke Waena"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4270000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1099) "Location, location, LOCATION! Situated at Log Cabins, which is arguably one of the best stretches of beach on the "7-Mile Miracle", you don't need to look any further for your ideal North Shore beach house. Surfing, swimming, white sand beaches, and stunning year-round sunsets are just outside your door. The main level of the home consists of 2 bedrooms and 1 full bathroom, plus there is a bonus studio downstairs with an additional full bathroom and kitchenette, all of which has been immaculately renovated and well maintained. With a modern kitchen and spacious living room with breathtaking ocean views, a large lanai ideal for hosting BBQs, a beautifully landscaped yard, an outside shower, and more for maximum comfortability, this is the perfect island retreat!
In the summertime, snorkel and swim out front or just enjoy your day basking on the beach. During the winter, watch the surfers from the deck and catch a glimpse of the passing whales! Enjoy strolling the bike path, which passes in front of the home and stretches for 3.5 shady, lush miles.
This is truly paradise found!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman 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) "5695.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1540"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1970"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(28) "Garden,Mountain,Ocean,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) "STER"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "sophia@sterman.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 780-5673"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Sophia L Miller"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-04-07T06:01:29.710"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17951626"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26173561"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26173561"
[1]=>
string(8) "26173562"
[2]=>
string(8) "26173563"
[3]=>
string(8) "26173564"
[4]=>
string(8) "26173565"
[5]=>
string(8) "26173566"
[6]=>
string(8) "26173567"
[7]=>
string(8) "26173568"
[8]=>
string(8) "26173569"
[9]=>
string(8) "26173570"
[10]=>
string(8) "26173571"
[11]=>
string(8) "26173572"
[12]=>
string(8) "26173573"
[13]=>
string(8) "26173574"
[14]=>
string(8) "26173575"
[15]=>
string(8) "26173576"
[16]=>
string(8) "26173577"
[17]=>
string(8) "26173578"
[18]=>
string(8) "26173579"
[19]=>
string(8) "26173580"
[20]=>
string(8) "26173581"
[21]=>
string(8) "26173582"
[22]=>
string(8) "26173583"
[23]=>
string(8) "26173584"
[24]=>
string(8) "26173585"
[25]=>
string(8) "26173586"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-04-18"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "06:01:29.710"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202408680
)
[StreetNumber] => Array
(
[0] => 59-495
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ke Waena
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 4270000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Location, location, LOCATION! Situated at Log Cabins, which is arguably one of the best stretches of beach on the "7-Mile Miracle", you don't need to look any further for your ideal North Shore beach house. Surfing, swimming, white sand beaches, and stunning year-round sunsets are just outside your door. The main level of the home consists of 2 bedrooms and 1 full bathroom, plus there is a bonus studio downstairs with an additional full bathroom and kitchenette, all of which has been immaculately renovated and well maintained. With a modern kitchen and spacious living room with breathtaking ocean views, a large lanai ideal for hosting BBQs, a beautifully landscaped yard, an outside shower, and more for maximum comfortability, this is the perfect island retreat!
In the summertime, snorkel and swim out front or just enjoy your day basking on the beach. During the winter, watch the surfers from the deck and catch a glimpse of the passing whales! Enjoy strolling the bike path, which passes in front of the home and stretches for 3.5 shady, lush miles.
This is truly paradise found!
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5695.00
)
[SqftTotal] => Array
(
[0] => 1540
)
[YearBuilt] => Array
(
[0] => 1970
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Mountain,Ocean,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] => STER
)
[ListAgentEmail] => Array
(
[0] => sophia@sterman.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 780-5673
)
[ListAgentFullName] => Array
(
[0] => Sophia L Miller
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-04-07T06:01:29.710
)
[Matrix_Unique_ID] => Array
(
[0] => 17951626
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26173561
)
[listing_image] => Array
(
[0] => 26173561
[1] => 26173562
[2] => 26173563
[3] => 26173564
[4] => 26173565
[5] => 26173566
[6] => 26173567
[7] => 26173568
[8] => 26173569
[9] => 26173570
[10] => 26173571
[11] => 26173572
[12] => 26173573
[13] => 26173574
[14] => 26173575
[15] => 26173576
[16] => 26173577
[17] => 26173578
[18] => 26173579
[19] => 26173580
[20] => 26173581
[21] => 26173582
[22] => 26173583
[23] => 26173584
[24] => 26173585
[25] => 26173586
)
[ListingContractDate] => Array
(
[0] => 2024-04-18
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 06:01:29.710
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,695 sf
- Living (sf): 1,540
- Year Built: 1970
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Garden,Mountain,Ocean,Sunset
- Listing Office: Sterman Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Sunset Beach
- Middle School: Kahuku
- High School: Kahuku
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on April 7, 2025 - 6:01 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.
© Marcus Realty. All Rights Reserved.