67-290 Farrington Highway $4,998,000

    Close

    67-290 Farrington Highway Waialua, HI 96791

    • 3 Beds
    • 3 Baths
    • 4,208 sq.ft.
    • Single Family
    MLS# 201925624 | Active
    Days On Market: 99 45 Views
    Add to Favorites Share

    Go Tour This Home

    Schedule A Showing

    Property Details

    A RARE & BREATHTAKING estate on 103 acres overlooking the scenic North Shore of Oahu, surrounded by the 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 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 w/a small herd of approx. 50 grass fed cattle & a variety of fruit trees; avocado, mango, lychee, & bananas. An IDEAL COUNTRY LIFESTYLE surrounded by nature vs people, perfect for a get-away home or family compound.

    • General Features
      • Land Tenure FS - Fee Simple
      • Architectural Style Detach Single Family
      • Subdivision WAIALUA
      • View Coastline, Garden, Mountain, Ocean, Sunrise
      • Year Built 0
      • Year Remodeled 2012
      • SQFT Roofed Living 2,630
      • Sqft Total 4,208
      • Association Fee $200
      • 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

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

    Market Last 30 Days

    $577,500 Median Sales Price
    10 Homes Sold
    5 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/7/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
        *This Payment Calculator is intended for educational and planning purposes only.
        Based on information from the Multiple Listing Service of Hicentral MLS, Ltd. listings last updated on 12/16/2019 5:58:52 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

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