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 = 3357 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 3357 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 3357 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;

158 Brightwater Drive
Clearwater, FL 33767

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,199,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2794
Agency: Coldwell Banker

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2017
Notes: Experience the epitome of waterfront luxury in this exquisite 3-story end-unit townhome, boasting 2,794 square feet of elegantly appointed indoor/outdoor living space. Nestled in the serene backdrop of the intracoastal waterway and bay/harbor, this property is a mere 3 blocks from the sun-drenched shores of Clearwater Beach. Three a/c units all 2017. Nest Thermostats on all (3) floors. Private Boat Slip: Private 40’ Slip Deep Water Dock with electric, water and Wifi! 10,000 lb Electric Boat Lift and a Jet Ski Lift. (4) minutes to Intracoastal and (10) minutes to Gulf of Mexico. Attached 2-car garage with a 50 AMP NEMA 14-50R electric vehicle charging outlet. Luxury Vinyl and Tile throughout. Crown molding throughout home. Fresh Interior Paint: Newly painted interior for a pristine finish. 10' ceilings, solid core 8' doors. Impact Glass/Storm Windows. First floor features welcoming foyer/media room and entertainment area with views of the private dock. Covered patio area overlooking the water. Second Floor features a spacious open floor plan with living, dining and kitchen. Conducive to today's lifestyle this culinary kitchen offers - stainless steal appliances, white Shaker cabinetry, Quartz countertops, center island ideal for entertaining guests, stunning backsplash and plenty of counter space. First bedroom on the second floor with a walk in closet, separate bathroom showcasing vanity with quartz countertop and a beautiful walk in glass door shower. A covered balcony with stunning views of the intracoastal and bay for your early morning coffee or nightcap. Third Floor features grand primary bedroom with breathtaking water views and a private balcony. Walk in California dream closet. En suite bathroom features stunning double vanity, quartz countertop, tub, separate glass door shower. Additional two bedrooms and one bathroom located on third floor. This community is patrolled by security, ensuring a safe and secure environment. Community features resort style salt water pool, spa, gas grills and a beach rinse off station. This property offers a unique blend of luxury, comfort, and stunning waterfront views, making it an ideal choice for those seeking an exceptional living experience in Clearwater Beach. Fantastic opportunity: MINIMUM 3-day rental.
MlsNumber: U8224084


Listing Provided By: Coldwell Banker, original listing
Name: Coldwell Banker
Phone: (813) 251-3030
Office Name: COLDWELL BANKER REALTY
Office Phone: (813) 253-2444
Agent Name: Terry Tillung
Disclaimer: Copyright © 2024 Stellar MLS. 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 = 3357 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 Sacha Haywood
Sacha Haywood
ASCIIImpact Realty Tampa Bay
Call Today!: (813) 312-6512

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App