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.91671288013458 45.40278910087822,-75.95928490161896 45.37554352048221,-75.9064131975174 45.33428850817599,-75.89336693286896 45.33211635862253,-75.88615715503693 45.32004734399728,-75.83671867847443 45.340804456964136,-75.79517662525177 45.346837074327055,-75.7592685520649 45.36607682761242,-75.75437620282173 45.37065962839337,-75.75772359967232 45.37584498148168,-75.75804747641087 45.37735226237295,-75.76083697378635 45.37777429382285,-75.7637981325388 45.37705080940884,-75.76736010611057 45.37819632212288,-75.7690767198801 45.380185841682085,-75.77710188925266 45.384164670788884,-75.8399024605751 45.370719925928746,-75.8647933602333 45.3763876072309,-75.91671288013458 45.40278910087822)))', 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','duplex','fourplex','garden home','house','modular','multi-family','single family','triplex','two apartment house') and status='a' and idx_approved=1
Query String: Page=5&PageAction=ViewSubCat&URL=/communities/bay-ward/
Script Name: /index.asp