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 = 3349 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 = 3349 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 = 3349 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;

15701 Race Track Road
Odessa, FL 33556

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,900,000
Beds: 4
Baths: 6
Status: Active
SqFt: 4419
Agency: Mihara & Associates, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2016
Notes: Premiering in the market for the first time. This sprawling 5 acre estate home with a resort style pool is a short 5 minutes to Tampa Bay Downs and nestled by 300 acres of Hillsborough Counties public horseback riding trails.  This property features a stately home with 4 bedrooms, 5.5 bathrooms, office, movie theater, game room, living room, dining room, 3 car oversized garage, a 15 car driveway, state of the art outdoor kitchen and living space, 2 remote operated electric outdoor fireplaces, an 88,000 gallon pool with waterfalls and a lazy river, The primary bedroom with built in walk in closets and large en suite bathroom with a freestanding tub and large walk in shower is downstairs along. The kitchen features a large island, built in 48" JennAir Fridge, WiFi enabled double oven convection and microwave with probe notification alerts, 5 burner induction cooktop with auto boil and simmer features, built in dishwasher that overlooks the sitting area and living room.  To the side is a pass-through buffet to an additional indoor food preparation area with separate fridge and sink/ filtration system.  The office overlooks the magnificent views of the pool and private lake and the second bedroom is also located downstairs with access to the courtyard.  The main living room boasts 20' soaring ceilings with a Romeo and Juliet balcony from the upstairs game room which has granite countertops with a built-in fridge and chilling drawers for drinks and snacks.  The movie theater has a 110" movie screen with a streaming and app controlled projector, Harman Kardon surround system and Bose speakers and comfortably seats 7 in the double insulated sound barrier walls.  The 2 additional bedrooms upstairs access the back balcony for stunning views of the property. The outdoor kitchen features a Bull SS 4 burner with 2 side burner grill, hood vent, 2 SS mini fridges, prep sink and 5 food storage drawers and insulated drink storage with drain. Accent fire Pit bowl on the stone granite lanai and LED lighting.  The zero entry resort style chlorine pool has dual sweepers and commercial UV lighting cleaning system, 2 chair pool ledge, stone grotto with dual waterfalls, lazy river with depths of 3' to 5' throughout, vanishing edge waterfall, 10' depth in the pool and the pool is App & Wifi enabled. The back patio is equipped with an automatic fly and insect control system near the pool.  Some other great features include whole home reverse osmosis, water softener, stunning Restoration Hardware crystal chandelier, pool storage room, 3 Trane AC systems (2016), pool alarms, beach like entry to the lake, auto lighting at dusk. Roof (2016) Access to a 3 acre lake, cameras on the perimeter of the home, gated entrances, and outdoor lighting. Adjacent land being sold separately can also potentially be divided into 7 large 1 acre estate homesites and should be verified.  All furniture is negotiable. YouTube video is under the property address. Fridge in the laundry room does not convey. Call today for a private showing.
MlsNumber: T3495479


Listing Provided By: Mihara & Associates, Inc, original listing
Name: Mihara & Associates, Inc
Phone: (813) 960-2300
Office Name: MIHARA & ASSOCIATES INC.
Office Phone: (813) 960-2300
Agent Name: Heather Spinosa
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 = 3349 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 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