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;

4465 Aku Rd
Hanalei, HI 96722
Amy Marvin with Hawaii Life, original listing - (800) 370-3848

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,950,000
Beds: 2
Baths: Full: 3
Status: Active
SqFt: 1332 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: 1988
Notes: Enjoy beautiful mountain and waterfall views from this lovely residence in the Heart of Hanalei located just a block and half from the Hanalei Pavillion. This well maintained 2 bedroom/3 bath home also offers an additional large second floor space for flexible use; office, yoga or a second living room, plus an additional multi-use room on the ground floor with a separate entrance. The house features an abundance of indoor storage space plus 2 large locking storage closets in the carport for all of your gear. The large front lanai provides mountain views and ample room for relaxation, and an outdoor shower is perfect for removing sand after a day at the beach. A laundry room and full 3rd bathroom are accessible through a small covered breezeway, allowing separate entrance for quick access from the outdoors. The yard has mature fruit bearing avocado, orange, starfruit and suriname cherry trees as well as a tall privacy hedge and plenty of room for outdoor entertaining. Enjoy the convenient location of a short walk to shopping, dining, yoga and other amenities. Hanalei Bay offers miles of sandy beach with multiple world class surf spots and the spectacular backdrop of Namolokama Mountain range. With a short drive to Ha'ena you can access the Na Pali Coast Trail, Limahuli Botanical Gardens and breathtaking views of Mt. Makana (Bali Hai) as you snorkel, beachcomb or surf at Makua (Tunnels) Beach. Drive in the other direction to Princeville’s dining and shopping and just beyond to the village of Kilauea where you will enjoy the Kilauea Lighthouse Wildlife Refuge and an additional wide variety of dining and shopping choices. Paradise awaits.
MlsNumber: --
ListingId: 716419


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