Private lake and irrigated pastures, mountain views and gorgeous home - all on 100 acres 30 minutes to Downtown Boulder. Privacy and luxury in this retreat like setting. Natural rock formations and natural waterfalls create a piece of paradise in the heart of Boulder County.
Wooded, Evergreen Trees, Deciduous Trees, Native Grass, Level, Rolling Lot, Rock Outcropping, Abuts Pond/Lake, Abuts Stream/Creek/River, Abuts Farm Land, Abuts Private Open Space, Meadow, Outbuildings, Unincorporated, Water Rights Included, Mineral Rights Included
Garage spaces
3
Other Structures
Storage
View
Mountain(s), Hills, Plains View, Water
CITY
Longmont
SUBDIVISION
Bagnell NUPUD
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
TAX AMOUNT
5453.0
LATEST UPDATE
2026-01-22T22:55:31.087Z
PRICE CHANGE(S)
$2,997,500 Oct 21, 2025
Property Details
Property TypeResidential
StatusClosed
Bedrooms4
Bathrooms (Full)3
Property Sub TypeFarm
Square Feet6,000
MLS #798369
Bathrooms (Half)1
FlooringWood
AppliancesElectric Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Gas Bar-B-Q, Disposal, Fire Alarm
Parking FeaturesGarage Door Opener, RV Access/Parking
FencePartial
Lot FeaturesWooded, Evergreen Trees, Deciduous Trees, Native Grass, Level, Rolling Lot, Rock Outcropping, Abuts Pond/Lake, Abuts Stream/Creek/River, Abuts Farm Land, Abuts Private Open Space, Meadow, Outbuildings, Unincorporated, Water Rights Included, Mineral Rights Included
Garage spaces3
Other StructuresStorage
ViewMountain(s), Hills, Plains View, Water
CITYLongmont
SUBDIVISIONBagnell NUPUD
COUNTYBoulder
AREASuburban Plains
STATECO
TAX AMOUNT5453.0
LATEST UPDATE2026-01-22T22:55:31.087Z
PRICE CHANGE(S)
$2,997,500 Oct 21, 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
13
35 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.