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.69108009338379 45.423576115507615,-75.68421363830566 45.4284253180114,-75.67575931549072 45.43197912736288,-75.67661762237549 45.43366560265902,-75.67176818847656 45.43345479600306,-75.67163944244385 45.42887708585173,-75.66953659057617 45.425533918210654,-75.66803455352783 45.42231103765098,-75.66679000854492 45.420021777089026,-75.66378593444824 45.416919078445865,-75.66975116729736 45.417310690588415,-75.67361354827881 45.41646721490659,-75.68580150604248 45.42089532167644,-75.69108009338379 45.423576115507615)))', 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/sandy-hill/
Script Name: /index.asp