5774 County Highway Q, Colgate, WI 53017

Listed by Michael Schaefer • Keller Williams Realty-Lake Country. Bought with ERA MyPro Realty.

Off market jul 2021 for $510K

$684,062

•

2,388

sq ft

5774 County Highway Q, Colgate, WI 53017

About this home

Public Remarks: Shockingly available, this stunning, private home on 2.83 acres in the town of Erin has come to the market. This 3 bedroom, 2.5 bath custom built home has it all. Enter down your private drive lined with massive Tall Pines coming to your home. A massive, attached garage, and additional two car detached garage welcome you home, entering your gorgeous, vaulted family room overlooking tranquil woods, a massive deck for entertaining, fenced garden and whimsical forest garden with rock stream. Great side yard with a large gathering firepit. The large chef's kitchen brings it all together, with a large family gathering dining area. Upstairs you will find a large loft area, perfect for a library, rec room or office space. Updated Electrical, HVAC, Windows, Carpet and Tankless Water Heater!

Single-familyProperty Type

1976Year Built

2.83 acresLot Size

$286Est. Price/Sq.Ft.

1 garage spacesParking

Listed by Michael Schaefer • Keller Williams Realty-Lake Country

Bought with Haley Burlage • ERA MyPro Realty

Redfin checked: a minute ago

•Source:MetroMLS as distributed by WIREX #1741766

Redfin Estimate

$684,062

$174K since sold in July 2021$1,000 since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 15.1% higher than the average sale price ($594K) of 6 comparable homes.

SOLD AUG 28, 2026
$680,000
A
3 beds2.5 baths2,182 sq ft
W280N8123 Black Diamond Ct, Hartland, WI 53029
SOLD APR 20, 2026
$550,000
B
4 beds2.5 baths2,296 sq ft
814 Tipperary Ln, Hartford, WI 53027
SOLD AUG 21, 2026
$565,000
C
4 beds2.5 baths2,196 sq ft
731 Tipperary Ln, Hartford, WI 53027
SOLD JUN 5, 2026
$530,000
D
3 beds2.5 baths2,644 sq ft
4252 Ridge Rd, Colgate, WI 53017
SOLD AUG 28, 2026
$615,000
E
3 beds2.5 baths1,858 sq ft
1661 Friess Lake Rd, Hubertus, WI 53033
SOLD JUN 10, 2026
$625,000
F
3 beds2.5 baths2,858 sq ft
1311 Emerald Dr, Hartford, WI 53027

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$275,712

Est. take-home

List your home with Redfin and save $6,841

Rent

$2,247/mo

Redfin rental estimate

List your home for rent

Market trends in 53017, WI

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

100.9%

0.2% MoM

Median sale price

$500K

$1K MoM

Avg. days on market

40d

0 days MoM

Recently sold homes

1 MoM

New listings for sale

3D WALKTHROUGH
$650,000
3 beds3 baths2,706 sq ft
527 Winchester Pass, Colgate, WI 53017
The Borowski Group* • Homestead Realty, Inc
$474,900
3 beds2.5 baths1,787 sq ft
W215N10122 Hickory Dr, Colgate, WI 53017
Elizabeth Bertrandt-Klug • Keller Williams Realty-Lake Country
$469,000
3 beds2 baths1,674 sq ft
4264 Kennedy Circle Cir S, Colgate, WI 53017
Cheryl Marquardt • EXP Realty, LLC MKE
See all

Provided by Redfin

Sale history for 5774 County Highway Q

Date

Event

Price

MetroMLS as distributed by WIREX #1741766

Jul 26, 2021

Sold

$510,000

$214/sq ft

May 25, 2021

Contingent

—

May 21, 2021

Listed

$509,500

$213/sq ft

MetroMLS as distributed by WIREX #1623597

Apr 12, 2019

Sold

$422,800

$177/sq ft

Feb 24, 2019

Contingent

—

Feb 21, 2019

Listed

$419,000

$175/sq ft

Public Remarks

Beautiful home nestled in the woods in the town of Erin. Natural fireplace to warm you up on the cold winter nights. Great Room is perfect for entertaining and has a hidden wet bar. Master suite has tile shower and walk in closet. Loft has endless possibilities, could be used as an office, den, or playroom. Plenty of garage space to store your toys! Open enrollment/School choice advantage with low Town of Erin taxes.

MetroMLS as distributed by WIREX #1020788

Jan 30, 2013

Listed

$419,900

$176/sq ft

Jan 30, 2013

Listing Removed

—

MetroMLS as distributed by WIREX #1155921

Jan 25, 2013

Listing Removed

—

Jan 25, 2013

Listed

$350,000

$147/sq ft

