Incredible agricultural estate located less than 15 minutes from the towns of Boulder, Erie, and Longmont. The 5,400 sf estate has breathtaking lake and mountain views from every window and is adjacent to Panama Reservoir. The lush 34 irrigates acres has valuable water rights and a tree lined driveway welcomes you through irrigated pastures as you approach the impressive home. The custom home has many unique features including expansive master bedroom with private porch, large brick fireplace, vaulted ceilings, granite counters, marble floors, custom wet bar and great outdoor living spaces with over 1,500 sf of screened in porches as you soaking in the stunning setting. The 40x60, heated & insulated metal shop has ample room for your toys, hobbies, farming equipment, etc. 30 share of Boulder White Rock Ditch (included in the sale). A 10-foot-deep picturesque pond adds to this scenic landscape. Conservation Easement on 29ac. Privacy, views and wildlife. Water & Mineral Rights Included.
Evergreen Trees, Deciduous Trees, Level, Abuts Pond/Lake, Abuts Stream/Creek/River, Abuts Farm Land, Outbuildings, Unincorporated, Water Rights Included, Mineral Rights Included
Lot FeaturesEvergreen Trees, Deciduous Trees, Level, Abuts Pond/Lake, Abuts Stream/Creek/River, Abuts Farm Land, Outbuildings, Unincorporated, Water Rights Included, Mineral Rights Included
Garage spaces2
Other StructuresStorage
ViewMountain(s), Water, Panoramic
CITYLongmont
SUBDIVISIONNA
COUNTYBoulder
AREASuburban Plains
STATECO
TAX AMOUNT10491.0
LATEST UPDATE2026-01-23T03:23:33.396Z
PRICE CHANGE(S)
$3,850,000 Oct 21, 2025
Market Trends
New Properties On Market
113
53%
Increase In New Listings
Average Asking Price
$749,201
$84,417 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$282
$52 Increase In List Price/Sq. Ft.
Average Days On Market
12
23 Day
Decrease In Days On Market
Data as of Apr 11, 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.