Stunning 35-acre property ideally located between Longmont and Berthoud with rare lake frontage and 360* back range views. This 2-bedroom, 3-bath home offers 2,517 finished sq. ft. plus a 1,080 sq. ft. basement with a full mother-in-law suite and kitchen. The main level features a gourmet kitchen with granite countertops, custom cabinets, and double ovens. Enjoy multiple outdoor living spaces, including two upper porches, two main-level patios and a walk-out basement patio. The primary suite offers heated floors and expansive views. Valuable water rights included. A rare opportunity for privacy, acreage, and unbeatable Colorado scenery.
Accepting backups
$1,592,500
8580 N County Line Rd, Longmont, CO 80503
2beds
4,133sqft
Est.:
Residential-Detached, Residential
Built in 2001
35.23 Acres Lot
$-- Zestimate®
$385/sqft
$-- HOA
What's special
Expansive viewsWalk-out basement patioTwo main-level patiosRare lake frontageTwo upper porchesCustom cabinetsDouble ovens
- 42 days |
- 281 |
- 7 |
Zillow last checked: 8 hours ago
Listing updated: December 03, 2025 at 03:50pm
Listed by:
Arnold Turner 303-776-1105,
Turner Realty,
Patricia Turner 303-362-3821,
Turner Realty
Source: IRES,MLS#: 1047574
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
- 1/2 bathrooms: 1
- Main level bedrooms: 1
Primary bedroom
- Area: 400
- Dimensions: 20 x 20
Bedroom 2
- Area: 143
- Dimensions: 11 x 13
Dining room
- Area: 117
- Dimensions: 9 x 13
Family room
- Area: 594
- Dimensions: 27 x 22
Kitchen
- Area: 368
- Dimensions: 16 x 23
Living room
- Area: 594
- Dimensions: 27 x 22
Heating
- Forced Air, Radiant
Cooling
- Central Air, Ceiling Fan(s)
Appliances
- Included: Electric Range/Oven, Gas Range/Oven, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
- Laundry: Sink, Washer/Dryer Hookups, Main Level
Features
- Study Area, In-Law Floorplan, Satellite Avail, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, High Ceilings, Open Floor Plan, Walk-in Closet, Media Room, 9ft+ Ceilings
- Flooring: Wood, Wood Floors, Tile, Carpet
- Doors: Storm Door(s)
- Windows: Skylight(s), Double Pane Windows, Storm Window(s), Skylights
- Basement: Full,Partially Finished,Walk-Out Access,Built-In Radon,Sump Pump
- Has fireplace: Yes
- Fireplace features: 2+ Fireplaces, Gas Log, Living Room, Family/Recreation Room Fireplace, Master Bedroom, Great Room, Dining Room, Basement
Interior area
- Total structure area: 3,597
- Total interior livable area: 4,133 sqft
- Finished area above ground: 2,517
- Finished area below ground: 1,080
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener
- Attached garage spaces: 2
- Details: Garage Type: Attached
Accessibility
- Accessibility features: Accessible Approach with Ramp, Accessible Hallway(s), Low Carpet, Accessible Doors, Accessible Entrance, Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level Laundry
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Deck
- Exterior features: Balcony
- Has spa: Yes
- Spa features: Bath
- Fencing: Partial,Fenced,Wood,Chain Link,Vinyl
- Has view: Yes
- View description: Mountain(s), Hills, Plains View, Water, Panoramic
- Has water view: Yes
- Water view: Water
- Waterfront features: Abuts Pond/Lake, Pond
Lot
- Size: 35.23 Acres
- Features: Water Rights Included, Rolling Slope, Abuts Ditch, Unincorporated
Details
- Additional structures: Storage
- Parcel number: R0127968
- Zoning: A
- Special conditions: Other Owner
- Other equipment: Home Theater
- Horses can be raised: Yes
- Horse amenities: Pasture
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary/Modern
- Property subtype: Residential-Detached, Residential
Materials
- Wood/Frame, Stucco
- Roof: Rubber
Condition
- Not New, Previously Owned
- New construction: No
- Year built: 2001
Utilities & green energy
- Electric: Electric, Xcel Energy
- Gas: Natural Gas, Propane
- Sewer: Septic, Septic Field
- Water: District Water, Little Thompson
- Utilities for property: Natural Gas Available, Electricity Available, Propane, Trash: Western Disposal
Green energy
- Energy efficient items: Southern Exposure
Community & HOA
Community
- Security: Fire Sprinkler System
- Subdivision: Northern Plains
HOA
- Has HOA: No
Location
- Region: Longmont
Financial & listing details
- Price per square foot: $385/sqft
- Tax assessed value: $1,099,700
- Annual tax amount: $7,140
- Date on market: 11/19/2025
- Cumulative days on market: 44 days
- Listing terms: Cash,Conventional,FHA,VA Loan
- Exclusions: All Owner's Personal Property
- Has irrigation water rights: Yes
- Electric utility on property: Yes
- Road surface type: Gravel
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 12/3/2025 | Pending sale | $1,592,500$385/sqft |
Source:  REcolorado #IR1047574 Report a problem | ||
| 11/19/2025 | Listed for sale | $1,592,500$385/sqft |
Source:  IRES #1047574 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $7,140 +4.3% | $70,036 -20.8% |
| 2024 | $6,842 +32.4% | $88,460 -0.9% |
| 2023 | $5,167 -2.5% | $89,295 +48.8% |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$7,435/mo
Principal & interest
$6175
Property taxes
$703
Home insurance
$557
Climate risks
Neighborhood: 80503
Nearby schools
GreatSchools rating
- 7/10Berthoud Elementary SchoolGrades: PK-5Distance: 5.4 mi
- 5/10Turner Middle SchoolGrades: 6-8Distance: 5 mi
- 7/10Berthoud High SchoolGrades: 9-12Distance: 4.5 mi
Schools provided by the listing agent
- Elementary: Berthoud
- Middle: Turner
- High: Berthoud
Source: IRES. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
