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(101,76) and 1=1 and lattlongchecked = 1 and latitude is not null and longitude is not null and ( geometry::stgeomfromtext('multipolygon(((-75.62434673309326 45.37328251176074,-75.61696529388428 45.37572439727473,-75.61267375946045 45.37539278937981,-75.60928344726562 45.37457883448435,-75.6013011932373 45.37626702418105,-75.59670925140381 45.372981037101155,-75.61928272247314 45.36441848584695,-75.62434673309326 45.37328251176074)))', 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/hunt-club/
Script Name: /index.asp