$collection = $productCollection->addAttributeToSelect('*')
                ->addAttributeToFilter('status', 1)
                ->addAttributeToFilter('retail_price' , array('from' => 501, 'to' => 700));
$collection->load();