67-290 Farrington Highway $5,498,000

    Close

    67-290 Farrington Highway Waialua, HI 96791

    • 3 Beds
    • 3 Baths
    • 4,208 sq.ft.
    • Single Family
    MLS# 201911877 | Active

    $5,498,000

    Request Info
    Days On Market: 52 1 Views
    Add to Favorites Share

    Go Tour This Home

    Schedule A Showing

    Property Details

    A RARE & BREATHTAKING gated estate on 103 acres, surrounded by the seclusion & privacy of hills & mountains w/ Mt Ka'ala as your backdrop. A beautiful country residence & 3-car garage w/connecting work shop - all PERFECTLY sited on a grassy knoll to capture stunning views far below of ocean, agricultural lands & Haleiwa community lights. A PERFECT blend of country & coastal living - 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 with a small herd of approx. 50 grass fed cattle & colorful wild peacocks roaming the acreage. An IDEAL COUNTRY LIFESTYLE surrounded by nature vs people, which includes a variety of fruit trees; avocado, mango, lychee, & bananas.

    • General Features
      • Land Tenure FS - Fee Simple
      • Architectural Style Detach Single Family
      • Subdivision WAIALUA
      • View Coastline, Garden, Mountain, Ocean, Sunrise
      • Year Built 1978
      • Year Remodeled 2012
      • SQFT Roofed Living 2,630
      • Sqft Total 4,208
      • Association Fee Includes Other Common Expenses
    • Building Features
      • Stories Type Two
      • Construction Materials Above Ground, Double Wall, Single Wall, Wood Frame
      • Amenities Bedroom on 1st Floor,Full Bath on 1st Floor,Landscaped,Patio/Deck,Storage,Workshop
      • Flooring Ceramic Tile, Hardwood
      • Inclusions Auto Garage Door Opener,Cable TV,Ceiling Fan,Chandelier,Convection Oven,Dishwasher,Disposal,Dryer,Fireplace,Microwave,Range Hood,Range/Oven,Refrigerator,Satellite Dish,Smoke Detector,Solar Heater,Washer
      • Furnished Partial
      • SQFT Lanai Open 1,317
      • SQFT Roofed Other 261
    • Property Features
      • Lot Size Area 4,493,214
      • Topography Hilly, Level, Other
      • Pool Features None
      • Lot Features Other
      • SQFT Garage Carport 671
      • Parking Features 3 Car+, Driveway, Garage
      • Parking Total 6
      • Utilities Cesspool, Gas, Internet, Overhead Electricity, Private Water, Underground Electricity
    • 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

    $592,500 Median Sales Price
    8 Homes Sold
    9 New On Market

    Average Days on Market

      Properties for Sale

        Property History

        Date Event Price Percent Change
        -- Current Price Source New Value: $5,498,000
        5/5/2019 11:58:00 AM 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 6/27/2019 2:59:08 AM. 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