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

452 Sullivan Rd
Westminster, MD 21157

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 1860
Notes: This romantic setting could become a Bed & Breakfast with application approval. Classic design, one of a kind manor house boasts high ceilings, wide plank solid wood floors & gorgeous staircase. Large, stocked pond & a gazebo. Plenty of space for many picnic tables and lawn chairs to relax and enjoy use of this gorgeous pond! Bring your paddle boat and enjoy a swim in the hot weather days! The barn sq footage is approximately 8,456 sq ft! If you're looking for storage space this huge barn may suit your needs? The barn 's main level has brick paver flooring! (Possibility per Zoning Dept. County government to use this huge barn as an antique shop /arts & craft shop but must be approved by application for conditional use. The barn is 84 x 45 on two levels & 64 x 14 measure on the front 1 level portion. Ground level portion has brick pavers! Owner of this well-kept home has installed stone tile in kitchen, office, half bath and full bath. Half bath on main level could be enlarged, plenty of sq footage. The great room on the main level could possibly become a main level bedroom by adding closets in this large room where doors are already present. The 4 large upper-level bedrooms each have very large closets (see photos). Flagstone flooring installed 2015 in rec room on lower daylight basement walkout level that has a large wet bar. Lower level offers a 24 x 15 family room that also walks out to the 33 ft. stone patio. Half bath/ flush in basement near utility sink. Unique daylight basement partially finished (800 sq ft) has three walkout doors & four full size windows! The windows in this home were reglazed. Every metal roof was re-silvered in 2022. Updated 200-amp electric panel, year 2021 renovated the oil boiler, 2 large above ground oil tanks, electric water heater. Septic new in 1971, tile drain field 4 trenches & 1,250-gallon septic tank. Drilled well was 1967, 219 ft produced 4 1/2 GPM. New gutters & leaf guard after 2014 as well as preventative measure was exterior French drain around house foundation to offload drainage ground water away from dwelling. Per zoning regulations, the barn cannot be used for livestock, but fowl may be permitted with application approval.
MlsNumber: MDCR2017610


Listing Provided By: Long & Foster Real Estate, original listing
Name: Long & Foster Real Estate
Phone: (888) 536-0216
Office Name: Eldersburg
Office Phone: (888) 536-0216
Agent Name: Janet Kraus
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