<% 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 %> Photos - Playa Principe Luxury 4th Floor apartment on beach, La Manga, Murcia, Spain

Property No.
  lamanga
Owners Area
Owner Log In
Management
Letting Guide
Owners Sign Up
Holiday Services

1 Bedroom Apt's
2 Bedroom Apt's
3 Bedroom Apt's
All Rental Properties
La Manga Villas
La Manga Photo's
 

Home > 3 Bedroom 2 Bath Apartment Playa Principe La Manga Strip > Property id= 67 > Photo Gallery Back to property detailsBack To Property Details

3 Bedroom 2 Bath Apartment Playa Principe-id67

|

Play Principe Complex - La Manga Strip- Luxury furnished 3 bedroom - 2 bathroom apartment 5* accomodation in an attractive complex with spectacular sea views over the Mediterranean and Mar Menor



Click on the photos below to see a bigger version

 Spectacular sea views over the Mediterranean

  The Balcony View
 Pool

 Pool

 Evenings on the beach of the Mar Menor

 Local beach on the shores of the Mar Menor

 Promenade At Tomas Maestre Marina

  Beach on the Mar Menor
 View From Tomas Maestre Marina To The Apartments

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