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

17541 Teagues Point Road
Hughesville, MD 20637

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $600,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3030
Agency: Redfin Corporation

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 1987
Notes: MAXWELL HALL! Located just a stone's throw away from Maxwell Hall Park, a nature and horse-lovers paradise featuring 14.2 miles of diverse riding trails, open fields, a jump course, wooded areas, steep terrain, shoreline, beach rest locations, and a trail course. This lovely farmhouse style home, owned by one owner in it's history, sits perched on a gently sloped hill surrounded by 3.38 acres. Landscaped, hardscaped and shows very well with an updated kitchen, bathrooms that included amazing tile and granite work. Details include: (Outside) 20 x 27 Belgrave Hardscape; Black Aluminum Fencing with 18’ x 8’ Spa/Swim Spa Combination; (2) 125 gallon propane tanks for the pool heater are owned and convey; 16 x 12 uncovered deck off kitchen with large fixed umbrella; 12 x 8 uncovered patio off basement; 24' x 12' shed; Leaf Guard Gutters; 30 yr. roof installed within the last 10 years; Garage Doors and openers less than 1 year old; Ring Doorbell; Ring Security Spotlight; Solar Attic Fan; Backyard surrounded by a Deer Fence for a dog/animal area. (Inside) Owner's Suite has Solid Wood Flooring: Walk in Closet with barn door; On suite full bathroom with pocket door, tiled floor and shower, double quartz top vanity; Room 2: Solid Wood Floor; Room 3: Solid Wood Floor; Room 4: Separate Heat and A/C, Laminate Plank w/ wood-look flooring & WIC; Upper Hall Bathroom Remodeled 5 years ago to include a tiled, HEATED floor, tiled ½ walls, and a quartz vanity top. On the main level of the home you'll notice details such as crown and chair rail moldings, solid wood flooring and true wood parquet flooring! The open kitchen includes solid Cherry wood cabinets, Top Grade Granite Countertops, Under Cabinet Lighting, Built-in hidden Spice Racks (2), Dishwasher, Stovetop, Hood with 2 vent speeds, GE Stovetop, GE Microwave/Convection Oven, GE Oven/Convection and NEW Whirlpool low-profile Refrigerator! The kitchen/living space is thoughtfully divided with a 1/2 wall that includes shelving and adorned with a matching granite top. The sunken living area has laminate flooring, brick hearth fireplace with wood-stove heatilator and flanked with built-in bookcases and features a bow window offering wonderful natural light. 2 car garage enters/exits from the breakfast nook area for easy grocery drop off. The basement is partially finished and includes so much storage area as well as space for exercise equipment and theater style seating area with a sound setup that conveys as does the furniture if desired. Laundry Room Washer/Dryer and Stand up Freezer convey. An office space is setup in the basement which offers an exit to the back yard open patio. There are many mature ornamental trees adorning this property including, but not limited to, Cherry, Dogwood, Flowering Magnolia, Japanese Red Maples & Holly. The holly tree on the left side of the house is over 100 years old and puts on a stunning Christmas Show! The fenced hardscape has Azalea bushes, roses and blueberries while raspberries surround the yard. This property is truly exceptional and feels tucked away while being close to PG, Calvert and St. Mary's counties all within 15 min. A must see! *Maxwell Hall Park is a membership-only facility for equestrians but open to the public for all other activities.*
MlsNumber: MDCH2032736


Listing Provided By: Redfin Corporation, original listing
Name: Redfin Corporation
Phone: (571) 477-1630
Office Name: Redfin Corp
Office Phone: (301) 658-6186
Agent Name: Farrah Fuchs
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.


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 = 1190 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;
Brian Crayton
ASCIICENTURY 21 Envision
Call Today!: (240) 473-3426

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App