Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 551 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 551 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 551 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

4510 Waha Pl
Haiku, HI 96708
Bonnie McCrystal with Keller Williams Realty Maui-Ka, original listing - (808) 270-1046

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,475,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2985 Square Feet
Agency: Keller Williams Realty Maui-Ka
Agency Phone: (808) 270-1046

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Privacy and elegance await you at the end of a quiet cul de sac, where 4510 Waha Place stands as a sanctuary amidst the tropical splendor of Haiku. This exceptionally maintained estate is less than a 9-mile scenic drive from the quaint town of Paia, providing a serene retreat that’s close enough to conveniences but far from the ordinary. Boasting an impressive interior, this expansive home features voluminous open living areas graced with soaring wood-beamed ceilings that create a grand atmosphere. The generously-sized rooms are complemented by high-end finishes, and privacy that is second to none. The gourmet kitchen serves as the heart of the home, equipped with stainless steel appliances, granite countertops, and a dining bar all set against a backdrop of breathtaking greenery visible through a large picture window and sliding glass doors. The primary suite is a spacious haven with a sumptuous en suite bathroom with a soaking tub and separate shower. Sliding glass doors invite you to an exclusive outdoor living space on the lanai, a sanctuary for relaxation. The upper level is completed by two additional bedrooms that share a deluxe bathroom outfitted with travertine and granite. The entire upper level is wrapped on all four sides by 1,888 sq/ft of lanai space, offering a private expanse to savor the fragrant morning blooms, relish in the melodious bird songs, practice yoga or meditation, and dine privately outdoors. The lower level extends to 825 sq/ft with a private entrance, and includes two versatile bedrooms rooms with closets, a full bath, a living area and more. Its separate covered carport area presents multiple possibilities for living arrangements or an in-law suite. A hobbyist's dream awaits in the expansive 2-car garage and workspace, yielding an additional 1,170 sq/ft for creative pursuits, storage, or workshop activities. Enhance an eco-friendly lifestyle with a fully-owned PV system, and solar hot water, ensuring your energy costs are kept remarkably low. 4510 Waha Place isn’t just a home; it's a lifestyle offering the perfect blend of luxury, privacy, and harmony with nature, situated only 16 minutes from Seabury Hall School, 13 minutes to Hookipa Beach, and a half hour to the Kahului airport. This is Lot 1 of a CPR, and some furnishings may be available. Seize this rare opportunity to own a slice of Maui paradise!
MlsNumber: --
ListingId: 401681


Listing Provided By: Keller Williams Realty Maui-Ka, original listing
Phone: (808) 868-8673
Office Phone: (808) 270-1046
Agent Name: Bonnie McCrystal
Disclaimer: Copyright © 2024 Realtors ® Association of Maui, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 551 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Tyler MacArthur
Tyler MacArthur
ASCIIHawaii Life - MacArthur Team Maui
Call Today!: (808) 283-6064

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App