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','uthud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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','uthud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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','uthud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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: $2,700,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Mihara & Associates, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 19 acre(s)
Property Type: Lots And Land
Year Built: --
Notes: 19.11 Acres with Race Trace Road frontage. Seller will be subdiving the property from the homesite. Up to 7 buildable 1 acre homesites or continue to use the property as an equestrian oasis that backs up to 300 acres of Hillsborough county dedicated horse riding trails. The land currently features 4 barns with 16 stalls, covered riding arena, covered shed and storage area and a parking lot. <br /> <br /> Barn 1 features: Equipped with Automatic Fly and Insect Control system <br /> 2 Classic Equine AutoFount Automatic Waterer outside <br /> 2 Classic Equine AutoFount Automatic Waterer in the stalls <br /> 1 - 12 x 24 stalls with 36” mounted fans <br /> 1 - 12 x 24 stalls <br /> 1 - 12 x 12 stalls with 36” mounted fans <br /> 2 Paddocks<br /> 1 Tack Room (12 x12) with fans<br /> 1 Wash Rack with Pergola 12 x 12<br /> 2 High Country Hay Feeders <br /> 2 Wood box Hay feeds<br /> All Stalls Matted Padded Flooring with French Drain System<br /> 12’ Covered Aisle way around the Barn<br /> Slab base – enforced with rebar in walkways<br /> <br /> Barn 2 features:<br /> 1 12 x 24 Stalls – Divider removed and can easily be converted into 2 stalls<br /> 1 Paddocks<br /> 1 12 x 12 Tack Room with fan<br /> 1 12X12 Wash Rack<br /> Stall has Matted Padded Flooring with French Drain System<br /> Slab base – enforced with rebar in walkways<br /> <br /> Barn 3 features: <br /> 6 Automatic Waterer<br /> 6 Stalls (10x12)<br /> 1 Paddocks<br /> 2 10x12 Tack Rooms<br /> 1 12X12 Wash Rack<br /> All Stalls Matted Padded Flooring with French Drain System<br /> Slab base – enforced with rebar in the walkway<br /> <br /> Barn 4 Features: <br /> Equipped with Automatic Fly and Insect Control system<br /> 2 X Automatic Waterers in that stalls<br /> 1 Classic Equine AutoFount Automatic Waterer in the stall<br /> 1 Classic Equine AutoFount Automatic Waterer outside<br /> 3 12x24 Stalls <br /> 1 X Paddocks<br /> 1 - 18 x 12 AC Tack Room<br /> 2 Wash Rack with hot water 12 x 12<br /> 1 High Country Hay Feeders <br /> 2 Wood box Hay feeds<br /> 1 Bathroom<br /> 1 Laundry room with washer and dryer hook ups<br /> 1 carport 12 x 24<br /> 12’ covered aisle<br /> Constructed with Hardy board. <br /> <br /> Covered Arena Features: <br /> Galvanized Steel Riding Arena 100 x 200 & 18’ Height on sides and center 24’ height<br /> Clear Span Arena <br /> Audio / Intercom System with receiver and commercial speakers<br /> Internet and WiFi<br /> 2 x Big Ass Fans Industrial 16 ft – Commercial Grade<br /> LED lights throughout <br /> Clay Sand Footing & Limestone Base<br /> Covered area with Shed features: <br /> Hudon AquaPacer System aprox 100k installed with plumbing (being sold separately)<br /> 48x12 total area<br /> 12 x 12 – storage room with electric and fans and internet and TV hookups<br /> Constructed with Hardy board on the exterior<br /> 12’ aisle way<br /> Slab base – enforced with rebar for entire surface area<br /> The property will also include rights the 3 acre lake and amount to be included is still be determined.<br /> <br /> Survey is available for whole property prior to sub diving into the 19.11 acres. Currently the whole property has 1 well and 2 septic tanks. Call for more details. NOTE: TAXES ARE NOT REFLECTING PROPERLY AND WILL BE LESS.
MlsNumber: T3507980


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','uthud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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