Vetrine Vasteggiando
Menu

Cerca nel Vastese Touristic Facilities

Search Hotels, Restaurants, Bars and B&B


Custom exit in C:\xampp\htdocs\vasteggiando\include\funzioni_vetrine.php on line 237

SELECT l.*, p.id, p.cliente, p.da, p.a, p.indirizzo, p.telefono, p.mail, p.immagine, p.link,
				p.url, p.luogo, p.tipo_vetrina, p.tipo_attivita, p.attiva, p.solo_nome, p.counter,
				p.id AS idvetrinafk, pacchetti.link_pacchetto 
				FROM vetrine AS p
				LEFT JOIN pacchetti_vetrine ON p.id = pacchetti_vetrine.id_vetrina
				LEFT JOIN pacchetti ON pacchetti.id = pacchetti_vetrine.id_pacchetto AND pacchetti.dal <= '2018-09-26' AND pacchetti.al >='2018-09-26' 
				INNER JOIN vetrine_lang AS l ON l.id_vetrine = p.id
				WHERE
				l.lang = :lang AND
				p.attiva = 1 AND (p.tipo_vetrina = 1 OR p.da > '2018-09-26' OR p.a < '2018-09-26')
				AND	cliente LIKE :cerca   AND p.ricerca = 1 
				GROUP BY p.id
				
				ORDER BY tipo_vetrina DESC, cliente ASC

Custom exit in C:\xampp\htdocs\vasteggiando\include\funzioni_vetrine.php on line 238

Array
(
    [:lang] => en
    [:cerca] => %%
)
1
vetrina Abruzzo Rural Property

Abruzzo Rural Property

  • Address: 
  • Telephone:  38982231630

2
vetrina Agenzia immobiliare L'Arenile

Agenzia immobiliare L'Arenile

  • Address: San Salvo, Via Vespucci, 24 - Vasto, Via Crispi, 23
  • Telephone: 0873 803539

3
vetrina Agriturismo Montevecchio

Agriturismo Montevecchio

  • Address: Contrada Montevecchio, 27/C
  • Telephone: 0873 361680

4
vetrina Aqualand del Vasto

Aqualand del Vasto

  • Address: Località Incoronata
  • Telephone: 0873 310130

5
vetrina Discoteca Baja Village

Discoteca Baja Village

  • Address: Località Punta Penna
  • Telephone: +39 389 4433112

6
vetrina Donato Di Fonzo & F.lli S.p.A.

Donato Di Fonzo & F.lli S.p.A.

  • Address: Corso Mazzini, 130
  • Telephone: 0873 364785 – 0873 364536

7
vetrina F.lli Bruno

F.lli Bruno

  • Address: Via Libero Grassi, 30 Zona Industriale 66050, San Salvo (CH)
  • Telephone: 0873 341690

8
vetrina FinisTerrae Ristobar

FinisTerrae Ristobar

  • Address: via Alessandrini Nord (zona Pineta), Casalbordino Lido
  • Telephone: 0873918516 - 3470834204

9
vetrina Grotta Del Saraceno camping village

Grotta Del Saraceno camping village

  • Address: Via Osca, 6
  • Telephone: 0873 310213

10
vetrina Hotel Caravel

Hotel Caravel

  • Address: Viale Dalmazia, 130
  • Telephone: 0873 801477

11

Hotel Miramare

  • Address: 
  • Telephone: 

12
vetrina Lido Da Mimì

Lido Da Mimì

  • Address: Lungomare Ernesto Cordella
  • Telephone: 0873 802288 / 3290611855

13
vetrina Lido Fernando

Lido Fernando

  • Address: Viale Duca Degli Abruzzi
  • Telephone: 360 365431 / 348 7593269

14
vetrina Trattoria Zì Albina

Trattoria Zì Albina

  • Address: Via Luigi Marchesani 15
  • Telephone: 0873367429 - 3201912609

15

Agriturismo Arkadia

  • Address: Contrada Torre Sinello, 44
  • Telephone: 0873 310145

