List Price $4,378,000 Fee Simple ❤
tapoffer.net
103 Acre, Ag-2, ONE OF KIND, PRIVATE country estate! Located at an elevation well above sea level, away from North Shore's traffic congestion. STUNNING OCEAN & Waialua/Haleiwa community VIEWs, cooler temperatures & trades. A BEAUTIFUL home includes 3-car garage w/connecting office-all PERFECTLY sited on a grassy knoll surrounded by space of hills & mountains. An ideal blend of country & coastal living, minutes to world famous beaches, surfing, kayaking, sky diving & historical Haleiwa town/ 26 Miles to Honolulu Int Airport. "STANHOPE FARMS" is a RARELY available legacy ranch w/endless farming opportunity. Enjoy a variety of fruit trees; avocado, mango, lychee, & bananas. Enjoy a PEACEFUL COUNTRY LIFESTYLE surrounded by nature vs people. MULTI-FAMILY possibilities/preliminary CPR.
Virtual Tour
What will it cost to Buy?
What will it cost to own?
Home Affordability Calculator
   Instant Offer
                     
MLS
Public
Single Family
Single Family
ContemporaryProperty Type
Sub Type
67-290 Farrington Hwy67-290-A Farrington Hwy
Waialua HI 96791Waialua Hawaii 96792
North Shore WaialuaWaialua
WaialuaWaialua Elem
WaialuaWaianae Int
WaialuaWaialua High
Nanakuli-Waianae-Complex-AreaComplex
Public SchoolsRank
Glenn Masonna Builder
MLS 202015797TMK 1-6-7-2-38Property ID
33 Bedrooms
22 Full Baths
11Half Baths
2.013Total baths
0Rooms
6na Parking
2,6302,630 Interior sf
1,317 Lanai sf
261Other roofed sf
4,208Total sf
671 Gar/Cpt sf
4,493,2144,493,214 Land sf
$4,378,000 8/12/2020Original list
Sold Status
$3,999,999 Sold price
Fee SimpleFee SimpleTenure
NoFractional
19781978Year built
2012 FullRemodeled
$ 0
$ 0
$ 0
$ 0
Includes:
Association
AOAO fee
AOAO other
Maint fee
AOAO total fees
Coastline
Garden
Mountain
Ocean
Sunrise
View
Hilly
Level
Other
Topography
OtherLand Features
Land CourtRecorded
AG-2 General AgriculturalnaZoning
Zone - DFlood Map
Tsunami Map
Flood
OtherLocation
Of RecordSetbacks
Driveway
Electric
Other
Plat Map & Easements
Parcel Map
ExcellentCondition
Ceramic Tile
Hardwood
Flooring
Wood ShakeRoof
Auto Garage Door Opener
Cable TV
Ceiling Fan
Chandelier
Convection Oven
Dishwasher
Disposal
Dryer
Fireplace
Microwave
Range/Oven
Refrigerator
Satellite Dish
Smoke Detector
Solar Heater
Washer
Inclusions
naExclusions
NonePool
Gated CommunitySecurity
Bedroom on 1st Floor
FBedroom on 1st Floor
Landscaped
Patio/Deck
Storage
Workshop
Amenities
naFrontage
Detach Single FamilyContemporary
Stories
Units
Architecture - sketch
naModel
County Rd
Paved Rd
Unpaved Rd
Road
Cesspool
Gas
Internet
Overhead Electricity
Private Water
Underground Electricity
Utilities
Above Ground
Double Wall
Single Wall
Wood Frame
Materials
TwoStoriesType
Disclosure StmtDisclosures
00Public Report
3 Car+
Driveway
Garage
Parking
naAOAO Name
naAOAO Ph
naManagement Co Name
naManagement Co Ph
OtherBuyer Financing
na1st Mortgagor
na1st Mortgage
na2nd Mortgagor
na2nd Mortgage
No/naForeclosure/Case#
20202020Property tax year
$ 274,700$ 274,700Land assessed
$ 537,300$ 537,300Building assessed
$ 0$ 0Home owner exemption
$ 812,000$ 812,000Total assessed RPAD
$ 386$ 386Tax per month rates
0Total rent
Building Permits
At ClosingPossession
NoneSpecial
Cash
Conventional
Financing
Affordability
Apply Online
PDF application
PartialFurnished
NoNew development
Estimated summary Buyer closing statement
calculated at list price
x PriceTotalBuyer Share
0.188%8,23140.0%3,292+ ALTA Insurance
0.137%6,00050.0%3,000+ Escrow Fee
0%14231 6,292= Sub-total
(37,488)= Sub-Total
4,378,000 4,378,000+ Price
4,340,512= Est Cost to Buy*
* Excluding loan fees, pro-rations, special and sundry fees. Escrow companies and lenders also calculate estimated closing costs for you.
MonthlyCost to own estimate:
$ 386Real Property Tax
$ 0Association Fee
$ 0Lease Rent
$ 386Cost to own
(ex Mortgage, Ins & Elec)
8/12/2020Active
naPrice change
10/6/2020Continue to show
naPending
naTemp withdrawn
naBack on market
naWithdrawn
12/22/2020Off market
12/22/2020Status change
naAdvertise
naAuction
Hawaii LifeListing Firm
julie@garrishawaii.com Listing Participant
9/4/2020Photos uploaded
naSupplement Mod
New listings!
Open Houses
Price reductions
Distressed property: Foreclosures, Short Sales, ect.
Top 25 most expensive homes
Sell your home or condo
Real Estate Laws, Acts, Codes
 
tapoffer.net © is provided by
Hawaii Home + Commercial LLC
1888 Kalakaua Ave C312, Waikiki, Honolulu, HI 96815
DCCA PV License # RB-20174
Affiliated Companies: Global Electronic Commerce LLC · Glass Commercial Properties Inc
 

Click for the BBB Business Review of this Real Estate in Honolulu HI
 

Robin Charles Glass (R), MBA, eng.
Principal Broker, Managing Member
DCCA PV License # RB-20173
Track Record: Top 2% Sales
Ph: (808) 358-1774
Email: glassr@hawaiihome.cc

Mami I. GLASS (MA)
Administrator, Managing Member
Ph: (808) 372-9136
Email: mamiglass@gmail.com

 
MLS and Public Records Databases synchronized every 15 minutes. Includes information from the Multiple Listing Service of HiCentral MLS, Ltd. IDX information is provided exclusively for consumers` personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the information is deemed reliable but not guaranteed. © 2020 by HiCentral MLS, Ltd.