NOT LISTED FOR SALE

5768 County Highway Q Colgate, WI 53017

4 Beds
6 Baths
7,654 Sq Ft
36.38 Acres

Last Sold December 15, 2020

Last sale price $1,650,000 $216 Per Sq Ft

8 Days on Market

Highlights

  • Indoor Pool
  • Sauna
  • Wooded Lot
  • Erin Elementary School Rated A-
  • 36.38 Acre Lot
  • Main Floor Primary Bedroom

About This Home

As of December 2020

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!

Last Agent to Sell the Property

Bruce Gallagher

Keller Williams Realty-Lake Country License #75491-94 Listed on: 05/25/2023

Keller Williams Realty-Lake Country

Last Buyer's Agent

Bridget Tighe

Keller Williams Realty-Milwaukee North Shore License #92186-94

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,182

Year Built

  • Built in 2006

Lot Details

  • 36.38 Acre Lot
  • Sprinkler System
  • Wooded Lot

Parking

  • 3.5 Car Attached Garage
  • Basement Garage
  • Heated Garage
  • Garage Door Opener

Home Design

  • Brick Exterior Construction
  • Stone Siding
  • Aluminum Trim
  • Stucco

Interior Spaces

  • 7,654 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Sauna
  • Home Security System

Kitchen

  • Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Whirlpool Bathtub
  • Bathtub Includes Tile Surround
  • Primary Bathroom includes a Walk-In Shower
  • Walk-in Shower

Laundry

  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Pool

  • Indoor Pool
  • Cabana

Outdoor Features

  • Patio

Schools

  • Erin Elementary School
  • Hartford High School

Utilities

  • Multiple cooling system units
  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Radiant Heating System
  • Well Required
  • Septic System
  • High Speed Internet

Listing and Financial Details

  • Exclusions: Sellers' personal property
  • Seller Concessions Not Offered

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,182

Year Built

Built in 2006

Lot Details

0

Parking

3

Listing Details

  • Prop. Type: Single-Family
  • Inclusions: See list
  • Directions: County Rd Q east from Monches to private driveway on the north side of Q. Follow driveway to the gate at the end of drive.
  • New Construction: No
  • Year Built: 2006
  • Cleared Acreage: Over 20 to 40 acres
  • Architecture: Tudor/Provincial
  • Full Street Address: 5768 County Highway Q
  • Type 5 Heat Fuel: Natural Gas
  • Kitchen Level: Main
  • Lot Acreage: 36.38
  • Municipality Type: Town
  • Other Rm1 Level: Main
  • Other Rm1 Name: Sun/Four Season Room
  • Lot Description Waterfront: No
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 0

Interior Features

  • Appliances: Cooktop, Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
  • Has Basement: Finished, Full, Sump Pump
  • Interior Amenities: Water Softener, Cable/Satellite Available, Central Vacuum, High Speed Internet, Indoor Pool, Intercom, Pantry, Sauna, Security System, Skylight(s), Walk-in closet(s), Wet Bar, Wood or Sim.Wood Floors
  • Bathroom Description: Ceramic Tile, Whirlpool, Master Bedroom Bath: Tub/No Shower, Master Bedroom Bath: Walk-In Shower, Master Bedroom Bath, Shower Stall
  • Room Bedroom2 Level: Upper
  • Bedroom 3 Level: Upper
  • Bedroom 4 Level: Upper
  • Den Office Level: Main
  • Dining Room Dining Room Level: Main
  • Family Room Level: Main
  • Living Room Level: Main
  • Master Bedroom Master Bedroom Level: Main
  • Master Bedroom Master Bedroom Width: 14
  • Second Floor Total Sq Ft: 7654.00

Exterior Features

  • Exclusions: Sellers' personal property
  • Exterior Features: Patio, Sprinkler System
  • Exterior Building Type: 2 Story
  • Exterior: Aluminum/Steel, Aluminum, Brick, Brick/Stone, Aluminum Trim, Stone, Stucco/Slate, (C) Stucco
  • Out Buildings: Cabana/Gazebo

Garage/Parking

  • Parking Features:Workshop in Garage: Basement Access, Opener Included, Heated, Attached, 3 Car
  • Garage Spaces: 3.5

Utilities

  • Water Waste: Well, Private Septic System

Schools

  • School District: Hartford Uhs
  • Elementary School: Erin
  • High School: Hartford
  • Elementary School: Erin
  • High School: Hartford
  • Junior High Dist: Hartford Uhs

Lot Info

  • Zoning: RES
  • Acreage Range: 20+
  • Lot Description: Horse Allowed, Wooded

Tax Info

  • Tax Year: 2022
  • Total Taxes: 15182.0

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area

Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/30/2023 07/30/23 Off Market $1,975,000 -- --
06/01/2023 06/01/23 For Sale $1,975,000 +19.7% $258 / Sq Ft
12/15/2020 12/15/20 Sold $1,650,000 0.0% $216 / Sq Ft
09/02/2020 09/02/20 Pending -- -- --
07/21/2020 07/21/20 For Sale $1,650,000 -- $216 / Sq Ft
Source: Metro MLS

Tax History Compared to Growth

Source: Public Records

Agents Affiliated with this Home

  • B

    Seller's Agent in 2023

    Bruce Gallagher

    Keller Williams Realty-Lake Country

    (414) 881-8586

    4 in this area

    133 Total Sales

    Bruce Gallagher
    Section Image

  • B

    Buyer's Agent in 2023

    Bridget Tighe

    Keller Williams Realty-Milwaukee North Shore

  • Q

    Seller's Agent in 2020

    Quinlevan & Armitage Team*

    Shorewest Realtors, Inc.

See All Agents

Map

Source: Metro MLS

MLS Number: 1835922

Metro MLS
Wisconsin Washington County Colgate 53017

5768 County Highway Q, Colgate, WI

This home is located at 5768 County Highway Q, Colgate, WI 53017 since 25 May 2023. This property was built in 2006. 5768 County Highway Q is a home located in Washington County with nearby schools including Erin Elementary School and Hartford High School.

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.

Metro MLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

IDX listing data provided by Multiple Listing Service, Inc. Information is supplied by seller and other third parties and has not been verified.

Copyright 2025 – Multiple Listing Service, Inc. – All Rights Reserved.

Nearby Homes