err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(17,82,47,110,14,43) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and (( Geometry::STGeomFromText('polygon((-79.81550860378775 44.38887508139616,-79.82014346096548 44.38887508139616,-79.82700991604361 44.396848132616014,-79.81293368313345 44.4053106445841,-79.82786500440852 44.42635123724486,-79.84906518511707 44.42500270845005,-79.87335849436931 44.42787135705804,-79.90734744700603 44.42051555879403,-79.93395496043377 44.44981065564735,-79.92039371165447 44.45544735716766,-79.90185428294353 44.46451395283957,-79.89189791784156 44.45606000933442,-79.88245654210914 44.45961326514755,-79.86975360021461 44.46745416799541,-79.8690669547068 44.47884610291949,-79.86494708165992 44.48117321390827,-79.85464739904273 44.47259918816467,-79.82992816076148 44.48435753864193,-79.83782458410133 44.492807384065195,-79.8335330496775 44.494889042089476,-79.79473757848609 44.49856237498484,-79.79078936681617 44.50027651781153,-79.80040240392555 44.493419636664825,-79.75474047667376 44.44429596469177,-79.77293658230337 44.438413053813754,-79.76315188381705 44.42799394585415,-79.76555514309439 44.42725840922086,-79.76933169338736 44.43130374616484,-79.77791476223501 44.428361710699924,-79.76298022309493 44.408989617694516,-79.81550860378775 44.38887508139616))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-79.67285478101985 44.41574605670907,-79.67697465406673 44.389194024113365,-79.6862443684222 44.388642006215015,-79.68564355360286 44.390727378964066,-79.69199502455012 44.390604712035596,-79.69834649549739 44.398270900959176,-79.70074975477473 44.39520454590357,-79.70298135267512 44.395511188639965,-79.70890367083484 44.40152106211556,-79.71705758624012 44.399558722400066,-79.71791589312488 44.399681370560494,-79.71988999895984 44.3987001780782,-79.7240957026952 44.39679907081996,-79.72426736407215 44.39587915780261,-79.72692811541492 44.39606314151623,-79.73224961810047 44.39354864736063,-79.73757112078601 44.389746036337606,-79.74212014727527 44.38845799916997,-79.7464116816991 44.393058001756955,-79.73920190386707 44.3961244692922,-79.73714196734363 44.39606314151623,-79.73491036944324 44.39716703165011,-79.7295888667577 44.39931342507393,-79.73027551226551 44.40047857710273,-79.73044717364246 44.40103048312309,-79.73199212603504 44.40354465577901,-79.72649896197254 44.40795952701321,-79.71980416827137 44.4158073647884,-79.71551263384754 44.4170334941677,-79.71413934283191 44.41660435180944,-79.70881783949153 44.410105524506335,-79.70753037916438 44.41071865218543,-79.70675790296809 44.40918582093622,-79.70504128919856 44.411147837736415,-79.69259583936946 44.4162978196253,-79.68667352186458 44.40973764481371,-79.67285478101985 44.41574605670907))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1)) and type2 in ('agriculture','att/row/twnhouse','condo apt','duplex','fourplex','garden home','house','mobile/trailer','modular','multi-family','single family','triplex','two apartment house','unknown','vacant land') and status='a' and idx_approved=1
Query String: PageAction=ViewSubCat&URL=/smart-search/school-zones/barrie-north-collegiate/
Script Name: /index.asp