Dec 29, 2010

Sold

$306,200

$128/sq ft

MetroMLS as distributed by WIREX #1070156

Jan 22, 2013

Listing Removed

—

Jan 22, 2013

Listed

$354,000

$148/sq ft

Jul 17, 2009

Sold

$325,000

$136/sq ft

Join or sign in to view all info

Year

Property tax

Land + Additions

Assessment*

2025

$4,319 (+14.0%)

$200,900 + $347,500

$548,400

2024

$3,788 (+0.9%)

$200,900 + $347,500

$548,400

2023

$3,753 (+6.9%)

$151,000 + $186,400

$337,400

2022

$3,510 (+2.2%)

$151,000 + $186,400

$337,400

2021

$3,434 (−7.9%)

$151,000 + $186,400

$337,400

2020

$3,730 (−2.0%)

$151,000 + $186,400

$337,400

2019

$3,807 (+1.0%)

$151,000 + $186,400

$337,400

2018

$3,770 (+1.1%)

$151,000 + $186,400

$337,400

2017

$3,728 (−3.0%)

$151,000 + $186,400

$337,400

2016

$3,842 (−3.5%)

$151,000 + $186,400

$337,400

2014

$3,983 (−7.1%)

$151,000 + $186,400

$337,400

2013

$4,288

$151,000 + $186,400

$337,400

Tax history for 5774 County Highway Q

Year

Property tax

Land + Additions

Assessment*

2025

$4,319 (+14.0%)

$200,900 + $347,500

$548,400

2024

$3,788 (+0.9%)

$200,900 + $347,500

$548,400

2023

$3,753 (+6.9%)

$151,000 + $186,400

$337,400

2022

$3,510 (+2.2%)

$151,000 + $186,400

$337,400

2021

$3,434 (−7.9%)

$151,000 + $186,400

$337,400

2020

$3,730 (−2.0%)

$151,000 + $186,400

$337,400

2019

$3,807 (+1.0%)

$151,000 + $186,400

$337,400

2018

$3,770 (+1.1%)

$151,000 + $186,400

$337,400

2017

$3,728 (−3.0%)

$151,000 + $186,400

$337,400

2016

$3,842 (−3.5%)

$151,000 + $186,400

$337,400

2014

$3,983 (−7.1%)

$151,000 + $186,400

$337,400

2013

$4,288

$151,000 + $186,400

$337,400

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

2.83 Acres

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Single Family Residential

County

Washington County

APN

T3 071900A

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 29, 2026.

Property details

Parking

Parking Information
Parking: 1 Space

Garage Information
# of Garage Parking Spaces (Total): 5
Garage: Opener Included, Attached, 4+ Cars

Interior

Bedroom Information
Master Bedroom Dimensions: 16 x 14
Master Bedroom Level: Main
Bedroom 2 Dimensions: 13 x 13
Bedroom 2 Level: Main
Bedroom 3 Dimensions: 14 x 13
Bedroom 3 Level: Main

Bathroom Information
Bath Description(s): Tub Only, Walk-In Shower in Master Bathroom, Master Bedroom Bath
# of Baths (1/2): 1
# of Baths (Full): 2

Interior Features
Water Softener, Cable/Satellite Available, High Speed Internet, Pantry, Cathedral/Vaulted Ceiling, Walk-In Closet(s), Wood or Simulation Wood Floors

Room Information
8'+ Ceiling, Block, Crawl Space, Full, Radon Mitigation System, Sump Pump
Living Room Dimensions: 22 x 24
Living Room Level: Main
Kitchen Level: Main
Kitchen Dimensions: 21 x 16
Dining Room Dimensions: 18 x 14
Dining Room Level: Main

Equipment
Appliances: Dishwasher, Dryer, Microwave, Range/Oven, Range, Refrigerator

Exterior

Building Information
Building Type: 2 Story
Estimated Sq. Ft. Range: 2001-2500
Below Grade Unfinished Sq. Ft.: 1,100

Exterior
Exterior: Stone, Brick/Stone, Wood

Property Information
Single-Family
Information Source Year Built: Assessor/Public Record

Land Information
Acreage: Over 2 Acres to 5 Acres

Lot Information
Lot Acreage: 2.83
Lot Description: Wooded
Zoning: R5

Financial

Tax Information
Total Taxes: $3,729.96
Tax Year: 2020

Utilities

Utility Information
Well, Private Septic System
Heating/Cooling: Central Air, Forced Air
Natural Gas

Location

Neighborhood Information
Municipality: ERIN
Municipality Type: Town

School Information
School District: Erin
Elementary School: Erin
High School: Hartford

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 2.83 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Washington County
APN: T3 071900A

