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','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 = 358 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 = 358 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;

26812 River Watch Court
Leesburg, FL 34748

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $397,000
Beds: 2
Baths: 2
Status: Pending
SqFt: 1878
Agency: LoKation Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2006
Notes: Under contract-accepting backup offers. Welcome to Affordable Golf-Front Living in Highly Sought After Arlington Ridge Guard Gated Active Adult Golf Community in beautiful Central Florida where the mild winters are perfect for year round outdoor activities. BOTH BONDS PAID OFF! Major Updating includes 2 year old roof & central vac system. 2 BLOCKS FROM FABULOUS AMENTIES, PUB & RESTAURANT. Homes has 9 foot ceilings throughout and engineered hardwood & crown molding in main part of home, 2 Bedroom 2 Bath, plus den/man cave and over-sized 700 s.f. 3 car tandem garage, 1,878 conditioned S.F. and 200+ s.f Golf-Front fully enclosed ALL-SEASON FLORIDA ROOM not included in the conditioned square footage, Great location on quiet no traffic cul-de-sac, Long driveway for plenty of off-street parking Low-Maintenance Stucco Home with decorative driveway on a 1/4 acre Lot that is large enough to add a bird cage or pool. Low HOA of $118 per month includes mowing, edging and blowing, 200+ channels cable T.V., 250 megabyte hi-speed internet, Wi-Fi router to broadcast signal all around home, 2 DVRs in the cloud to record shows on. Home has open floor plan, 9 foot ceilings and through main part of home and master bedroom. The large kitchen features plenty of cabinets & countertops and breakfast nook and is perfect for entertaining friends and family. Gas range and fridge are included as well as washer & dryer The Master bedroom has tray ceiling and en-suite bath with a walk-in shower for safety & jetted soaker tub, over-sized his & hers walk-in closets, His & Hers solid surface vanities., A dedicated indoor Laundry Room with washer & dryer that stay. This residence is constructed to high standards, meeting wind code requirements, boasting high elevation with no chance of flooding or storm surge. As a result, the property qualifies for deep and affordable insurance discounts . Arlington Ridge is an in demand Central Florida community, offering an array of Resort Style amenities, including an 18-hole golf course, driving range, tennis & pickleball courts, 2 heated swimming pools, a professionally equipped fitness center, sidewalks throughout community for n evening stroll, low speed limit streets for a bike ride and more. With close proximity (3 minutes) to grocery stores, restaurants, (10 minutes) Free Boat Ramp & 50,000 acres of fresh-water Big Bass Fishing, Emergency Room, medical facilities, dog park, walking trails and a multitude of recreational opportunities, (20 minutes to Mall with 12 screen theater, arcade, indoor ice skating & go carts (45 minutes) to Orlando Airport, (90 minutes) to Atlantic ocean & Gulf of Mexico, This location and mild Florida weather are perfect for year-round recreation and enjoyment. Don't miss the chance to make this exceptional property your home sweet home. Schedule a showing today before this gem in Arlington Ridge is gone! SJS 2024 ©
MlsNumber: G5081027


Listing Provided By: LoKation Real Estate, original listing
Name: LoKation Real Estate
Phone: (954) 545-5583
Office Name: LOKATION
Office Phone: (954) 545-5583
Agent Name: Steven Simpkins
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','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;
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