Services Category Listings in Deira

Services - Doctors

Minha Dental Clinic- Deira, Dubai

Dubai, UNITED ARAB EMIRATES

₹ 0

View

Services - Business Offers

UPVC Pipes & Fittings Traders In UAE | UPVC Fittings

Abu Hail , Deira, UNITED ARAB EMIRATES

₹ 502,090

View

SELECT l.id,l.category,l.subcategory,l.transaction_type,l.title, NULLIF(TRIM(l.city),'') city, NULLIF(TRIM(l.state),'') state, NULLIF(TRIM(l.country),'') country, l.currency,l.price,l.pkg,l.pmt_cpn, l.updated_at, 'listings' src, adstatus :==: WHERE l.status='verified' AND (l.city LIKE '%Deira%' OR l.state LIKE '%Deira%') AND l.category LIKE '%Services%' ORDER BY l.pmt_cpn DESC, l.updated_at DESC LIMIT 27 OFFSET 27 /:==:/ SELECT id,category,'' subcategory,'' transaction_type, pprovince title, pcity city,'' state,pcountry country, '' currency, price,pkg,pmt_cpn, updated_at, 'classifieds' src, adstatus, imglnk_0,imglnk_1,imglnk_2,imglnk_3,imglnk_4,imglnk_5 :==: WHERE adstatus NOT IN (0,9) AND (pcity LIKE '%Deira%' OR pprovince LIKE '%Deira%') AND category LIKE '%Services%' ORDER BY pmt_cpn DESC, updated_at DESC LIMIT 27 OFFSET 27