Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50560 Library:100135 in /home/www/med_portals/www/shared/includes/rude-php-mailgun/apps/mailgun-standalone/etc/database.php on line 49

Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50560 Library:100135 in /home/www/med_portals/www/shared/includes/bridge/classes/helpers/database/database.php on line 49

Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50560 Library:100135 in /home/www/trademed/medbiz/medbiz.net/www/index.php on line 86

Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50560 Library:100135 in /home/www/trademed/medbiz/shared/classes/DB.php on line 233
SELECT `user_id`,`is_seller`,`pass`,`email`,`login`,`personal_title`,`firstname`,`lastname`,`activation`,`registered_date`,`is_mail_confirm`,`is_activated`,`is_enabled`,`is_approved`,`is_spammer`,`zip`,`country_id`,`city`,`state`,`street`,`fax`,`phone`,`mobile`,`imported`,`status_to_receive_newsletters`,`status_to_receive_newsletters_date`,`fb_id`,`oauth_registration`,`user_id`
FROM users

WHERE users.user_id='897'



SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='2951'



SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='2951'



| WALL MOUNTED 4LE | Medical Equipment and devices for hospitals or institutions. | TradeMed SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='2951'



En Es
Products
Covid-19
Companies
Pre-Owned
News
Events
About Us       Join now!
Categories

Browse Products by Category

Critical Care

Emergency Medicine

Intensive Care

Respiratory Care

Anesthesiology Systems

Home Care

Rehabilitation

Other

Hospital Infrastructure

IT Equipment

Transportation Systems

Other

Medical Imaging

Computed Tomography

Digital Radiography

Image Management Systems

Interventional Radiology

Magnetic Resonance Imaging

Mammography

PACS/RIS

Positron Emission Tomography

Radiation Safety

Radiography

Single-Photon Emission Computed Tomography

Ultrasound

Other

Patient Care

Bariatric Care

Beds

Examination Equipment

Other

Surgery

Endoscopy

Laparoscopy

Laser Surgery

Operating Room Equipment

Sterilization

Surgical Implants

Surgical Instruments

Waste Management

Other

Clinical Laboratory

Blood/Gas Analyzers

Cell Counters

Centrifuges

Clinical Chemistry Analyzer

Coagulation Analyzers

Hematology Analyzers

Immunoassay Systems

Lab Glassware

Microscopes

Pipettes

General Lab

Microplate Reader

Urine Analyzer

Ready-to-use kits for analysis

Rapid Tests

Other

Browse Products by Category

Close
SELECT `user_id`,`is_seller`,`pass`,`email`,`login`,`personal_title`,`firstname`,`lastname`,`activation`,`registered_date`,`is_mail_confirm`,`is_activated`,`is_enabled`,`is_approved`,`is_spammer`,`zip`,`country_id`,`city`,`state`,`street`,`fax`,`phone`,`mobile`,`imported`,`status_to_receive_newsletters`,`status_to_receive_newsletters_date`,`fb_id`,`oauth_registration`,`user_id`
FROM users

WHERE users.user_id='897'



SELECT p.product_id,cat.category_id,cat.category_name_en as category_name
FROM products as p
JOIN products_to_categories AS pc ON pc.product_id=p.product_id
JOIN view_category_root vcr on vcr.category_id=pc.category_id
JOIN categories cat on cat.category_id=vcr.root_id
LEFT JOIN products_only_in_country as poic ON poic.product_id = p.product_id
LEFT JOIN companies_only_in_country as coic ON coic.company_id = p.user_id
WHERE p.user_id=897 AND p.covid_19 = 1 AND p.is_enabled = 1 AND p.is_deleted = 0 AND (poic.product_id IS NULL OR poic.country_id = 225) AND (coic.company_id IS NULL OR coic.country_id = 225)
GROUP BY category_id,p.product_id
ORDER BY category_name ASC, p.posted DESC, p.product_id ASC

Sismatec Ltda.

Sismatec manufactures OR and ICU equipment, including surgical tables (electro-hydraulic and mechanical-hydraulic), halogen and LED surgical lights (ceiling mounted, stand types and wall mounted), saws and drills for osteotomy, cameras, and surgical monitors.
Products Pre-OwnedSummary
Close

Pre-Owned Sismatec Ltda.

Surgery

SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='1022'




More details
Close

About Sismatec Ltda.

Sales: US$1 Million - US$9 Million
Number of Employees: 20-99
Year of Establishment: 1980
Export Markets
North America, South America, Central America, Africa, Caribbean, Middle East, Asia Pacific, Europe, Asia
Sismatec manufactures OR and ICU equipment, including surgical tables (electro-hydraulic and mechanical-hydraulic), halogen and LED surgical lights (ceiling mounted, stand types and wall mounted), saws and drills for osteotomy, cameras, and surgical monitors.
ISO 13845
ISO 9001
TUV
FaceBook Twitter Google+ Linked in

Model: WALL MOUNTED 4LE
Request Information

Description:


SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='2951'



Tags: [Surgery], [Operating Room Equipment], [OR Lighting and Surgical Tables]

Send A Message To This Supplier

* Required Information
* Email
To
Sismatec Ltda. (Surgical Light)
* Message

SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='2951'




Warning: Invalid argument supplied for foreach() in /home/www/trademed/medbiz/shared/mvc/Product/Block/View.php on line 37

Warning: array_shift() expects parameter 1 to be array, boolean given in /home/www/trademed/medbiz/shared/mvc/Product/Block/View.php on line 68

More Products From This Supplier or Category

SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='2950'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='1022'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='7325'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='7297'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='6123'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='2409'
SELECT `user_id`,`medsite_id`,`title_en`,`title_es`,`model`,`description_en`,`description_es`,`keywords`,`conditions`,`is_newly_created`,`image`,`image_add1`,`image_add2`,`image_add3`,`image_old`,`image_add1_old`,`image_add2_old`,`image_add3_old`,`is_deleted`,`is_enabled`,`orders`,`orders_not_viewed`,`viewed`,`posted`,`user_login`,`is_for_print`,`is_must_run`,`image_for_print`,`url_to_product_on_company_website`,`image_real_width`,`image_real_height`,`image_crop_x1`,`image_crop_y1`,`image_crop_x2`,`image_crop_y2`,`covid_19`,`product_id`,`product_id`
FROM products

WHERE products.product_id='3223'
Copyright © 2000-2024 TradeMed.com. All rights reserved. | Terms And Conditions