67-290 Farrington Highway

(Waialua)

1 / 25
67-290 Farrington Highway, North Shore
Call Tracy (808) 372-2274 or use contact form.

Tracy Yamato (RA) CRS

Certified Residential Specialist
RS-51972

Mobile: (808) 372-2274
Email: Tracy@HawaiiLiving.com

"Let my 25+ years of experience work for you. See what some clients say."
Client Testimonials
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
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.

Recent Activity
  • 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,900
  • Sold Furnished: Partially
  • Year Remodeled: 2012
  • Owner, Tax & Resale History: Click here
  • MLS: 201925624
  • Occupancy Type: Owner
  • Elementary School: Waialua
  • Middle School: Waialua
  • High School: Waialua
  • 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 September 20, 2019. Information is deemed reliable but not guaranteed.
67-290 Farrington Highway - listing courtesy Hawaii Life.
- We poured our heart into building this website for you! It took time, money, and effort. If you like it, consider working with us. We will not disappoint.
- We update our site every 1 minute.
Other Waialua Homes
65-200 Poamoho Place
3 Bd | 2.5 Ba | 2,519 sqft
Ocean view
65-1140 Poamoho Street
2 Bd | 1.5 Ba | 1,900 sqft
Ocean view
68-235 Au Street
4 Bd | 3 Ba | 2,370 sqft
Ocean view
66-346 Paalaa Road
2 Bd | 3 Ba | 1,853 sqft
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
61-181 Iliohu Place
3 Bd | 2.5Ba | 2,742 sqft
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 September 20, 2019. Information is deemed reliable but not guaranteed.
67-290 Farrington Highway - listing courtesy Hawaii Life.
- We poured our heart into building this website for you! It took time, money, and effort. If you like it, consider working with us. We will not disappoint.
- We update our site every 1 minute.
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 gplus share on twitter