Ok. Nashville, Middle Tennessee, and parts of the rim towards Cookeville, TN had major flooding (500 year level event) in May and August. When looking at homes make sure they were not impacted by the flooding in any manner (ie. actual damage, blocked roads into the area, etc.) As a Nashvillian, I suggest the suburb areas around the city. City proper has issues, though, if you like condo living, they overbuilt downtown, so you can get great deals... Places to look - Centered loosely around Nashville: (starting South, and going counter clockwise around Nashville, roughly) Brentwood (expensive), Franklin (expensive), Crossroads (between Nashville, Nolensville, Brentwood, and Antioch), Nolensville, Smyrna, Mt. Juliet, Hendersonville, Goodlettsville, Greenbrier, Joelton, Hermitage, and Ashland City. I recommend these areas due to you liking Franklin, KY. Further areas out which are good towns: Lebanon, Dickson, and Murfreesboro.
Areas of Nashville to avoid: Anywhere around the Titan's LP Field side of Downtown, except Germantown area. Go to that area in day light. Jefferson Street, up to the Fisk Area/ Tennessee State University areas. Daylight only. Charlotte Ave Close to the interstate loop downtown.
Tourist areas I recommend: Go to the Hermitage, President Andrew Jackson's home, Broadway, downtown Nashville, to go to the Country/Western bars, Fort Negley - the largest stone built Civil War Fort not on an ocean shore, Carter House-Franklin, TN - Battle of Franklin Civil War, Country Music Hall of Fame- Nashville, any of our state Parks in the area - Long Hunter - Cedars of Lebanon, visit our lakes Old Hickory lake and J Percy Priest Lake. NOTE: There will be signs at the state parks prohibiting firearms, due to the recent change in law, they no longer apply to Permit Holders.
What areas you want to stay hotel wise? I may know of a few places.
Personally, I hate Cincinnati, as I had to visit due to work. Much of downtown Cincinnati is crime ridden. IF you have to stay there stay on the Kentucky Side of the River. I suggest the Airport/Turfway area - I stay at the Red Roof there. More Holiday Inn level than Red Roof.
Homes here are less expensive than in other areas - around $200k will get you a good sized 3 bedroom 2 bath home in a safe neighborhood. More in towns further out. Murfreesboro is booming, as is Mt Juliet. Most towns in the area are growing.
What type of business you want to start?
http://www.homes.com/ just put in the town name or zip code to find homes.