In my opinion, even if I wanted to take Sofia to the farm and have her in the guest room, it's not worth it considering we lose Emma's invitation to the farm and the cryptid quest. There should be some option like: betraying Sofia, she ends up in the guest room, and then Emma discovers the information about the cryptids and asks if we can help put Mario in jail.
Hello there,
this is not possible since Mario only really trusts you fully and rewards you with the guest room key AFTER you share Emma with him. At that point Emma is corrupted and has no interest in taking Mario down, nor fix his mistakes, which is what she's doing in the cryptids quest after finding out some of the things he's done.