$1,399,000
$81K PRICE DROP

2017 Vaquero St Longmont, CO 80504

Estimated payment $8,005/month

Total Views 4,500
4 Beds
2.5 Baths
3,181 Sq Ft
$440 Price per Sq Ft

Highlights

  • Barn or Stable
  • Open Floorplan
  • Deck
  • Spa
  • Mountain View
  • Steam Shower

About This Home

Discover a rare and remarkable opportunity to own a beautifully renovated retreat that blends rustic charm with modern luxury-set against the breathtaking backdrop of Longs Peak. Nestled on two pristine, fully fenced acres, this like-new home underwent a high-quality renovation inside and out, offering the craftsmanship and design of a modern custom build. Every detail has been thoughtfully curated, from high-end finishes to durable, timeless materials. A brand-new roof was installed in 2024, ensuring peace of mind for years to come. Inside, expansive living spaces are filled with natural light and feature luxury flooring, energy-efficient windows and doors, and a warm, elegant atmosphere. The home offers four spacious bedrooms and three bathrooms, including a spa-inspired primary suite with a custom steam shower and walk in closet-your own private sanctuary. An upstairs laundry room adds convenience to the well-considered layout. Outside, the property is enclosed by custom steel fencing with an automatic gated entry, providing both privacy and security. Perfect for equestrians or hobby farmers, the land includes a 36x36 custom barn with two stalls, stall mattress systems, Nelson automatic waterers, and built-in fans. Fenced paddocks, a wash rack, and room to expand enhance the property's versatility. A fully enclosed hay storage building connects to the barn, while a chicken coop, two sheds, and a covered tractor bay offer additional functionality. An orchard of mature apple, cherry, and peach trees adds to the charm, while panoramic views of Longs Peak provide a stunning natural backdrop. Whether you're sipping morning coffee on the custom wraparound porch or caring for your animals under Colorado's wide-open skies, this extraordinary property offers an unparalleled blend of comfort, serenity, and elevated country living.

Listing Agent

Lindsey Hanna

Homestead Real Estate, LLC Listed on: 06/27/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,585

Year Built

  • Built in 1974

Lot Details

  • 2.12 Acre Lot
  • Kennel or Dog Run
  • Fenced
  • Level Lot
  • Sprinkler System
  • Landscaped with Trees
  • Property is zoned FA1

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Brick Veneer
  • Wood Frame Construction
  • Composition Roof
  • Stucco

Interior Spaces

  • 3,181 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Ceiling Fan
  • Includes Fireplace Accessories
  • Double Pane Windows
  • Window Treatments
  • Family Room
  • Dining Room
  • Recreation Room with Fireplace
  • Luxury Vinyl Tile Flooring
  • Mountain Views
  • Unfinished Basement
  • Partial Basement
  • Fire and Smoke Detector

Kitchen

  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Steam Shower

Laundry

  • Laundry on upper level
  • Dryer
  • Washer
  • Sink Near Laundry

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Energy-Efficient Thermostat

Outdoor Features

  • Spa
  • Deck
  • Outdoor Storage

Schools

  • Ivy Stockwell Elementary School
  • Berthoud Jr/Sr Middle School
  • Berthoud High School

Farming

  • Loafing Shed
  • Pasture

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Hay Storage
  • Barn or Stable

Utilities

  • Forced Air Heating and Cooling System
  • Septic System

Community Details

  • No Home Owners Association
  • Horseshoe Park Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0496260

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,585

Year Built

Built in 1974

Lot Details

0

Parking

2

Listing Details

  • Inclusions: Window Coverings,Gas Range/Oven,Dishwasher,Refrigerator,Clothes Washer,Clothes Dryer,Microwave,Laundry Tub,Garage Door Opener,Fireplace Tools Included,Disposal,Smoke Alarm(s)
  • Year Built: 1974
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: Yes
  • Lot Size Acres: 2.12
  • Subdivision Name: Horseshoe Park
  • Above Grade Finished Sq Ft: 2481
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Efficiency: HVAC, Thermostat
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3181
  • Special Features: VirtualTour
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
  • Has Basement: Partial, Unfinished
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 700
  • Fireplace Features: Family/Recreation Room Fireplace, Fireplace Tools Included
  • Fireplace: Yes
  • Interior Amenities: Separate Dining Room, Open Floorplan, Walk-In Closet(s), Steam Shower
  • Living Area: 2481
  • Main Level Bathrooms: 1
  • Window Features: Window Coverings, Double Pane Windows
  • Room Bedroom4 Area: 110
  • Room Bedroom3 Features: Luxury Vinyl Floor
  • Dining Room Features: Luxury Vinyl Floor
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Upper
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 165
  • Room Bedroom4 Features: Luxury Vinyl Floor
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 192
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 14
  • Room Family Room Area: 255
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Luxury Vinyl Floor
  • Master Bedroom Features: Luxury Vinyl Floor
  • Room Family Room Level: Main
  • Room Kitchen Features: Luxury Vinyl Floor
  • Room Living Room Area: 255
  • Family Room Features: Luxury Vinyl Floor
  • Living Room Features: Luxury Vinyl Floor
  • Room Kitchen Area: 210
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 210
  • Room Dining Room Area: 100
  • Master Bathroom Features: Luxury Features Primary Bath

