SOLD 05/13/2022
Photos
About
Details
Open Houses
Interior Features
Listed by
Buyer agent
Payment calculator
Exterior Features
Lot details
Neighborhood
Schools
Price history
Taxes
Agent viewpoints
Similar homes for sale
Recently sold homes
Request more info
FAQ
Map View
Home sold for $1,670,000 in 119 days
54-174 Hauula Homestead Rd Hauula, HI, 96717
Neighborhood: HauulaOff the market 3 beds 5 full + 1 half baths 3,384 sqft
Timeless lifestyle living with magnificent sunrise ocean views. Whale watch from your balcony while experiencing the peace and serenity this this 76,000 square foot property has to offer. This property features full bathrooms in every room, separate mother in law unit, ample parking, and much more!
Read more
Property details
3,384 sqft interior area
Property type
Home
Interior area
3,384 sqft
Open Lanai area
200 sqft
View
Mountain, Ocean
Land area
76,236 sqft (1.75 acres)
Price per sqft
$493/sqft
Address
54-174 Hauula Homestead Rd, Hauula, HI, 96717
City of Hawaii
Hauula
Island
Oahu
Sold price
$1,670,000
Total area
4,869 sqft
nr.of parking places
10
Style
Detach Single Family
Year Built
1994
Land tenure
FS - Fee Simple
Neighborhood
Hauula
District
Kaneohe
Stories
Two
Open Houses
No upcoming open houses
Interior Features
10 parking places, Ceramic Tile, Other floors
Beds
3
Baths
5 full + 1 half
Floors
Ceramic Tile, Other
Stories
Two
Property Condition
Average
Parking
10
Garage & Parking
3 Car+, Boat, Carport, Driveway
Inclusions
AC Split, Ceiling Fan, Dryer, Photovoltaic – Leased, Range/Oven, Refrigerator, Washer
Amenities
Bedroom on 1st Floor, Full Bath on 1st Floor, Patio/Deck, Storage
Listed by
William P Lindsey Jr., Marlene's Realty, Inc.
Name
William P Lindsey Jr.
License number
RS-74074
Brokerage company
Marlene's Realty, Inc.
MLS #
202202925
Buyer agent
Name
Sean Hungerford
Brokerage company
Forward Realty
(808) 548-2366
(808) 548-2366
Payment calculator
Calculate your monthly payments
Mortgage
$5,128
Taxes
$315
HOA dues
$0
Mortgage
$334,000 / 20%
2.28%
30 years
Your amount
$5,128 / month
Exterior Features
Masonry/Stucco construction and more
Roof
Composition
Utilities
Overhead Electricity, Public Water, Septic
Construction
Masonry/Stucco
Pool
None
Lot details
TMK #1540050200000
Lot Description
Clear
Parcel nr.
1540050200000
Hauula 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 Hauula
45%
Families with children
National average: 39%
19%
Non family households
11,792
Population
$120,700
Average Income
Age & gender
Median age 31 years
More info
Commute types
75% commute by car
More info
Education level
34% have high school education
More info
Number of employees
12% work in education and healthcare
More info
Vehicles available
35% have 2 vehicle
More info
Vehicles by gender
35% have 2 vehicle
More info
Housing market insights for
$937.78k
Neighborhood average
sales price*
sales price*
$779.6k
Neighborhood median
sales price*
sales price*
29
Number
of sales*
of sales*
Housing type
62% are single detacheds
More info
Rooms
48% of the houses have 4 or 5 rooms
More info
Bedrooms
62% have 2 or 3 bedrooms
More info
Owners vs Renters
50% are owners
More info
11.5 / 20
Above Average
►
15-20
Most Walkable
10-15
Above Average
5-10
Below Average
1-5
Least Walkable
Walkability according to the National Walkability Index
Schools
5 schools with rating up to 6
| School rating | Distance | |
|---|---|---|
| out of 10 |
Hauula Elementary School
54046 Kamehameha Hwy,
Hauula, HI 96717
Elementary School |
0.382mi |
| out of 10 |
Hauula Elementary School
54046 Kamehameha Hwy,
Hauula, HI 96717
Middle School |
0.382mi |
|
Asia Pacific International School
54-230 Kamehameha Highway,
Hauula, HI 96717
High School |
0.783mi | |
| School rating | Distance | |
|---|---|---|
| out of 10 |
Hauula Elementary School
54046 Kamehameha Hwy,
Hauula, HI 96717
|
0.382mi |
|
Asia Pacific International School
54-230 Kamehameha Highway,
Hauula, HI 96717
|
0.783mi | |
| School rating | Distance | |
|---|---|---|
| out of 10 |
Hauula Elementary School
54046 Kamehameha Hwy,
Hauula, HI 96717
|
0.382mi |
|
Asia Pacific International School
54-230 Kamehameha Highway,
Hauula, HI 96717
|
0.783mi | |
| School rating | Distance | |
|---|---|---|
|
Asia Pacific International School
54-230 Kamehameha Highway,
Hauula, HI 96717
|
0.783mi | |
School ratings provided by Greatschools.org
© 2023. All rights reserved.
Price history
Sold May 13, 2022
Hauula Median sales price 2024
| Bedrooms | Med. price | % of listings |
|---|---|---|
| Not specified | $425k | 0.44% |
| 1 bed | $451.73k | 3.59% |
| 2 beds | $579.23k | 21.42% |
| 3 beds | $760.57k | 39.18% |
| 4 beds | $947.44k | 25.54% |
| 5 beds | $1.21m | 7.18% |
| 6 beds | $1.47m | 1.67% |
| 7 beds | $1.39m | 0.41% |
| 8 beds | $1.4m | 0.38% |
| 9 beds | $1.7m | 0.1% |
| Date | Event | Price | $/sqft | Source |
|---|---|---|---|---|
| May 13, 2022 | Sold | $1,670,000 | 493.5 | Public Record |
| May 13, 2022 | Price Decrease | $1,670,000 -24.09% | 493.5 | MLS #202202925 |
| Mar 18, 2022 | Pending | $2,200,000 | 650.12 | MLS #202202925 |
| Feb 15, 2022 | New Listing | $2,200,000 +22.29% | 650.12 | MLS #202202925 |
| Jan 28, 2022 | Withdrawn | $1,799,000 | 531.62 | MLS #202119574 |
| Sep 20, 2021 | Price Decrease | $1,799,000 -4.71% | 531.62 | MLS #202119574 |
| Jul 28, 2021 | New Listing | $1,888,000 | 557.92 | MLS #202119574 |
Taxes of 54-174 Hauula Homestead Rd, Hauula, HI, 96717
52 - AG-2 General Agricultural zoning / MLS #202202925
Current Property Taxes p/month
$315
Assessed Improvement value
$632,000
Assessed Land value
$591,300
Land Recorded
Dual Systems
Zoning
52 - AG-2 General Agricultural
Flood Zone
Zone D
Topography
Up Slope
Location
Inside
Total Assessed value
$1,291,400
Tax History
| Year | Taxes | Source |
|---|---|---|
| 2021 | $3,780 | MLS #202202925 |
| 2020 | $3,780 | MLS #202119574 |
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 54-174 Hauula Homestead Rd, Hauula, HI, 96717
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 homes for sale
Similar homes nearby 54-174 Hauula Homestead Rd for sale
Recently sold homes
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 54-174 Hauula Homestead Rd
What is 54-174 Hauula Homestead Rd?
54-174 Hauula Homestead Rd, Hauula, HI, 96717 is a single family home located in the city of Hauula, Hawaii with zipcode 96717. This single family home has 3 bedrooms & 5 full bathrooms + & 1 half bathroom with an interior area of 3,384 sqft.
Which year was this home built?
This home was build in 1994.
Which year was this property last sold?
This property was sold in 2022.
What is the full address of this Home?
54-174 Hauula Homestead Rd, Hauula, HI, 96717.
Are grocery stores nearby?
The closest grocery stores are Foodland, 2.92 miles away.
What is the neighborhood like?
The 96717 zip area has a population of 11,792, and 45% of the families have children. The median age is 31.95 years and 75% commute by car. The most popular housing type is "single detached" and 50% is owner.
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. Copyright 2024 by HiCentral Mls, Ltd. Listing courtesy of Marlene's Realty, Inc..
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: May 13, 2022
Verhouse Last checked 2 minutes ago
The closest grocery stores are Foodland, 2.92 miles away.
The 96717 zip area has a population of 11,792, and 45% of the families have children. The median age is 31.95 years and 75% commute by car. The most popular housing type is "single detached" and 50% is owner.
*Neighborhood & street median sales price are calculated over sold properties over the last 6 months.