Private 103+Acre One-of-A-Kind Estate - North Shore

67-290 Farrington Highway, Waialua, Oahu 96791 Get Directions

SOLD: $3,999,999

 

Bedrooms
3
Full Baths
2
Half Baths
1
Total SqFt
4,208
Lot Size Area
4,493,214 SqFt
Land Tenure
Fee Simple
MLS #
202015797
Request More Info

Overview

RARE & BREATHTAKING! A secluded gated country estate on 103 ACRES nestled on the Waianae mountain range provides the ultimate in privacy surrounded by lush hills and mountains with Mt. Ka’ala as your backdrop. The beautiful residence and three-car garage with connecting workshop are perfectly sited on a grassy knoll to capture UNPARALLELED VIEWS overlooking the ocean, agricultural lands and Haleiwa community lights in the distance. Simply elegant, the home exudes warmth and style that blends in perfectly with the environment.

Newly remodeled in 2012-2013, this beautiful 3 bedroom, 2.5 bath pole home showcases gorgeous Ipe hardwood flooring, high ceilings, brick fireplace for cool evenings, dual mud/laundry room with separate entrance, walk-in closets and great storage. The wrap around cedar decks are perfect for relaxing or entertaining and enjoying the amazing 360-degree views. Large walls of glass capture mountain and ocean views in every direction.  The spacious and open kitchen has plenty of cabinets, a wine refrigerator, microwave/convection oven, gas stove, and gorgeous granite countertops. The ocean view master bedroom includes a deck with stunning coastline vistas. The master bath features green celadon granite counters with travertine floors and shower. Newly built two-car garage features additional single equipment garage and bonus storage/office space located behind the garage.  

“Stanhope Farms” is a peaceful legacy cattle ranch with a herd of approximately 50 grass fed cattle grazing on the expansive grounds. The ideal country lifestyle with awe-inspiring natural surroundings, including a variety of fruit trees (avocado, mango, lychee, lime, banana, papaya), offers an idyllic escape from people and city life. Neighboring active agricultural activity include goats, horses, cacao & macada-mia nut groves. Other possible ventures include equestrian ranching & farming.

This one-of-a-kind gated retreat offers the best of both worlds - tranquil country living and convenient access to the ocean, shops and restaurants. Enjoy exceptional privacy, seclusion, and being surrounded by nature with breathtaking 360-degree vistas from the magnificent North Shore coastline to the heavenly mountain peaks. Yet, the property is just minutes to Haleiwa town and world-famous beaches, surfing, kayaking, fishing and sky diving.  Also conveniently located just 45 minutes to the Honolulu International Airport.

Zoned AG-2, General Agricultural.  MULTI-FAMILY possibilities with proposed CPR map available.

View Slideshow Tour

View 3-D Walk-Through & Floor Plan

Property Details

Amenities
Bedroom on 1st Floor, Full Bath on 1st Floor, Landscaped, Patio/Deck, Storage, Workshop
Sold Date
12/22/2020
Sold Price
$3,999,999
Construction Materials
Above Ground, Double Wall, Single Wall, Wood Frame
Flooring
Ceramic Tile, Hardwood
Furnished
Partial
Location
Other
Neighborhood
Waialua
Parking Features
3 Car+, Driveway, Garage
Parking Total
6
Property Type
Single Family
Security Features
Gated Community
Garage Carport SqFt
671
Living Area SqFt
2,630
Lanai Open SqFt
1,317
Roofed Other SqFt
261
Total SqFt
4,208
Status
Sold
Stories
2
View
Coastline, Garden, Mountain, Ocean, Sunrise
Year Built
1978
Year Remodeled
2012

Additional Property Info

Active Continue To Show Date
10/06/2020
Disclosures
Property Disclosure Stmt
Days on Market
50
Elementary School
Waialua
Flood Zone
Zone D
High School
Waialua
Middle/Junior School
Waialua
Property Condition
Excellent
Roof
Wood Shake
Tax Amount
$386
Tax Assessed Value
$812,000
Tax Assessed Value Improvements
$537,300
Tax Assessed Value Land
$274,700
Topography
Hilly, Level, Other
Utilities
Cesspool, Gas, Internet, Overhead Electricity, Private Water, Underground Electricity
Zoning
52 - AG-2 General Agricultural

Location (Also shows similar listings) Get Directions

Loading map...

Listing Courtesy of Hawaii Life Courtesy of Julianna Garris, Hawaii Life.
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. Information is deemed reliable but not guaranteed. Copyright 2024 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.