SELECT property.pid, property.Property, property.Location, property.BType, property.Ptype, property.Psize, property.Status, property.Info, property.Picture, property.active
FROM property
WHERE (((property.BType)<>"Development") AND ((property.Ptype)="residential") AND ((property.active)=Yes))
ORDER BY property.Property
GHATTAS ENTERPRISES, INC. - RESIDENTIAL PROPERTY
