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;

1425 Rhode Island Avenue Nw
Washington, DC 20005
Mr. Michael A Hines with EXP Realty, LLC, original listing - (703) 935-1218

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,750,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3690 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (833) 335-7433

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 2004
Notes: Every now and then there comes a property that is a once in a lifetime opportunity...Penthouse 1 is it.  Never before offered for sale, this unicorn property spans almost 3,700 interior square feet, with an additional 2,000 square feet of private penthouse outdoor space in four separate balconies and roof decks.  Penthouse 1, the only custom built unit by local legend Jim Abdo in his landmark prewar building in the building is the largest condominium ever offered for sale in Logan Circle.  The home features four bedrooms, three bathrooms and spans the entire front and north side of the building.  <br /> <br /> The Willison is an exquisite boutique condominium featuring 23 units nestled in the highly sought-after Logan Circle neighborhood. Originally established in 1926, this historic building underwent a luxurious transformation in 2002 by the renowned Abdo Development, blending timeless charm with modern sophistication.<br />  <br /> The one of a kind open-concept floor plan features an entire primary bedroom wing on the opposite side of the unit, along with an additional secondary primary bedroom with private balcony. The rest of the space features custom poured concrete flooring, an elegant gas fireplace, a butler's entrance to the office/bedroom and second floor access with wet bar that takes you to a 1,500 square foot private terrace overlooking downtown with sweeping, unobstructed monument views.  This residence is adorned with premium finishes, including Viking, Miele, and Subzero appliances, custom lighting, limestone finishes,  updated cabinetry, and granite countertops.<br /> <br /> Convenience is key at The Willison, situated just steps away from downtown and some of DC’s most celebrated restaurants, Whole Foods, various shops, and other amenities. Additionally, easy access to the Metro ensures seamless connectivity to the vibrant pulse of the city.
MlsNumber: --
ListingId: DCDC2156074


Listing Provided By: EXP Realty, LLC, original listing
Phone: (202) 379-5868
Office Phone: (703) 935-1218
Agent Name: Mr. Michael A Hines
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