Enter City, Zip or MLS
Mountain Homes Realty
1-833-379-6393New Listing
6789 niwot road
Longmont, CO 80503
$3,495,000
3 BEDS 3 BATHS
3,048 SQFTResidential - Single Family
New Listing
Bedrooms 3
Total Baths 3
Full Baths 1
Square Feet 3048
Status Active
MLS # IR1062666
County Boulder
More Info
Category Residential - Single Family
Status Active
Square Feet 3048
MLS # IR1062666
County Boulder
Listed By: Listing Agent The Zach Zeldner Team
Compass - Boulder - (303) 501-4959
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.
Location not available
Listing
Street
Satellite
Exterior Features
- Construction Single Family Residence
- Siding Brick, Frame, Wood Siding
- Roof Composition
- Garage No
- Water Public, Well
- Sewer Septic Tank
- Lot Description Level
Interior Features
- Appliances Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
- Heating Forced Air, Wood Stove
- Cooling Ceiling Fan(s), Central Air
- Fireplaces Description Living Room
- Living Area 3,048 SQFT
- Year Built 1983
Neighborhood & Schools
- Subdivision Foothills East
- Elementary School Blue Mountain
- Middle School Altona
- High School Silver Creek
Financial Information
- Parcel ID R0051512
- Zoning RR
Additional Services
Internet Service Providers
Listing Information
Listing Provided Courtesy of Compass - Boulder - (303) 501-4959
 | Listings courtesy of the RE Colorado MLS as distributed by MLS GRID. IDX information is provided exclusively for consumers’ personal noncommercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interestedin purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability. Based on information submitted to the MLS GRID as of 07/06/2026 03:17:29 UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to: DMCAnotice@MLSGrid.com. The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner’s behalf. Failure to include all of the above information may result in the delay of the processing of your complaint. © 2026 RE Colorado MLS, Inc. |
Listing data is current as of 07/06/2026.
Contact Our Agent
Additional Markets
1-833-379-6393
All information is deemed reliable but not guaranteed accurate. Such Information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Some listings have been excluded from this website.
This page utilizes third-party mapping services and does not make any warranties or representations about the accuracy or completeness of these services' representations.
Copyright © 2024-2026 Mountain Homes Realty
Search States
Resources
- Sell A Mountain Home
- Find an Agent
- Mountain Market Report
- Mountain Homes Lifestyles
- Frequently Asked Questions
Additional Markets
1-833-379-6393
All information is deemed reliable but not guaranteed accurate. Such Information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Some listings have been excluded from this website.
This page utilizes third-party mapping services and does not make any warranties or representations about the accuracy or completeness of these services' representations.
Copyright © 2024-2026 Mountain Homes Realty