SELECT parent.id, parent.slug, TRIM(parent.title) AS title, parent.details, parent.sidebar, parent.metatitle, parent.metadesc, parent.keywords, customjs FROM tbl_pages AS parent WHERE parent.slug = 'brisas-by-zephyr' AND parent.publish=1 AND (date_format(parent.start_date,'%Y-%m-%d')<=CURDATE() OR ISNULL(parent.start_date) OR parent.start_date='1970-01-01' OR parent.start_date='1969-12-31') AND (date_format(parent.end_date,'%Y-%m-%d')>=CURDATE() OR ISNULL(parent.end_date) OR parent.end_date='1970-01-01' OR parent.end_date='1969-12-31')
We do not currently have any Brisas By Zephyr products available. Please contact us for more details or to inquire about a specific model.
Schedule an Appointment
Meet with one of our Trained Product Experts who can assist with all of your needs.