Seller's Agent in 2024
CJ Sefcovic
C3 Real Estate Solutions, LLC
(719) 214-3442
90 Total Sales
12678 Shiloh Rd Greeley, CO 80631
Estimated Value: $2,123,462 - $2,298,000
5
Beds
4.5
Baths
5,435
Sq Ft
$404/Sq Ft
Est. Value
Highlights
- Lake Front
- Private Pool
- Open Floorplan
- Parking available for a boat
- Two Primary Bedrooms
- River Nearby
About This Home
As of September 2024Welcome to true luxury living & lake life! This superior lakefront estate is an exceedingly rare offering, located in beautiful Northern Colorado just minutes from downtown Windsor! This exquisite home sits on a sprawling 2.5 acre lot at the end of a cul-de-sac and backs to the exclusive Bracewell Lake. Enjoy your own private dock while indulging in all of your favorite water sports including skiing, surfing, jet skiing, paddle boarding, kayaking, and fishing. Unmatched mountain views of Longs Peak and the Front Range! This property boasts a 5 bedroom, 4.5 bath ranch style home with just over 5,400 finished sq ft. Inside you will find high end finishes including quartz counters, custom lighting fixtures, stained oak hardwood floors, stainless steel appliances, custom fireplaces & detailed tile work throughout the home. Stunning kitchen features quartz counters, stainless steel appliances including a double oven, 5 burner gas cooktop, white-wash soft close cabinets, undercabinet lighting, huge island with built in storage & additional baking/espresso bar area. Huge master suite features a 5-piece bath with heated floors, quartz counters, vanity with trough sink, custom tile shower, spacious tub & walk-in closet! Fully finished walk-out basement includes a full kitchen with stainless steel appliances, additional bedrooms, laundry area, flex room, theatre room and entertainment area. Main laundry features ample cabinet space and drop-in sink. Out back, you will find a covered outdoor kitchen space with granite counters, built in gas grill, mini refrigerator, storage, swim spa & multiple patios for relaxing around the fire pit or setting up games. Private beach with plenty of room for sand volleyball! Dock is set up for jet skis & ski boat! Detached garage/shop is perfect for storing all of your outdoor equipment and DIY projects! Space for boat & trailer storage on the property. A rare opportunity to own your very own motorized lakefront estate!
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,556
Year Built
- Built in 2006
Lot Details
- 2.49 Acre Lot
- Lake Front
- River Front
- Cul-De-Sac
- North Facing Home
- Partially Fenced Property
- Vinyl Fence
- Level Lot
- Sprinkler System
HOA Fees
- $358 Monthly HOA Fees
Parking
- 5 Car Attached Garage
- Heated Garage
- Driveway Level
- Parking available for a boat
Property Views
- Water
- Mountain
Home Design
- Contemporary Architecture
- Composition Roof
- Log Siding
Interior Spaces
- 5,435 Sq Ft Home
- 1-Story Property
- Open Floorplan
- Bar Fridge
- Ceiling height of 9 feet or more
- Multiple Fireplaces
- Gas Log Fireplace
- Bay Window
- Family Room
- Living Room with Fireplace
- Dining Room
- Home Office
- Recreation Room with Fireplace
Kitchen
- Eat-In Kitchen
- Double Oven
- Gas Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
Flooring
- Wood
- Carpet
Bedrooms and Bathrooms
- 5 Bedrooms
- Double Master Bedroom
- Walk-In Closet
- Primary bathroom on main floor
Laundry
- Laundry on main level
- Dryer
- Washer
Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Fireplace in Basement
Accessible Home Design
- Garage doors are at least 85 inches wide
- Accessible Doors
- Accessible Entrance
Pool
- Private Pool
- Spa
Outdoor Features
- River Nearby
- Deck
- Patio
- Outdoor Storage
Schools
- Range View Elementary School
- Severance Middle School
- Windsor High School
Utilities
- Forced Air Zoned Heating and Cooling System
- Septic System
Listing and Financial Details
- Assessor Parcel Number R3198904
Community Details
Overview
- Association fees include common amenities, management
- Bracewell At Shiloh Lake Subdivision
Recreation
- Park
- Hiking Trails
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Feb 6, 2025
Sold by
Covelli Chris A and Covelli Kathi
Bought by
Chris A Covelli Trust and Kathi Covelli Trust
Total Days on Market
116
Current Estimated Value
Purchase Details
Listed on
Jun 6, 2024
Closed on
Sep 30, 2024
Sold by
Mccauley Gail and Mccauley Monta
Bought by
Covelli Kathi and Covelli Chris
Seller's Agent
CJ Sefcovic
C3 Real Estate Solutions, LLC
Buyer's Agent
Raechel Drake
eXp Realty LLC
List Price
$2,195,000
Sold Price
$2,120,000
Premium/Discount to List
-$75,000
-3.42%
Views
66
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.68%
Purchase Details
Closed on
Feb 9, 2017
Sold by
Mccauley Gail and Mccauley Monta
Bought by
Mccauley Gail and Mccauley Monta
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
4.17%
Mortgage Type
New Conventional
Purchase Details
Listed on
Jul 24, 2015
Closed on
Aug 31, 2015
Sold by
Geiler David P and Geiler Nancy E
Bought by
Mccauley Gail and Mccauley Monta
Seller's Agent
Nancy Geiler
Boardwalk Real Estate Brokers
Buyer's Agent
Sherry Boersma
HomeSmart Realty Partners Lvld
List Price
$915,000
Sold Price
$915,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.51%
Original Mortgage
$915,000
Interest Rate
4.12%
Mortgage Type
Future Advance Clause Open End Mortgage
Purchase Details
Closed on
Aug 5, 2011
Sold by
Trucap Reo Corp
Bought by
Geiler David P and Geiler Nancy E
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
4.54%
Mortgage Type
New Conventional
Purchase Details
Closed on
Dec 20, 2010
Sold by
Trucap Grantor Trust 2010-2
Bought by
Trucap Reo Corp
Purchase Details
Closed on
Dec 6, 2010
Sold by
Leners Edward and Leners Debra
Bought by
Trucap Grantor Trust 2010-2
Purchase Details
Closed on
Nov 18, 2004
Sold by
Roberts William R and Roberts Dolores A
Bought by
Leners Edward and Leners Debra
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$172,500
Interest Rate
5.87%
Mortgage Type
Unknown
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
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Chris A Covelli Trust | -- | None Listed On Document | |
| Covelli Kathi | $2,120,000 | None Listed On Document | |
| Mccauley Gail | -- | None Available | |
| Mccauley Gail | $915,000 | Stewart Title | |
| Geiler David P | $525,000 | Cat | |
| Trucap Reo Corp | -- | None Available | |
| Trucap Grantor Trust 2010-2 | -- | None Available | |
| Leners Edward | $230,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Mccauley Gail | $250,000 | |
| Previous Owner | Mccauley Gail | $75,000 | |
| Previous Owner | Mccauley Gail | $915,000 | |
| Previous Owner | Geiler David P | $480,000 | |
| Previous Owner | Geiler David P | $75,000 | |
| Previous Owner | Geiler David P | $417,000 | |
| Previous Owner | Leners Edward | $956,250 | |
| Previous Owner | Leners Edward | $868,500 | |
| Previous Owner | Leners Edward | $172,500 | |
| Closed | Leners Edward | $57,500 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 09/30/2024 09/30/24 | Sold | $2,120,000 | -2.3% | $390 / Sq Ft |
| 07/15/2024 07/15/24 | Price Changed | $2,170,000 | -1.1% | $399 / Sq Ft |
| 06/06/2024 06/06/24 | For Sale | $2,195,000 | +139.9% | $404 / Sq Ft |
| 01/28/2019 01/28/19 | Off Market | $915,000 | -- | -- |
| 08/31/2015 08/31/15 | Sold | $915,000 | 0.0% | $169 / Sq Ft |
| 08/01/2015 08/01/15 | Pending | -- | -- | -- |
| 07/24/2015 07/24/15 | For Sale | $915,000 | -- | $169 / Sq Ft |
Source: IRES MLS
Tax History Compared to Growth
Tax History
| 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 |
|---|---|---|---|---|
| 2024 | $6,556 | $90,010 | $14,850 | $75,160 |
| 2023 | $6,556 | $90,880 | $14,990 | $75,890 |
| 2022 | $6,829 | $79,930 | $13,820 | $66,110 |
| 2021 | $6,274 | $82,230 | $14,220 | $68,010 |
| 2020 | $5,478 | $73,420 | $11,010 | $62,410 |
| 2019 | $5,422 | $73,420 | $11,010 | $62,410 |
| 2018 | $5,185 | $65,880 | $16,560 | $49,320 |
| 2017 | $5,533 | $65,880 | $16,560 | $49,320 |
| 2016 | $4,826 | $58,110 | $21,890 | $36,220 |
| 2015 | $4,441 | $58,110 | $21,890 | $36,220 |
| 2014 | $4,474 | $54,370 | $11,940 | $42,430 |
Source: Public Records
Agents Affiliated with this Home
-
CJ Sefcovic
-
Raechel Drake
Buyer's Agent in 2024
Raechel Drake
eXp Realty LLC
(970) 381-1768
48 Total Sales
-
Nancy Geiler
Seller's Agent in 2015
Nancy Geiler
Boardwalk Real Estate Brokers
(970) 800-1905
25 Total Sales
-
Sherry Boersma
Buyer's Agent in 2015
Sherry Boersma
HomeSmart Realty Partners Lvld
(970) 412-2297
13 Total Sales
Map
Similar Home in Greeley, CO
Source: IRES MLS
MLS Number: 1011340
APN: R3198904
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.
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.
Nearby Homes
- 12690 Shiloh Rd
- 8217 River Run Dr
- 8101 River Run Dr
- 8158 Eagle Dr
- 616 Riverside Ct
- 32799 County Road 27
- 407 Double Tree Dr
- 403 Double Tree Dr
- 7704 Poudre River Rd
- 31496 County Road 29
- 12902 Highway 392
- 7306 Poudre Vista Dr
- 33062 County Road 25
- 6929 Poudre River Rd Unit 2
- 0 Tbd County Road 25
- 8506 7th St Rd
- 603 97th Ave
- 607 97th Ave
- 610 97th Ave
- 614 97th Ave