227 Cedar Drive W, Hudson, WI 54016
$2,500,000
Property Type: Residential Bedrooms: 5 Baths: 7 Square Footage: 8,762 Lot Size (sq. ft.): 473,933 Status: Closed
Current Price: $2,500,000 List Date: 6/17/2024 Last Modified: 8/08/2025
Overview
Description
Listing Details MLS# 6450040
General Property Information
- Association Fee Frequency
- Annually
- Common Wall
- No
- Lot Measurement
- Acres
- Manufactured Home?
- No
- Multiple PIDs?
- Yes
- New Development
- No
- Number of Fireplaces
- 5
- Road Btwn WF & Home?
- No
- Waterfront Frontage
- 325
- Waterfront YN
- Yes
- Year Built
- 2005
- Yearly/Seasonal
- Yearly
- Zoning
- Residential-Single Family
- Bath Full
- 2
- Bath Three Quarters
- 3
- Bath Half
- 2
- Main Floor Total SqFt
- 1587
- Above Grd Total SqFt
- 2275
- Below Grd Total SqFt
- 6487
- Total SqFt
- 8762
- Total Finished Sqft
- 8762.00
- FireplaceYN
- Yes
- Lake/Waterfront Name
- St. Croix River
- Style
- (SF) Single Family
- Foundation Size
- 3551
- Garage Stalls
- 4
- Lot Dimensions
- 1106x292x1001x237
- Acres
- 10.88
Property Features
Accessible: Accessible Elevator Installed Air Conditioning: Central Air Amenities Unit: Deck; Dock; Hardwood Floors; In-Ground Sprinkler; Patio; Porch; Security System; Tennis Court; Tile Floors; Vaulted Ceiling(s); Walk-In Closet; Washer/Dryer Hookup Appliances: Air-To-Air Exchanger; Central Vacuum; Cooktop; Dishwasher; Disposal; Dryer; Electronic Air Filter; Freezer; Microwave; Refrigerator; Washer Basement: Drain Tiled; Egress Windows; Full; Sump Pump Construction Status: Previously Owned Dining Room Description: Breakfast Area; Informal Dining Room; Separate/Formal Dining Room Electric: Circuit Breakers Elevation Highpoint to Waterfront Slope: Gradual Exterior: Brick/Stone; Cement Board Family Room Characteristics: Entertainment/Media Center; Lower Level Financing Terms: Conventional Fireplace Characteristics: Family Room; Gas Burning; Living Room; Primary Bedroom; Other Foundation: Poured Concrete Fuel: Natural Gas Heating: Forced Air; In-Floor Heating Lake Details: Sand Lock Box Type: Supra Parking Characteristics: Garage Door Opener; Heated Garage; Insulated Garage; Secured Pool Description: Below Ground; Heated Roof: Age Over 8 Years; Pitched; Shake Sewer: Private Sewer; Tank with Drainage Field Special Search: 3 BR on One Level; Main Floor Bedroom; Main Floor Laundry Stories: Bi-Level Water: Well Waterfront View: Panoramic; South
Contract Information
- Off Market Date
- 2024-06-17
- Contingency
- None
- Closed Date
- 2024-06-17
- Original List Price
- 2850000
- Sales Close Price
- 2500000
- ListPrice
- 2500000
- Owner is an Agent?
- No
- Auction?
- No
Location Tax and Other Information
- House Number
- 227
- Street Name
- Cedar
- Street Suffix
- Drive
- Street Direction Suffix
- W
- Postal City
- Hudson
- County
- St. Croix
- State
- WI
- Zip Code
- 54016
- Complex/Dev/Subdivision
- St Joseph
Additional Parcels Information
- Property ID #2
- 030202160000
- Property ID #3
- 030202140000
Assessments
- Tax With Assessments
- 51599
More Information
Building Information
- Finished SqFt Above Ground
- 2275
- Finished SqFt Below Ground
- 6487
Elevation Highpoint to Waterfront Feet
- Elevation Highpoint Waterfront Feet
- 26-40
Lease Details
- Land Leased
- Not Applicable
Miscellaneous Information
- Homestead
- Yes
Ownership
- Fractional Ownership
- No
Parking Characteristics
- Garage Square Feet
- 800
Public Survey Info
- Range#
- 20W
- Section#
- 01
- Township#
- 29N
Room Information
| Room Name | Dimensions | Level |
|---|---|---|
| Family Room | 22x28 | Lower |
| Dining Room | 16x18 | Main |
| First (1st) Bedroom | 12x19 | Main |
| Kitchen | 19x20 | Main |
| Living Room | Main | |
| Laundry | 10x14 | Main |
| Great Room | 19x22 | Main |
| Media Room | 26x36 | Lower |
| Third (3rd) Bedroom | 12x17 | Lower |
| Second (2nd) Bedroom | 18x20 | Main |
| Fifth (5th) Bedroom | 12x17 | Lower |
| Fourth (4th) Bedroom | 12x17 | Lower |
| Billiard Room | 20x22 | Lower |
Listing Office: Keller Williams Select Realty
Last Updated: August - 08 - 2025
The data relating to real estate for sale on this web site comes in part from the Broker
Reciprocity SM Program of the Regional Multiple Listing Service of Minnesota, Inc. The information provided is deemed reliable but not guaranteed. Properties subject to prior sale, change or withdrawal.
©2026 Regional Multiple Listing Service of Minnesota, Inc All rights reserved.