Welcome to 1223 Columbus Ave, a beautifully designed newer construction 3 bedroom, 2.5 bath home located in Pittsburgh’s Manchester neighborhood within the Columbus Square community. This home offers modern living, generous ceiling heights, private outdoor space, and the convenience of a detached 2 car garage with additional driveway parking. Step inside to an inviting open concept main level featuring impressive 10-foot ceilings, a spacious living room and dining area, a convenient half bath, and a well-appointed kitchen with a gas stove, large center island, abundant cabinet storage, and a pantry. Upstairs, 9-foot ceilings continue throughout the bedroom level, including a spacious primary suite with a modern en-suite bath and walk-in closet, plus two additional bedrooms and a full bath. Enjoy outdoor living from the covered front porch or relax and entertain in the private courtyard with a garden. Set in a pleasant, walkable neighborhood across from Manchester Park, the home is just minutes from Downtown Pittsburgh, Acrisure Stadium, PNC Park, Stage AE, the National Aviary, Children’s Museum of Pittsburgh, Rivers Casino, restaurants, shopping, and public transportation. Newer construction, exceptional parking, private outdoor space, and a convenient North Side location make 1223 Columbus Ave a standout opportunity.
Partially renovated brick row home in Pittsburgh’s historic Manchester neighborhood. The heavy lifting is underway, and it’s ready for a buyer to finish it and make it their own. This 2-story home offers 3 bedrooms, 1.5 baths, and approximately 1,914 sq ft, Finish it as your own home, a rental, or a resale in a neighborhood that continues to see investment, just minutes from the North Shore, Downtown, and major bus routes. Sold as-is.
Built in 1905, this attached end-unit rowhome offers approximately 1202 finished square feet, two bedrooms, one full and one-half bath, unfinished basement and sits on an approximate 1742 square foot lot. This home is in uninhabitable condition.
Welcome to Brighton-Beech: Industrial Heritage Meets Organic Modern Design Welcome to Brighton-Beech, a distinctive three-bedroom, three-bath contemporary residence where industrial history meets warm, organic craftsmanship. Once a distribution warehouse for the Chase Brass & Copper Company, this remarkable property has been thoughtfully reimagined with architecture reminiscent of Frank Lloyd Wright. Located in Pittsburgh’s Allegheny West Historic District, directly across from West Park and Lake Elizabeth, this one-of-a-kind home blends architectural character, modern luxury, and exceptional urban convenience—with the added benefit of an oversized two-car garage. The Main Level Step inside to an open-concept living space defined by soaring exposed industrial ceilings and a striking combination of steel, timber, and original character. The living room flows into a sunken dining area, creating architectural interest while maintaining an open, connected feel. The kitchen is both functional and beautifully appointed, featuring hard-surface countertops and a full suite of Viking appliances. The primary suite offers a private retreat, complete with a spacious bedroom, en-suite bathroom with soaking tub, walk-in closet with laundry, and custom built-in closets flanking the bed. Thoughtful design and integrated storage bring comfort and functionality to this inviting space. The Upper Level Upstairs, warm wood-inlaid ceilings introduce a handcrafted, Wright-inspired aesthetic. A den or office sits at the top of the staircase, while the bedroom features floor-to-ceiling windows opening onto the deck. A full bathroom completes this level, creating a private and versatile space ideal for guests, extended stays, or a separate work-from-home retreat. Outdoor Living & Garage A lush, L-shaped rooftop deck extends the living space outdoors, offering a private setting for morning coffee, relaxing afternoons, and evening entertaining. An additional side yard, accessible from Brighton Road, provides room for gardening, quiet reading, or creating your own outdoor sanctuary. An oversized two-car garage adds exceptional convenience and valuable functionality, with generous room for parking and additional storage—a welcome feature in this distinctive urban neighborhood. The Lower Level The expansive lower-level family room offers remarkable flexibility, with ample space for movie nights, a home gym, or a second gathering area. This level also includes a third bedroom, a full bathroom, and a personal sauna—an uncommon luxury that brings a spa-inspired experience to everyday living. An Exceptional Pittsburgh Location Enjoy West Park and Lake Elizabeth just across the street, with the stadiums, neighborhood restaurants, and the shops and dining along Western Avenue and East Ohio Street nearby. Downtown Pittsburgh is easily accessible, putting the city's cultural attractions, dining, and entertainment within convenient reach. Allegheny West's architectural heritage and vibrant community are celebrated through neighborhood traditions, including the annual Victorian Christmas House Tour and the Wine & Garden Tour. Brighton-Beech is more than a renovation—it is a distinctive expression of industrial heritage, architectural artistry, and contemporary comfort. With its striking design, thoughtfully arranged living spaces, private rooftop deck, personal sauna, oversized two-car garage, and exceptional location, this remarkable residence offers a lifestyle unlike any other in Pittsburgh.
Built in 2013, this Columbus Square home offers the best of both worlds—the character of one of Pittsburgh's most beloved neighborhoods paired with the comfort and peace of mind of newer construction. From morning coffee on the welcoming wraparound porch to evenings spent cooking, gathering, and relaxing, every space was designed to feel like home. The open-concept great room flows effortlessly into the beautifully appointed kitchen, featuring granite countertops, a large center island, GE Profile stainless-steel appliances, pantry, and an abundance of cabinetry—making it just as perfect for hosting friends as it is for everyday life. The main-level owner's suite provides a private retreat with a spacious walk-in closet and en-suite bath, while three additional bedrooms upstairs—including a guest suite with its own private bath and walk-in closet—offer flexibility for family, visitors, or a dedicated home office. Step outside to enjoy not one, but multiple outdoor living spaces. The wraparound porch invites you to slow down and enjoy the outdoors while being covered from the elements, while the two fenced side yards create the perfect setting for grilling, gardening, pets, or simply unwinding at the end of the day. Complete with first-floor laundry, an oversized two-car garage, and an unbeatable location just minutes from Downtown Pittsburgh, the North Shore, and major highways, this home offers the rare opportunity to enjoy modern living in a neighborhood full of history, community, and charm. The Pittsburgh Esplanade is planned to bring restaurants, retail, riverfront green space, entertainment, a marina + Pittsburgh’s very own Ferris wheel—all within walking distance of 1207 Columbus Ave.
Spacious Manchester home offering exceptional versatility and opportunity! This 4-bedroom, 2.5-bath residence is a great opportunity for a primary residence, investment property, or potential Airbnb. The home features luxury vinyl flooring throughout, ceiling fans and lighting accents, and decorative fireplaces, some with exposed brick details. The newly designed kitchen offers granite countertops, a stone backsplash, stainless steel appliances, a center island, and plenty of cabinet and countertop space for preparing and serving meals. Off the dining room is a convenient stacked washer and dryer. The generously sized primary bedroom faces the front of the home with plenty of natural light from the windows, and the primary bath includes a claw foot soaking tub and a stand-up shower. Additional rooms on floor 2 and 3 provide flexible space for guests, sitting rooms, a home office, or other needs. Enjoy two decks off bedrooms on the second and third floors, plus a rear 2-car garage and backyard area ideal for entertaining or relaxing. Located on a tree-lined street in Pittsburgh's historic Manchester neighborhood, near the area of the future Esplanade development. Convenient to Downtown Pittsburgh, major thoroughfares, I-376 and the Pittsburgh International Airport.
Completely renovated from the inside out. Historic Victorian character. TWO off-street parking spaces. Now offered at $290,000. If you love the character of Pittsburgh's historic homes but have no interest in taking on a renovation, 1413 Columbus Avenue deserves your attention. Behind the beautifully restored Victorian façade is a surprisingly modern 2-bedroom, 1-bath home that has been taken down to the studs and thoughtfully rebuilt. New windows, furnace, central air, an updated kitchen, contemporary finishes, and a bright, open living space make this home truly move-in ready. The exterior restoration was completed by hand in coordination with the Manchester Historic Society, preserving the architectural details that give this property its distinctive character. And unlike many city homes, this one comes with TWO dedicated off-street parking spaces. Located in Pittsburgh's historic Manchester neighborhood, with convenient access to Downtown, the North Shore, hospitals, restaurants, entertainment, and major highways. The expensive renovations are already done. The parking is included. The historic charm is still there. Come see the inside. It's worth the showing.
A remarkable opportunity to own this large old Victorian Manse in the Heart of Historic Allegheny West. Western Avenue is home to many local restaurants, diners, bars and shopping options. Steps away from entertainment venues such as River's Casino, Acrisure Stadium, PNC Park, The Children's Museum, Allegheny commons Park home to the National Aviary. This 4 unit building has a strong record of tenancy, Two LARGE units offer one bedroom per unit and two Studio units are offered on the first floor. as well as off street parking, ample storage and many updated features. With both residential AND commercial zoning the options are limitless offering you a great investment opportunity, business or convert back to the Magnificent single family home of years past. home warranty included!
Welcome to 1005 Sheffield Street in Pittsburgh’s developing Manchester neighborhood—an opportunity for investors or buyers looking to bring a property to its full potential in a growing area. This home has seen some updates already, offering a starting point for the next owner, while still leaving room for additional improvements and customization. With a spacious layout, high ceilings, and original character throughout, the possibilities here are easy to envision. Natural light fills the main living areas, and the home offers multiple rooms that can be reimagined to suit a variety of needs—whether for resale, rental, or owner-occupant renovation. Located just minutes from the North Shore, stadiums, and downtown Pittsburgh, this property offers strong upside in a location that continues to see growth and development. The home is priced to reflect its current condition and the work needed, presenting a valued opportunity for the right buyer.
Beautifully renovated Mexican War Streets charmer! Fully renovated from the studs in 2016, you will find elegant, exaggerated woodwork throughout the entire home, from crown molding and detailed window casing to decorative fireplaces. To provide modern convenience and efficiency, thoughtful custom built-ins and smart-home upgrades are seamlessly integrated throughout this 4 bedroom, 2.5 bath home. The first floor features a cozy living room, dining room, half bath, and a fully equipped kitchen with brand-new Samsung Bespoke appliances, including an induction range, microwave/convection oven, refrigerator with dual ice dispensers/auto-fill pitcher, and an island with seating for the audience while the chef is cooking! On the second floor, two bedrooms offer versatility, with the possibility of a full-floor owner’s suite or individual rooms. The expansive primary bathroom is a spa-like retreat, featuring a jetted tub, heated toilet seat, a double vanity, and a glass-enclosed walk-in shower with a custom tile surround. The third floor houses two more bedrooms, another fully-renovated bathroom with a classic white tiled shower/tub, and a laundry closet equipped with high-end smart washer and steam dryer. Skylights in the hallway ensure maximum natural light flow. Step outside to discover a charming small fully enclosed courtyard between the house and the garage. This intimate space provides room for some light gardening and a convenient spot for your pets to take a quick bathroom break. The oversized 1-car garage is a showstopper, featuring two overhead garage doors. One door is solid against the alley, while the other is fully glass, providing a seamless transition to the courtyard. This versatile garage can be used as a seasonal outdoor entertaining space or as a parking area. Additionally, the garage roof was built to accommodate a rooftop deck, adding to its functionality. The front facade of the house just completed a full restoration including total refurbishment of the slate mansard roof, new copper gutters & flashing, and composite porch floor, all designed to be maintenance free. A new hybrid heat pump H2O tank was recently installed to enhance energy efficiency. Great dry storage space, work areas, and cabinets can be found in the basement. Smart switches, cameras, doorbells convey along with the smart hub they operate through. Ethernet is run through much of the house for networking success! This home is located in one of Pittsburgh’s most walkable neighborhoods, just a short stroll away from charming shops, restaurants, museums, and the sports stadiums. The neighborhood also boasts beautiful public park space, offering residents a chance to enjoy nature and recreation!
LOCATION, LOCATION, LOCATION! Situated in the shadow of the transformative Esplanade project, this timeless Arts & Crafts home spanning a double lot has been completely rehabbed into a stunning single-family home with high-end modern touches and sunlight pouring in from all four sides. This extensive renovation was completed down to the studs, incorporates all-new wiring, plumbing, mechanical systems, windows and flooring. Featuring two expansive front porches and minimal exterior maintenance, this home offers exceptional curb appeal in Pittsburgh's next IT neighborhood with easy access to light rail transportation, stadiums, dining and concert venues. Enter through the custom period-inspired glass front door and be welcomed into a warm Arts & Crafts-style living room highlighted by rich wainscoting and a classic brick fireplace. New hardwood floors seamlessly connect the main living spaces, including the dining room, hearth room, powder room and impressive 24x11 custom kitchen. Designed for both beauty and functionality, the kitchen features butcher-block countertops, soft-close cabinetry, custom refrigerator panels, a five-burner gas range, and a charming eat-in area. Thoughtfully selected designer lighting fixtures throughout the home provide sophisticated and elegant finish. The second floor offers a versatile den/office centered around a second brick fireplace, with direct access to an expansive south-facing porch--an ideal retreat for afternoon reading or enjoying sunset views of the Pittsburgh skyline. Also located on this level are a convenient laundry room, a beautifully appointed full bath with custom 31"x52" ceramic tile shower, a spacious secondary bedroom with three west-facing windows and a luxurious owner's suite featuring a spa-inspired bath and walk-in closet. The third floor provides additional flexibility with another bedroom, a large 29x15 game room, and an adjacent half bath--perfect for entertaining, recreation or guest accommodations. The basement offers abundant storage space and even includes the potential for a future wine cellar beneath the front porch. Ideally situated three blocks from the Esplanade, Pittsburgh's transformative $740 million riverfront development, residents will enjoy walkable access to dining, entertainment, recreation and employment opportunities. Also within walking distance are Acrisure Stadium, PNC Park, the Carnegie Science Center and the light rail station, providing convenient access to Downtown Pittsburgh and the Cultural District. This exceptional home combines custom craftsmanship, upscale finishes and modern efficiency with the charm of a historic neighborhood poised for significant growth and appreciation. A rare opportunity to own a truly distinctive residence in a neighborhood that not only has one of Pittsburgh's most distinctive pasts, but also its most promising future.
Welcome to 928 Western Avenue, a fully renovated home in one of the area’s most charming and historic neighborhoods. Blending timeless character with modern luxury, this residence offers the rare combination of a walkable urban setting, a quiet residential feel, and beautifully updated living spaces designed for both everyday comfort and effortless entertaining. Perfectly situated near Acrisure Stadium, PNC Park, The Rivers Casino, Allegheny Commons Park, The Children's Museum and The National Aviary, this home places you just moments from some of the city’s most exciting destinations. You will also enjoy easy access to nearby restaurants, entertainment, coffee shops, and neighborhood favorites, all while coming home to a quaint, peaceful street that feels tucked away from the bustle. The location offers the best of both worlds: the energy of city living with the calm and charm of a close-knit, walkable area. Inside, the home features four spacious bedrooms and three and a half baths, providing plenty of room for family, guests, or a flexible home office setup. Every space has been thoughtfully renovated with an emphasis on style, function, and livability. The first floor has an open, inviting layout that creates an ideal setting for hosting gatherings, relaxing at the end of the day, or simply enjoying the flow of a well-designed home. At the heart of the residence is a chef’s kitchen that is both beautiful and highly functional. Whether you are preparing a quiet dinner at home or cooking for a crowd, this kitchen is equipped to handle it all with ease. The layout supports connection and conversation, making it easy to stay engaged with guests or family while cooking. Multiple gathering areas on the first floor provide flexible space for different activities, whether that means quiet conversation, playing games, lounging with friends, or spreading out while meals are being prepared. Attention to detail is a theme throughout this fantastic home including laundry on the second and third floors, a cozy wine room on the lower level as well as off-street parking - all adding to convenience and ease in this walkable location. From morning coffee runs to evening outings, everything you need is close by, yet the home itself remains a peaceful retreat at the end of the day. The historic setting adds to the overall appeal, giving the property a sense of place and character that is not easy to find. This home is more than just a house, it is an opportunity. With its fully renovated interior, generous bedroom and bath count, chef’s kitchen, off-street parking, and exceptional location near major attractions and neighborhood amenities, this home offers a unique chance to enjoy city living in a setting that feels both vibrant and serene. Thoughtfully updated and ideally located, it is ready to welcome its next owner home.
Come and discover amazing Northside Historic District with great views, historic, and fantastic urban living experience. This neighborhood offers a fantastic convince to public transpirations and free subway. A short distance to many exciting entertainments (PNC Park, museums, theaters, Steelers stadium, farm market, restaurants and lovely trail by the river. Location of the property offers a wonderful opportunely to make extra income by renting bedrooms through Airbnb rentals. This redesigned brick 3 level townhouse with 3-bedroom, 1½ bath comes with a double lot, backyard patio, garden and parking space. A new front door, roof, windows, back porch patio, AC/ furnace and water heater systems,all new kitchen appliances, fresh painting on the 1st floor and bath hardware and accessories. Finished basement - perfect playroom or office. A Large laundry room comes with extra storage space. A house comes with older security system. Last new 2 windows willing to prepay before closing.
Welcome to 1411 W North Avenue in Pittsburgh’s up-and-coming Manchester—a solid opportunity for investors or buyers looking to add value in a prime location just minutes from the North Shore, stadiums, and downtown Pittsburgh. This home offers a flexible layout, including a main-level bedroom—an increasingly desirable feature for a variety of living situations. With multiple living spaces and a functional footprint, the potential here is easy to see. Some updates have been completed, while additional improvements will allow the next owner to customize and build equity over time. The home is priced accordingly to reflect its current condition and the opportunity it presents. Conveniently located near major roadways, public transportation, and the growing amenities surrounding the North Side, this property is well-positioned for both long-term hold or resale. Whether you’re looking for your next project or an entry into a developing neighborhood, this is one worth exploring.

The data relating to real estate for sale on this web site comes in part from the IDX Program of the West Penn MLS. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Copyright 2026 West Penn Multi-List™. All rights reserved.
Pittsburgh is located in Pennsylvania. Pittsburgh, Pennsylvania 15233has a population of 303,207. Pittsburgh 15233 is less family-centric than the surrounding county with 24.35% of the households containing married families with children. The county average for households married with children is 27.79%.
The median household income in Pittsburgh, Pennsylvania 15233 is $54,306. The median household income for the surrounding county is $66,659 compared to the national median of $69,021. The median age of people living in Pittsburgh 15233 is 33.7 years.
The average high temperature in July is 83.5 degrees, with an average low temperature in January of 21 degrees. The average rainfall is approximately 38.3 inches per year, with 27.7 inches of snow per year.