Recently Viewed Properties
See This Home
Save This Listing
Close

$1,525,000

  • Sold
  • Closed
  • Single Family
  • 2 Beds
  • 1 Full Bath
  • 1 Partial Bath
  • 1,268 Sq. Ft.
See This Home
Save This Home
See This Home
Save This Home
Ask about a credit to qualified buyers. Property is currently rented at $6500/mo ($4K Barn + $2.5K House). Leases can be modified/terminated with 3 mo notice. Exceptional opportunity to own a 30+ Acre Equestrian Property in Boulder County, minutes from Downtown Niwot & Longmont's Whole Foods Shopping Center & easy access to LOBO Trail. An equestrian & farmer's dream with a charming 2BR 2BA + Loft + Office house, Panoramic Front Range views, and beautifully-designed, functional facilities that cater to the needs of horse, rider and farmer. As you enter the property, you're greeted by lush pastures with ample space for grazing, riding, and growing hay. A new home, up to 3500 sq ft above grade may be added + a 500 sq ft detached garage. Water rights abound with significant Left Hand Ditch shares. A Heated 8-Stall Barn w/attached runs, 3 tack rooms, lounge, 1/2 Bath, Wash Stall w/hot & cold water & Brand New $30,000 (12 Employee) Septic System installed in Dec 2023. The professionally-designed 240-ft x 119-ft (0.65 acre) outdoor arena is adjacent to a 60-ft round pen. In addition to a 5-acre cross-country course, there is a 1-mile gallop track that loops around the property. An orchard is nestled in the heart of the property with 30 fruit trees, including cherry, apple, pear, and peach. Open fields totaling 18 acres (6 x 3-Acre rotational Grazing) are ideal for rotational grazing and hay production. Abundant storage, including a large 1836-sq ft hay/equipment barn with an attached 200-sq ft workshop with electricity and work bench. Agricultural zoning allows up to 4 animal units (horses or cows) per acre. This is truly a dream facility, thoughtfully equipped with everything a horse enthusiast could desire and in close proximity to all that Colorado offers. For the equestrian, the entertainer, or those in search of the quiet farm lifestyle, this property encompasses it all. Come and experience the peace and serenity of this magnificent sanctuary!

Full Property Details for 8590 N 87th St

General

  • Sold For: $1,525,000
  • Taxes: $11,113 (2023)
  • Status: Closed
  • Type: Single Family
  • Source: IRES
  • MLS ID: 1005545
  • Added to Site: 666 day(s) ago

Interior

  • Interior Features: Eat-In Kitchen, Open Floorplan, Pantry, Washer/Dryer Hookup
  • Appliances: Electric Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Fire Alarm

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Main Floor Baths: 1

Bedrooms

  • Total Bedrooms: 2

Exterior

  • Porch/Patio/Deck: Deck

Parking

  • Garage Description: None

Location

  • Area: Boulder
  • County: Boulder
  • Subdivision: FOOTHILLS EAST
  • Driving Directions: Take Diagonal Hwy to Airport Rd (N 87th St) , north on Airport Rd. The property is the second property on the right (East side of Airport Rd). Please park inside the gated area only. Please wear outdoor shoes for showings. Sandals will not provide adequate protection.

School Information

  • School District: ST Vrain Dist RE 1J
  • Elementary School: Eagle Crest
  • Middle School: Altona
  • High School: Silver Creek

Heating & Cooling

  • Cooling Type: Evaporative Cooling, Ceiling Fan(s)
  • Heating Type: Baseboard

Utilities

  • Gas: Propane
  • Sewer: Septic Tank
  • Water: District
  • Utility Description: Electricity Available, Propane, Cable Available, Satellite Available, High-Speed Internet Available

Structural Information

  • Architectural Style: Farmhouse, Legal Conforming
  • Construction: Composition
  • Exterior Const.: Composition
  • Basement Desc.: None
  • Roof: Composition
  • Windows: Window Coverings
  • Square Feet: 1,268
  • Sq. Ft. Source: Other
  • Living Area: 1,268 Sq. Ft.
  • Year Built: 1980

