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

4525 Sunrise Drive S
Saint Petersburg, FL 33705

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,675,000
Beds: 5
Baths: 3
Status: Active
SqFt: 2343
Agency: Keller Williams St. Pete Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1951
Notes: Introducing a remarkable and unmatched waterfront compound, situated on a deep sailboat water canal with no bridges boasting unparalleled access to Tampa Bay, perfect for boating, jet skiing and kayaking. Enjoy the luxury of coastal living at its best. Entertain yourself by watching the Dolphins and Manatees from your living room, fishing from your dock, and the convenience of two lifts for Boat and/or Jet Ski’s (7,000 lbs. and 13,500lbs). Nestled on a spacious corner lot with two private homes, each exuding its own unique charm and functionality. The primary residence stands as a testament to modern elegance, offering 3 bedrooms and 2 full baths, meticulously crafted living space. Recently renovated, this stunning home showcases a brand-new roof, complemented by luxurious travertine flooring that gracefully adorns the interior. Newly designed kitchen and baths, adorned with granite countertops, stainless steel appliances, and travertine backsplash elevate the homes aesthetic appeal. The private primary bedroom retreat features an ensuite bath, providing a tranquil sanctuary for relaxation, with huge <br /> walk-in shower, enjoy a rainforest shower with misters and your choice of LED lighting, with multiple shower heads (9 total). Step outside to discover an oasis of leisure in the private fenced-in yard, complete with a custom heated resort-style saltwater pool & spa surrounded by a travertine tile deck, vinyl fencing, and lush tropical landscaping. Adjacent to the main residence lies the second home, offering two bedrooms and one full bath. Boasting a full kitchen and living room, this secondary dwelling provides versatility and comfort. Ideal for accommodating guests or as an accessory dwelling unit (ADU)/in-law suite, this beauty has original terrazzo floors and abundant storage space. A private fenced backyard, one-car attached garage, and private access further enhance its appeal. Beyond the residences, the property offers an array of enticing amenities, including a private Celebrity Greens putting green, ensuring endless opportunities for relaxation and recreation. Additional upgrades include new appliances, HVAC system, water heater, and doors throughout both homes. Located in a great neighborhood, overlooking Cook Park, you can zip to vibrant Downtown St. Petersburg and the Beaches, and less than half a mile from St. Petersburg Country Club. This waterfront sanctuary offers unrivaled convenience and utility. Situated on Sunrise Drive South, live life waking up with an amazing sunrise each morning. With a mere 30-minute commute to Tampa and easy access to major highways, residents enjoy seamless connectivity to urban amenities while savoring the tranquility of waterfront living. Indulge in waterfront dining and specialty shopping nearby, completing this must have coastal lifestyle experience. This is a once in a generation opportunity to own a property that does not exist anywhere else in the Tampa Bay Region.
MlsNumber: U8237422


Listing Provided By: Keller Williams St. Pete Realty, original listing
Name: Keller Williams St. Pete Realty
Phone: (727) 894-1600
Office Name: KELLER WILLIAMS ST PETE REALTY
Office Phone: (727) 894-1600
Agent Name: Jac Smith
Disclaimer: Copyright © 2024 Pinellas Suncoast Association of REALTORS ®, Inc. 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 = 3194 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;
Jen Vultaggio
ASCIIColdwell Banker Realty
Call Today!: (727) 244-1564

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App