I have to excavate the sidewalk in order to run a new pipe.

This is what I see from right to left:6 cop cars lining the street so no one can enter or leave.12 cops on the sidewalk looking confused.3 contractors on the stoop of the property protecting it.2 angry guys with a truck next to the property.The problem started with the angry guys so I walk up and put on my late night dj voice and talk slow, “ Hi my name is Jared, I believe I purchased this property on Monday from the seller.

Do the streets have sidewalks?

The Connecticut statute also specifically provides protection to the tax deed purchaser against any liability for any condition existing or occurrence upon the property or adjoining public sidewalks and streets, or for any failure to act to remedy or investigate any such condition or occurrence during such redemption period. 

Footage of the property for landscape area as well as parking/sidewalk areas?

Maybe they'll spend some money on the lighting and sidewalks and the road nearby, but don't give it too much weight.  

So how much life is left on your roof, water heater, furnace, decks, garage door, sidewalk, driveway and then take the years left and divide by the cost it takes to fix it.

They can walk the sidewalk and go into the ally to see them, and if the neighbors have easy access they can look from their property, but they can't go onto yours even if you just bought the property and had to pay for the inspection.2.

However, in a big snow I anticipate needing someone to clear the sidewalk and do some alley clean-ups since the City can ticket the Owner the sidewalks are not shoveled. 

Boston  requires the following:DO: Remove snow, slush, and ice from sidewalks and curb ramps abutting your property within 3 hours of snowfall ending (or 3 hours from sunrise if snow falls overnight) as required by law.