Metro Denver Luxury Homes For Sale

Property Description

One-of-a-kind property with Versatile Living Spaces & Income Potential and a Horse Barn! Just minutes from downtown Erie! Over 100K in updates creating a 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, Hot Water
: Central Air
: None
: Partial, Fenced
: Gas
: Smoke Detector(s)
: Deck
: 3
: Dryer, Dishwasher, Disposal, Microwave, Refrigerator, Self Cleaning Oven, Washer, Oven, Water Softener, Trash Compactor
: Composition
: Septic Tank
Address Map
CO
Weld
Erie
80516
Aspen
5557
Avenue
W106° 58' 50.9''
N40° 4' 51.7''
Additional Information
: Brick, Wood Frame
Soaring Heights
: Spa/Hot Tub
: Laminate, Wood
Erie
Yes
: Pantry, Open Floorplan, Kitchen Island, No Stairs, Walk-In Closet(s), In-Law Floor Plan
Yes
Yes
Cash, Conventional, FHA, VA Loan
: Corner Lot
Soaring Heights
Compass-Denver
R5680486
: House
Carmacar Ranchettes
$4,396
2024
: Cable Available, Natural Gas Available, Internet Access (Wired)
: Double Pane Windows, Skylight(s), Window Coverings, Bay Window(s)
RES
03/31/2025
2174
Active
St. Vrain Valley RE-1J
Raised
St. Vrain Valley RE-1J
In Unit
04/05/2025
Multi-Family,Residential
04/04/2025
Public
: One

Carmacar Ranchettes

5557 Aspen Avenue, Erie, CO 80516

3 Bedrooms
2 Total Baths
2,174 Square Feet
$1,179,000
Listing ID #IR1030225
Basic Details
Property Type : Residential
Listing Type : For Sale
Listing ID : IR1030225
Price : $1,179,000
Bedrooms : 3
Rooms : 11
Total Baths : 2
Full Bathrooms : 2
Square Footage : 2,174 Square Feet
Year Built : 1975
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