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((-81.01150517326222 46.50807807169921,-81.01150517326222 46.501815955146306,-81.0046387181841 46.49703026665595,-80.99468235832082 46.489053183124916,-80.98644261222707 46.484916456945136,-80.98292355399953 46.48686666705367,-80.97854618888722 46.48964411832704,-80.97923283439503 46.514221334052806,-81.01124768119679 46.51357159875698,-81.01150517326222 46.50807807169921))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-81.04146008354054 46.47256350264193,-81.01716999870168 46.50442779808682,-81.0115910039507 46.501769261982986,-81.00523953300343 46.49739716438346,-80.99493985038625 46.48894738507761,-80.98618512016164 46.48481065085181,-80.98053688696827 46.48830305957858,-80.97066635779346 46.483634381398765,-80.99126572302784 46.47074911508213,-81.03220696143116 46.46944859760866,-81.04146008354054 46.47256350264193))', 4326).STIntersects(Geometry::STGeomFromText('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) or ( Geometry::STGeomFromText('polygon((-81.07695808472077 46.4649024261336,-81.07730140747468 46.479089394866705,-81.06811752380769 46.483817562644816,-81.05558624329011 46.48369936345817,-81.04949226440827 46.4685677473322,-81.07678642334382 46.46366089041876,-81.07695808472077 46.4649024261336))', 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/west-end/
Script Name: /index.asp