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;

1321 Western Chapel Road
New Windsor, MD 21776

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $624,999
Beds: 5
Baths: 3
Status: Pending
SqFt: 3375
Agency: Winning Edge

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1969
Notes: ** FIRST TIME TO THE MARKET ** Find your personal haven in this remarkable and distinctive Custom Built Rancher/ Rambler that has had only One Owner. This home is a one of a kind, masterfully crafted with impressive finishes at every turn...the Owner's attention to detail is nothing short of magnificent! Only the finest materials were chosen to adorn every square foot of this masterpiece. Every room thoughtfully designed to feel warm and exceptionally inviting. Situated on 2.48 lush acres, embraced by nature. Highlights include: 2 functioning Wells, optional separate Office/Au-Pair or In-Law suite with private entrance, Anderson Windows, 2 Sided Fireplace, Red Oak hardwoods, New Luxury Bamboo Floors, Hand Huen Chestnut Beams, New HVAC 2023, Buderus Boiler System and whole home central vacuum system. Main Level living features an expansive Living and Family Rooms with expertly placed solid wood beamed ceilings, 2 sided wood burning Fireplace and perfect red oak hardwood floors. There is a Primary Suite w/ new bamboo floors and en-suite full bath, 3 additional large bedrooms, all with new bamboo floors, Massive hallway Walk-in Closet and a hallway full bathroom. The Kitchen is well designed for entertaining & cooking! Also adorned w/ beamed ceiling, rich cherry cabinerty, granite counters, breakfast nook with spectacular views and formal Dining Room off Kitchen. Off the Kitchen is the Laundry Room, half bath, access to 2 car garage & optional Office/Au-Pair or In-Law suite with private entrance . Partially Finished lower level walk-out has a sprawling recreation room w/ new wood based laminate plank floors, wet bar and game room. Plenty of lower level storage and ENORMOUS 47x27 Workshop area in basement with private entrance! 2 Car garage, driveway w/ retaining wall w/ parking for 12. Outdoors is a wooded, private lot abundant with wildlife plus a variegated pattern Blue Stone Patio to enable you to sit back, relax and revel in priceless views of scenic vistas and mountainous terrains. This is a home you must witness to fully appreciate...Schedule your Showing TODAY! ** USDA LOAN ELIGIBLE HOME - may be eligible for 100% financing - Contact the listing agent for a trusted lender to review if you qualify **
MlsNumber: MDCR2018620


Listing Provided By: Winning Edge, original listing
Name: Winning Edge
Phone: (443) 463-6009
Office Name: Winning Edge
Office Phone: (443) 463-6009
Agent Name: Jim Bim
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