Hang on a second...
USDAProperties.com is running a little warm 🔥...

 

 

 

$3,900,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
317 Door of Faith Rd
Haiku, HI 96708
5 bed 7 bath 4,468 SqFt ($872/SqFt)
2.0 acre lot. Built 1988
Listed 2023-10-20, Taxes $19,784
May be USDA loan restricted due to income limits
near Kokomo

Introducing Cliff's Edge

Is truly exceptional oceanfront property. Formerly an exclusive vacation destination, this property has been featured in Coastal Living, USA Today Travel and many others. Nestled on the corner of Waipio Bay, at the end of Haikus Door of Faith Road, this magnificent estate offers truly breathtaking views from every room and carefully landscaped grounds, ensuring unparalleled privacy. Perched atop a 350' cliff and strategically positioned to be sheltered from trade winds making it possibly the best parcel on Mauis North Shore. Cliff's Edge provides a serene and tranquil poolside experience - juxtapositioned by the sensory stimuli provided by nature with the sounds of waves crashing, spectacular visuals of whales breaching and breathtaking sunrises and sunsets.

Nearly 5, 000 sf under roof, this custom home was constructed with quality features such as one-inch stucco, Japanese MCA tile roofing, 17 ft. vaulted ceilings and exquisite slate flooring. The main house offers a total of 7 bedrooms, with 5 of them being ensuite for added convenience and luxury. Additionally, the ohana or guest house, offers incredible views, making it the perfect space for hosting friends and family. A third structure on the property presents unlimited possibilities and can be tailored to suit your specific needs. While Cliff's Edge is move-in ready, it is priced to reflect some deferred maintenance, allowing you the opportunity to add your personal touch to enhance its already remarkable allure and particularly its value potential (like buying Apple stock in 1999). This Northshore Unicorn is a rare gem that must be seen to be fully appreciated. Don't miss out on this extraordinary opportunity - contact your favorite agent today to reserve a private viewing of Cliff's Edge.


Presented by Dave Futch at
Compass.
Listing Agent Photo

Property MLS #400042 from Maui

Bedrooms: 5
Primary Bedroom On Main Level: No

Total Bathrooms: 6.5
Full Bathrooms: 6
1/2 Bathrooms: 1

Book Shelves
Ceiling Fan(s)
Dishwasher
Disposal
Dryer
Drapes
Fireplace
Microwave
Range
Refrigerator
TV Cable
Washing Machine
Interior Amenities: Den/Study, Dining Area, Eat-In Kitchen/Nook, Family Room, Laundry Room, Loft, Storage Room, Work Space
Flooring: Stone/Concrete, Carpet, Wood, Vinyl

Pool Features: In-Ground

OceanFront

Lot Size Acres: 2.0
Topography: Gentle Slope
Lot Size Square Feet: 87120

Roads: Paved, Graded, Private

View: Ocean

Storage
Workshop
Maids Quarters
Remodeled
Wall/Fence
Entry
Source Listing Status: ACTIVE
Source Property Type: Residential
Area: Haiku
Source Neighborhood: Haiku
Property Subtype: SF w/Det Ohana or Cottage
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$1,621,800 + $1,120,000
$2,741,800
$19,784
2021$1,456,200 + $1,100,000
$2,556,200
$6,005
2020$1,469,700 + $734,500
$2,204,200
$7,659
2019$1,380,100 + $1,100,000
$2,480,100
$7,971
2018$1,486,400 + $1,100,000
$2,586,400
$8,148
2017$1,407,500 + $900,000
$2,307,500
$7,133
2016$1,373,300 + $900,000
$2,273,300
$6,574
2015$945,700 + $890,000
$1,835,700
$5,479
2014$858,600 + $760,000
$1,618,600
$4,816
2013$854,800 + $720,000
$1,574,800
$4,797
2012$unknown + $252,000
$252,000
$4,611
2010$864,100 + $850,100
$1,714,200
$3,869
2009$894,100 + $1,150,100
$2,044,200
$3,488
2008$844,100 + $1,100,000
$1,944,100
$3,288
2007$783,100 + $1,200,000
$1,983,100
$3,366

Listed 2023-10-20
$3,900,000
Maui
Listing removed 2017-02-04
$2,200,000
Maui
Relisted 2017-01-19
$2,200,000
Maui
Listing removed 2016-10-31
$2,200,000
Maui
Price Changed 2016-10-19
$2,200,000
Maui
Listed 2016-03-07
$2,499,999
Maui
Sold 1991-05-02
$500,000
Public Record
Sold 1989-06-01
$525,000
Public Record
Sold 1985-05-01
$125,000
Public Record

Total Square Feet Living: 3570
Building Exterior Type: Stucco
Construction Materials: Double Wall, Wood Frame
Foundation Details: Concrete Slab
Property Age: 36
Property Condition: Remodeled
Roof: Monier Tile/Tile
House Style: 2 Story
Year Remodeled: 2021

Sewer: Cesspool
Catch Water
Underground Electricity
TV Cable
Water Source: Catch Water

Haiku Elementary School is a public elementary school located approximately 6.5 miles away.
directions icon Map directions

Samuel Enoka Kalama Intermediate School is a public middle school located approximately 7.7 miles away.
directions icon Map directions

King Kekaulike High School is a public high school located approximately 9 miles away.
directions icon Map directions

Roots School is a private elementary and middle school located approximately 2.7 miles away.
directions icon Map directions

Click Thumbnail Images To View Full Size
unknownunknownunknownunknownunknown
house_viewunknownunknownhouse_viewunknown
house_viewunknownunknownhouse_viewhouse_view
unknownunknownunknownunknownunknown
unknownunknownunknown

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.