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','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 = 3452 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 = 3452 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;

4749 Cherokee Street
College Park, MD 20740
Mandy Hursen with RLAH @properties, original listing - (202) 518-8781

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $640,000
Beds: 3
Baths: Full: 3, ½: 2
Status: Active
SqFt: 2472 Square Feet
Agency: RLAH @properties
Agency Phone: (202) 518-8781

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Townhouse
Year Built: 2019
Notes: Coming soon! A Rare Gem in the Heart of College Park — The Townhome You've Been Waiting For!<br /> <br /> Step into a life of elevated living at The Metropolitan of College Park. Immaculate, four-level townhome boasting a rooftop deck with sweeping panoramic views and a private two-car garage. Gently lived in and just five years young, this turnkey masterpiece offers the ideal blend of luxury and practicality, promising a lifestyle as seamless as it is stylish.<br /> <br /> With 2,500 square feet of thoughtfully curated space, this residence is currently designed with 3 generously sized bedrooms, 2 versatile flex rooms, and 3 full baths plus 2 powder rooms. Easily adaptable into a 4-bedroom haven with a simple addition of a wall and door on the entry level. If closet space is important you will be very happy here! <br /> <br /> From the moment you step inside, you'll be captivated by the attention to detail. Gleaming wood floors flow across the sun-drenched main level, where soaring ceilings and custom architectural finishes create an atmosphere of refined elegance. A formal dining space framed by timeless wainscoting leads into an expansive, chef-inspired kitchen featuring an oversized island that comfortably seats four—a true entertainer’s dream.<br /> <br /> Ascend to the top floor to discover a sanctuary in the sky: the third bedroom, a full bath, and a charming loft space that opens onto a private rooftop deck—your personal oasis, perfect for morning coffee, sunset toasts, or stargazing nights.<br /> <br /> Additional highlights include:<br /> <br /> Every room features gigabit hardwired connections and a fully integrated wireless mesh network for seamless, ultra-fast internet connectivity throughout the home.<br /> <br /> Convenient laundry on the bedroom level.<br /> <br /> Private two-car garage plus 2 additional registered parking spots and 2 guest passes.<br /> <br /> Low HOA fees in a prestigious Lennar-built community.<br /> <br /> Energy-efficient, smart-home features.<br /> <br /> Easy access to Greenbelt Metro, major bus lines, I-495, and University of Maryland.<br /> <br /> Live moments away from vibrant restaurants, shopping, and entertainment, yet tucked into a peaceful community with modern charm and timeless appeal.<br /> <br /> Ideal for homeowners and investors alike, this property qualifies for the Live + Work College Park Program, offering up to $20,000 in down payment assistance to eligible buyers employed in the City of College Park.
MlsNumber: --
ListingId: MDPG2147654


Listing Provided By: RLAH @properties, original listing
Phone: (202) 518-8781
Office Phone: (202) 518-8781
Agent Name: Mandy Hursen
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

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','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;
Kinder Vaughan
ASCIIKeller Williams Preferred Properties
Call Today!: (240) 595-0687

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App