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

62 G Street Sw
Washington, DC 20024

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $768,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1728 Square Feet
Agency: Real Broker, LLC
Agency Phone: (855) 450-0442

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 1961
Notes: Welcome to urban sophistication with a mid-century modern vibe in this captivating three-story townhouse in the vibrant Capitol Park community. This residence, one of the largest models in the community, embodies the perfect blend of modernity and historic allure, offering three bedrooms and two-and-a-half baths spread across 1,728 square feet.<br /> <br /> As you step inside, you're greeted by the first level's newly renovated kitchen, with brand new stainless steel appliances and a versatile flex space perfect for dining or a living area tailored to your lifestyle. The convenience of the half bath on this level adds to the ease of living. Moving upstairs, the second level offers a wide-open space, providing endless possibilities for how you'd like to set it up. Here, you will be enamored with all the natural light combined with the richness of the pristine hardwood floors.<br /> <br /> The top floor features three spacious bedrooms with generous closet space, accompanied by two bathrooms, offering plenty of room for relaxation. Outside, a tranquil fenced backyard oasis invites you to unwind and entertain. Additionally, this unit comes with assigned parking, ensuring convenience in the heart of the bustling city. Capitol Park, designed by the esteemed architect Chloethiel Woodard Smith, is steeped in history and community spirit. Situated just moments away from the Waterfront and close to the metro, the new owners will enjoy not only The Wharf's countless bars, restaurants, and music venues but also easy access to all of the DMV.
MlsNumber: --
ListingId: DCDC2146094


Listing Provided By: Real Broker, LLC, original listing
Phone: (202) 427-9689
Office Phone: (855) 450-0442
Agent Name: John Coleman
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