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

10603 Low Oak Terrace
Thonotosassa, FL 33592
Virginia Bond with Engel & Völkers Tampa Downtown, original listing - (813) 863-1986

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,690,000
Beds: 9
Baths: Full: 9, ½: 2
Status: Active
SqFt: 7782 Square Feet
Agency: Engel & Völkers Tampa Downtown
Agency Phone: (813) 863-1986

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Garage: Garage
Property Type: Other-Single Family Residence
Year Built: 2014
Notes: This incredible Tuscan estate is located in the exclusive and gated community of Stonelake Ranch. Situated on over 3 acres at the end of a quiet cul-de-sac. With a total of 11,278 sq. ft. under roof, including 7,782 sq. ft. of air-conditioned space in the main house, the property includes a 4-car garage and detached two story in law suite. The main home features 7 bedroom suites, each with a full bath the detached in law offers two full suites. This grand estate offers a total 11 bathrooms with 9 full baths and 2 half baths and 9 bedrooms. The first floor includes the primary suite with trey ceilings, crown molding, sliding glass doors leading to the pool, and a luxurious master bath with double vanities, a separate tub, and ample cabinetry. A secondary bedroom suite is also located downstairs. Upstairs, the bonus room features wood floors and a wet bar. Designed by architect Tulio Zuloaga, the home offers a gourmet kitchen with two islands, a breakfast bar, and a breakfast area with exposed beams. The formal dining room has tray ceilings, recessed lighting, and built-in speakers. The outdoor area includes a sundeck, landscaped pool, waterfall feature, and detached in-law suite with two full suites, kitchenettes, and a total of 1,142 sq. ft. of living space. The property is adjacent to horse trails and near 37 acre Lake Hendry, a private 37-acre man-made lake. The exclusive community provides access to Lakeside Lodge, a 100-acre meadow preserve, boat parking, a community boat launch, a playground, and a 24-hour fitness center. With only 160 home sites, this tranquil setting offers privacy and luxury. Additionally, the estate is located just 20 minutes from downtown and 30-45 minutes from major hospitals including Tampa General, Brandon Hospital, USF Medical, AdventHealth Wesley Chapel, BayCare Wesley Chapel, and St. Joseph’s Hospital. This is a rare opportunity to experience elegant Tuscan living with the convenience of nearby urban amenities. Buyer to verify all information. Measurements are approximate, and accuracy is not guaranteed.
MlsNumber: --
ListingId: TB8300833


Listing Provided By: Engel & Völkers Tampa Downtown, original listing
Phone: (813) 863-1986
Office Phone: (813) 863-1986
Agent Name: Virginia Bond
Disclaimer: Copyright © 2024 Engel & Völkers. 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 = 352 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 Susan Cioffi
Susan Cioffi
ASCIIRe/Max Realty Unlimited - The Cioffi Group
Call Today!: (813) 956-8513

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App