No sales currently planned

Viewing Days

Viewing date(s) & Start time(s):

Viewing by appointment only - Telephone +44 (0)1485 542 822

2024 Auction Dates:

Monday 25^th & Tuesday 26^th March 2024
(Sealed Bid closes 10:30am Thursday 4^th April)

Monday 29^th & Tuesday 30^th July 2024
(Sealed Bid closes 10:30am Thursday 8^th August)

Monday 2^nd & Tuesday 3^rd December 2024
(Sealed Bid closes 10:30am Thursday 12^th December)

Categories

SELECT rf_name, rf_lots.rf_dept, rf_first=MIN(SUBSTRING(rf_salelot,8,6)), rf_last=MAX(SUBSTRING(rf_salelot,8,6)), rf_count=COUNT(*) FROM rf_lots JOIN rf_lookups ON rf_lookups.rf_key=rf_lots.rf_dept AND rf_lookups.rf_ltype='S' WHERE rf_saleno IN (SELECT rf_sales.rf_saleno FROM rf_sales WHERE Left(rf_sales.rf_saleno, 1) <> 'X' AND rf_sales.rf_saledate >= '5/3/2025 2:58:47 PM' ) GROUP BY rf_name, rf_lots.rf_dept ORDER BY rf_nameNo categories available