SELECT p.*, r.name AS region, c.name AS cat FROM properties p, regions r, categories c WHERE p.category_id=c.cat_id AND p.region_id=r.region_id AND p.property_id=37 AND p.status='Y'Property not found.