Title Page Background
DEBUG FN args: Array ( [0] => 321 [1] => [2] => [3] => agent ) BEFORE: Site: 321 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 321 Igate: njhud LocID: 321 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mdhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 321 [1] => [2] => [3] => lender ) BEFORE: Site: 321 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 321 Igate: njhud LocID: 321 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mdhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 321 [1] => [2] => [3] => other ) BEFORE: Site: 321 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 321 Igate: njhud LocID: 321 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mdhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => washington-ne [3] => DC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: washington-ne State: DC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: washington-ne State: DC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('mdhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Paula Kelly
Paula Kelly
ASCIIColdwell Banker Platinum One
Call Today!: (202) 251-7523

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App