Public Remarks: Presenting the exquisite home at 5800 St Vrain Rd! This 5 acre, completely remodeled plantation-style estate in Longmont, CO is a masterpiece of modern updates and timeless elegance. Upon entry you will be greeted by a grand foyer with staircase leading upstairs to a primary suite with walls of windows as well as the sun/exercise room which sits just below the rooftop deck. You will find two additional tastefully appointed bedrooms and bathrooms as well as a seating area and stairs to a finished attic space that could act as another bedroom or office. Downstairs, the open floor plan flows seamlessly between kitchen and patio with top of the line appliances and sliding glass doors for indoor outdoor living. Passing the Butler's Pantry and across the large family/rec room, you'll find an expansive wing that offers additional bedrooms, bathrooms, a private kitchen, and deck space, along with the home's three-car garage. This versatile area can be used as part of the main residence or as a separate living space, making it ideal for multi-generational living, guest quarters, or potential rental opportunities. On the exterior, you will find the gazebo, the pool with lighting system, a fireplace, an oversized chess set, a pond, and an abundance of flower beds with ample gardening opportunities. All while basking in the majestic Colorado Front Ranges amazing sunsets! No part of the home or lot has been left untouched including large updates such as new electrical, HVAC, windows, doors, and plumbing. The location is impeccable as you are mere minutes from Boulder, Longmont, and Lyons as well as less than an hours drive from the Denver International Airport. Truly spectacular in every way, this home will take your breath away.
Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, 9ft+ Ceilings, Crown Molding, Sunroom, Sun Space
Room Information
Basement: None
Exterior
Exterior Features
Balcony
Fencing: Fenced, Vinyl
Patio and Porch Features: Patio, Deck
Roof: Composition
Pool Information
Private Pool: Yes
Pool Features: Private
Spa: Yes
Land Information
Road Surface Type: Gravel
Lot Information
Horse(s): Yes
Current Use: Horses
Lot Features: Water Rights Excluded, Wooded, Level
Zoning: A
Property Information
Property Type: Residential
Waterfront: No
Subdivision Information
Subdivision Name: Eagle Ridge Nupud
MLS Area Major: Suburban Plains
Building Information
Above Grade Finished Area: 6562
Below Grade Finished Area: 0
Building Area Total: 6562
Construction Materials: Wood/Frame
Financial
Tax Information
Parcel Number: R0110105
Tax Annual Amount: 15252
Tax Year: 2024
Financial Information
Listing Terms: Cash, Conventional, FHA, VA Loan
Utilities
Utility Information
Utilities: Natural Gas Available, Electricity Available
Electric: Electric,Poudre Valley
Gas: Natural Gas,Xcel
Sewer: Septic
Location
HOA Information
Association: No
School Information
High School District: ST Vrain Dist RE 1J
Elementary School: Blue Mountain
Middle or Junior School: Altona
High School: Silver Creek
Location Information
Directions: From Foothills highway, head EAST on St. Vrain. From 75th, head WEST on St Vrain. Property is approximately half way between Foothills HWY and 75th on the south side of St Vrain Rd.
Unparsed Address: 5800 Saint Vrain Rd Longmont CO 80503
Street Number: 5800
Street Name: Saint Vrain
Street Suffix: Rd
City: Longmont
State or Province: CO
County or Parish: Boulder
Country: US
Postal Code: 80503
Coordinates: -105.21942,40.17353
Latitude: 40.17353
Longitude: -105.21942
Public facts
Beds: 6
Baths: 4.5
Sq. Ft.: 5,072
Stories: —
Lot Size: 5.31 acres
Style: Single Family Residential
Year Built: 1991
Year Renovated: 2014
County: Boulder County
APN: R0110105
Home facts updated by county records on Dec 3, 2025
Other
Miscellaneous Information
Exclusions: Sellers Personal Property. Seller's will consider other inclusions with full price offer.
Listing Information
Attribution Contact: 8313202416
Close Price: $4,300,000
Photos Count: 40
Possible Use: Single Family
Special Listing Conditions: Private Owner
Standard Status: Closed
Listing Date Information
Close Date: Friday, August 1, 2025
Cumulative Days on Market: 312
Days on Market: 55
Listing Contract Date: Wednesday, April 23, 2025
Modification Timestamp: Monday, August 4, 2025 7:09 PM
Home Information
Levels: Three Or More
Window Features: Sunroom
Year Built: 1991
Green Information
Green Energy Efficient: Southern Exposure
Around this home
Schools
Blue Mountain Elementary School
Public PreK-5 • Assigned • 3.1mi
10/10
Altona Middle School
Public 6-8 • Assigned • 3.6mi
10/10
Silver Creek High School
Public 9-12 • Assigned • 3.1mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Historical weather
Longmont, CO • 80503
Average low and high temperatures (°F)
43
18
52
26
64
37
64
39
71
46
83
56
90
62
86
59
78
52
69
43
55
31
53
30
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 10.4 hours in
June and 6 hours in December, placing it above the
U.S. average for solar exposure.
10.4 hrs
6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$3.89M – $4.71M
Reach more buyers when you sell with Redfin. Save up to $40,936 in fees.3 minutes to get started.