Hawaii Living

59-459 Ke Waena Rd (Sunset)

1 / 25
59-459 Ke Waena Rd, Haleiwa
Inquire / Showing / Video Tour
Call/Text Tracy (808) 372-2274 or use contact form.
Tracy Yamato

Tracy Yamato (RA) CRS

Certified Residential Specialist
RS-51972

Mobile: (808) 372-2274

Email: Tracy@HawaiiLiving.com

"Let my over 30 years of experience work for you."
Client Testimonials
We are a team of licensed real estate agents with in-depth knowledge of the pros & cons of every North Shore neighborhood. For an informed decision when making your purchase, contact us here at Hawaii Living.
Description
OPEN HOUSE SUNDAY APRIL 21, 2024, NOON TO 5 PM! PLEASE COME!List Price under 4M!! Sellers are motivated! This is a family generation homestead property…all children and grandchildren raised here. Family owned since 1960. On one of the Most Incredible Beachfronts on the entire North Shore! Dramatic Ocean and Sunset Views and right on Rock Pile Beach! Direct view up the coast from Pipeline to Sunset Beach! Not in a Flood Zone & White Sand Beach is protected by "Rock Pile"! The house is a fixer upper but it's a good structure with lots of potential. "In the Action" but just far enough away from Pipeline to make it private! **Owners have just completed a top floor bedroom and full bathroom remodel with new Vinyl Plank flooring, new Jalousie windows** What a difference!
Recent Activity
  • Mar 31, 2024 Price $3,950,000
  • Jan 31, 2024 Price $4,000,000
  • Jan 03, 2024 Listed at $5,500,000
Past Sales
Blog
More Details
  • Owner, Tax & Resale History
  • Price / ft²: $2,633
  • Year Remodeled: 1968
  • Zoning: 05 - R-5 Residential District
  • Flood Zone: Zone X
  • Elementary School: Sunset Beach
  • Middle School: Kahuku
  • High School: Kahuku
  • View: Coastline, Mountain, Ocean, Sunset
  • Furnished: Partial
  • Property Condition: Average
  • Amenities: Landscaped, Patio/Deck, Storage, Wall/Fence
  • TMK: 1-5-9-3-35-0
  • Tax Assessed Land: $3,026,400
  • Tax Assessed Improvements: $593,200
  • Tax Assessed Total: $3,619,600
  • Courtesy: Sterman Realty / (808) 637-6200
  • MLS: 202326437
Ask Tracy a Question
Good to Know
See our aerial video of Sunset homes on Oahu's North Shore.

About Sunset
The Sunset area of the North Shore is generally home to two groups. Surfers and those with the funds to buy homes on these widely envied lands. It's not just professional board riders, current and retired, who have tied their leash permanently here. The top surf companies have bought as well, making the houses their headquarters during the big competitions that happen up here. They can't have their sponsored surfers fighting the traffic with everyone else to reach the beaches on contest day.

You'll still find some   .....
Read more.
The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on April 27, 2024. Information is deemed reliable but not guaranteed.
Other Sunset Homes
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
59-209 Ke Nui Rd
4 Bds | 4 Ba
2,642 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
59-171C Ke Nui Rd
4 Bds | 3 Ba
2,864 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
59-495 Ke Waena Rd
3 Bds | 2 Ba
1,198 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
58-131 Maika Way
7 Bds | 5 Ba
2,440 ft²
Other North Shore Homes
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
65-340 Poamoho Pl
3 Bds | 3 Ba
2,255 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
59-405 Pupukea Rd
4 Bds | 3 Ba
2,128 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
67-241 Kahaone Lp
4 Bds | 3 Ba
1,900 ft²
  • Asking Price: $3,950,000
Description
OPEN HOUSE SUNDAY APRIL 21, 2024, NOON TO 5 PM! PLEASE COME!List Price under 4M!! Sellers are motivated! This is a family generation homestead property…all children and grandchildren raised here. Family owned since 1960. On one of the Most Incredible Beachfronts on the entire North Shore! Dramatic Ocean and Sunset Views and right on Rock Pile Beach! Direct view up the coast from Pipeline to Sunset Beach! Not in a Flood Zone & White Sand Beach is protected by "Rock Pile"! The house is a fixer upper but it's a good structure with lots of potential. "In the Action" but just far enough away from Pipeline to make it private! **Owners have just completed a top floor bedroom and full bathroom remodel with new Vinyl Plank flooring, new Jalousie windows** What a difference!
    The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on April 27, 2024. Information is deemed reliable but not guaranteed.
    • Mar 31, 2024 Price $3,950,000
    • Jan 31, 2024 Price $4,000,000
    • Jan 03, 2024 Listed at $5,500,000
    See our aerial video of Sunset homes on Oahu's North Shore.

    About Sunset
    The Sunset area of the North Shore is generally home to two groups. Surfers and those with the funds to buy homes on these widely envied lands. It's not just professional board riders, current and retired, who have tied their leash permanently here. The top surf companies have bought as well, making the houses their headquarters during the big competitions that happen up here. They can't have their sponsored surfers fighting the traffic with everyone else to reach the beaches on contest day.

    You'll still find some   .....
    Read more.
    Other Sunset Homes
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    59-209 Ke Nui Rd
    4 Bds | 4 Ba
    2,642 ft²
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    59-171C Ke Nui Rd
    4 Bds | 3 Ba
    2,864 ft²
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    59-495 Ke Waena Rd
    3 Bds | 2 Ba
    1,198 ft²
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    58-131 Maika Way
    7 Bds | 5 Ba
    2,440 ft²
    You do not own the land, but have the right to use the land until an expiration year. At expiration the ownership typically reverts back to the land owner.
    Buyer and Seller have reached an agreement and are under contract. However, the sale is still subject to one or more contingencies.
    We have handled many transactions for clients who purchase Hawaii real estate without visiting. By request, we can prepare thorough property videos to ensure you are familiar with every detail necessary. All documents can be signed remotely.
    Buyer and Seller have reached an agreement and are under contract. The sale is expected to close / record soon.
    We will be happy to work with you as a Buyer's agent. Call us to learn more: 808-943-9000.
    Note: A Seller's agent has a fiduciary responsibility towards the Seller. Working with a Buyer's agent objectives and goals are aligned, at no cost to you, the Buyer.
    Other fees could be a special assessment, reserve contributions etc.
    DOM = Days On Market. Our site shows listings immediately. A brand new listing may show DOM 2 or 3 days, if listing agent did not upload the same day listing agreement was executed.
    Includes estimated monthly mortgage payment, maintenance / HOA fees & property taxes. The estimate does not include insurance premiums.
    Learn about property tax rates.