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;

5209 Burnettsville Rd
Marion Station, MD 21838

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $642,000
Beds: 5
Baths: 4
Status: Active
SqFt: --
Agency: Long & Foster Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential
Year Built: 2005
Notes: Unique Opportunity - 5BR/3.5BA estate home and detached workshop/garage on 8.6+ acres. Masterfully-built custom home offers more than 4,000sf of extraordinary quality and artisan-crafted details throughout - soaring ceilings, custom wood doors, Italian marble, gourmet Viking appliances. Great floorplan offers several living, dining, and entertaining spaces - from the formal dining room, expansive living room, cozy family room, dream kitchen w/pantry, integrated commercial Viking fridge and new dishwasher, 2 huge sunrooms, wrap-around porch, and the large patio overlooking the acreage, backing to trees. 1st floor owner's suite is truly exceptional -- large sitting area w/a handsome fireplace, door out to the wrap-around porch, vaulted ceilings, built-in window seat, huge walk-in closet, full, en-suite luxe bath -- jetted corner tub, tiled shower, double-sinks, private water closet, walls adorned with Italian tile. Up the gorgeous hand-crafted staircase - the 2nd floor is perfectly symmetrical 4BR/2BA -- on both sides of the loft, overlooking the family room and foyer, are 2 bedrooms - each with a huge closet featuring custom built-in dressers, and a gorgeous full bath w/tiled shower. Energy-efficient and very well insulated - including spray-in insulation in the attic, and a concrete floor in the crawlspace. The multipurpose detached garage offers parking, workshop area, and loads of storage. Minutes to the best that Somerset County has to offer - boating, world-class fishing, crabbing, hunting, dining, arts, shopping, wildlife estuaries, incredible state parks - a true paradise for nature lovers, photographers, boaters, fishermen and anyone who wants to enjoy the relaxed pace on the Eastern Shore - from the beaches to the bays and beyond! 10mi to Crisfield, 12mi to Pocomoke's shopping hub. About 26mi to NASA / Wallops Island, 31mi to the beloved Chincoteague Island, and the incredible wild horses and sandy beaches of Assateague Island. Just 2-3 hours to major metro areas - Virginia Beach/Norfolk, Washington DC, Baltimore, Philadelphia, NYC. 30' ROW mentioned on the deed. Seller has flood insurance at $404/year. Sizes, taxes approximate.
MlsNumber: MDSO2004036


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Salisbury/Williamsport Circle
Office Phone: (888) 536-0216
Agent Name: Charlene L Reaser
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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