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

9125 Heffelfinger Road
Churubusco, IN 46723
Zelda Mayers with CENTURY 21 Bradley Realty, Inc, original listing - (260) 399-1177

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $329,900
Beds: 3
Baths: Full: 1, ½: 2
Status: Active
SqFt: 1728 Square Feet
Agency: CENTURY 21 Bradley Realty, Inc
Agency Phone: (260) 399-1177

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1976
Notes: Welcome to your serene country retreat, a charming 3 bedroom, 1 full and 2 half bath home that perfectly blends comfort and tranquility. This This beautiful home has an inviting front porch, which is perfect for drinking your morning coffee, Inside you'll find a large updated family room that just feels like country living. Off the living room you'll find a very large eat in kitchen, with so many updates like new cabinets, new appliance, new backsplash to name a few. You'll also find a really large room that I have listed as a living room, but would make a nice formal dining room as well. Upstairs you'll find a large master bedroom with a half bath, and a large walk in closet. Rounding out the upstairs are two additional nice sized bedrooms, with large closets, a newly updated full bath, and plenty of storage closets. Outside you'll find a nice 2 1/2 car detached garage, but it's a two car garage, and a section has been remodeled to be an office/work from home space, currently it's an office/dog grooming facility, so the possibilities are endless for this space. If all of that's not enough, this home sits on almost 1 1/2 acres, with a picturesque view which gives both privacy and easy to nature, making it a perfect haven for those seeking quiet country living. You'll also find a cherry tree, 2 apple trees, and a peach tree. You'll also find blackberry, blueberry, raspberry, and strawberry bushes. Some of the update include, but are not limited to New metal Roof in 2023 All bathrooms updated in 2023, New updated baseboard heaters 2023. The garage office/work from home space 2024. Although this home has electric baseboard heat it does have central air. Experience the charm of country life in this delightful property, which is in NWA Schools. This home is a must see!
MlsNumber: --
ListingId: 202438688


Listing Provided By: CENTURY 21 Bradley Realty, Inc, original listing
Phone: (260) 409-8505
Office Phone: (260) 399-1177
Agent Name: Zelda Mayers
Disclaimer: Copyright © 2024 Upstate Alliance of REALTORS® Multiple Listing Service, Inc. 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