$3,900,000
Beds: 5
Baths: 4 full, 3 half
Sqft: 8,900
Sqft lot: 110,199
Acre lot: 2.53
Just Listed -

Courtesy of Ryan Andre, Sears Real Estate 9703307700

Info
 Print
 Print
Tour
Status: Active
Property Type: Single Family Residence
Year Built: 2009
Days On Website: 3
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.

Features

Building

  • Above Grade Finished Area: 5476
  • Architectural Style: "Contemporary/Modern", "Ranch"
  • Below Grade Finished Area: 3546
  • Building Area Total: 5476
  • Construction Materials: "Stone", "Stucco"
  • Has Improvements: No
  • Main Floor Sq Ft: 3371
  • Total Sq Ft: 9022
  • Upper Sq Ft: 2105
  • Levels: "One"
  • Living Area: 8900
  • Living Area Source: Assessor
  • Living Area Units: Square Feet
  • Stories: 1
  • Year Built: 2009

Property Access

  • Accessibility Features: "Main Floor Bath", "Main Level Bedroom", "Main Level Laundry"

Appliances & Equipment

  • Appliances: "Gas Range/Oven", "Self Cleaning Oven", "Double Oven", "Dishwasher", "Refrigerator", "Bar Fridge", "Microwave", "Disposal"

Home Owner's Association

  • Association Fee: 4300
  • Association Fee Frequency: Annually
  • Association YN: t
  • Has Association 2 Fee: No
  • Has Association 2 Reserve: No
  • Has Association Fee: Yes
  • Has Association Reserve: Yes
  • Has HOA Covenants: t
  • HOA 2 Transfer Fee: No
  • HOA Transfer Fee: Yes

Garage

  • Attached Garage YN: t
  • Covered Spaces: 11
  • Garage Spaces: 11
  • Garage YN: t
  • Garage Sq Ft: 2928
  • Garage Type: Attached

Basement

  • Basement: "Full", "Partially Finished", "Walk-Out Access"

Bathrooms

  • Bathrooms Full: 4
  • Bathrooms Half: 3
  • Bathrooms Three Quarter: 2
  • Bathrooms Total Integer: 9
  • Baths Full Additional: 1
  • Baths Full Basement: 1
  • Baths Half Additional: 1
  • Baths Half Basement: 0
  • Baths Rough In: 0
  • Baths Three Quarters Additional: 0
  • Baths Three Quarters Basement: 2
  • Baths Three Quarters Lower: 0
  • Baths Three Quarters Upper: 0

Bedrooms

  • Bedrooms Total: 5
  • All Bedrooms Conform: t

Location

  • City: Greeley
  • Country: US
  • County Or Parish: Weld
  • Locale: Greeley
  • Latitude: 40.4577
  • Longitude: -104.8168
  • MLS Area Major: Greeley/Weld
  • Postal Code: 80631
  • State Or Province: CO
  • Street Name: Shiloh
  • Street Number: 12690
  • Street Suffix: Rd
  • Subdivision Name: Bracewell
  • Unparsed Address: 12690 Shiloh Rd Greeley CO 80631

Community

  • Community Features: "Park"

Cooling

  • Cooling: "Central Air", "Ceiling Fan(s)"
  • Cooling YN: t

Property

  • Direction Faces: North,Northeast
  • Parcel Number: R3199204
  • Possible Use: "Single Family"
  • Property Condition: "Not New, Previously Owned"
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Road Frontage Type: "City Street"
  • Road Surface Type: "Paved", "Asphalt"
  • View: "Mountain(s)", "Foothills View", "Water"
  • Waterfront Features: "Abuts Pond/Lake", "Lake Front"
  • Waterfront YN: t

Utilities

  • Electric: "Electric", "XCEL"
  • Gas: "Natural Gas", "ATMOS"
  • Is Water Meter Installed: Yes
  • Utilities: "Natural Gas Available", "Electricity Available", "Cable Available"

Schools

  • Elementary School: Mountain View
  • High School: Severance High School
  • High School District: Weld RE-4
  • Middle Or Junior School: Severance

Exterior Features

  • Exterior Features: "Balcony"
  • Patio And Porch Features: "Patio", "Deck"

Fence

  • Fencing: "Partial", "Vinyl"

Fireplaces

  • Fireplace Features: "Gas", "Living Room"
  • Fireplace YN: t

Floors

  • Flooring: "Wood Floors"

