SELECT property.pid
FROM property
WHERE (((property.BType)<>"land" And (property.BType)<>"specialized") AND ((property.Ptype)="commercial") AND ((property.active)=Yes))
ORDER BY property.Property
SELECT * FROM property
where pid=#pid#
SELECT * FROM THUMBNAILS
WHERE PID = #PID#
SELECT * FROM DOCUMENTS
WHERE PID = #PID#
GHATTAS ENTERPRISES, INC. - COMMERCIAL PROPERTY
