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="18" OR profiles.mulcity LIKE "%~18~%" ) && profiles.is_delete!=1 && profiles.status=1 && (profiles.d_sc_id="204" || profiles.subcat_id LIKE "%,204,%") ORDER BY profiles.profileaccount DESC, profiles.priority DESC limit 0 , 20
Current City :
Madurai Karaikudi Ramanathapuram Dindigul Theni Virudhunagar Chennai Coimbatore Trichy Pudukkottai Erode Karur Karaikal Thanjavur Mayiladuthurai Sivakasi Sivagangai Tirunelveli Kanyakumari Salem Pondicherry Kodaikanal Thiruvarur Kumbakonam Tuticorin Hosur Nagercoil Thirumangalam-Madurai Nagapattinam Perambalur Cuddalore Villupuram Vellore Tiruppur Namakkal Tenkasi Rajapalayam Srivilliputhur Aruppukkottai Rameshwaram Paramakudi Tirupathur Thirumayam Devakottai Kamuthi Pattukottai Tiruvannamalai Tirukoilur Peravurani Aranthangi Mannargudi Vedaranyam Thiruthuraipoondi Chidambaram Virudhachalam Neyveli Sethiyathope Kallakurichi Ulundurpettai Attur Sankagiri Krishnagiri Vaniyambadi Ooty Thiruttani Kanchipuram Mahabalipuram Chengalpattu Sriperumbudur Ranipet Tiruvallur Avadi Arcot Gummidipoondi Gudiyatham Aarani Batlagundu Nilakkottai Oddanchathiram Palani Dharapuram Chinnamanur Kaveripattinam Sengottai Mettur Bhavani Edappadi Gobichettipalayam Perundurai Mettupalayam Sathyamangalam Kotagiri Coonoor Kumily Periyakulam Bodinayakkanur Tiruchengode Avinashi Rasipuram Pollachi Udumalaipettai Palapatti Palladam Lalgudi Thuraiyur Kulithalai Ariyalur Jayankondam Jolarpettai Sholinghur Chinnasalem Musiri Manapparai Natham Thondi Devipattinam Vilathikulam Ettayapuram Sankarankovil Nanguneri Valliyur Kudankulam Colachel Mandapam Ottapidaram ParamathiVelur Dharmapuri Marthandam Avadi-Chennai Cumbum Usilampatti Andipatti Sattur Melur Manamadurai Vadamadurai
Listing Search Results
Found 10 records
Kulathur Village, Trichy,
Dindigul Road
- Trichy , Tamilnadu, India - 621303.
Campus 1 30/1 1st Floor Royal City Tower, Above Yamaha Showroom,
Chathiram Bus Stand
- Trichy , Tamilnadu, India - 620002.
Siruganur, Trichy To Chennai Trunk Road,,
Srirangam
- Trichy , Tamilnadu, India - 621105.
Panjapur, Venkateshwara Nagar,
Tiruchirappalli H.O
- Trichy , Tamilnadu, India - 620001.
Pirattiyur,
Ramjeenagar
- Trichy , Tamilnadu, India - 620009.
Near Malaikottai Tholurpatti P O, Namakkal Trichy Main Road,,
Thottiyam
- Trichy , Tamilnadu, India - 621215.
Highway Road,
Industrial Colony
- Trichy , Tamilnadu, India - 620010.
Main Road,
Tiruchirappalli H.O
- Trichy , Tamilnadu, India - 620001.
No 4, Kallukuzhi Main Road,
Mannarpuram
- Trichy , Tamilnadu, India - 620020.
Opposite Thuvakkudi Bus Stand,
Thuvakkudi
- Trichy , Tamilnadu, India - 620015.
Popular Search Categories