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;

3593 Kuaaina St
Kalaheo, HI 96741
Joyce Wright Funk with Better Homes and Gardens Real Estate Rainbow Island Properties, original listing - (808) 212-1980

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,000
Beds: 4
Baths: Full: 2, ¾: 2
Status: Active
SqFt: --
Agency: Better Homes and Gardens Real Estate Rainbow Island Properties
Agency Phone: (808) 212-1980

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11,523 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Luxurious Coastal Living in Kalaheo: A Rare Gem on the Garden Isle<br /> PANORAMIC OCEAN VIEWS and RAINBOWS!!!<br /> Nestled in the Kakela Makai OceanView subdivision in Kalaheo, Kauai. This custom-built residence offers unparalleled views of the South Coast, from breathtaking sunrises to serene sunsets. Imagine waking up to the sight of rainbows arching over the ocean making this truly magical.<br /> Comfortable Living in the Heart of Paradise<br /> Kalaheo is renowned for cooler temperatures & gentle breezes, ensuring a comfortable climate year-round. This property encompasses a main home and a separate studio apartment above the detached 2-car garage, ideal for generating additional income or providing a private retreat for family & guests.<br /> Main Home: Spacious and Elegant<br /> Living Area : 2,592 sqft Bedrooms : 3 Bathrooms : 3 (recently remodeled) The main house features solid 3/4" maple floors throughout, adding a touch of warmth and elegance. Upstairs, a vast living area and kitchen await, perfect for entertaining. The entrance foyer and stairwell are adorned with a contemporary stainless steel and aluminum railing system, leading to the Great Room.<br /> The kitchen boasts stunning Blue Pearl granite countertops, complementing the home's sophisticated aesthetic. Enjoy the convenience of a new, full-sized washer and dryer on the ground floor, adjacent to the bedrooms.<br /> Outdoor Living at Its Finest<br /> Two expansive covered lanais, each 360 sqft, provide incredible ocean views. The upstairs lanai offers a unique vantage point to observe mother whales and their calves during the migration season.<br /> Studio Apartment: Cozy and Private<br /> Living Area : 576 sqft Features : Full kitchen & bath, ocean & mountain views The studio apartment is a perfect blend of functionality & style, offering a serene living space with panoramic views.<br /> Additional Features<br /> 2-Car Garage : 576 sqft HOA Fees : $81/month Fees include: swimming pool, jacuzzi, showers, recreation room, & barbecue facilities.<br /> Prime Location<br /> Situated just up the street from Kukuiolono Park and Golf Course, this home offers easy access to outdoor activities and leisurely strolls.
MlsNumber: --
ListingId: 711785


Listing Provided By: Better Homes and Gardens Real Estate Rainbow Island Properties, original listing
Phone: (808) 639-2767
Office Phone: (808) 212-1980
Agent Name: Joyce Wright Funk
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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 Claire Spyer
Claire Spyer
ASCIIWai`oli Properties
Call Today!: (808) 278-8200

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App