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 = 1182 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 = 1182 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 = 1182 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;

18909 Legislative Road Sw
Barton, MD 21521

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $279,000
Beds: 6
Baths: 3
Status: Pending
SqFt: 3156
Agency: The Goodfellow Agency

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1920
Notes: NOW OFFERING $10,000 seller concession with acceptable offer! Unique & rare opportunity to own a piece of historic Real Estate in the quaint town of Barton, MD. The Red House on the Hill sits on a beautiful lot and features much of its original charm, while offering endless opportunities. On the main floor you will find ample living space, including two living rooms, a family room, a formal dining room, attached sun porch, eat-in kitchen and even a half bath. Be sure to take notice of the beautiful woodwork throughout, such as hardwood floors, wood trim, pocket doors, and several built-ins. There are many large windows to let in beautiful natural light and a gas fireplace. It is obvious when viewing this property that it is not lacking in storage space. There are ample closets and storage in just about every room. On the second story you will find 6, yes 6, bedrooms and 2 full bathrooms. Again, lots of closets and even more storage. You will even find a second staircase leading down to the kitchen.<br /> <br /> As if the house itself is not enough, outside you will find a large shaded front porch, an attached carport, rear patio, storage shed/washhouse AND a two car detached garage with a full apartment above. With some updating, this space could serve as a guest house, apartment, home office, etc. as it features its own private entrance, has a full kitchen, bathroom and an even an attic. This property is located right next to a wonderful playground. The uses for this property are plenty! Home Warranty included for the buyer. Don't miss this opportunity! Call today to inquire! Prequalified buyers only!
MlsNumber: MDAL2004478


Listing Provided By: The Goodfellow Agency, original listing
Name: The Goodfellow Agency
Phone: (301) 689-8857
Office Name: The Goodfellow Agency
Office Phone: (301) 689-8857
Agent Name: Elizabeth Hobel
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