select sum(cast(landvalue as float)) from lib_imasset where candid=342947 and landvalue <> 'NA' and landvalue <> 'NA' and landvalue <> 'Not specified' and landvalue <> 'NIL' and landvalue is not null6,622,000

select sum(cast(landvalue as float)) from lib_imasset where candid=342948 and landvalue <> 'NA' and landvalue <> 'NA' and landvalue <> 'Not specified' and landvalue <> 'NIL' and landvalue is not null21,557,660

select sum(cast(landvalue as float)) from lib_imasset where candid=342949 and landvalue <> 'NA' and landvalue <> 'NA' and landvalue <> 'Not specified' and landvalue <> 'NIL' and landvalue is not null2,636,000

select sum(cast(landvalue as float)) from lib_imasset where candid=342950 and landvalue <> 'NA' and landvalue <> 'NA' and landvalue <> 'Not specified' and landvalue <> 'NIL' and landvalue is not null290,000

select sum(cast(landvalue as float)) from lib_imasset where candid=342323 and landvalue <> 'NA' and landvalue <> 'NA' and landvalue <> 'Not specified' and landvalue <> 'NIL' and landvalue is not null14,401,275

select sum(cast(landvalue as float)) from lib_imasset where candid=342327 and landvalue <> 'NA' and landvalue <> 'NA' and landvalue <> 'Not specified' and landvalue <> 'NIL' and landvalue is not null6,686,414

select sum(cast(landvalue as float)) from lib_imasset where candid=342328 and landvalue <> 'NA' and landvalue <> 'NA' and landvalue <> 'Not specified' and landvalue <> 'NIL' and landvalue is not null368,000

select sum(cast(landvalue as float)) from lib_imasset where candid=342329 and landvalue <> 'NA' and landvalue <> 'NA' and landvalue <> 'Not specified' and landvalue <> 'NIL' and landvalue is not null1,456,397

select sum(cast(landvalue as float)) from lib_imasset where candid=342330 and landvalue <> 'NA' and landvalue <> 'NA' and landvalue <> 'Not specified' and landvalue <> 'NIL' and landvalue is not null2,990,439