INBOUND L1:0 L2:10 Primary Category:(2240)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 (2240) 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) Mobile Home Parks & Communities

Mobile Home Parks & Communities



46

Calistoga Springs

45 Magnolia Dr, Calistoga CA 94515

(707) 942-6294

45

Town & Country Mobile Village

195 Blossom Hill Rd, San Jose CA 95123

(408) 225-3165

44

Highline Park

31813 21st Ave SW, Federal Way WA 98023

(253) 838-2069

34

Fairplex Trailer Park

1101 W Mckinley Ave, Pomona CA 91768

(909) 622-8577

34

Carousel Ranch

4315 N Flowing Wells Rd, Unit 96, Tucson AZ 85705

(520) 887-2050

33

Western Acres Mobile Park

9913 E Main St, Mesa AZ 85207

(480) 986-1158

32

Vineyard Estates

3263 Vineyard Ave, Pleasanton CA 94566

(925) 846-5336

32

Paradise Park

1108 S Lake Arthur Ave, # OFC, Jennings LA 70546

(337) 824-0312

31

Ventura Marina Mobile Home Park

1215 Anchors Way Dr, Ventura CA 93001

(805) 642-1553

31