AINAŽI SALACGRĪVA LIMBAŽI ALOJA un STAICELE

Riverside Smokehouse

+1
It offers various types of smoked and cooked chicken, pork and deer meat. The products are smoked with alder wood on the banks of the Salaca River.
The products are available at various markets in Vidzeme and Rīga.
Location
Salacgrīva
Contacts
+371 28376600
NEAREST OBJECTS
SELECT *, byNear(,, gpslon,gpslat) AS dist FROM objekti2 WHERE id!='1307700465' AND nonearest!=1 ORDER BY dist ASC LIMIT 5
Query error