Question: Bayfront Avenue passes what resort that opened in 2010, and was billed as the world's most expensive standalone casino property?

Context articles: Andrea Syngrou Avenue
Central Avenue (Los Angeles)
Marina Bay Sands
Odawa Casino Resort
Miami Riverwalk
Bayfront Avenue
Second Avenue (Manhattan)
Fifth Avenue (Pittsburgh)
Piedmont Avenue (Atlanta)
North Avenue (Atlanta)

Andrea Syngrou Avenue () is a major road in Athens, linking the city centre with Poseidonos Avenue near the Bay of Faliro.
 It is planned, built and later named for Andreas Syngros.
 It runs southwest to northeast.
 The Syngrou Fix station of the Attiko Metro's Red Line is situated near the northeastern end of the avenue.
 The avenue passes through the municipalities of Palaio Faliro, Kallithea and Nea Smyrni as well as Athens.
Central Avenue is a major north-south thoroughfare in the central portion of the Los Angeles, California metropolitan area.
 Located just to the west of the Alameda Corridor, it runs from the eastern end of the Los Angeles Civic Center south, ending at Del Amo Boulevard in Carson.
 From north to south, Central Avenue passes through Downtown Los Angeles, South Los Angeles (including Watts, Florence-Graham, and Willowbrook), Compton, and Carson (where it runs through California State University, Dominguez Hills).
Marina Bay Sands is an integrated resort fronting Marina Bay in Singapore.
 At its opening in 2010, it was billed as the world's most expensive standalone casino property at S$8 billion, including the land cost.
Odawa Casino Resort is a Northern Michigan casino resort.
 Located in Resort Township near Petoskey, Michigan, the casino opened for business on June 20, 2007.
 It is owned and operated by the Little Traverse Bay Bands of Odawa Indians.
 The resort replaced Victories Casino in 2007, which had served as the tribe's casino until the new resort was opened.
 In addition to gaming, Odawa Casino Resort features multiple restaurants and retail outlets, a concert venue (Ovation Hall), a nightclub (The O Zone Nightclub), and a circular lounge bar in the middle of the gaming floor (Rendezvous).
 The resort also includes a AAA Diamond rated Hotel.
 Full shuttle transportation is available to all resort guests.
 Odawa Casino Resort is open to guests of all ages, however, the casino's gaming floor and the O Zone Nightclub are restricted to those of age 21 and older.
 Starting in 2011, the minimum gaming age at Odawa Casino Resort has been approved to be lowered to 19 years old.
The Miami Riverwalk is a pedestrian walkway located in Downtown Miami, Florida.
 It extends along the north side of the Miami River and the Biscayne Bay.
 It begins at Bayfront Park and ends one block west of the South West 2nd Street bridge where the path leads back to South West -North River Drive.
 The Riverwalk is currently blocked at two points along this route by developers, for one block at the mouth of the river by a temporary sales office for the former Epic Residences & Hotel 2 Tower, and at the west side of the South Miami Avenue bridge by the One River Point Condo tower site at Riverfront.
 The Riverwalk passes under the Brickell Avenue Bridge, built in 1915, carrying Brickell Avenue, South Miami Avenue Bridge, Miami Metrorail, South West 2nd Street Bridge, and ends under the I-95 overpass.
 Since 2008, the Miami Riverwalk Festival has been held in November, which includes a lot of free and cultural entertainment.
 The Riverwalk is a part of a broader project known as the Miami River Greenway which also includes an incomplete greenway along the south side of the river.
Bayfront Avenue (Chinese: 贝弗兰道 ) is a road in Singapore running along the southern side of Marina Bay.
 Starting at Marina Boulevard in the west, the road passes the Marina Bay Sands integrated resort.
 The road then passes the Bayfront Bridge at the south while continuing towards Raffles Avenue.
Second Avenue is an avenue on the East Side of the New York City borough of Manhattan extending from Houston Street at its south end to the Harlem River Drive at 128th Street at its north end.
 A one-way street, vehicular traffic on Second Avenue runs southbound (downtown) only, except for a one-block segment of the avenue in Harlem.
 South of Houston Street, the roadway continues as Chrystie Street south to Canal Street.
 A bicycle lane in the left hand portion from 55th to 34th Street closes a gap in the Manhattan Waterfront Greenway.
 The bike lane extends from 125th Street all the way down to Houston Street.
 Second Avenue passes through a number of Manhattan neighborhoods including (from south to north) the Lower East Side, East Village, Gramercy Park, Murray Hill, Upper East Side, Yorkville and Spanish Harlem.
Fifth Avenue (sometimes spelled 5th Avenue) is one of the longest streets in Pittsburgh, Pennsylvania, United States.
 It begins downtown and moves eastward for over five miles (9 km).
 Fifth Avenue passes by the Carlow University, the Cathedral of Learning and other buildings of the University of Pittsburgh, then forms the borders between Shadyside on the north and Squirrel Hill and Point Breeze to the south.
 Finally, after passing Chatham University, The Ellis School, and Mellon Park, it turns north and forms the border between Larimer on the west and North Point Breeze and Homewood (Pittsburgh) on the east.
 At the intersection with Frankstown Avenue its name becomes Washington Boulevard (PA 8) and descends a branch of Negley Run to meet Allegheny River Boulevard (PA 130) near the Highland Park Bridge.
Piedmont Avenue is a major thoroughfare in Atlanta, beginning in Downtown Atlanta and ending at its continuation as Piedmont Road (Georgia State Route 237) just before crossing under Interstate 85.
 Along the way, Piedmont Avenue passes through Midtown Atlanta where several historic properties are located on the street.
North Avenue is a major avenue in Atlanta, Georgia that divides Downtown Atlanta from Midtown Atlanta.
 North Avenue stretches continuously in Atlanta from Candler Park in the east, across Interstate 75 & Interstate 85, along the southern boundary of the Georgia Institute of Technology, to Joseph E. Lowery Boulevard (formerly Ashby Avenue) just southwest of Georgia Tech, where it ends.
 North Avenue passes through the neighborhoods of Poncey-Highland, Old Fourth Ward, and Midtown Atlanta.