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.70223808288574 45.40512425568256,-75.68322658538818 45.41282205012924,-75.68146705627441 45.40866446756867,-75.68103790283203 45.40366291204207,-75.67872047424316 45.400740111355574,-75.68090915679932 45.39691312310666,-75.6879472732544 45.395918666411035,-75.69159507751465 45.39395983688635,-75.69850444793701 45.3937488819647,-75.70103645324707 45.39070501616016,-75.71039199829102 45.39673231410008,-75.70026397705078 45.40128249816683,-75.70223808288574 45.40512425568256)))', 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/glebe/
Script Name: /index.asp