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

314 Heatherwood Court
Winter Springs, FL 32708

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $980,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 3823
Agency: CENTURY 21 Alton Clark

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: Under contract-accepting backup offers. Exceptional opportunity to own in The Reserve at Tuscawilla, a prestigious gated community where luxury meets functionality. As you enter this home, you’re immediately greeted with a dedicated office complete with built in desk, vaulted ceiling, and beautiful hardwood floors. Directly adjacent to the office is the dining room which boasts travertine floors, tray ceiling, and beautiful archways. As you make your way further into the home, you come to the family room area which can only be described as the heartbeat of the home. The family room features a gas fireplace, coffered ceiling, custom built ins and custom mantle, and all while providing direct access to the pool via sliders. Overlooking the family room is the gourmet kitchen which features granite counters, stainless KitchenAid appliances, double oven, glass cooktop with hood, custom cabinets, custom backsplash, breakfast bar, and walk in pantry. The breakfast nook which seamlessly connects the kitchen to the family room is large and overlooks the patio and pool area. The downstairs Master Suite is oversized featuring a sitting area, tray ceiling, direct access to the pool via French Doors, his and hers walk in closets, and an ensuite bath boasting dual vanities, jacuzzi tub and a custom tiled glass enclosed shower with dual heads. Also located downstairs is a bonus room that’s a perfect place for a home theater or game room and comes with a bar making this home ideal for entertaining. As you make your way upstairs to the guest bedrooms you first encounter a loft area perfect for a children’s play area or tv room. The upstairs bedrooms are all oversized with one having its own dedicated bathroom while the other two share a large jack and jill bathroom. The resort-style pool and spa are set in a beautifully designed outdoor area with a large, covered patio complete with summer kitchen making this a perfect area for relaxation and entertainment. For those with multiple cars or toys, a large 3-car side entry garage accommodates just about any toys you could bring. Families will appreciate the safety and tranquility of living on a cul-de-sac, free from through traffic. If that wasn’t enough, this home is only a few minutes away from Tuscawilla Country Club as well as some of Seminole Counties best schools, dining, shopping, and entertainment. If you’re looking for a turnkey luxury pool home in Winter Springs, then look no further because you’re home.
MlsNumber: O6168896


Listing Provided By: CENTURY 21 Alton Clark, original listing
Name: CENTURY 21 Alton Clark
Phone: (407) 575-7011
Office Name: CENTURY 21 ALTON CLARK
Office Phone: (407) 636-4637
Agent Name: James Clark
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 = 3222 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 Rick Brown
Rick Brown
ASCIIBrown Home Group at KELLER WILLIAMS REALTY
Call Today!: (407) 383-1866

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App