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

223 North Water Street
Caledonia, OH 43314
Devon Heacock with RES Auction Services, original listing - (833) 765-3737

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: RES Auction Services
Agency Phone: (833) 765-3737

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Absolute Faulkner Real Estate & Personal Property Auction Tuesday, November 12th Personal Property @ 3 PM Cars @ 4:45 PM | Real Estate @ 5PM 2-Story Home - 3 Vehicles - Two Car Garage Live Auction w/ Online Bidding For Cars & Real Estate @ RES.bid Auction will be held onsite located at 223 North Water Street, Caledonia, OH. From Marion, head East on St Rt 309, then North on Water Street. Watch for RES Signs. Real Estate:Selling a 2-story home with classic charm in a small-town setting. This dated 2-story, 3-bedroom, 1-bath home offers timeless appeal and endless potential. Nestled on a 0.25-acre lot in a charming small town, the 1,474 square-foot property features an original woodwork staircase that serves as a beautiful focal point, adding character throughout. The first-floor primary bedroom provides convenience, while the spacious bathroom offers room for future updates and customization. A bright sunroom is perfect for bringing natural light into the home, creating a cozy spot for morning coffee. Outside, you'll find a peaceful shaded sitting area, a two-car garage, and a shed-ideal for extra storage or workspace. If you're looking for a home with classic features and plenty of potential, this property combines small-town living with opportunities for modern upgrades. Open House: The home will be open for inspection on Sunday, November 3rd 4:00 to 6:00PM. For private showings call. Taxes & Legal:Marion County Parcel Number 050050004200. Located in River Valley School District and Claridon Twp. The current annual taxes are $1,120.02. Terms:The Successful purchaser will be required to make a nonrefundable down payment of 10% at the conclusion of the auction with the balance due at closing within 45 days. A 10% buyers premium will be added to the final bid to determine the purchase price. All desired inspections need to be completed prior to the bidding.
MlsNumber: --
ListingId: 11355667


Listing Provided By: RES Auction Services, original listing
Phone: (330) 845-4411
Office Phone: (833) 765-3737
Agent Name: Devon Heacock
Disclaimer: Copyright © 2024 My State 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