The Final Four Cylons are outed and they find Earth. It turns out the show does indeed take place in the distant future with the humans being descendants of humans who went off-world after Earth was destroyed in a nuclear war.
Near the end of the episode, the area the landing party arrives at appears to be the Brooklyn side of New York City. The landing party is next to a broad river and across that river to the left is a wide bay. The other shore appears to be the edge of Lower Manhattan with a destroyed skyline of buildings.
The camera pans to the right over what is ostensibly the East River until the last two seconds of the episode, where at the far right edge of the screen stands a wrecked structure with a heavily abbreviated roadway. It appears to be the East Tower (Brooklyn side) of the Brooklyn Bridge. However, it should be noted that the information on this is incomplete.
So it looks like our heroes with the Cylons landed on an area that looked like an atomised Manhattan…