Is it really possible with current prices and mortgage rates?

They are already going to have to sell at a discount for this to be a viable wholesale deal and then on top of that reduced price they will have to compensate the agent.

While opinions may vary, I rely on data to help drive real estate decisions and planning.Key ConsiderationsEducational Attainment: 77008 boasts higher numbers of residents with bachelor's (12,241) and master's degrees (5,739) compared to 77063.Demographics: 77063 has a higher percentage of foreign-born residents (41.02%) which typically indicates a strong rental market and with 76.86% renter-occupied versus 32.60% in 77008.Economic Factors: Median income in 77008 is $140,609 with a low unemployment rate of 3.37%, whereas 77063 shows lower median income ($51,899), higher unemployment (9.99%), and more families below the poverty level (16.51%), which may indicate economic diversity but also potential rental payment risks​​.Age Distribution: 77008 has more middle-aged residents (35-54) [8970 compared to 6,115] and a slightly higher proportion of young adults (25-34) compared to 77063 but both are popular with younger adults suggesting strong rental markets equally exist.

Long term I anticipate construction costs will generally soften as the high-rate environment continues and stifles development.

Many HELOC or second mortgages are fixed interest rates and depending on the loan amount, even offer 100% online and no appraisal requirement for issuance.

My CPA is saying I have to pro rate those expenses for the number of nights that it was actually rented out, but I can't find anything online that confirms that.

Becoming a Key Principal (KP) in other people’s commercial real estate deals is a great way to shelter your income, participate in several deal at the same time, minimize / spread out risk, capture equity w/ a preferred double-digit return at a discount cash-out-of-pocket investment. 

Either way, would I be taxed at the normal capital gains rate (for me it’s 15%) for each share that sells?

If you're providing an "up-scale" environment and hope to attract more guests of this calibre (I do; they don't quibble about higher nightly rates and rarely cause problems) then I recommend white duvet covers and wash them after each guest.  

I don't know how much you are willing to do personally to recover your money, but it seems like Scott does still care about people hurting his online image (Zero Star ratings on his podcast and book on Amazon, Complaints with BBB, rip off report etc. )  And about not getting reported to the SEC, State Securities Board, etc, so you might try to work those angles in addition to the ones you mentioned.