Hawaii Living

59-029 Holawa St#D (Sunset (Oahu))

1 / 18
59-029 Holawa St #D, Haleiwa
Inquire / Showing / Video Tour
Call/Text Tracy (808) 372-2274 or use contact form.
Tracy Yamato

Tracy Yamato

Certified Residential Specialist
Realtor, RS-51972

Mobile: (808) 372-2274

Email: Tracy@HawaiiLiving.com

"Let my over 30 years of experience work for you."
Client Testimonials
We are expert real estate agents who have sold in Sunset (Oahu). We would be happy to assist you too.
Description
Nestled in the heart of one of the most coveted coastal neighborhoods, the "Point" House at Sunset Point offers an unparalleled opportunity to own a slice of paradise. Never before listed, this exceptional property boasts stunning, unobstructed views of the world-famous Sunset surf break. With its prime location and a tranquil, laid-back atmosphere, this is the perfect place to create your dream beach retreat.Adjacent to the "Carriage" House, also for sale (MLS 20246668, TMK 1-5-9-001-110-0003), this is a rare opportunity to acquire one or both properties for a truly remarkable investment. Combined, these two homes offer 102 feet of beach frontage and come complete with a legal rock revetment wall, providing both beauty and stability along the shoreline.Whether you're looking to build, renovate, or simply enjoy as-is, this beachfront property offers limitless potential in one of the most desirable locations along the coast. Don't miss your chance to own a piece of Sunset Point — an area known for its surf, sunsets, and sought-after coastal living.Click on the film reel!
Recent Activity
  • Nov 14, 2024 Listed at $3,800,000
Past Sales
Blog
More Details
  • Owner, Tax & Resale History
  • Price / ft²: $2,461
  • Year Remodeled: 1950
  • Zoning: 05 - R-5 Residential District
  • Flood Zone: Zone VE
  • Elementary School: Sunset Beach
  • Middle School: Kahuku
  • High School: Kahuku
  • View: Coastline, Mountain, Ocean, Sunset
  • Furnished: None
  • Property Condition: Average
  • Security Features: Key
  • Amenities: None, Full Bath on 1st Floor, Maids/Guest Qrters, Patio/Deck, Wall/Fence
  • TMK: 1-5-9-1-110-4
  • Tax Assessed Land: $2,185,100
  • Tax Assessed Improvements: $328,300
  • Tax Assessed Total: $2,513,400
  • Courtesy: Sterman Realty / (808) 637-6200
  • MLS: 202426554
Ask Tracy a Question
Good to Know
See our aerial video of Sunset homes on Oahu's North Shore.

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 of the older,   .....
Read more.
The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on December 20, 2024.Information is deemed reliable but not guaranteed.
Other Sunset (Oahu) 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
$3,450,888
59-329 Ke Nui Rd
3 Bds | 2 Ba
1,704 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
$4,270,000
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
$4,350,000
59-075 Hoalua St
4 Bds | 2 Ba
1,700 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
$4,795,000
59-557 Ke Iki Rd#A
3 Bds | 2.5 Ba
1,350 ft²
Other Hawaii 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
  • Photo
  • Photo
  • Photo
  • Photo
$3,800,000
34-144 KAIHUIKI RD
4 Bds | 5.5 Ba
3,760 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$3,800,000
3300 Keha Dr
3 Bds | 3 Ba
2,484 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
  • 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
$3,795,000
85 Pukolu Pl
5 Bds | 4 Ba
4,232 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
  • Photo
  • Photo
  • Photo
  • Photo
$3,779,000
2963 PUA ALANI PL
7 Bds | 4.5 Ba
4,179 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
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$3,750,000
47 Wailau Pl##A
3 Bds | 3 Ba
2,606 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
$3,750,000
45-3514 NANAINA KAI RD
6 Bds | 6.5 Ba
8,736 ft²
  • Asking Price: $3,800,000
Description
Nestled in the heart of one of the most coveted coastal neighborhoods, the "Point" House at Sunset Point offers an unparalleled opportunity to own a slice of paradise. Never before listed, this exceptional property boasts stunning, unobstructed views of the world-famous Sunset surf break. With its prime location and a tranquil, laid-back atmosphere, this is the perfect place to create your dream beach retreat.Adjacent to the "Carriage" House, also for sale (MLS 20246668, TMK 1-5-9-001-110-0003), this is a rare opportunity to acquire one or both properties for a truly remarkable investment. Combined, these two homes offer 102 feet of beach frontage and come complete with a legal rock revetment wall, providing both beauty and stability along the shoreline.Whether you're looking to build, renovate, or simply enjoy as-is, this beachfront property offers limitless potential in one of the most desirable locations along the coast. Don't miss your chance to own a piece of Sunset Point — an area known for its surf, sunsets, and sought-after coastal living.Click on the film reel!
    The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on December 20, 2024.Information is deemed reliable but not guaranteed.
    • Nov 14, 2024 Listed at $3,800,000
    See our aerial video of Sunset homes on Oahu's North Shore.

    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 of the older,   .....
    Read more.
    Other Sunset (Oahu) 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
    $3,450,888
    59-329 Ke Nui Rd
    3 Bds | 2 Ba
    1,704 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
    $4,270,000
    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
    $4,350,000
    59-075 Hoalua St
    4 Bds | 2 Ba
    1,700 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
    $4,795,000
    59-557 Ke Iki Rd#A
    3 Bds | 2.5 Ba
    1,350 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.