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 = 3452 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 3452 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 3452 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;

10112 51st Avenue
College Park, MD 20740
Chris Craddock with EXP Realty, LLC, original listing - (833) 335-7433

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $540,000
Beds: 4
Baths: Full: 1, ½: 2
Status: Active
SqFt: 2099 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (833) 335-7433

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1954
Notes: Charming split-level home in College Park’s Sunnyside neighborhood! Welcome to this inviting 4-bedroom, 1 full two and half bath home on a quiet street, featuring four levels of comfortable living with charm and convenience.<br /> As you step inside, you'll be greeted by a bright and airy living room featuring large windows that flood the space with natural light, complemented by warm hardwood floors and a fireplace with built-in shelving. The updated kitchen boasts updated countertops, custom cabinetry, and stainless steel appliances, making meal prep a delight. A separate dining area leads to a sun-drenched family room with oversized windows.<br /> The upper level includes two comfortable bedrooms and a full bathroom, while the topmost level offers a private third bedroom. The lower level provides a versatile space with a fourth bedroom, a convenient half bath, and direct access to the fenced backyard—ideal for guests or a home office. There's also a basement for additional storage.<br /> Outside, enjoy a spacious, fully fenced backyard with a deck and a storage shed. The two-car driveway provides ample parking. With central air conditioning and a functional layout, this home is move-in ready.<br /> Sunnyside offers a welcoming community with its own playground and easy access to shopping at Mom’s Organic Market, IKEA, and Costco. The home is conveniently located near the University of Maryland, NASA/Goddard Space Flight Center, and the USDA Research Center. Commuting is a breeze with quick access to Route 1, I-495, I-95, I-295, and the Greenbelt Metro Station.<br /> Don’t miss this fantastic opportunity to own a beautiful home in one of College Park’s most convenient and desirable neighborhoods!
MlsNumber: --
ListingId: MDPG2143480


Listing Provided By: EXP Realty, LLC, original listing
Phone: (703) 688-2635
Office Phone: (833) 335-7433
Agent Name: Chris Craddock
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App