loading-uptown
Subscribe
Welcome to
Uptown Real Estate Group
Buy, Sell
or Lease
Buy, Sell
or Lease
Buy, Sell
or Lease
Luxury Residences
for Lease
Beautiful views
in Houston
The best places to live
in Houston and The Woodlands
The best places to live
in Houston and The Woodlands
Comfort and Elegance
in Uptown
Buy, Sell
or Lease
Bilingual Realtors
in Houston
Over 30 Years
Of Experience
Luxury and Comfort
in Houston
Galleria-Uptown
Downtown-Medical Center

Search our Communities

About us


Uptown Real Estate Group

Thanks for visiting Uptown Real Estate Group, we want to give you the best experience choosing your new home. We are a realtor's team ready to support your questions and give you the lowest prices according to your needs, feel free to ask whatever you want. It's a pleasure to serve you

Coming soon - Now under construction

Financing available for foreign nationals with 25% down payment

The Sophie

More details

Giorgetti

More details

The Revere

More details

Call Us for Free, We Speak Spanish

MEX (55)85-25-92-35
MTY (81)41-62-33-14
GDL (33)41-62-33-17

Llamanos Gratis, Hablamos Español

Recent Properties


Warning: mysqli_connect(): (42000/1203): User bdintranetuptown already has more than 'max_user_connections' active connections in /home/content/60/9858060/html/uptownrealestategroup/librerias/conexion.php on line 3

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/content/60/9858060/html/uptownrealestategroup/librerias/conexion.php on line 4

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/content/60/9858060/html/uptownrealestategroup/librerias/conexion.php on line 5

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /home/content/60/9858060/html/uptownrealestategroup/modelos/post.php on line 100

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/content/60/9858060/html/uptownrealestategroup/librerias/conexion.php on line 16
Fallo al ejecutar el query en la línea 100:
SQL: select publicaciones.id, publicaciones.titulo_publicacion, publicaciones.contenido_publicacion, publicaciones.meta_description_publicacion, publicaciones.meta_keywords_publicacion, publicaciones.meta_image_publicacion, if(publicaciones.publicado="Si","Yes","No") publicado, publicaciones.users_id, publicaciones.fecha_hora_publicacion, publicaciones.alias_permalink, lower(date_format(publicaciones.fecha_hora_publicacion,"%M")) mes_publicacion_full, date_format(publicaciones.fecha_hora_publicacion,"%b") mes_publicacion_abrev, date_format(publicaciones.fecha_hora_publicacion,"%Y") anio_publicacion_full, date_format(publicaciones.fecha_hora_publicacion,"%d") dia_publicacion_full from publicaciones left join publicacion_tags on publicacion_tags.activo_publicacion_tag="Si" and publicacion_tags.publicaciones_id=publicaciones.id left join tags on tags.activo_tag="Si" and tags.id=publicacion_tags.tag_id where publicaciones.activo_publicacion="Si" and publicaciones.publicado="Si" group by publicaciones.id order by publicaciones.fecha_hora_publicacion desc limit 0,6