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;

1630 Olinda Rd
Makawao, HI 96768

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,995,000
Beds: 4
Baths: 5
Status: Pending
SqFt: 5035
Agency: Compass

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1996
Notes: Welcome to an exquisite Upcountry Estate, perfectly positioned halfway up Olinda Rd on a secluded 2+ acre lot, offering breathtaking panoramic views. The meticulously planned layout of the gated property features a stunning 5000+ sqft home at its heart providing both luxury and privacy. The kitchen of the main home is a true masterpiece, featuring a striking focal point in the form of a substantial Spalted Mango island. Custom cabinetry, built-in fridge and dishwashers, and artistic concrete countertops, the kitchen offers a captivating experience with its wall of windows framing the incredible bicoastal views of Maui’s north and south shores. The family room hosts an impressive stone fireplace, seamlessly flowing into the formal dining room, creating an inviting and open living space. Step outside into the sunroom, complete with a new fireplace, leading to the expansive Ipe deck offering ample space for outdoor relaxation and dining. The infinity pool, accompanied by a spa, waterfall, and even a water slide, provides a serene retreat to soak in the mesmerizing views. New pickleball and basketball courts make this full-fenced property a dream for outdoor recreation and entertaining. Back inside, the ground floor primary suite features a walk-in closet and spa bathroom adorned with natural stone. Follow the stunning mango flooring into a dedicated laundry room with a huge mango and koa wood island, multiple sets of laundry machines. Brand new bathrooms throughout, new upstairs carpeting, and fresh paint brighten the interior and exterior. Three bedrooms plus an attached guest suite above the three-car garage offer ample living space. There’s a new roof complete with an owned photovoltaic system to power the property with solar energy, as well as new HVAC ducting for the central heating system and whole-house dehumidifiers. No detail has been overlooked! Nestled among mature citrus trees, bananas, and producing avocados are additional structures to accommodate guests, extended family, or provide work-from-home space. The detached 1 bed/1 bath Ag Office is newly remodeled with open beam ceilings, a loft and a dedicated lanai. There’s also a brand-new large lofted barn/workspace! This private retreat offers an unparalleled opportunity for luxurious living and working from home. Come experience the beauty and versatility of one of Maui’s finest upcountry estates!
MlsNumber: 401578


Listing Provided By: Compass, original listing
Name: Compass
Phone: (808) 762-1796
Office Name: Compass
Office Phone: (808) 762-1796
Agent Name: Christopher Barca
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 Art Manzano
Art Manzano
ASCIIeXp Realty
Call Today!: (808) 276-3248

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App