Home facts updated by county records on Jul 29, 2026

Other

Listing Information
Inclusions: Refrigerator, Dishwasher, Microwave, Oven/Range, Washer, Dryer, GDO (2), Water Softener (Owned), Radon Mitigation
Exclusions: Sellers Personal Property

Around this home

Schools

Erin Elementary School

Public PreK-8 • Assigned • 4.9mi

9/10

Hartford High School

Public 9-12 • Assigned • 8.4mi

5/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

1/10 Heat Factor

7 days above 99° expected this year, 13 days in 30 years

2/10 Wind Factor

Minor risk of severe winds over next 30 years

3/10 Air Factor

2 unhealthy days expected this year, 3 days in 30 years

Provided by First Street

Historical weather

Colgate, WI • 53017

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9.9 hours in June and 3.4 hours in December, placing it below the U.S. average for solar exposure.

9.9 hrs

3.4 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$650,000 – $787,000

Reach more buyers when you sell with Redfin. Save up to $6,841 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$4,200,000

3 beds3.5 baths6,828 sq ft

790 Erin Rd, Hartford, WI 53027

Glen Hupfer • RE/MAX United - West Bend

OPEN SAT, 11AM TO 12:30PM

$819,900

4 beds2.5 baths2,726 sq ft

W275N8210 Harvest Ct, Hartland, WI 53029

Erin Russell • Tim O'Brien Homes LLC

$774,900

5 beds3.5 baths3,434 sq ft

N93W24655 Bark Rd, Colgate, WI 53017

William Winser • List 4 Less MLS of WI

NEW CONSTRUCTION

$819,990

4 beds2.5 baths2,945 sq ft

N82 W27810 Sunflower Pass, Merton, WI 53029

Jordan Kaerek • Kaerek Homes, Inc.

$824,900

4 beds3 baths3,452 sq ft

N71W31034 Lower Club Circle Cir W, Hartland, WI 53029

Pluster Filip Property Group* • Keller Williams Realty-Lake Country

OPEN SAT, 11AM TO 12:30PM3D WALKTHROUGH

$699,900

3 beds3 baths2,464 sq ft

4786 Riverview Dr, Hubertus, WI 53033

Tony Wendorf & Associates Team* • Keller Williams Realty-Lake Country

New listings for sale in 53017

3D WALKTHROUGH

$650,000

3 beds3 baths2,706 sq ft

527 Winchester Pass, Colgate, WI 53017

The Borowski Group* • Homestead Realty, Inc

$474,900

3 beds2.5 baths1,787 sq ft

W215N10122 Hickory Dr, Colgate, WI 53017

Elizabeth Bertrandt-Klug • Keller Williams Realty-Lake Country

$469,000

3 beds2 baths1,674 sq ft

4264 Kennedy Circle Cir S, Colgate, WI 53017

Cheryl Marquardt • EXP Realty, LLC MKE

Home values near 5774 County Highway Q

Data from public records.

Address	Redfin Estimate
W291N9535 Badger Trl, Colgate, WI 3 Beds \| 2.5 Baths \| 2528 Sq. Ft.	$555,378
N95W29096 Fawn Ct, Colgate, WI 3 Beds \| 2 Baths \| 1700 Sq. Ft.	$486,186

Address	Redfin Estimate
N95W29135 Fawn Ct, Colgate, WI 4 Beds \| 2.5 Baths \| 2450 Sq. Ft.	$554,111
N95W29233 County Road Q, Colgate, WI 3 Beds \| 2 Baths \| 2000 Sq. Ft.	$620,510

Address	Redfin Estimate
W290N9553 Deer Ln, Colgate, WI 4 Beds \| 2.5 Baths \| - Sq. Ft.	$509,821
W290N9569 Deer Ln, Colgate, WI 3 Beds \| 2.5 Baths \| 2348 Sq. Ft.	$589,931

Property information provided by MetroMLS as distributed by WIREX when last listed in 2021. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Washington County	Agents near me	Kenosha, WI homes for sale	Washington County Housing Market
Houses for sale near me	Madison, WI homes for sale	Wauwatosa, WI homes for sale
Land for sale near me	Milwaukee, WI homes for sale	Green Bay, WI homes for sale
Open Houses near me	Lake Geneva, WI homes for sale	Washington County Property Records
Condos for sale near me	Brookfield, WI homes for sale	WI New Listings

Milwaukee County homes for sale
Sheboygan County homes for sale
Waukesha County homes for sale

Hartford homes for sale
Germantown homes for sale
West Bend homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 53017, WI

Sale history for 5774 County Highway Q

Tax history for 5774 County Highway Q

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 53017

Home values near 5774 County Highway Q

More real estate resources