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

3795 W Sycamore Beach Road
Angola, IN 46703
Christy Thomson with RE/MAX Results - Angola office, original listing - (260) 665-2414

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,475,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3707 Square Feet
Agency: RE/MAX Results - Angola office
Agency Phone: (260) 665-2414

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Start Showing Date: 4/27/2025 OPEN HOUSE SUNDAY APRIL 27, 11-1. Experience stunning panoramic views and luxurious living on the highly sought-after second basin of Crooked Lake, an 800+ acre all-sports lake known for exceptional fishing, boating, and year-round enjoyment. This nearly 4,000 sq ft modern lakefront home, remodeled in 2019, offers high-end features throughout. The open-concept main floor is accented by rich hardwood floors and expansive windows that flood the space with natural light and breathtaking water views. The gourmet kitchen is outfitted with premium Thermador appliances and showcases elegant Calacatta Gold quartz countertops with a waterfall island — perfect for entertaining. The walk-out lower level includes a spacious family room, second kitchen/wet bar, two additional bedrooms, a full bath, a dedicated workout room, storm shelter, and a bright Florida room. Outdoor living is equally impressive with a composite lakeside deck, stone patio with built-in firepit, and a concrete seawall bordering the firm sandy swimming area. A vinyl dock system is included for immediate lake access. Some fun things close, you can walk all the way around the lake and the county park is on Crooked. Office on main level has laundry attachments, you can change it back to laundry if you want main level laundry or a 2nd one. Additional features: Master en-suite with lake views, Central vacuum and irrigation system, Extensive landscaping updated in 2023, Attached garage plus 2-car garage on the back lot for boat storage and extra parking, Third lower level with generous storage space for lake toys and dock storage, 50 feet of lake frontage, “Million-dollar views” from nearly every room, This home is 99% upgraded, thoughtfully designed for comfort, style, and lakeside entertaining. Whether you're looking for a summer retreat or a year-round residence, this property is a rare find on Crooked Lake.
MlsNumber: --
ListingId: 202513841


Listing Provided By: RE/MAX Results - Angola office, original listing
Phone: (260) 316-9940
Office Phone: (260) 665-2414
Agent Name: Christy Thomson
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