<% 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 = "Costa del Sol" 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

Costa Del Sol Villa Rental Holidays 2024/2025

Costa Del Sol Villa Rentals

The Costa del Sol is famous for having the longest coastline in Spain, providing what appears to be an unlimited amount of sun soaked beaches. The region has beautiful scenery, from impressive views of the Mediterranean Sea to fabulous mountain imagry. The culture in the area varies from the vibrant glamorous, modern way of life in cosmopolitan Marbella, to beautifully unspoilt traditional localities. These include theatres, museums and quaint old towns, a reminder of how traditional Spanish life used to be.

With many of the Costa Del Sol beaches awarded the blue flag status, the area sets a high standard. Golden sands and crystal clear waters are the trademark of the region. With a variety of beaches to choose from, activities such as snorkelling, swimming and various types of water sports are on offer, as well as simply relaxing and topping up a tan. Local amenities include restaurants and beach bars, catering for families and couples alike.

Costa Del Sol 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 %>

Costa Del Sol Resorts

Frigiliana

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