59-495 Ke Waena Road Haleiwa, HI 96712
Listing
Overview
Price: $4,650,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(45) {
["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) "4650000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "4650000.00"
}
["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) "2024-06-10T16:58:55.157"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17951626"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-20T16:22:41.063"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_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"
}
}
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] => 4650000.00
)
[CurrentPrice] => Array
(
[0] => 4650000.00
)
[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] => 2024-06-10T16:58:55.157
)
[Matrix_Unique_ID] => Array
(
[0] => 17951626
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-20T16:22:41.063
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_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
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,695
- 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
