Metro Denver Luxury Homes For Sale

Property Description

One-of-a-kind property with Versatile Living Spaces & Income Potential and Horse Barn!

Versatile property with three private structures: a renovated 2,170 sq. ft. home, a 300 sq. ft. income-generating studio, and a 2,400 sq. ft. barn, including a 1,000 sq. ft. conversion with an office, bedroom with en suite bed/ and a spacious multipurpose room. Four horse barn stalls included.

Main House:

The beautifully remodeled main house boasts over 2000 square feet of living space, three spacious bedrooms, two modern bathrooms, and a massive 360-square-foot
mudroom/family/media room. The bright, open-concept layout includes a stunning remodeled kitchen outfitted with top-of-the-line Viking appliances, perfect for culinary enthusiasts.

Barn Conversion: Approximately 1,000 sq. ft. of the barn has been transformed into a fully insulated and conditioned living space, including a spacious bedroom with an en-suite bath and two additional 24×12 ft. living or working spaces. Could easily be a mother in law suite. The spaces are equipped with mini-split systems for efficient heating and cooling, and a tankless water heater—a new entrance with landscape lighting and a flagstone pathway enhance the welcoming appeal of the barn. The remaining horse stalls are ready for immediate use or further renovation.

Studio Apartment—Income Opportunity A former 30×12 ft. horse barn has been converted into a fully insulated and conditioned studio apartment, complete with a kitchenette, full bath, mini-split HVAC, and tankless water heater It is currently rented on Airbnb for $125 per night!

Backyard Oasis: Enjoy a beautifully re-landscaped backyard with a pergola, creating the perfect outdoor retreat.

This property blends charm, functionality, and rental potential—perfect for those seeking a unique home with additional income opportunities Schedule a showing today!

Features
: Forced Air, Natural Gas
: Central Air, Air Conditioning-Room
: Partial
: Mountain(s), Plains
: Gas, Gas Log, Dining Room
: Security System, Smart Locks, Smart Cameras, Security Entrance, Smart Security System
: Covered, Patio
: 4
: Negotiable
: Cooktop, Dryer, Dishwasher, Microwave, Range, Refrigerator, Range Hood, Washer, Oven, Tankless Water Heater, Double Oven, Water Softener, Water Purifier
: Contemporary
: Composition
: Septic Tank
Address Map
CO
Weld
Erie
80516
Aspen
5557
Avenue
W106° 58' 43.5''
N40° 4' 52.4''
Additional Information
4
: Frame, Brick, Wood Siding
East
: 220 Volts, 110V
Soaring Heights
: Private Yard, Fire Pit
1
: Carpet, Tile, Wood
Erie
Yes
: Pantry, Open Floorplan, Utility Sink, Smoke Free, Kitchen Island, Eat-in Kitchen, Smart Thermostat, High Speed Internet, Ceiling Fan(s), Entrance Foyer, Built-in Features, Sound System, Primary Suite, No Stairs, Breakfast Nook, Jack & Jill Bathroom, Butcher Counters, Walk-In Closet(s)
Yes
Yes
Cash, Conventional
: Level, Corner Lot, Sprinklers In Front, Landscaped, Open Space
Soaring Heights
Compass - Denver
R5680486
: None
: House
Carmacar Ranchettes
$4,396
2024
: Electricity Connected, Natural Gas Connected
: Double Pane Windows, Window Treatments
02/18/2025
2174
Active
St. Vrain Valley RE-1J
St. Vrain Valley RE-1J
In Unit
St. Vrain Valley RE-1J
02/18/2025
02/18/2025
Public
: One

Carmacar Ranchettes

5557 Aspen Avenue, Erie, CO 80516

3 Bedrooms
2 Total Baths
2,174 Square Feet
$1,250,000
Listing ID #9136245
Basic Details
Property Type : Residential
Listing Type : For Sale
Listing ID : 9136245
Price : $1,250,000
Bedrooms : 3
Rooms : 11
Total Baths : 2
Full Bathrooms : 1
3/4 Bathrooms : 1
Square Footage : 2,174 Square Feet
Year Built : 1975
Lot Area : 55,757 Acres
Lot Acres : 1.28
Property Sub Type : Single Family Residence
Status : Active
Originating System Name : REcolorado
Mortgage Calculator
$
$ %
years
%
$ %per year
$ %per year

$
Contact Agent