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;

5104 W Longfellow Avenue
Tampa, FL 33629

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $10,995,000
Beds: 5
Baths: 6
Status: Active
SqFt: 6405
Agency: The Toni Everett Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: Under Construction. Welcome to an extraordinary opportunity for luxurious living in South Tampa! This truly unique Custom OPEN BAY WATERFRONT pool home in coveted Sunset Park, spanning over 6400 square feet, offers unrivaled views of Tampa Bay and downtown St. Pete setting a new standard for upscale living. Designed by the renowned Mary Beth Courier, who designed Oxford Exchange, this magnificent residence provides ample space for relaxation and privacy which features five spacious bedrooms, six bathrooms, large office, huge game/media room and 4 car garage. The well-designed floor plan includes an extraordinary master suite with 2 expansive master closets, oversized walk in shower, stand alone tub and an abundance of storage and organization options. Prepare to be wowed by the kitchen, featuring top-of-the-line Sub-Zero and Viking appliances that combines functionality with exquisite aesthetics, making it a dream for both aspiring and seasoned chefs. Entertainment options abound within this amazing home. A dedicated home theatre and a state-of-the-art golf simulator provide unparalleled enjoyment for both movie nights and golf enthusiasts. With high-end audio, visual technology, and intelligent lighting control throughout the house, every moment spent in this home will be immersed in luxury and sophistication. This property will offer an array of exceptional features. Imagine indulging in a resort-style swimming pool and hot tub, perfect for relaxation and entertaining guests. Additionally, a new dock with a boat lift will provide direct access to the water, ideal for boating and waterfront living. Located in a desirable area, this property offers convenient access to the vibrant downtown scene, where renowned restaurants, upscale shopping, and cultural attractions await. Furthermore, schools, parks, and major transportation routes are all within reach, ensuring a well-rounded and convenient lifestyle. Scheduled for completion in the middle of 2024. Currently, there is still an opportunity to customize options and features. Don't miss the chance to experience the pinnacle of luxury living in South Tampa. Call now for further details.
MlsNumber: T3455755


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: Eric Panico
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 = 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;
Real Estate Expert Photo for Elizabeth Colon
Elizabeth Colon
ASCIIeXp Realty Tampa Bay Home Team
Call Today!: (813) 919-4553

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App