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 = 182 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 = 182 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 = 182 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;

1542 Riverside Drive
Tarpon Springs, FL 34689

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,829,900
Beds: 5
Baths: 4
Status: Active
SqFt: 2950
Agency: Realtec Group, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2008
Notes: Waterfront paradise!! Incredible 4 story waterfront executive home with elevator built for ultimate Florida living. Nestled along the picturesque Anclote River in charming Tarpon Springs. Nearly 3,000 sq. ft. with 5 bedrooms, 4 full baths, heated saltwater pool and jacuzzi and deep-water access to the Gulf at the mouth of the Anclote River! The home comes with access to a deeded community boat ramp. A rare find! Beautifully designed inside, and a nirvana oasis outside… picturesque pool and spa with natural gas heater, a custom outdoor, private shower, a 30' x 15' Gazebo, housing a full kitchen with gas grill and a full bar with custom concrete counters, all accented at night with magnificent landscape lighting. The incredible architecture brings a Key West vibe to the entire property. Sweeping water views yet privacy prevails. Plenty of room for water toys… the 40ft dock with floating dock lift and a custom fish carving station is currently set up for 25' boat. Two minutes by boat to the Gulf of Mexico!! Entertaining and family space is abundant and extends to the additional square footage of the downstairs bonus room that is not included in the living square feet. And because they’ve thought of everything, an indulgent elevator can transport you to and from the home’s central living spaces. The second-floor houses three bedrooms, a full bath, a gathering room and convenient laundry room. It also boasts a fully covered balcony perfect for dolphin watching! The 3rd floor offers a main living space with a fabulous kitchen boasting high end appliances, beautiful cabinetry, working breakfast bar with prep sink, convection oven microwave, designer granite counters, Wolf gas range with posh hood, plus a pantry and a substantial eat-in dining area. A convenient guest bath is nearby, and the main living area is a site to behold… sweeping water views and French doors to a magnificent balcony begging for morning coffee or afternoon cocktails! The third floor is also home to the first primary suite with a stunning spa-like ensuite bath. Claw foot classic soaking tub, walk-in shower, designer tile work, water closet, marble flooring, double sinks and walk-in closet with custom closet system and a private owner’s balcony with incredible views. The fourth floor brings the final bedroom offering a second primary layout with a full walk-in closet and ensuite bath. This generously sized suite has allowed the sellers to fashion a quiet office area to one side… the possibilities are endless and this room also has its own quaint ‘sunset’ balcony. The famous Gulf coast sunsets are visible from every angle!! Each floor has its own separate HVAC unit. Three car garage allows back opening for easy access to water toys! Metal roof, galvanized steel shutters. The home’s design and finishes offer a sophisticated Florida vibe… an ambiance of pure pleasure and relaxation. Paradise for those who love the water! This is the waterfront haven you’ve been searching for… the search ends here! Better hurry!
MlsNumber: U8235426


Listing Provided By: Realtec Group, Inc., original listing
Name: Realtec Group, Inc.
Phone: (727) 789-5555
Office Name: RE/MAX REALTEC GROUP INC
Office Phone: (727) 789-5555
Agent Name: Nancy Leslie
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 = 182 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 Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App