<% 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 Penthouse Photos - La Manga Strip Mar Menor (Murcia)

Owners Area
Holiday Services

 

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

Los Miradores Penthouse 2 Bedroom - 2 Bathroom id=66

Los Miradores Complex - La Manga Strip- Luxury furnished 2 bedroom - 2 bathroom Penthouse.87sq m, 2 Balconies overlooking Thomas Maestre Marina - upstairs is 87sqm private roof terrace with BBQ,sink & shower,superb 360d views of the Mar Menor & Mediterranean



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 %>