Lot Features

  • Property View: Hills, Plains View
  • Lot Size (Acres): 30.02
  • Lot Size (Sq. Ft.): 1,307,671
  • Frontage: County Maintained
  • Street/Road Desc.: Asphalt
  • Fence: Yes
  • Lot Features: Deciduous Trees, Native Grass, Level, Abuts Ditch, Abuts Farm Land, Paved, Water Rights Included
  • Potential Use: Single-Family, Farm
  • Permitted Use: Single Family, Farm
  • Zoning: A
  • Fencing (Description): Fenced, Wood, Wire, Dog Run/Kennel

Horse Property

  • Horse Property: Yes
  • Horse Facility Desc.: Horse(s) Allowed, Zoning Appropriate for 4+ Horses, Barn, Pasture, Tack Room, Hay Storage

Green Features

  • Energy Efficient: Southern Exposure, Windows

Financial Considerations

  • Tax Amount: $11,113
  • Tax Year: 2023
  • Terms: Cash, Conventional, 1031 Exchange

Disclosures and Reports

  • Special Conditions: Private Owner
  • Exclusions: Sellers' personal property and staging items.
  • Property ID: R0052200

Listed by Modern Prestige Real Estate (303) 667-8738
Sold by Modern Prestige Real Estate (303) 667-8738

Listing agents

— 8590 N 87th St —

  • Modern Prestige Real Estate

    303-667-8738

  • Modern Prestige Real Estate

    303-667-8738

3036678738

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 8590 N 87th St

School District:St. Vrain Valley School District Re 1j
NameGradesDistance
Hygiene Elementary School
11968 North 75th Street, Longmont, CO 80503
PK-51.6 mi
Westview Middle School
1651 Airport Road, Longmont, CO 80503
6-81.2 mi
Longmont High School
1040 Sunset Street, Longmont, CO 80501
9-122.4 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 8590 N 87th St

Date
Details
Price
Change
Source
11/18/2025
Sold
$1,525,000
-7.58%
MLS
3/22/2024
Listed
$1,650,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Listed by Modern Prestige Real Estate (303) 667-8738
Sold by Modern Prestige Real Estate (303) 667-8738

Similar Properties near 8590 N 87th St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1312 Steamboat Valley Rd, Lyons, CO 80540 - Photo 1
$1,550,000

1312 Steamboat Valley Rd  Lyons, CO 80540

  • Single Family
  • Active
  • 2
    Beds
  • 1
    Total Bath
  • 1,403
    Sq. Ft.
  • MLS # 1009709
Listed by LIV Sotheby's Intl Realty
13168 N 95th St, Longmont, CO 80504 - Photo 1
$1,595,000

13168 N 95th St  Longmont, CO 80504

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 1,842
    Sq. Ft.
  • MLS # 1042579
Listed by JPAR Modern Real Estate
8586 N 55th St, Longmont, CO 80503 - Photo 1
$1,477,000

8586 N 55th St  Longmont, CO 80503

  • Single Family
  • Active
  • Updated 14 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,680
    Sq. Ft.
  • MLS # 1036017
Listed by The Bernardi Group (303) 402-6000
12967 Woodridge Dr, Longmont, CO 80504 - Photo 1
$1,660,000

12967 Woodridge Dr  Longmont, CO 80504

  • Single Family
  • Active
  • 3
    Beds
  • 4
    Total Baths
  • 5,811
    Sq. Ft.
  • MLS # 4540597
Listed by Home Savings Realty

Just Listed near 8590 N 87th St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

23534 Waynes Way, Golden, CO 80401 - Photo 1 New to Website
$5,250,000

23534 Waynes Way  Golden, CO 80401

  • Single Family
  • Active
  • Updated 1 day ago
  • 5
    Beds
  • 5
    Total Baths
  • 7,493
    Sq. Ft.
  • MLS # 6211289
