err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(107,125) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-63.90145763411301 44.96906880809982,-63.89871105208176 44.516480613889904,-63.60482677473801 44.38315403860671,-63.25326427473801 44.6240956438275,-63.38611072063978 45.04480256666811,-63.90145763411301 44.96906880809982)))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and province='nova scotia' and type2 in ('att/row/twnhouse','condo apt','duplex','fourplex','house','recreational','single family','triplex','two apartment house') and status='a' and idx_approved=1 order by id desc
Query String: Page=36&PageAction=ViewSubCat&URL=/communities/all-of-hrm/
Script Name: /index.asp