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

6023 Workers Dr
Brooklyn, MD 21225

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $439,000
Beds: 3
Baths: 4
Status: Active
SqFt: 1920
Agency: RE/MAX Aspire

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: *** Save thousands on like New Construction (Never lived in) without the large deposits and without paying all of the transfer taxes at closing. Receive a seller credit towards 2/1 rate buy down, if loan program allows, for a ratified contract on or before April 30, 2024 with preferred lender Neo Home Loans & Scott Rosenthal. Seller willing to accept offers utilizing down payment assistance programs through preferred lender. This home has never been lived in and is the former model home for Ryan Homes in this community.*** 3 bedroom, 3.5 bathroom end unit townhome boasts a generous 1,920 square feet of beautifully finished living space. Partial stone plus an abundance of windows. Arrival center on the ground floor, perfectly situated alongside the home's third bedroom and bathroom. Recreation room on the ground entry floor with walkout slider to rear yard. Step upstairs to discover luxurious LVP flooring that connects the kitchen, family room, dining room, and bathrooms. Gourmet kitchen, granite countertops, stylish island, and a full stainless steel appliance package with gas cooking. LED under-cabinet lighting and a chic tiled backsplash. The living room is primed for entertainment with HDMI connectivity, while the rear composite deck offers an outdoor retreat. On the top level, the two bedrooms are each illuminated by LED lighting. The master suite features a bathroom complete with tiled walls, plus a bench, promising a private retreat for rejuvenation. Washer/dryer included! The community pool promises endless summer fun. This townhome is not just a house, but a lifestyle opportunity in the sought-after location of Cedar Hill!
MlsNumber: MDAA2079538


Listing Provided By: RE/MAX Aspire, original listing
Name: RE/MAX Aspire
Phone: (410) 465-8300
Office Name: RE/MAX Aspire
Office Phone: (410) 465-8300
Agent Name: Daniel Iampieri
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App