We are expert real estate agents who know Haleiwa very well. We would be happy to assist you too.
Description
Unique downtown Haleiwa property with a diversified mixed use tenant profile of multifamily and retail. Centrally located on iconic Haleiwa's high traffic Kamehameha hwy. main thoroughfare, you'll find this gem of a property with two separate single family homes, and a retail/office building leased to an Optometrist w/ an attached studio + a loft area. Both the 3 bed/3 bath single family home and the 2 bed/2 bath single family home boast high end finishes in Indonesian flair w/ materials such as travertine, Balinese greenstone, limestone, granite and more. Fruit trees, extra storage, and ample parking are bonus features of this rare B-1 zoned property. Priced below assessed value. Do not go on property without an appointment - accessed by a 14' wide driveway stem behind future Billabong retail store and 2 parcels away from the Malama market grocery store. Be sure to view the 3D Matterport tour.
Oahu’s North Shore is known for its long stretch of beaches, the big wave surf that rolls in every winter, and a relaxed country feel. Haleiwa homes is located in the downtown area on the North Shore, but it couldn’t be further-removed from the hustle and bustle of Downtown Honolulu and Waikiki. There isn’t one towering office building, skyscraper or hotel to be found here. Traffic eases along Kamehameha Highway through town, which is lined with surf shops, beach boutiques, art galleries and restaurants. Haleiwa is so laid-back that i..... Read more.
The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on December 21, 2024.Information is deemed reliable but not guaranteed.
Sold 3/7/22 at $2,320,000 (List Price: $2,495,000)
Description
Unique downtown Haleiwa property with a diversified mixed use tenant profile of multifamily and retail. Centrally located on iconic Haleiwa's high traffic Kamehameha hwy. main thoroughfare, you'll find this gem of a property with two separate single family homes, and a retail/office building leased to an Optometrist w/ an attached studio + a loft area. Both the 3 bed/3 bath single family home and the 2 bed/2 bath single family home boast high end finishes in Indonesian flair w/ materials such as travertine, Balinese greenstone, limestone, granite and more. Fruit trees, extra storage, and ample parking are bonus features of this rare B-1 zoned property. Priced below assessed value. Do not go on property without an appointment - accessed by a 14' wide driveway stem behind future Billabong retail store and 2 parcels away from the Malama market grocery store. Be sure to view the 3D Matterport tour.
The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on December 21, 2024.Information is deemed reliable but not guaranteed.
Oahu’s North Shore is known for its long stretch of beaches, the big wave surf that rolls in every winter, and a relaxed country feel. Haleiwa homes is located in the downtown area on the North Shore, but it couldn’t be further-removed from the hustle and bustle of Downtown Honolulu and Waikiki. There isn’t one towering office building, skyscraper or hotel to be found here. Traffic eases along Kamehameha Highway through town, which is lined with surf shops, beach boutiques, art galleries and restaurants. Haleiwa is so laid-back that i..... Read more.
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.
"....ensuring you have all the facts...." It’s with immense pleasure that I share my experience with Tracy, a realtor who I wholeheartedly endorse for anyone navigating the O‘ahu real estate market. From day one, communication with Tracy was refreshingly easy. He listens intently, articulates his points clearly, and ensures that every question is answered with precision.
Tracy’s expertise in the local property market is unparalleled. He has a vast network of contacts that proves invaluable in every transaction. It’s not just about having a realtor with knowledge; it’s about having one who can harness that knowledge to connect you with the right people and opportunities.
Over the course of our four-year acquaintance, Tracy has patiently worked to understand our specific needs. For my wife and me, relocating from Texas meant finding a home that wasn't just a space to live, but a place that resonated with our lifestyle and aspirations. Tracy’s approach to real estate goes beyond the transactional aspect; he has an intuitive grasp of what makes a house a home for his clients.
He has been an anchor, offering candid and practical advice. His straightforward feedback has been crucial in helping us discern the best choices for us amidst a sea of possibilities. Navigating the technicalities of real estate can be daunting, but Tracy provided us with the guidance and support needed to understand the finer points, ensuring we made well-informed decisions.
Our professional relationship with Tracy has evolved into a cherished friendship. His integrity and dedication are evident in his every action. He's a realtor who gives you the unvarnished truth, ensuring you have all the facts to make decisions that are right for you.
As our long and sometimes challenging journey to find the perfect home comes to a close, we reflect on the path we’ve traveled with gratitude. Tracy has been more than a realtor; he has been a trusted advisor, a confidant, and a friend. We’re profoundly grateful for his relentless dedication to our cause.
Mahalo, Tracy, for your exceptional service and for being an integral part of our life-changing adventure to find our dream home in the beautiful state of Hawai‘i. I highly recommend. Naoto Ueno - Home Buyer, Kakaako
"....full of knowledge...." We finally did it!!!! We worked with Tracey Yamato at Hawaii Living to get through one of the most confusing processes I've ever been a part of... WOW! Thank goodness for Tracey! Buying a home has been a dream but the actual process is WAY more involved than you might imagine. It can takes months of scouring properties before finding the home you love and only then does the real work begin. Deadlines, paperwork, inspections, contractors to schedule, do's, don'ts etc. etc. etc... it was crazy. There is so much to know and so much paperwork to understand we truly couldn't have done this without Tracey by our side. It is legitimately a full time job to handle all of the deadlines and inspections and there is just no way my partner and I could have kept up with our actual jobs while also managing all of this. Thank goodness Tracey was there every step of the way and so full of knowledge about every little thing that we could have possibly needed to know about. Thank you Tracey for all you did
