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

4923 Long Meadow Drive
Leesburg, FL 34748

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $494,900
Beds: 3
Baths: 2
Status: Active
SqFt: 2669
Agency: PAL Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: A Luxurious Find in the Plantation at Leesburg; Small Town Living with lots of Amenities. This 3 Bedroom w/Studio home is located on the 5th Fairway of Cranes Roost Golf Course. Open 2003 Custom Hydrangea. 2669 Sq. Ft. Eastern Exposure. ##### Spacious Kitchen w/Upgraded Quartz Countertops w/ Tabletop Edge; Pull Out Drawers; Under Cabinet Lighting; Upgraded Door Pulls; 2019 Fingerprint Resistant Graphite Appliances; Airy Front Porch W/ Front Patio; Laundry Room w/ Cabinetry And Utility Sink; Guest Room With Double Closets; Guest Bath w/ Upgraded Crushed Quartz Shower Enclosure & Countertop; Large Master Bedroom w/ Dual Walk In Closets; Master Bath w/ Upgraded Crushed Quartz Shower Enclosure & Countertops; Upgraded Soft Close Drawers; Upgraded Light Fixtures; Upgraded Cabinetry; Dual Sinks; Bidet Seat; Private Studio/Office; Climate Controlled Storeroom; Epoxy Painted Drive And Walkways; Expanded Garage w/ Upgraded Coach Lights; New Roof - 2023; 6 Inch Baseboards; Washer & Dryer Included; Solar Tubes in Great Room And Laundry; Screen Enclosed In-Ground Pool w/ Fiber Optic Lighting & Salt Chlorinator & Elevated Golf Course View; Some Items Negotiable; ##### You’ll want this home on your “must see” list. This community of 2,820 homes features beautifully manicured lawns, cascading waterfalls, lush palm trees, 24-hour staffed security, and amenities and activities to fit every taste, interest and budget. Residents enjoy three well-equipped multi-purpose clubhouses, three swimming pools, spring fed fishing ponds and much more. Scenic walking and biking trails meander through the neighborhoods of the broad community. The Plantation at Leesburg; Central Florida 55 Plus Active Adult Specialists in Gated Golf and Tennis Retirement Communities with Championship golf courses, equity memberships available, large clubhouses, heated pools, full time activity directors, 100+ activities per week, state of the art fitness centers, walking and biking trails & a 30-45 minute drive to all Orlando attractions! Information deemed accurate, but not guaranteed. Note: Property taxes may increase or decrease with reassessment after the sale. A MUST SEE! CALL TODAY!!!!
MlsNumber: G5073982


Listing Provided By: PAL Realty, original listing
Name: PAL Realty
Phone: (352) 326-3626
Office Name: PAL REALTY
Office Phone: (352) 326-3626
Agent Name: Cary Fier
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 Mortgage Pro

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 = 358 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 Michael R. Miller, NMLS#1730402
Michael R. Miller, NMLS#1730402
ASCIICrossCountry Mortgage, LLC
Call Today!: (330) 328-4084

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App