Title Page Background
DEBUG FN args: Array ( [0] => 1189 [1] => [2] => [3] => agent ) BEFORE: Site: 1189 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1189 Igate: njhud LocID: 1189 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 = 1189 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1189 [1] => [2] => [3] => lender ) BEFORE: Site: 1189 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1189 Igate: njhud LocID: 1189 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 = 1189 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1189 [1] => [2] => [3] => other ) BEFORE: Site: 1189 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1189 Igate: njhud LocID: 1189 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 = 1189 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

103 Fred Dr
North East, MD 21901
Tyrone Maxwell with Keller Williams Gateway LLC, original listing - (443) 318-8800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $629,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3695 Square Feet
Agency: Keller Williams Gateway LLC
Agency Phone: (443) 318-8800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Stunning Jefferson Home – 4362 SqFt Spacious, Modern & Perfect for Entertaining!<br /> Welcome to the beautifully designed Jefferson, where elegance meets functionality in a seamless open-concept layout. As you arrive, you’re greeted by a charming covered front porch, the perfect spot to relax with a morning coffee, unwind in the evening, or enjoy rainy days while staying dry. This inviting space enhances curb appeal while providing a cozy outdoor retreat.<br /> <br /> As you step through the front door, you're welcomed by a grand, open foyer leading to a spacious choice room—ideal as a library, private home office, with a half bath just off the room. From here, the main level unfolds into a seamless open floor plan, creating an inviting flow between the great room, breakfast nook, and chef-inspired kitchen.<br /> <br /> Dream Kitchen with Long Island, Wood Flooring & Walk-In Pantry<br /> <br /> At the heart of the home is the chef-inspired kitchen, featuring a long kitchen island that offers ample prep space, seating, and a natural gathering spot for family and guests. The beautiful wood flooring in the kitchen adds a touch of sophistication while making cleanup effortless. Designed for both style and function, the kitchen boasts plenty of cabinet space, outside vented exhaust and a sizeable pantry.<br /> Just off the kitchen, you'll find a great room with ample space for theater seating and large television.<br /> <br /> Second Floor Retreat<br /> <br /> Upstairs, the Owner’s Suite is a private oasis, featuring a a sprawling bedroom with an elegant tray ceiling, adding architectural charm and a touch of luxury bedroom, walk-in closet, and a luxurious ensuite bath with multiple layout options. Enjoy double vanities, and a separate glass shower, large Venetian-style soaking bath, designed for spa-like relaxation.<br /> <br /> Three additional generously sized bedrooms, all with sizeable closets, provide ample space for family, guests, or creative use. The versatile loft can be kept as a cozy lounge or converted into a fifth bedroom for even more flexibility. A full hall bath and a large laundry room with counter space complete this level, offering both convenience and functionality.<br /> <br /> Convenient Upstairs Laundry Room<br /> <br /> No more carrying laundry up and down the stairs—this home features a spacious upstairs laundry room, designed for maximum convenience. With ample counter space and storage, it makes laundry day effortless and helps keep your household organized.<br /> <br /> Fully Finished Basement – Extra Living & Entertaining Space<br /> <br /> The finished basement with walkout access adds even more living space and flexibility to this incredible home. Fully carpeted for comfort, this space is perfect for a home theater, game room, gym, or additional family room. The full basement bathroom adds convenience, making it an excellent option for guests or extended stays.<br /> <br /> Expansive Corner Lot with Ample Parking<br /> <br /> Situated on a large corner lot, this home offers plenty of outdoor space, a 2-car garage with side door access, a 4-car driveway, and dedicated RV parking—providing room for at least 6 vehicles and more.<br /> With numerous upgraded options, from expanded living spaces to upgraded finishes, the Jefferson ls the home of your dreams. Don’t miss your chance to own this exceptional property—schedule your private tour today!
MlsNumber: --
ListingId: MDCC2015908


Listing Provided By: Keller Williams Gateway LLC, original listing
Phone: (410) 342-4444
Office Phone: (443) 318-8800
Agent Name: Tyrone Maxwell
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] => cecil [3] => MD [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cecil State: MD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cecil 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 = 1189 AND i.igate IN ('pahud','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 = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
JAMES JONES
ASCIIeXp Realty
Call Today!: (302) 559-4332

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App