Sounds like a SQL error. What is the datatype of the "Smoking" and "Kitchen" columns? If its looking for a integer or a booleon, use 1 or 0 instead of yes, no.
Also this is just personal preference, but i prefer using one "input" for the checkbox and integrate the if statment inside it.
example:
<input type="checkbok" name="Kitchen" <cfif rsUnit.Kitchen eq 'yes'>checked</cfif> />
pound signs are not required in a cfif either.
hope that helps