Is Schedule C the correct place for this property ?  

What was the purpose for purchasing the property ?     

Building for business location ?       Buy, Fix, Flip ?        Rental?   

The only purpose of this single member LLC was to buy this property, demolish and build a new property and sell it. The old property was demolished but nothing was built and it was finally sold. It is under the name of the company not the taxpayer. That's why I think it should be reported under the schedule C for that company.

If the property wasn't owned by the SMLLC disregarded for tax purposes, where would you report the sale?

Well it would have been Schedule D, if it was under client name.

And it still is.

Even though it's not under the name of the taxpayer? Is there an option to show it's connected to schedule C?

Yes.

No. Schedule C is only appropriate if this was a business. Having something titled in the name of an LLC does not make it a business.

SMLLC disregarded for tax purposes means it is disregarded for tax purposes. You make believe it had John's name on it instead of John LLC.