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

2335 Theodore Road
North East, MD 21901
Tracy McCullough with Remax Vision, original listing - (410) 287-3629

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,190,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4638 Square Feet
Agency: Remax Vision
Agency Phone: (410) 287-3629

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: **PROFESSIONAL PHOTOS BEING TAKEN ON MONDAY 11/18. WILL BE UPLOADED ON TUESDAY, 11/19** Do not sleep on seeing this AMAZING property! The meticulously maintained home was built in 2017 and has 5 bedrooms, 3 full baths, and 2 half baths and has 4638 sf of above grade living apace and sits on nearly 6.5 acres. The main level offers an open floor plan and has LVP flooring throughout (with the exception of the owners suite). Set up like a ranch style home on the main level, you'll find 3 bedrooms and 2.5 baths. The massive gourmet kitchen has soft close cabinets, granite counters, tile backsplash, and professional style Thermador stainless steel appliances to include a 48' gas range with steamer oven, warming drawer and pot filler above as well as a 54" wide refrigerator/freezer. The kitchen also has a large center island with a prep sink and a breakfast bar. Living room is open to the breakfast nook with sliders to rear composite deck and a dining room. On the left side of the house, you'll enter through the garage to find the entrance to the upstairs in-law suite on the right and the laundry suite to the left. Bedrooms 2 and 3 share a Jack and Jill bathroom. The Owners suite is on the right side of the house and has a sitting area, 2 walk-in closets, and a large bath with tiled shower and soaking tub. Upstairs in the newly completed in-law suite is 2 additional bedrooms, a full bath, and a living room. The partially finished basement has a theater room which includes theater seating, theater system, and a projector. The HVAC has heat pumps in 4 zones and radiant floors on the main level. 500 gallon propane tank is and owned as well as a whole house filtration system. Attached is a 2 car oversized garage and a 40 x 60 pole barn with 200 amp electric service and a floored upper level for additional storage. Relax in the summertime in your above ground pool and enjoy the surrounding farmland or catch a race at the nearby Cecil County Dragway. Paved circular driveway and inground sprinkler system to keep the yard looking sharp! Call, text, or message me for more information!
MlsNumber: --
ListingId: MDCC2014486


Listing Provided By: Remax Vision, original listing
Phone: (302) 453-3200
Office Phone: (410) 287-3629
Agent Name: Tracy McCullough
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.


Local Real Estate Expert

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 = 1189 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;
Real Estate Expert Photo for Michelle Kahl
Michelle Kahl
ASCIIColdwell Banker Realty
Call Today!: (410) 790-8402

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App