67-290 Farrington Highway $4,998,000

    Close

    67-290 Farrington Highway Waialua, HI 96791

    • 103.15 Acres
    • Land
    MLS# 201925690 | Active

    $4,998,000

    Request Info
    Days On Market: 7 0 Views
    Add to Favorites Share

    Go Tour This Home

    Schedule A Showing

    Property Details

    A RARE & BREATHTAKING 103 acres overlooking the scenic North Shore of Oahu, surrounded by the PRIVACY of hills & mountains w/Mt Ka'ala as your backdrop. This SPECIAL property includes a BEAUTIFUL COUNTRY RESIDENCE + 3-car garage w/connecting work shop-all PERFECTLY sited on a grassy knoll to capture STUNNING views below of ocean, agricultural lands & Haleiwa community lights. A PERFECT location minutes to world famous beaches, surfing, kayaking, fishing, sky diving & historical Haleiwa town/ 45 Minutes to Hnl Int Airport. STANHOPE FARMS is a PEACEFUL LEGACY cattle ranch w/a small herd of approx. 50 grass fed cattle & a variety of fruit trees; avocado, mango, lychee, & bananas. IDEAL for a get-away home, family compound or possibilities of other agricultural use. This property is AMAZING!

    • General Features
      • Land Tenure FS - Fee Simple
      • Subdivision WAIALUA
      • Possible Use Business, Farm, Multi Family, Other, Single Family
      • Land Use Agricultural
      • Improvements Access Rd, Driveway, Landscaped, Underground Utilities, Walls/Fenced
      • View City, Coastline, Garden, Mountain, Ocean, Sunrise
      • Association Fee $200
    • Property Features
      • Lot Size Area 4,493,214
      • Topography Hilly, Level, Other, Up Slope
      • Lot Features Other
      • Utilities Cable, Electricity, Private Water, Telephone, Underground Electricity
      • Sewer Cesspool
      • Restrictions Other
    • Schools
      • Elementary School Waialua
      • Middle School Waialua
      • High School Waialua

    Contact

    Neighborhood

    96791 (Waialua) Demographics

    37Median Age
    204Population Density (per sq. mile)
    39%College Educated
    $73,871 Estimated Median Income
    1,357Estimated Total Home Owners
    949Estimated Total Renters
    59% / 41%Estimated Owner / Renter Divide
    3Estimated Average Household Size
    7,609Total Population
    Community data courtesy of LiveBy, Inc.

    Market Last 30 Days

    $700,000 Median Sales Price
    9 Homes Sold
    17 New On Market

    Average Days on Market

      Properties for Sale

        Property History

        Date Event Price Percent Change
        -- Current Price Source New Value: $4,998,000
        9/6/2019 10:58:00 PM New in Database Source

        Payment Calculator

        $0 per month
        Year Fixed, Interest
        Principal and Interest
        $0
        Property Taxes
        Homeowners' Insurance

        Home Price
        Down Payment
        Based on information from the Multiple Listing Service of Hicentral MLS, Ltd. listings last updated on 9/14/2019 10:59:08 PM. All information is deemed reliable but is not guaranteed and should be independently verified. All properties are subject to prior sale or withdrawal. Data may not be reproduced or redistributed and may not be used for any purpose other than individual consumer's personal, non-commercial use to identify prospective properties consumers may be interested in purchasing. Copyright: 2019 by HiCentral MLS, Ltd.
        Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company’s active listing, you may speak to one of our agents regarding your options for representation.

        Oahu Real Estate

        Big Island of Hawaii Real Estate

        Kauai Real Estate

        Maui Real Estate

        Hawaii Real Estate

        Cheryl Dillon, RB-18551, James W. Wright, RB-16206, 1-800-735-2100