Where Chesapeake Bay sunsets meet sophisticated coastal living, this exceptional waterfront residence offers an effortless blend of architectural elegance, refined comfort, and the unmistakable charm of historic Havre de Grace. Welcome HQME to 505 Concord Street, Unit Q, an impeccably maintained three-bedroom, two-bathroom end-unit condominium in the desirable waterfront community of Heron Harbor. Offering captivating harbor views, thoughtful upgrades, and an exceptional location, this beautifully appointed residence presents a rare opportunity to enjoy the best of Chesapeake Bay living. From the moment you enter, distinctive architectural details create an immediate sense of sophistication. A graceful barrel-vaulted hallway illuminated by ambient cove lighting leads to a striking central rotunda, setting the stage for the expansive, light-filled interiors beyond. Gleaming solid hardwood floors, refined finishes, and an open, flowing floor plan create an inviting atmosphere equally suited to intimate evenings at home and elegant entertaining. At the heart of the residence, a beautifully appointed kitchen features granite countertops, stainless steel appliances, a generous pantry, and an expansive breakfast bar. The adjoining dining area offers ample space for formal gatherings and flows seamlessly into the waterfront living room, where a natural gas fireplace provides warmth and ambiance. Step outside onto the private balcony to take in sweeping harbor views and unforgettable sunsets—a picturesque backdrop for morning coffee, evening cocktails, or simply watching life unfold along the waterfront. The thoughtfully designed split-bedroom floor plan offers an exceptional degree of privacy. Positioned to capture tranquil water views, the generously sized primary suite serves as a peaceful retreat, complete with a walk-in closet, secondary closet and a spacious ensuite bath featuring a soaking tub, separate walk-in shower, dual vanities, and a private water closet. On the opposite side of the residence, two additional bedrooms, a full bathroom, and a dedicated laundry room with additional storage provide comfortable accommodations for family and guests. Thoughtful upgrades further enhance the home's comfort and functionality, including motorized window shades, customizable closet organization systems, and a newer Bosch dishwasher featuring CrystalDry technology. The conveniences of luxury condominium living extend beyond the residence, with a designated covered garage parking space, elevator access, and a private garage-level storage closet for seasonal belongings and recreational equipment. For those drawn to life on the Chesapeake, community boat slips are available for rent, making it easy to spend the day exploring the Bay and return home to the comfort of your waterfront retreat. Just beyond your doorstep, the charm of historic Havre de Grace awaits. Enjoy leisurely strolls along the waterfront promenade, discover locally owned boutiques and antique shops, dine at inviting restaurants, and experience the town's vibrant calendar of festivals, markets, and community events. Convenient access to Interstate 95 provides an easy connection to Baltimore, Philadelphia, and beyond. Whether envisioned as a sophisticated full-time residence or an elegant Chesapeake Bay getaway, this exceptional property offers a rare combination of waterfront beauty, refined comfort, and low-maintenance living. Schedule your showing today to discover a lifestyle where every day feels like a waterfront escape!