Code Enforcement in my market has just recently started, as part of their tenant turnover inspections, to document the material composing the water inlet pipes where they enter into the basement. 

Does that include materials and labor?

.: Quote from @James Hamling:Fraud for property generally involves material misrepresentation or omission of information with the intent to deceive or mislead a lender into extending credit that would likely not be offered if the true facts were known. 

Via the posting of well defined (defined within the state property code) notices which must be publicised within certain publications/online.In MI the specific Document which must be published is called Notice of Foreclosure by Advertisement.

But unless they advertise the seller finance (and be careful as most are really bad deals), then you'll need to talk them into it.

They are a fraction of the price of those who advertise online.

Quick tips…✅ Everyday Homeowners - track all home improvements as you could qualify for energy efficiency home improvement credit - new exterior windows, new central A/C, new hot water heater, new insulation material.✅ Investors - Keep detailed records of ALL rental property expenses to reduce your taxable income - helping your CPA spot additional tax saving opportunities.Imperative to use a CPA who is well versed in Real Estate tax code.My CPA is just that - DM me to get his contact information....

Does it have material defects such as a roof, foundation, heating system issue etc?

Keep in mind this is sponsor-provided material, not something that the site discovered through research, nor verified. 

Offering custom container home builds featuring:Fully customizable designsSustainable materials and methods8 -week construction timelineSpecial multi unit pricingEnergy-efficient systemsLooking to connect with:Investors interested in container housingProperty developers exploring shipping container housing optionsAnyone curious about container home construction