Available Listings

$1,000,000 (USD)
Active

Shadyside Area Single Family Home

Active

5884 Ellsworth Ave Shadyside, PA 15232

3 Bed
5 Baths
sqft
MLS# 1757733
Virtual Tour
Unique Mixed-Use Opportunity in the Heart of Shadyside
Welcome to 5884 Ellsworth Avenue, a truly unique and iconic Shadyside property offering endless possibilities for investors, entrepreneurs, artists, and owner-occupants alike. Home to the renowned Photo Forum since 1986, this one-of-a-kind property consists of three distinct units: a commercial café space, a residential apartment/art gallery, and a separate two-bedroom house.
The main building features a charming 30-seat café on the first floor, currently configured for food and beverage service. Rich in local history, the space once housed the beloved Con Alma before its move downtown. Guests can enjoy a beautifully landscaped 35-seat outdoor patio complete with a tranquil koi pond and mature gardens, creating an inviting urban oasis.
The upper levels of the main building offer exceptional live/work flexibility. The second floor is currently home to the Photo Forum photography gallery and includes a kitchen with access to a private deck. The residential space extends to the third floor, offering a spacious one-to-two-bedroom apartment highlighted by a stunning solarium. Above it all, a rooftop deck provides breathtaking panoramic views of Shadyside and the surrounding neighborhoods.
Adding even more value, the property includes a separate two-bedroom house located at the rear of the lot with alley access, creating additional rental income potential, guest accommodations, or owner occupancy options.
Outdoor living and entertaining spaces abound, from the café patio to the private residential deck and expansive rooftop terrace. Situated in one of Pittsburgh's most walkable neighborhoods, the property enjoys constant foot traffic and is just steps from the shopping, dining, and entertainment districts of Shadyside and East Liberty. Major universities, hospitals, and employment centers are only a short drive away.
Whether you're seeking an investment opportunity, a live/work environment, or a landmark property with character and history, 5884 Ellsworth Avenue is a rare offering unlike anything else on the market.
Listing Courtesy of West Penn MLS, Inc / Listed By: Sarah Orbin, Coldwell Banker Realty
$1,000,000 (USD)
Active

Shadyside Area Multi-Family Home

Active

5884 Ellsworth Ave Shadyside, PA 15232

Bed
0 Baths
sqft
MLS# 1757830
Virtual Tour
Unique Mixed-Use Opportunity in the Heart of Shadyside
Welcome to 5884 Ellsworth Avenue, a truly unique and iconic Shadyside property offering endless possibilities for investors, entrepreneurs, artists, and owner-occupants alike. Home to the renowned Photo Forum since 1986, this one-of-a-kind property consists of three distinct units: a commercial café space, a residential apartment/art gallery, and a separate two-bedroom house.
The main building features a charming 30-seat café on the first floor, currently configured for food and beverage service. Rich in local history, the space once housed the beloved Con Alma before its move downtown. Guests can enjoy a beautifully landscaped 35-seat outdoor patio complete with a tranquil koi pond and mature gardens, creating an inviting urban oasis.
The upper levels of the main building offer exceptional live/work flexibility. The second floor is currently home to the Photo Forum photography gallery and includes a kitchen with access to a private deck. The residential space extends to the third floor, offering a spacious one-to-two-bedroom apartment highlighted by a stunning solarium. Above it all, a rooftop deck provides breathtaking panoramic views of Shadyside and the surrounding neighborhoods.
Adding even more value, the property includes a separate two-bedroom house located at the rear of the lot with alley access, creating additional rental income potential, guest accommodations, or owner occupancy options.
Outdoor living and entertaining spaces abound, from the café patio to the private residential deck and expansive rooftop terrace. Situated in one of Pittsburgh's most walkable neighborhoods, the property enjoys constant foot traffic and is just steps from the shopping, dining, and entertainment districts of Shadyside and East Liberty. Major universities, hospitals, and employment centers are only a short drive away.
Whether you're seeking an investment opportunity, a live/work environment, or a landmark property with character and history, 5884 Ellsworth Avenue is a rare offering unlike anything else on the market.
Listing Courtesy of West Penn MLS, Inc / Listed By: Sarah Orbin, Coldwell Banker Realty
$710,000 (USD)
Active

Ehrman Farms Area Single Family Home

Active

502 Sword Dancer Pl Cranberry Twp, PA 16066

4 Bed
5 Baths
3136 sqft
MLS# 1757622
Virtual Tour
Ehrman Farms! Exceptional 4 Bedroom, 4.5 Bath custom built residence blends classic architecture and craftsmanship with modern comfort. This beautifully landscaped, level yard offers an ideal setting for everyday enjoyment or memorable gatherings. Step inside to the impressive 2-story foyer, where an elegant Palladian window creates a light-filled space and highlights the exquisite custom woodwork and trim throughout. A richly appointed private den provides the perfect work-from-home retreat with custom built ins. The warm and inviting family room features a gas fireplace and opens to an expansive covered deck overlooking the lush backyard—an effortless extension of your living and entertaining space. The designer-inspired island kitchen showcases rich cherry cabinetry and also offers direct access to the deck with glass doors. Upstairs, the luxurious Primary Suite includes a spacious spa inspired bath and generous walk-in closet. A private guest suite with its own bath, plus two additional bedrooms connected by a Jack & Jill bath complete the upper level. The walk-out game room with full bath adds even more flexible living space—ideal for recreation, guests, or hobbies. An oversized 3-car garage provides abundant storage and convenience. Just a short stroll from the community park and less than a mile from the acclaimed Ehrman Crest Schools, this home offers unmatched comfort, craftsmanship, and location. Immaculate condition and new roof 2025. Please allow 24 hours to show - if possible. Thank you.
Listing Courtesy of West Penn MLS, Inc / Listed By: Deborah "Debi" Platts, Coldwell Banker Realty
$659,000 (USD)
Active

