err#-2147217900
err desc:Could not find method 'stgeomfromtext' for type 'Microsoft.SqlServer.Types.SqlGeometry' in assembly 'Microsoft.SqlServer.Types'
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: PageAction=ViewSubCat&URL=/communities/barrhaven/
Script Name: /index.asp