err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and (( Geometry::STGeomFromText('polygon((-80.9155703812027 46.53722524116151,-80.91548455051422 46.554580663239285,-80.87291252902985 46.554285549380374,-80.87299835971832 46.580249425720524,-80.87299835971832 46.582550169723746,-80.84347260288239 46.5824911775074,-80.84347260288239 46.55912521400734,-80.84295761875153 46.54253871478065,-80.9075022964859 46.53698907470963,-80.9155703812027 46.53722524116151))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-80.86540838635254 46.49658034488535,-80.86506506359864 46.47565999746457,-80.82910200512696 46.476369293526986,-80.8311619416504 46.4969348577074,-80.86540838635254 46.49658034488535))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-80.8244869157171 46.569695484689504,-80.82452983106134 46.583914107551614,-80.7970210954046 46.58400259352959,-80.79684943402765 46.568928399053114,-80.82444400037286 46.56904641293406,-80.8244869157171 46.569695484689504))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-80.74654556653431 46.68737695528909,-80.75530029675892 46.685963864280055,-80.76517082593372 46.664586354875595,-80.73212601087025 46.664821965798,-80.73186851880482 46.68737695528909,-80.74654556653431 46.68737695528909))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-80.80890371714729 46.64479422760747,-80.75105383311409 46.63465827784867,-80.76255514536994 46.60659772739668,-80.79190924082893 46.597044391093036,-80.84598257456916 46.60730531492573,-80.80890371714729 46.64479422760747))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-80.77702506353761 46.66125320804093,-80.78783973028565 46.64110343480285,-80.75333579351808 46.6349745298629,-80.74123366644288 46.6590736239564,-80.77590926458741 46.66443406495985,-80.77702506353761 46.66125320804093))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-80.80754983564681 46.4947519860009,-80.7987951054222 46.473830935307106,-80.7695268406517 46.47702280206258,-80.78171479841536 46.498592547597944,-80.80754983564681 46.4947519860009))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1)) and sale_lease in ('sale') and type2 in ('agriculture','att/row/twnhouse','business','condo apt','duplex','fourplex','hospitality','house','industrial','institutional - special purpose','manufactured home','manufactured home/mobile','manufacturing','mobile/trailer','modular','multi-family','multi-tenant industrial','no building','office','offices','other','parking','recreational','residential commercial mix','retail','single family','special purpose','triplex','two apartment house','vacant land','warehouse') and status='a' and idx_approved=1
Query String: PageAction=ViewSubCat&URL=/communities/nickel-centre/
Script Name: /index.asp