Find a Dealer

---

All find a dealer searches will hit the same outdoors api endpoints.

All unique searches are cached for 30 days, expires after 30 days.

Distance SQL Query Reference

SELECT
    s.Id,
    s.Timestamp,
    s.Modified,
    s.Name,
    s.Address,
    s.AddressLineTwo,
    s.City,
    s.State,
    s.ZipCode,
    s.Phone,
    s.Publish,
    s.WebsiteURL,
    s.Body,
    s.StoreHours,
    s.Latitude,
    s.Longitude,
    s.HasLogo,
    s.HasPriceSheet,
    s.RegionId,
    s.DealerType,
    s.Sites,
    (round( ( 3959 * acos( cos( radians( 40.8302 ) ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians( -83.28608 ) ) + sin( radians( 40.8302 ) ) * sin( radians( Latitude ) ) ) ), 1)) AS Distance
FROM Stores s
WHERE 1=1 
    AND Publish = 1
    AND (Sites & 1) > 0
    AND {distanceSqlClause} <= @Distance

Structures

Search Radius = 75 miles, closest stores first.

First 5 stores from the search results.

Returns only Structures Dealers (Labeled Sites under Outdoors Admin dealers).

Outdoors

Search Radius = 25 miles, closest stores first.

First 5 stores from the search results.

Returns only Outdoors Dealers (Labeled Sites under Outdoors Admin dealers).