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

697 Stonefield Loop
Lake Mary, FL 32746
Qiong Zavala Wang with MORRIS WILLIAMS REALTY, original listing - (888) 326-3949

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,900
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3799 Square Feet
Agency: MORRIS WILLIAMS REALTY
Agency Phone: (888) 326-3949

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: One or more photo(s) has been virtually staged. Gorgeous Single Story that Completely Remodeled located in the Exclusive and Highly Sought After STONEBRIDGE Neighborhood of HEATHROW. The FINEST MATERIALS were chosen for this Amazing HOME with 4 Bedrooms, 4 Baths, HUGE Custom Laundry, Mud Room, and Executive Office, 12' High Ceiling of the Garage! Upon entering, you will be greeted by an open area with high ceilings, followed by massive space offered by the integrated family room with HUGE POCKET DOORS and dining room with POOL view! The kitchen is the Chef's Dream that next to the living room has a HUGE HIDDEN PANTRY offers <br /> a fully equipped New Kitchenaid appliance package which includes (60" Rangehood, 48" Gas Cooktop, 48" Built-in Refrigerator, Wine Cooler, Wall Built-in microwave combo), Custom Cabinetry with Soft closing doors, Elegant Taj Mahal Quartzite countertops, full Backsplash, and Oversized Islands! Master bedroom sits on the rear of the office with Plenty of space along a luxury bath that has the largest tile 72" X 48" throughout with a freestanding tub, big shower, double vanity with all drawers, and extra width of the countertops and a large customized walk-in closet. There is 1 Suite and 2 bedrooms and 1 bathroom at the end of the other side along the hallway. The patio has a large covered lanai, and the huge pool is the perfect home for entertaining. <br /> $600K Upgraded including High quality New Windows and Doors/Pocket/Sliding Doors with that are Florida approved and Exceed 130 MPH Wind Ratings and Energy Star with Manufacture Lifetime Warranties! New Large Tile Flooring and New Engineering Hardwood Flooring throughout.<br /> Pinewood Crown Moldings, trims and baseboards! New landscaping, pool screen and new painting outside and inside including ceilings! Quartzite countertops throughout all baths, kitchen and laundry. New Gas water heater, softener system, water filter, washer dryer.<br /> Re-Piped! New insulation! New pavers for the driveway and walkway! New Gutters! , gutters, maintained the tile roof, New light textures and ceiling fans, etc. Heathrow is a desirable community in Central Florida! It offers many amenities. The Homeowners' Association including Parks, playgrounds, multi-purpose fields, and more! Heathrow Country Club memberships are also available for golf, pool, tennis etc. Close to I-4, 417, wonderful schools, fine restaurants, shopping plus miles of walking and bike trails!
MlsNumber: --
ListingId: O6297042


Listing Provided By: MORRIS WILLIAMS REALTY, original listing
Phone: (951) 396-9627
Office Phone: (888) 326-3949
Agent Name: Qiong Zavala Wang
Disclaimer: Copyright © 2025 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','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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 Joy Martin
Joy Martin
ASCIILPT Realty LLC
Call Today!: (386) 631-1299

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App