I thought it could be confusion with the walk pattern(store spacing-so they dont conflict). That's not the problem...Im assuming a bug withing the game. I have tried many things, even having someone else buy it, even empty with nothing there but the green sign and a register(maxis register) and same thing, cant get in. Cant even be/get in build mode if a sim owns it. argh...
At this point, having made other lots and such, Im not really missing that lot anymore. If dozing opens it up to be playable again, then goodie.

If anyone else has this issue go ahead and post. Im keeping my fingers crossed that someone out there knows how to remedy this without having to demolish hard spent time working on an awsome lot.
Oops, forgot to mention, I do not have FFP...waiting for the patch to fix all the bugs before I get it! heehee
Nothing 'midievil' either...