So much potential at 949 Philadelphia! This spacious 2,600 sq. ft. home is ready for someone with vision to bring it back to life and turn it into a true masterpiece. The third floor is ready to be finished--perfect for a future primary suite, office, or additional living space. The block has seen major transformation over the last few years with a mix of new builds and beautifully renovated older homes, and the home next door is currently being renovated as well. Located within walking distance to Mainstrasse, the dog park, restaurants, bars, and just minutes from downtown Cincinnati, this one is packed with opportunity.
Pending
$199,900
949 Philadelphia St, Covington, KY 41011
4beds
2,632sqft
Single Family Residence, Residential
Built in ----
2,613 Square Feet Lot
$-- Zestimate®
$76/sqft
$-- HOA
What's special
- 18 days |
- 32 |
- 0 |
Zillow last checked:
Listing updated:
Listed by:
Matthew Brock 859-445-8331,
Resource Realty Partners
Source: NKMLS,MLS#: 642272
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Features: See Remarks
- Level: First
- Area: 225
- Dimensions: 15 x 15
Bedroom 2
- Features: See Remarks
- Level: Second
- Area: 225
- Dimensions: 15 x 15
Bedroom 3
- Features: See Remarks
- Level: Second
- Area: 225
- Dimensions: 15 x 15
Bedroom 4
- Features: See Remarks
- Level: Second
- Area: 225
- Dimensions: 15 x 15
Dining room
- Features: See Remarks
- Level: First
- Area: 225
- Dimensions: 15 x 15
Kitchen
- Features: See Remarks
- Level: First
- Area: 225
- Dimensions: 15 x 15
Living room
- Features: See Remarks
- Level: First
- Area: 225
- Dimensions: 15 x 15
Heating
- Forced Air
Cooling
- None
Appliances
- Included: Electric Range, Refrigerator
Features
- Windows: Vinyl Frames
Interior area
- Total structure area: 2,632
- Total interior livable area: 2,632 sqft
Property
Parking
- Parking features: On Street
- Has uncovered spaces: Yes
Features
- Levels: Three Or More
- Stories: 3
- Patio & porch: Patio
Lot
- Size: 2,613 Square Feet
- Dimensions: 25 x 100
Details
- Parcel number: 0404412011.00
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Vinyl Siding
- Foundation: Stone
- Roof: Membrane
Condition
- Existing Structure
- New construction: No
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Covington
Financial & listing details
- Price per square foot: $76/sqft
- Tax assessed value: $71,800
- Annual tax amount: $944
- Date on market: 6/10/2026
- Cumulative days on market: 19 days
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/11/2026 | Pending sale | $199,900$76/sqft |
Source:  NKMLS #642272 Report a problem | ||
| 5/6/2026 | Listed for sale | $199,900+247.7%$76/sqft |
Source: NKMLS #642272 Report a problem | ||
| 11/27/2019 | Sold | $57,500+310.7%$22/sqft |
Source: Public Record Report a problem | ||
| 11/16/2015 | Listing removed | $695 |
Source: ReInvest Consultants LLC Report a problem | ||
| 10/22/2015 | Listed for rent | $695 |
Source: ReInvest Consultants LLC Report a problem | ||
| 8/16/2014 | Listing removed | $695 |
Source: ReInvest Consultants LLC Report a problem | ||
| 8/6/2014 | Listed for rent | $695 |
Source: ReInvest Consultants LLC Report a problem | ||
| 8/5/2012 | Listing removed | $695 |
Source: Heritage Financial Services Limited Report a problem | ||
| 6/23/2012 | Listed for rent | $695 |
Source: RentalHunt.com #242344 Report a problem | ||
| 5/30/2001 | Sold | $14,000$5/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $944 -1.3% | $71,800 |
| 2023 | $956 +0.8% | $71,800 |
| 2022 | $948 +8.1% | $71,800 +24.9% |
| 2021 | $877 -31.9% | $57,500 |
| 2020 | $1,288 | $57,500 +4.5% |
| 2019 | $1,288 +40% | $55,000 |
| 2018 | $920 | $55,000 +10% |
| 2017 | $920 -13.8% | $50,000 |
| 2015 | $1,068 | $50,000 |
| 2014 | $1,068 +10.2% | $50,000 +25% |
| 2013 | $968 | $40,000 |
| 2012 | -- | $40,000 |
| 2011 | -- | $40,000 |
| 2010 | -- | $40,000 |
| 2009 | -- | $40,000 |
| 2008 | -- | $40,000 |
| 2007 | -- | $40,000 |
| 2006 | -- | $40,000 +14.3% |
| 2005 | -- | $35,000 |
| 2004 | -- | $35,000 |
| 2003 | -- | $35,000 |
| 2002 | -- | $35,000 +84.2% |
| 2001 | -- | $19,000 |
| 2000 | -- | $19,000 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 41011
Getting around
39 / 100
Some TransitNearby schools
GreatSchools rating
- 7/10John G Carlisle Elementary SchoolGrades: K-5Distance: 0.3 mi
- 3/10Holmes Middle SchoolGrades: 6-8Distance: 1.4 mi
- 1/10Holmes High SchoolGrades: 9-12Distance: 1.5 mi
Schools provided by the listing agent
- Elementary: Glenn O. Swing Elementary
- Middle: Holmes Middle School
- High: Holmes Senior High
Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Kentucky
- Kenton County
- Covington
- 41011
- 949 Philadelphia St
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Covington Topics
