BEDS4
BATHS3 full 2 partial
SQUARE FEET4,892
MLS#5474734
STATUSActive
PROPERTY TYPEResidential - Single Family
SUBDIVISIONBerthoud
SCHOOLSt Vrain Valley RE-1J
Listing Courtesy of:
Redfin Corporation
Agency Contact: matt.purdy@redfin.com,970-347-9387
Property Description
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 chefs 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!
Property Features
Property Type: Residential - Single Family
Basement: Daylight, Finished, Interior Entry, Sump Pump, Walk-Out Access
Cooling: Central Air
Fireplaces: 1
Garage: 5 car attached
Heating: Forced Air, Propane
Home Style: Mountain Contemporary
Lot Size: 8.80 Acres
Roof Type: Shingle
Stories: 1.0
Taxes: $1,699
Year Built: 2026
Amenities
Ceiling Fan(s)
Entrance Foyer
Granite Counters
High Ceilings
Kitchen Island
Open Floorplan
Pantry
Primary Suite
Quartz Counters
Radon Mitigation System
Sauna
Smart Thermostat
Smart Window Coverings
Smoke Free
Solid Surface Counters
Walk-In Closet(s)
Wet Bar
Wired for Data
Gas Valve
Lighting
Rain Gutters
Feature Descriptions
Appliances: Bar Fridge, Convection Oven, Cooktop, Dishwasher, Disposal, Humidifier, Microwave, Range, Range Hood, Refrigerator, Self Cleaning Oven, Sump Pump, Tankless Water Heater
Baths 3/4: 2
Baths Full: 1
Baths Half: 2
Baths Total: 5
Days on Site: 17
Exclusions: Sellers Personal Property
Exterior: Frame, Wood Siding
Fencing: None
Fireplace: Circulating, Gas, Gas Log, Living Room
Flooring: Carpet, Laminate, Wood
Lot: Meadow, Open Space, Secluded, Suitable For Grazing
Parcel#: R8979741
Parking: 220 Volts, Circular Driveway, Gravel, Dry Walled, Exterior Access Door, Heated Garage, Insulated Garage, Lighted, Oversized
Parking Notes: 220 Volts, Circular Driveway, Gravel, Dry Walled, Exte
Patio/Porch: Covered, Deck, Front Porch, Patio
Sauna: Yes
Security: Carbon Monoxide Detector(s), Smart Cameras, Smoke Detector(s), Video Doorbell, Water Leak/Flood Alarm
Sewer: Septic Tank
Special View Info: Meadow, Mountain(s), Water
Utilities: Electricity Connected, Propane
Water: Public
Window: Double Pane Windows, Window Coverings, Window Treatments
Local Schools
High School: Mead
Middle School: Mead
Elementary School: Mead
School District: St Vrain Valley RE-1J
Listed By / Shown By
Listed By
Agency Name: Redfin Corporation
Agency Contact: matt.purdy@redfin.com,970-347-9387
Shown By
Agent Name: Tias (Ty) Hecht
Agent Phone: (719) 332-0433
Agency Title: The Cutting Edge, Realtors
Estimate Your Payment
Estimated Payment
$ 11,619.87 per month $10,836.62 Principal & Interest $141.58 Property Tax $641.67 Homeowner's InsuranceChange Payment Information
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information
METROLIST, INC., DBA RECOLORADO Disclaimer & Copyrights
The content relating to real estate for sale in this website comes in part from the Internet Data eXchange ("IDX") program of REcolorado®. All information subject to change and should be independently verified. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose.
This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought. The information contained in this publication is subject to change without notice. METROLIST, INC., DBA REcolorado, MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA REcolorado, SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.
PUBLISHER'S NOTICE: All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.
METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.
COPYRIGHT © 2020 by METROLIST, INC., DBA RECOLORADO® – All Rights Reserved 6455 S. Yosemite St., Suite 500 Greenwood Village, CO 80111 USA
ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.
The data relating to real estate for sale on this web site comes in part from the REcolorado®. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) nor shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
17895 County Road 3 | MLS# 5474734
This single family home located at 17895 County Road 3, Berthoud, CO 80513 is currently listed for sale with an asking price of $2,200,000. This property was built in 2026 and has 4 bedrooms and 3 full and 2 partial baths with 4892 sq. ft. County Road 3 is located in the Berthoud subdivision within the St Vrain Valley RE-1J school district. Search Berthoud real estate on tyhecht.thecuttingedgerealtors.com today.