select * from profile_images inner join profile_media on profile_images.mediaID=profile_media.mediaID where profile_images.profileID = '122' and profile_media.pending = '0' order by list_order
About Us
San Antonio’s newest premier event facility, Emporium by Yarlen, offers two ballrooms.
The Baroque Room with seating for up to 200, featuring round tables, chivari chairs and custom dance floor.
The Renaissance Room has seating for 200 to 500, mezzanine and two grand spiral staircases. Round table with chivari chairs surrounds the marble dance floor lit by chandeliers.
Free parking and full service, in-house catering make your special day easy to plan.