67-290 Farrington Highway

    Waialua, HI 96791
    • $4,998,000
    • STATUS: Active
    • ON SITE: 71 days
    • MLS #: 201925624
    UPDATED: 40 min ago
    $4,998,000
    • 3
      BEDS
    • 103.15
      ACRES
    • 2
      BATHS
    • 1
      1/2 BATHS
    • 4,208
      SQFT
    • $1,188
      $/SQFT
    Neighborhood:
    Type:
    Single-Family Home
    County:
    Area:

    School Information

    Elementary School:
    Middle School:
    High School:

    Description

    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.

    Monthly Payment Calculator



    © 2019 HiCentral MLS, Ltd. All rights reserved.
    Some of the active listings 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.

    IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or Keller Williams Honolulu.

    Licensed in the State of Hawaii, USA.
    www.realtyinhawaii.com/homes/98704608

    67-290 Farrington Highway Waialua, HI 96791

    • Price: $4,998,000
    • Status: Active
    • Updated: 40 min ago
    • MLS #: 201925624
    3
    Beds
    2
    Baths
    1
    ½ Baths
    103.15
    Acres
    4,208
    SQFT
    $1,188
    $/SQFT
    Neighborhood:
    Waialua
    County:
    Oahu
    Area:
    Norshore
    Elementary School:
    Waialua
    Middle School:
    Waialua
    High School:
    Waialua
    Property Description
    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.
    Exterior Features

    Construction Materials Above GroundDouble WallSingle WallWood Frame Location Other Lot Description Other Parking 3 Car+DrivewayGarage Pool None Road Frontage County RdPaved RdUnpaved Rd Roof Wood Shake Sq Ft Garage 671 Sq Ft Lanai Open 1317 Stories Two Style Detach Single Family Topography HillyLevelOther View CoastlineGardenMountainOceanSunrise

    Interior Features

    Floors Ceramic TileHardwood Furnished Partial Inclusions Auto Garage Door OpenerCable TvCeiling FanChandelierConvection OvenDishwasherDisposalDryerFireplaceMicrowaveRange HoodRange/OvenRefrigeratorSatellite DishSmoke DetectorSolar HeaterWasher Remodeled Full Remodeled Year 2012 Sq Ft Roofed Living 2630 Sq Ft Roofed Other 261

    Property Features

    Amenities Bedroom On 1st FloorFull Bath On 1st FloorLandscapedPatio/DeckStorageWorkshop Assessed Value Improvements 546300.00 Assessed Value Land 274700.00 Assessed Value Total 821000.00 Association Fee 200 Association Fee Total 200 Association Fee2 Includes Other Common Expenses Builder Name Glenn Mason Disclosures Property Disclosure Stmt Easements DrivewayElectricOther Flood Zone Zone D Land Recorded Land Court Land Tenure Fs - Fee Simple Listing Financing CashConventional New Construction No Occupancy Owner Possession At Closing Property Condition Excellent Property Subtype Single Family Security Gated Community Setbacks Of Record Special Sale Conditions None Tax Amount 389.98 Tax Paid By Seller No Tax Year 2019 Utilities Available CesspoolGasInternetOverhead ElectricityPrivate WaterUnderground Electricity Zoning 52 - Ag-2 General Agricultural

    Listings provided courtesy of Hawaii Life.
    Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. Listings last updated on 2019-11-17T00:58:45.19. Information is deemed reliable but not guaranteed. Copyright: 2019 by HiCentral MLS, Ltd.


    © 2019 HiCentral MLS, Ltd. All rights reserved.
    Some of the active listings 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.

    IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or Keller Williams Honolulu.

    Licensed in the State of Hawaii, USA.
     
    Keller Williams Honolulu
    1347 Kapiolani Blvd, 3rd Floor
    Honolulu HI, 96814