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
 


COMMERICAL PROPERTY
Office/Flex For Lease
#property#  #status#