In NYC, NYU/Stern, the CCNY schools, and Stevens just across the river https://www.stevens.edu/school-business/undergraduate-programs
CMU/Tepper in Pittsburgh
Emory/Goizueta in Atlanta
In the Boston area, MIT/Sloan if your son is a super-amazing student!..Tufts (has econ with finance minor, not a formal undergrad business degree), Babson https://stuart.iit.edu/programs/undergraduate-programs , and Brandeis http://www.brandeis.edu/business/index.html
and WPI in Worcester https://www.wpi.edu/academics/business/undergraduate
In Rochester, UofR https://www.rochester.edu/college/bsb/undergraduate/bs-degree.html
and RIT https://saunders.rit.edu/undergraduate/undergraduate-degrees-demand-careers#
Case Western Reserve in Cleveland https://weatherhead.case.edu/degrees/undergraduate/academics/
Catholic U in DC https://business.catholic.edu/academics/undergraduate-programs/index.html
Trinity in San Antonio https://new.trinity.edu/academics/departments/school-business
Rhodes in Memphis https://www.rhodes.edu/business
KZoo https://reason.kzoo.edu/econ/major/
In Chicago, UIC http://business.uic.edu/undergraduate-programs
and IIT https://stuart.iit.edu/programs/undergraduate-programs
In the Seattle/Tacoma area, U of Puget Sound https://www.pugetsound.edu/academics/departments-and-programs/undergraduate/school-of-business-leadership/ and Pacific Lutheran https://www.plu.edu/busa/bachelor-of-business/
In suburban LA (maybe not urban enough) Chapman and Claremont McKenna (the latter a top econ school but more econ/management than business/finance)
For financial safeties, look to the U of Wisconsin campuses that offer discounted tuition through the MHEP program. Milwaukee would be the most urban of these I think, and it has a good-sized business school, but they’re all (except for Madison) D3 and they have business programs of varying size and scope.
http://uwm.edu/business/academics/undergrad/
https://msep.mhec.org/institution/university-wisconsin-milwaukee
The problem with wanting a sports management program and wanting to play is that these programs are most often at D1 schools. Syracuse is a great place for this… and Drexel is a “major city” school with a terrific co-op program in this field http://drexel.edu/sportmanagement/academics/BS-in-Sport-Management/ and great co-op business programs too https://www.lebow.drexel.edu/academics/undergraduate/areas-of-study , but again a D1 school. A lot of the D1 schools do have club teams, so that’s another way to be on a team without having to confine the search to D3 schools.
Hope that helps!