Hi,
Greetings!!
I am a senior magento developer having 4+ years of experience in magento and PHP.
I have gone through your given issue and i find that the product attribute model is not get the proper result from database that's why you can see your products in your store.
I can do it in easy way with your 100% of satisfaction within given timeline.
I am new in this portal so my first priority is to give your best quality work to get some nice review and rating.
So please give me a chance to work in your project. I premiss you, i will never let you down.
Awaiting your response on same,
Regards,
Sitesh Saurabh