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.67108154296875 45.400137453236255,-75.66232681274414 45.399233454004374,-75.64164161682129 45.40025798537436,-75.66447257995605 45.36939336530105,-75.66786289215088 45.36824767426616,-75.68155288696289 45.37391560331485,-75.68850517272949 45.383441268142484,-75.6778621673584 45.38928850786253,-75.67108154296875 45.400137453236255)))', 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: PageAction=ViewSubCat&URL=/communities/alta-vista/
Script Name: /index.asp