Upper St Clair Area Single Family Home

Active

2358 Golfview Dr Upper St Clair, PA 15241

4 Bed
4 Baths
3004 sqft
MLS# 1758220
Welcome to 2358 Golfview Drive — where timeless elegance meets one of Upper St. Clair’s most coveted addresses.

Perfectly positioned on a premier street adjoining St. Clair Country Club, this residence offers a rare opportunity to become part of one of Upper St. Clair’s most prestigious golf course communities. From the moment you arrive, the governor’s driveway and inviting front porch create a sense of warmth and pride of ownership that carries throughout the home.

Inside, a classic center-hall floor plan provides the perfect balance of sophistication and everyday comfort. Sunlit living spaces flow effortlessly from the formal living and dining rooms to a private study, creating inviting places to gather.

At the heart of the home, the spacious kitchen and family room blend together seamlessly, with a beautiful brick fireplace and offering direct access to the outdoor living area perfect for hosting holiday gatherings or enjoying quiet evenings at home.
Step outside to discover a private backyard retreat featuring a spacious exposed-aggregate patio and fully fenced yard—an ideal setting for summer barbecues or morning coffee.

Upstairs, four generously sized bedrooms provide comfort and flexibility for family and guests alike. The owner’s suite offers a peaceful sanctuary complete with dual closets and a private en-suite bath. A large pull-down attic with standing headroom provides exceptional storage rarely found in homes of this era.

The finished lower level expands the living space even further, featuring a game room with wet bar, additional kitchen area, powder room, and abundant storage—perfect for entertaining, hobbies, fitness, or multi-generational living.

Beyond the property itself, the location is truly exceptional. Residents enjoy quick access to South Hills Village, dining, shopping, major transportation routes, and the award-winning Upper St. Clair School District—consistently recognized as one of the region’s most sought-after school systems.

2358 Golfview Drive is more than a home—it is an opportunity to create your next chapter in a neighborhood where community, tradition, and exceptional living come together. A place where children ride bikes to friends’ homes, neighbors become lifelong friends, and every season brings new memories waiting to be made. Welcome home
Listing Courtesy of West Penn MLS, Inc / Listed By: Ann "Annie" Augustine, Coldwell Banker Realty
$500,000 (USD)
Active

Wilkinsburg Area Multi-Family Home

Active

300 S Trenton Ave Wilkinsburg, PA 15221

Bed
0 Baths
sqft
MLS# 1757811
Virtual Tour
Few investment properties offer this level of character, flexibility, and existing revenue potential. Located just steps from Regent Square and Wilkinsburg's growing collection of restaurants, coffee shops, and neighborhood amenities, 300 S. Trenton Avenue is a beautifully restored three-unit property where thoughtful design and historic craftsmanship have been transformed into a truly distinctive income-producing asset.
The striking brick exterior immediately captures attention with its steep gables, original architectural details, and artfully crafted metal fire escapes that showcase the care and creativity invested in the property's restoration. Inside, each residence offers its own unique personality while sharing a common theme of thoughtfully designed living spaces filled with natural light, character, and warmth. Refinished hardwood floors, exposed brick accents, oversized windows, custom built-ins, exposed ductwork, reclaimed materials, and carefully curated finishes create an aesthetic rarely found in traditional investment properties. Dedicated work-from-home spaces, loft-inspired layouts, and abundant natural light make each residence feel more like a boutique urban loft than a conventional rental. The property features two spacious 1-bedroom, 1-bath apartments along with a beautifully designed studio apartment currently operating as a successful short-term rental. The Airbnb unit has generated $19,959.77 in income during 2025 alone, providing an attractive supplemental revenue stream and demonstrating the property's strong income-producing potential. The dramatic third-floor residence is particularly memorable, featuring soaring vaulted ceilings, exposed brick, corrugated metal architectural details, and an open-concept layout that creates a truly one-of-a-kind living experience. Beyond the interiors, residents enjoy private outdoor spaces, mature landscaping, and a surprisingly large, flat rear yard rarely found in this walkable urban setting. The corner lot location enhances natural light throughout the building while providing easy access to nearby shopping, dining, parks, public transportation, and the vibrant amenities of both Wilkinsburg and Regent Square. Whether you're seeking a fully leased investment, an owner-occupied opportunity with supplemental rental income, or a distinctive multifamily property with proven short-term rental performance, 300 S. Trenton Avenue delivers a compelling combination of historic character, creative design, flexibility, and income potential in one of Pittsburgh's most connected east-end neighborhoods.
Listing Courtesy of West Penn MLS, Inc / Listed By: Ryan Bibza, Coldwell Banker Realty