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('multipolygon(((-78.78760054606931 44.3956234800625,-78.72168257731931 44.25611976820374,-78.44290450114744 44.3278779027137,-78.42779829997556 44.29053529435051,-78.29046919841306 44.32394822064491,-78.27673628825681 44.29643307515749,-77.97598555583494 44.37697671635075,-78.06524947185056 44.55883215971816,-78.38659956950681 44.57057311354517,-78.47998335856931 44.48441775767252,-78.78760054606931 44.3956234800625)))', 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 order by id desc
Query String: Page=5&PageAction=ViewSubCat&URL=/communities/RuralNorth/
Script Name: /index.asp