Select *, f.ListingIdentityColumn as FeaturedID, ((Unix_timestamp(Now()) - Unix_timestamp(DatePosted)) /(24*3600)) as NumDaysPosted, DateDiff(OpenHouseDate,CurDate()) as DaysUntilOpenHouse FROM RealEstateListings r LEFT JOIN RECategory c on c.Code = SUBSTRING(r.Category,1,1) left join Featured f ON f.ListingIdentityColumn = r.IdentityColumn WHERE r.RealtorID = 'pcc' AND r.Status in ('S','U','P','B') AND r.Status <> 'dfsafl;djf' AND (r.DateExpires is NULL OR r.DateExpires > CURDATE() OR r.DateExpires = '0000-00-00') AND r.Category IN ('R') ORDER BY Price DESC
Select *, f.ListingIdentityColumn as FeaturedID, ((Unix_timestamp(Now()) - Unix_timestamp(DatePosted)) /(24*3600)) as NumDaysPosted, DateDiff(OpenHouseDate,CurDate()) as DaysUntilOpenHouse FROM RealEstateListings r LEFT JOIN RECategory c on c.Code = SUBSTRING(r.Category,1,1) left join Featured f ON f.ListingIdentityColumn = r.IdentityColumn WHERE r.RealtorID = 'pcc' AND r.Status in ('S','U','P','B') AND r.Status <> 'dfsafl;djf' AND (r.DateExpires is NULL OR r.DateExpires > CURDATE() OR r.DateExpires = '0000-00-00') AND r.Category IN ('U') ORDER BY Price DESC
Select *, f.ListingIdentityColumn as FeaturedID, ((Unix_timestamp(Now()) - Unix_timestamp(DatePosted)) /(24*3600)) as NumDaysPosted, DateDiff(OpenHouseDate,CurDate()) as DaysUntilOpenHouse FROM RealEstateListings r LEFT JOIN RECategory c on c.Code = SUBSTRING(r.Category,1,1) left join Featured f ON f.ListingIdentityColumn = r.IdentityColumn WHERE r.RealtorID = 'pcc' AND r.Status in ('S','U','P','B') AND r.Status <> 'dfsafl;djf' AND (r.DateExpires is NULL OR r.DateExpires > CURDATE() OR r.DateExpires = '0000-00-00') AND r.Category IN ('F') ORDER BY Price DESC
Select *, f.ListingIdentityColumn as FeaturedID, ((Unix_timestamp(Now()) - Unix_timestamp(DatePosted)) /(24*3600)) as NumDaysPosted, DateDiff(OpenHouseDate,CurDate()) as DaysUntilOpenHouse FROM RealEstateListings r LEFT JOIN RECategory c on c.Code = SUBSTRING(r.Category,1,1) left join Featured f ON f.ListingIdentityColumn = r.IdentityColumn WHERE r.RealtorID = 'pcc' AND r.Status in ('S','U','P','B') AND r.Status <> 'dfsafl;djf' AND (r.DateExpires is NULL OR r.DateExpires > CURDATE() OR r.DateExpires = '0000-00-00') AND r.Category IN ('A') ORDER BY Price DESC
Select *, f.ListingIdentityColumn as FeaturedID, ((Unix_timestamp(Now()) - Unix_timestamp(DatePosted)) /(24*3600)) as NumDaysPosted, DateDiff(OpenHouseDate,CurDate()) as DaysUntilOpenHouse FROM RealEstateListings r LEFT JOIN RECategory c on c.Code = SUBSTRING(r.Category,1,1) left join Featured f ON f.ListingIdentityColumn = r.IdentityColumn WHERE r.RealtorID = 'pcc' AND r.Status in ('S','U','P','B') AND r.Status <> 'dfsafl;djf' AND (r.DateExpires is NULL OR r.DateExpires > CURDATE() OR r.DateExpires = '0000-00-00') AND r.Category IN ('L') ORDER BY Price DESC
Select *, f.ListingIdentityColumn as FeaturedID, ((Unix_timestamp(Now()) - Unix_timestamp(DatePosted)) /(24*3600)) as NumDaysPosted, DateDiff(OpenHouseDate,CurDate()) as DaysUntilOpenHouse FROM RealEstateListings r LEFT JOIN RECategory c on c.Code = SUBSTRING(r.Category,1,1) left join Featured f ON f.ListingIdentityColumn = r.IdentityColumn WHERE r.RealtorID = 'pcc' AND r.Status in ('S','U','P','B') AND r.Status <> 'dfsafl;djf' AND (r.DateExpires is NULL OR r.DateExpires > CURDATE() OR r.DateExpires = '0000-00-00') AND r.Category IN ('H') ORDER BY Price DESC
Select *, f.ListingIdentityColumn as FeaturedID, ((Unix_timestamp(Now()) - Unix_timestamp(DatePosted)) /(24*3600)) as NumDaysPosted, DateDiff(OpenHouseDate,CurDate()) as DaysUntilOpenHouse FROM RealEstateListings r LEFT JOIN RECategory c on c.Code = SUBSTRING(r.Category,1,1) left join Featured f ON f.ListingIdentityColumn = r.IdentityColumn WHERE r.RealtorID = 'pcc' AND r.Status in ('S','U','P','B') AND r.Status <> 'dfsafl;djf' AND (r.DateExpires is NULL OR r.DateExpires > CURDATE() OR r.DateExpires = '0000-00-00') AND r.Category IN ('M') ORDER BY Price DESC
Select *, f.ListingIdentityColumn as FeaturedID, ((Unix_timestamp(Now()) - Unix_timestamp(DatePosted)) /(24*3600)) as NumDaysPosted, DateDiff(OpenHouseDate,CurDate()) as DaysUntilOpenHouse FROM RealEstateListings r LEFT JOIN RECategory c on c.Code = SUBSTRING(r.Category,1,1) left join Featured f ON f.ListingIdentityColumn = r.IdentityColumn WHERE r.RealtorID = 'pcc' AND r.Status in ('S','U','P','B') AND r.Status <> 'dfsafl;djf' AND (r.DateExpires is NULL OR r.DateExpires > CURDATE() OR r.DateExpires = '0000-00-00') AND r.Category IN ('C') ORDER BY Price DESC
Select *, f.ListingIdentityColumn as FeaturedID, ((Unix_timestamp(Now()) - Unix_timestamp(DatePosted)) /(24*3600)) as NumDaysPosted, DateDiff(OpenHouseDate,CurDate()) as DaysUntilOpenHouse FROM RealEstateListings r LEFT JOIN RECategory c on c.Code = SUBSTRING(r.Category,1,1) left join Featured f ON f.ListingIdentityColumn = r.IdentityColumn WHERE r.RealtorID = 'pcc' AND r.Status in ('S','U','P','B') AND r.Status <> 'dfsafl;djf' AND (r.DateExpires is NULL OR r.DateExpires > CURDATE() OR r.DateExpires = '0000-00-00') AND r.Category IN ('B') ORDER BY Price DESC

Real Estate for Sale in Pittsfield, Pike County, IL and elsewhere in Northeast Missouri