N95W26705 County Road Q, Colgate, WI, 53017
About This Home
Welcome to Lake Five--where lake living is at its finest. This beautifully maintained Cape Cod-style cabin offers 50 feet of frontage on a private 104-acre full recreational lake with no public access. Spend your days boating, fishing, and making memories, then tie up at your year-round pier and unwind. The 3-bedroom, 1-bath home sits on a deep .64-acre lot, perfect for entertaining or relaxing lakeside. Ideal as a full-time residence or weekend escape, this move-in-ready retreat puts you just minutes from scenic views and quick freeway access. Bring your boat and start enjoying summer on the water. Also note that all of the land on the northside of the lake is in a conservancy and will not be built on. Long story short you'll be able to enjoy the piece and quiet for decades to come!
Getting Around
Car-Dependent
Very Limited Transit
Somewhat BikeableSchools
Construction
Condition
- Property condition: 21+ Years
- Year built: 1926
Materials
- Construction materials: Vinyl Siding
Type & Style
- Home type: SingleFamily
- Architectural style: Cape Cod
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Dishwasher,Dryer,Other,Oven,Refrigerator,Washer
Basement
- Has basement: Yes
- Basement: Full,Sump Pump
Bedroom2
- Level: Upper
- Area: 0
Bedroom3
- Level: Upper
- Area: 0
Bedrooms & Bathrooms
- Bedrooms: 3
- Bathrooms: 1
- Full bathrooms: 1
- Main level bedrooms: 1
Heating & Cooling
- Heating features: Natural Gas
- Cooling features: Central Air
Interior Area
- Total structure area: 1,072
- Total interior livable area: 1,072 sqft
Kitchen
- Level: Main
- Area: 0
Living Room
- Level: Main
- Area: 0
Master Bedroom
- Level: Main
- Area: 0
Office
- Level: Upper
- Area: 0
Property
Details
- Parcel number: LSBT0162985
- Zoning: Residential
- Exclusions: Seller's Personal Property.
Features
- Levels: One and One Half
- Stories: 1
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- On waterfront: Yes
- Waterfront features: Waterfront,Lake,1-50 feet
- Waterbody name: Lake Five
- Living area range: 1001-1250
Lot
- Lot size: 0.64 Acres
Parking
- Total spaces: 2
- Parking features: Garage Door Opener,Detached,2 Car
- Has garage: Yes
- Attached garage spaces: 2
- Covered spaces: 2
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Cold Wave
- Tornado
- Hail
- Heat Wave
- Inland Flooding
- Winter Weather
How This Home’s Risks Compare
FEMA Declared Disasters Across Wisconsin Counties
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $2,927 | $35,124 |
| Home Insurance * | $151 | $1,812 |
| Property Taxes | $523 | $6,276 |
| Electricity | $171 | $2,054 |
| Total | $3,772 | $45,264 |
Income You'd Need if You Spent...
Wisconsin FAIR Plan Programs
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2026-05-07 | Listed for sale | $610,000 |
View on Zillow