2gig Repeaters

Sort by:

Sorting

Best Selling

On Sale

Brand

Display All

2gig (1)

Color

White (1)

Transmission Band

345 MHz (1)

select p.products_image, p.products_image_med, p.products_model, p.products_quantity, p.products_date_available, p.products_date_order_due, m.manufacturers_id, p.products_parent_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, p.vendors_prod_id, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products AS p INNER JOIN products_to_groups pg ON pg.products_id = p.products_id AND pg.group_code = 'G' LEFT JOIN products_to_products_extra_fields AS p2pef ON p2pef.products_id = p.products_id LEFT JOIN products_extra_fields AS pef ON p2pef.products_extra_fields_id = pef.products_extra_fields_id AND pef.products_extra_fields_status = 1 AND pef.products_extra_fields_facet = 1 AND pef.languages_id IN (0, 1) INNER JOIN products_to_categories AS ptc ON ptc.products_id = p.products_id left join products_description pd on p.products_id = pd.products_id AND pd.language_id = 1 left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on (s.products_id = p.products_id and s.status = 1) LEFT JOIN ( SELECT DISTINCT products_id, 1 AS is_featured_match FROM featured WHERE status = 1 AND featured_group_id = 6 AND f_categories_id = '1' ) feat ON feat.products_id = p.products_id WHERE p.is_active = 1 AND ptc.categories_id = '79' AND p.manufacturers_id = '4959' group by p.products_id ORDER BY CASE WHEN feat.is_featured_match = 1 THEN 0 ELSE 1 END, p.products_sort_order, p.products_date_available DESC, p.products_last_views DESC, pd.products_name

1 items

2GIG 2GIG-RPTR100-345 Wireless Repeater, 345MHz
# 2GIG-RPTR100-345

2gig

1 items

2gig Repeaters

Sorting

Brand

Color

Transmission Band

About Us

Customer Care

Our Policies

How do you want to process the order?
Pickup from Local Warehouse Ship from Miami via UPS

Language:
English Spanish
Don't show again