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.
Single-familyProperty Type
2009Year Built
2.53 acresLot Size
$338Est. Price/Sq.Ft.
11 car garageParking
Listed by Ryan Andre• Sears Real Estate
Contact: 9703307700
Bought with Kendal Brazelton• MB/Brazelton Realty Inc
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.
IRES as Distributed by MLS Grid #1010735
Oct 23, 2024
Listing Removed
—
Aug 15, 2024
Contingent
—
May 29, 2024
Listed
$3,900,000
$432/sq ft
Public Records
Oct 27, 2015
Sold
$1,399,000
$155/sq ft
IRES as Distributed by MLS Grid #644501
Mar 4, 2011
Sold
$750,000
$83/sq ft
Mar 3, 2011
Listing Removed
—
Dec 15, 2010
Listed
$1,125,000
$125/sq ft
IRES as Distributed by MLS Grid #587890
Dec 15, 2010
Listing Removed
—
Dec 14, 2010
Listed
$1,225,000
$136/sq ft
IRES as Distributed by MLS Grid #536350
Nov 10, 2008
Listing Removed
—
Jun 15, 2007
Listed
$2,000,000
$222/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$12,673 (+15.7%)
$15,720 + $127,670
$143,390
2024
$10,957 (+10.3%)
$15,720 + $127,670
$143,390
2023
$9,932 (+8.5%)
$14,940 + $119,520
$134,460
2022
$9,153 (+8.8%)
$13,910 + $93,220
$107,130
2021
$8,409 (−2.3%)
$13,910 + $93,220
$107,130
2020
$8,611 (+1.0%)
$14,310 + $95,900
$110,210
2019
$8,523 (+10.5%)
$11,100 + $104,320
$115,420
2018
$7,712 (−6.3%)
$11,100 + $104,320
$115,420
2017
$8,231 (+26.4%)
$16,560 + $81,440
$98,000
2016
$6,511 (+25.1%)
$16,560 + $81,440
$98,000
2014
$5,206 (−1.5%)
$21,890 + $56,520
$78,410
2013
$5,283 (−8.4%)
$11,940 + $51,330
$63,270
2012
$5,766 (−1.2%)
$13,530 + $55,080
$68,610
2011
$5,838 (−12.9%)
$13,530 + $55,080
$68,610
2010
$6,701 (+4.2%)
$17,910 + $61,390
$79,300
2009
$6,434
$17,910 + $61,390
$79,300
Tax history for 12690 Shiloh Rd
Year
Property tax
Land + Additions
Assessment*
2025
$12,673 (+15.7%)
$15,720 + $127,670
$143,390
2024
$10,957 (+10.3%)
$15,720 + $127,670
$143,390
2023
$9,932 (+8.5%)
$14,940 + $119,520
$134,460
2022
$9,153 (+8.8%)
$13,910 + $93,220
$107,130
2021
$8,409 (−2.3%)
$13,910 + $93,220
$107,130
2020
$8,611 (+1.0%)
$14,310 + $95,900
$110,210
2019
$8,523 (+10.5%)
$11,100 + $104,320
$115,420
2018
$7,712 (−6.3%)
$11,100 + $104,320
$115,420
2017
$8,231 (+26.4%)
$16,560 + $81,440
$98,000
2016
$6,511 (+25.1%)
$16,560 + $81,440
$98,000
2014
$5,206 (−1.5%)
$21,890 + $56,520
$78,410
2013
$5,283 (−8.4%)
$11,940 + $51,330
$63,270
2012
$5,766 (−1.2%)
$13,530 + $55,080
$68,610
2011
$5,838 (−12.9%)
$13,530 + $55,080
$68,610
2010
$6,701 (+4.2%)
$17,910 + $61,390
$79,300
2009
$6,434
$17,910 + $61,390
$79,300
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Permits
Beds
4
Baths
6
Stories
1
Lot width
—
Lot depth
—
Lot size
2.53 Acres
Year renovated
—
Sq. Ft.
6,141
Year built
2006
Style
Single Family Residential
County
Weld County
APN
R3199204
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 31, 2026.
Feb 17, 2022 • Final
Accessory structure new construction
Construct a two-story detached wood frame sports barn on a slab foundation. The building includes a basketball court, billiards area, loft, bathrooms, and a covered patio with utility connections. No living quarters are included in the structure.
ADU
Bathroom
Electrical
Plumbing
Sep 24, 2020 • Final
Residential alteration
Replace the roof on an attached porch of a residential building due to wind damage. Electrical work is included.
Electrical
Roofing
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking/Garage Information
Parking Total: 11
Garage Spaces: 11
AttachedGarageYN: Yes
Parking Features: Heated Garage, Oversized, Oversized Door, RV Access/Parking, Tandem
Interior
Bedroom Information
Bedrooms Total: 5
Main Level Bedrooms: 2
Basement Level Bedrooms: 2
Bathroom Information
Bathrooms Total Integer: 9
Bathrooms Full: 4
Bathrooms Three Quarter: 2
Bathrooms Half: 3
Main Level Bathrooms: 4
Basement Level Bathrooms: 3
Room 1 Information
Bedroom
Description: Carpet
Length: 15
Width: 14
Level: Basement
Room 2 Information
Bedroom
Length: 25
Width: 17
Level: Main
Features: Primary Suite
Room 3 Information
Bedroom
Description: Carpet
Length: 13
Width: 14
Level: Main
Room 4 Information
Bedroom
Description: Carpet
Length: 17
Width: 15
Level: Basement
Room 5 Information
Dining Room
Description: Tile
Length: 13
Width: 15
Level: Main
Room 6 Information
Kitchen
Length: 24
Width: 16
Level: Main
Room 7 Information
Living Room
Length: 20
Width: 20
Level: Main
Room 8 Information
Game Room
Length: 16
Width: 16
Level: Basement
Room 9 Information
Office
Length: 13
Width: 13
Level: Main
Room 10 Information
Laundry
Description: Tile
Length: 20
Width: 9
Level: Main
Room 11 Information
Bathroom Full
Level: Main
Features: Primary Suite
Room 12 Information
Bathroom Full
Level: Main
Room 13 Information
Bathroom Full
Level: Basement
Room 14 Information
Family Room
Length: 28
Width: 28
Level: Basement
Room 15 Information
Bathroom Half
Level: Main
Room 16 Information
Bathroom Half
Level: Main
Room 17 Information
Bathroom Three Quarter
Level: Basement
Room 18 Information
Bathroom Three Quarter
Level: Basement
Interior Features
Interior Features: Five Piece Bath,Kitchen Island,Open Floorplan,Pantry,Vaulted Ceiling(s),Walk-In Closet(s)