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;

590 Freeman Street
Longwood, FL 32750

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $589,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2264
Agency: Keller Williams Winter Park

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1997
Notes: One or more photo(s) has been virtually staged. This home has it all! Boasting numerous updates and upgrades, this impressive 4-bedroom (all with BUILT-IN CUSTOM CLOSETS), 3 full bathroom Longwood abode offers a saltwater, screen-enclosed pool and spacious living with 2,264 sq ft. Nestled in a quiet cul-de-sac, enjoy privacy and scenic wooded views from the conservation area right outside.<br /> Through the double front doors, guests are greeted by soaring ceilings in the living and dining areas. Wood flooring runs throughout the first floor and energy-efficient PELLA DOUBLE-PANE windows with plantation shutters exude elegance. The separate kitchen features porcelain tile flooring and seamlessly flows into the family room overlooking the pool area. Stainless steel appliances (including a BOSCH dishwasher and NEW Samsung French Door fridge) complement the quartz countertops and breakfast bar, making it the heart of the home. Enjoy pool views from the custom-built banquette by the bay window, perfect for casual family meals.<br /> Two PELLA TRIPLE-PANE sliders, with built-in blinds (one in the kitchen and one in the family room), lead out to the screen-enclosed, paver patio and saltwater pool. A motorized retractable awning provides shade, while the NEW LED adjustable multicolor lights on the screen enclosure create a stunning light show at night. The fully fenced and landscaped backyard, with new fencing along the conservation area, ensures safety for kids and pets.<br /> Downstairs you’ll find one bedroom with built-in custom closets and a remodeled full bathroom with walk-in shower, along with a fantastic inside laundry room leading to the 2-car garage. Upstairs, beautiful wood flooring continues into two guest bedrooms and a beautifully remodeled hall bathroom featuring a glass-enclosed walk-in shower with colorful glass tile accents.<br /> The spacious primary suite boasts a cove ceiling, large walk-in closet, windows overlooking the pool, and an incredible en-suite with double-sink quartz vanity, glass-enclosed shower, jetted soaking tub, and private toilet room.<br /> Located in the serene Longwood Plantation neighborhood, consisting of only 94 homes, this residence occupies the BEST LOT. Historic Downtown Longwood, with its charming shops and restaurants, is just around the corner, along with excellent SEMINOLE County Schools.
MlsNumber: O6204195


Listing Provided By: Keller Williams Winter Park, original listing
Name: Keller Williams Winter Park
Phone: (407) 545-6430
Office Name: KELLER WILLIAMS WINTER PARK
Office Phone: (407) 545-6430
Agent Name: Steven Ritz
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