Hawaii Living

5451 Opihi St (Aina Haina)

5451 Opihi St, Honolulu
Looking to Purchase Something Similar?
Email Info@HawaiiLiving.com or use below contact form.
We are a team of licensed real estate agents with in-depth knowledge of the pros & cons of every Honolulu neighborhood. For an informed decision when making your purchase, contact us here at Hawaii Living.
Description
Incredible price listed WAY below the LAND assessed value of $1,060,000!!! This is your chance to win a very large, level lot in the upscale area of Aina Haina with 2 homes on one lot! The neighborhood boasts underground electric, ocean views, and beautifully renovated homes enjoying year round trade winds. The property is within walking distance of Kawaikui Beach Park, Foodland, and restaurants like Pieology in Aina Haina town center. Don't miss out on this incredible deal!
Past Activity
  • Aug 27, 2020 Sold for $2,175,000
  • Jul 19, 2020 In Escrow
  • Jul 17, 2020 Listed at $2,175,000
  • Oct 15, 2019 Sold for $950,000
  • Aug 27, 2019 In Escrow
  • Aug 24, 2019 Listed at $1,000,000
Blog
More Details
  • Owner, Tax & Resale History
  • Price / ft²: $575
  • Other Homes Price / ft²
  • Cash vs Financing Buyers
  • Zoning: 03 - R10 - Residential District
  • Flood Zone: Zone X
  • Elementary School: Aina Haina
  • Middle School: Niu Valley
  • High School: Kalani
  • Furnished: None
  • Property Condition: Fair,Needs Major Repair
  • Security Features: Key
  • Amenities: Bedroom on 1st Floor, Full Bath on 1st Floor
  • TMK: 1-3-6-6-86-0
  • Tax Assessed Land: $1,060,000
  • Tax Assessed Improvements: $103,800
  • Tax Assessed Total: $1,163,800
  • Courtesy: Hawaii Life
  • MLS: 201922966
Good to Know
See our aerial video of Aina Haina homes.

Popular Honolulu real estate, Aina Haina is a quiet established neighborhood of around 650 homes in Honolulu located between 2 popular view ridges, Waialae Iki and Hawaii Loa Ridge. Sometimes referred to as ‘the next Kahala’, the properties offer generous, mostly level, lot sizes between 7,500 to 10,000 sq ft. Aina Haina homes for sale are typically valued in the $800K to $1.5M range.

Insight to Aina Haina Homes & Neighborhood
Originally developed in the 1940’s and continued through the 1950’s and 1960’s this a  .....
Read more.
The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on April 24, 2024. Information is deemed reliable but not guaranteed.
Other Diamond Head Region 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
3622A Maunalei Ave
3 Bds | 1 Ba
924 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
1989 9th Ave
3 Bds | 2 Ba
880 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
2061 10th Ave
3 Bds | 1.5 Ba
1,040 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
1351 13th Ave
2 Bds | 1 Ba
735 ft²
Other Honolulu Homes
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
4050B Keanu St
4 Bds | 3 Ba
3,028 ft²
2250 Pauoa Rd
7 Bds | 6 Ba
2,317 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
2375 Makanani Dr
2 Bds | 2 Ba
1,084 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
810 Puunani Pl
5 Bds | 2 Ba
1,276 ft²
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
2015 Waterhouse St
4 Bds | 3 Ba
2,026 ft²
2620 B Date St
3 Bds | 1 Ba
844 ft²
  • Sold 10/15/19 at $950,000
    (List Price: $1,000,000)
Description
Incredible price listed WAY below the LAND assessed value of $1,060,000!!! This is your chance to win a very large, level lot in the upscale area of Aina Haina with 2 homes on one lot! The neighborhood boasts underground electric, ocean views, and beautifully renovated homes enjoying year round trade winds. The property is within walking distance of Kawaikui Beach Park, Foodland, and restaurants like Pieology in Aina Haina town center. Don't miss out on this incredible deal!
    The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on April 24, 2024. Information is deemed reliable but not guaranteed.
    • Aug 27, 2020 Sold for $2,175,000
    • Jul 19, 2020 In Escrow
    • Jul 17, 2020 Listed at $2,175,000
    • Oct 15, 2019 Sold for $950,000
    • Aug 27, 2019 In Escrow
    • Aug 24, 2019 Listed at $1,000,000
    See our aerial video of Aina Haina homes.

    Popular Honolulu real estate, Aina Haina is a quiet established neighborhood of around 650 homes in Honolulu located between 2 popular view ridges, Waialae Iki and Hawaii Loa Ridge. Sometimes referred to as ‘the next Kahala’, the properties offer generous, mostly level, lot sizes between 7,500 to 10,000 sq ft. Aina Haina homes for sale are typically valued in the $800K to $1.5M range.

    Insight to Aina Haina Homes & Neighborhood
    Originally developed in the 1940’s and continued through the 1950’s and 1960’s this a  .....
    Read more.
    Other Diamond Head Region 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
    3622A Maunalei Ave
    3 Bds | 1 Ba
    924 ft²
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    1989 9th Ave
    3 Bds | 2 Ba
    880 ft²
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    2061 10th Ave
    3 Bds | 1.5 Ba
    1,040 ft²
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    1351 13th Ave
    2 Bds | 1 Ba
    735 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.