err#-2147467259
err desc:Transaction (Process ID 762) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
sql:SELECT ID FROM PropertiesFreeholdAndCondos WHERE Board IN(17,82,47,110,14,43) AND 1=1 AND lattlongchecked = 1 AND Latitude IS NOT NULL AND Longitude IS NOT NULL AND ( Geometry::STGeomFromText('MULTIPOLYGON(((-79.66055631637573 44.37077222328706,-79.6579384803772 44.37647789599111,-79.6308159828186 44.37476011753644,-79.63154554367065 44.367980535738475,-79.63510751724243 44.365403475284744,-79.63008642196655 44.362458124508755,-79.62929248809814 44.36129221558383,-79.64027881622314 44.35914442787942,-79.64027881622314 44.35435764631888,-79.65049266815186 44.35675108597812,-79.66371059417725 44.366753378233824,-79.66055631637573 44.37077222328706)))', 4326).STIntersects(Geometry::STGeomFromText('POINT(' + CAST(Longitude AS VARCHAR(20)) + ' ' + CAST(Latitude AS VARCHAR(20)) + ')', 4326))=1) AND Type2 IN ('Agriculture','Att/Row/Twnhouse','Condo Apt','Duplex','Fourplex','Garden Home','Hospitality','House','Institutional - Special Purpose','Mobile/Trailer','Modular','Multi-Family','Other','Single Family','Special Purpose','Triplex','Two Apartment House','Unknown','Vacant Land') AND Status='A' AND IDX_Approved=1
Query String: Page=3&PageAction=ViewSubCat&URL=/smart-search/school-zones/algonquin-ridge/
Script Name: /index.asp