SELECT property.pid, property.Property, property.Location, property.BType, property.Ptype, property.Psize, property.Status, property.Info, property.Picture, property.active, property.active
FROM property
WHERE (((property.BType)<>"land" And (property.BType)<>"specialized") AND ((property.Ptype)="commercial") AND ((property.active)=Yes))
ORDER BY property.Property
GHATTAS ENTERPRISES, INC. - COMMERCIAL PROPERTY