Exterior Features

  • Roof: Composition
  • Fencing: Fenced
  • Lot Features: Lawn Sprinkler System, Level
  • View: Mountain(s), Foothills View
  • View: Yes
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure, Lead Paint Disclosure
  • Home Warranty: No
  • Construction Type: Wood/Frame, Brick/Brick Veneer, Stucco
  • Exterior Features: Hot Tub Included
  • Other Structures: Kennel/Dog Run, Storage
  • Patio And Porch Features: Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: Garage Door Opener
  • IRESDS_Garage Sq Ft: 484
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, PVREA
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Sink, Washer/Dryer Hookups, Upper Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: Septic
  • Water Source: District Water, Little Thompson
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Elementary School: Ivy Stockwell
  • HighSchool: Berthoud
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: Berthoud Jr/Sr

Lot Info

  • Zoning: FA1
  • Current Use: Horses
  • Horse Amenities: Barn with 1-2 Stalls, Pasture, Loafing Shed, Hay Storage
  • Lot Size Sq Ft: 92347
  • Parcel #: R0496260
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 4585

Multi Family

Map

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

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 $4,585 $56,682 $14,405 $42,277
2024 $3,991 $51,382 $14,405 $36,977
2022 $3,380 $39,184 $13,900 $25,284
2021 $3,474 $40,312 $14,300 $26,012
2020 $3,278 $38,024 $14,300 $23,724
2019 $3,230 $38,024 $14,300 $23,724
2018 $2,899 $32,594 $6,120 $26,474
2017 $2,527 $32,594 $6,120 $26,474
2016 $2,368 $29,611 $6,766 $22,845
2015 $2,352 $29,620 $6,770 $22,850
2014 $2,323 $27,890 $5,410 $22,480
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/07/2025 08/07/25 Price Changed $1,399,000 -5.5% $440 / Sq Ft
06/27/2025 06/27/25 For Sale $1,480,000 +81.8% $465 / Sq Ft
02/02/2022 02/02/22 Off Market $814,000 -- --
11/02/2021 11/02/21 Sold $814,000 -0.6% $231 / Sq Ft
09/09/2021 09/09/21 Price Changed $819,000 -0.7% $233 / Sq Ft
09/02/2021 09/02/21 For Sale $825,000 -- $234 / Sq Ft
Source: IRES MLS

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed $814,000 None Listed On Document
Special Warranty Deed $814,000 First American Title
Warranty Deed $242,500 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $210,000 Credit Line Revolving
Previous Owner $651,200 New Conventional
Previous Owner $407,700 New Conventional
Previous Owner $310,000 New Conventional
Previous Owner $312,067 New Conventional
Previous Owner $328,000 Unknown
Previous Owner $41,500 Credit Line Revolving
Previous Owner $328,000 Unknown
Previous Owner $328,000 Unknown
Previous Owner $60,000 Credit Line Revolving
Previous Owner $240,000 Unknown
Previous Owner $75,000 Unknown
Previous Owner $207,000 Unknown
Previous Owner $194,000 No Value Available
Source: Public Records

