No se puede seleccionar las Propiedades

Debido a:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and p.inmobiliaria = 'CU' and i.muestra_propiedad' at line 16

En la consulta 'select p.propiedad, p.venta, p.alquiler, IF (TO_DAYS(NOW()) - TO_DAYS(p.fec_ult_act) <= 5, p.fec_ult_act, DATE_SUB( NOW(), INTERVAL 5 DAY)) as orden_fecha from propiedades p, inmobiliarias i where i.inmobiliaria = p.inmobiliaria and i.region = and p.inmobiliaria = 'CU' and i.muestra_propiedades = 'S' and i.habilita_internet = 'S' and en_internet = 'S' order by orden_fecha DESC,p.orden '