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;

3005 W Fair Oaks Avenue
Tampa, FL 33611

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,200,000
Beds: 5
Baths: 7
Status: Active
SqFt: 6880
Agency: RE/MAX Action First

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2007
Notes: Do you desire a supremely luxurious custom home with five primary suites, a dream-worthy theater, an attached guest apartment, and an outdoor poolside oasis? Look no further! Beautifully tucked away in an exclusive area just moments from scenic Bayshore Boulevard, this 5BR/6.5BA, 6800+sqft residence immediately captivates the imagination with attractive custom architecture, a half-circle paver driveway, lush tropical landscaping, and towering mature trees, all sitting on a large double lot. Immaculately styled for the most discerning homeowner, the interior impresses with gorgeous oak hardwood floors with Brazilian cherry inlays, 12’ ceilings throughout the home, an openly flowing traditional layout, plantation shutters, thick crown molding, stunning wainscoting, living room with a fireplace, an elegant formal dining room, an exquisite mahogany-paneled home library/office, and a lovely music room, suitable for a baby grand piano. Catering to both foodies and gourmets, the Tuscan-inspired chef’s kitchen delights with premium stainless-steel appliances, custom wood cabinetry, granite countertops, gas range, center island, butler’s pantry, breakfast bar peninsula, and a breakfast nook. Unparalleled entertaining is discovered in the fully enclosed backyard featuring a sparkling pool, soothing spa, screened-in full outdoor kitchen, putting green, and a sprawling terrace. Indoor gatherings may also be enjoyed with the game/billiard room or the state-of-the-art home theater, which both enjoy wet bars. Bliss is found in the main primary bedroom boasting a romantic fireplace, two custom walk-in closets, and an en suite with stately columns, soaking tub, oversized multi-head shower with an attached steam shower room, and dual vanities. Multigenerational needs are satisfied with a guest/in-law suite featuring a full kitchen and full bathroom. Additional amenities include four garage parking spaces, laundry room with double washers/dryers, guest bedrooms with full bathrooms and walk-in closets, and so much more! Get all the advantages, and live your best life in one of Tampa’s most coveted areas. Bedroom Closet Type: Walk-in Closet (Primary Bedroom).
MlsNumber: U8229803


Listing Provided By: RE/MAX Action First, original listing
Name: RE/MAX Action First
Phone: (727) 443-6700
Office Name: RE/MAX ACTION FIRST OF FLORIDA
Office Phone: (813) 749-0875
Agent Name: Khang Ngo
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