Hawaii Living

47-578 Hua Pl (Ahuimanu)

1 / 1
47-578 Hua Pl, Kaneohe
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 know Ahuimanu very well. We would be happy to assist you too.
Description
On cul-de-sac in Ahuimanu Hills. Set back from street. Lush surroundings amidst the Koolau mountain range. Seller still clearing/cleaning property. Showings after November 24, 2024.
Recent Activity
  • Oct 15, 2024 Listed at $1,700,000
Past Sales
Blog
More Details
  • Owner, Tax & Resale History
  • Price / ft²: $702
  • Zoning: 04 - R-7.5 Residential District
  • Flood Zone: Zone D
  • View: Mountain
  • Furnished: Negotiable
  • Property Condition: Average,Fair
  • Amenities: Full Bath on 1st Floor
  • TMK: 1-4-7-61-74-0
  • Tax Assessed Land: $895,500
  • Tax Assessed Improvements: $460,399
  • Tax Assessed Total: $1,355,800
  • Courtesy: Pono Realty / (808) 596-8680
  • MLS: 202421129
Ask Tracy a Question
Good to Know
See our aerial video of Temple Valley homes and another video of Ahuimanu homes.

Ahuimanu and Temple Valley are almost an afterthought often when people talk about the neighborhoods in Kaneohe. It's understandable. To get here from the central part of the town, you drive north on a stretch of Kahekili Highway that's nothing but untouched green hills almost the entire way. It almost feels like you're coming into a completely different town when you reach the valley.

The residents are off on your own here, in a sense, protected by the deep green valley walls that encircle them. That soothi  .....
Read more.
The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on November 17, 2024.Information is deemed reliable but not guaranteed.
Other Ahuimanu Homes
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
47-166 Wailehua Rd
10 Bds | 6 Ba
3,356 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
47-688 Lamaula Rd
4 Bds | 2.5 Ba
1,504 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
47-358 Mahakea Rd
5 Bds | 4 Ba
2,006 ft²
Other Kaneohe 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
47-433 Hui Nene St
4 Bds | 2 Ba
1,268 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
47-724 Ahuimanu Lp
4 Bds | 2 Ba
2,386 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
45-510 Pahia Rd
5 Bds | 2 Ba
1,536 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
45-081 Lilipuna Rd
3 Bds | 2.5 Ba
1,917 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
44-129 Kalenakai Pl
4 Bds | 2.5 Ba
1,795 ft²
  • Asking Price: $1,700,000
Description
On cul-de-sac in Ahuimanu Hills. Set back from street. Lush surroundings amidst the Koolau mountain range. Seller still clearing/cleaning property. Showings after November 24, 2024.
    The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on November 17, 2024.Information is deemed reliable but not guaranteed.
    • Oct 15, 2024 Listed at $1,700,000
    See our aerial video of Temple Valley homes and another video of Ahuimanu homes.

    Ahuimanu and Temple Valley are almost an afterthought often when people talk about the neighborhoods in Kaneohe. It's understandable. To get here from the central part of the town, you drive north on a stretch of Kahekili Highway that's nothing but untouched green hills almost the entire way. It almost feels like you're coming into a completely different town when you reach the valley.

    The residents are off on your own here, in a sense, protected by the deep green valley walls that encircle them. That soothi  .....
    Read more.
    Other Ahuimanu Homes
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    47-166 Wailehua Rd
    10 Bds | 6 Ba
    3,356 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
    47-688 Lamaula Rd
    4 Bds | 2.5 Ba
    1,504 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
    47-358 Mahakea Rd
    5 Bds | 4 Ba
    2,006 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.