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.7547664642334 45.40483801609086,-75.76163291931152 45.39893211771299,-75.76197624206543 45.39242286156868,-75.76086044311523 45.39290505440343,-75.75845718383789 45.38965017293036,-75.75373649597168 45.3923023127172,-75.75253486633301 45.389891281689955,-75.75373649597168 45.38838433506843,-75.7481575012207 45.37946238812381,-75.7426643371582 45.381271004663134,-75.73253631591797 45.39151873891491,-75.73820114135742 45.39031321954434,-75.74197769165039 45.39712406621648,-75.74747085571289 45.39959505543275,-75.74867248535156 45.40152355730053,-75.75322151184082 45.402548047144265,-75.7547664642334 45.40483801609086)))', 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/westboro/
Script Name: /index.asp