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;

4806 W San Rafael Street
Tampa, FL 33629

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,300,000
Beds: 5
Baths: 6
Status: Active
SqFt: 4213
Agency: Keller Williams Realty Tampa Central

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2020
Notes: Welcome to a waterfront retreat that epitomizes the pinnacle of luxury living, where panoramic water views meld seamlessly with an outdoor haven designed for relaxation and refinement. Constructed in 2020, this extraordinary residence is a showcase of impeccable craftsmanship, featuring impact windows, grand 8' wood doors, and exquisite finishes throughout. Revel in culinary creativity with a chef's dream kitchen boasting Sub-Zero and Wolf appliances, including M Series Professional built-in double ovens, and a Wolf 36" sealed burner rangetop with 6 burners. Additional conveniences include a 24" transitional drawer microwave and custom cabinetry with soft-close hinges. The living and main areas are adorned with wainscot trim and 7" cove crown molding in the foyer, upstairs hallway, and the master bedroom, while wood sills and full window casings grace every window. The home is adorned with 6" baseboards and 4" casing, elevating its architectural elegance. The master closet features custom shelving for organization, while the bathrooms and kitchen showcase quartz Bianco Fuma countertops. The outdoor oasis offers a gas fire pit, a saltwater pool, and a spa with a cascading waterfall. Boating enthusiasts will appreciate the recently dredged canal and the newly installed dock with a 10,000 LB boat lift. Whether you cherish waterside tranquility or seek aquatic adventures, 4806 W San Rafael St promises an unmatched waterfront lifestyle. This exceptional property beckons—seize the opportunity to make it your new home today!
MlsNumber: T3474509


Listing Provided By: Keller Williams Realty Tampa Central, original listing
Name: Keller Williams Realty Tampa Central
Phone: (813) 865-0700
Office Name: KELLER WILLIAMS TAMPA CENTRAL
Office Phone: (813) 865-0700
Agent Name: Ally Russell
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