So I moved my entire operation downstairs and tried hooking the Desktop up directly to the Router but it didn't work. I took the cable from the computer that was working and used it on the Desktop and the Laptop, it didn't work. Short of actually seeing what's going on on the machine, I' m not sure where else to go with it. Normally I don't use the wizard to do the configuration, but in this case it might actually help. If that doesn't work, maybe going thru the network setup again using the wizard (varies depending on which OS we're talking here) might trip the setting that's giving you grief.
can you turn OFF the wireless connection before you connect via the ethernet cable? Can't imagine that's doing anything, but easy enough to try.
But perhaps it's interface specific in this case. I would have thought the firewall would already be configured to allow the 192.168.1.x network in as a trusted network. I suspect we're dealing with a firewall block on the client PC. Having gone thru a variety of configuration tests on the modem/switch and confirming other computers on the switch aren't having issues. the 'limited connectivity' message, that would imply the network card is seeing link, but not getting a DHCP to succeed.