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 = 746 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 746 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 746 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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;

5575 S 930 E
Wolcottville, IN 46795
Shelby Holsinger with Century 21 Bradley Realty, Inc, original listing - (260) 316-8446

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $775,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 3800 Square Feet
Agency: Century 21 Bradley Realty, Inc
Agency Phone: (260) 316-8446

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Fantastic move-in-ready home for year round lake lovers, or summertime getaways! Arguably one of the best lake views on BIG LONG LAKE! Breathtaking panoramic, “Birds Eye” views as if you were up on the perch itself! Upon entry of the home you will find a conducive layout right on the main level featuring a cozy living room, kitchen with new granite countertops and new stainless appliances, lake-view dining, main bedroom en suite on waterfront, guest bedroom and guest bathroom! Access the waterfront deck on this level through dining room or main bedroom for an unbelievable lakefront experience. Upper level features 2 more bedrooms with one overlooking the lake and a spacious “Jack & Jill” bathroom. The lower level of this home REALLY takes the cake with a 9 foot+ ceilings, a spacious second living room area with newly installed gas fireplace area with built in shelving. Large game room to the rear of the home with tons of storage. Fourth bedroom located, yet again, on the lakefront side of the home! Oversized deck on the lower level is perfect for an escape to the shade or starry night hangouts after long boat days on the water! Less than 50 steps to the waters edge where you can enjoy 60 feet of sandy lake frontage, not to mention a low maintenance concrete sea wall and newly installed rock scape on the hill. Conveniently installed drink fridge down by the water means “poppin tops” are easier than ever without having to leave the lakeshore! Deck boards on every deck and step on the property were replaced less than 2 years ago. Back lot features a 2-car garage and plenty of parking on the concrete approach on both sides of the street! Big Long Lake is a glacial made, all sports lake from sun up to sun down offering 365 acres of top ranked cleanest water in NE Indiana. Fantastic fishing all year round. Enjoy cruising on the pontoon to Shady Nook restaurant, wakeboarding, kayaking, sailing, paddleboarding, or skiing all Summer long.
MlsNumber: --
ListingId: 202511743


Listing Provided By: Century 21 Bradley Realty, Inc, original listing
Phone: (260) 367-1979
Office Phone: (260) 316-8446
Agent Name: Shelby Holsinger
Disclaimer: Copyright © 2025 Northeastern Indiana Association 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App