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

1319 Shoreline Drive
Swanton, MD 21561

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,895,000
Beds: 6
Baths: 6
Status: Active
SqFt: 5789
Agency: Railey Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2004
Notes: Spectacular 6 bedroom 5.5 bath, 2 car garage lakefront retreat located in the desirable Thousand Acres community! This spectacular property includes 1.6 acres of gently sloping property with 100' of prime lakefront. With western exposure and incredible sunsets, the property offers a great mixture of indoor and outdoor living spaces. <br /> <br /> The open floor-plan includes an amazing great room with a window wall that provides generous amounts of natural lighting. There are 6 sleeping suites on 3 levels, each with direct bath access. A large dining/kitchen area with seating for everyone is on the main level and a bar/kitchenette is on the lower level offering close proximity to the family and game rooms. <br /> <br /> There are four distinct indoor living spaces offering opportunities for activities and relaxation. For outdoor lovers, the property offers several outdoor gathering spaces including a fire pit and a covered/screened porch . There are also 3 fireplaces throughout the house. Located on a private road with limited vehicle activity, walking, and biking are favorite activities throughout the community. For golfers, the recently completed Thousand Acres Golf Club is receiving rave reviews and is located within a couple miles of the property. <br /> <br /> Additional features: <br /> Strong rental potential<br /> Whole house generator <br /> Qualifies for a Type A dock<br /> Level year round driveway access<br /> <br /> DISCLOSURE: RAILEY REALTY IS NOT THE CARETAKER OF PROPERTIES LISTED BY IT. DURING INCLEMENT WEATHER CONDITIONS, PROSPECTIVE PURCHASERS AND THEIR AGENTS ASSUME ALL LIABILITY ASSOCIATED WITH OR BY WEATHER AT THE PROPERTY.
MlsNumber: MDGA2006088


Listing Provided By: Railey Realty, Inc., original listing
Name: Railey Realty, Inc.
Phone: (301) 387-2000
Office Name: Railey Realty, Inc.
Office Phone: (301) 387-2000
Agent Name: Bill Weissgerber
Disclaimer: Copyright © 2024 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App