Post Free Ad Login Sign Up

SELECT concat(b1.catg1,'~~',b1.url_iyp) AS l2_catg, b1.slno as l2_slno, tci.img_name_home, tci.img_name_home_width_height FROM category_tbl b1 LEFT JOIN tbl_category_image tci ON tci.final_catg_slno = b1.slno WHERE b1.slno IN (337814,71999,63692,356215,113734,68473,361446,68494,74422,360394,14158,66159,79528,63665,348845,355975,95422,348525,14171,66288,88161,112376,163790,62758,64242,70230,71473,140606,182516,340276,342525,354751,355894,355967,356103,360395,75947,114420,125291,179102) && b1.wide_range_catg=0 && final_catg='Y' ORDER BY FIELD(b1.slno, 337814,71999,63692,356215,113734,68473,361446,68494,74422,360394,14158,66159,79528,63665,348845,355975,95422,348525,14171,66288,88161,112376,163790,62758,64242,70230,71473,140606,182516,340276,342525,354751,355894,355967,356103,360395,75947,114420,125291,179102) LIMIT 40SELECT concat(b1.catg1,'~~',b1.url_iyp) AS l2_catg, b1.slno as l2_slno, tci.img_name_home, tci.img_name_home_width_height FROM category_tbl b1 LEFT JOIN tbl_category_image tci ON tci.final_catg_slno = b1.slno WHERE b1.slno IN (351296) && b1.wide_range_catg=0 && final_catg='Y' ORDER BY FIELD(b1.slno, 62697,63871,66054,323511,351437,354019,354371,358190) DESC, FIELD(b1.slno, 351296) LIMIT 40

Give Us Your Feedback

Follow Us

Hailakandi Business Directory

Business Services

SEO Service , Digital Marketing Services , Internet Marketing Service , Project Management , Media Services , Trade Consultation Service , Export Consultants , Direct Marketing , Projects Consultants , Quality Checking Service

Education & Training Services

Education Consultancy Services , Educational Services , Coaching Classes , Online Education Consultancy Services , Customer Service Training , Digital Marketing Training Services , E-Learning Solution , Corporate Training Consultation , Publishing House , Marketing Training

Engineering Service

Fabrication Services , Maintenance Contractors , Packaging Solutions , Electrical Contractors , Farm Management Service , Machinery Repairs , Material Packaging Service , Agro Farming Services , Annual Maintenance Contract Services , Product Designing

Event Management & Photography

Event Management Services , Wedding Event Management Service , Photography Services , Wedding Planner , Event Organizers , Videography Services , Decoration Services , Catering Services , Exhibitions Services , Party Organizers

Financial & Legal Services

Loan Service Providers , Financial Services , Real Estate Finance , Insurance Service , Tax Consultancy Service , Real Estate Service , Finance Consultant , Real Estate Agents , Legal Consultant , Auditing Services

HR Planning & Recruitment

HR Consultancy Services , Placement Consultants , HR Solutions , Job Consultation Service , Manpower Service , Recruitment Services , Direct Placement Services , Staffing Services , Placement Service , Corporate Recruitment Services

Media Production & Advertising

Advertising Service , Media Services , Advertising Printing Service , Publishing House , Digital Printing , Internet Marketing Service , Social Media Marketing Service , Logo Design , Content Writing Services , Content Development Service

Small Business Houses

Horoscope Prediction Services , Astrology Services , Language Translation Service , Vastu Shastra , Investigation Services , Vastu Consultancy , Art Glass Work , Numerologists , Pooja Services , NGO Service

Tours, Travels & Hotels

Tour Operators , Vehicle Rental Service , Car Rental Services , Hotel Booking , Ticket Booking Service , Tour Packages , Immigration Service , Air Ticket Booking , Visa Consultant , CAB Service

Transportation and Logistics

Freight Forwarding Services , Transportation Services , Logistic Services , Cargo Transportation Services , Domestic Relocation Service , Shipping Services , Custom Clearing Services , Warehousing Services , Air Cargo Service , Courier Services

Agriculture

Agro Products , Animal Feed , Seed Spices , Agricultural Equipment , Grain Seeds , Wood Craft , Fungicides , Astrological Accessories , Dehydrated Vegetables , Herbal Powder

Apparel & Fashion

Readymade Garments , Men Wear , Kids Clothing , Fashion Handbags , Ladies Bags , Women Party Wear , Kids Wear , Plastic Bags , Men Shirts , Personal Protective Equipment

Automobile

Two Wheeler Accessories , Bike Accessories , Auto Electrical Products , Electric Two Wheelers, Parts And Kits , Two Wheeler Spare Parts , Automotive Speedometer , Electric Motorcycle Part , Motorcycle Electrical Parts , Auto Electrical Parts , Commercial Vehicle

Ayurveda & Herbal Product

Ayurvedic Medicines , Herbal Powder , Herbal Extracts , Inorganic Compounds , Herb Oil , Herbs,Sticks and Roots , Carrier Oil , Organic Spices , Henna Powder , Medical Supplies

Computers and Internet

Computer Parts , Computer Systems , Computer Accessories , Desktop Computers , Networking Device , Computer Monitors , Laptops , Networking Equipment , Computer Hardware , Networking Devices and Equipment

Consumer Electronics

LED Lights , Camera , Photo Studio Equipment , Street Lights , Electrical Kitchen Appliance , Kitchen Appliances , Mobile Phones , Lighting Accessories , Multifunction Printer , Cleaning Machine

