NOT LISTED FOR SALE

5655 Niwot Rd Longmont, CO 80503

Estimated Value: $6,150,568

106 Acres
$58,161 Price per Acre
4,606,470 Sq Ft Lot

Last Sold October 22, 2024

Last sale price $6,200,000

Est. 1% decrease in value since last sale

Current estimated payment $34,346/month

698 Days on Market

Highlights

  • Horses Allowed On Property
  • Panoramic View
  • No HOA
  • Blue Mountain Elementary School Rated A
  • 105.75 Acre Lot
  • Agricultural

About This Lot

As of October 2024

AUCTION BIDDING OPEN: Bidding ends September 24th. Previously Listed $8.9M. Current High Bid $6.2M. Showings Daily By Appt. Offered as a whole, this 105-acre parcel includes 31 shares of Left-Hand Ditch Water and Mineral Rights. The property also allows the new owner the option to create three 35-acre buildable parcels, all with no conservation easement(s). This property is a prime location to build a private residence with panoramic views of Longs Peak, the snowcapped back range, Boulder's Flatirons, and incredible long distance views overlooking Boulder County. Standing proudly in the shadow of the Rocky Mountains, welcome to this once in a lifetime opportunity to own an iconic feature of the Boulder County landscape, Haystack Mountain. Enjoy the peace and tranquility of country living along with convenient access to nearby amenities and easy commutes to downtown Boulder, Niwot, Longmont and Denver International Airport. To participate in the auction go to https://www.conciergeauctions.com/auctions/haystack-mountain-5655-niwot-road-longmont-colorado

Last Listed By

Jeff Erickson

LIV Sotheby's Intl Realty Listed on: 10/28/2022

Property Details

Property Type

  • Land

Est. Annual Taxes

  • $207

Lot Details

  • 105.75 Acre Lot
  • Wire Fence
  • Rock Outcropping
  • Level Lot
  • Property is zoned Ag

Property Views

  • Panoramic
  • Mountain

Location

  • Mineral Rights
  • Near Farm

Schools

  • Niwot Elementary School
  • Altona Middle School
  • Silver Creek High School

Utilities

  • Gas Available
  • Water Rights

Additional Features

  • Agricultural
  • Horses Allowed On Property

Listing and Financial Details

  • Assessor Parcel Number R0614556

Community Details

Overview

  • No Home Owners Association
  • Haystack Mountain Subdivision

Recreation

  • Access to stream, creek or river

Property Details

Property Type

Land

Est. Annual Taxes

$207

Lot Details

0

Listing Details

  • Development Status: Raw Land, Approved Subdivided
  • Property Sub Type: Unimproved Land
  • Prop. Type: Land
  • Horses: Yes
  • Lot Size Acres: 105.75
  • Road Surface Type: Gravel
  • Co List Office Mls Id: LLEG
  • Subdivision Name: Haystack Mountain
  • Directions: From Diagonal Highway go North on 63rd Street to Oxford Road. Go West on Oxford Road to the sign on the property on the left. 24 Hours Notice Required for all property tours.
  • Special Features: VirtualTour

Interior Features

  • Possible Use: Single Family, Farm

Exterior Features

  • Fencing: Wire
  • Lot Features: Water Rights Included, Mineral Rights Included, Level, Rolling Slope, Sloped, Steep Slope, Rock Outcropping, Abuts Ditch, Abuts Farm Land, Agricultural
  • View: Mountain(s), Foothills View, Plains View, Panoramic
  • Waterfront Features: Abuts Stream/Creek/River
  • Waterfront: No

Utilities

  • Utilities: Gas Tap Available
  • Gas Company: Gas Tap Available, Xcel

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Elementary School: Niwot
  • HighSchool: Silver Creek
  • Junior High Dist: ST Vrain Dist RE 1J
  • Middle Or Junior School: Altona

Lot Info

  • Zoning: Ag
  • Current Use: Horses
  • Lot Size Sq Ft: 4606470
  • Parcel #: R0614556
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 207

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 28, 2022
Closed on
Oct 21, 2024
Sold by
Haystack Living Trust
Bought by
County Of Boulder
Seller's Agent
Jeff Erickson
LIV Sotheby's Intl Realty
Buyer's Agent
Jeff Erickson
LIV Sotheby's Intl Realty
List Price
$12,900,000
Sold Price
$6,200,000
Premium/Discount to List
-$6,700,000
-51.94%
Total Days on Market
698
Views
455
Current Estimated Value
$6,150,568

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$49,432
Avg. Annual Appreciation
-1.11%

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
County Of Boulder $6,200,000 None Listed On Document
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/22/2024 10/22/24 Sold $6,200,000 0.0% --
09/25/2024 09/25/24 Pending -- -- --
09/21/2024 09/21/24 Price Changed $6,200,000 -30.3% --
07/27/2024 07/27/24 Price Changed $8,900,000 -6.3% --
08/05/2023 08/05/23 Price Changed $9,500,000 -9.5% --
05/02/2023 05/02/23 Price Changed $10,500,000 -18.6% --
10/28/2022 10/28/22 For Sale $12,900,000 -- --
Source: IRES MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $207 $2,059 $2,059 --
2023 $207 $2,059 $2,059 --
2022 $211 $2,006 $2,006 $0
2021 $33,601 $335,139 $335,139 $0
Source: Public Records

Agents Affiliated with this Home

  • Jeff Erickson

    Seller's Agent in 2024

    Jeff Erickson

    LIV Sotheby's Intl Realty

    (303) 589-2741

    95 Total Sales

    Jeff Erickson
    Section Image
  • Ryan McIntosh

    Seller Co-Listing Agent in 2024

    Ryan McIntosh

    LIV Sotheby's Intl Realty

    (720) 495-4563

    48 Total Sales

    Ryan McIntosh
    Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 978012

IRES MLS

APN: 1317270-00-023

Colorado Boulder County Longmont 80503

5655 Niwot Rd, Longmont, CO

Homes for Sale in Longmont, CO

This home is located at 5655 Niwot Rd, Longmont, CO 80503 since 28 October 2022 and is currently estimated at $6,150,568. 5655 Niwot Rd is a home located in Boulder County with nearby schools including Blue Mountain Elementary School, Altona Middle School, and Silver Creek High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

IRES MLS Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.

Listing information is provided exclusively 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.

Information deemed reliable but not guaranteed by the MLS.