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;

117 N Woodruff Road
Wolcottville, IN 46795-9411
Dominic Jackson with Hosler Realty Inc - Kendallville, original listing - (260) 347-1158

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $330,000
Beds: 4
Baths: Full: 2, ½: 2
Status: Active
SqFt: 2970 Square Feet
Agency: Hosler Realty Inc - Kendallville
Agency Phone: (260) 347-1158

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Charming 4-Bedroom Home with Spacious Lot and Endless Potential! Welcome to your dream home! This stunning 4-bedroom, 2-full bath, and 2-half bath residence is nestled on a half-acre lot, offering both space and tranquility. With 2,970 square feet of thoughtfully designed living space, this property is perfect for anyone looking to make it their own. Step inside to discover a warm and inviting open floor plan that seamlessly connects the living, dining, and kitchen areas. The well-appointed kitchen is ideal for culinary enthusiasts, featuring ample counter space and modern appliances. Two of the spacious bedrooms are complete with their own private bathrooms, providing a perfect retreat for family members or guests. The additional bedrooms are versatile and can easily accommodate your lifestyle needs. A bonus room offers the ideal space for a home office, playroom, or additional guest area, ensuring you have all the flexibility you need. The full basement, spanning over 2,800 square feet, presents a blank canvas with limitless potential. Whether you envision creating a cozy family room, a personal gym, or simply need extra storage space, this basement is ready for your personal touch. Outside, enjoy the expansive half-acre lot, perfect for outdoor activities, gardening, or simply relaxing in the fresh air. Don’t miss out on this incredible opportunity to own a spacious home that combines comfort, functionality, and the potential for customization!
MlsNumber: --
ListingId: 202444633


Listing Provided By: Hosler Realty Inc - Kendallville, original listing
Phone: (260) 446-7650
Office Phone: (260) 347-1158
Agent Name: Dominic Jackson
Disclaimer: Copyright © 2024 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