INBOUND L1:0 L2:10 Primary Category:(969)Premium Listing Activation Pending: (0) (10)
L1:0 PC:1
SELECT * FROM (SELECT @myRow := ifnull(@myRow,-2) + 1 as position, s.* FROM (SELECT DISTINCT l.* FROM pmd_listings l INNER JOIN pmd_listings_categories c ON l.id=c.list_id AND c.cat_id IN (969) WHERE (l.product_id=1) ORDER BY 'claimed' DESC, zapscore DESC) s)p WHERE position >=0 LIMIT 10
No Results from PQ
Remainder:9
bool(true) Antique Dealers

Antique Dealers



Esmaili Rugs and Antique

1500 Hi Line Dr, Dallas TX 75207

(214) 651-7847

51

Random House

12 W State St, Athens OH 45701

(740) 592-2464

51

American Crafts

10629 Courthouse Rd, Fredericksburg VA 22407

(540) 898-2327

50

Crompton Collective

138 Green St, Worcester MA 01604

(508) 753-7303

49

Eron Johnson Antiques

389 S Lipan St, Denver CO 80223

(303) 777-8700

48

Debra's Antiques & Collectibles

265 Station Dr, Martinsville VA 24112

(276) 957-1394

47

Memory Lane

801 Strong Ave, Ballinger TX 76821

(325) 365-3286

47

Kendall Wilkinson Design

3419 Sacramento St, San Francisco CA 94118

(415) 409-2299

46

Eurolux Antiques

14673 C R Koon Hwy, Newberry SC 29108

(803) 276-4001

45

Antiques On Jackson

1028 Jackson Ave, New Orleans LA 70130

(504) 524-8201

45