Determine Post types ..

Is there a way to tell for sure that what type of post it is? by observing the database, I mean by executing a query.
I am using AgentPress theme on my blog and want to need a mechanism to separate general posts and the property listing related blog posts.
TIA