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.70232391357422 45.40489827717806,-75.69416999816895 45.407911249578646,-75.68352699279785 45.41230990069011,-75.68155288696289 45.408875366805994,-75.6807804107666 45.403271205260644,-75.67949295043945 45.400740111355574,-75.68035125732422 45.39766648774011,-75.68395614624023 45.39609947802103,-75.68670272827148 45.39628028905252,-75.68944931030273 45.39519541418556,-75.69219589233398 45.394050245897446,-75.69683074951172 45.39386942773064,-75.69923400878906 45.394170791020564,-75.70489883422852 45.39748568114408,-75.70592880249023 45.396702179209406,-75.70086479187012 45.391217361482845,-75.70652961730957 45.393929700517184,-75.70901870727539 45.39673231410008,-75.6998348236084 45.40095104017867,-75.70232391357422 45.40489827717806)))', 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/the-glebe/
Script Name: /index.asp