MLS® 201925624 (Hawaii Real Estate) is located at 67-290 Farrington Hwy Waialua HI 96791 in WAIALUA . The current listing status is Active. This 3 bed and 3 bath Home was built in 0 and features 4208 finished sq.ft with a lot size of 103.15 acres. This property is currently listed for an *asking* price of $4,998,000 (Fee Simple) - please call for an explanation of fee simple vs leasehold. Buying Real Estate in Hawaii is very different from the mainland. We can help. 808-298-2030 Click Here to read customer Reviews from people who have worked with this agent.
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.
Bedroom on 1st Floor, Full Bath on 1st Floor, Landscaped, Patio/Deck, Storage, Workshop
Cesspool, Gas, Internet, Overhead Electricity, Private Water, Underground Electricity
Coastline, Garden, Mountain, Ocean, Sunrise
Above Ground, Double Wall, Single Wall, Wood Frame
Based on information from the Multiple Listing Service of the Honolulu Board of REALTORS®. active listings last updated on September 20th, 2019 at 6:38am HST. Information is deemed reliable but not guaranteed. Copyright: 2019 by the Honolulu Board of REALTORS®.
Listing 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.
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.
Listing information last updated on September 20th, 2019 at 6:38am HST.