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

2939 Vera Ave
Southington, OH 44470
Tony Lehman with Southington MHC Sales and Leasing LLC, original listing - (330) 898-0870

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $29,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1056 Square Feet
Agency: Southington MHC Sales and Leasing LLC
Agency Phone: (330) 898-0870

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Other-Mobile Home
Year Built: 1998
Notes: Handyman Special! Welcome home to Southington Estates nestled amidst the picturesque landscapes of Southington Ohio! Explore this 3 bedroom, 2 bathroom home located on Lot 71. This mobile home for sale has a nice sized living room, a kitchen with lots of cabinets, and includes an oven, range, and refrigerator. This home is being sold as a HANDYMAN SPECIAL... Meaning, it needs some TLC. This home comes with a large outside shed. Southington Ohio exudes a small-town charm that's utterly inviting. The historic district is a gem with its well-preserved architecture and delightful shops lining the streets. It's the perfect setting for leisurely strolls and cozy evenings out with family and friends. For those with a deep appreciation for the outdoors, Southington offers a wealth of possibilities. West Branch State Park, located nearby, provides an ideal backdrop to immerse yourself in the wonders of nature. Our residents enjoy picnics, hikes, and family gatherings, that West Branch State Park offers. Your new journey awaits at Southington Estates. Here, you'll find the comforts of mobile home living, a close-knit community, and a town that combines small town charm with the allure of the rural countryside. Engage with our warm community, explore the rich history and cultural offerings of Southington, and unlock the potential for countless adventures in this corner of Ohio. Southington Estates is more than a place to live, it's a place to belong. Welcome home to Southington Estates. Be sure to follow or Southington Facebook Social page to hear about community news and events.
MlsNumber: --
ListingId: 11452793


Listing Provided By: Southington MHC Sales and Leasing LLC, original listing
Phone: (330) 898-0870
Office Phone: (330) 898-0870
Agent Name: Tony Lehman
Disclaimer: Copyright © 2025 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