Hawaii Living

67-290 Farrington Highway (Waialua)

1 / 24

67-290 Farrington Highway

(Waialua)

67-290 Farrington Highway, North Shore
Inquire / Schedule Showing
Call agent (808) 372-2274 or use contact form.
Description
A RARE & BREATHTAKING estate, with STUNNING OCEAN VIEWS overlooking the scenic North Shore of Oahu, agricultural lands & Haleiwa community lights. A BEAUTIFUL COUNTRY RESIDENCE & 3-car garage w/connecting work shop-all PERFECTLY sited on a grassy knoll surrounded by the PRIVACY of hills & mountains w/Mt Ka'ala as your backdrop. An ideal 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 grass fed cattle & a variety of fruit trees; avocado, mango, lychee, & bananas. An IDEAL COUNTRY LIFESTYLE surrounded by nature vs people. This BEAUTIFUL property is an opportunity not to miss.
Recent Activity
  • Feb 09, 2020 Listed @ $4.7M
  • Feb 09, 2020 Expired
  • Sep 06, 2019 Listed @ $4.998M
  • Sep 06, 2019 Expired
  • May 05, 2019 Listed @ $5.498M
Recently Sold
(Waialua)
More Details
  • Price / Interior Sf: $1,787
  • Sold Furnished: Partially
  • Year Remodeled: 2012
  • Owner, Tax & Resale History: Click here
  • MLS: 202002833
  • Occupancy Type: Owner
  • High School: Farrington
  • View: Coastline, Garden, Mountain, Ocean, Sunrise
  • Zoning: 52 - AG-2 General Agricultural
  • Flood Zone: Zone D
  • Security Features: Gated Community
  • Amenities: Bedroom on 1st Floor, Full Bath on 1st Floor, Landscaped, Patio/Deck, Storage, Workshop
  • 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
  • TMK: 1-6-7-2-38-0
  • Tax Assessed Land: $274,700
  • Tax Assessed Improvements: $546,300
  • Tax Assessed Total: $821,000
  • Special Sales Terms: None
  •  
The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on February 18, 2020. Information is deemed reliable but not guaranteed.
67-290 Farrington Highway - listing courtesy Hawaii Life.
Other Waialua Homes
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
65-200 Poamoho Place
3 Bd | 2.5 Ba | 2,519 sqft
Ocean view
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
67-221 A Waialua Beach Road
1 Bd | 1 Ba | 672 sqft
Ocean view
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
65-1140 Poamoho Street
2 Bd | 1.5 Ba | 1,900 sqft
Ocean view
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
  • Photo
68-235 Au Street
4 Bd | 3 Ba | 2,370 sqft
Ocean view
About Waialua
See our aerial video of Waialua beachfront homes.

About Waialua Real Estate
Waialua is a sleepy beach town on Oahu’s famous North Shore. It’s almost an entirely residential community, with no commercial center to speak of. However, Haleiwa town, with its restaurants, surf shops, beach boutiques and art galleries, is just 5 minutes away. Much larger and more urban towns like Mililani and Waipahu are also easily accessible to Waialua for shopping at big box stores and national cains. Waialua residents are also conveniently located close to the North Shore beaches and beach parks, which is a major draw for most people who make Waialua their home. In addition, residents savor the peace and quiet you find here, and enjoy feeling like they’re miles away from the development that covers much of Oahu today.

Waialua homes range widely in their age, size and condition. A good majority of the single family homes have 3-5 bedrooms. However, there are houses with as many as  ....click here to read more
Other North Shore Homes
62-196 Kawailoa Drive
3 Bd | 3.5Ba | 2,974 sqft

Asking Price

$4,700,000

Living

2,630 sqft

Baths

2.5

Beds

3

 
 
    Description
    A RARE & BREATHTAKING estate, with STUNNING OCEAN VIEWS overlooking the scenic North Shore of Oahu, agricultural lands & Haleiwa community lights. A BEAUTIFUL COUNTRY RESIDENCE & 3-car garage w/connecting work shop-all PERFECTLY sited on a grassy knoll surrounded by the PRIVACY of hills & mountains w/Mt Ka'ala as your backdrop. An ideal 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 grass fed cattle & a variety of fruit trees; avocado, mango, lychee, & bananas. An IDEAL COUNTRY LIFESTYLE surrounded by nature vs people. This BEAUTIFUL property is an opportunity not to miss.
    Inquire / Schedule Showing
    Call agent (808) 372-2274 or use contact form.
    See our aerial video of Waialua beachfront homes.

    About Waialua Real Estate
    Waialua is a sleepy beach town on Oahu’s famous North Shore. It’s almost an entirely residential community, with no commercial center to speak of. However, Haleiwa town, with its restaurants, surf shops, beach boutiques and art galleries, is just 5 minutes away. Much larger and more urban towns like Mililani and Waipahu are also easily accessible to Waialua for shopping at big box stores and national cains. Waialua residents are also conveniently located close to the North Shore beaches and beach parks, which is a major draw for most people who make Waialua their home. In addition, residents savor the peace and quiet you find here, and enjoy feeling like they’re miles away from the development that covers much of Oahu today.

    Waialua homes range widely in their age, size and condition. A good majority of the single family homes have 3-5 bedrooms. However, there are houses with as many as  ....click here to read more
    • Feb 09, 2020 Listed @ $4.7M
    • Feb 09, 2020 Expired
    • Sep 06, 2019 Listed @ $4.998M
    • Sep 06, 2019 Expired
    • May 05, 2019 Listed @ $5.498M
    Other Waialua Homes
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    65-200 Poamoho Place
    3 Bd | 2.5 Ba | 2,519 sqft
    Ocean view
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    67-221 A Waialua Beach Road
    1 Bd | 1 Ba | 672 sqft
    Ocean view
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    65-1140 Poamoho Street
    2 Bd | 1.5 Ba | 1,900 sqft
    Ocean view
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    • Photo
    68-235 Au Street
    4 Bd | 3 Ba | 2,370 sqft
    Ocean view
    Other North Shore Homes
    62-196 Kawailoa Drive
    3 Bd | 3.5Ba | 2,974 sqft
    The MLS properties are based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on February 18, 2020. Information is deemed reliable but not guaranteed.
    67-290 Farrington Highway - listing courtesy Hawaii Life.
    You do not own the land, but have the right to use the land until an expiration year. At expiration the ownership typically reverts back to the land owner.
    Buyer and Seller have reached an agreement and are under contract. However, the sale is still subject to one or more contingencies.
    Buyer and Seller have reached an agreement and are under contract. The sale is expected to close / record soon.
    We will be happy to work with you as a Buyer's agent. Call us to learn more: 808-943-9000.
    Note: A Seller's agent has a fiduciary responsibility towards the Seller. Working with a Buyer's agent objectives and goals are aligned, at no cost to you, the Buyer.
    Other fees could be a special assessment, reserve contributions etc.
    DOM = Days On Market. Our site shows listings immediately. A brand new listing may show DOM 2 or 3 days, if listing agent did not upload the same day listing agreement was executed.
    Includes estimated monthly mortgage payment, maintenance / HOA fees & property taxes. The estimate does not include insurance premiums.
    Learn more about Oahu property taxes here.
    Share this on:
    share on facebook share on twitter