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

5100 42nd Ave
Hyattsville, MD 20781
Ann Barrett with College Park, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $785,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: --
Agency: College Park
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1891
Notes: Stunning Victorian situated on a landscaped corner lot in the heart of hip, happening, historic Hyattsville. Originally built in 1891, this property was lovingly and mindfully rebuilt from the studs up in 2001! So many updates including the unsexy things like new electrical wiring and pipes, new water and sewer lines to the street, plus a new architectural shingle roof in 2024! There are 2 heat-pumps plus a backup radiator system too! Welcoming wrap-around, covered porch has long-lasting composite flooring, a charming porch swing and window boxes. The entry hall has the original newel post & balusters, ceramic tile flooring and a spacious closet. The living room enjoys 2 exposures and has french doors to the side porch. Each window has a transom window above showing off the wonderfully high ceilings throughout this home. Gorgeous chandeliers brighten the open layout of the living and formal dining room. There's a half bath with storage too! The rear of this home is where you will live and love! Truly a chef's kitchen! This welcoming, open space is super beautiful and highly functional! High-end stainless steel appliances including a side-by-side GE Monogram fridge, a 5-burner gas cooktop with hood and electric & convection wall ovens. The deep sink and its touchless faucet is surrounded by 5 windows with views of the backyard and porch! You will actually love doing the dishes. There's an additional prep sink on the stainless steel island. Deep drawers and pull-out shelving throughout the kitchen - there's a place for everything - plus there's a 10 'x 5' pantry! The kitchen's raked ceiling seamlessly meets the family room's coffered 9'5"" ceilings. French doors lead you out to the spacious screened porch with vaulted ceilings and views on 3 sides; overlooking the fenced backyard with a beautiful stamped & stained concrete patio and brick walkway. Super useful shed and a grilling station with a Big Green Egg under a classic pergola for shade. Raised beds are ready for the season - there's plenty of room to plant and play. Upstairs the 15 x 15 primary bedroom enjoys an ensuite bath with glass door shower. The spacious walk-in closet has an elfa system and has plenty of room for 2. What a special treat to have a screened-balcony off your bedroom! The 2nd bedroom enjoys a Murphy Bed with bookshelves that can hide it away. The hall bath has a tub shower and ceramic tile. You will love having the laundry room on your sleeping level! Charming built-in ironing board and storage too! The top level is versatile space with its vaulted ceiling Need another bedroom, office or workout room or a bit of all three- there's room and gorgeous views too! Fabulous location within blocks of the Trolly Trail and Arts District shops & restaurants - including Franklin's Brew Pub, Yes Organic Market, Busboys & Poets, Streetcar 82, Pizzeria Paradiso and so much more! Artists and art lovers will love the proximity to Pyramid Atlantic and the shops at SoHy. Just 1.5 miles to two METRO Stations and to the MARC Train Station! Easy access to Washington, DC and the flagship Univeristy of Maryland. A very special home in a wonderful community. You will love living here!
MlsNumber: --
ListingId: MDPG2148900


Listing Provided By: College Park, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Ann Barrett
Disclaimer: Copyright © 2025 Long & Foster Real Estate. 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 = 3262 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