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

31881 Mitchell Road
Princess Anne, MD 21853
Mike Beauchamp with Hall Realty, original listing - (410) 957-1888

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $479,900
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2046 Square Feet
Agency: Hall Realty
Agency Phone: (410) 957-1888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: Have you been dreaming of owning a horse farm that is all set up and ready to go? Then you owe it to yourself to take a look at this property situated on just under 6 acres. Approximately 4 of the acres are fenced in pasture that is well-established. Inside this large area are smaller fenced in areas as well. Next to the pasture is a 5 stall stable. This well built masonry constructed building provides shelter as well as extra protection during extreme weather. Each stall can be entered from the outside with 4 stalls that have access to a tack room complete with concrete floor. This tack room is also set up to be used as a firing range. there are several outbuildings to store supplies and all of your equipment. Close to the house is a detached garage and a heated building with concrete floor that can be used as a shop. This could also be set up as a man cave or she shed. What sets this horse farm apart from others is an adjacent 2,000 acre public preserve area owned by the State. This is located directly beside and behind the property. You don't have to worry about someone else building around you. There are over 7 miles of trails for riding. Parking is just down the street, but you have direct access from the back of the farm with a trail to enter from. Imagine the convenience of saddling up and being able to ride anytime you would like. The 4 bed, 2 bath home sits back from the road for quietness and privacy. Enter from the side into the separate mudroom that keeps you from tracking dirt into the house. From there you can go to the laundry room and behind that is a full bath. A hall opens into a large kitchen which has been remodeled with plenty of cabinet space and an island as well. The countertops are solid surface Corian. The dining room is next to the kitchen with room for large family gatherings. The living room is located in the front and features a rustic stone gas fireplace with built-in cabinets and shelves. The open foyer next to the living room has a staircase to the 2nd floor and the front door that leads out to a covered porch. Upstairs are 4 ample sized bedrooms and a full bath. The front porch is a good place to sit and relax overlooking the huge front lawn. You can entertain family and friends on the patio which has a pergola located next to the porch. The crawlspace has been encapsulated and includes dehumidifier. If horses aren't your thing, this could be a gentleman's farm with room for an expanded garden, or a place for sheep or alpacas. This property has so much more than what is described here. You really need to see for yourself the possibilities this property has to offer.
MlsNumber: --
ListingId: MDSO2005092


Listing Provided By: Hall Realty, original listing
Phone: (410) 957-1888
Office Phone: (410) 957-1888
Agent Name: Mike Beauchamp
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