N95W23241 County Road Q, Colgate, WI 53017

Listed by Colleen Tarantino • Redefined Realty Advisors LLC (2627325800). Bought with EXIT Realty Horizons-Gmtwn.

Off market nov 2022 for $228K

$256,512

•

1,774

sq ft

N95W23241 County Road Q, Colgate, WI 53017

About this home

Public Remarks: This stone & brick farmhouse has so much potential! With almost 1,775 square feet of living space this is the perfect opportunity to re-do the interior & design a floor plan that works best for you. Exterior already has the charm, but bring your ideas for the interior. The yard is beautiful & private. Exterior also features a detached 2 car garage that will fit a pick up truck. Tall ceilings thru out are quite a bonus & there is a cozy wood burning stove to boot in the living rm. The 1st floor also features a ''summer kitchen'' & could be turned into an inviting 3-season room. The 2nd floor is very spacious & includes a walk-up attic which holds endless design opportunities. Boiler new in 2005. This home needs someone with vision, but with some sweat equity it will be a storybook home.

Single-familyProperty Type

1900Year Built

0.7 acresLot Size

$145Est. Price/Sq.Ft.

2 car garageParking

Listed by Colleen Tarantino • Redefined Realty Advisors LLC

Contact: 2627325800

Bought with Warren Krahn • EXIT Realty Horizons-Gmtwn

Redfin checked: 2 minutes ago

•Source:MetroMLS as distributed by WIREX #1811828

Redfin Estimate

$256,512

$29K since sold in November 2022$4,000 since September

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 41.7% lower than the average sale price ($440K) of 6 comparable homes.

SOLD SEP 24, 2026
$435,000
A
3 beds1.5 baths1,472 sq ft
W215N10105 Hickory Dr, Colgate, WI 53017
SOLD AUG 25, 2026
$425,000
B
3 beds1.5 baths1,724 sq ft
573 Jordan Cir, Colgate, WI 53017
SOLD SEP 18, 2026
$460,000
C
3 beds1.5 baths1,780 sq ft
N95W25161 Whitewater Dr, Colgate, WI 53017
SOLD JUL 15, 2026
$425,000
D
3 beds2 baths1,804 sq ft
W226N8085 Rolling Hills Dr, Lisbon, WI 53089
SOLD JUL 20, 2026
$439,900
E
3 beds2 baths1,920 sq ft
N97W21763 White Horse Dr, Colgate, WI 53017
SOLD JUL 20, 2026
$455,000
F
3 beds1.5 baths2,180 sq ft
W248N9575 Norwauk Ct, Colgate, WI 53017

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

Earn from this home

Sell

$70,703

Est. take-home

List your home with Redfin and save $2,565

Rent

$2,104/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 N95W23241 County Road Q

Year

Property tax

Land + Additions

Assessment*

2025

$2,475 (+4.9%)

$33,400 + $137,700

$171,100

2024

$2,359 (+11.8%)

$33,400 + $137,700

$171,100

2023

$2,110 (−4.6%)

$33,400 + $137,700

$171,100

2022

$2,211 (+4.5%)

$33,400 + $137,700

$171,100

2021

$2,115 (+3.3%)

$33,400 + $137,700

$171,100

2020

$2,048 (+0.2%)

$33,400 + $137,700

$171,100

2019

$2,043 (+3.9%)

$27,800 + $99,400

$127,200

2018

$1,965 (+2.5%)

$27,800 + $99,400

$127,200

2017

$1,917 (−2.9%)

$27,800 + $99,400

$127,200

2016

$1,975 (+0.2%)

$27,800 + $99,400

$127,200

2014

$1,972 (−5.1%)

$27,800 + $99,400

$127,200

2013

$2,077

$27,800 + $99,400

$127,200

Tax history for N95W23241 County Road Q

Year

Property tax

Land + Additions

Assessment*

2025

$2,475 (+4.9%)

$33,400 + $137,700

$171,100

2024

$2,359 (+11.8%)

$33,400 + $137,700

$171,100

2023

$2,110 (−4.6%)

$33,400 + $137,700

$171,100

2022

$2,211 (+4.5%)

$33,400 + $137,700

$171,100

2021

$2,115 (+3.3%)

$33,400 + $137,700

$171,100

2020

$2,048 (+0.2%)

$33,400 + $137,700

$171,100

2019

$2,043 (+3.9%)

$27,800 + $99,400

$127,200

2018

$1,965 (+2.5%)

$27,800 + $99,400

$127,200

2017

$1,917 (−2.9%)

$27,800 + $99,400

$127,200

2016

$1,975 (+0.2%)

$27,800 + $99,400

$127,200

2014

$1,972 (−5.1%)

$27,800 + $99,400

$127,200

2013

$2,077

$27,800 + $99,400

$127,200

*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

0.3 Acres

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Single Family Residential

County

Waukesha County

APN

LSBT0149001

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 21, 2026.

Property details

Parking

