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.60891458514538 45.43545925805149,-75.60436555865613 45.437386535422156,-75.60917207721081 45.445817599977694,-75.6004173469862 45.44515520479836,-75.59440919879285 45.44738323039172,-75.58711359027234 45.45045414845057,-75.58376619342175 45.45141753926957,-75.59003183368054 45.44208399824822,-75.59621164325085 45.4367842683147,-75.60582468036023 45.43190566783699,-75.60891458514538 45.43545925805149)))', 4326).stintersects(geometry::stgeomfromtext('point(' + cast(longitude as varchar(20)) + ' ' + cast(latitude as varchar(20)) + ')', 4326))=1) and status='a' and idx_approved=1
Query String: PageAction=ViewSubCat&URL=/communities/beacon-hill-cyrville/beaconhill-south/
Script Name: /index.asp