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;

4911 W Melrose Avenue S
Tampa, FL 33629

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,695,000
Beds: 6
Baths: 6
Status: Active
SqFt: 4843
Agency: Keller Williams St. Pete Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2008
Notes: Welcome to your waterfront oasis in the heart of South Tampa, where Mediterranean elegance meets modern luxury. This impeccable two-story pool home is situated on a corner lot and offers an impressive array of features and amenities across its expansive 4,843 square feet of living space. Approaching the home, you'll be greeted by lush landscaping, a decorative water fountain, and a brick-paved driveway leading to a covered front entry adorned with travertine tile and extensive crown molding, setting the tone for style throughout. Upon entry, architectural details are showcased with arched entryways leading into the living and dining areas, creating an inviting ambiance. The gourmet-style kitchen is a chef's dream, boasting Marble countertops, custom wood cabinets, high-end appliances including a GE Monogram refrigerator, gas cooktop, built-in double ovens, GE Monogram built-in microwave, farm-style sink, and double stainless dishwasher. A butler's pantry with additional storage and a built-in wine fridge adds convenience for entertaining. Enjoy casual meals at the breakfast nook or the snack bar, all while overlooking the great room with its soaring ceiling and custom lighting and ceiling fan. The main level features two bedrooms connected by a Jack and Jill bath, providing comfort and privacy for guests or family members, lavishly styled with Terracotta ceramic tile floors. Ascend the hardwood staircase to the second level, decorated with artisanal lighting, you'll find the isolated primary suite featuring travertine floors, separate a/c unit, a spacious sitting area or office, a private open patio with breathtaking water and sunset views, and an expansive primary bath complete with double sinks, a soaking tub, walk-in shower, and an exceptionally large walk-in closet with a custom-built organizing system and center island. The 4th & 5th bedroom upstairs are connected with a Jack & Jill bath and the sixth bedroom has a private balcony and ensuite bath. Step outside to discover your outdoor paradise, featuring a covered seating area, a screened patio with an outdoor custom kitchen & half bath, and a large heated pool surrounded by brick-paved decking. Enjoy stunning water views, breathtaking sunsets, and direct access to Tampa Bay via your private floating boat dock with lift that can handle up to 6,000 lbs capacity and up to 27th boat. The property is meticulously landscaped throughout, enhancing its tropical allure. Additional features include a level 2 charging stations for 2 vehicles - Tesla and a J1772 connector, FULL house generators that runs on natural gas and can supply the entire house, fully landscaped front yard, Mango tree, installed generators for peace of mind, security system and hurricane-rated electric storm shutters. Located just minutes from prime shopping destinations, including International Mall, Westshore Marina district, Bayshore Blvd, and Hyde Park Village, this home offers unparalleled convenience. Easy access to major highways such as Dale Mabry, Kennedy Blvd, and Tampa International Airport ensures effortless travel. Within the sought-after Plant High School district, and with proximity to Gandy Blvd and Downtown Tampa, this property embodies luxury living at it's finest.
MlsNumber: U8239334


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 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