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

820 Stephens Pass Cove
Lake Mary, FL 32746

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $864,800
Beds: 5
Baths: 4
Status: Active
SqFt: 3284
Agency: Southern Realty Enterprises, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2011
Notes: Back on Market Priced $35,000 Below Appraisal Seller may hold loan for short term ! Seller will contribute toward Buyer closing costs<br /> Gorgeous WATERFRONT custom home located in the serene luxury highly sought after gated community Island Club in the Heathrow area. Welcome to your Florida oasis. This community is surrounded by breathtaking water views of Island Lake and Banana Lake. Enjoy taking in spectacular sunsets every evening in this beautiful home. Expect to be impressed with this 5 bedroom/3.5 bath meticulously maintained home boasting many high quality upgrades throughout. First Floor Spacious Primary Bedroom; Elegant en suite Primary Bath with all the best upgrades with oversized custom closets. Large main floor Flex Room-makes for a great office/play/gym/library; Light and bright open and spacious Kitchen and Family room combo. Stunning Chefs Kitchen with all Stainless Steel Appliances, Granite countertops offering ample prep and serving space, upscale back-splash, Solid Wood Cabinets, wine fridge, large Pantry and GE Monogram Gourmet Kitchen. Family Room Pre-wired for Surround Sound and all those wires discretely stored out of view in ceiling. Beautiful Engineered Hardwood flooring and Crown Molding throughout main floor and stairway; Custom Plantation Shutters throughout the home. Recessed and Elegant Chandelier lighting with medallion accents; Lighted fans in all rooms including patio area. 2nd floor includes a large open Game/Media Entertainment bonus room along with 4 spacious bedrooms. Two bedrooms include expansive walk in closets. Laundry room includes LG Ultra Capacity stainless Washer/Dryer. Step outside to your exquisite sanctuary and lake views. You will be delighted by the screened in lanai patio that is completely pre-wired and pre-plumbed for a Summer Kitchen. Garage has lots of added storage. This home has so many upgrades you will definitely appreciate every attention to detail. This home is located in the exclusive Heathrow community offering many fine dining restaurants, upscale shopping as well your favorite casual neighborhood hot spots, golfing and more. Top rated schools and hospitals nearby and both Sanford and Orlando Airport. You are minutes away from all the modern conveniences you desire. Work or play, it’s all here. Tons of fun places to explore and only a short drive to venture out to the sparkling ocean, best entertainment and the many theme park and attractions. Everyone deserves the great Florida Lifestyle. It’s time to make it your home.
MlsNumber: O6083572


Listing Provided By: Southern Realty Enterprises, Inc, original listing
Name: Southern Realty Enterprises, Inc
Phone: (407) 869-0033
Office Name: SOUTHERN REALTY ENTERPRISES
Office Phone: (407) 869-0033
Agent Name: Frank Filippelli
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 = 382 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;
Diane Sterling
ASCIIKeller Williams Realty Advantage
Call Today!: (407) 761-0512

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App