A friend suggested setting the high school rating above 7 in the Redfin search engine, along with other filters, for my house search.

When I talk to my local bank, the options appear to be only a commercial loan with relatively high interest (currently 8.5-10%), 75% LTV max and maximum amortization of 20 years. 

True.You just can't advertise a property that you don't own as it is now highly illegal is SC and no attorney is going to close these deals anymore.

Now, if you want a fully legal duplex, including having the property reclassified, Scott Mac offered the basic outline of steps.  

Hey Angela, what might save your client a ton of money and still get what they need is to reach out to an accounting firm that offers asset protection services.

It’s free and offers great features for rent collection, which makes it perfect for managing a few units and scaling up as you grow.Before Cozy.co was bought out by Apartments.com, it was a good option, but now it has limited features, especially with billing and handling utility changes consistently.Venmo is another option, but for staying organized and efficient, Innago is definitely worth a look.Hope this helps!

Off market deal fell into my lap and negotiated a cash offer using a line of credit How did you finance this deal?

@Varun Hegde - This is a good topic.Often a title policy is issued to "XYZ Entity or Individual(s) and/or it's assigns" – however unless the title company handling my closing can perform a date down from when the existing title policy is ordered and issue an update in my name, I purchase a new policy at closing and factor the cost into my offer price. 

However if it is rough and deteriorating/cracking then you might want to budget a high amount for removing it safely (which is not cheap) then residing the entire property.I'd try to negotiate the price down either way!

These factors collectively present a high-return, low-risk investment opportunity that aligns well with my strategic growth goals.