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 = 552 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 = 552 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 = 552 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;

5750-m Olohena Road
Kapaa, HI 96746
Yelena Okhman with RE/MAX Kauai - Princeville Office, original listing - (808) 826-9675

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,750,000
Beds: 3
Baths: Full: 4
Status: Active
SqFt: 2960 Square Feet
Agency: RE/MAX Kauai - Princeville Office
Agency Phone: (808) 826-9675

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: Welcome to your private sanctuary, where elegance, comfort, and nature harmoniously unite. This exceptional estate is designed to seamlessly blend indoor and outdoor living, offering abundant natural light, refreshing breezes, and privacy.<br /> <br /> The main house features a wraparound lanai with solid wood decking, creating a seamless extension of the indoor living areas into the lush outdoors. Inside, the custom-designed kitchen showcases koa and monkeypod cabinetry, a striking granite slab countertop, and premium finishes. With 19-foot vaulted ceilings, tigerwood floors, and a warm, inviting ambiance, every detail has been thoughtfully crafted.<br /> <br /> The home boasts marble bathrooms, including a master bath with a clawfoot tub, walk-in closets, and a spacious pantry. Perfectly designed for convenient family living, this property serves as both a relaxing retreat and a functional compound.<br /> <br /> The estate is surrounded by a mature, meticulously landscaped garden featuring a bounty of producing fruit trees. Enjoy fresh avocados from different varieties, mangoes, starfruit, Surinam cherries, coconuts, pomegranates, mountain apples, noni, bananas, papayas, and more. This tropical oasis offers the ultimate farm-to-table experience, right in your backyard.<br /> <br /> Adding to its versatility, a separate building includes a full bathroom and auxiliary room, ideal for a workshop, gym, yoga studio, art space, or private retreat. This additional structure allows for endless possibilities to suit your lifestyle.<br /> Set in an idyllic location, this one-of-a-kind estate is a rare opportunity to embrace nature, luxury, and practicality in perfect harmony
MlsNumber: --
ListingId: 716180


Listing Provided By: RE/MAX Kauai - Princeville Office, original listing
Phone: (808) 635-6552
Office Phone: (808) 826-9675
Agent Name: Yelena Okhman
Disclaimer: Copyright © 2024 Hawaii Information Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App