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;

2545 Nicholson Street
Hyattsville, MD 20782

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $662,500
Beds: 3
Baths: 5
Status: Active
SqFt: 2400
Agency: Coldwell Banker Residential Brokerage

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: OPEN SUNDAY 5/5 12-4pm With over 2,400 sq ft of living space, this four-story townhouses’ curb appeal benefits from its ample windows and spacious top-floor terrace overlooking the park. The "Wagner" model ground-level entrance opens to a foyer and a 14-by-14-foot room. It can be used as a home office, a recreation room, a home gym or a spare bedroom. This flex space has a bath, closet and a door that opens into the two-car garage with an opener and built-in storage. A wood staircase leads to the main living area, where a roomy kitchen is flanked by a family room and a dining area in the open floor plan. The gourmet kitchen and dining area, at a combined 25 by 27 feet, take up more than half of the second level. A long center island doubles as a breakfast bar, with seating for four. Stylish pendant light fixtures appear to float over the white center island. There’s also a pantry, plenty of cabinet and countertop space. Stylish cabinetry with crown molding lines the wall. Stainless-steel GE appliances, including wall ovens and quartz countertops are among the home’s many features. The dining area is in a sunroom-like setting with windows on two sides. On the other side of the kitchen is the sunlit, 19-by-15-foot family room with an ample sized deck overlooking the park. A conveniently located half bathroom (or powder room) is also on this level. There are three bedrooms and two full bathrooms on the third floor, including a private bathroom, with a double sink and a shower with an upgraded glass enclosure, in the owner’s bedroom suite. The suite also has a spacious walk-in closet. The two remaining bedrooms are on the opposite end of the hallway and share a hall bathroom that has a tub with a shower. There is also a laundry closet on this level hosting a full size washer and dryer. Another set of stairs leads to the top floor, which is primarily a large loft space divided into two sections facing the front and back of the residence. The generous sized space could easily be another bedroom, office, family room, etc. On the front end, a 19-by-10-foot terrace overlooks the gorgeous park and neighborhood. A bath is located on the back of the loft area. There are custom window treatments throughout the home. You will finid numerous upgrades as you tour the property like ceiling fans, conveniently placed outlets for wall mounted tv's, additional lighting, etc. With over 2,400 sq ft of living space, this luxurious home is perfect for entertaining. The neighborhood has a park with a tot lot and trails connecting to the Anacostia Tributary Trail System. Walk to West Hyattsville Metro Station, dining and retail options in the Shoppes at Art District, the Mall at Prince George’s, Takoma Park Shopping Center and Promenade Park, with trail connecting to Northwest Branch trail, all nearby. This stately home is a commuters dream that is close to downtown DC, Baltimore and surrounding areas.
MlsNumber: MDPG2104688


Listing Provided By: Coldwell Banker Residential Brokerage, original listing
Name: Coldwell Banker Residential Brokerage
Phone: (410) 224-2200
Office Name: Coldwell Banker Realty
Office Phone: (301) 718-0010
Agent Name: Elizabeth Cummings Bacigalupo
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 = 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;
Real Estate Expert Photo for Emcee Arah
Emcee Arah
ASCIISamson Properties
Call Today!: (301) 691-2209

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App