$4,300,000
SOLD AUG 1, 2025

5800 Saint Vrain Rd Longmont, CO 80503

6 Beds
6 Baths
6,562 Sq Ft
5.31 Acres

Recently Sold

$655 Per Sq Ft

9% Below List Price

49 Days on Market

Highlights

  • Parking available for a boat
  • Horses Allowed On Property
  • Open Floorplan
  • Blue Mountain Elementary School Rated A
  • Private Pool
  • Fireplace in Primary Bedroom

About This Home

As of August 2025

Presenting the exquisite home at 5800 St Vrain Rd! This 5 acre, completely remodeled plantation-style estate in Longmont, CO is a masterpiece of modern updates and timeless elegance. Upon entry you will be greeted by a grand foyer with staircase leading upstairs to a primary suite with walls of windows as well as the sun/exercise room which sits just below the rooftop deck. You will find two additional tastefully appointed bedrooms and bathrooms as well as a seating area and stairs to a finished attic space that could act as another bedroom or office. Downstairs, the open floor plan flows seamlessly between kitchen and patio with top of the line appliances and sliding glass doors for indoor outdoor living. Passing the Butler's Pantry and across the large family/rec room, you'll find an expansive wing that offers additional bedrooms, bathrooms, a private kitchen, and deck space, along with the home's three-car garage. This versatile area can be used as part of the main residence or as a separate living space, making it ideal for multi-generational living, guest quarters, or potential rental opportunities. On the exterior, you will find the gazebo, the pool with lighting system, a fireplace, an oversized chess set, a pond, and an abundance of flower beds with ample gardening opportunities. All while basking in the majestic Colorado Front Ranges amazing sunsets! No part of the home or lot has been left untouched including large updates such as new electrical, HVAC, windows, doors, and plumbing. The location is impeccable as you are mere minutes from Boulder, Longmont, and Lyons as well as less than an hours drive from the Denver International Airport. Truly spectacular in every way, this home will take your breath away.

Last Agent to Sell the Property

Christopher Choate

8z Real Estate Listed on: 04/23/2025

8z Real Estate

Last Buyer's Agent

Jon Hatch

Compass - Boulder

Compass - Boulder

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,252

Year Built

  • Built in 1991

Lot Details

  • 5.31 Acre Lot
  • Southern Exposure
  • Vinyl Fence
  • Level Lot
  • Wooded Lot
  • Landscaped with Trees

Parking

  • 3 Car Attached Garage
  • Parking available for a boat

Home Design

  • Farmhouse Style Home
  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 6,562 Sq Ft Home
  • 3-Story Property
  • Open Floorplan
  • Crown Molding
  • Cathedral Ceiling
  • Multiple Fireplaces
  • Gas Fireplace
  • Living Room with Fireplace
  • Dining Room
  • Recreation Room with Fireplace
  • Sun or Florida Room
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom

Laundry

  • Dryer
  • Washer

Pool

  • Private Pool
  • Spa

Outdoor Features

  • Balcony
  • Deck
  • Patio

Schools

  • Blue Mountain Elementary School
  • Altona Middle School
  • Silver Creek High School

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Grass Field

Utilities

  • Forced Air Heating and Cooling System
  • Water Rights Not Included
  • Septic System

Community Details

  • No Home Owners Association
  • Eagle Ridge Nupud Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0110105

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,252

Year Built

Built in 1991

Lot Details

0

Parking

3

Listing Details

  • Inclusions: Gas Range/Oven,Dishwasher,Refrigerator,Clothes Washer,Clothes Dryer,Microwave,Disposal,Smoke Alarm(s)
  • Year Built: 1991
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: Yes
  • Lot Size Acres: 5.31
  • Road Surface Type: Gravel
  • Subdivision Name: Eagle Ridge Nupud
  • Directions: From Foothills highway, head EAST on St. Vrain. From 75th, head WEST on St Vrain. Property is approximately half way between Foothills HWY and 75th on the south side of St Vrain Rd.
  • Above Grade Finished Sq Ft: 6562
  • Architectural Style: Farm House
  • Garage Yn: Yes
  • Unit Levels: Three Or More
  • New Construction: No
  • Efficiency: Southern Exposure
  • Building Stories: 3
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 6562
  • Special Features: None
  • Stories: 3

