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.
Sold for $1,365,000
$1,365,000
2017 Vaquero St, Longmont, CO 80504
4beds
3,181sqft
Single Family Residence
Built in 1974
2.12 Acres Lot
$1,366,000 Zestimate®
$429/sqft
$3,430 Estimated rent
Home value
$1,366,000
$1.30M - $1.43M
$3,430/mo
Zestimate® history
Owner options
List your home for rent
$3,430/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,430/mo
Rent Zestimate®
Refinance and save
$6,362/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$6,362/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Lindsey Hanna 714-504-1463,
Homestead Real Estate, LLC
Bought with:
Lindsey Hanna, 100068460
Homestead Real Estate, LLC
Source: IRES as distributed by MLS GRID,MLS#: 1037847
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- 3/4 bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Primary bedroom
- Description: Luxury Vinyl
- Features: Luxury Features Primary Bath
- Level: Upper
- Area: 210 Square Feet
- Dimensions: 14 x 15
Bedroom 2
- Description: Luxury Vinyl
- Level: Upper
- Area: 192 Square Feet
- Dimensions: 12 x 16
Bedroom 3
- Description: Luxury Vinyl
- Level: Upper
- Area: 165 Square Feet
- Dimensions: 11 x 15
Bedroom 4
- Description: Luxury Vinyl
- Level: Upper
- Area: 110 Square Feet
- Dimensions: 10 x 11
Dining room
- Description: Luxury Vinyl
- Level: Main
- Area: 100 Square Feet
- Dimensions: 10 x 10
Family room
- Description: Luxury Vinyl
- Level: Main
- Area: 255 Square Feet
- Dimensions: 15 x 17
Kitchen
- Description: Luxury Vinyl
- Level: Main
- Area: 210 Square Feet
- Dimensions: 10 x 21
Laundry
- Description: Luxury Vinyl
- Level: Upper
- Area: 88 Square Feet
- Dimensions: 8 x 11
Living room
- Description: Luxury Vinyl
- Level: Main
- Area: 255 Square Feet
- Dimensions: 15 x 17
Heating
- Forced Air
Cooling
- Central Air, Ceiling Fan(s)
Appliances
- Included: Gas Range, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
- Laundry: Sink, Washer/Dryer Hookup
Features
- Separate Dining Room, Open Floorplan, Walk-In Closet(s), Steam Shower
- Windows: Window Coverings
- Basement: Partial,Unfinished
- Has fireplace: Yes
- Fireplace features: Family Room
Interior area
- Total structure area: 2,481
- Total interior livable area: 3,181 sqft
- Finished area above ground: 2,481
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener
- Attached garage spaces: 2
- Details: Attached
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck
- Exterior features: Sprinkler System
- Spa features: Heated
- Fencing: Fenced,Dog Run/Kennel
- Has view: Yes
- View description: Mountain(s), Hills
Lot
- Size: 2.12 Acres
- Features: Evergreen Trees, Deciduous Trees, Level
Details
- Additional structures: Storage
- Parcel number: R0496260
- Zoning: FA1
- Special conditions: Private Owner
- Other equipment: Fireplace Tools Included
- Horses can be raised: Yes
- Horse amenities: Horse(s) Allowed, Barn, Pasture, Loafing Shed, Hay Storage
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Brick, Stucco
- Roof: Composition
Condition
- New construction: No
- Year built: 1974
Utilities & green energy
- Electric: PVREA
- Gas: Xcel
- Sewer: Septic Tank
- Water: District
- Utilities for property: Natural Gas Available, Electricity Available
Green energy
- Energy efficient items: Windows, High Efficiency Furnace, Thermostat
Community & HOA
Community
- Security: Fire Alarm
- Subdivision: Horseshoe Park
HOA
- Has HOA: No
Location
- Region: Longmont
Financial & listing details
- Price per square foot: $429/sqft
- Tax assessed value: $856,900
- Annual tax amount: $4,585
- Date on market: 6/27/2025
- Listing terms: Cash,Conventional,FHA,VA Loan
- Electric utility on property: Yes
Price history
| Date | Event | Price |
|---|---|---|
| 9/5/2025 | Sold | $1,365,000-2.4%$429/sqft |
Source:  IRES as distributed by MLS GRID #1037847 Report a problem | ||
| 8/18/2025 | Pending sale | $1,399,000$440/sqft |
Source:  REcolorado as distributed by MLS GRID #IR1037847 Report a problem | ||
| 8/7/2025 | Price change | $1,399,000-5.5%$440/sqft |
Source: REcolorado as distributed by MLS GRID #IR1037847 Report a problem | ||
| 6/27/2025 | Listed for sale | $1,480,000$465/sqft |
Source: REcolorado as distributed by MLS GRID #IR1037847 Report a problem | ||
| 6/24/2025 | Listing removed | $1,480,000$465/sqft |
Source: IRES as distributed by MLS GRID #1033812 Report a problem | ||
| 6/13/2025 | Price change | $1,480,000-0.7%$465/sqft |
Source: IRES as distributed by MLS GRID #1033812 Report a problem | ||
| 5/16/2025 | Listed for sale | $1,490,000+83%$468/sqft |
Source: IRES as distributed by MLS GRID #1033812 Report a problem | ||
| 11/2/2021 | Sold | $814,000-0.6%$256/sqft |
Source: IRES as distributed by MLS GRID #950156 Report a problem | ||
| 9/9/2021 | Price change | $819,000-0.7%$257/sqft |
Source: IRES as distributed by MLS GRID #950156 Report a problem | ||
| 9/2/2021 | Listed for sale | $825,000+120%$259/sqft |
Source: IRES as distributed by MLS GRID #950156 Report a problem | ||
| 10/12/2011 | Listing removed | $375,000$118/sqft |
Source: ERA Tradewind Real Estate, LLC #664378 Report a problem | ||
| 10/6/2011 | Listed for sale | $375,000$118/sqft |
Source: ERA Tradewind Real Estate, LLC #1033042 Report a problem | ||
| 9/28/2011 | Pending sale | $375,000$118/sqft |
Source: ERA Tradewind Real Estate, LLC #1033042 Report a problem | ||
| 8/30/2011 | Listed for sale | $375,000+54.6%$118/sqft |
Source: ERA Tradewind Real Estate #664378 Report a problem | ||
| 8/21/1997 | Sold | $242,500$76/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,909 +7.1% | $53,557 -5.5% |
| 2024 | $4,585 +35.7% | $56,682 +9.3% |
| 2023 | $3,380 -2.7% | $51,881 +32.4% |
| 2022 | $3,474 +6% | $39,184 -2.8% |
| 2021 | $3,278 +1.5% | $40,312 +6% |
| 2020 | $3,230 +11.4% | $38,024 -0.7% |
| 2019 | $2,899 | $38,290 +17.5% |
| 2018 | $2,899 | $32,594 |
| 2017 | $2,899 +14.7% | $32,594 +10.1% |
| 2016 | $2,527 +7.4% | $29,611 0% |
| 2015 | $2,352 +1.2% | $29,620 +6.2% |
| 2014 | $2,323 | $27,890 |
| 2013 | -- | $27,890 +3.3% |
| 2012 | -- | $26,990 |
| 2011 | -- | $26,990 -4.9% |
| 2010 | -- | $28,380 |
| 2009 | -- | $28,380 -0.2% |
| 2008 | -- | $28,450 |
| 2007 | -- | $28,450 0% |
| 2006 | -- | $28,460 |
| 2005 | -- | $28,460 +0.7% |
| 2004 | -- | $28,270 -2.1% |
| 2002 | -- | $28,880 |
| 2001 | -- | $28,880 |
Find assessor info on the county website
Neighborhood: 80504
Nearby homes
- $885,4005 bd2 ba3.4k sqft2005 Vaquero St, Longmont, CO 80504Off Market
- $750,5004 bd2 ba2.2k sqft2113 Caballo Ave, Longmont, CO 80504Off Market
- $1,000,7003 bd3 ba4.7k sqft2004 Caballo Ave, Longmont, CO 80504Off Market
- $928,5114 bd3 ba3.3k sqft2200 Horseshoe Cir, Longmont, CO 80504Sold
- $778,3003 bd1 ba1.9k sqft2101 Caballo Ave, Longmont, CO 80504Off Market
- $922,9004 bd2 ba2.4k sqft1921 Vaquero St, Longmont, CO 80504Off Market
- $874,9004 bd2 ba1.4k sqft1812 Horseshoe Cir N, Longmont, CO 80504Off Market
- $845,0004 bd3 ba2.8k sqft1920 Vaquero St, Longmont, CO 80504Sold
Nearby schools
GreatSchools rating
- 6/10Ivy Stockwell Elementary SchoolGrades: K-5Distance: 2.7 mi
- 5/10Turner Middle SchoolGrades: 6-8Distance: 3 mi
- 7/10Berthoud High SchoolGrades: 9-12Distance: 2.5 mi
Schools provided by the listing agent
- Elementary: Ivy Stockwell
- Middle: Berthoud Jr/Sr
- High: Berthoud
Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,366,000
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,366,000
- Colorado
- Larimer County
- Berthoud
- 80504
- 2017 Vaquero St
Nearby cities
Nearby zip codes
Other Berthoud Topics
