<% dim rsTemp,mySQL,location ,connTemp 'location= Request.querystring("location") 'if location ="" then 'Response.Redirect "home.asp" 'end if pIdCategory=location 'Response.Write(pIdCategory) mySQL="SELECT * FROM products WHERE hotdeal=-1 AND active=-1 ORDER BY beds ASC" 'Response.Write("
"&mySQL) call getFromDatabase(mySQL, rsTemp,"listCategoriesAndProducts") 'pCategory = rsTemp("categoryDesc") if request.queryString("curPage") = ""then curPage = 1 else curPage = getUserInput(request.queryString("curPage"),4) end if '****************************************************************************** pIdCategory= location Dim mySQLxxx, rsTempXXX , connTempXXX , totalPages , numPerPage , countP set connTempXXX = server.createObject("adodb.connection") connTempXXX.Open pDatabaseConnectionString mySQLxxx="SELECT * FROM products WHERE hotdeal=-1 AND active=-1 ORDER BY beds ASC" numPerPage = 6 set rsTempXXX = server.createObject("adodb.recordset") rsTempXXX.cursorLocation = adUseClient rsTempXXX.cacheSize = numPerPage rsTempXXX.open mySQLxxx, connTempXXX if request.queryString("curPage") = ""then curPage = 1 else curPage = getUserInput(request.queryString("curPage"),4) end if %> Los Miradores Photos - La Manga Strip Mar Menor (Murcia)

Owners Area
Holiday Services

 

Home > Los Miradores Apartments La Manga Strip > Property id= 147 > Photo Gallery Back to property detailsBack To Property Details

Los Miradores Del Puerto 2 Bedroom - 2 Bathroom id=147

Los Miradores Complex - La Manga Strip- Luxury furnished 2 bedroom - 2 bathroom apartment in an attractive complex with spectacular views over the Mar Menor



Click on the photos below to see a bigger version

 Los Miradores Apartments

 Los Miradores Del Puerto Apartments

 Views Over Thomas Maestre Marina

 Canal de El Estacio

 Promenade along the Mar Menor

 Local beach on the shores of the Mar Menor

 Puerto Thomas Maestre Marina

 Beach on the Mar Menor

 Pieter van Driel Restaurant Veniziola

 Relax Lunch or dinner over looking the beach


Back to property details

© 2004-2008 La Manga Dreams Vacation Rentals

 
 
   
   
   
 


<% Dim mysql3,reTemp3 mySQL3="SELECT * FROM products WHERE hotspot=-1 AND active=-1 ORDER BY dateAdded ASC" call getFromDatabase(mySql3, rstemp3,"listCategoriesAndProducts") if rsTemp3.EOF then response.Write("No Hot Spots Available") end if do while not rsTemp3.eof idp = rsTemp3("idProduct") thumb = rsTemp3("thumbnail") response.write "
" &rsTemp3("hotspotText") response.Write "


" rsTemp3.movenext loop %>