6,213 visitors today 7 antiques added today
Choose an antique category
Buy Now With

Dealers with the most listings for Antique Stick Stands

SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY sellingstatus ASC, the_rotate DESC,date_modified DESC) AS RowNum,* FROM antiquesforsale WITH (NOEXPAND) WHERE CONTAINS(theindex, ' ( FORMSOF(INFLECTIONAL, miscellaneous) AND FORMSOF(INFLECTIONAL, stick) AND FORMSOF(INFLECTIONAL, stand) ) ') AND newcat = 'miscellaneous' AND price BETWEEN 100 AND 250000 ) AS SOD WHERE SOD.RowNum between 49 AND 96