Is a hot/cold utility sink in CO garage a bad idea?

[Great-Kazoo]

Is a utility sink in a garage a bad idea? Here's my option:

Looking for both hot/cold lines and a normal sink drain (not a 5gal bucket option), tied in to plumbing through the basement (currently unfinished).
The wall is an interior wall, but the location is also within a few feet of the 2-car garage door (currently not insulated). Garage is not heated.
There's a hose spigot there currently that I'm going to need to move about 6 inches anyway, so I'll likely replace it and have hot water brought in next to it if so as well. See pic, you can see the spigot and just barely see the garage door opening on the right.
Sink would be semi-built in - not sure if I'm going to spend the cash on this expensive NewAge option, but something like this:
Probably best to assume I won't always turn off the lines underneath the sink, assuming that is an option. So something that stays hooked up more or less all year long, even when I "forget" it.
Bottom line though, I don't need a flooded garage.

So before I get a plumber out here and sound too stupid, is this a realistic option for Colorado temps? Do they make freeze-free sink lines like they do for hose spigots? From what I've read, you can maybe put the trap on the interior (basement) side of the wall to prevent the trap from freezing too...

If you want hot water. Install an on demand unit, instead of running 2 lines from point a-b. If you run water from the house. I'd do a shut off valve, so once the garage is not in use, you tun the water off.

Plumb the faucets in with some Frost Proof Anti-Siphon Outdoor Wall Faucets. You turn them off and there is no water in there.

https://www.homedepot.com/p/Merrill-...MAD8/308176700

Your next problem is the water that will be left in your P-trap. I guess you could plumb that into the basement and put the p-trap in the heated area of the basement.

You need water in the p-trap. No water, allows sewer gasses to seep back in to the dwelling.

[mb504]

You need water in the p-trap. No water, allows sewer gasses to seep back in to the dwelling.

I was envisioning moving the P-Trap into the basement on the backside of the wall. Probably would be a huge code violation, though.