Store Locator

Retail Chain - Select a Chain - Comic Book Stores Costco Wholesale Real Canadian Superstore Toys R Us Walmart

Postal Code

# Locations - 20 40 60 80 100 120 140 160 180 200

Distance 20 mi (32.19 km) 40 mi (64.37 km) 60 mi (96.56 km) 80 mi (128.75 km) 100 mi (160.93 km)

Go Reset

Add a Store

SELECT DISTINCT s.store_id, s.chain_id, s.name, s.address, s.city, s.state, s.postal_code, s.country, c.logo, st.state_name, (3959 * ACOS( COS(RADIANS(55.77700042725)) * COS(RADIANS(z.latitude)) * COS(RADIANS(z.longitude) - RADIANS(-3.91300010681)) + SIN(RADIANS(55.77700042725)) * SIN(RADIANS(z.latitude)) )) AS distance_from_postal_code FROM postal_codes z JOIN store_locations s ON ( z.postal_code = LEFT(s.postal_code, 3) ) JOIN store_chains c ON s.chain_id = c.chain_id JOIN states st ON s.state = st.state_id WHERE z.latitude IS NOT NULL AND z.longitude IS NOT NULL AND c.is_active = 1 AND s.is_active = 1 HAVING distance_from_postal_code <= 40 ORDER BY distance_from_postal_code ASC, st.state_name, s.city ASC, s.name ASC LIMIT 20