Gallery

select * from galerias where nombre_en <> '' and codigo = 1 select * from fotos where galeria = 1 and estado = 1 order by orden limit 1 SELECT carpeta FROM oficinas WHERE codigo = '4' Puerto Vallarta's Jewels	select * from galerias where nombre_en <> '' and codigo = 4 select * from fotos where galeria = 4 and estado = 1 order by orden limit 1 SELECT carpeta FROM oficinas WHERE codigo = '1' Guadalajara	select * from galerias where nombre_en <> '' and codigo = 7 select * from fotos where galeria = 7 and estado = 1 order by orden limit 1 SELECT carpeta FROM oficinas WHERE codigo = '1' Riviera Maya's Jewels	select * from galerias where nombre_en <> '' and codigo = 8 select * from fotos where galeria = 8 and estado = 1 order by orden limit 1 SELECT carpeta FROM oficinas WHERE codigo = '6' Los Cabos

select * from galerias where nombre_en <> '' and codigo = 9 select * from fotos where galeria = 9 and estado = 1 order by orden limit 1 SELECT carpeta FROM oficinas WHERE codigo = '7' Mexican Haciendas	select * from galerias where nombre_en <> '' and codigo = 10 select * from fotos where galeria = 10 and estado = 1 order by orden limit 1 SELECT carpeta FROM oficinas WHERE codigo = '8' Guadalajara

Casas, departamentos, villas y condominios de lujo en Mexico. Residences, apartments, villas and luxury condos at Mexico. | Sotheby’s International Realty Mexico.

Sotheby´s International Realty Mexico: Here you will find an introduction to the luxury real estate services that Sothebys International Realty Mexico offers as well as categorized listings of luxury properties in Mexico and Mexican beaches such as: Cancún, Playa del Carmen, Puerto Morelos, Xcalacoco, Punta Maroma, Punta Bete, Xcaret, Paamul, Xpu-ha, Puerto Aventuras, Akumal, Xel-ha, Tulum, Sian Kaan Cozumel, Puerto Vallarta, Punta de Mita, ,Litibu, Sayulita, Cruz de Huanacaxtle, Bucerias, Nuevo Vallarta, Conchas Chinas, Mismaloya, Yelapa and Costa Alegre. You will discover that Mexico is a beautiful destination, with interesting culture, recreation spaces, sports and entertainment.

© 2010 Sotheby's International Realty ® is a registered trademark licensed to Sotheby's International Realty Affiliates LLC.
Each office Is Independently Owned And Operated. Operated by Sotheby´s International Realty Mexico