If you are functioning as an "unlicensed agent" and just representing buyers or sellers, it may be illegal.

@Shetal Gandhias a programmer, you are likely ahead of most REI folks in terms of what you can do with data.mash yourself a simple geodatabase from redfin csv's or assessor shapefiles. get up on qgis (20 minutes) and make some visual databases for your programmer self.

@Leigh Ann Smith Is your excel sheet similar in function to the calculator on here for analyzing?

You would think that we would start having these discussions sooner than closing day, but we have a tough time visualizing everything until we're walking through it with no tenant, no furniture, no agent hovering and the ability to really take our time and just hang out in the place for a couple hours.The way I handle it is this.  

I was more curious if anything if you guys have a new function.. like votes or something .. is that what the recommendations are .. like maybe on a post you recommend it to others for reading something like that.

Sadly most prospective tenants still have never heard of heating water with the sun and quite a few figure it is a summer-time only thing.That said, the basic functioning of the system is simple to explain and most folks think its cool once you walk them through it.  

Building constructed in 1980Present loan value appx $77k on a 15 yr note with 3.375% interestP&I pmt is appx $602NOI 2014 was $11489NOI 2013 was $5142      (spent around $4k on updates/remodeling)Appx $27k by my calculations of capital improvements needed in the next 5-10 years to increase the value of the property, properly maintain it, and keep it functionally up to date in order to attract higher quality tenants (located in a b grade area) (I'd rather have more invested to have higher quality tenants - have my own reasons for this line of thinking - willing to sacrifice a bit of profit to have good people)- Redo Kitchens- replace doors and all base trim/casing (more for my taste and would help the place rent out even quicker)- 2 escape windows installed for basement bedrooms- Concrete work needed on patios and near front of the house -- need to be done in the next yearProperty based on comps in the immediate area and a tight supply of decent duplexes here is $175-210k or so.  

The amount you can increase rent on vacancy is a function of both current rent as well as the length of time it has been since the last new lease was issued, plus of course getting the current tenants to vacate/not-renew. 

In my opinion, if a fan functions, then check. 

Generally i am a visual person so the scenerios are so appreciated.