<% Dim ConnectionString set objConn = Server.CreateObject("ADODB.Connection") 'define connection string, specify database driver and location of the database objConn.open "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=213.171.200.85; PORT=3306; DATABASE=villas; USER=Nick_P2; PASSWORD=nick753848x2; OPTION=3;" location = "Fuerteventura" Onsite = "Yes" sql = "Select * from VillasFull" sql = sql & " Where Destination = " & "'" & location & "'" sql = sql & " And Live = " & "'" & Onsite & "'" Set villaRS = objConn.Execute (sql) %>

Villas With Pools

Villas With Pools

Fuerteventura Villa Rental Holidays 2021/2022

Fuerteventura is the most easterly of the Canary Islands making it so close to Africa, in fact, it is only 60 miles from the coast of Morocco. Due to its close proximity to Africa, the sands of the Sahara desert have been depositing itself on the Fuerteventura coastline for thousands of years, making the beaches some of the most stunning in the world. Another benefit of the island being so close to Africa is that on average, it boasts over 320 sunny days a year and has a great spring like temperature all year round. During the summer months, it can get as hot as 28c.

Fuerteventura Villas

<% while not villaRS.EOF %>

<%=villaRS("VillaName")%>, <%=villaRS("Resort")%>

Sleeps: <%=villaRS("Sleeps")%>
Tour Operator:
<%=villaRS("Top")%>

<%=villaRS("Offer")%>

<%=villaRS("Description")%>

<% IF villaRS("Top") = "Olivers Travels" THEN %>

" target="new"> ">

<% ELSE %> <% IF villaRS("Online") = "Yes" THEN %> <% IF villaRS("Top") = "Solmar" THEN %>

<% ELSE %>

" target="_blank">

<% END IF %> <% ELSE %>

">

<% END IF %> <% END IF %>

<% villaRS.MoveNext %> <% WEND %>

Fuerteventura Resorts

Costa Caleta

<% VillaRS.Close objConn.Close set villaRS = nothing set objConn = nothing %>