Where to go for SQL replication advice?

Does anyone have any suggestions on where to go for SQL replication questions/consulting?

Here at work we've setup a replicating system, but it doesn't work well, so we are hoping to find a better out of the box solution.

We have one master database that holds all of the information for all our properties. There are 5-6 tables in that database that have a property code field that is property specific. We need to replicate this whole database out to 150+ properties. The catch is that in the 5 or 6 tables that have a property code column, we only want to send the data for that particular property to each property, we don't want to send all the information, for all properties, to every property. The rest of the tables should all replicate as normal. We also want to get property specific data and pull it back into the master tables.

Anyone have any experience with anything like this? Any place to begin looking?

Thanks for your help!