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,1123,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,)"

Archived Sales - Find Auctions, Estate Sales and More!

[1 - 10 of 276]
Page of 28
[1 - 10 of 276]Page of 28
by: Bullock's Bid 'N Buy
Auction-Live
Real Estate

Absolute Real Estate Auction

Sale Complete

April 22, 2025 at 05:00 pm EDT

April 22, 2025 at 05:00 pm EDT

1124 Barkeyville Road, Grove City, Pennsylvania, United States, 16127
by: Bullock's Bid 'N Buy
Auction-Live
Collectibles, Equipment, Furniture, Tools

General Contractor Equipment, 2012 Toyota Prius V - Hybrid Synergy Drive w/82,000 On Engine (255,240 Miles on Car), Kubota B9200 4 WD w/Mohawk B-4 Brush Hog, Tools & Equipment, Furniture, Collectibles & Household.

Sale Complete

April 19, 2025 at 10:00 am EDT

April 19, 2025 at 10:00 am EDT

111 Pine Haven Road, Fenelton, Pennsylvania, United States, 16034
by: Bullock's Bid 'N Buy
Auction-Live
Antiques, Collectibles, Furniture, General

Awesome Clean Items that are located in a large house, garage and Barn. Everything will sell to the highest bidder!! "Thanks for your bid-ness".

Sale Complete

April 7, 2025 at 09:00 am EDT

April 7, 2025 at 09:00 am EDT

3611 Cardinal Drive, Sharpsville, Pennsylvania, United States, 16150
by: Bullock's Bid 'N Buy
Auction-Live
Collectibles, General, Tools, Vehicles

Estate Auction Saturday March 22 @ 10:00 A.M. 377 Fairgrounds Road Stoneboro, PA 16153

Sale Complete

March 22, 2025 at 10:00 am EDT

March 22, 2025 at 10:00 am EDT

377 Fairgrounds Road, Stoneboro, Pennsylvania, United States, 16153
by: Bullock's Bid 'N Buy
Auction-Live
General

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

Sale Complete

March 16, 2025 at 01:00 pm EDT

March 16, 2025 at 01:00 pm EDT

4635 Scrubgrass Road, Grove City, Pennsylvania, United States, 16127
by: Bullock's Bid 'N Buy
Auction-Live
Collectibles, Farm Equipment, Firearms, Tools

Large Estate Auction Saturday March 15 @ 10:00 A.M. 2848 Georgetown Road Kennerdell, PA 16374

Sale Complete

March 15, 2025 at 10:00 am EDT

March 15, 2025 at 10:00 am EDT

2848 Georgetown Road, Kennerdell, Pennsylvania, United States, 16374
by: Bullock's Bid 'N Buy
Auction-Live
General

Auction 2003 Single Wide Mansion Trailer Thursday March 13 @ 5:00 P.M. 139 Scott Wallace Road Enon Valley, PA 16120

Sale Complete

March 13, 2025 at 05:00 pm EDT

March 13, 2025 at 05:00 pm EDT

139 Scott Wallace Road, Enon Valley, Pennsylvania, United States, 16120
by: Bullock's Bid 'N Buy
Auction-Live
Antiques, Coins and Currency, Jewelry, Tools

Large Public Auction Sunday, February 23 at 1:00 PM 4635 Scrubgrass Road Grove City, PA 16127 LIVE & "In Person" Auction Early Birds Start at 12:30 Great Auction! You Do Not Want to Miss This One!

Sale Complete

February 23, 2025 at 01:00 pm EDT

February 23, 2025 at 01:00 pm EDT

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

Estate Auction Real Estate Tuesday February 18 at 5:00 PM 745 North Broad Street Extension Grove City, PA 16127

Sale Complete

February 18, 2025 at 05:00 pm EDT

February 18, 2025 at 05:00 pm EDT

745 North Broad Street Extension, Grove City, Pennsylvania, United States, 16127
by: Bullock's Bid 'N Buy
Auction-Live
General

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

Sale Complete

February 16, 2025 at 01:00 pm EDT

February 16, 2025 at 01:00 pm EDT

4635 Scrubgrass Road, Grove City, Pennsylvania, United States, 16127
[1 - 10 of 276]
Page of 28
[1 - 10 of 276]Page of 28
Log In