I haven't read through all the responses, but yes, technically, there can be such a thing as a "free standing" (i.e., single-family home) condo.
While we tend to think of condos as simply apartments that we own, a condominium is simply an entity. It can be an apartment style house, or a townhouse, or a single family home.
I've never seen a single-family home condo, but I'd imagine they do exist. Most likely, the condo association would own the land that the building sits on, and might be responsible for the exterior maintenance, major structure, etc.
Basically, like an HOA, but with more control over you.
As for this listing, I'd imagine one way to determine whether it's in a condo association, or simply an HOA, is, who is responsible for cutting the grass and landscaping? If there's a company that comes in and handles that, it's a condo. If you're responsible for handling it, but you can get in trouble if you don't, it's an HOA. And if you're responsible for it, but won't get in trouble if you don't cut the grass (although in some areas the city or county will still get you), then it's neither.
If it's a condo, your property taxes should be lower, since you don't own the land. However, the condo fee can be fairly high, and unpredictable.
On Redfin, it's referred to as a "Detached condo." it also says that the HOA fee (Redfin doesn't always distinguish between an HOA fee and condo fee) covers lawn care/snow removal. HOA's usually cover snow removal, but not lawn care. Also, there is no list of the square footage of the lot, so that leads me to believe this is indeed a condo entity, rather than just a house with an HOA.