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

Foreclosure: 5200 Kansas Avenue Nw
Washington, DC 20011
Joseph Himali with RLAH @properties, original listing - (301) 652-0643

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,000,000
Beds: 7
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2567 Square Feet
Agency: RLAH @properties
Agency Phone: (301) 652-0643

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Townhouse
Year Built: 1932
Notes: 5200 Kansas Avenue is a stunning, fully renovated from top-to-bottom, end of row townhome in the heart of Petworth that offers a perfect blend of classic charm and modern convenience. The main level opens to a foyer and offers gracious room proportions with a large, sun-filled living room that benefits from three exposures, allowing natural light to pour in throughout the day. The space is enhanced by elegant crown molding and gleaming hardwood floors, creating a warm and inviting atmosphere. Centering the space is a wood-burning fireplace, and on both sides, are French doors opening onto a spacious deck, providing a seamless transition to outdoor living and entertaining. ------<br /> Across from the living room is a formal dining room, complete with chair railing and crown molding. This space offers the perfect setting for holiday gatherings or intimate dinners. The all-new galley kitchen is features white shaker-style cabinets, stainless steel appliances, and granite counters. A cozy breakfast nook off the kitchen overlooks the backyard and offers direct access to the backyard, which features off-street parking. Completing the main level is a private den, tucked just off the living room, which is ideally suited as a home office or study. The den also provides access to the powder room. ------<br /> Upstairs, the second level offers four generously sized bedrooms, each filled with natural light and outfitted with ample closet space and glistening hardwood floors. The primary bedroom suite serves as a peaceful sun-flooded retreat, featuring two closets and an ensuite bathroom. There is also an all-new full bathroom in the hall. The top level of the home adds even more flexibility, with a fifth bedroom featuring heart pine floors and a large closet. ------<br /> The fully finished lower level offers expansive additional living space and its own outdoor access. This level includes a large family room, ideal for movie nights or recreation, as well as two additional bedrooms. A beautifully renovated full bathroom serves the lower level, and the stacked washer/dryer can also be found here. ------<br /> Situated in the vibrant Petworth neighborhood. Enjoy easy access to Rock Creek Park, the Upshur Street corridor with its diverse selection of cafes, restaurants, and boutiques, and the bustling Petworth Farmers Market. The neighborhood also boasts excellent public transportation, with nearby Metro station and bus lines making commutes a breeze.
MlsNumber: --
ListingId: DCDC2165744


Listing Provided By: RLAH @properties, original listing
Phone: (301) 652-0643
Office Phone: (301) 652-0643
Agent Name: Joseph Himali
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 = 321 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 Summer Davis
Summer Davis
ASCIICoalition Properties Group Keller Williams
Call Today!: (202) 517-7815

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App