..............................
Listing IDT3334458
Sold For$2,950,000
StatusClosed
Bedrooms6
Total Baths6
Full Baths6
SqFt
3,762
Acres
29.590
CountyHillsborough
Year Built1998
Property TypeResidential
Property Sub TypeFarm
Welcome to L & D Farms in the highly sought after equestrian community of Odessa, Florida. This almost 30 acre, All Uplands Equestrian Compound is a dream opportunity for an investor to further develop, a horse boarding business or a discerning buyer wanting a tranquil equestrian residence for family and friends. Only minutes to the Veterans Expressway to catch all the “Champa Bay”
sporting events, theater, fine dining and the number one rated beach! As you enter the private gate the story begins with L & D Farms. These fields have seen the best of the best in thoroughbred horses with many accolades including owners of the year at Tampa Bay Downs in 2000, to Grade 1 Winner Magnificent Song. Supporting this winning tradition with 30 stables with 2 attached residences this farm is positioned to produce the next great race horse or, equestrian competition winner. L & D Farms features 4,816 sq ft under roof, horse stalls, tack rooms, offices, swimming pool and cabana. The oversized garage has plenty of room for a Prevost, Sea Ray or even storing a helicopter. The 1,468 sq ft residence is perfect for staff or guests as it provides 3 bedrooms, 2 bathrooms including a downstairs master suite, and 2 additional bedrooms upstairs with a private bathroom, 8 stables, tack room, plenty of loft storage, office and an equipment garage complete this front property with 8 stables. The main residence is quietly tucked away and features 2,368 sq ft of air conditioned living space. The first floor includes the living room, kitchen and a downstairs master suite. Upstairs, you will find 2 additional bedrooms with a shared bathroom, home office, bonus room, 9 stables, 2 garages, full bathroom and plenty of loft storage complete this residence.
13 additional stalls, 3 wells with 1 1/2, 5 and 40 horse power pumps, a new water treatment system and freshly painted buildings completes the story of this expansive property. For the most accurate directions to the property please enter 18737 Crescent Rd in your GPS.
County
Hillsborough
Property Sub Type
Farm
Property Type
Residential
Subdivision
Keystone Park Colony Sub
Year Built
1998
Zoning
AR
Additional Rooms
Den/Library/Office, Inside Utility, Storage Rooms
Appliances
Dishwasher, Microwave, Range, Refrigerator, Water Filtration System
Building Area Units
Square Feet
Cooling Type
Central Air
Fireplace
no
Flooring
Carpet, Ceramic Tile
Heating Type
Central, Electric
Interior Features
Ceiling Fans(s), Eat-in Kitchen, Living Room/Dining Room Combo, Master Bedroom Main Floor, Solid Surface Counters, Solid Wood Cabinets
Laundry Features
Inside
Levels
Two
Living Area Meters
349.50
Living Area Source
Public Records
Living Area Units
Square Feet
Room Count
7
Spa
yes
Spa Features
In Ground
Stories Total
2
Attached Garage
yes
Barn Features
Barn Apartment,Barn Office,Feed Room,Horse Barn,Tack Room
Carport
no
Construction Materials
Block, Wood Frame
Exterior Features
French Doors, Irrigation System
Farm Type
Horse
Fencing
Wood
Foundation Details
Slab
Garage
yes
Garage Spaces
2
Homestead
no
Lot Features
Greenbelt, Oversized Lot, Zoned for Horses
Lot Size SqFt
1288940
Lot Size Square Meters
119746
Number Of Septics
2
Number Of Wells
3
Other Structures
Barn(s), Cabana, Storage
Parking Features
Boat, Golf Cart Parking, RV Garage
Pool Features
In Ground
Pool Private
yes
Road Surface Type
Paved
Roof
Metal
Sewer
Septic Tank
Total Acreage
20 to less than 50
Utilities
BB/HS Internet Available, Electricity Connected, Sprinkler Well, Water Connected
View Type
Park/Greenbelt, Trees/Woods
Water Access
no
Water Extras
no
Water Source
Well
Water View
no
Waterfront
no
Association
no
Association Approval Required
no
Building Area Source
Public Records
Building Area Total
4816
Community Development District
no
Country
US
Direction Faces
North
Flood Zone Code
x
MLS Area Major
33556 - Odessa
Number Of Lots
2
Township
27
Zoning Compatible
yes
Available For Lease
yes
Current Price
2950000.00
Existing Lease Tenant
no
Minimum Lease
No Minimum
Ownership
Fee Simple
Special Listing Conditions
None
Tax Annual Amount
13150.27
Tax Book Number
5-55
Tax Lot
2
Tax Year
2021
Listed by: Coldwell Banker Realty .
Listing information ©My Florida Regional MLS DBA Stellar MLS 2024. All listing information is deemed reliable but not guaranteed and should be independently verified through personal inspection by appropriate professionals. Listings displayed on this website may be subject to prior sale or removal from sale. Availability of any listing should always be independently verified. Listing information is provided for consumer personal, non-commercial use, solely to identify potential properties for potential purchase. All other use is strictly prohibited and may violate relevant federal and state law. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed. Properties displayed may be listed or sold by various participants in the MLS. Data last updated on Thursday, March 28th, 2024 at 07:43:52 PM.
Listing information ©My Florida Regional MLS DBA Stellar MLS 2024. All listing information is deemed reliable but not guaranteed and should be independently verified through personal inspection by appropriate professionals. Listings displayed on this website may be subject to prior sale or removal from sale. Availability of any listing should always be independently verified. Listing information is provided for consumer personal, non-commercial use, solely to identify potential properties for potential purchase. All other use is strictly prohibited and may violate relevant federal and state law. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed. Properties displayed may be listed or sold by various participants in the MLS. Data last updated on Thursday, March 28th, 2024 at 07:43:52 PM.
Request More Information - Listing ID T3334458
Data services provided by IDX Broker
Powered by RealtyCandy.com IDX Broker for Wordpress