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

4818 W San Rafael Street
Tampa, FL 33629

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,450,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 4701
Agency: The Toni Everett Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2008
Notes: Under contract-accepting backup offers. Welcome to an exquisite waterfront retreat that seamlessly blends luxury and Mediterranean-inspired design. This stunning home spans an impressive 4,701 square feet, offering a captivating fusion of opulence and coastal charm. Boasting four bedrooms and three and a half baths, this residence is a testament to its owners’ meticulous eye and thoughtful details. As you approach the property, a grand facade welcomes you, adorned with archways, wrought iron details, and terracotta roofing that characterize the timeless Mediterranean style. The lush landscaping provides an enchanting backdrop, enhancing the overall curb appeal. Step through the elegant double-door entryway into a spacious foyer, where natural light spills through large windows, illuminating the exquisite details of the home. Just off the foyer is the formal living room, private office and downstairs guest suite complete with a recently updated bathroom and walk-in closet. <br /> Many luxury-level upgrades and renovations have taken place in recent years and a full listing is attached or available. The floor plan seamlessly connects the living spaces, creating an inviting ambiance for both intimate gatherings and grand entertaining. The gourmet kitchen is a culinary haven, featuring high-end appliances, custom cabinetry, marble backsplash, accent lighting and a central island that overlook the family room and dining area. A redesign of the family room has seamlessly connected the outdoor and indoor spaces by transforming the walls into oversized sliding glass doors. Natural light pours through to family room, dining area and kitchen providing an amazing view of all outdoor features and entertainment areas. The home's four bedrooms are generously sized, each offering serene views of the water or lush surroundings. The master suite is a sanctuary of indulgence, complete with a private balcony, a new closet remodel and new spa-like ensuite bath. The master bathroom is a page out of a designer’s magazine and the floor-to-ceiling marble enhances the spa experience along with the open shower and large soaking tub. The outdoor living space is a true oasis, featuring a brand-new pool surrounded by a travertine patio. The heated, saltwater pool and spa has a spill over ledge, bubblers, gas fireplace and all the luxury items to transport you into a resort-like atmosphere. Enjoy breathtaking sunsets from the covered terrace, where you can entertain guests or simply relax in the embrace of the gentle sea breeze. A private dock extends into the canal waterfront, providing easy access (recently dredged/year-round access) for boating and water activities. The garage offers two full spaces and additional space for your golf cart, ensuring convenience and security along with plenty of storage space. With meticulous attention to detail, the Mediterranean-style masterpiece is not just a home but a lifestyle statement—a sanctuary where luxury and coastal living converge in perfect harmony. This South Tampa, luxury waterfront home is located conveniently to Tampa International Airport; a multitude of Tampa’s best dining and shopping venues; Downtown Tampa; Channelside District; Raymond James Stadium; the bay bridges to the beach; and I-275 and I-4.
MlsNumber: T3496615


Listing Provided By: The Toni Everett Company, original listing
Name: The Toni Everett Company
Phone: (813) 839-5000
Office Name: THE TONI EVERETT COMPANY
Office Phone: (813) 839-5000
Agent Name: Henderson Everett
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App