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;

222 Keoawa St
Lahaina, HI 96761
Joanne Foxxe with Keller Williams Realty Maui-L, original listing - (808) 661-8777

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $16,900,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: 4631 Square Feet
Agency: Keller Williams Realty Maui-L
Agency Phone: (808) 661-8777

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Top of the world in the famous Kapalua Resort at Honolua Ridge II. This gorgeous one level custom home has unobstructed views go the ocean, Molokai and Lanai. The year round sunsets are breathtaking. This gorgeous home is a quiet, private sanctuary. Every detail of this home has been designed for those who enjoy the finer things in life: from the gourmet kitchen with island to the lavish master suite with jacuzzi tub, to the large pool overlooking the sea with amazing views. The chefs kitchen is open to the large eating area, stamped copper double sinks, top of the line appliances: Viking gas stove, 2 dishwashers, Kitchenade refrigerator. There are ample cabinets and deep drawers with organizers for easy access to tools and ingredients. There is also a formal dining room, which is great for entertaining. The large living room with high ceilings has sliders that open to the beautiful lanai and pool/spa area. Great indoor/outdoor Maui living at its best. There is great separation of space with a junior master suite with a separate entrance. There is also a gorgeous office with amazing built ins with a separate entrance. There is a 3-car garage with oversized bays, 2 laundry rooms, 4 instant hot water systems, venetian plaster, travertine flooring, and security system. There are 2 custom fireplaces with custom hand carved Tuscan mantles in the living room and the master bedroom. There are gorgeous travertine pillars. There are copper gutters custom rain chains, beautiful landscaping with fruit trees. The large, covered lanai is perfect for entertaining year-round. This spacious property blends elegance, charm and modern comfort. There are TV's in every bedroom, theater room and living rooms. There is LED lighting, security system, gated property, with gated guarded subdivision. The property is set up for an ohana. There is a pond and privacy. Gorgeous security gate. There is also Kapalua security. Minutes away from world class beaches, dining, shopping and golf. The Kapalua resort is 23,000 acres on West Maui and is home to the first PGA golf tournament of the season.
MlsNumber: --
ListingId: 403622


Listing Provided By: Keller Williams Realty Maui-L, original listing
Phone: (808) 385-2918
Office Phone: (808) 661-8777
Agent Name: Joanne Foxxe
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