Title Page Background
DEBUG FN args: Array ( [0] => 1188 [1] => [2] => [3] => agent ) BEFORE: Site: 1188 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1188 Igate: njhud LocID: 1188 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mdhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1188 [1] => [2] => [3] => lender ) BEFORE: Site: 1188 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1188 Igate: njhud LocID: 1188 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mdhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1188 [1] => [2] => [3] => other ) BEFORE: Site: 1188 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1188 Igate: njhud LocID: 1188 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mdhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

14958 New Windsor Rd
New Windsor, MD 21776
Joe McDonnell with Corner House Realty, original listing - (443) 499-3839

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1916 Square Feet
Agency: Corner House Realty
Agency Phone: (443) 499-3839

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1957
Notes: ***OPEN HOUSE SUNDAY MAY 4TH 1:00-3:00PM***Welcome to your new cozy, quiet, comfortable home settled at 14958 New Windsor Rd! Nestled off a picturesque windy country road of New Windsor, this charming all brick rancher currently 3 bedroom, 1 full bath bathroom rural home backing to a 52 acre private farm offers the perfect blend of comfort and country living with 3,800 total sqft. Situated on a spacious 2 acre scenic view lot, the property provides ample outdoor space for play, relaxation, gardening, or entertaining. This 2 acre lot includes approximately a 1/2 acre of level ground immediately adjacent to the house and yard. This space is perfect for use options such as playground, gardens, fruit trees, pet housing, or outbuilding. Inside, you'll find a bright and inviting, fairly open concept living room with large, picture windows, a formal dining room, French doors to the great room perfect for family gatherings or snuggling up by the wood/pellet stove (hookup ready) and 3 generous bedrooms of easy all on one level living complete with real hardwoods throughout the main level. The light-filled, warm kitchen boasts garden views, induction surface cooktop, double sink, refinished cabinets, peninsula island and pantry. Enjoy the peaceful surroundings while being just minutes from local shops, schools, and commuter routes to wherever you need to travel, or make working from home a breeze in this setting. This home offers the tranquility of rural life with easy access to everything you need. Don’t miss your chance to own this lovely home in the heart of the country! Schedule your private tour today and see all that this property has to offer. You won't be disappointed. UPDATES: New Driveway [2025], New Roof [2018], Water Heater [2020], Well Tank [2022], Gutters and Soffit [2020], New Slider.
MlsNumber: --
ListingId: MDFR2061324


Listing Provided By: Corner House Realty, original listing
Phone: (443) 499-3839
Office Phone: (443) 499-3839
Agent Name: Joe McDonnell
Disclaimer: Copyright © 2025 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => carroll-north [3] => MD [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: carroll-north State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: carroll-north State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mdhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Stacie Storm Miller, REALTOR, CLHMS, MRP, SRES, SRS, MD & PA Licensed
Stacie Storm Miller, REALTOR, CLHMS, MRP, SRES, SRS, MD & PA Licensed
ASCIIBHHS, PenFed Realty
Direct: (703) 577-4850
Office: (443) 627-2900

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App