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','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 = 3350 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 = 3350 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;

8414 Dunham Station Drive
Tampa, FL 33647
Leza Sharipoff with ROBERT SLACK LLC, original listing - (352) 229-1187

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,249,000
Beds: 6
Baths: Full: 5, ½: 2
Status: Active
SqFt: 5382 Square Feet
Agency: ROBERT SLACK LLC
Agency Phone: (352) 229-1187

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: AT APPRAISED VALUE! LOCATION, LOCATION, LOCATION! A hurricane flood free Non-Evacuation Zone. Welcome to Luxury Living in the 24-hour GUARD GATED Community of GRAND HAMPTON! From the moment you arrive this UPDATED Custom Residence exudes Elegance & Comfort on a Sprawling Lot with PRIVACY & BREATHTAKING VIEWS of the surrounding conservation area. The manicured landscaping and long custom paver driveway leads you to spacious 3 car garages featuring epoxy floors and a striking Architectural Design. As you step inside this 6 Bedroom + Full Office, 5 Full-Bath and 2 Half-Bath's , you're greeted by an incredible light filled OPEN FLOOR PLAN. The home effortlessly combines traditional charm with Luxurious Modern Finishes. A grand two-story foyer sets the stage, adorned with a Feature Staircase, Sparkling Crystal Chandeliers, Designer Flooring, Crown Molding, Built-in Home Scenting system and whole-house Water Filtration System. The living and dining spaces are beautifully appointed, perfect for hosting gatherings of any size. The Gourmet Chef’s Kitchen is a highlight, featuring Rich Custom soft-close cabinetry with ample storage space and roll-out cabinets, Luxurious Cambria Quartz Countertops, and High-End stainless steel appliances. A bonus breakfast bar adds casual seating for family and friends. Entertainment seamlessly flows into the BACKYARD PARADISE, a Dream for outdoor living. Oversized glass doors with Custom interior motorized drapes lead to an Expansive Patio with travertine stone flooring. The patio features state-of-the-art remote controlled enclosed screens. An outdoor kitchen with built-in BBQ, sink, fridge, TV, invites culinary adventures. An adjacent outdoor private bath, in-pool patio built in firepit. CUSTOM 7ft Deep SALTWATER POOL along with an infinity Spa & Multi-Color LED lights complete the resort-like experience. Inside, every detail has been Meticulously Designed. The STUNNING MASTER SUITE is located on the main level along with En-Suite Bedroom. The Master boasts separate Dual Walk-in Closets and Private Patio Access. Two separate vanities, oversized walk-in shower, and a oversized soaker tub create a Luxurious Retreat. The home is tailored for family enjoyment, featuring a large upstairs with a private outdoor covered balcony with an AMAZING VIEW, a Den with In-Ceiling Surround Sound for entertainment that include 3 T'Vs, and a WET BAR with a built-in temp controlled wine cooler. A CUSTOM MOVIE THEATER room designed with velvet insulated noise cancelation, plush carpeting, 13 Reclining-Seats equipped with a state-of-the-art Sony Projector. The theater delivers crisp High-Definition Visuals that bring Movies to Life, complementing the impressive visuals with an impeccable sound system, meticulously installed to enhance every detail of the movie soundtrack with premium audio quality that promises a cinematic experience. For shopping & dining enthusiasts, you're just minutes away from Shops at Wiregrass, Premium Outlet Mall, a variety of restaurants catering to every taste along with many Entertainment Attractions! Whether you're looking for family-friendly activities or leisure pursuits, there's something for everyone. Located just off I-75/275, you'll have easy access to Downtown Tampa within a short 25-minute drive. Grand Hampton offers RESORT-STYLE AMENITIES, here you'll find not just a place to live, but a lifestyle best of suburban tranquility with easy access to urban conveniences & recreational opportunities.
MlsNumber: --
ListingId: TB8314841


Listing Provided By: ROBERT SLACK LLC, original listing
Phone: (503) 894-2635
Office Phone: (352) 229-1187
Agent Name: Leza Sharipoff
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 = 3350 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;
Angela Royster & Lauren Batcho
ASCIIAR Realty
Call Today!: (813) 484-9330

Local Mortgage Pro

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','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;
Real Estate Expert Photo for Joe Spellman NMLS# 2142845
Joe Spellman NMLS# 2142845
ASCIIFamily First Mortgage USA empowered by NEXA
Call Today!: (863) 559-8288

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App