Located close to Carnegie Mellon University, Restored Sharpsburg Gem | 2 Kings | Gourmet Kitchen | 3.5 Baths + Game Room has plenty to offer. Active travellers can enjoy birdwatching, mountain biking and motor boating at this apartment. Stay connected with in-room WiFi.
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.
Property amenities
Internet
Available in the apartment: WiFi
Parking and transport
Parking on site
Kitchen
Coffee/tea maker
Cookware, dishware, and utensils
Dishwasher
Hob
Ice maker
Microwave
Oven
Paper towels
Refrigerator
Spices
Toaster
Dining
Dining table
Bedrooms
2 bedrooms
Bathroom
3.5 bathrooms
Hair dryer
Shampoo
Shower
Soap
Toilet paper
Living spaces
Dining table
Entertainment
Smart TV with cable/satellite channels
Outdoor areas
Barbecue grill
Fenced yard
Outdoor furniture
Patio
Laundry
Washing machine
Comfort
Air conditioning
Pets
Pet friendly
Suitability/Accessibility
Smoke-free property
Services and conveniences
Iron/ironing board
Location highlights
In the city centre
Near a hospital
Near a zoo
Near an outlet shopping centre
Things to do
Birdwatching
Ice skating
Motor boating
Mountain biking
Casino nearby
Hiking/biking trails nearby
Jet skiing nearby
Kayaking nearby
Theme park nearby
Winery tours nearby
Safety features
Carbon monoxide detector (host has indicated there is a carbon monoxide detector on the property)
Smoke detector (host has indicated there is a smoke detector on the property)
You will receive an email from the host with check-in and check-out instructions
Information provided by the property may be translated using automated translation tools
Pets
Pets are allowed
Service animals are welcome, and are exempt from fees
Children and extra beds
Children are welcome
Events
No events allowed
Smoking
Smoking is not permitted
Important information
You need to know
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
This property is managed through our partner, Vrbo. You will receive an email from Vrbo with a link to a Vrbo account, where you can change or cancel your reservation
About the area
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. Visit our Pittsburgh travel guide
Is Restored Sharpsburg Gem | 2 Kings | Gourmet Kitchen | 3.5 Baths + Game Room pet-friendly?
Yes, pets are allowed at this property.
How much does it cost to stay at Restored Sharpsburg Gem | 2 Kings | Gourmet Kitchen | 3.5 Baths + Game Room?
As of 3 Jun 2026, prices found for a 1-night stay for 2 adults at Restored Sharpsburg Gem | 2 Kings | Gourmet Kitchen | 3.5 Baths + Game Room on 4 Jun 2026 start from NZ$1,002, including taxes and fees. This price is based on the lowest nightly price found in the last 24 hours for stays in the next 30 days. Prices are subject to change. Choose your dates for more accurate prices.
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).
Have a question?
AI iconBetaBeta
Get instant answers with AI powered search of property information and reviews.