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 = 261 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 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 = 261 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 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 = 261 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 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;

1804 Little Raven Street
Denver, CO 80202
Stuart Crowell with Compass - Denver, original listing - (303) 536-1786

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,720,000
Beds: 3
Baths: Full: 1, ½: 1, ¾: 2
Status: Active
SqFt: 3999 Square Feet
Agency: Compass - Denver
Agency Phone: (303) 536-1786

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Townhouse
Year Built: 2004
Notes: Welcome to 1804 Little Raven Street, an exquisite brownstone residence nestled in the heart of Denver. This luxurious 3-bedroom, 4-bathroom home spans an impressive 3,999 square feet, offering an unparalleled blend of elegance and contemporary living. Upon entering, you are greeted by an open floor plan that seamlessly integrates the living, dining, and kitchen areas, perfect for both intimate gatherings and grand entertaining. The chef's kitchen is a culinary masterpiece, featuring an island, high-end Viking appliances, and an Allavino wine storage refrigerator. The ebony gas fireplace in the living room provides a cozy ambiance, complemented by floor to ceiling windows that add to the grandeur of the space. The primary suite is a sanctuary of luxury, boasting a 5-piece bath and an expansive fitted walk-in closet. Each bedroom offers private balconies, ensuring personal retreats with stunning views. The lower level includes a versatile den or additional living space, ideal for a home office or media room. Step outside to discover multiple outdoor living spaces, including a private patio on the main level with RH outdoor furniture included, and a rooftop deck with breathtaking city and mountain views. Enjoy the convenience of automatic blinds and Lutron lighting throughout the home, enhancing the modern living experience. This residence is designed for comfort and convenience, featuring an extremely rare 3-car attached underground garage with epoxy flooring and a double-gated entrance for next-level security and privacy. The home is professionally managed by East West Management, providing year-round snow removal, landscaping, package delivery, fitness center, garden, trash, recycling, water, and sewer. Located in close proximity to Commons Park, Union Station, Coors Field, and a variety of dining and entertainment options such as Tavernetta, ChoLon, BriDer, and Blue Sparrow Coffee. Experience the epitome of urban luxury living in this extraordinary residence.
MlsNumber: --
ListingId: 2087053


Listing Provided By: Compass - Denver, original listing
Phone: (303) 909-2331
Office Phone: (303) 536-1786
Agent Name: Stuart Crowell
Disclaimer: Copyright © 2025 ROCC/REcolorado. 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 = 261 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 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 Steven Sumey, #100079779
Steven Sumey, #100079779
ASCIIModern Vibe Group - Real Broker
Call Today!: (303) 704-2190

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App