I am worried that the value of these homes are not stable and one day could bite me in the ***.

Wood may cost more, but with added weight and proper methods to secure, it could be far more stable. 

I thought Bay Area has the most stable market in US.

IMO, instead of the STR option, I would look at investing into a turn key rental in a less expensive and more stable market.

You also have to consider the increased risk of damage from moving appliances in/out, especially if it's anything with a water connection.Yes, tenants damage appliances, but it's typically a broken shelf, door bar, or crisper drawer.

@Kuriakos Mellos how stable is your job?

Based on my research, Kyle seems to be a stable suburb with good schools.

GL with whatever you do but double your cost and tax expectations and be ready to see huge variations in your net worth which use to be much more stable. 

My income is reliable in a stable career.

Thoroughly vet your potential tenants to ensure they are going to be reliable, clean, law-abiding, financially-stable, etc.