Closed
$2,025,000
5768 County Highway Q, Colgate, WI 53017
4beds
7,654sqft
Single Family Residence
Built in 2006
36.38 Acres Lot
$2,170,800 Zestimate®
$265/sqft
$4,889 Estimated rent
Home value
$2,170,800
$1.91M - $2.47M
$4,889/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Gorgeous brick and stone home on 36 private wooded acres. Absolutely stunning, high end luxury home tucked away down a long private road past the restored vintage barn. Enter through the gates to this magical place - fantastic professional landscaping and 2 fully-fenced acres for dogs or kids. Gorgeous woodwork, stone, and hickory floors, main floor master suite, 3 fireplaces. An entertainer's dream with space and amenities inside and out, Several stone patios including new backyard oasis that features a stone pizza oven, great firepit, seating for everyone surrounded by nature. Indoor pool + sauna for year-round fun! Elevator so nobody has to miss out. The fully-finished lower level offers an authentic tavern room, workout area/play room, hunting room and craft room. A must see!
Zillow last checked: 8 hours ago
Listing updated: January 13, 2025 at 12:41am
Listed by:
Bruce Gallagher 414-881-8586,
Keller Williams Realty-Lake Country
Bought with:
Bridget M Tighe
Source: WIREX MLS,MLS#: 1835922
Originating MLS: Metro MLS
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 2
- Main level bedrooms: 1
Primary bedroom
- Level: Main
- Area: 280
- Dimensions: 20 x 14
Bedroom 2
- Level: Upper
- Area: 238
- Dimensions: 17 x 14
Bedroom 3
- Level: Upper
- Area: 168
- Dimensions: 14 x 12
Bedroom 4
- Level: Upper
- Area: 180
- Dimensions: 15 x 12
Bathroom
- Features: Ceramic Tile, Whirlpool, Master Bedroom Bath: Tub/No Shower, Master Bedroom Bath: Walk-In Shower, Master Bedroom Bath, Shower Stall
Dining room
- Level: Main
- Area: 252
- Dimensions: 18 x 14
Family room
- Level: Main
- Area: 210
- Dimensions: 15 x 14
Kitchen
- Level: Main
- Area: 198
- Dimensions: 18 x 11
Living room
- Level: Main
- Area: 357
- Dimensions: 21 x 17
Office
- Level: Main
- Area: 208
- Dimensions: 16 x 13
Heating
- Natural Gas, Forced Air, In-floor, Radiant, Multiple Units, Radiant/Hot Water, Zoned
Cooling
- Central Air, Multi Units
Appliances
- Included: Cooktop, Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer, Water Softener
Features
- Central Vacuum, High Speed Internet, Pantry, Sauna, Walk-In Closet(s), Wet Bar, Kitchen Island
- Flooring: Wood or Sim.Wood Floors
- Windows: Skylight(s)
- Basement: Finished,Full,Sump Pump
Interior area
- Total structure area: 7,654
- Total interior livable area: 7,654 sqft
Property
Parking
- Total spaces: 3.5
- Parking features: Basement Access, Garage Door Opener, Heated Garage, Attached, 3 Car
- Attached garage spaces: 3.5
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio
- Exterior features: Sprinkler System
- Pool features: Indoor
- Has spa: Yes
- Spa features: Bath
Lot
- Size: 36.38 Acres
- Features: Horse Allowed, Wooded
Details
- Additional structures: Barn(s), Cabana/Gazebo
- Parcel number: T3071900K
- Zoning: RES
- Special conditions: Arms Length
- Other equipment: Intercom
- Horses can be raised: Yes
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Tudor/Provincial
- Property subtype: Single Family Residence
Materials
- Aluminum/Steel, Aluminum Siding, Brick, Brick/Stone, Aluminum Trim, Stone, Stucco/Slate
Condition
- 11-20 Years
- New construction: No
- Year built: 2006
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Cable Available
Community & neighborhood
Security
- Security features: Security System
Location
- Region: Colgate
- Municipality: Erin
Price history
| Date | Event | Price |
|---|---|---|
| 7/26/2023 | Sold | $2,025,000+2.5%$265/sqft |
Source: | ||
| 6/9/2023 | Contingent | $1,975,000$258/sqft |
Source: | ||
| 6/1/2023 | Listed for sale | $1,975,000+19.7%$258/sqft |
Source: | ||
| 12/15/2020 | Sold | $1,650,000$216/sqft |
Source: | ||
Public tax history
Tax history is unavailable.
Neighborhood: 53017
Nearby schools
GreatSchools rating
- 9/10Erin Elementary SchoolGrades: PK-8Distance: 4.8 mi
- 5/10Hartford High SchoolGrades: 9-12Distance: 8.3 mi
Schools provided by the listing agent
- Elementary: Erin
- High: Hartford
- District: Hartford Uhs
Source: WIREX MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$2,170,800
2% more+ $43,416
With Zillow Showcase(estimated)
$2,214,216
