A year ago I watched this video and was intrigued.

https://www.youtube.com/watch?v=2Z4vz5Ms0rE

A company has started putting high end manufactured housing in an older mobile home park in a prime neighborhood of Palm Springs. Last weekend we were down there on vacation and I suggested to SO that we take a look. The homes are really nice and obviously well built. They currently have four models they are selling, ranging from a 600 sq foot 1 bed/1 bath for $150k to a 1000 sq foot 2 bed/2 bath. All of them have a lot of outside deck space and a covered parking area that can hold 2 cars tandem.

There are issues we'd need to sort out from a practical standpoint (not least of which that SO still needs to be in San Francisco for work, so we'd have to be bi-home-al and also factor in the cost of him commuting weekly between Palm Springs and SF.) (since I work from home I could simply move down there and go on with my life occasionally coming to SF on the company dime when I need to be here for work meetings and the like.) Ignoring all that for the moment my main concerns are the big picture financial issues which seem to center around 3 things that I can think of:

1. Although the mobile home park is in a prime location and is definitely going upscale as a result of this company's efforts to replace the older old-school mobile homes (currently around 50% replaced), it's still a mobile home park. And the company selling the new and improved homes is not directly affiliated with the mobile home park owner, so presumably has limited control over what the park owners may or may not do. How significantly will that effect our resale value?

2. The park itself (again, not affiliated with the sellers of these homes) has a 65 year lease. We'll be long dead before that ends, but at what point do home values for homes on rented land begin to lose value? If we move there and like it I expect that after 10 years or so we'd probably view it as our forever home and this question would stop mattering since we don't have any kids that we need/want to pass assets on to.

3. How nervous should I be that we'd be buying an expensive asset that relies on a rented space to place it. Current rent for a spot in the park is $686/month, going up 5% on january 1. That seems reasonable for now, especially since water/trash/sewage/pool and other common space is included in the rent. But should I worry that they may double that rent next year or the year after? What do we do then?

This is the link to the company that is selling the homes: https://www.palmcanyonmobileclub.com/

At the end of the day the home itself, as well as the park, seemed quite nice. Public spaces like the pool area have all been recently redone and are finished. And overall this seems much preferable from a lifestyle standpoint, at least in my mind, to purchasing a similar size/cost condo in Palm Springs. If I weren't nervous about dropping $250k of our assets into this and potentially not being able to come close to being made whole by selling I would totally do it. But I don't want to be stuck a few years down the road with an asset that isn't worth anywhere near what we paid for it.

Everyone's thoughts/experiences will be much appreciated.