Unique landmark single-family home, 824 S. Front Street aka 104 Queen Street, with an additional attached property, 108 Queen Street, with a two car garage + 2 apartments. One-of-a-kind is the only way to describe 824 S. Front Street aka 104 Queen Street. Sitting prominently along the corner at Front and Queen Streets, this almost 5,000 SqFt property was transformed into a stately city mansion offering a main residence with 5 bedrooms, 3.5 bathrooms, and a 2-car garage, plus two updated studio apartments. The exterior of this towering 3-story home is historic Philadelphia at its best, featuring a pristinely kept red brick facade and tall windows framed by shutters and marble stone. Inside, the expansive main level is made for entertaining with plenty of room for guests to gather and two street level entrances. It's completely open and filled with natural light from nine windows that trace the north and east walls. Ornate banisters trim openings to the family room, kitchen, and staircase below, creating a bright, airy feel. The center opening extends up all three stories to a skylight on the roof, forming a lightwell in the middle of the home. Beautiful hardwood floors extend to a mudroom with a storage closet and a closet for the gas furnace. You'll find more storage in the attached oversized 2-car garage, in addition to the gas water heater and one of two washer/dryers pairs. On the lower level of the home, there's a cozy family room with a fireplace, built-ins, and an aquarium at the front. In the middle, the dining area flanks one side of the staircase, with a pantry and powder room on the other side. The large kitchen is fitted with inset cabinetry, top-of-the-line stainless steel appliances, a wood-burning pizza oven, and a peninsula with seating. Off the kitchen, there's a secluded courtyard patio, perfect for enjoying a morning cup of coffee or an evening glass of wine from the humidity-controlled wine cellar. The home's second level has three bright bedrooms, one currently used as a walk-in closet, and a full bathroom with access to a private balcony. On the third level of the home, the primary suite sits at the front. There's a large bedroom anchored by a fireplace, a spa-like ensuite bathroom equipped with a dual head rainfall shower, a bidet, and a full walk-in closet. Completing this level is another bedroom suite and a laundry closet. A separate entrance at the rear of the property leads to the two spacious studio apartments above the garage. Both are updated with modern flooring, kitchens, and bathrooms. In addition to everything inside this phenomenal home, 824 S. Front St aka 104 Queen St's highly sought-after Queen Village location earns a Walk Score of 89! Nearby, South St is lined with friendly shops, popular restaurants, and markets, including Whole Food. Target, Wine & Spirits, Ikea, and Lowes are also close by. Plus, multiple parks are within walking distance, and there's easy access to I-95 and South Jersey. Schedule your in-person or virtual tour today!