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 = 3350 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 3350 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 3350 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

8406 Dunham Station Drive
Tampa, FL 33647

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 5
Baths: 4
Status: Active
SqFt: 4221
Agency: RE/MAX Metro

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2007
Notes: A stunning executive home nestled in the prestigious gated community of Grand Hampton. Situated on a private, premium lot with conservation areas on one side and behind, this two-story pool home offers the epitome of luxury living. Step inside and be greeted by the grandeur of the two-story foyer, adorned with a sparkling crystal chandelier and a captivating winding wooden staircase. The seamless flow leads you to the formal living and dining rooms, perfect for hosting elegant soirées. A chef’s dream, the kitchen features a large center island, walk-in pantry, 4-burner gas range with an enclosed cooking area and separate oven. A first-floor master retreat features pool views, custom wood walk-in closet, en-suite bathroom with dual vanities, a walk-in rain shower, and separate soaking tub. An additional bedroom or office with full bathroom, laundry room and pool half bath round out the first floor to service the amazing backyard. This home was designed with both entertaining and family comfort in mind, this spacious home boasts 5 bedrooms, 3 full and 1 half baths, a loft area, and even a theater room including a 133 inch Movie Theater Room with multi rows of seats, a Digital projector and a 7.1 Dolby Surround Sound system built-in. <br /> The versatile layout effortlessly accommodates multi-generational living arrangements. Natural light floods the airy 20-foot-high family room, providing serene views of the largest residential lagoon-style pool oasis in the area. Step outside onto the paver deck and immerse yourself in pure relaxation. This custom-designed saltwater heated pool features an oversized spa, a center island, numerous waterfalls, fountain jets, and even a grotto with a cozy sitting area inside - all beautifully crafted with hand-laid natural rocks. With an expansive 4221 square feet of living space and three oversized garage spaces, there is ample room for all your needs. Enjoy the convenience of parking without any hassle. Located in Grand Hampton, you'll have access to top-notch amenities such as a clubhouse, fitness center, pool, tennis courts, playgrounds, and more. Plus, you'll be just moments away from shopping centers, restaurants, schools, and major highways. Don't miss this incredible opportunity to own a true executive home. Schedule your private showing today! **Feature sheet available / custom virtual tour here: https://my.matterport.com/show/?m=VtThwRrLZyP Property has recently been professionally staged on 12/28/2023 Contact me for more info!
MlsNumber: U8215945


Listing Provided By: RE/MAX Metro, original listing
Name: RE/MAX Metro
Phone: (727) 896-1800
Office Name: RE/MAX METRO
Office Phone: (727) 896-1800
Agent Name: Kayla Biathrow
Disclaimer: Copyright © 2024 Pinellas Suncoast Association of REALTORS ®, Inc. 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 = 3350 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 Stacy Wolfson
Stacy Wolfson
ASCIIeXp Realty - The Wolfson Luxury Group
Call Today!: (813) 240-8888

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App