800.644.1855

≡

Buy
Sell
Explore
About UsTop Navigation Control
- Team
Blog
Contact

800.644.1855

Back to search Property Details Mortgage Calculator

Street View

64 Total Photos [Click to View All]

Listing Courtesy Of:

Listing Office: MELGES Real Estate, LLC

Listing Office Phone: (262) 249-7653

4200 West End Rd Geneva, WI 53147

$2,600,000

Active / MLS# 1950492 / Commercial - Recreational / Geneva

0 Beds

8658 SqFt

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.

Property Details

Property Type: Commercial - Recreational

Basement: Crawl Space

Lot Size: 0.61 Acres

Roof Type: Composition

Stories: 2.0

Taxes: $10,220

Year Built: 1999

Feature Descriptions

Ceiling Height (AVG): 8-10

Data Source: Metro MLS

Exterior: Wood

Flood Plain: Unknown

Heating/Cooling: Central Air, Electric, Forced Air, Indiv. Heating Units, Natural Gas, Wall/Sleeve Air

Location: Free Standing

Miscellaneous: Carpeting, Fixtures, Furniture, Handicap Access, Inside Storage, Inventory Included, Living Space Avail., Outside Storage, Rec Facilities, Rest Rooms

Parking: 10.00

Proximity to Highway: 0-1 Miles

Road Frontage: High Visibility, Paved Lot, Paved Road, Town/City Road, Waterfrontage

Sale Includes: Business Name, Outbuilding(s), Real Estate, Rental Units

Truck Door Height: No Truck Door

Water/Sewer: Private Well, Septic System

Zoning: B3

Location

See details and scored characteristics about this location.

Disclaimer

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 04/02/2026. The listing information on this page last changed on 04/02/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 04/02/2026 12:23:48 AM EST) or MRED MLS (last updated Wed 04/01/2026 4:16:28 PM EST) or NIRA MLS (last updated Wed 04/01/2026 11:05:58 PM EST) or METROMLS (last updated Thu 04/02/2026 12:19:13 AM EST) or Miami MLS (last updated Thu 04/02/2026 12:18:27 AM EST) or Stellar MLS (last updated Thu 04/02/2026 12:14:02 AM EST) or SPC MLS (last updated Wed 04/01/2026 11:20:30 PM EST) or Emerald Coast MLS (last updated Thu 04/02/2026 12:05:25 AM EST) or Fort Myers (last updated Wed 04/01/2026 11:04:35 PM EST) or Beaches MLS (last updated Thu 04/02/2026 12:16:33 AM EST) or Naples MLS (last updated Wed 04/01/2026 11:40:46 PM EST) or Bonita Springs MLS (last updated Wed 04/01/2026 11:02:21 PM EST). Real estate listings held by brokerage firms other than Baird & Warner may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

Information is supplied by seller and other third parties and has not been verified.
Listing data compilation and photo(s) © 2026 – Multiple Listing Service, Inc. – All Rights Reserved .
Data Source: Metro MLS

Privacy Policy / DMCA Notice / ADA Accessibility

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 04/02/2026. The listing information on this page last changed on 04/02/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 04/02/2026 12:23:48 AM EST) or MRED MLS (last updated Wed 04/01/2026 4:16:28 PM EST) or NIRA MLS (last updated Wed 04/01/2026 11:05:58 PM EST) or METROMLS (last updated Thu 04/02/2026 12:19:13 AM EST) or Miami MLS (last updated Thu 04/02/2026 12:18:27 AM EST) or Stellar MLS (last updated Thu 04/02/2026 12:14:02 AM EST) or SPC MLS (last updated Wed 04/01/2026 11:20:30 PM EST) or Emerald Coast MLS (last updated Thu 04/02/2026 12:05:25 AM EST) or Fort Myers (last updated Wed 04/01/2026 11:04:35 PM EST) or Beaches MLS (last updated Thu 04/02/2026 12:16:33 AM EST) or Naples MLS (last updated Wed 04/01/2026 11:40:46 PM EST) or Bonita Springs MLS (last updated Wed 04/01/2026 11:02:21 PM EST) or Delta Media Group MLS (last updated Thu 04/02/2026 12:23:48 AM EST) or MRED MLS (last updated Wed 04/01/2026 4:16:28 PM EST) or NIRA MLS (last updated Wed 04/01/2026 11:05:58 PM EST) or METROMLS (last updated Thu 04/02/2026 12:19:13 AM EST) or Miami MLS (last updated Thu 04/02/2026 12:18:27 AM EST) or Stellar MLS (last updated Thu 04/02/2026 12:14:02 AM EST) or SPC MLS (last updated Wed 04/01/2026 11:20:30 PM EST) or Emerald Coast MLS (last updated Thu 04/02/2026 12:05:25 AM EST) or Fort Myers (last updated Wed 04/01/2026 11:04:35 PM EST) or Beaches MLS (last updated Thu 04/02/2026 12:16:33 AM EST) or Naples MLS (last updated Wed 04/01/2026 11:40:46 PM EST) or Bonita Springs MLS (last updated Wed 04/01/2026 11:02:21 PM EST). Real estate listings held by brokerage firms other than Baird & Warner may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

Information is supplied by seller and other third parties and has not been verified.
Listing data compilation and photo(s) © 2026 – Multiple Listing Service, Inc. – All Rights Reserved .
Data Source: Metro MLS

Privacy Policy / DMCA Notice / ADA Accessibility