Seller's Agent in 2025
Ryan Andre
Sears Real Estate
(970) 381-1081
203 Total Sales
12690 Shiloh Rd Greeley, CO 80631
Estimated Value: $3,330,000 - $3,931,000
5
Beds
9
Baths
9,022
Sq Ft
$407/Sq Ft
Est. Value
Highlights
- Lake Front
- RV Access or Parking
- Deck
- Home Theater
- Open Floorplan
- Contemporary Architecture
About This Home
As of April 2025Presenting 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.
Last Agent to Sell the Property
Sears Real Estate Brokerage Phone: 9703307700 License #40014705 Listed on: 11/01/2024
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $9,153
Year Built
- Built in 2009
Lot Details
- 2.53 Acre Lot
- Lake Front
- North Facing Home
- Partially Fenced Property
- Vinyl Fence
- Corner Lot
- Paved or Partially Paved Lot
- Sprinkler System
- Wooded Lot
- Landscaped with Trees
HOA Fees
- $358 Monthly HOA Fees
Parking
- 11 Car Attached Garage
- Heated Garage
- Tandem Garage
- RV Access or Parking
Property Views
- Water
- Mountain
- Hills
Home Design
- Contemporary Architecture
- Metal Roof
- Stucco
- Stone
Interior Spaces
- 9,022 Sq Ft Home
- 1-Story Property
- Open Floorplan
- Bar Fridge
- Cathedral Ceiling
- Ceiling Fan
- Gas Fireplace
- Window Treatments
- Family Room
- Living Room with Fireplace
- Dining Room
- Home Theater
- Media Room
- Recreation Room
- Wood Flooring
- Fire and Smoke Detector
Kitchen
- Double Self-Cleaning Oven
- Gas Range
- Microwave
- Dishwasher
- Kitchen Island
- Disposal
Bedrooms and Bathrooms
- 5 Bedrooms
- Walk-In Closet
- Primary bathroom on main floor
Laundry
- Laundry Room
- Laundry on main level
- Sink Near Laundry
- Washer and Dryer Hookup
Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
Outdoor Features
- Access To Lake
- Balcony
- Deck
- Patio
- Outdoor Storage
Location
- Mineral Rights Excluded
Schools
- Mountain View Elementary School
- Severance Middle School
- Severance High School
Utilities
- Forced Air Heating and Cooling System
- Cable TV Available
Listing and Financial Details
- Assessor Parcel Number R3199204
Community Details
Overview
- Bracewell Association, Phone Number (970) 515-5004
- Built by Steve Doerschlag
- Bracewell Subdivision, Remodeled 2017 Floorplan
Recreation
- Park
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Nov 1, 2024
Closed on
Apr 25, 2025
Sold by
Bought by
Seller's Agent
Ryan Andre
Sears Real Estate
Buyer's Agent
Kendal Brazelton
MB/Brazelton Realty Inc
List Price
$3,900,000
Sold Price
$3,800,000
Premium/Discount to List
-$100,000
-2.56%
Views
198
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$124,187
Avg. Annual Appreciation
-2.80%
Purchase Details
Closed on
Oct 31, 2023
Sold by
Bought by
Purchase Details
Closed on
Oct 27, 2015
Sold by
Bought by
Purchase Details
Closed on
May 2, 2013
Sold by
Bought by
Purchase Details
Closed on
May 1, 2011
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$275,000
Interest Rate
4.73%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 4, 2011
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$275,000
Interest Rate
4.73%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 18, 2005
Sold by
Bought by
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $3,800,000 | Stewart Title | ||
| -- | None Listed On Document | ||
| $1,399,000 | Unified Title Company | ||
| -- | None Available | ||
| -- | None Available | ||
| $750,000 | Stewart Title | ||
| -- | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | $275,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 04/25/2025 04/25/25 | Sold | $3,800,000 | -2.6% | $421 / Sq Ft |
| 03/31/2025 03/31/25 | For Sale | $3,900,000 | 0.0% | $432 / Sq Ft |
| 03/31/2025 03/31/25 | Off Market | $3,900,000 | -- | -- |
| 11/01/2024 11/01/24 | For Sale | $3,900,000 | -- | $432 / Sq Ft |
Source: IRES MLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2026 | $12,673 | $175,810 | $16,650 | $159,160 |
| 2025 | $10,957 | $143,390 | $15,720 | $127,670 |
| 2024 | $10,957 | $143,390 | $15,720 | $127,670 |
| 2023 | $9,932 | $135,770 | $15,090 | $120,680 |
| 2022 | $9,153 | $107,130 | $13,910 | $93,220 |
| 2021 | $8,409 | $110,210 | $14,310 | $95,900 |
| 2020 | $8,611 | $115,420 | $11,100 | $104,320 |
| 2019 | $8,523 | $115,420 | $11,100 | $104,320 |
| 2018 | $7,712 | $98,000 | $16,560 | $81,440 |
| 2017 | $8,231 | $98,000 | $16,560 | $81,440 |
| 2016 | $6,511 | $78,410 | $21,890 | $56,520 |
| 2015 | $5,992 | $78,410 | $21,890 | $56,520 |
| 2014 | $5,207 | $63,270 | $11,940 | $51,330 |
Source: Public Records
Agents Affiliated with this Home
-
Ryan Andre
-
Kendal Brazelton
K
Buyer's Agent in 2025
Kendal Brazelton
MB/Brazelton Realty Inc
(970) 302-0480
37 Total Sales
Map
Source: IRES MLS
MLS Number: IRE1021712
APN: R3199204
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
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. Some IDX listings have been excluded from this website. Listing 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.
Information deemed reliable but not guaranteed by the MLS.
Based on information submitted to the MLS GRID
Listings courtesy of IRES MLS as distributed by MLS GRID
Nearby Homes
- 0 County Road 66 Unit IRE1057632
- 8205 River Run Dr
- 8209 Surrey St
- 7902 River Run Dr
- 8206 Surrey St
- 31793 County Road 29
- 403 Double Tree Dr
- 419 N Brisbane Ave
- 7226 W Canberra St
- 7163 W Canberra St
- 7141 W Canberra St
- 8507 5th St
- 8519 5th St
- 8527 5th St
- 8601 5th St
- 504 85th Avenue Ct
- 507 85th Ave Ct
- 507 85th Avenue Ct
- 508 85th Ave
- 509 85th Ave
- 12686 Shiloh Rd
- 12694 Shiloh Rd
- 12801 County Road 64 1/2
- 12799 County Road 64 1/2
- 12682 Shiloh Rd
- 12691 County Road 64 1/2
- 12698 Shiloh Rd
- 12702 Shiloh Rd
- 12681 County Road 64 1/2
- 12678 Shilo Rd
- 12678 Shiloh Rd
- 31552 County Road 27
- 31535 County Road 27
- 12706 Shiloh Rd
- 12598 County Road 64 1/2
- 12710 Shiloh Rd
- 12714 Shiloh Rd
- 12549 County Road 64 1/2
- 13006 County Road 66
- 0 County Road 64 1 2
Your Personal Tour Guide
Ask me questions while you tour the home.