Presenting a truly exceptional property that offers a luxurious indoor & outdoor living experience. This exclusive Northern Colorado lakefront estate sits on 2.5 acres with one amazing location to enjoy all your favorite water sports including skiing, surfing, fishing, jet skiing, paddle boarding or kayaking. This stunning property boasts an impressive 5 bedrooms, 9 bathrooms, providing ample space for a large household or for those who enjoy entertaining guests. With a generous 6,900 square feet in the main house & 2,100 in the sports garage, every room on this property is designed to offer comfort & elegance. Inside you will find clean architectural lines, soft colors with beautiful finishes. The living room serves as the centerpiece of the home, with its floor to ceiling fireplace, high vaulted ceilings, & picturesque windows. The kitchen is a chef's delight, equipped with built-in high-end cabinet appliances, 2 spacious islands, exquisite leathered granite counters, espresso bar & walk in pantry. The dining area offers a sophisticated space with its backlit ceiling, separate sitting area, & abundance of natural light. The bedrooms in this home are designed with luxury in mind, each offering its own unique charm. The bathrooms are elegantly appointed, with custom tile, upgraded sinks, & high-end fixtures. The basement has everything one could ask for to entertain. Spacious & open living room w/ a custom wet bar, a dedicated workout area w/ a sauna, a movie room & game area. The last outstanding feature of this property is the custom-built sports garage. It comes with a basketball court, living room, dining area, kitchen, loft, bedroom, washer & dryer. For car lovers you will find over 10 usable garage spaces on the property with epoxy flooring. Eight of the garage spaces are heated & cooled with water & drains. Don't miss this opportunity to purchase one of Northern Colorado's most exclusive properties. Sqft listed as Upper Measurements are in the Sports Garage.
Sold for $3,800,000
$3,800,000
12690 Shiloh Rd, Greeley, CO 80631
5beds
9,022sqft
Single Family Residence
Built in 2009
2.53 Acres Lot
$3,725,000 Zestimate®
$421/sqft
$4,337 Estimated rent
Home value
$3,725,000
$3.54M - $3.95M
$4,337/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$4,337/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$4,337/mo
Rent Zestimate®
Refinance and save
$26,311/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$26,311/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: 7 hours ago
Listing updated: October 20, 2025 at 06:55pm
Listed by:
Ryan Andre 9703307700,
Sears Real Estate
Bought with:
Kendal Brazelton, 40018669
MB/Brazelton Realty Inc
Source: IRES as distributed by MLS GRID,MLS#: 1021712
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 9
- Full bathrooms: 4
- 3/4 bathrooms: 2
- 1/2 bathrooms: 3
- Main level bathrooms: 4
Primary bedroom
- Description: Engineered Hardwood
- Features: Luxury Features Primary Bath, 5 Piece Primary Bath
- Level: Main
- Area: 425 Square Feet
- Dimensions: 17 x 25
Bedroom 2
- Description: Carpet
- Level: Main
- Area: 182 Square Feet
- Dimensions: 14 x 13
Bedroom 3
- Description: Carpet
- Level: Basement
- Area: 255 Square Feet
- Dimensions: 15 x 17
Bedroom 4
- Description: Carpet
- Level: Basement
- Area: 210 Square Feet
- Dimensions: 14 x 15
Dining room
- Description: Tile
- Level: Main
- Area: 195 Square Feet
- Dimensions: 15 x 13
Family room
- Description: Engineered Hardwood
- Level: Basement
- Area: 784 Square Feet
- Dimensions: 28 x 28
Kitchen
- Description: Engineered Hardwood
- Level: Main
- Area: 384 Square Feet
- Dimensions: 16 x 24
Laundry
- Description: Tile
- Level: Main
- Area: 180 Square Feet
- Dimensions: 9 x 20
Living room
- Description: Engineered Hardwood
- Level: Main
- Area: 400 Square Feet
- Dimensions: 20 x 20
Recreation room
- Description: Engineered Hardwood
- Level: Basement
- Area: 256 Square Feet
- Dimensions: 16 x 16
Study
- Description: Engineered Hardwood
- Level: Main
- Area: 169 Square Feet
- Dimensions: 13 x 13
Heating
- Forced Air, 2 or more Heat Sources
Cooling
- Ceiling Fan(s)
Appliances
- Included: Gas Range, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
- Laundry: Sink, Washer/Dryer Hookup
Features
- Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, Theatre Room
- Flooring: Wood
- Windows: Window Coverings
- Basement: Full,Partially Finished,Walk-Out Access
- Has fireplace: Yes
- Fireplace features: Gas, Living Room
Interior area
- Total structure area: 9,022
- Total interior livable area: 9,022 sqft
- Finished area above ground: 5,476
- Finished area below ground: 3,546
Property
Parking
- Total spaces: 11
- Parking features: RV Access/Parking, >8' Garage Door, Heated Garage, Oversized, Tandem
- Attached garage spaces: 11
- Details: Attached
Accessibility
- Accessibility features: Main Floor Bath, Accessible Bedroom, Main Level Laundry
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System, Balcony
- Fencing: Partial,Vinyl
- Has view: Yes
- View description: Mountain(s), Hills, Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Abuts Pond/Lake, Lake Privileges, Lake Front, Waterfront
Lot
- Size: 2.53 Acres
- Features: Corner Lot, Wooded, Deciduous Trees, Waterfront, Paved, Fire Hydrant within 500 Feet, Mineral Rights Excluded
Details
- Additional structures: Storage, Carriage House
- Parcel number: R3199204
- Zoning: Res
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Stone, Stucco
- Roof: Metal
Condition
- New construction: No
- Year built: 2009
Details
- Builder model: Remodeled 2017
- Builder name: Steve Doerschlag
Utilities & green energy
- Electric: XCEL
- Gas: ATMOS
- Sewer: Public Sewer
- Water: District
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available, High Speed Avail
Community & neighborhood
Security
- Security features: Fire Alarm
Community
- Community features: Park
Location
- Region: Greeley
- Subdivision: Bracewell
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $4,300 annually
- Association name: Bracewell
- Association phone: 970-515-5004
Other
Other facts
- Listing terms: Cash,Conventional,FHA,VA Loan
- Road surface type: Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 4/25/2025 | Sold | $3,800,000-2.6%$421/sqft |
Source:  IRES as distributed by MLS GRID #1021712 Report a problem | ||
| 3/31/2025 | Pending sale | $3,900,000$432/sqft |
Source:  REcolorado as distributed by MLS GRID #IR1021712 Report a problem | ||
| 3/31/2025 | Listed for sale | $3,900,000$432/sqft |
Source: IRES as distributed by MLS GRID #1021712 Report a problem | ||
| 3/22/2025 | Pending sale | $3,900,000$432/sqft |
Source: REcolorado as distributed by MLS GRID #IR1021712 Report a problem | ||
| 11/2/2024 | Listed for sale | $3,900,000$432/sqft |
Source: IRES as distributed by MLS GRID #1021712 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $10,957 +10.3% | $143,390 +6.6% |
| 2024 | $9,932 +8.5% | $134,460 -1% |
| 2023 | $9,153 +8.8% | $135,770 +26.7% |
Find assessor info on the county website
Neighborhood: 80631
Nearby schools
GreatSchools rating
- 7/10Mountain View Elementary SchoolGrades: 3-5Distance: 4.6 mi
- 5/10Severance Middle SchoolGrades: 6-8Distance: 3.9 mi
- 6/10Severance High SchoolGrades: 9-12Distance: 3.7 mi
Schools provided by the listing agent
- Elementary: Mountain View
- Middle: Severance
- High: Severance High School
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
$3,725,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
$3,725,000
- Colorado
- Weld County
- Greeley
- 80631
- 12690 Shiloh Rd