12690 Shiloh Rd

9,022 Sq. Ft.
$421 / Sq. Ft.
9,022
Sq. Ft.
$421
per Sq. Ft.

Description

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...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.
  1. Listed by Ryan Andre • Sears Real Estate
    P: (970)-381-1081 C: (970)-381-1081 randre@searsrealestate.com

Property Details for 12690 Shiloh Road

Locale
Greeley
Description 1
House
LISTING UPDATED: 04/25/2026 04:16 AM

Property Details for 12690 Shiloh Road

StatusSold
MLS #1021712
Days on Compass176
Taxes$9,153 / year
HOA Fees$4,300 / year
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built2009
Lot Size2.53 AC / 110,206 SF
CountyWeld County

Location

Listing Courtesy of Sears Real Estate, Ryan Andre

Sold By MB/Brazelton Realty Inc, Kendal Brazelton

Add your commute

Building Information for 12690 Shiloh Road

Stories-Year Built2009Building Size-Lot Size2.53 AC / 110,206 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$20,057 per month

30 year fixed, 6.36% Interest

Principal and Interest

$18,936

Property Taxes

$763

HOA Dues

$358

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 12690 Shiloh Road

Summary
Location and General Information
  • Road Access 2: City Street, Privately Maintained
  • Latitude: 40.46
  • Longitude: -104.82
Parking
  • Garage SqFt: 2928
  • Total Parking: 11.00
  • Parking Features: RV Access/Parking, Attached
Taxes and HOA Information
  • Fee Includes: Reserves
  • Has HOA: Yes
  • HOA Fee: $4,300.00
  • Legal Description: Lot 4, BRACEWELL P.U.D.
  • Tax Information: No
  • Has HOA 2: No
  • HOA2 Fee Amount: $0
  • Tax Year: 2023
  • Association Fee Frequency: Annually
  • Has HOA Covenants: Yes
  • HOA Transfer Fee: Yes
  • HOA 2 Transfer Fee: No
  • Association Name: Bracewell
  • Association Phone: 970-515-5004
  • Has Association Fee: Yes
  • Has Association 2 Fee: No
  • Has Association Reserve: Yes
  • Has Association 2 Reserve: No
  • Tax Annual Amount: $9,153
  • Parcel Number: R3199204
Property
Lot Information
  • Lot Improvements: Corner Lot, Wooded, Deciduous Trees, Abuts Pond/Lake, House Faces North, House/Lot Faces NE, Lake Access, Lake Front, Waterfront, Paved, Fire Hydrant within 500 Feet, Mineral Rights Excluded
  • Lot Size Area: 110,199.00
  • Has Irrigation Water Rights: No
  • Has Improvements: No
  • Vegetation: Wooded
Property and Assessments
  • Total Finished Area Source: Assessor
  • Living SqFt: 5476
  • Above Grade Finished Area Source: 5476
  • Sq Ft Apx: 3546
  • Total Finished Area: 8900
  • Property Attached YN: No
  • Are Ditches Active: No
  • New Construction YN: No
  • Levels: One
Utilities
  • Electric: XCEL
  • Sewer: Public Sewer
Interior and Exterior Features
Exterior Features
  • Construction Materials: Stone, Stucco
  • Exterior Features: Sprinkler System, Balcony, >8' Garage Door, Heated Garage, Oversized Garage, Tandem Garage, Carriage House
  • Flooring: Wood
Interior Features
  • Interior Features: Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-In Closet(s), Washer/Dryer Hookup, Kitchen Island, Theatre Room, Luxury Features Primary Bath, 5 Piece Primary Bath
  • Laundry Features: Gas Range, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal, Fire Alarm, Sink
  • Window Features: Window Coverings
  • Fireplaces 1: Gas, Living Room
  • All Bedrooms Conform: Yes
  • Full Bathrooms: 4
  • Half Bathrooms: 3
  • Rough-in Bathrooms: 0
  • Three Quarters Bathrooms: 2
  • Baths Full Additional: 1
  • Baths Full Basement: 1
  • Baths Full Upper: 0
  • Baths Full Main: 2
  • Baths Full Lower: 0
  • Baths Half Additional: 1
  • Baths Half Basement: 0
  • Baths Half Upper: 0
  • Baths Half Main: 2
  • Baths Half Lower: 0
  • Baths Three Quarters Additional: 0
  • Baths Three Quarters Basement: 2
  • Baths Three Quarters Lower: 0
  • Baths Three Quarters Upper: 0
  • Baths Three Quarters Main: 0
