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;

5108 Opelu St
Hanalei, HI 96714
Neal Norman with Hawaii Life, original listing - (800) 370-3848

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $9,500,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2192 Square Feet
Agency: Hawaii Life
Agency Phone: (800) 370-3848

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: This beautifully renovated home in Hanalei offers stunning ocean and mountain views. It features 3 ensuite bedrooms, and everything inside has been recently updated, including Silestone Quartz countertops, cabinetry, designer furnishings, flooring, lighting, fixtures, window coverings, and high-end appliances. The home has vaulted ceilings, plenty of windows, and large sliding glass doors that fill the space with natural light and airflow. The open floor plan connects the kitchen, living, dining, and office areas to several outdoor lanais.<br /> <br /> Located just 25 steps from Hanalei beach, you can enjoy ocean views from the front and breathtaking mountain and waterfall views from the back. The property offers various outdoor living spaces, including covered lanais, breezeways, and a private yard with tropical landscaping.<br /> <br /> In addition to the main house, there are two separate structures: one used as a yoga or art studio and the other with a large loft, perfect for recreational use or as a guest area.<br /> <br /> Key features include:<br /> <br /> -Full guest suites<br /> -Elevator<br /> -Attached 2-car garage and detached boat house<br /> -New hot tub (83” x 83” Vita Prestige with Smart Hardtop)<br /> -New Mitsubishi City Multi-Wall Mounted and Ductless AC System<br /> -Solar panels and a SunPower electric car charging station<br /> -36” gas fire pit with piped-in gas<br /> -Home office/TV room with extra sleeping space<br /> -Custom Ipe deck and outdoor kitchenette with BBQ<br /> -Private courtyard and backyard<br /> -Two outdoor showers with hot/cold water<br /> -Electronic locks for keyless access to garages and elevator<br /> -Security alarm system<br /> <br /> This property offers classic island living with modern amenities in a prime location. Being so close to the sands of Hanalei Bay unlocks a vast variety of activities and water sports, and the great shopping and dining of Hanalei town are all just a short walk or bike ride away.
MlsNumber: --
ListingId: 714112


Listing Provided By: Hawaii Life, original listing
Phone: (800) 370-3848
Office Phone: (800) 370-3848
Agent Name: Neal Norman
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