err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(76) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-75.75442314147949 45.40562140521049,-75.75373649597168 45.40339173071344,-75.74764251708984 45.401704350975784,-75.74695587158203 45.39989638818863,-75.74163436889648 45.39748568114408,-75.73747158050537 45.39043377263847,-75.73283672332764 45.390584463644565,-75.7472562789917 45.37653833568162,-75.75571060180664 45.39103653425222,-75.7593584060669 45.388896701427555,-75.7622766494751 45.39323655959081,-75.76347827911377 45.40019771933747,-75.75652599334717 45.40513932088405,-75.75442314147949 45.40562140521049)))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and sale_lease in ('sale') and status='a' and idx_approved=1
Query String: Page=4&PageAction=ViewSubCat&URL=/communities/westboro/
Script Name: /index.asp