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;

4139 Koaki Pl
Lihue, HI 96766
Catherine Pennell with Keller Williams Honolulu, original listing - (808) 596-2888

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2374 Square Feet
Agency: Keller Williams Honolulu
Agency Phone: (808) 596-2888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Beautiful 3-Bedroom Home in Quiet, Convenient Neighborhood<br /> <br /> Welcome to Puako Subdivision, a charming little neighborhood in the heart of Lihue, Kauai! <br /> This special 3bd, 3ba stucco home is in a beautiful setting with meticulously planned landscaping, surrounded by palm trees & the mountains as its backdrop. As the corner home on a culdesac, it has excellent bones & a new cedar shake roof. The home features plenty of natural light and is perfect for entertaining. The kitchen has plenty of cabinets and counter space for those that love to cook. Enjoy stunning views from every room & lanai throughout the house. <br /> <br /> Key Features:<br /> Grand entrance & detailed landscaping<br /> Spacious rooms with plenty of natural light<br /> Large kitchen & living areas area, ideal for hosting<br /> Beautiful views of the mountains from multiple rooms<br /> Outdoor lounging area for entertaining or to enjoy your morning cup of coffee<br /> <br /> Primary Bedroom Features:<br /> Sitting/office area <br /> Ensuite bathroom has double sinks, walk in shower & soaking tub<br /> 2 Lanais with unique views<br /> <br /> Location Benefits:<br /> Close to shopping, groceries, the mall, Costco, Home Depot, Target, & excellent restaurants<br /> Minutes from hospital<br /> Close to Harbor Mall, Kalapaki Beach, Poipu Beach, world-renowned golf courses<br /> A drive to the amazing hikes of Koke'e & views of the Napali Coast<br /> <br /> Additional Features:<br /> Newly installed roof - Dec 2024<br /> Hardwood floors recently refinished - Nov 2024<br /> Newly installed carpet – Nov 2024<br /> Paint touch up – Dec 2024<br /> <br /> Storage: <br /> Storage unit located in back of house<br /> Laundry room off & shelving kitchen area<br /> Two car garage with plenty of storage area and shelves<br /> Plenty of closets & storage throughout the house & underneath the stairs<br /> <br /> This home is perfect for those seeking a quiet neighborhood with all the conveniences at your fingertips. <br /> <br /> Don't miss out on this opportunity to own a piece of paradise.
MlsNumber: --
ListingId: 716879


Listing Provided By: Keller Williams Honolulu, original listing
Phone: (808) 285-4593
Office Phone: (808) 596-2888
Agent Name: Catherine Pennell
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