Date
Details
Price
Change
Source
2/15/2026
Listed
$2,600,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/64
$2,600,000 Just Listed
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/64
Property Description
Sand Hill Inn is a rare luxury lakefront retreat on Lake Como, just minutes from downtown Lake Geneva. Set on 129 feet of shoreline, this stunning property offers 10 upscale suites, each with a fireplace, jacuzzi, and private bath, plus a charming lake view cottage with 2 suites. The main inn features inviting gathering spaces, a breakfast kitchen and double-sided fireplace, The Inn is ideal for weddings, retreats and events. Thoughtfully designed for personal or STR business operations, Sand Hill Inn is an exceptional opportunity for a rare unforgettable lakeside destination.
Full Property Details
Full Property Details for 4200 West End Rd
General
- Price: $2,600,000
- Taxes: $10,220 (2024)
- Status: Active
- Type: Commercial Recreational
- Source: MetroMLS_Milwaukee_Wirex
- MLS ID: 1950492
- Updated: Today (2/15/2026)
- Added to Site: Today
Additional Information
- Other Features: Carpeting, Fixtures, Furniture, Handicap Access, Inside Storage, Inventory Included, Living Space Available, Outside Storage, Recreational Facilities, Restrooms
Parking
- Total Spaces: 10
Location
- Municipality: Town
- County: Walworth
- Driving Directions: Hwy 50 West from Lake Geneva. Turn right on Red Chimney Rd. Go to end of road into parking lot.
- Dist. to Freeway: Less than 1 Mile
- Location Details: Freestanding
Heating & Cooling
- Heating/Cooling: Central Air Conditioning, Electric, Forced Air, Individual Heating Units, Natural Gas, Wall Air Conditioning
Utilities
- Water/Sewer: Private Well, Septic System
Structural Information
- Structure Type: Recreation
- Exterior Const.: Wood
- Basement Desc.: Crawl Space
- Roof: Composition
- Ceiling Height: 8 to 10 Feet
- Drive-In Clearance: No Truck Door
- Stories Description: 2
- Square Feet: 8,658
- Year Built: 1999
Lot Features
- Lot Size (Acres): 0.61
- Frontage: High Visibility, Paved Lot, Paved Road, Town/City Road, Waterfrontage
- Zoning: B3
Financial Considerations
- For Sale/Rent/Lease: For Sale Only
- Tax Amount: $10,220
- Tax Year: 2024
Listed by MELGES Real Estate, LLC
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 4200 West End Rd —
MELGES Real Estate, LLC
NMLS#: 1598647
Get Pre-Approved Today
Get a Great Insurance Rate
Schools
Schools serving 4200 West End Rd
School District:Williams Bay School District
| Name | Grades | Distance |
|---|---|---|
Williams Bay Elementary School 250 Theatre Road, Williams Bay, WI 53191 | PK-5 | 3 mi |
Williams Bay Junior High School 500 West Geneva Street, Williams Bay, WI 53191 | 6-8 | 3.1 mi |
Williams Bay High School 500 West Geneva Street, Williams Bay, WI 53191 | 9-12 | 3.1 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 4200 West End Rd
Estimate the Cost
Estimate the Cost for 4200 West End Rd
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 16 hours ago
- 1Bed
- 1Total Bath
- 640Sq. Ft.
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 3Total Baths
- 2,408Sq. Ft.
- Single Family
- Active
- Updated 5 days ago
- 3Beds
- 4Total Baths
- 2,444Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 3 days ago
- 3Beds
- 1Total Bath
- 1,556Sq. Ft.
- Single Family
- Active
- Updated 3 days ago
- 2Beds
- 2Total Baths
- 942Sq. Ft.
- Condo
- Active
- Updated 5 days ago
- 2Beds
- 2Total Baths
- 1,137Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- Updated 13 days ago
- 5Beds
- 6Total Baths
- 5,946Sq. Ft.
4200 West End Rd, Geneva, WI 53147 (MLS# 1950492) is a Commercial Recreational property. 4200 West End Rd is currently listed for $2,600,000 and was received on February 15, 2026. Want to learn more about 4200 West End Rd? Do you have questions about finding other Commercial Recreational real estate for sale in Geneva? You can browse all Geneva real estate or contact a Coldwell Banker agent to request more information.