FREE RETURNS. STANDARD SHIPPING ORDERS $99+
|
Air Vent Car Phone Holder
Air Vent Car Holders
Search Your Device Or Accessories
Air Vent Car Phone Holder
A car phone holder is a perfect road companion for anyone who loves to travel. A good car phone holder provides so many benefits to the user that it has become a must have mobile accessory for all those who spend a lot of time in their cars. Here is a list of different car phone holders such as magnetic car mobile holder, slim car holder, air vent car phone holder, etc.
This Car Air Vent car phone holder by Hiker Store is magnetic and produces an intensive force of attraction that helps to hold any smartphone perfectly including iPhone and Android phones. The premium building material i.e. Aluminium and ABS Plastic is used to build this magnetic mount.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id=733
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (1186, 1195, 1199, 1200, 1202, 1748, 1749, 1853, 1186, 1195, 1199, 1200, 1202, 1748, 1749, 1853, 1186, 1195, 1199, 1200, 1202, 1748, 1749, 1853, 1186, 1195, 1199, 1200, 1202, 1748, 1749, 1853, 1853, 1202, 1748, 1749, 1186, 1195, 1199, 1200, 1186, 1195, 1199, 1200, 1202, 1748, 1749, 1853)) ORDER BY FIELD(e.entity_id,1186,1195,1199,1200,1202,1748,1749,1853,1186,1195,1199,1200,1202,1748,1749,1853,1186,1195,1199,1200,1202,1748,1749,1853,1186,1195,1199,1200,1202,1748,1749,1853,1853,1202,1748,1749,1186,1195,1199,1200,1186,1195,1199,1200,1202,1748,1749,1853), `e`.`entity_id` DESC
LIMIT 12
