@BeriCollection What I did was asked ChatGPT to create a Python script that would search Google Custom Search Engine and my ApI for Google Search in Google Cloud for urls containing services from my services list, + city locations from my locations list. i pulled a lot of local prospects for tier 1 links that way. Other than that, have you tried Moz Local? If you have a local business, that's a great way to get 30+ of them really fast.

Hey guys! We are targeting a number of cities in the Nassau and Suffolk County areas for foundation repair, insulation, and mold remediation keywords, and we were debating on creating city-specific pages for each location and service, or creating one service page for each type of service that contains all of the services and solutions within that service category for each city.

Example:

1. City-Specific Pages for Each Service: One page for say foundation repair, one page for foundation crack repair, one page for foundation problems, etc. (for each target city)
2. Service Category Pages for Each City: One page for foundation contractors that lists all services on one page in sections.

Which one do you think is better for local SEO and rankings?

Both seem to have their advantages and disadvantages to me. Just to throw a couple out there, the category pages may not rank as high as the city pages for each individual service if our competitors have a whole page designed for that service and we only have a part of a page covering the topic. At the same time, they would save labor hours, technical issues would be less, and they would be condensed, and we would have WAY less mess on the backend.

I appreciate your expert opinion on this one. The site is www. zavzaseal.com in case you want to check us out.