Loading data..

Mention

Find Truck Service! receive discounts from our participating vendors.



National Love's Truck Tire Care in or near West Palm Bch, FL

generateAdsByGPS2 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*pi()/180 )*COS(latitude*pi()/180) *POWER(SIN((-longitude)*pi()/180' at line 36 SELECT `id`, `service_type`, `adtype`, `name`, `interstate`, `milemarker`, `address`, `city`, `state`, `zip`, `latitude`, `longitude`, `description`, `image`, `category`, `subcategory`, `phone`, `fax`, `afterhours`, `website`, `website2`, `email`, `specials`, `cid`, `247`, `hours`, `special_hours`, `impressions`, `ameneties`, `fuel_price`, `fuel_updated`, `status`, CONCAT(UPPER(city), ',' , UPPER(state)) AS city_state, 3956 * 2 * ASIN(SQRT( POWER(SIN(( - latitude)*pi()/180/2),2) +COS(*pi()/180 )*COS(latitude*pi()/180) *POWER(SIN((-longitude)*pi()/180/2),2))) as distance FROM `db487459190`.ads WHERE longitude between (-250/cos(radians())*69) and (+250/cos(radians())*69) and latitude between (-(250/69)) and (+(250/69)) and `approved` != 'suspend' and `status` = 1 and `zip` != 0 and `category` LIKE '%National Network%' and `subcategory` LIKE '%Love\'s Truck Tire Care%' having distance < 250 ORDER BY distance limit 100