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.74280166626)) * COS(RADIANS(z.latitude)) * COS(RADIANS(z.longitude) - RADIANS(-97.87789916992)) + SIN(RADIANS(55.74280166626)) * SIN(RADIANS(z.latitude)) )) AS distance_from_postal_code FROM seibert_site.postal_codes z JOIN seibert_site.store_locations s ON ( z.postal_code = LEFT(s.postal_code, 3) ) JOIN seibert_site.store_chains c ON s.chain_id = c.chain_id JOIN seibert_site.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 AND s.lat BETWEEN 55.163091521332 AND 56.322511811188 AND s.lng BETWEEN 98.907746587887 AND 96.848051751953 HAVING distance_from_postal_code <= 40 ORDER BY distance_from_postal_code ASC, st.state_name, s.city ASC, s.name ASC LIMIT 20