But my husbi wants to keep it as he thinks it'd appreciate gradually. 

On the other hand people keep telling me there’s never a “good or bad time to buy”.Sorry for the barrage of questions but would really appreciate any advice/insight!

Unit A is about 100 years old and Unit B is almost completely new.Pros:-The duplex is in a very desirable neighborhood with home value appreciation year over year at about 50+%-Rent is also in high demand within this area-Cash flows well even with high interest rates and increasing property taxes-Home is price below average cost per sq ft-The house has been renovated and some parts of it has been remodeledCons:-All issues are with Unit A, the 100 year old unit.

. - Half of REI is about appreciation over time.

All advice is greatly appreciated.

The math will tell the tale.When analyzing, assume little/no appreciation for 3-5 years and anticipate rents will stagnate.

Some of the strategies I've used in the past are:-comparable sales data nearby-take pictures to show damage or deteriorating conditions of the property-show low rental income or conditions if applicableAny advice would be appreciated.

I am looking for a growing market with lots of appreciation value.  

. $40k is a great starting point, but a 203k will allow you to stretch it far further and even create substantial forced appreciation. 

You'll attract the guests that will appreciate that and are willing to pay more for it.