16

Agriturismo La Collina

  • Address: Via Polercia, 1, 66054 Vasto
  • Telephone: +390873 317263

17

Agriturismo Le Magnolie

  • Address: via Palombari, 54/A
  • Telephone: 0873 363249 / 339 3074988

18

Agriturismo Pozzitello

  • Address: Località  Buonanotte
  • Telephone: 0873 549888

19

Aimone Viaggi

  • Address: Via Luigi Marchesani , 13
  • Telephone:  39087360299,0

20

Albergo Palizzi

  • Address: Corso Mazzini, 14
  • Telephone: 0873 367361


 

    Info/Booking Request

    For more information contact us

    Follow us on Facebook


    Custom exit in C:\xampp\htdocs\vasteggiando\tema\footer.php on line 92

    Array
    (
    )
    

    Custom exit in C:\xampp\htdocs\vasteggiando\tema\footer.php on line 93

    Array
    (
        [REDIRECT_UNIQUE_ID] => W6tfGan@inkACt1o4-wAAAGJ
        [REDIRECT_MIBDIRS] => C:/xampp/php/extras/mibs
        [REDIRECT_MYSQL_HOME] => \xampp\mysql\bin
        [REDIRECT_OPENSSL_CONF] => C:/xampp/apache/bin/openssl.cnf
        [REDIRECT_PHP_PEAR_SYSCONF_DIR] => \xampp\php
        [REDIRECT_PHPRC] => \xampp\php
        [REDIRECT_TMP] => \xampp\tmp
        [REDIRECT_STATUS] => 200
        [UNIQUE_ID] => W6tfGan@inkACt1o4-wAAAGJ
        [MIBDIRS] => C:/xampp/php/extras/mibs
        [MYSQL_HOME] => \xampp\mysql\bin
        [OPENSSL_CONF] => C:/xampp/apache/bin/openssl.cnf
        [PHP_PEAR_SYSCONF_DIR] => \xampp\php
        [PHPRC] => \xampp\php
        [TMP] => \xampp\tmp
        [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
        [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
        [HTTP_IF_MODIFIED_SINCE] => Fri, 20 Jul 2018 12:31:31 GMT
        [HTTP_HOST] => www.vasteggiando.it
        [HTTP_CONNECTION] => Keep-Alive
        [HTTP_ACCEPT_ENCODING] => gzip
        [PATH] => C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\xampp\php\;
        [SystemRoot] => C:\Windows
        [COMSPEC] => C:\Windows\system32\cmd.exe
        [PATHEXT] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
        [WINDIR] => C:\Windows
        [SERVER_SIGNATURE] => 
    Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1 Server at www.vasteggiando.it Port 80
    [SERVER_SOFTWARE] => Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1 [SERVER_NAME] => www.vasteggiando.it [SERVER_ADDR] => 212.43.96.9 [SERVER_PORT] => 80 [REMOTE_ADDR] => 54.80.219.236 [DOCUMENT_ROOT] => C:/xampp/htdocs/vasteggiando [SERVER_ADMIN] => info@studioware.eu [SCRIPT_FILENAME] => C:/xampp/htdocs/vasteggiando/index_s.php [REMOTE_PORT] => 59502 [REDIRECT_QUERY_STRING] => op=vetrine&lang=en&page=1&key=+ [REDIRECT_URL] => /en/vetrine/+/1.html [GATEWAY_INTERFACE] => CGI/1.1 [SERVER_PROTOCOL] => HTTP/1.1 [REQUEST_METHOD] => GET [QUERY_STRING] => op=vetrine&lang=en&page=1&key=+ [REQUEST_URI] => /en/vetrine/+/1.html [SCRIPT_NAME] => /index_s.php [PHP_SELF] => /index_s.php [REQUEST_TIME] => 1537957657 )

    Custom exit in C:\xampp\htdocs\vasteggiando\tema\footer.php on line 94

    	
    		
    Close
    Close