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 = 1073 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 = 1073 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 = 1073 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;

6639 Peninsula Ln
Wentworth, SD 57075

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,650,000
Beds: 3
Baths: Full: 2, ¾: 1
Status: Active
SqFt: 2948 Square Feet
Agency: Coldwell Banker Empire Realty
Agency Phone: (605) 610-9848

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer, Dryer, Oven - Gas, Range - Gas
Architectural Style: Other
Construction Materials: Brick
Flooring: Carpet, Tile, Vinyl
Heating: Central Furnace
Interior Features: Wet Bar, Main Floor Laundry, Vaulted Ceiling, MASTER BATH, Lfd_equipment_13, Master Bed Main Level, 9 Ft+ Ceiling In Lwr Lvl, Pre-wired High Speed
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Dining Room, Kitchen, Laundry, Living Room, Loft

Window Features

Exterior Features: Patio, Landscaping, Covered Patio, Concrete Drive, Covered Front Porch, Shade Trees, Firepit, 3-season Porch
Patio and Porch Features: Patio, Porch
Roof: Shingle, Composition
View: Lake
Waterfront Features: Waterfront

Neighborhood/Schools

Elementary School/District: Madison ES/Norman
Middle/Junior High School/District: /Madison Central 39-2
High School/District: Madison HS/Madison Central 39-2
Subvidision Name: No Subdivision

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: This magnificent and high-end home is located on the shores of Lake Madison. Upon entering the home, it offers more than just its picturesque lakeside location. The property boasts a 63-foot lake frontage and zero maintenance - enjoy the beauty of nature without having to maintain it. Be sure to take note of the upscale appliances, quartz countertops, custom floor-to-ceiling cabinetry, a generous walk-in hidden pantry, and a bar area. The wide-open kitchen, dining, and living room concept is perfect for all your lake home entertainment and the numerous windows on the back of the house offer you a gorgeous sunset view over the lake. The rest of the main floor boasts a spacious master bedroom with an ensuite bath and walk-in closet. As you make your way outside, you are greeted with a 14x28 covered porch with an electric screen and natural gas hook-ups, as well as another concrete patio with a retaining wall and steps that lead to your private beach all beautifully lined with lights!
MlsNumber: --
ListingId: 22402350


Listing Provided By: Coldwell Banker Empire Realty, original listing
Phone: (952) 297-5625
Office Phone: (605) 610-9848
Agent Name: Carly Chambers
Disclaimer: Copyright © 2024 Realtor Association of the Sioux Empire MLS. 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 = 1073 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;
Real Estate Expert Photo for Dora Sheppard
Dora Sheppard
ASCIIKeller Williams Realty
Call Today!: (270) 205-6236

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App