Listed by LIV Sotheby's International Realty
255 Divide View Dr, Golden, CO 80403 - Photo 1 New to Website
$700,000
Open House

255 Divide View Dr  Golden, CO 80403

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,912
    Sq. Ft.
  • MLS # 1049610
Listed by Compass - Boulder
211 Black Birch Rd, Golden, CO 80401 - Photo 1 New to Website
$650,000

211 Black Birch Rd  Golden, CO 80401

  • Single Family
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 2
    Total Baths
  • 3,855
    Sq. Ft.
  • MLS # 5387009
Listed by Realty One Group Premier Colorado
1008 Xenon St, Golden, CO 80401 - Photo 1 New to Website
$759,000
Open House

1008 Xenon St  Golden, CO 80401

  • Duplex
  • Active
  • Updated 1 day ago
  • 5
    Beds
  • 4
    Total Baths
  • 2,112
    Sq. Ft.
  • MLS # 3355208
Listed by Sterling Real Estate Group Inc

Price Reduced near 8590 N 87th St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

16359 W 10th Ave, Golden, CO 80401 - Photo 1 Price Reduced
-$2,000 (-0.89%)
$222,000

16359 W 10th Ave  #Yy2  Golden, CO 80401

  • Condo
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 1
    Total Bath
  • 773
    Sq. Ft.
  • MLS # 9454695
Listed by Dave Strang (303) 521-6180
23518 Pondview Pl, Golden, CO 80401 - Photo 1 Price Reduced
-$10,000 (-2.23%)
$439,000

23518 Pondview Pl  Golden, CO 80401

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,206
    Sq. Ft.
  • MLS # 3516576
Listed by Novella Real Estate
87 Circle Rd, Golden, CO 80403 - Photo 1 Price Reduced
-$10,000 (-2%)
$490,000

87 Circle Rd  Golden, CO 80403

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 1
    Total Bath
  • 1,564
    Sq. Ft.
  • MLS # 6702365
Listed by CLK Property Solutions
15834 W 11th Ave, Golden, CO 80401 - Photo 1 Price Reduced
-$9,600 (-1.48%)
$639,900

15834 W 11th Ave  Golden, CO 80401

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 2
    Total Baths
  • 1,260
    Sq. Ft.
  • MLS # 2444478
Listed by Elevate Real Estate

Recent Sales near 8590 N 87th St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

8971 Prairie Knoll Dr, Longmont, CO 80503 - Photo 1 Sold
$1,550,000

8971 Prairie Knoll Dr  Longmont, CO 80503

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 5,476
    Sq. Ft.
  • MLS # 1039905
Listed by Group Centerra
8858 Prairie Knoll Dr, Longmont, CO 80503 - Photo 1 Sold
$1,428,882

8858 Prairie Knoll Dr  Longmont, CO 80503

  • Single Family
  • Closed
  • 3
    Beds
  • 4
    Total Baths
  • 5,217
    Sq. Ft.
  • MLS # 1042383
Listed by Compass - Boulder
7451 Rozena Dr, Longmont, CO 80503 - Photo 1 Sold
$1,600,000

7451 Rozena Dr  Longmont, CO 80503

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 4,736
    Sq. Ft.
  • MLS # 1037975
Listed by Live West Realty
10587 N 95th St, Longmont, CO 80501 - Photo 1 Sold
$1,600,000

10587 N 95th St  Longmont, CO 80501

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,875
    Sq. Ft.
  • MLS # 1028323
Listed by Slifer Smith & Frampton-Bldr

8590 N 87th St, Longmont, CO 80503 (MLS# 1005545) is a Single Family property that was sold at $1,525,000 on November 18, 2025. Want to learn more about 8590 N 87th St? Do you have questions about finding other Single Family real estate for sale in Longmont? You can browse all Longmont real estate or contact a Coldwell Banker agent to request more information.