MLS#:	202416607 * Questions?
Status:	Active since 07-22-2024 See History
Price:	$4,449,000
Rebate:	$ 22,245 from OahuRE.com.
Monthly:	$ 26,316.53 Update the default down payment and interest rate
	Monthly payment estimate for $ 4,449,000 price, 10% down, 6.60% interest rate, 30 year loan, $ 744 taxes, and $ 0 fees. Insurance not included.
Beds:	9 Baths: 6 Half: 1 Parking Spaces: 6
Living Sq Ft:	3,690
Land Sq Ft:	10,309
Land Tenure:	FS - Fee Simple
Address:	54-223 Kamehameha Highway Hauula HI 96717
Region:	Kaneohe - Activity
Neighborhood:	Hauula - Activity * Hauula Stats
Street:	Kamehameha - Activity * Kamehameha Highway Stats
Showing:	Showing Request
Top of Page * Showing Request * Questions?
Original:	$4,449,000
Change:	$0 0.00%
Parcel#:	1-5-4-011-025-0000
Link:	Tax Info/Plat Map/Parcel Map/Sketch
Days:	5 days in Active or In Escrow Showing
Date:	Listed: 07-22-2024
Date:	Status Change: 07-22-2024
Recent History:	Last Sold on 09-13-2023 for $995,000 - MLS# 202313199 - Seller's Agent: Lou Ann Uyeda, Buyer's Agent: Richard O Linke Jr.
Year Built:	1950 Remodeled: 2024
View:	Coastline, Garden, Mountain, Ocean, Sunrise, Sunset
Frontage:	Ocean
Monthly Tax:	$744 Year: 2024
Land:	FS - Fee Simple
Condition:	Excellent
Top of Page * Showing Request * Questions?
Description:
Discover the ultimate coastal retreat in this oceanfront, two-story home. With nine bedrooms, six and a half bathrooms, and five kitchens across two dwellings, it's perfect for large families or entertaining guests. The Ocean Reef coral stone flooring, topaz-adorned bathrooms, and anthracite limestone exude luxury, complemented by rich African mahogany trim throughout. Enjoy over 800 sq ft of second-story decking with unobstructed ocean views, perfect for soaking in the beauty of the horizon. French drains ensure efficient water management, preserving the home's pristine condition. This home offers seamless indoor-outdoor flow, creating an unparalleled living experience. It's not just a residence; it's a lifestyle. Embrace the perfect blend of elegance and nature—make this dream home yours today.


Inclusions: AC Split, Dishwasher, Range/Oven Amenities: Patio/Deck Utilities: Overhead Electricity, Public Water Construction: Above Ground, Double Wall, Other Lot Features: Clear Floor: Other Disclosures: Property Disclosure Stmt Land Recorded: Dual Systems Furnished: None Possession: At Closing Terms: Cash, Conventional Sale Conditions: None
Top of Page * Showing Request * Questions?
Sold Price:
Concession:
Closed:
Sold Ratio:
Days Sold:
Land:	$791,900
Building:	$641,100
Assessed Total:	$1,433,000
Assessed Ratio:	310.47%
Pool:	None
Location:	Other
Parking:	3 Car+, Carport, Driveway
Top of Page * Showing Request * Questions?
District Locator:	DOE Locator to Confirm District
Area Total:	10,309
Acres:	0.2367
Topography:	Level
Building Style:	Detach Single Family, Multiple Dwellings
Building:
New Const:	No
Top of Page * Showing Request * Questions?
Maint. Fee:	$0
Assoc. Fee:	$0
Other Fee:	$0
Includes:
Total Fees:	$0
Exemption:	0
Other:	0
Lanai Sq Ft:	1,261
Garage Sq Ft:	400
Avg Sq Ft Living:	$1,205.69
Avg Sq Ft Land:	$431.56
Security:
Rental Income:	$0
Stories:	Two CPR: No
Zoning:	05 - R-5 Residential District
Flood Zone:	Zone X * Check if this property is in a Flood Zone
Tsunami Zone:	Check if this property is in a Tsunami Zone * Tsunami Info * Oahu Tsunami Map
Roofing:	Asphalt Shingle
Set-Backs:	Of Record Roads: State Hwy
Easements:	None
Top of Page * Showing Request * Questions?
Links:
Google Maps * Supermarkets * Schools * Private Schools * Hospitals * Restaurants * Gyms * Shopping * Attractions * Beaches * Churches * Tax Info including a Plat Map PDF and GIS Parcel Map and Building Sketch
Commuting:
Waikiki * Downtown * Ala Moana * Airport * Kapolei * Hawaii Kai * Kailua Town * Windward Mall * Waikele * North Shore
Barbers Point * Camp Smith * Fort Shafter * Hickam * Lualualei * K-Bay Marine * Pearl Harbor * Schofield * Tripler * Wheeler * VA Mortgage Info
Closing Cost Calculators:
Buyer's Closing Cost Calculator to estimate the buyer's closing cost.
Seller's Closing Cost Calculator to estimate the seller's closing cost.

