SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 9 with query: "SELECT li.id, li.state, li.city, li.sale_type, (SELECT name FROM listings_sale_type WHERE id = li.sale_type) AS sale_name, (SELECT GROUP_CONCAT(id ORDER BY name ASC SEPARATOR "###") FROM listings_categories_master WHERE id IN (SELECT category_id FROM listings_category WHERE listing_id = li.id )) AS category_id, (SELECT GROUP_CONCAT(name ORDER BY name ASC SEPARATOR "###") FROM listings_categories_master WHERE id IN (SELECT category_id FROM listings_category WHERE listing_id = li.id )) AS category, (SELECT name FROM directories_location_3 WHERE id = li.state) AS state_name, (SELECT name FROM directories_location_4 WHERE id = li.city) AS city_name FROM listings AS li WHERE li.id IN (48,49,51,53,54,58,62,63,65,66,67,93,98,99,105,106,107,113,144,146,178,193,194,195,199,205,210,211,212,214,218,227,250,251,288,351,352,353,360,361,422,447,448,457,458,470,477,519,520,569,570,571,705,706,707,730,770,790,808,821,870,886,889,890,913,927,928,937,938,955,994,997,1025,1032,1033,1042,1088,1108,1109,1122,1154,1156,1178,1184,1185,1198,1199,1200,1223,1235,1236,1237,1246,1258,1275,1289,1296,1297,1299,1301,1302,1308,1315,1319,1321,1322,1329,1342,1343,1345,1346,1351,1354,1355,1356,1357,1363,1369,1370,1389,1392,1404,1438,1444,1445,1452,1458,1461,1463,1468,1502,1503,1505,1506,1509,1519,1520,1528,1533,1537,1540,1541,1542,1551,1552,1558,1567,1569,1576,1577,1581,1582,1583,1609,1635,1644,1645,1646,1650,1658,1659,1660,1669,1670,1671,1677,1678,1698,1699,1700,1709,1718,1719,1720,1721,1746,1747,1748,1749,1750,1764,1765,1828,1829,1831,1832,1833,1834,1841,1849,1850,1851,1852,1859,1860,1885,1886,1887,1888,1889,1914,1915,1916,1917,1939,1949,1950,1951,1958,1959,1960,1961,1968,1973,1974,1975,1980,1986,1987,1988,1989,2015,)"

Archived Sales - Find Auctions, Estate Sales and More!

[1 - 10 of 262]
Page of 27
[1 - 10 of 262]Page of 27
by: Bullock's Bid 'N Buy
Auction-Live
General

New Merchandise & Food Auction Sunday November 17 @ 1:00 PM 4635 Scrubgrass Road Grove City, PA 16127

Sale Complete

November 17, 2024 at 01:00 pm EST

November 17, 2024 at 01:00 pm EST

4635 Scrubgrass Road, Grove City, Pennsylvania, United States, 16127
by: Bullock's Bid 'N Buy
Auction-Live
Real Estate

Absolute Real Estate Auction Saturday November 16 @ 9:00 A.M. 2214 Big Bend Road Emlenton, PA 16373

Sale Complete

November 16, 2024 at 09:00 am EST

November 16, 2024 at 09:00 am EST

2214 Big Bend Road, Emlenton, Pennsylvania, United States, 16373
by: Bullock's Bid 'N Buy
Auction-Live
Collectibles, Real Estate, Tools, Vehicles

Estate Auction Real Estate & Contents Saturday November 16 @ 10:00 A.M. 489 Stone Church Road Emlenton, PA 16373

Sale Complete

November 16, 2024 at 10:00 am EST

November 16, 2024 at 10:00 am EST

489 Stone Church Road, Emlenton, Pennsylvania, United States, 16373
by: Bullock's Bid 'N Buy
Auction-Live
Collectibles, General, Real Estate, Tools

Living Estate Auction Real Estate & Contents Saturday Nov 2 @ 10:00 AM 149 Hazelnut Road Chicora, PA 16025

Sale Complete

November 2, 2024 at 10:00 am EST

November 2, 2024 at 10:00 am EST

149 Hazelnut Road, Chicora, Pennsylvania, United States, 16025
by: Bullock's Bid 'N Buy
Auction-Live
Collectibles, General, Real Estate, Tools

Estate Auction Real Estate & Contents Saturday September 28 at 10:00 AM 207 Martin Avenue Ellwood City, PA 16117

Sale Complete

September 28, 2024 at 10:00 am EST

September 28, 2024 at 10:00 am EST

207 Martin Ave, Ellwood City, Pennsylvania, United States, 16117
by: United Country Richardson Real Estate and Auction, Inc.
Auction-Live
Antiques, Collectibles, Real Estate, Vehicles

Selling the real estate and personal property of Dale H & Susan R Miller Auction Day: Saturday, September 21st 9am Event you don’t want to miss! Inspection Day: Friday, Sept 13th 1pm to 5pm

Sale Complete

September 21, 2024 at 09:00 am CST

September 21, 2024 at 09:00 am CST

235 Coleman Rd, Linden, Tennessee, United States, 37096
by: Bullock's Bid 'N Buy
Auction-Live
Collectibles, Furniture, Real Estate, Tools

ABSOLUTE REAL ESTATE & CONTENTS Thursday September 19 @ 4:00 P.M. 1211 Savannah Road New Castle, PA 16101

Sale Complete

September 19, 2024 at 04:00 pm EST

September 19, 2024 at 04:00 pm EST

1211 Savannah Road, New Castle, Pennsylvania, United States, 16101
by: Bullock's Bid 'N Buy
Auction-Live
General

New Merchandise & Food Auction Sunday September 15 @ 1:00 PM 4635 Scrubgrass Road Grove City, PA 16127

Sale Complete

September 15, 2024 at 01:00 pm EST

September 15, 2024 at 01:00 pm EST

4635 Scrubgrass Road, Grove City, Pennsylvania, United States, 16127
by: Bullock's Bid 'N Buy
Auction-Live
Collectibles, General, Real Estate, Tools

Estate Auction Real Estate & Contents Saturday September 14 @ 10:00 A.M. 642 East Main Street Extension Grove City, PA 16127

Sale Complete

September 14, 2024 at 10:00 am EST

September 14, 2024 at 10:00 am EST

642 East Main Street Extension, Pennsylvania, United States, 16127
by: Bullock's Bid 'N Buy
Auction-Live
Real Estate

Real Estate Auction Tuesday September 10 @ 5:00 P.M. 529 North Center Street Grove City, PA 16127

Sale Complete

September 10, 2024 at 05:00 pm EST

September 10, 2024 at 05:00 pm EST

529 North Center Street, Grove City, Pennsylvania, United States, 16127
[1 - 10 of 262]
Page of 27
[1 - 10 of 262]Page of 27
Log In