err#-2147217871
err desc:Query timeout expired
sql:select id from propertiesfreeholdandcondos with (nolock) where board in(76) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( Geometry::STGeomFromText('multipolygon(((-75.70789217948914 45.414757631798565,-75.69481372833252 45.4201272056012,-75.68992137908936 45.42000671585693,-75.6863808631897 45.42163330570959,-75.67945003509521 45.41881686582582,-75.68333387374878 45.41215926761822,-75.68807601928711 45.41032151179173,-75.69361209869385 45.40767021770054,-75.69777488708496 45.40592270582535,-75.70215225219727 45.404657232443576,-75.70789217948914 45.414757631798565)))', 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: PageAction=ViewSubCat&URL=/communities/centretown-ottawa/
Script Name: /index.asp