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(((-75.77215904883076 45.26012262194483,-75.7756781070583 45.2617538115674,-75.78108544043232 45.270392293731845,-75.78632111242939 45.272325200650144,-75.78675026587177 45.27389563905002,-75.78477616003681 45.27697598814835,-75.73108176736736 45.29838368619597,-75.71897964029216 45.27590630230437,-75.72292785196208 45.274758719178344,-75.7320259049406 45.27590630230437,-75.74696044473552 45.270651389412926,-75.75465339770875 45.26689589096545,-75.76375145068727 45.26031102718921,-75.76787132373414 45.25934437739506,-75.77215904883076 45.26012262194483)))', 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
Query String: Page=3&PageAction=ViewSubCat&URL=/communities/barrhaven/
Script Name: /index.asp