Title Page Background
DEBUG FN args: Array ( [0] => 2115 [1] => [2] => [3] => agent ) BEFORE: Site: 2115 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2115 Igate: njhud LocID: 2115 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2115 [1] => [2] => [3] => lender ) BEFORE: Site: 2115 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2115 Igate: njhud LocID: 2115 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2115 [1] => [2] => [3] => other ) BEFORE: Site: 2115 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2115 Igate: njhud LocID: 2115 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1415 Southern Blvd Nw
Warren, OH 44485
Brian Brockman with Williams & Williams Real Estate Auctions, original listing - (800) 801-8003

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $50,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 988 Square Feet
Agency: Williams & Williams Real Estate Auctions
Agency Phone: (800) 801-8003

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1960
Notes: •Property is being sold in an "as is" condition, and the condition is unknown and may include defects, possible health or safety hazards, or debris, or be located in a Special Flood Hazard Area. •Proof of Funds Required. The seller requires that the high bidder be able to demonstrate proof of funds or financing pre-qualification within 24 hours of the auction. Buyer must obtain a "pre-qualification" letter from a lender of their choice. If buyer intends to pay with cash, a bank letter or other financial account statement showing proof of sufficient funds to cover 100% of the purchase price will be required (account numbers should be removed or redacted). Buyer understands and agrees to submit said documentation to auctioneer within 24 hours of the auction. • Utilities Disclosure. The utilities to this property are not currently "turned on" and the property has been winterized. Utilities will not be turned prior to closing, regardless of inspections. Buyer will need to consider this and account for it if/when inspecting the property. Buyer is responsible for utility transfer post-closing. · Square Footage/Acreage Disclosure. The source of the square footage or acreage represented for the property is from public record. Buyer understands and acknowledges that square footage or acreage measurements of a property can vary from a few feet to several hundred feet regardless of source (County Assessor's records, appraisal or appraisal measurement report, survey, etc.). Buyer shall be solely responsible for satisfying that the size and/or square footage or acreage of the property is acceptable to the Buyer. Septic Inspection Disclosure. The Property may be subject to a Trumbull County septic inspection. Buyer understands that if the inspection is required, it will be ordered, and Buyer will receive a copy of the inspection report prior to closing. Buyer agrees to comply with all requirements necessary to complete said inspection and any necessary remediation, including, but not limited to, obtaining the necessary permits and making arrangements to correct any noted city/county violations at Buyer's expense. Buyer agrees that any and all violations will be repaired within 60 days of closing. Buyer should conduct an investigation into cost of compliance with septic requirements prior to bidding.
MlsNumber: --
ListingId: 11361614


Listing Provided By: Williams & Williams Real Estate Auctions, original listing
Phone: (800) 801-8003
Office Phone: (800) 801-8003
Agent Name: Brian Brockman
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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => trumbull [3] => OH [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: trumbull State: OH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: trumbull State: OH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('ohhud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Timothy Simmons
Timothy Simmons
ASCIIeXp Realty LLC
Call Today!: (330) 676-2208

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App