#6748662, David Bracht, Listing office: Property Executives Realty
$539,000 List price
851 174th Ave Somerset, WI 54017
3 beds
2 full
2,550 sqft
$211 / sqft
House
Property details
About 851 174th Ave
Well Kept, 3 bedroom, 2 full bath home with park like yard. Roof 2018, Furnace 2022, boiler 2023. Duel heat with in-floor heat and Forced air furnace with Central air. Andersen windows, steel siding, blacktop driveway. Park like yard includes 126 grape vines and extensive landscaping. Two sided fireplace in the Living room. no pets, kids or smoking ever in this house. Shows well. This lot extends into the neighbors garden, there is no money exchanged just veggies...after this season can be terminated if wish.
Highlights
Home typeSingle Family Residence
HeatingSteam, Forced Air, Fireplace(s), Radiant Floor, Zoned
StatusActive
CoolingCentral Air
Size2,550 sqft
BasementYes
Year built2003
ParkingAttached Garage, Concrete, Garage Door Opener
MLS #6748662
Attached garage3 spaces
FireplaceTwo Sided, Living Room
Summary
- Full Bathrooms: 2
- Appliances: Dishwasher, Dryer, Gas Water Heater, Range, Refrigerator, Washer
- Basement: Yes
- Fireplace: Two Sided, Living Room
- Total Bedroom Count: 3
- Garage Space: 3 spaces
- Attached Garage: Yes
- Parking: Attached Garage, Concrete, Garage Door Opener
- Heating: Steam, Forced Air, Fireplace(s), Radiant Floor, Zoned
- Cooling: Central Air
- List Price: $539,000
- Price/SqFt: $211
- HOA Amount: $0
- Directions: freeway 64 East out of Somerset to 85th St go South to 174th Ave
- Year Built: 2003
- Living Area: 2,550 SqFt
- MLS Number: 6748662
- MLS Name: NORTHSTAR
- Office Name: Property Executives Realty
Copyright © 2025 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.
By searching, you agree to the EULA Terms Agreement.
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Regional Multiple Listing Service of Minnesota, Inc. Real estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Some or all of the property listings above may have been submitted to the Regional Multiple Listing Service (RMLS) by the listing broker for distribution to cooperating brokers through Broker reciprocity. Attribution of the listing broker may be found on the detail page for all properties. The broker providing these data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision.
Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited. No part of this search utility may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise. Home sale information is not an appraisal, competitive or comparative market analysis, CMA or home valuation.
DMCA Notice
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/25/2025, 11:37:28 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
7
Somerset Elementary School
Public District PK-4
2.7 mi
•635 Sunrise Dr
4
New Richmond Starr Elementary School
Public District KG-5
4.6 mi
•967 S Starr Ave
6
New Richmond Hillside Elementary School
Public District KG-5
5.1 mi
•635 Richmond Way
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $76,522. The most common annual income of people living in Somerset, WI is between $35k-100k. Residents typically live in married, with kids family. Most residents in this area have post secondary degree education.
How much money do the neighbors make?
14%
<35k
50%
35k-100k
30%
100k-200k
6%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
29%
Single, No Kids
15%
Single, with Kids
26%
Married, No Kids
30%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
21%
<11 yrs old
11%
12-17 yrs old
21%
18-34 yrs old
42%
35-64 yrs old
5%
65+ yrs old
What do the neighbors do for fun?
Hunting
NASCAR
Monster Trucks
Where do the neighbors shop?
Academy Sports & Outdoors
Bass Pro Shops
Wal-Mart
Where do the neighbors go to eat?
Jimmy Johns
Hardee's
Applebees
What do the neighbors drive?
Chevrolet
GMC
Ram
What do the neighbors listen to?
New Country
Classic Country- Country
All data provided by Home Junction and Claritas
Similar homes for sale
#6737152, Listing office: WESTconsin Realty LLC
#6737152, James Moe, Listing office: WESTconsin Realty LLC
Frequently asked questions
About 851 174th Ave
The listing price of 851 174th Ave property is $539,000.
The property 851 174th Ave is a house located in Somerset, Wisconsin, 54017.
Active Listing: 851 174th Ave is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 851 174th Ave are: Somerset Elementary School (GreatSchools Rating 7/10), New Richmond Starr Elementary School (GreatSchools Rating 4/10), New Richmond Hillside Elementary School (GreatSchools Rating 6/10), Somerset Middle School (GreatSchools Rating 7/10), New Richmond Middle School (GreatSchools Rating 8/10), Hudson Middle School (GreatSchools Rating 6/10), Somerset High School (GreatSchools Rating 7/10), New Richmond High School (GreatSchools Rating 4/10), New Heights School Inc. (GreatSchools Rating 4/10).
The property at 851 174th Ave has 3 bedrooms and 2 bathrooms.
The property 851 174th Ave is 2,550 SqFt (source: MLS/tax record).
The year of construction for 851 174th Ave is 2003.
This home is located at 851 174th Ave in Somerset, WI and zip code 54017. This 2,550 square foot home was built in 2003. Features: 3 bedrooms, 2 bathrooms. It has been listed on Rocket Homes since July 3, 2025 and is currently priced at $539,000.
Somerset, WI housing market in June 2025 saw over 9 listings sold above listed price, more than 18 sold at listed price and over 14 sold below. Between May and June 2025, Somerset, WI real estate market has seen increase in the number of listings by 17.1%. In June 2025, listings were on the market for 54 days. During the same period, the median list price in this real estate market was $372,000.
From Rocket Homes Real Estate and based on county public records data.