Heating

  • Heating: "Forced Air", "2 or more Heat Sources"
  • Heating YN: t

Family Room

  • Has Family Room: t
  • Room Family Room Area: 784
  • Room Family Room Features: "Engineered Hardwood Floor"
  • Room Family Room Length: 28
  • Room Family Room Level: Basement
  • Room Family Room Width: 28

Taxes

  • Has Metro Tax District: No
  • Tax Annual Amount: 9153
  • Tax Year: 2023

Water Features

  • Has Water Rights: No
  • Water Source: "District Water", "North Weld Water"

Laundry

  • Laundry Room Floor Type Code: Tile
  • Laundry Room Length: 20
  • Laundry Room Width: 9
  • Laundry Features: "Sink", "Washer/Dryer Hookups", "Main Level"

Recreation Room

  • Rec Room Floor Type Code: Engineered Hardwood
  • Rec Room Length: 16
  • Rec Room Level Code: Basement
  • Rec Room Width: 16

Sitting Room

  • Study Floor Type Code: Engineered Hardwood
  • Study Length: 13
  • Study Level Code: Main
  • Study Width: 13

Interior Features

  • Interior Features: "Study Area", "High Speed Internet", "Separate Dining Room", "Cathedral/Vaulted Ceilings", "Open Floorplan", "Pantry", "Walk-In Closet(s)", "Kitchen Island"

Listing

  • Listing Id: 1021712
  • Listing Terms: "Cash", "Conventional", "FHA", "VA Loan"
  • List Price: 3900000
  • Mls Status: Active
  • Special Listing Conditions: "Private Owner"
  • Standard Status: Active

Lot

  • Lot Features: "Fire Hydrant within 500 Feet", "Lawn Sprinkler System", "Mineral Rights Excluded", "Corner Lot", "Wooded", "Lake Access", "Lake Front", "Waterfront"
  • Lot Size Acres: 2.53
  • Lot Size Area: 110199
  • Lot Size Square Feet: 110199
  • Lot Size Units: Square Feet

Miscellaneous

  • Other Structures: "Storage", "Carriage House"

Parking

  • Parking Features: "RV/Boat Parking", ">8' Garage Door", "Heated Garage", "Oversized", "Tandem"

Second Bedroom

  • Room Bedroom 2 Area: 182
  • Room Bedroom 2 Features: "Carpet"
  • Room Bedroom 2 Length: 13
  • Room Bedroom 2 Level: Main
  • Room Bedroom 2 Width: 14

Third Bedroom

  • Room Bedroom 3 Area: 255
  • Room Bedroom 3 Features: "Carpet"
  • Room Bedroom 3 Length: 17
  • Room Bedroom 3 Level: Basement
  • Room Bedroom 3 Width: 15

Fourth Bedroom

  • Room Bedroom 4 Area: 210
  • Room Bedroom 4 Features: "Carpet"
  • Room Bedroom 4 Length: 15
  • Room Bedroom 4 Level: Basement
  • Room Bedroom 4 Width: 14

Dining Room

  • Room Dining Room Area: 195
  • Room Dining Room Features: "Tile Floor"
  • Room Dining Room Length: 13
  • Room Dining Room Level: Main
  • Room Dining Room Width: 15

Kitchen

  • Room Kitchen Area: 384
  • Room Kitchen Features: "Engineered Hardwood Floor"
  • Room Kitchen Length: 24
  • Room Kitchen Level: Main
  • Room Kitchen Width: 16

Living Room

  • Room Living Room Area: 400
  • Room Living Room Features: "Engineered Hardwood Floor"
  • Room Living Room Length: 20
  • Room Living Room Level: Main
  • Room Living Room Width: 20

Primary Bedroom

  • Room Master Bathroom Features: "Luxury Features Primary Bath", "5 Piece Primary Bath"
  • Room Master Bedroom Area: 425
  • Room Master Bedroom Features: "Engineered Hardwood Floor"
  • Room Master Bedroom Length: 25
  • Room Master Bedroom Level: Main
  • Room Master Bedroom Width

Windows

  • Window Features: "Window Coverings"

Property Map

Map View

$3,900,000 - 12690 Shiloh Rd, Greeley, CO 80631

Street View

Directions

12690 Shiloh Rd
Greeley, CO 80631
City: Greeley

Nearby Schools

Local Sales

Photo of Sydney Sowy

Sydney Sowy

(210) 788-9633

Request Information

This content last updated on November 5, 2024 12:44PM. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.