INBOUND L1:0 L2:10 Primary Category:(2644)Premium Listing Activation Pending: (0) (10)
L1:0 PC:2
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 (2644) WHERE (l.product_id=1) ORDER BY 'claimed' DESC, zapscore DESC) s)p WHERE position >=0 LIMIT 10
No Results from PQ
Remainder:8
bool(true) Interior Decorators & Designers

Interior Decorators & Designers



Geranium Street Floral

133 Newport Dr, Ste G, San Marcos CA 92069

(760) 798-2316

49

Seura Inc

1230 Ontario Rd, Green Bay WI 54311

(920) 857-9069

48

June DeLugas Interiors Inc

2575 Old Glory Rd, Ste 100, Clemmons NC 27012

(336) 778-1030

48

Model My Home

3235 Skylane Dr, Ste 127, Carrollton TX 75006

(972) 733-3435

47

Boston Design Guide

348 Boston Post Rd, Ste 4, Sudbury MA 01776

(978) 443-9886

47

Martha Stewart Omnimedia

20 W 43rd St, New York NY 10036

(212) 827-8000

47

Decorating Den Interiors

13455 Malaki Rd, Ste 2B, Apple Valley CA 92308

(760) 247-5393

46

O'rourke Bryan

799 Broadway, New York NY 10003

(212) 674-6600

45

Housetrends

6423 Rigsby Rd, Richmond VA 23226

(804) 237-7623

45

Deziner Tonie & Associates, Decorating Den Interiors

1050 Nevada St, Ste 402, Redlands CA 92374

(760) 200-5881

44