Interior Features

  • Possible Use: Single Family
  • Private Spa: Yes
  • Appliances: Gas Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
  • Has Basement: None
  • Full Bathrooms: 1
  • Half Bathrooms: 2
  • Three Quarter Bathrooms: 3
  • Total Bedrooms: 6
  • Fireplace Features: 2+ Fireplaces, Gas, Living Room, Family/Recreation Room Fireplace, Primary Bedroom
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, 9ft+ Ceilings, Crown Molding, Sunroom, Sun Space
  • Living Area: 6562
  • Main Level Bathrooms: 2
  • Window Features: Sunroom
  • IRESDS_HasFamilyRoom: No
  • Master Bedroom Master Bedroom Level: Upper
  • Master Bedroom Master Bedroom Width: 12
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Room Kitchen Area: 260
  • Room Master Bedroom Area: 144
  • Master Bathroom Features: Full Primary Bath

Exterior Features

  • Roof: Composition
  • Fencing: Fenced, Vinyl
  • Lot Features: Water Rights Excluded, Wooded, Level
  • Pool Features: Private
  • Pool Private: Yes
  • View: No
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Home Warranty: No
  • Construction Type: Wood/Frame
  • Exterior Features: Balcony
  • Patio And Porch Features: Patio, Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: RV/Boat Parking, Oversized
  • IRESDS_Garage Sq Ft: 864
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric, Poudre Valley
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: Septic
  • Water Source: District Water, Lefthand District
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: No

Schools

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

Lot Info

  • Zoning: A
  • Current Use: Horses
  • Lot Size Sq Ft: 231093
  • Parcel #: R0110105
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 15252

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 23, 2025
Closed on
Aug 1, 2025
Sold by
Taylor Glen E and Hofmann Casandra S
Bought by
James And Kristi Raney Revocable Trust
Seller's Agent
Christopher Choate
8z Real Estate
Buyer's Agent
Jon Hatch
Compass - Boulder
List Price
$4,750,000
Sold Price
$4,300,000
Premium/Discount to List
-$450,000
-9.47%
Views
44

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
93.42%

Purchase Details

Listed on
Apr 23, 2025
Closed on
Jul 23, 2025
Sold by
Hennigh Quinton Todd and Hennigh Heather Noel
Bought by
Taylor Glen E and Hofmann Casandra S
Seller's Agent
Christopher Choate
8z Real Estate
Buyer's Agent
Jon Hatch
Compass - Boulder
List Price
$4,750,000
Sold Price
$4,300,000
Premium/Discount to List
-$450,000
-9.47%
Views
44

Purchase Details

Listed on
Aug 14, 2015
Closed on
Jun 2, 2016
Sold by
Fruehauf Todd F and Estate Of Mary Lee Fruehauf
Bought by
Taylor Glen E
Seller's Agent
Patrick Dolan
RE/MAX of Boulder, Inc
Buyer's Agent
Evan Lam
Colorado Key Properties
List Price
$1,397,700
Sold Price
$1,150,000
Premium/Discount to List
-$247,700
-17.72%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
15.47%
Original Mortgage
$115,000
Interest Rate
3.61%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Oct 10, 2011
Sold by
Daum David
Bought by
Freuhauf Mary

Purchase Details

Closed on
Mar 23, 2004
Sold by
Daum David
Bought by
Daum David

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$37,500
Interest Rate
5.68%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Feb 5, 2004
Sold by
Daum David and Fruehauf Mary
Bought by
Daum David

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$37,500
Interest Rate
5.68%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Apr 11, 1991
Bought by
Taylor Glen E and Hofmann Casandra S

Purchase Details

Closed on
Dec 18, 1990
Bought by
Taylor Glen E and Hofmann Casandra S
Source: Public Records

