The bold red door is just the beginning. Step inside 2004 Main Street and you'll find a home that's been thoughtfully restored from top to bottom — three floors of original Pittsburgh character, modern finishes, and the kind of details that make guests extend their stay and come back next year.
THE SPACE
The open main floor flows from living room to dining room to gourmet kitchen without a single wasted inch. The living room is anchored by an oversized sectional, wall-mounted flat screen with surround sound, and a glass-door cabinet stocked with board games and puzzles. French doors open to the enclosed bonus room — part sunroom, part office, with a futon that converts for a child or young teen. Original staircase spindles, dark wood millwork, and hardwood floors throughout remind you this home has a century of soul.
The dining room is made for evenings that run long. A glass-top table with painted blue Queen Anne chairs seats the group in style, anchored by an original fireplace surround and a framed Café Arabica print that sets the room's whole vibe. The brass bar cart is ready before you've unpacked.
The gourmet kitchen means business. Dark cabinetry, butcher block island, stone countertops, a commercial Rangemaster gas range with pot filler, KitchenAid mixer, Keurig station, wall wine rack, and a full suite of stainless appliances. This is the kitchen you actually cook in.
THE BEDROOMS
Level 2 — Primary Suite: King bed with a custom upholstered headboard, antique lamps, original dark wood doors, and direct access to the clawfoot bath. Quiet, warm, full of character.
Level 3 — The Attic Suite: The most distinctive room in the house. Soaring vaulted ceilings, king bed, its own mini-split climate control, and a generous walk-in closet dormer where the Pack 'n Play lives for families with infants. Completely private at the top of the house with its own marble en-suite.
THE BATHROOMS
Four bathrooms across three floors. Nobody waits.
The Clawfoot Bath (Level 2, Primary En-Suite) — A cobalt blue clawfoot soaking tub in a classic beadboard bathroom with a vessel sink on an antique carved vanity and a bamboo tub caddy. Take your time.
The Skylight Shower (Level 3, Attic En-Suite) — Floor-to-ceiling marble tile, glass door, and a natural skylight overhead. One of the best showers you'll find in any rental.
Level 2 Hall Bath — Large-format tile walk-in shower, modern vanity, fresh linens. Solid and well-appointed for guests on any floor.
The Harry Potter Potty (Level 1 Half Bath) — Tucked under the grand staircase: terracotta walls, Moroccan tile, marble vanity, angled ceiling. Tiny, magical, and every guest will mention it.
THE GAME ROOM
The basement game room runs on exposed stone walls and full-time foosball energy. Flat screen TV, barn door media console, and the kind of space where kids claim territory for the whole trip.
OUTDOOR
A covered back deck with string lights, ceiling fan, hanging rope chair, gas grill, and patio dining. Plus a fenced backyard with a fire pit. The place you'll end up every evening.
THE EXTRAS
Full-size washer and dryer. Iron and ironing board. Keypad entry. High-speed WiFi throughout.
THE LOCATION
Sharpsburg is one of Pittsburgh's most authentic riverfront neighborhoods — just minutes from the North Shore, PNC Park, PPG Paints Arena, the Strip District, and every great restaurant and brewery the city has to offer. Perfect base for a game night, a week of exploring, or just a long weekend of doing nothing particularly well.
Book your dates. Come home to the red door.
Add dates for prices
Have a question?
AI iconBetaBeta
Get instant answers with AI powered search of property information and reviews.
Similar properties
Modern & Upscale King Bed Suite|Private w/Parking!
East Liberty
Modern & Upscale King Bed Suite|Private w/Parking!
Extra-person charges may apply and vary depending on property policy
Government-issued photo identification and a credit card, debit card or cash deposit may be required at check-in for incidental charges
Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed
On-site parties or group events are strictly prohibited
Host has indicated that there is a carbon monoxide detector on the property
Host has indicated that there is a smoke detector on the property
Safety features at this property include a fire extinguisher and a deadlock
This property has outdoor spaces, such as balconies, patios and terraces, which may not be suitable for children; if you have any concerns, we recommend contacting the property prior to your arrival to confirm that they can accommodate you in a suitable room
About the area
Pittsburgh
Located in North Side, a neighbourhood in Pittsburgh, this apartment is near theme parks. Market Square and Station Square are worth checking out if shopping is on the agenda, while those wishing to experience the area's popular attractions can visit Kennywood. Looking to enjoy an event or a game? See what's going on at PNC Park or PPG Paints Arena. Jet skiing and kayaking offer great chances to get out on the surrounding water, or you can seek out an adventure with hiking nearby.
Carnegie Mellon University - 17 min drive - 8.7 km
University of Pittsburgh - 19 min drive - 9.4 km
PNC Park - 20 min drive - 17.5 km
Acrisure Stadium - 21 min drive - 18.6 km
PPG Paints Arena - 22 min drive - 19.6 km
Getting around
Wood Street Station - 12 min drive
Pittsburgh Station - 18 min drive
Pittsburgh International Airport (PIT) - 40 min drive
Restaurants
Dragon Palace - 8 min walk
Caliente Pizza & Drafthouse - 15 min walk
Polska Laska - 17 min walk
Redhawk Coffee - 18 min walk
The Bulldog Pub - 4 min drive
Frequently asked questions
Is Restored Sharpsburg Gem | 2 Kings | Gourmet Kitchen | 3.5 Baths + Game Room pet-friendly?
Yes, pets are allowed at this property.
How much is parking at Restored Sharpsburg Gem | 2 Kings | Gourmet Kitchen | 3.5 Baths + Game Room?
On-site parking is available at the property.
What time is check-in at Restored Sharpsburg Gem | 2 Kings | Gourmet Kitchen | 3.5 Baths + Game Room?
Check-in begins at 4:00 PM.
What time is check-out at Restored Sharpsburg Gem | 2 Kings | Gourmet Kitchen | 3.5 Baths + Game Room?
Checkout is at 10:00 AM.
Where is Restored Sharpsburg Gem | 2 Kings | Gourmet Kitchen | 3.5 Baths + Game Room located?
Located in North Side, this apartment building is 0.3 mi (0.4 km) from Allegheny River and within 3 miles (5 km) of UPMC St. Margaret and Bayernhof Museum. VA Hospital H.J. Heinz Campus and Three Rivers Heritage Trail are also within 3 miles (5 km).