SOLD 08/09/2023
Photos
About
Details
Open Houses
Listed by
Buyer agent
Payment calculator
Lot details
Neighborhood
Utilities
Location Details, Documents & Disclosures
Schools
Price history
Taxes
Agent viewpoints
Similar land for sale
Recently sold land
Recently sold homes
Similar homes for sale
Request more info
FAQ
Map View
Virtual Tour
Land sold for $925,000 in 153 days
67-174C Farrington Hwy #2A & 2B Waialua, HI, 96791
Neighborhood: WaialuaOff the market 4.23 acres
Up a scenic gated ranch road, high in the Waialua mountains, this spectacular vacant parcel of land with jaw dropping, panoramic views of the North Shore awaits. Prepare to be awestruck by the ocean & coastline views from this 4.23 acre CPR property nestled under Oahu’s tallest mtn. peak. Unlike other CPR offerings on the market, this property is allowed 1 legal home, or ‘farm dwelling,’ as well as accessory agricultural structures. The owner is seeking a well capitalized buyer who can transform this property into their own agricultural Shangri La. There is a shared well that has been drilled & power is already pulled near the property. The property offered for sale is comprised of 2 CPR units being sold together of a 4 unit Condominium Project Regime (CPR). SHOWN BY APPOINTMENT ONLY: ACCESSED BY A GATED PRIVATE ROAD
Read more
Property details
Oahu county
View
Coastline, Ocean, Sunrise
Land area
184,433 sqft (4.23 acres)
Price per sqft
$5/sqft
Address
67-174C Farrington Hwy #2A & 2B, Waialua, HI, 96791
City of Hawaii
Waialua
Island
Oahu
Land tenure
FS - Fee Simple
Neighborhood
Waialua
District
North Shore
Virtual Tour
Zoning
52 - AG-2 General Agricultural
Open Houses
No upcoming open houses
Listed by
Orion R Barels, Compass
(808) 825-4277
(808) 825-4277
Name
Orion R Barels
License number
RS-64269
Brokerage company
Compass
(808) 825-4277
(808) 825-4277
MLS #
202225399
Buyer agent
Name
Orion R Barels
Brokerage company
Compass
(808) 228-7195
(808) 228-7195
Payment calculator
Calculate your monthly payments
Mortgage
$2,840
Taxes
$606
HOA dues
$0
Mortgage
$185,000 / 20%
2.28%
30 years
Your amount
$2,840 / month
Lot details
TMK #1670020280003
Lot Description
Irregular, Other, Wooded
Parcel #
1670020280003
Waialua neighborhood info
Essentials nearby
Neighborhood stats
Walkability
Coffee shops
—
no data
Bus stop
—
no data
Supermarket
—
no data
Costco
—
no data
Hospital
—
no data
Park
—
no data
Beach
—
no data
Elementary school
—
no data
Middle school
—
no data
High school
—
no data
Local airport
—
no data
People living in Waialua
35%
Families with children
National average: 39%
25%
Non family households
14,778
Population
$126,456
Average Income
Age & gender
Median age 42 years
More info
Commute types
79% commute by car
More info
Education level
30% have high school education
More info
Number of employees
12% work in education and healthcare
More info
Vehicles available
34% have 3 or more
More info
Vehicles by gender
34% have 3 or more
More info
Housing market insights for #2A & 2B
$967.9k
Neighborhood average
sales price*
sales price*
$910k
Neighborhood median
sales price*
sales price*
24
Number
of sales*
of sales*
Housing type
67% are single detacheds
More info
Rooms
41% of the houses have 4 or 5 rooms
More info
Bedrooms
56% have 2 or 3 bedrooms
More info
Owners vs Renters
58% are owners
More info
4.5 / 20
Least Walkable
►
15-20
Most Walkable
10-15
Above Average
5-10
Below Average
1-5
Least Walkable
Walkability according to the National Walkability Index
Utilities
Electricity, Private Water
Utilities
Electricity, Private Water
Location Details, Documents & Disclosures
—
Documents & disclosure
Property Disclosure Stmt
Schools
15 schools with rating up to 10
| School rating | Distance | |
|---|---|---|
|
St Michael School
67-340 Haona Street,
Waialua, HI 96791
Elementary School |
0.454mi | |
| out of 10 |
Waialua High & Intermediate School
67160 Farrington Hwy,
Waialua, HI 96791
Middle School |
0.186mi |
| out of 10 |
Waialua High & Intermediate School
67160 Farrington Hwy,
Waialua, HI 96791
High School |
0.186mi |
| School rating | Distance | |
|---|---|---|
|
St Michael School
67-340 Haona Street,
Waialua, HI 96791
|
0.454mi | |
| out of 10 |
Waialua Elementary School
67020 Waialua Beach Rd,
Waialua, HI 96791
|
0.765mi |
| out of 10 |
Haleiwa Elementary School
66505 Haleiwa Rd,
Haleiwa, HI 96712
|
1.546mi |
| out of 10 |
Sergeant Samuel K Solomon Elementary School
2875 Waianae Uka Avenue,
Wahiawa, HI 96786
|
6.412mi |
| out of 10 |
Hale Kula Elementary School
Waianae and Ayres Ave,
Wahiawa, HI 96786
|
6.651mi |
| School rating | Distance | |
|---|---|---|
| out of 10 |
Waialua High & Intermediate School
67160 Farrington Hwy,
Waialua, HI 96791
|
0.186mi |
|
St Michael School
67-340 Haona Street,
Waialua, HI 96791
|
0.454mi | |
| out of 10 |
Waialua Elementary School
67020 Waialua Beach Rd,
Waialua, HI 96791
|
0.765mi |
| out of 10 |
Haleiwa Elementary School
66505 Haleiwa Rd,
Haleiwa, HI 96712
|
1.546mi |
| out of 10 |
Major Sheldon Wheeler Middle School
2 Wheeler Army Airfield,
Wahiawa, HI 96786
|
8.052mi |
| School rating | Distance | |
|---|---|---|
| out of 10 |
Waialua High & Intermediate School
67160 Farrington Hwy,
Waialua, HI 96791
|
0.186mi |
|
Maranatha Christian Church & Academy
127 N Circle Mauka Street,
Wahiawa, HI 96786
|
8.055mi | |
|
Ho'ala School
1067 California Avenue,
Wahiaw, HI 96786
|
8.277mi | |
| out of 10 |
Kamaile Academy
85180 Ala Akau St,
Waianae, HI 96792
|
8.712mi |
| out of 10 |
Leilehua High School
1515 California Ave,
Wahiawa, HI 96786
|
8.759mi |
School ratings provided by Greatschools.org
© 2023. All rights reserved.
Price history
Sold Aug 9, 2023
Waialua Median sales price 2024
| Bedrooms | Med. price | % of listings |
|---|---|---|
| Not specified | $425k | 0.43% |
| 1 bed | $450.61k | 3.57% |
| 2 beds | $579.95k | 21.41% |
| 3 beds | $761.11k | 39.18% |
| 4 beds | $946.82k | 25.56% |
| 5 beds | $1.21m | 7.2% |
| 6 beds | $1.45m | 1.67% |
| 7 beds | $1.4m | 0.4% |
| 8 beds | $1.4m | 0.38% |
| 9 beds | $1.68m | 0.09% |
| Date | Event | Price | $/sqft | Source |
|---|---|---|---|---|
| Aug 9, 2023 | Sold | $925,000 | 5.02 | Public Record |
| Aug 9, 2023 | Price Decrease | $925,000 -7.31% | 5.02 | MLS #202225399 |
| May 9, 2023 | $998,000 | 5.41 | MLS #202225399 | |
| Dec 8, 2022 | New Listing | $998,000 | 5.41 | MLS #202225399 |
Taxes of 67-174C Farrington Hwy #2A & 2B, Waialua, HI, 96791
52 - AG-2 General Agricultural zoning / MLS #202225399
Current Property Taxes p/month
$605
Assessed Improvement value
$0
Assessed Land value
$1,275,700
Land Recorded
Regular System
Flood Zone
Zone D
Topography
Steep Slope,Up Slope
Total Assessed value
$1,275,700
Tax History
| Year | Taxes | Source |
|---|---|---|
| 2022 | $7,272 | MLS #202225399 |
About Tax & History Data: We obtain the price and history data from public records and / or from local MLS feeds. Please use the contact form on this page if you would like the most up-to-date information.
Agent viewpoints of 67-174C Farrington Hwy #2A & 2B, Waialua, HI, 96791
No reviews yet
Stunning views
Open floorplan
Needs Work
Street noise
We do not have an Agent Viewpoint for this listing yet.
As soon as we do, we post it here.
As soon as we do, we post it here.
Similar land for sale
Similar homes nearby 67-174C Farrington Hwy for sale
Recently sold land
Recently sold homes
Similar homes for sale
Request more info
By pressing SEND, you agree that Verhouse and real estate professionals may call/text you about your inquiry, which may involve use of automated means and prerecorded/artificial voices. You don’t need to consent as a condition of buying any property, goods or services. Message/data rates may apply. You also agree to our Terms of Use. Verhouse does not endorse any real estate professionals.
Frequently Asked Questions about 67-174C Farrington Hwy #2A & 2B
What is 67-174C Farrington Hwy #2A & 2B?
67-174C Farrington Hwy #2A & 2B is a lot of 4.23 acres (about is 184,433 sqft).
What is the full address of this Land?
67-174C Farrington Hwy #2A & 2B, Waialua, HI, 96791.
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. Copyright 2024 by HiCentral Mls, Ltd. Listing courtesy of Compass.
Our company may forward your question(s), email address, phone number, name, and any other information you may provide to a licensed real estate agent in the state where the property you are inquiring about is located. We forward your information to assist you in getting you the answers you are requesting. However, you are not obligated to work with this agent. The agent we forward your information to may or may not be the listing agent for the property. Please discuss with the agent regarding your options for representation. Information deemed reliable but not guaranteed.
Listing last updated: Aug 09, 2023
Verhouse Last checked 2 minutes ago
The 96791 zip area has a population of 14,778, and 35% of the families have children. The median age is 42.86 years and 79% commute by car. The most popular housing type is "single detached" and 58% is owner.