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;

45 Sutton Square Sw
Washington, DC 20024
George Lima with Compass, original listing - (202) 545-6900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,050,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1103 Square Feet
Agency: Compass
Agency Phone: (202) 545-6900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 2017
Notes: Premiere DC living awaits at the VIO with this exquisite 2BD/2BA corner unit with 1 garage parking space, Unit 303. Spanning 1103 square feet, this contemporary residence offers a sophisticated urban lifestyle. Host guests in the open concept living area featuring a chef’s kitchen with a large island, breakfast bar, Porcelanosa cabinets, quartz countertops, and stainless Thermador appliances. The owners’ suite boasts a private balcony with breathtaking river and Wharf views, a custom walk-in closet, and a luxurious marble-tiled bath with a frameless glass shower. A spacious second bedroom and full bath with a soaking tub, wide-planked wood flooring, and recessed lighting complete this exceptional offering. Conveniently located near the pool and gym, you'll have easy access to fitness and relaxation amenities, including a yoga studio. The VIO offers 24-hour concierge, porter service, security, a waterfront saltwater infinity pool, rooftop terrace, resident's lounge, gym, and additional amenities such as an espresso bar, dog washing station, car-detailing station, and bike storage. Ideally positioned near the L'Enfant Plaza Metro Station and the crossroads of I-395/I-695, this home provides effortless access to all of Washington. Additionally, relish in the vibrant entertainment, dining, and shopping options at the District Wharf, right at your doorstep. Don't miss this incredible opportunity to reside in one of DC's most sought-after locations.
MlsNumber: --
ListingId: DCDC2159426


Listing Provided By: Compass, original listing
Phone: (202) 491-1275
Office Phone: (202) 545-6900
Agent Name: George Lima
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