Garage Information
# of Garage Parking Spaces (Total): 2
Garage: Detached, 2 Car

Interior

Bedroom Information
Master Bedroom Dimensions: 16 x 11
Master Bedroom Level: Upper
Bedroom 2 Dimensions: 12 x 10
Bedroom 2 Level: Upper
Bedroom 3 Dimensions: 13 x 9
Bedroom 3 Level: Upper

Bathroom Information
Bath Description(s): Tub Only, Shower Stall
# of Baths (Full): 2

Interior Features
Water Softener, Expandable Attic

Room Information
None/Slab
Other Room 1 Dimensions: 11 x 9
Other Room 1 Level: Upper
Other Room 1 Name: Other Room
Other Room 2 Name: Three Season Room
Living Room Dimensions: 18 x 13
Living Room Level: Main
Kitchen Level: Main
Kitchen Dimensions: 12 x 8
Dining Room Dimensions: 20 x 12
Dining Room Level: Main
Den/Office Dimension: 11 x 8
Den/Office Level: Upper

Equipment
Appliances: Dryer, Oven, Range, Refrigerator, Washer

Exterior

Building Information
Building Type: 2 Story
Estimated Sq. Ft. Range: 1751-2000

Exterior
Exterior: Brick, Brick/Stone, Stone

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

Land Information
Acreage: 1/2 to 1

Lot Information
Outbuildings: Garden Shed
Lot Acreage: 0.7
Zoning: RES

Financial

Tax Information
Total Taxes: $2,551.53
Tax Year: 2021

Utilities

Utility Information
Private Septic System, Mound System, Well
Heating/Cooling: Radiant/Hot Water
Natural Gas

Location

Neighborhood Information
Municipality: LISBON
Municipality Type: Village

School Information
School District: Hamilton
Middle School: Templeton
High School: Hamilton

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: 0.3 acres
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Waukesha County
APN: LSBT0149001

Home facts updated by county records on Sep 21, 2026

Other

Listing Information
Inclusions: Stove, Refrigerator, Washer, Dryer, Water Softener

Around this home

Schools

Woodside Elementary School

Public K-4 • Assigned • 2.8mi

8/10

Templeton Middle School

Public 7-8 • Assigned • 4.6mi

10/10

Hamilton High School

Public 9-12 • Assigned • 4.5mi

7/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

3/10 Fire Factor

0.15% chance of being in a wildfire in next 30 years

1/10 Heat Factor

7 days above 98° 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, 4 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

$244,000 – $295,000

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

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

Nearby similar homes

$774,900

5 beds3.5 baths3,434 sq ft

N93W24655 Bark Rd, Colgate, WI 53017

William Winser • List 4 Less MLS of WI

$474,900

3 beds2.5 baths1,787 sq ft

W215N10122 Hickory Dr, Colgate, WI 53017

Elizabeth Bertrandt-Klug • Keller Williams Realty-Lake Country

$1,099,000

4 beds4 baths7,165 sq ft

3976 Woodridge Ct, Colgate, WI 53017

Michelle Hintz • Homestead Realty, Inc

3D WALKTHROUGH

$549,000

3 beds1 bath1,072 sq ft

N95W26705 County Road Q, Colgate, WI 53017

James Menger • Keller Williams Prestige

$469,000

3 beds2 baths1,674 sq ft

4264 Kennedy Circle Cir S, Colgate, WI 53017

Cheryl Marquardt • EXP Realty, LLC MKE

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 N95W23241 County Road Q

Data from public records.

Address	Redfin Estimate
3374 County Road Q, Colgate, WI 3 Beds \| 1 Baths \| 1248 Sq. Ft.	$281,222
W230N9489 Colgate Rd, Lisbon, WI 3 Beds \| 1 Baths \| 1250 Sq. Ft.	$341,667

Address	Redfin Estimate
N95W23295 County Road Q, Colgate, WI 3 Beds \| 2 Baths \| 2380 Sq. Ft.	—
W230N9491 Colgate Rd, Lisbon, WI 3 Beds \| 2 Baths \| 1351 Sq. Ft.	$367,663

Address	Redfin Estimate
County Rd Q, Colgate, WI 2 Beds \| - Baths \| 1456 Sq. Ft.	$386,846
3410 Cty Highway Q, Colgate, WI 3 Beds \| 1 Baths \| 1481 Sq. Ft.	$342,933

Property information provided by MetroMLS as distributed by WIREX when last listed in 2022. 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.

53046 homes for sale
53089 homes for sale
53029 homes for sale
53072 homes for sale
53051 homes for sale

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	Lisbon Property Records
Condos for sale near me	Brookfield, WI homes for sale	WI New Listings
Agents near me	Kenosha, WI homes for sale	Lisbon Housing Market

Wauwatosa homes for sale
Milwaukee homes for sale
Brookfield homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 53017, WI

Sale history for N95W23241 County Road Q

Tax history for N95W23241 County Road 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 N95W23241 County Road Q

More real estate resources