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 board in(125, 76) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( geometry::stgeomfromtext('multipolygon(((-75.7016372680664 45.427371178989105,-75.68035125732422 45.418575880487644,-75.68361282348633 45.41243040685833,-75.69846153259277 45.40586244583094,-75.70584297180176 45.403934092069,-75.70318222045898 45.39947452188043,-75.7093620300293 45.39682271867569,-75.71253776550293 45.4026685741398,-75.7203483581543 45.408333052890484,-75.72386741638184 45.41002023463975,-75.72918891906738 45.417310690588415,-75.72052001953125 45.42110617524166,-75.70489883422852 45.42453996532349,-75.7016372680664 45.427371178989105)))', 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 ('att/row/twnhouse','condo apt','garden home','house','single family') and status='a' and idx_approved=1
Query String: Page=4&PageAction=ViewSubCat&URL=/communities/somerset/
Script Name: /index.asp