Search Description Details Neighborhood
Main
Photo 1
Photo 2
Photo 3
Photo 4
Photo 5
Photo 6
Active Residential

6789 Niwot Road

Longmont, CO 80503

RECOLORADO #IR1062666 Updated: Jun 25, 2026, 4:15pm
$3,495,000
3 Beds • 3 Baths • 3,048 SqFt
Property
ActiveResidential
1/28
$3,495,000

6789 Niwot Road

Longmont, CO 80503
3
Beds
3
Baths
3,048
SqFt
28.61
Acres
RECOLORADO
#IR1062666
Updated: Jun 25, 2026, 4:15pm

Property Description

Seeking your dream ranch property with close-to-town access, extensive water rights and room for animals? Look no further than this expansive 28.6-acre Boulder County, Colorado, property just 15 minutes from Downtown Boulder. Surrounded by huge foothills views, this special ranch destination invites you to move right in and enjoy the existing brick single-level home, featuring an open layout, spacious living and dining room, nicely appointed kitchen, three oversized bedrooms and an attached garage. Or, plan your ideal farmhouse showplace in this beautifully located, completely flat lot. Currently used for farming and hay, including two cuts of hay per season, this property enjoys significant water rights with an available 30 shares of Left Hand Ditch Company. Multiple outbuildings add convenience for farming and ranching, including a shop, machinery storage, hay storage, a barn, a detached one-bedroom caretaker's unit and more. This idyllic Longmont location is surrounded by vast open space, reservoirs, trails and top-rated St. Vrain Valley School District schools. Enjoy excellent access into and out of town with Longmont amenities 10 minutes away and Pearl Street/Downtown Boulder just 15 minutes from your door.
Watch Video Tour
CLICK TO LOAD 3D TOUR
YouTube
Included Appliances
DishwasherDisposalDryerMicrowaveOvenRefrigeratorWasher

Property Details

Interior
Above Grade Finished Area
3048
Appliances
DishwasherDisposalDryerMicrowaveOvenRefrigeratorWasher
Basement
None
Building Area Total
3048
Cooling
Ceiling Fan(s)Central Air
Fireplace Features
Living Room
H V A C Description
Central Air,Ceiling Fan
Heating
Forced AirWood Stove
Interior Features
Eat-in KitchenKitchen IslandOpen FloorplanPantryWalk-In Closet(s)Wet Bar
Living Area
3048
Room Count
8
Window Features
Window Coverings
Construction
Also Marketed As
Farm
Building Area Source
Other
Construction Materials
BrickFrameWood Siding
Levels
One
Roof
Composition
Structure Type
House
Year Built
1983
Site & Exterior
Garage Spaces
7
Horse
Yes
Horse Amenities
Corral(s)Loafing ShedPastureTack Room
Issued Well Permit Numbers
180474
Lot Features
Level
Lot Size Acres
28.61
Lot Size Square Feet
1246395
Parking Total
7
Sewer
Septic Tank
Utilities
Electricity AvailableNatural Gas Available
Vegetation
GrassedWooded
View
Mountain(s)Plains
Water Mineral Rights
Water Rights
Water Source
PublicWell
Zoning
RR
Financials
Contract Earnest Check To
Fidelity National Title - Rebecca Ringman
Contract Min Earnest
150000.00
Exclusions
Owner's personal propertymachinerytoolsfarm equipmentair compressorhydraulic liftrefrigerators and freezers that are not currently being used in the residences.Water Rights Included
Ownership
Individual
Parcel Number
R0051512
Tax Annual Amount
8902
Tax Legal Description
WLY 990 FT OF SW 1/4 SE 1/4 26-2N-70 30 ACS M/L PER DEED 884997 10/26/87 BCR SEE ID 51987
Tax Year
2025

Neighborhood & Lifestyle

Community & Association
Subdivision Name
Foothills East
Schools
Ratings
Elementary
Blue Mountain
Middle
Altona
High
Silver Creek
Elem. District
St. Vrain Valley RE-1J
High District
St. Vrain Valley RE-1J
Listing provided courtesy of RECOLORADO via IDX. Updated: Jun 25, 2026, 4:15pm.
The Zach Zeldner Team

Listing Agent

Compass - Boulder

Call Agent
Call