$1,575,000
OPEN SAT 11AM - 2PM $300K PRICE DROP

Estimated payment $9,518/month

Total Views 7,646
5 Beds
4.5 Baths
6,209 Sq Ft
$254 Price per Sq Ft

Highlights

  • Primary Bedroom Suite
  • 2.31 Acre Lot
  • Deck
  • City View
  • Open Floorplan
  • Contemporary Architecture

About This Home

Open House Sat 8th 11AM-2PM. Active First Right - Continue to Show! The current contract is contingent upon the buyer's home sale, presenting a unique opportunity for another buyer to secure this exceptional property. Schedule your showing today while this opportunity remains available. This isn't your typical 2005 home. With hundreds of thousands invested in improvements, it lives like new. Major updates include a new Class 4 impact-resistant roof, new high-efficiency windows, new furnaces, new A/C units, new water heaters, new carpet, new epoxy garage floor, and a beautifully finished basement living space with kitchenette. Over $400,000 has been invested in the outdoor living spaces and professional landscaping, creating an exceptional private retreat. Located in a gated community on 2.31 acres with no Metro District taxes, FA1 zoning, and room to build an outbuilding, just minutes from Boulder, Longmont, Loveland, Fort Collins, TPC Colorado golf course, I-25 and Denver with an easy drive to many recreation opportunities. The custom home features newly refinished travertine floors, formal living and dining rooms, a private office, gourmet kitchen with knotty alder cabinetry, granite slab countertops, built-in refrigerator, 42" gas range, center island and walk-in pantry. The vaulted family room features a dramatic stacked stone fireplace. Upstairs offers a luxurious primary suite with fireplace, private balcony, dual walk-in closets and spa bath, plus additional bedrooms, loft and second laundry. The walk-out basement includes a theater or fitness space, billiards area, family room, wine room, guest suite and remodeled bath. Enjoy a circular stamped concrete driveway, wraparound covered porch, private courtyard, expansive patios, wood-burning fire pit, mature landscaping and a 3-car oversized finished garage. Request the complete features list to appreciate the extensive upgrades throughout this exceptional property.

Listing Agent

John Simmons

C3 Real Estate Solutions LLC Brokerage Phone: 970-225-5152 License #100001625 Listed on: 04/17/2026

C3 Real Estate Solutions LLC

Open House Schedule

  • Saturday, August 8, 2026
    11:00 am to 2:00 pm
    8/8/2026 11:00:00 AM +00:00
    8/8/2026 2:00:00 PM +00:00

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,291

Year Built

  • Built in 2005

Lot Details

  • 2.31 Acre Lot

HOA Fees

  • $179 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Property Views

  • City
  • Pasture
  • Mountain

Home Design

  • Contemporary Architecture
  • Fiberglass Roof
  • Wood Siding
  • Stone Siding
  • Stucco

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Vaulted Ceiling
  • Ceiling Fan
  • Family Room with Fireplace
  • Great Room
  • Living Room with Fireplace
  • Dining Room
  • Home Office

Kitchen

  • Breakfast Bar
  • Double Oven
  • Microwave
  • Dishwasher

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • 1 Bedroom in Basement

Outdoor Features

  • Deck
  • Patio

Schools

  • Ivy Stockwell Elementary School
  • Turner Middle School
  • Berthoud High School

Utilities

  • Forced Air Heating and Cooling System
  • Radiant Heating System
  • Septic Tank

Community Details

  • Willis Farm HOA, Phone Number (303) 775-1711
  • Willis Farms Subdivision

Listing and Financial Details

  • Exclusions: Sellers Personal Property
  • Assessor Parcel Number R1606666

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,291

Year Built

Built in 2005

Lot Details

2.31 Acres

HOA Fees

$179 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: Two
  • Year Built: 2005
  • Above Grade Finished Sq Ft: 3987
  • Below Grade Sq Ft: 427
  • Exclusions: Sellers Personal Property
  • Living Area: 6209
  • SubdivisionName: Willis Farms
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBedrooms: 1
  • REC_ExpectedActiveDate: 2026-04-17
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 3
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • OpenHousePublicUpcoming: Public: Sat Aug 8, 11:00AM-2:00PM
  • OpenHouseUpcoming: Public: Sat Aug 8, 11:00AM-2:00PM
  • REC_AdditionalLivingStructureYN: 0
  • Special Features: OpenHouse

Interior Features

  • Appliances: Dishwasher, Double Oven, Dryer, Microwave, Oven, Refrigerator, Washer
  • Interior Amenities: Breakfast Bar, Ceiling Fan(s), Open Floorplan, Pantry, Vaulted Ceiling(s), Walk-In Closet(s)
  • Flooring: Carpet, Tile, Vinyl
  • Fireplace Features: Family Room, Living Room
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Finished, Full
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 2222
  • Main Level Bathrooms: 1

Exterior Features

  • Roof: Fiberglass
  • Construction Materials: Stone, Stucco, Wood Siding
  • View: City, Mountain(s), Plains
  • Patio and Porch Features: Deck, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3

Utilities

  • Sewer: Septic Tank
  • Cooling: Central Air
  • Heating: Forced Air, Radiant
  • Water Source: Public

Condo/Co-op/Association

  • Association Name: Willis Farm HOA
  • Association Fee Frequency: Annually
  • Association Fee: 2150
  • Phone: 303-775-1711
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 2150.00
  • REC_AssociationFeeTotalAnnual: 2150.00
  • REC_AssociationManagementType: Professionally Managed

Schools

  • Middle Or Junior School: Turner

Lot Info

  • Parcel Number: R1606666
  • Lot Size Acres: 2.31
  • Building Area Total: 6636
  • Lot Size Sq Ft: 100624

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 8291

MLS Schools

  • Elementary School: Ivy Stockwell
  • High School: Berthoud

Map

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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $8,291 $90,457 $22,188 $68,269
2024 $7,935 $98,524 $23,785 $74,739
2022 $4,106 $47,607 $17,055 $30,552
2021 $4,221 $48,977 $17,546 $31,431
2020 $3,070 $35,615 $12,663 $22,952
2019 $3,026 $35,615 $12,663 $22,952
2018 $4,379 $49,233 $13,471 $35,762
2017 $3,817 $49,233 $13,471 $35,762
2016 $4,267 $53,364 $13,134 $40,230
2015 $4,238 $64,150 $13,130 $51,020
2014 $4,740 $56,900 $11,460 $45,440
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/04/2026 08/04/26 Price Changed $1,575,000 -0.9% $254 / Sq Ft
06/17/2026 06/17/26 Price Changed $1,589,000 -5.9% $256 / Sq Ft
05/21/2026 05/21/26 Price Changed $1,689,000 -5.5% $272 / Sq Ft
04/29/2026 04/29/26 Price Changed $1,787,000 -4.7% $288 / Sq Ft
04/17/2026 04/17/26 For Sale $1,875,000 -- $302 / Sq Ft
Source: REcolorado®

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Quit Claim Deed -- None Listed On Document
Warranty Deed $188,000 Fahtco
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Previous Owner $552,900 Construction
Source: Public Records

Source: REcolorado®

MLS Number: 4657610

REcolorado®

APN: 94354-07-012

Your Personal Tour Guide

Ask me questions while you tour the home.