Similar Homes in Longmont, CO

  • 5101 Saint Vrain Rd, Longmont, CO 80503

    $3,750,000

    • 5 Beds
    • 5.5 Baths
    • 6,242 Sq Ft
    • 5101 Saint Vrain Rd
    • Longmont, CO

    Welcome to a truly one-of-a-kind property, inside and out. Upon entrance through the gate, a tree-lined drive sets the tone—its canopy lush and vibrant in both summer and fall. The circular driveway makes the arrival all the more elegant. As you approach, you’ll also notice the fantastic mountain vistas and serenity this property offers. Sitting on just over five acres, this custom-built home,

    Dina Piterniece Compass - Denver

    Section Image
  • 10077 N 75th St, Longmont, CO 80503

    $3,950,000

    • 4 Beds
    • 3.5 Baths
    • 5,417 Sq Ft
    • 10077 N 75th St
    • Longmont, CO

    RUSTIC ELEGANCE MEETS PANORAMIC MOUNTAIN VIEWS - EXQUISITE EQUESTRIAN ESTATE ON 6.05 ACRES. More than a home - it's a lifestyle. This 4 bed 4 bath ranch-style estate blends luxury, natural beauty and equestrian functionality, all set against the stunning backdrop of Longs Peak, Mt Meeker and the Flatirons. Privately gated and completely renovated by renowned Nassar Development in 2012, offering

    Janet Caminite Kentwood Real Estate Boulder Valley

    Section Image
  • 5952 Oxford Rd, Longmont, CO 80503

    $4,500,000

    • 4 Beds
    • 4.5 Baths
    • 4,376 Sq Ft
    • 5952 Oxford Rd
    • Longmont, CO

    A rare chance to own one of Colorado’s most thoughtfully designed + soulfully restored gentleman’s ranches. Just minutes from downtown Niwot + Boulder, this secluded yet central location offers easy access to Longmont, Lyons, Denver, + Fort Collins. Nestled into the ridge below Haystack Mountain, this 8.8-acre irrigated estate offers panoramic views from Pikes Peak to Longs Peak, the Flatirons to

    Coleen Sanders Compass - Denver

    Section Image
  • 5196 Oxford Rd, Longmont, CO 80503

    $3,695,000

    • 4 Beds
    • 2.5 Baths
    • 2,924 Sq Ft
    • 5196 Oxford Rd
    • Longmont, CO

    Escape from it all on this peaceful 38-acre Boulder County property featuring a 4-bed, three-bath home, incredible views, lush scenery, a spring-fed pond, 30 shares of Left Hand Ditch, and a bounty of outbuildings ready to accommodate any use or interest. Located just 20 minutes from Longmont amenities and Boulder attractions, this is the perfect farm getaway. The sunny residence welcomes

    Zachary Zeldner Compass - Boulder

    Section Image
  • 7979 N 41st St, Longmont, CO 80503

    $4,500,000

    • 5 Beds
    • 5 Baths
    • 5,728 Sq Ft
    • 7979 N 41st St
    • Longmont, CO

    Experience the perfect blend of rustic charm and modern luxury in this stunning farmhouse-style estate, situated on just over 9 acres of picturesque land. Located just a 10-minute drive from the heart of Boulder, this property offers a rare opportunity to enjoy country living with convenient city access. Each bedroom in this 5BD, 5BA home has its own bathroom, and the renovated walk-out lower

    Stephanie N Watson Compass - Boulder

    Section Image
  • 15789 N 83rd St, Longmont, CO 80503

    $3,250,000

    • 4 Beds
    • 5 Baths
    • 6,465 Sq Ft
    • 15789 N 83rd St
    • Longmont, CO

    Where the foothills meet the plains, this 9.13-acre estate offers natural beauty, timeless design, and sustainable living. Backing to Rabbit Mountain Open Space and hundreds of acres of protected land, it provides sweeping views, abundant wildlife, and privacy just 10 minutes from Longmont and 30 from Boulder. At its heart is a Provence-inspired farmhouse, remodeled by a European antiques dealer

    Zachary Zeldner Compass - Boulder

    Section Image
  • 9402 Crystal Ln, Longmont, CO 80503

    $4,495,000

    • 5 Beds
    • 5.5 Baths
    • 9,538 Sq Ft
    • 9402 Crystal Ln
    • Longmont, CO

    Enjoy privacy and exclusivity at this unrivaled Crystal Lane retreat, just 10 minutes from Longmont amenities and 30 minutes from Downtown Boulder. Experience gated, waterfront living at its very best in this stunning showplace featuring huge mountain views, expansive interiors and a bucolic water-front location on 5.57 verdant acres on Boulder County's Crystal Lake. Inside this beautifully

    Zachary Zeldner Compass - Boulder

    Section Image
  • 5767 Pelican Shores Dr, Longmont, CO 80504

    $3,200,000

    • 5 Beds
    • 5 Baths
    • 6,613 Sq Ft
    • 5767 Pelican Shores Dr
    • Longmont, CO

    Welcome to your dream home, where luxury meets the serenity of lakefront living. This exclusive property offers direct access to a private lake, perfect for all your favorite water activities. Whether you're into water skiing, surfing, wakeboarding, or fishing, this home is your year-round waterfront retreat. And yes—bring your boat! Step inside and be captivated by the elegance throughout. The

    Marshall Marquardt Equity Colorado Real Estate

    Section Image

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 Type Sale Price Title Company
Warranty Deed $4,300,000 Bstg (Blue Sky Title Group)
Bargain Sale Deed -- None Listed On Document
Personal Reps Deed $1,150,000 Fntc
Quit Claim Deed $27,500 None Available
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- Land Title Guarantee Company
Deed $200,000 --
Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $2,615,000 New Conventional
Previous Owner $3,000,000 Construction
Previous Owner $1,438,500 New Conventional
Previous Owner $175,000 Commercial
Previous Owner $1,380,000 New Conventional
Previous Owner $130,000 Unknown
Previous Owner $1,000,000 Adjustable Rate Mortgage/ARM
Previous Owner $115,000 Unknown
Previous Owner $115,000 Credit Line Revolving
Previous Owner $920,000 Adjustable Rate Mortgage/ARM
Previous Owner $1,480,000 Negative Amortization
Previous Owner $37,500 Credit Line Revolving
Previous Owner $1,462,500 New Conventional
Previous Owner $1,300,000 Unknown
Previous Owner $999,000 Unknown
Previous Owner $150,000 Credit Line Revolving
Previous Owner $638,000 Unknown
Previous Owner $100,000 Unknown
Previous Owner $153,000 Stand Alone Second
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/01/2025 08/01/25 Sold $4,300,000 -9.5% $655 / Sq Ft
06/11/2025 06/11/25 Pending -- -- --
04/23/2025 04/23/25 For Sale $4,750,000 +313.0% $724 / Sq Ft
01/28/2019 01/28/19 Off Market $1,150,000 -- --
06/03/2016 06/03/16 Sold $1,150,000 -17.7% $167 / Sq Ft
05/04/2016 05/04/16 Pending -- -- --
08/14/2015 08/14/15 For Sale $1,397,700 -- $203 / Sq Ft
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
2025 $15,252 $157,038 $27,638 $129,400
2024 $15,252 $157,038 $27,638 $129,400
2023 $14,992 $159,025 $17,668 $145,042
2022 $10,007 $102,123 $16,207 $85,916
2021 $10,029 $105,062 $16,674 $88,388
2020 $8,835 $94,810 $19,234 $75,576
2019 $8,687 $94,810 $19,234 $75,576
2018 $8,108 $89,064 $19,368 $69,696
2017 $7,902 $98,465 $21,412 $77,053
2016 $9,002 $100,503 $27,303 $73,200
2015 $8,249 $84,567 $30,089 $54,478
2014 $7,141 $84,567 $30,089 $54,478
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 1031895

IRES MLS

APN: 1317030-12-002