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;

2309 N Riverside Drive
Tampa, FL 33602

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,799,000
Beds: 5
Baths: 4
Status: Active
SqFt: 4162
Agency: Compass

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2025
Notes: Under Construction. Discover the unparalleled opportunity awaiting you in Ridgewood Park, where a new construction luxury estate beckons. Meticulously crafted by renowned builder GILK, this modern-contemporary masterpiece embodies both elegance and functionality. Designed to perfection, this custom-built residence maximizes the expansive 8,000+ sq ft homesite. Boasting 5 bedrooms and 4 baths spread across 4,100+ sq. ft. of living space, this home offers the epitome of luxury living. Upon entry, guests are greeted by striking architectural features, including a floating staircase and a stunning 3-sided fireplace. Flooded with natural light from floor-to-ceiling windows and sliding glass doors, the living and dining areas seamlessly flow into a sleek, two-toned kitchen complete with a built-in wine cellar and custom pantry. The kitchen is outfitted with top-of-the-line stainless steel appliances and ample storage space. A convenient ensuite bedroom is located on the first floor, while the primary suite and three additional bedrooms reside upstairs. The Primary Ensuite is a true oasis, boasting tongue and groove wood panel accents, a spacious walk-in closet, and a lavish bathroom featuring a wet room with a soaking tub, shower heads, dual vanities, and a makeup station. Step outside to enjoy breathtaking views of the Hillsborough River from the front balcony, or entertain guests on the oversized balcony overlooking the pool and patio area. The property also features a rear garage accommodating two cars and beautifully landscaped gardens at the front of the home. Conveniently situated steps from the Tampa Riverwalk, near Armature Works, Downtown Tampa, The Straz Center For Performing Arts, Raymond James Stadium, and other iconic Tampa destinations, this one-of-a-kind masterpiece offers the pinnacle of modern living in a vibrant urban setting. Schedule your private tour today and envision the lifestyle of luxury awaiting you in this exquisite home.
MlsNumber: T3515030


Listing Provided By: Compass, original listing
Name: Compass
Phone: (551) 404-5204
Office Name: COMPASS FLORIDA, LLC
Office Phone: (813) 355-0744
Agent Name: Eric Dungy
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