Incomparable property w the Saint Vrain river running through it, spring fed pond, huge trees grace the property. Stunning home, impeccable quality and design w huge rooms + massive ceilings. Year round outdoor pool, waterfall, tennis court, fire pit + a 2 bed "party guest house" + Georgian historical home all perfectly maintained and manicured. Yes, and water rights!
Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Gas Bar-B-Q, Water Softener Owned
FIREPLACE FEATURES
Two or More, Bedroom
Heating
Forced Air, Radiant
Cooling
Ceiling Fan(s)
Utility Features
Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
SEWER
Septic Tank
WATER SOURCE
City
Year Built
2003
Basement
None
FINISHED BASEMENT SIZE
0.0
ARCHITECTURAL STYLE
Farmhouse, Contemporary
Roof
Tile
EXTERIOR FEATURES
Sprinkler System, Hot Tub, Tennis Court(s), >8' Garage Door, Heated Garage, Oversized Garage, Carriage House
Parking Features
Garage Door Opener, RV Access/Parking
Fence
Partial, Fenced, Other
Lot Features
Deciduous Trees, Abuts Ditch, Abuts Pond/Lake, Abuts Stream/Creek/River, Abuts Farm Land, Outbuildings, House/Lot Faces SE, Water Rights Included, Irrigation Well Included
Garage spaces
7
Other Structures
Storage
CITY
Longmont
SUBDIVISION
Foothills East
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
TAX AMOUNT
34093.0
LATEST UPDATE
2026-01-23T08:23:31.439Z
PRICE CHANGE(S)
$6,450,000 Oct 21, 2025
Property Details
Property TypeResidential
StatusClosed
Bedrooms5
Bathrooms (Full)3
Property Sub TypeSingle Family Residence
Square Feet13,000
MLS #822668
Bathrooms (¾)2
Bathrooms (Half)1
FlooringWood
AppliancesDishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Gas Bar-B-Q, Water Softener Owned
FIREPLACE FEATURESTwo or More, Bedroom
HeatingForced Air, Radiant
CoolingCeiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
SEWERSeptic Tank
WATER SOURCECity
Year Built2003
BasementNone
FINISHED BASEMENT SIZE0.0
ARCHITECTURAL STYLEFarmhouse, Contemporary
RoofTile
EXTERIOR FEATURESSprinkler System, Hot Tub, Tennis Court(s), >8' Garage Door, Heated Garage, Oversized Garage, Carriage House
Parking FeaturesGarage Door Opener, RV Access/Parking
FencePartial, Fenced, Other
Lot FeaturesDeciduous Trees, Abuts Ditch, Abuts Pond/Lake, Abuts Stream/Creek/River, Abuts Farm Land, Outbuildings, House/Lot Faces SE, Water Rights Included, Irrigation Well Included
Garage spaces7
Other StructuresStorage
CITYLongmont
SUBDIVISIONFoothills East
COUNTYBoulder
AREASuburban Plains
STATECO
TAX AMOUNT34093.0
LATEST UPDATE2026-01-23T08:23:31.439Z
PRICE CHANGE(S)
$6,450,000 Oct 21, 2025
Market Trends
New Properties On Market
82
64%
Increase In New Listings
Average Asking Price
$1,200,058
$168,949 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$360
$28 Decrease In List Price/Sq. Ft.
Average Days On Market
9
20 Day
Decrease In Days On Market
Data as of Apr 06, 2026.
Remaining statistics above are calculated on activity within the period from Feb 01, 2026 to Mar 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.