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

42 Ems W33 Lane
North Webster, IN 46555

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $289,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1888
Agency: TODD REALTY INC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1985
Notes: Discover this perfect retreat by the serene Tippecanoe River. This cozy 3-bedroom, 2-bathroom brick ranch home boasts a recently remodeled bathroom, a family room with a charming masonry fireplace, and a kitchen featuring two spacious pantries and brand-new flooring throughout. Enjoy the tranquility of the 322 feet of waterfront along the river, where you can watch the water flow by, try your hand at fishing, or simply unwind. The property includes a large heated 2-car garage with an attached carport, a convenient storage shed, a fenced-in yard with a dog run, and multiple patios offering both river and garden views. Please note that the gas logs in the fireplace have never been used, and the hanging heater in the garage is not functional, while the new gas wall heater provides warmth. Additionally, the brown shed by the river is sold in "as is" condition. Escape to this riverside oasis and immerse yourself in the beauty of nature!You just found the perfect retreat in this 3 BR, 2 BA(1 BA totally remodeled) brick ranch home with attached large heated 2 car garage and 1 stall carport. The family has a masonry fireplace, but the gas logs have never been used and kitchen has 2 pantries and new flooring through out! This home is nestled along side of the Tippecanoe River in North Webster. This is only 1 of 3 homes on the Lane with 322 ft of waterfront to watch the water and let the cares go by. Throw in a fishing line to catch your next meal or what ever you feel like doing or nothing at all! You have attached storage shed in back of garage, with fenced in back and side yard with a patio and dog run. On front of house you have another patio with river view!
MlsNumber: 202410886


Listing Provided By: TODD REALTY INC., original listing
Name: TODD REALTY INC.
Phone: (574) 457-4417
Office Name: ERA Crossroads
Office Phone: (574) 457-4417
Agent Name: Connie Anthony
Disclaimer: Copyright © 2024 Kosciusko Board of Realtors MLS. 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