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.
Gas Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURES
Two or More, Gas, Living Room, Family Room, Bedroom
Heating
Forced Air
Cooling
Central Air
Utility Features
Natural Gas Available, Electricity Available
SEWER
Septic Tank
WATER SOURCE
District
Year Built
1991
Basement
None
FINISHED BASEMENT SIZE
0.0
ARCHITECTURAL STYLE
Farm House
Roof
Composition
EXTERIOR FEATURES
Balcony, Oversized Garage
Parking Features
RV Access/Parking
Fence
Fenced, Vinyl
Lot Features
Wooded, Deciduous Trees, Native Grass, Level, Water Rights Excluded
Garage spaces
3
CITY
Longmont
SUBDIVISION
Eagle Ridge Nupud
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
TAX AMOUNT
15252.0
LATEST UPDATE
2026-01-23T14:38:04.515Z
PRICE CHANGE(S)
$4,750,000 Oct 29, 2025
Property Details
Property TypeResidential
StatusClosed
Bedrooms6
Bathrooms (Full)1
Property Sub TypeSingle Family Residence
Square Feet6,562
MLS #1031895
Bathrooms (¾)3
Bathrooms (Half)2
FlooringWood
AppliancesGas Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURESTwo or More, Gas, Living Room, Family Room, Bedroom
HeatingForced Air
CoolingCentral Air
Utility FeaturesNatural Gas Available, Electricity Available
SEWERSeptic Tank
WATER SOURCEDistrict
Year Built1991
BasementNone
FINISHED BASEMENT SIZE0.0
ARCHITECTURAL STYLEFarm House
RoofComposition
EXTERIOR FEATURESBalcony, Oversized Garage
Parking FeaturesRV Access/Parking
FenceFenced, Vinyl
Lot FeaturesWooded, Deciduous Trees, Native Grass, Level, Water Rights Excluded
Garage spaces3
CITYLongmont
SUBDIVISIONEagle Ridge Nupud
COUNTYBoulder
AREASuburban Plains
STATECO
TAX AMOUNT15252.0
LATEST UPDATE2026-01-23T14:38:04.515Z
PRICE CHANGE(S)
$4,750,000 Oct 29, 2025
Market Trends
New Properties On Market
49
277%
Increase In New Listings
Average Asking Price
$912,945
$818,670 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$352
$179 Decrease In List Price/Sq. Ft.
Average Days On Market
14
33 Day
Decrease In Days On Market
Data as of Feb 06, 2026.
Remaining statistics above are calculated on activity within the period from Dec 01, 2025 to Jan 31, 2026.
Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.