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;

1831 Poipu Rd
Koloa, HI 96756
Kat Ouano Mobley with eXp Realty, original listing - (808) 725-2794

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,195,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1329 Square Feet
Agency: eXp Realty
Agency Phone: (866) 549-8527

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 1999
Notes: Close to the beach! This ground floor active Vacation Rental has been renovated and is being sold fully furnished, turnkey complete with the cool luxury of A/C! A great location and ideal floor plan with not just two, but three lanais, this first floor unit welcomes you to enjoy your time on the sunny south shore of Poipu.<br /> <br /> Accommodate up to 6 guests comfortably with a king bed in the primary bedroom with en suite primary bathroom and private lanai, 2 twin beds in the secondary bedroom with it’s own lanai and access to adjacent full bathroom, and a pull out queen sofa bed in the spacious living room also with its own lanai. This unit was renovated in 2022 with the following:<br /> <br /> * Fully functioning central A/C<br /> * New and upgraded flooring<br /> * New trim and paint<br /> * New couch, loveseat, and beds<br /> * New light fixtures and ceiling fans<br /> * New televisions<br /> * New dishwasher and kitchen amenities<br /> <br /> Regency at Poipu Kai has 2 pools and jacuzzis exclusively for the project and an additional pool, hot tub, tennis club, with both tennis and pickleball and restaurant in Poipu Kai, a lovely 70-acre community. Located on the greenbelt between the world renowned Grand Hyatt and Shipwrecks beach, and to Brennecke's Beach the choice is yours whether you will spend your days at the famous Poipu Bay Golf Course or watch the turtles come in at Poipu Beach Park. Each with easy access being just a short distance from your front door. <br /> <br /> HOA fees include basic cable/internet, 24-hour security, and beautifully landscaped grounds.<br /> <br /> Whether you choose to use this as your primary residence, second home, or vacation rental investment property, your Kauai dream starts here.<br /> <br /> Unbranded video: https://seehouseat.com/public/vtour/display/2288447?idx=1#!/
MlsNumber: --
ListingId: 715134


Listing Provided By: eXp Realty, original listing
Phone: (808) 635-3383
Office Phone: (808) 725-2794
Agent Name: Kat Ouano Mobley
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.


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 = 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;
Real Estate Expert Photo for Mark K. Tanaka
Mark K. Tanaka
ASCIIKaua'i Realty, Inc
Call Today!: (808) 639-0367

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App