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="37" OR profiles.mulcity LIKE "%~37~%" ) && profiles.is_delete!=1 && profiles.status=1 && (profiles.d_mc_id="27" || profiles.catgory_id LIKE "%,27,%") && (profiles.d_sc_id="477" || profiles.subcat_id LIKE "%,477,%") 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
No 13, Gr Floor Second Cross, Anna Nagar Nellithope,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
No 140, Maraimalai Adigal Salai, Next New Bus Stand,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
No 255, Rangapillai Street, Near Raja Cinema Theatre Signal,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
No 72, Calatheswaran Koil Street (Chetty Street), Inbetween Mission & MG Road,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
No 6, Marai Malai Adigal Salai, Opposite Botanical Garden,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
No 101 A, Gingee Salai, Old Law College Bus Stop, Near Pondicherry Beach,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
No 89, B, Needarajappar Street, Near Amudhasurai,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
Number 8 Quai D, Ambur Salai, Near By Salt And Pepper Restaurant,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
No 126, S V Patel Salai, Near Ajantha Square,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
No 18, Rangapillai Street, Near BSNL Head Office,
Pondicherry Ho
- Pondicherry , Tamilnadu, India - 605001.
Popular Search Categories