The best areas for shophouses are in the Historic Districts, which include Boat Quay, Chinatown, Kampong Glam, and Little India. These areas are among the city's oldest and most intact, making them highly desirable for their historical value and unique charm.