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="3" || profiles.catgory_id LIKE "%,3,%") ORDER BY profiles.profileaccount DESC, profiles.priority DESC limit 0 , 20
  • Useit Yellow Pages
  • Useit Yellow Pages
  • Useit Yellow Pages
Add US

AUTOMOBILES In madurai

Listing Search Results

Found 1030 records

  • 1
  • 2
  • 3
  • 4
  • 5
  • ...
  • 52
  • Total 1030 records found

SEND SMS / E-Mail

Related Category

Popular Search Categories

Follow on Facebook

useit yellowpages madurai