However- it expanded how/what we can expense all at once...which is why cost segregation (separating out some of the property from 27.5 year) is such a powerful tool. 

As of now I stay in San Diego and searching for a market where I can invest in small multifamily homes(non-commercial).

I've heard Ohio I good place and have over 200 new companies started out this or last year and state is investing 100s of millions into it. also New Mexico is getting Netflix. how do yo guys norrow your search of where its best to invest. any PM you use or recommend?? 

@Mike Bowling check out the tools on the BP website (after you have signed in) Great tool for this, regarding an excell spreadsheet, you’d have to go into the files section of BP.

Online searches are like a needle in a haystack.

I suggest you search for properties yourself and send them to your agent for advice. 

I attend a couple meetup groups in and around NYC(Manhattan, Brooklyn and Jersey City).You may want to open up your search to meetup.com and do a search for real estate.

The property is located in Jersey City, by any chance does anyone know if there is any public portal where i can do my searches? 

Social Media is already being used as a tool in RE so I would definitely get on board asap.

You can do a google search for a 1031 tax calculator to get a ballpark idea (you will need a few data entry points (sale price, depreciation taken, balance on the loan, 1031 fees, etc.)