SELECT profiles.id, profiles.catgory_id,profiles.address, profiles.profileaccount, profiles.subcat_id, profiles.company_name, profiles.pincode, profiles.phone, profiles.seo_url, profiles.mobile, profiles.fax, profiles.email, profiles.website,profiles.statecountry, profiles.smallbanner, profiles.bigbanner, profiles.shortdescription, profiles.website, area.name as area ,city.name as city FROM profiles INNER JOIN city ON city.id = profiles.city INNER JOIN area ON area.id = profiles.area WHERE (profiles.city="1" OR profiles.mulcity LIKE "%~1~%" ) && profiles.is_delete!=1 && profiles.status=1 && (profiles.d_mc_id="606" || profiles.catgory_id LIKE "%,606,%") ORDER BY profiles.profileaccount DESC, profiles.priority DESC limit 0 , 20
  • Useit Yellow Pages
  • Useit Yellow Pages
  • Useit Yellow Pages
Add US

EQUIPMENTS AND PRODUCTS In madurai

Listing Search Results

Found 88 records

  • 1
  • 2
  • 3
  • 4
  • 5
  • Total 88 records found

SEND SMS / E-Mail

Related Category

Popular Search Categories

Follow on Facebook

useit yellowpages madurai