SELECT
    sa.accountno AS accountno,
    s.saledate AS SaleDate,
    s.saleprice AS saleprice, 
    s.improvedflag AS improvedflag,
    s.grantor AS grantor,
    s.grantee AS grantee, 
    s.receptionno AS recpno,
    d.deeddescription AS deed, 
    CASE 
        when s.saleprice = '0' AND s.improvedflag = '0' then 'N/A'
        when s.saleprice > '0' AND s.improvedflag = '0' then 'Vacant'
        when s.saleprice > '0' AND s.improvedflag = '1' then 'Improved'
        else NULL
    end ImprovedFlagDescription
from
    tblsale s
    inner join tblsaleacct sa
        on (sa.receptionno = s.receptionno)
    inner join tlkpdeedtype d
        on (sa.receptionno = s.receptionno)
where
    s.verend = '99999999999'
    and sa.verend = '99999999999'
order by
    sa.accountno,
    s.saledate; 

select distinct
        a.accountno
      , a.parcelno
      , p.privateflag
      , p.name1
      , p.name2
      , a.businessname
      , ad.address1
      , ad.address2
      , ad.city
      , ad.statecode
      , ad.zipcode
      , ad.province
      , ad.country
      , ad.postalcode
from    tbladdress ad
inner join tblperson p
        on  p.personcode = ad.personcode 
inner join tblacctowneraddress o
        on  o.addresscode = ad.addresscode 
		and o.personcode = p.personcode 
inner join tblacct a
        on  a.accountno = o.accountno 
where   a.acctstatuscode = 'A'
        and a.accountno not like 'P%'
        and p.privateflag != '1'
        and o.primaryownerflag = '1'
        and a.verend = '99999999999'
        and p.verend = '99999999999'
        and o.verend = '99999999999'
        and ad.verend = '99999999999'
order by a.accountno ;

     Jul 13  

Sometimes this is me