Cosmetics & Personal Care

Beauty Cosmetics , Body Care Product , Detergent , Baby Care Products , Cosmetic Raw Materials , Inorganic Compounds , Herbal Skin Care Cosmetics , Herbal Powder , Ayurvedic Medicines , Chemical Compound

Electronics & Electrical

Instrumentation Equipment , Air Conditioning System , Electrical Components , Metal Wire , Commercial Air Conditioner , Industrial Control System , Transformers , Generator and Accessories , Electric Cables , Electronic Connectors

Food Products & Beverages

Bakery Products , Herbal Powder , Ayurvedic Medicines , Edible Nuts , Food Additives , Seed Spices , Chilli , Nuts , Confectionery Products , Basmati Rice

Furniture & Carpentry Services

Furniture , Office Furniture , Wooden Furniture , Chairs , Outdoor Furniture , Living Room Furniture , Metal Furniture , Kitchen Furniture , Beds , Hospital Furniture

Gifts & Crafts

Wood Craft , Decorative Collectibles , Wooden Handicraft , Corporate Gifts , Antique Pieces , Antique Statues , Decorative Items , Stone Crafts , Bamboo Craft , Astrological Accessories

Home Furnishings

Floor Mats , Carpets , Floor Rugs , Kitchen Linens , Table Linens , Cushion Covers , Floor Carpet , Natural Rug , Towels , Furniture

Home Supplies

Serving Utensils , Wood Craft , Disposable Utensils , Silver Utensils , Disposable Crockery , Towels , Incense Sticks , Astrological Accessories , Agro Products , Cleaning Brushes

Hospitals & Diagnosis Supplies

Medical Supplies , Surgical Supplies , Medical Equipment , Personal Protective Equipment , Surgical Equipments , Safety Masks , Medical Instruments , Medical & Industrial Mask , Face Mask , Industrial Safety Masks

Industrial Machinery

Water Treatment Plant , Water Purification Plants , Processing Plant , Printing Machines , Hydraulic Machine , Textile Machine , Conveyor Components , Pollution Control Machines , Milling Machine , Material Handling Equipments

Industrial Supplies

Nuts , Industrial Pump , Bearings , Machine Parts , Molded Rubber Products , Nut Fastener , Rubber Products , Flange Accessories , Industrial Hose , Transmission Seal

Jewelry & Jewelry Designers

Fancy Jewellery , Fashion Accessories , Gemstones , Sterling Silver , Gold Jewellery , Imitation Jewelry , Diamond Jewellery , Ladies Earrings , Pendant Set , Diamonds

Mineral & Metals

Metal Scrap , Mineral Ores , Metal Wire , Steel Products , Metal Sheets , Industrial Mineral , Coal , Aluminium Scrap , Nano Powder , Inorganic Compounds

Office Supplies

Printer Consumables , Writing Instruments , Desk Accessories , craft tools , Stationery Items , Rulers , Measuring Ruler , Scale Ruler , Pens , Office Stationery

Packaging & Paper

Food Packaging Materials , Packaging Rolls , Plastic Bags , Tapes , Plastic Film , Plastic Bottles , Packaging Machine , Corrugated Box , Photo Studio Equipment , Metal Container

Pharmaceutical Drugs & Medicines

Medical Supplies , Nutraceuticals , Pharmaceutical Capsules , Pharmaceutical Syrups , Antibiotic Drugs , Nutritional Supplement , Erectile Dysfunction Medicine , Surgical Supplies , Protein Powder , Feed Supplements

Realestate, Building & Construction

Natural Stone , Building Material , Special Purpose Paints , Designer Tiles , Sanitary Ware , Wood , Light Travertine Tiles , Steel Pipes , Metamorphic Stone , Marble

Security Products & Services

Safety Equipments , Personal Protective Equipment , Highway Safety Products , Safety Masks , Face Mask , Medical & Industrial Mask , Industrial Safety Masks , Anti pollution Masks , Dust Protection Mask , Safety Locks

Sports Goods and Entertainment

Sports Good , Readymade Garments , Sports Jersey , Sports Apparel , Horse Riding & Hunting Clothing , Sports Footwear , Sports Shoes , Swimming Pool Goods , Men Wear , Adventure Trekking Good

Telecommunication

Telecommunication Equipments , Audio Amplifier , Cellular Yagi Antenna , Audio Device , Fibre Optic Components , Fiber Optic Tools , Fiber Optic Cables , Voice Recorder , Audio Recorder , Communication Systems And Equipment

Textiles, Yarn & Fabrics

Industrial Fabrics , Cotton Textile , Cotton Fabric , Home Decor & Furnishing Fabrics , Natural Fiber Yarn , Animal Leather , Synthetic Yarn , Fibers , Raw Leather , Cotton

Tools & Equipment

Testing Equipment , Power Tools , Medical Supplies , Weighing Scale , Surgical Supplies , Measurement Gauge , Electronic Test Instruments , Infrared Thermometer & Thermal Camera Raw Materials , Wrench , craft tools

Toys & Games

Kids Toys , Soft Toys , Learning and Educational Toy , Figure Toy , Toys Vehicles , Animated Stuffed Toy , Amusement Park Inflatable , Video Games , Wooden Toys , Baby Toys

GENERAL LINK

Top Cities (India)

Hailakandi Localities

top