Skip main navigation
Off market
  • $3,143,500

    54-154 Hauula Hmstd Rd, Hauula, HI 96717

    0beds
    3baths
    75,225sqft
    SingleFamily
    Built in 2021
    1.7 Acres Lot
    $3,143,500 Zestimate®
    $42/sqft
    $5,302 Estimated rent

    Home value

    $3,143,500

    $1.98M - $5.25M

    $5,302/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $5,302/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $5,302/mo

    Rent Zestimate®

    Refinance and save

    $14,023/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $14,023/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    PRICE DRASTICALLY REDUCED!!! OCEAN VIEW! IMPROVED ACREAGE! This 1.7 acre property lies against state conservation land and the beautiful Koolau Mountains on the Hawaiian island of Oahu. Located on the desirable windward side, it is zoned AG-2 and has many possibilities for a custom dream home, private retreat, equestrian estate, or farm. The ocean and mountain views are breathtaking. FULLY IMPROVED LAND, over $150K in improvements. The property has been landscaped and is ready to build. The lot has been graded and terraced with rock walls built to maximize the property. The lot is leveled in the middle and slopes upward to another level site pad at the top of the property. Just completed 3 terraced walls on the front of the property and a paved driveway. Great for horses with a grass riding arena. Blueprints for an elegant custom home are available. There are well maintained mature fruit trees such as, lime, avocado,grapefruit, and guava. All trees produce good fruit. This rare property is close to state hiking trails and minutes to gorgeous white sand beaches. City water service has been installed and electrical service and cable is readily available. Septic tank required. On a county maintained paved road. Great location, only 25 minutes from Kaneohe on the windward side of Oahu. Live your dream on this property! Wear your walking shoes. To appreciate this property you must walk this lot. You cannot see it driving by. Land Property, Area: Approximately 1.72 acre(s), Lot is 75225 sq. ft., Hill/mountain view, Waterview, rectangle shaped lot; 90ft wide at road. Buyer is responsible for their own financing. WILL CONSIDER ALL REASONABLE OFFERS. NEW PRICE: $525,000MLS#1107980

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 0
    • Bathrooms: 3
    Features
    • Flooring: Other
    Interior area
    • Total interior livable area: 75,225 sqft

    Property

    Features
    • Exterior features: Other
    Lot
    • Size: 1.70 Acres
    Details
    • Parcel number: 540050240000

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary
    Materials
    • Other
    • Foundation: Other
    • Roof: Other
    Condition
    • Year built: 2021

    Community & neighborhood

    Location
    • Region: Hauula

    Price history

    DateEventPrice
    1/31/2024Listing removed$2,500,000$33/sqft
    Source: HiCentral MLS #202306986 Report a problem
    4/14/2023Listed for sale$2,500,000$33/sqft
    Source: HiCentral MLS #202306986 Report a problem
    9/2/2022Listing removed$2,500,000$33/sqft
    Source: HiCentral MLS #202201797 Report a problem
    2/24/2022Price change$2,500,000-16.7%$33/sqft
    Source: HiCentral MLS #202201797 Report a problem
    1/28/2022Listed for sale$3,000,000+471.4%$40/sqft
    Source: HiCentral MLS #202201797 Report a problem
    3/24/2021Listing removed--
    Source: Owner Report a problem
    8/28/2012Listing removed$525,000+16.7%$7/sqft
    Source: Owner Report a problem
    4/20/2012Sold$450,000-14.3%$6/sqft
    Source: Public Record Report a problem
    2/29/2012Listed for sale$525,000-4.4%$7/sqft
    Source: Owner #2807589 Report a problem
    12/31/2011Listing removed$549,000$7/sqft
    Source: Owner #2807589 Report a problem
    8/4/2011Listed for sale$549,000-31.3%$7/sqft
    Source: Owner #2807589 Report a problem
    3/24/2011Listing removed$799,000$11/sqft
    Source: Owner Report a problem
    4/8/2009Price change$799,000+14.3%$11/sqft
    Source: Owner Report a problem
    1/17/2009Price change$699,000-6.8%$9/sqft
    Source: Owner Report a problem
    9/23/2008Price change$750,000-11.8%$10/sqft
    Source: Owner Report a problem
    5/19/2008Price change$849,999-13.7%$11/sqft
    Source: Owner Report a problem
    7/5/2007Listed for sale$985,000+535.5%$13/sqft
    Source: Owner Report a problem
    3/2/2001Sold$155,000+15400%$2/sqft
    Source: Public Record Report a problem
    6/15/2000Sold$1,000
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$4,968 +11.9%$1,539,500 +21.4%
    2024$4,438 +118.9%$1,268,100 +118.9%
    2023$2,028 +9.1%$579,300 +9.1%
    2022$1,859 $531,000
    2021-- $531,000
    2020-- $531,000
    2019$1,859 +25%$531,000 +25%
    2018$1,487 +10%$424,800 +10%
    2017$1,352 +14.3%$386,200 +14.3%
    2016$1,183 +2.9%$337,900 +2.9%
    2015$1,149 $328,300 +9.7%
    2014-- $299,300

    Find assessor info on the county website

    Neighborhood: 96717

    Nearby schools

    GreatSchools rating
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $3,143,500
    2% more
    +$62,870
    With Zillow Showcase(estimated)
    $3,206,370