Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 823 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 823 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 823 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1012 Hill Street
Wahpeton, IA 51351
Josh Schaben with Keller Williams Okoboji, original listing - (712) 340-7900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,200,000
Beds: 4
Baths: Full: 2, ½: 2
Status: Active
SqFt: 5079 Square Feet
Agency: Keller Williams Okoboji
Agency Phone: (712) 340-7900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2010
Notes: Stunning Custom 4 Bed, 5 Bath Home on 50' of West Lake in Wahpeton, Iowa! Welcome to your dream home on the pristine shores of West Lake Okoboji! This custom-built masterpiece offers unparalleled luxury and modern elegance, boasting top-of-the-line features and exquisite finishes throughout. With 4 spacious bedrooms (1 non-conforming) and 5 bathrooms, this residence is designed to cater to your every need. Situated on a generous 50' of West Lake frontage, providing breathtaking views of Miller's Bay and direct access to the water; located close to local attractions, dining, and The Lakes Area entertainment. The Interior Features: Gourmet Kitchen: Equipped with state-of-the-art appliances, custom cabinetry, granite countertops, and a large center island perfect for entertaining. Elegant Living Spaces: Open-concept design with floor-to-ceiling windows, offering panoramic lake views and abundant natural light. Luxurious Primary Suite: Features a spa-like en-suite bathroom, dual vanities, and a walk-in shower. There are two generously sized guest bedrooms upstairs; each has a bathroom, providing comfort and privacy for family and guests. Exterior and Outdoor Amenities: Expansive Patio: Perfect for outdoor dining and entertaining, with stunning West Lake views and an outdoor sound system. Private Dock: Offering easy access to boating, fishing, and water sports right from your backyard. Landscaped Grounds: Professionally designed landscaping and lighting with mature trees and lush greenery, creating a serene and private oasis. The driveway and entry sidewalks have in ground heat providing a safe year round retreat. Additional Features: In home theater with a wet bar and huge projector screen in the basement makes this home the perfect spot for entertaining. Smart Home Technology: Fully integrated sound system, allowing you to control lighting, security, and climate with ease. High-End Finishes: Imported Italian tile throughout, custom millwork, and designer fixtures make this home stand out. This exceptional property combines the best of luxury living with the natural beauty of Okoboji's West Lake. Whether you are looking for a year-round residence or a seasonal retreat, this home offers the perfect blend of sophistication and tranquility. Don't miss the opportunity to own this one-of-a-kind custom home located in the highly desirable Miller's Bay on West Lake Okoboji. Schedule your private tour today and experience the finest in lakeside living!
MlsNumber: --
ListingId: 240676


Listing Provided By: Keller Williams Okoboji, original listing
Phone: (712) 330-4773
Office Phone: (712) 340-7900
Agent Name: Josh Schaben
Disclaimer: Copyright © 2024 Iowa Great Lakes Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 823 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App