Similar Homes in Longmont, CO

  • 8924 Prairie Knoll Dr, Longmont, CO 80503

    $1,850,000

    • 5 Beds
    • 6 Baths
    • 7,461 Sq Ft
    • 8924 Prairie Knoll Dr
    • Longmont, CO

    Welcome to 8924 Prairie Knoll Drive in Majestic Retreat-a one-of-a-kind Prairie Style estate on 1.21 private acres backing to Boulder County Open Space. With over 7,400 SqFt of luxurious living space, this custom-built home offers five bedrooms, six bathrooms, and five fireplaces, blending timeless elegance with unmatched functionality. Start your day relaxing in the hot tub with a cup of coffee,

    Brie Fowler The Agency - Boulder

    Section Image
  • 5629 Cottontail Dr, Longmont, CO 80503

    $1,166,234

    • 4 Beds
    • 3.5 Baths
    • 2,777 Sq Ft
    • 5629 Cottontail Dr
    • Longmont, CO

    Move-in ready 4-bedroom + Study, exuding elegance and comfort! Enjoy your morning coffee on the welcoming front porch while gazing at your low-care landscaping. Upon entering, you'll see a hallway leading to the bright living room with a fireplace as the centerpiece of the room. Immaculate eat-in kitchen showcases stainless steel appliances, quartz counters, an island with a breakfast bar, wood

    Jesus Orozco Jesus Orozco Jr

    Section Image
  • 5608 Grandville Ave, Longmont, CO 80503

    $1,240,797

    • 4 Beds
    • 2.5 Baths
    • 2,970 Sq Ft
    • 5608 Grandville Ave
    • Longmont, CO

    Your dream home is within reach! This 4-bedroom residence welcomes you with a 3-car garage and a front porch that sets an inviting atmosphere. Fall in love with the captivating open layout with soaring ceilings, plenty of windows that bathe the space with natural light, a soothing palette, wood flooring, and a cozy fireplace for relaxing evenings with loved ones. The eat-in kitchen boasts quartz

    Jesus Orozco Jesus Orozco Jr

    Section Image
  • 5575 Moosehead Cir, Longmont, CO 80503

    $1,188,127

    • 4 Beds
    • 3.5 Baths
    • 2,777 Sq Ft
    • 5575 Moosehead Cir
    • Longmont, CO

    Entertaining has never been easier, thanks to the large island, open main floor and back patio on this Harmony plan. Ample amounts of natural light pour through the large windows and sliding glass doors. Coats and boots are out of sight in the convenient owner's entry that holds a closet, cubbies, built in bench and hooks. This kitchen has everything from a large pantry to a butler's pantry that

    Jesus Orozco Jesus Orozco Jr

    Section Image
  • 5567 Moosehead Cir, Longmont, CO 80503

    $1,499,900

    • 6 Beds
    • 4.5 Baths
    • 3,627 Sq Ft
    • 5567 Moosehead Cir
    • Longmont, CO

    Huge announcement! McStain Neighborhoods is selling its model home situated in the highly soughtWest Grange community in the heart of Boulder County, Colorado. Built in 2022, this stunning home offers over 3600 square feet of thoughtfully designed living space, featuring 6 bedrooms, 5 bathrooms, main-floor study, and a fullyfinished basement. As McStain's model home, it showcases

    Jesus Orozco Jesus Orozco Jr

    Section Image
  • 2005 Calico Ct, Longmont, CO 80503

    $1,440,000

    • 6 Beds
    • 4.5 Baths
    • 5,723 Sq Ft
    • 2005 Calico Ct
    • Longmont, CO

    Wonderful stucco and stone family home in one of Boulder County's most beloved neighborhoods. Original custom home in the first phase of Somerset Meadows with 6 Bedrooms and 4.5 bathrooms on a quiet cul-de-sac. Fully equipped cherry and granite kitchen with 5-burner gas stove in the island, double ovens and stainless appliances. The kitchen area opens to a walkout deck which overlooks a

    Steve Kiss Equity Colorado-Front Range

    Section Image
  • 2316 Horseshoe Cir, Longmont, CO 80504

    $1,350,000

    • 5 Beds
    • 4 Baths
    • 4,229 Sq Ft
    • 2316 Horseshoe Cir
    • Longmont, CO

    Experience the perfect blend of country living and comfort at 2316 Horseshoe Circle! Situated on 4.18 acres with mountain views, this property offers the space, privacy, and amenities you've been dreaming of. Equestrians and hobby farmers will love the fully fenced pasture, 5-stall barn with tack room, enclosed 2-stall shed, and 3 strategically placed water hydrants-one in the barn and two in the

    Cheryl Melichar Coldwell Banker Realty-NOCO

    Section Image
  • 10650 Yellowstone Rd, Longmont, CO 80504

    $1,250,000

    • 4 Beds
    • 2.5 Baths
    • 2,812 Sq Ft
    • 10650 Yellowstone Rd
    • Longmont, CO

    OPEN HOUSE SATURDAY 8/15/2025 from 10:00 AM to Noon. Come see the great yard and stunning views! Welcome to the top of Boulder County's prestigious Yellowstone Road. Offering a $15,000 seller concession towards rate buydown, closing costs, or updates. Unobstructed views of the entire front range from Wyoming to the Spanish Peaks of Southern Colorado. This stunning hilltop location, surrounded by

    Max Engelhardt Engel & Voelkers Aspen - Snowmass

    Section Image
  • 8971 Prairie Knoll Dr, Longmont, CO 80503

    $1,550,000

    • 3 Beds
    • 2.5 Baths
    • 5,476 Sq Ft
    • 8971 Prairie Knoll Dr
    • Longmont, CO

    Welcome to this exceptional home, situated in the prestigious and highly sought-after Majestic Retreat subdivision, where location and privacy are unparalleled. Set on a serene 1.55-acre lot, the property is surrounded by protected Conservatory Farmland to the west and north, offering stunning, unobstructed mountain views that will never be developed. The main floor features a luxurious primary

    Alexis Foster Group Centerra

    Section Image

Source: IRES MLS

MLS Number: 1037847

IRES MLS

APN: 94342-06-009