Room Information
Room 1
  • RoomDescription: Carpet
  • RoomLength: 13.0
  • RoomLevel: Main
  • RoomType: Bedroom 2
  • RoomWidth: 14.0
Room 2
  • RoomDescription: Carpet
  • RoomLength: 17.0
  • RoomLevel: Basement
  • RoomType: Bedroom 3
  • RoomWidth: 15.0
Room 3
  • RoomDescription: Carpet
  • RoomLength: 15.0
  • RoomLevel: Basement
  • RoomType: Bedroom 4
  • RoomWidth: 14.0
Room 4
  • RoomDescription: Tile
  • RoomLength: 13.0
  • RoomLevel: Main
  • RoomType: Dining Room
  • RoomWidth: 15.0
Room 5
  • RoomDescription: Engineered Hardwood
  • RoomLength: 28.0
  • RoomLevel: Basement
  • RoomType: Family Room
  • RoomWidth: 28.0
Room 6
  • RoomDescription: Engineered Hardwood
  • RoomLength: 24.0
  • RoomLevel: Main
  • RoomType: Kitchen
  • RoomWidth: 16.0
Room 7
  • RoomDescription: Tile
  • RoomLength: 20.0
  • RoomLevel: Main
  • RoomType: Laundry
  • RoomWidth: 9.0
Room 8
  • RoomDescription: Engineered Hardwood
  • RoomLength: 20.0
  • RoomLevel: Main
  • RoomType: Living Room
  • RoomWidth: 20.0
Room 9
  • RoomDescription: Engineered Hardwood
  • RoomLength: 25.0
  • RoomLevel: Main
  • RoomType: Primary Bedroom
  • RoomWidth: 17.0
  • Room Features: Luxury Features Primary Bath, 5 Piece Primary Bath
Room 10
  • RoomDescription: Engineered Hardwood
  • RoomLength: 16.0
  • RoomLevel: Basement
  • RoomType: Recreation Room
  • RoomWidth: 16.0
Room 11
  • RoomDescription: Engineered Hardwood
  • RoomLength: 13.0
  • RoomLevel: Main
  • RoomType: Study
  • RoomWidth: 13.0
Rental
Rental Information
  • Horse YN: No
  • Occupant Type: Owner

Property History for 12690 Shiloh Road

DateEvent & SourcePriceAppreciation
Apr 25, 2025

Sold (Public Record)

Public Record #1556130095

$3,800,000

+11.1% / yr

Oct 27, 2015

Sold (Public Record)

Public Record #558557009

$1,399,000

+14.4% / yr

Mar 4, 2011

Sold (Public Record)

Public Record #304996999

$750,000—
DateEvent & SourcePrice
04/25/2025

Sold (Public Record)

Public Record #1556130095

$3,800,000

+11.1% / yr

10/27/2015

Sold (Public Record)

Public Record #558557009

$1,399,000

+14.4% / yr

03/04/2011

Sold (Public Record)

Public Record #304996999

$750,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 12690 Shiloh Road

Taxable ValueLand$15,720Additions$127,670Total$143,390
Tax Record2025$12,673 ($1,056 / month)
Home Facts
Beds4Total Finished SqFt6,141 SqFtAbove Grade Finished SqFt3,371 SqFtFinished Basement SqFt2,770 SqFtUnfinished Basement SqFt3,546 SqFtStories1Lot Size110,207 SqFtStyleSingle Family ResidenceYear Built2006Year Renovated2017CountyWELDAPNR3199204

Schools near 12690 Shiloh Road

This home is within Weld County Reorganized School District No. Re-4.
Rating
School
Type
Grades
Distance
Public - PK to 2
Public - 3 to 5
Public - 6 to 8
Public - 9 to 12
Rating
School
Distance
Tozer Elementary School
PublicPK to 2

Mountain View Elementary School
Public3 to 5

Severance Middle School
Public6 to 8

Windsor High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Sears Real Estate, Ryan Andre

Based on information submitted to the MLS GRID as of 04/25/2026 04:16 AM. 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. Properties displayed may be listed or sold by various participants in the MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed by MLS GRID. Use of the MLS GRID data may be subject to an end user license agreement prescribed by the applicable MLS of the Member Participant, if any, and as amended from time to time.