Welcome to this brand-new, high-end custom retreat built in 2026, perfectly positioned on 8.8 private acres with no HOA or metro district! Offering 180-degree views of the majestic Rocky Mountains to the west and rolling pasture land to the east, every single room in this home, including the walk-out basement, is designed to capture breathtaking Colorado scenery. Step inside to a stunning great room boasting soaring ceilings, a striking gas fireplace, rich wood flooring, and a dramatic wall of windows. The gourmet chef’s kitchen is a true centerpiece, featuring premium Electrolux appliances, quartz countertops, a massive island with breakfast bar, and rich custom cabinetry. Adjacent to the kitchen, the dining area opens via sliding glass doors to the upper deck for effortless entertaining. A beautiful private office, a powder room, and a dedicated laundry room reside nearby. On the opposite wing, the primary suite serves as a sanctuary, complete with a spa-like 5-piece en-suite bath featuring a deep soaking tub, custom walk-in shower, and a massive walk-in closet. A second bedroom with its own private en-suite bath completes the main floor. The light-filled walk-out basement is anchored by a huge family room with a wet bar and direct patio access. A media room with bar seating creates the ultimate setting for movie nights. Two additional bedrooms, a 1/2 bath, a 3/4 bath, and a private exercise room round out the lower level. Relax on the upper deck or lower patio and take in endless big-sky views. The property is exceptionally equipped for future expansion, featuring a heated detached 2-car garage/barn with electricity, a 220V connection ready for a hot tub on the south side, a 100A electrical hookup on the NE corner for future structures, 2 additional water connection points, and several designed options for retaining walls. Offering total peace, freedom, luxury finishes, and endless possibilities on nearly 9 acres, this masterpiece is ready for you to call home!
For sale
$2,200,000
17895 County Road 3, Berthoud, CO 80513
4beds
4,892sqft
Single Family Residence
Built in 2026
8.8 Acres Lot
$-- Zestimate®
$450/sqft
$-- HOA
What's special
- 5 days
- 842
- 89
Zillow last checked:
Listing updated:
Listed by:
Matt Purdy 970-347-9387 matt.purdy@redfin.com,
Redfin Corporation
Source: REcolorado as distributed by MLS GRID,MLS#: 5474734
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 1
- 3/4 bathrooms: 2
- 1/2 bathrooms: 2
- Main level bathrooms: 3
- Main level bedrooms: 2
Bedroom
- Description: En-Suite Bathroom, Ceiling Fan, Carpet Flooring
- Features: Primary Suite
- Level: Main
- Area: 252 Square Feet
- Dimensions: 14 x 18
Bedroom
- Description: En-Suite Bathroom, Ceiling Fan, Walk-In Closet, Carpet Flooring
- Level: Main
- Area: 238 Square Feet
- Dimensions: 17 x 14
Bedroom
- Description: Closet, Carpet Flooring
- Level: Basement
- Area: 168 Square Feet
- Dimensions: 12 x 14
Bedroom
- Description: Closet, Carpet Flooring
- Level: Basement
- Area: 168 Square Feet
- Dimensions: 14 x 12
Bathroom
- Description: Dual Sinks With Vanity, Soaking Tub, Walk-In Shower, Water Closet, Walk-In Closet, Tile Flooring
- Features: En Suite Bathroom, Primary Suite
- Level: Main
- Area: 135 Square Feet
- Dimensions: 9 x 15
Bathroom
- Description: Sink With Vanity, Shower, Laminate Flooring
- Features: En Suite Bathroom
- Level: Main
- Area: 55 Square Feet
- Dimensions: 5 x 11
Bathroom
- Description: Sink With Vanity, Wood Flooring
- Level: Main
- Area: 20 Square Feet
- Dimensions: 4 x 5
Bathroom
- Description: Sink With Vanity, Laminate Flooring
- Level: Basement
- Area: 30 Square Feet
- Dimensions: 6 x 5
Bathroom
- Description: Sink With Vanity, Shower, Laminate Flooring
- Level: Basement
- Area: 50 Square Feet
- Dimensions: 10 x 5
Dining room
- Description: Sliding Glass Doors To Deck, Wood Flooring
- Level: Main
- Area: 240 Square Feet
- Dimensions: 16 x 15
Exercise room
- Description: Door To Patio
- Level: Basement
- Area: 378 Square Feet
- Dimensions: 18 x 21
Family room
- Description: Wet Bar, Sliding Glass Doors To Patio, Carpet Flooring
- Level: Basement
Great room
- Description: High Ceilings, Fireplace, Dual Ceiling Fans, Wood Flooring
- Level: Main
- Area: 704 Square Feet
- Dimensions: 32 x 22
Kitchen
- Description: High Ceilings, Quartz Countertops, Island With Breakfast Bar, Cabinetry, Wood Flooring
- Level: Main
- Area: 255 Square Feet
- Dimensions: 15 x 17
Laundry
- Description: Laundry, Utility Sink, Wood Flooring
- Level: Main
- Area: 99 Square Feet
- Dimensions: 11 x 9
Media room
- Description: Carpet Flooring
- Level: Basement
- Area: 864 Square Feet
- Dimensions: 24 x 36
Office
- Description: Wood Flooring
- Level: Main
- Area: 110 Square Feet
- Dimensions: 10 x 11
Heating
- Forced Air, Propane
Cooling
- Central Air
Appliances
- Included: Bar Fridge, Convection Oven, Cooktop, Dishwasher, Disposal, Humidifier, Microwave, Range, Range Hood, Refrigerator, Self Cleaning Oven, Tankless Water Heater
Features
- Ceiling Fan(s), Entrance Foyer, Granite Counters, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Sauna, Smart Thermostat, Smoke Free, Solid Surface Counters, Walk-In Closet(s), Wet Bar, Wired for Data
- Flooring: Carpet, Laminate, Wood
- Windows: Double Pane Windows, Window Coverings, Window Treatments
- Basement: Daylight,Finished,Interior Entry,Sump Pump,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Circulating, Gas, Gas Log, Living Room
Interior area
- Total structure area: 4,892
- Total interior livable area: 4,892 sqft
- Finished area above ground: 2,446
- Finished area below ground: 1,971
Video & virtual tour
Property
Parking
- Total spaces: 5
- Parking features: Circular Driveway, Dry Walled, Exterior Access Door, Heated Garage, Insulated Garage, Lighted, Oversized
- Attached garage spaces: 5
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Deck, Front Porch, Patio
- Exterior features: Gas Valve, Lighting, Rain Gutters
- Fencing: None
- Has view: Yes
- View description: Meadow, Mountain(s), Water
- Has water view: Yes
- Water view: Water
Lot
- Size: 8.8 Acres
- Features: Meadow, Open Space, Secluded, Suitable For Grazing
Details
- Parcel number: R8979741
- Special conditions: Standard
- Horses can be raised: Yes
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Mountain Contemporary
- Property subtype: Single Family Residence
Materials
- Frame, Wood Siding
Condition
- Year built: 2026
Utilities & green energy
- Electric: 110V, 220 Volts, 220 Volts in Garage
- Water: Public
- Utilities for property: Electricity Connected, Propane
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Smart Cameras, Smoke Detector(s), Video Doorbell, Water Leak/Flood Alarm
- Subdivision: Berthoud
HOA
- Has HOA: No
Location
- Region: Berthoud
Financial & listing details
- Price per square foot: $450/sqft
- Tax assessed value: $1,406,147
- Annual tax amount: $1,699
- Date on market: 9/4/2026
- Listing terms: Cash,Conventional,FHA,VA Loan
- Exclusions: Seller's Personal Property
- Ownership: Individual
- Electric utility on property: Yes
- Road surface type: Dirt, Gravel
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 9/4/2026 | Listed for sale | $2,200,000$450/sqft |
Source:  REcolorado as distributed by MLS GRID #5474734 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $1,699 +860.7% | $96,040 +460% |
| 2025 | $177 +4.3% | $17,150 +797.9% |
| 2024 | $169 -6.9% | $1,910 |
| 2023 | $182 | $1,910 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 80513
Nearby schools
Schools provided by the listing agent
- Elementary: Mead
- Middle: Mead
- High: Mead
- District: St. Vrain Valley RE-1J
Source: REcolorado 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.
Similar homes
- $1,559,0004 bd5 ba6.6k sqft559 Dove Ln, Berthoud, CO 80513For Sale
MLS ID #1067783, John Simmons, C3 Real Estate Solutions, LLC. IRES as distributed by MLS GRID - $1,450,0005 bd5 ba5.7k sqft2532 S County Road 15, Berthoud, CO 80513For Sale
MLS ID #1063998, Ann Yuska, RE/MAX Nexus. IRES as distributed by MLS GRID - $1,700,0005 bd5 ba5.1k sqft2774 Heron Lakes Pkwy, Berthoud, CO 80513For Sale
MLS ID #1068063, Melissa Maersk-Moller, Luxury Homes LLC. IRES as distributed by MLS GRID - $2,950,0004 bd4 ba4.1k sqft2525 W County Road 4, Berthoud, CO 80513For Sale
MLS ID #1067434, John Herrity, Hayden Outdoors - Windsor. IRES as distributed by MLS GRID - $1,850,0003 bd3 ba3.3k sqft19858 County Road 1, Berthoud, CO 80513For SaleMLS ID #1052368, Cheryl Melichar, Coldwell Banker Realty-NOCO. IRES as distributed by MLS GRID
- $2,190,0005 bd4 ba5k sqft2626 Heron Lakes Pkwy, Berthoud, CO 80513For SaleMLS ID #1058413, Kelly Moye, Compass-Denver. IRES as distributed by MLS GRID
- $1,150,0003 bd2 ba3.5k sqft18080 County Road 1, Berthoud, CO 80513For SaleMLS ID #1058169, Greg Zadel, Zadel Realty. IRES as distributed by MLS GRID
- $2,350,0004 bd4 ba4.8k sqft2625 Heron Lakes Pkwy, Berthoud, CO 80513For SaleMLS ID #1061775, Liz Montoya, Realty One Group Fourpoints. IRES as distributed by MLS GRID
- $2,295,0004 bd4 ba6.2k sqft4980 Getaway Dr, Berthoud, CO 80513For SaleMLS ID #1061214, Ursula Albers, RE/MAX Alliance-Loveland. IRES as distributed by MLS GRID
- $2,550,0004 bd7 ba5.6k sqft2311 Sugarloaf Rd, Berthoud, CO 80513For SaleMLS ID #1067902, David Johnson, LIV Sotheby's Intl Realty D. IRES as distributed by MLS GRID
- $1,895,0005 bd5 ba5.3k sqft830 Berthoud Peak Dr, Berthoud, CO 80513For SaleMLS ID #1059516, Kassie Tipton, Dwellings Colorado Real Estate. IRES as distributed by MLS GRID
- $2,399,0003 bd4 ba3k sqft560 Talons Reach Run, Berthoud, CO 80513For SaleMLS ID #1054348, Lindsay Eisiminger, Resident Realty. IRES as distributed by MLS GRID
- $2,200,0004 bd3 ba4.9k sqft7182 Lakota Lakes Rd, Johnstown, CO 80534For SaleMLS ID #1066574, Jonathan Leifheit, C3 Real Estate Solutions, LLC. IRES as distributed by MLS GRID
- $1,300,0005 bd4 ba4.2k sqft3112 Megan Way, Berthoud, CO 80513For Sale
MLS ID #9395884, Randy Sons, US Realty Pros LLC. REcolorado as distributed by MLS GRID - $1,140,0004 bd3 ba2.4k sqft1212 Glenview Dr, Berthoud, CO 80513For SaleMLS ID #1063442, Ryan Harper, Epique Realty - Longmont. IRES as distributed by MLS GRID
- $1,350,0004 bd4 ba5.2k sqft1101 Shelby Dr, Berthoud, CO 80513For SaleMLS ID #1067007, Sheena Rosenquist, St Vrain Realty LLC. IRES as distributed by MLS GRID
- $1,450,0003 bd5 ba4.4k sqft4803 Malibu Drive, Berthoud, CO 80513New ConstructionMLS ID #8277263, Karlee Watts, eXp Realty, LLC. REcolorado as distributed by MLS GRID
- $2,095,0005 bd4 ba5.1k sqft740 W County Road 10 E, Berthoud, CO 80513For SaleMLS ID #1058565, Dennis Schick, RE/MAX Alliance-FTC South. IRES as distributed by MLS GRID
- $2,039,0006 bd7 ba5.9k sqft2782 Heron Lakes Pkwy, Berthoud, CO 80513For SaleMLS ID #1061374, Jason Filler, LIV Sotheby's Intl Realty. IRES as distributed by MLS GRID
- $2,800,0004 bd5 ba6.4k sqft3095 Heron Lakes Pkwy, Berthoud, CO 80513For SaleMLS ID #1067801, Chris Sturgeon, Live West Realty. IRES as distributed by MLS GRID
