Loading data..

Mention

Find Truck Service! receive discounts from our participating vendors.



Truck Wash Trailer Wash in or near Land O' Lakes, FL

FINANCE ALL REPAIRS, SERVICE AND PARTS PURCHASES NATIONWIDE
CLICK FOR DETAILS

generateAdsByGPS2 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`, `merchant_type`, 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 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 '%Truck Wash%' and `subcategory` LIKE '%Trailer Wash%' having distance < 250 ORDER BY distance limit 100