select  iv.property_description_id,iv.value
from    item_values iv
where   iv.item_id=245
;

 property_description_id |    value    
-------------------------+-------------
                     708 | Company
                      26 | 064F-0193
                      22 | 2007-03-01


select  itv.property_description_id,itv.value
from    itemtemplate_values itv
where   itv.itemtemplate_id =(
        select  i.itemtemplate_id
        from    items i
        where   i.id=245  
        ) 
;

 property_description_id |                 value                 
-------------------------+---------------------------------------
                      34 | Extreme Networks
                      33 | BlackDiamond 8806 - Ethernet 48 ports
                      15 | 48
                      18 | 1000