Listing courtesy of eXp Realty Troy D Krill (808) 426-8104

Top of Page * Showing Request * Questions?

Property History from MLS
Date	MLS#	Change	Old Value	New Value	List Price	Sold Price	Assessed Total	Land	Building
07-22-2024	202416607	New Listing		Active	$4,449,000	$0	$1,433,000	$791,900	$641,100
09-13-2023	202313199	Sold	In Escrow Showing	Sold	$1,050,000	$995,000	$1,572,000	$930,500	$641,500
08-17-2023	202313199	Active Under Contract	Active	In Escrow Showing	$1,050,000	$995,000	$1,572,000	$930,500	$641,500
07-22-2023	202313199	Back On Market	In Escrow Showing	Active	$1,050,000	$995,000	$1,572,000	$930,500	$641,500
07-13-2023	202313199	Active Under Contract	Active	In Escrow Showing	$1,050,000	$995,000	$1,572,000	$930,500	$641,500
06-05-2023	202313199	New Listing	Active	Active	$1,050,000	$995,000	$1,572,000	$930,500	$641,500
03-09-2016	201604542	Withdrawn	Active	Cancelled	$1,250,000	$0	$878,300	$534,600	$343,700
03-03-2016	201604542	New Listing	Active	Active	$1,250,000	$0	$878,300	$534,600	$343,700
11-08-2002	2112281	Temporarily Withdrawn	Active	Active	$699,000	$0	$374,800	$279,500	$95,300
12-16-2001	2112281	New Listing	Active	Active	$699,000	$0	$374,800	$279,500	$95,300
01-17-2001	2000469	Expired	Active	Expired	$699,000	$0	$374,400	$279,600	$94,800
07-11-2000	2000469	Back On Market	Active	Active	$699,000	$0	$374,400	$279,600	$94,800
06-09-2000	2000469	Temporarily Withdrawn	Active	Active	$699,000	$0	$374,400	$279,600	$94,800
01-17-2000	2000469	New Listing	Active	Active	$699,000	$0	$374,400	$279,600	$94,800

Top of Page * Showing Request * Questions?

Comparables

Instant Comparables

Comparables with Options

Multiple Comparable Options

Going more years back returns closer matches.

Listings in Hauula Neighborhood

View listings near this one sorted by the closest listing on the top: 1 Mile, 2 Miles, 3 Miles, 4 Miles, 5 Miles

Top of Page * Showing Request * Questions?

Directions from this property to nearest Grocery Store, Hospital, Gas Station, Beach Park, and Park

View Hauula Neighborhood Boundary

View Tax Records

All Neighborhood Boundaries in the Kaneohe Region

View Full Size in Google Maps

Top of Page * Showing Request * Questions?

Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools

School Map

Top of Page * Showing Request * Questions?

View Directions on Google Maps to nearest Beach Access

View Beach Access Points All Over Oahu including Street View, Directions, and Facilities Info

Top of Page * Showing Request * Questions?


Neighborhoods Near Hauula Shown on Google Earth

Top of Page * Showing Request * Questions?

Google Traffic Maps

Top of Page * Showing Request * Questions?

Estimated Monthly Mortgage Payment

View OahuRE Mortgage and Interest Savings Calculator

Save $75,586.30 of interest charges by adding an extra payment of $100 per month. View details from the link above.

Rate:	5.85%	6.10%	6.35%	6.60%	6.85%	7.10%	7.35%	7.60%	8.10%
0% Down	$26,246	$26,961	$27,683	$28,414	$29,152	$29,899	$30,652	$31,413	$32,956
3.5% Down	$25,328	$26,017	$26,714	$27,419	$28,132	$28,852	$29,580	$30,314	$31,802
10% Down	$23,622	$24,265	$24,915	$25,573	$26,237	$26,909	$27,587	$28,272	$29,660
20% Down	$20,997	$21,569	$22,147	$22,731	$23,322	$23,919	$24,522	$25,131	$26,365
30% Down	$18,373	$18,872	$19,378	$19,890	$20,407	$20,929	$21,457	$21,989	$23,069
40% Down	$15,748	$16,176	$16,610	$17,048	$17,491	$17,939	$18,391	$18,848	$19,774
50% Down	$13,123	$13,480	$13,842	$14,207	$14,576	$14,949	$15,326	$15,707	$16,478