Great custom built AndrewJames home in Columbia Tusculum. Rare fenced rear yard with private paver terrace. Gas fireplace - coffered ceilings - counter bar - stainless appliances - gas range - 2nd floor laundry - new 2022 LL family room w/ 4th bedroom & full bath - hardwood floors - 2 car garage - tax abatement til 2031', EV charger - new gas furnace 10/25 & the features go on & on ... this home has it all! Leave offers open for 48 hours, seller reserves the right to accept an offer prior. No escalation clauses.
Sold for $800,000
$800,000
504 Hoge St, Cincinnati, OH 45226
4beds
2,365sqft
Single Family Residence
Built in 2016
3,267 Square Feet Lot
$819,800 Zestimate®
$338/sqft
$3,856 Estimated rent
Home value
$819,800
$754,000 - $894,000
$3,856/mo
Zestimate® history
Owner options
List your home for rent
$3,856/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,856/mo
Rent Zestimate®
Refinance and save
$5,257/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$5,257/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Gas fireplaceFenced rear yardPrivate paver terraceStainless appliancesCounter barCoffered ceilingsGas range
Zillow last checked:
Listing updated:
Listed by:
Michael C Hinckley 513-533-8080,
Coldwell Banker Realty 513-321-9944,
Jack C Hinckley 513-604-1686,
Coldwell Banker Realty
Bought with:
Michael C Hinckley, 0000261574
Coldwell Banker Realty
Source: Cincy MLS,MLS#: 1861467
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Wood Floor
- Level: Second
- Area: 182
- Dimensions: 14 x 13
Bedroom 2
- Level: Second
- Area: 120
- Dimensions: 12 x 10
Bedroom 3
- Level: Second
- Area: 110
- Dimensions: 11 x 10
Bedroom 4
- Level: Lower
- Area: 0
- Dimensions: 0 x 0
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Shower, Double Vanity, Marb/Gran/Slate
Bathroom 1
- Features: Full
- Level: Second
Bathroom 2
- Features: Full
- Level: Second
Bathroom 3
- Features: Full
- Level: Lower
Bathroom 4
- Features: Partial
- Level: First
Dining room
- Features: Chandelier, Wood Floor
- Level: First
- Area: 143
- Dimensions: 13 x 11
Family room
- Features: Wet Bar, Wood Floor
- Area: 288
- Dimensions: 18 x 16
Kitchen
- Features: Eat-in Kitchen, Wood Floor, Marble/Granite/Slate
- Area: 156
- Dimensions: 13 x 12
Living room
- Features: Bookcases, Walkout, Fireplace, Wood Floor
- Area: 342
- Dimensions: 19 x 18
Office
- Area: 0
- Dimensions: 0 x 0
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Gas Cooktop, Microwave, Oven/Range, Refrigerator, Gas Water Heater
Features
- High Ceilings, Beamed Ceilings, Crown Molding, Ceiling Fan(s), Recessed Lighting
- Doors: Multi Panel Doors
- Windows: Wood Frames, Insulated Windows
- Basement: Full,Finished
- Number of fireplaces: 1
- Fireplace features: Gas, Living Room
Interior area
- Total structure area: 2,365
- Total interior livable area: 2,365 sqft
Property
Parking
- Total spaces: 2
- Parking features: On Street, Driveway, Garage Door Opener
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Porch
Lot
- Size: 3,267 Square Feet
- Dimensions: 25 x 120
- Features: Less than .5 Acre, Busline Near
Details
- Parcel number: 0280005008800
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Transitional
- Property subtype: Single Family Residence
Materials
- Stone, Fiber Cement
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 2016
Utilities & green energy
- Electric: 220 Volts
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Connected
Community & HOA
HOA
- Has HOA: No
Location
- Region: Cincinnati
Financial & listing details
- Price per square foot: $338/sqft
- Tax assessed value: $619,850
- Annual tax amount: $3,270
- Date on market: 11/12/2025
- Listing terms: No Special Financing,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 12/16/2025 | Sold | $800,000+1.9%$338/sqft |
Source:  Cincy MLS #1861467 Report a problem | ||
| 11/18/2025 | Pending sale | $785,000$332/sqft |
Source: Cincy MLS #1861467 Report a problem | ||
| 11/12/2025 | Listed for sale | $785,000+160.3%$332/sqft |
Source: Cincy MLS #1861467 Report a problem | ||
| 11/7/2017 | Sold | $301,621-45.2%$128/sqft |
Source: Public Record Report a problem | ||
| 12/1/2016 | Listing removed | $550,000$233/sqft |
Source: Comey & Shepherd #1494357 Report a problem | ||
| 6/10/2016 | Sold | $550,000$233/sqft |
Source: Cincy MLS #1494357 Report a problem | ||
| 5/16/2016 | Pending sale | $550,000$233/sqft |
Source: Comey & Shepherd #1494357 Report a problem | ||
| 5/16/2016 | Listed for sale | $550,000-4.3%$233/sqft |
Source: Comey & Shepherd #1494357 Report a problem | ||
| 3/14/2016 | Listing removed | $575,000$243/sqft |
Source: Comey & Shepherd #1482010 Report a problem | ||
| 2/19/2016 | Listed for sale | $575,000$243/sqft |
Source: Comey & Shepherd #1482010 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $3,271 +22.6% | $216,948 +5.4% |
| 2023 | $2,669 +71.8% | $205,842 -6.2% |
| 2022 | $1,553 +1% | $219,450 |
| 2021 | $1,538 | $219,450 |
| 2020 | $1,538 +33.2% | $219,450 +14% |
| 2019 | $1,155 +0.3% | $192,500 |
| 2018 | $1,151 -91.9% | $192,500 0% |
| 2017 | $14,151 +701.2% | $192,501 +672.6% |
| 2016 | $1,766 +5% | $24,917 |
| 2015 | $1,682 -0.5% | $24,917 |
| 2014 | $1,691 +12.4% | $24,917 +9% |
| 2013 | $1,504 +1.8% | $22,859 |
| 2012 | $1,478 +3.1% | $22,859 |
| 2011 | $1,433 +12.6% | $22,859 +6.2% |
| 2010 | $1,273 +3.8% | $21,518 |
| 2009 | $1,226 +1.8% | $21,518 |
| 2008 | $1,204 +21.4% | $21,518 +6% |
| 2007 | $992 +1.1% | $20,300 |
| 2006 | $981 -0.9% | $20,300 |
| 2005 | $990 +2.5% | $20,300 +11.8% |
| 2003 | $965 +6.7% | $18,165 |
| 2002 | $905 +5.7% | $18,165 +12.6% |
| 2001 | $856 +3.4% | $16,135 |
| 2000 | $828 | $16,135 |
Find assessor info on the county website
Neighborhood: Columbia-Tusculum
Nearby homes
- $20,1704 bd4 ba3.6k sqft518 Hoge St, Cincinnati, OH 45226Off Market
- $20,170-- bd-- ba-- sqft516 Hoge St, Cincinnati, OH 45226Off Market
- $770,0003 bd4 ba2.2k sqft508 Hoge St, Cincinnati, OH 45226Sold
- $285,0003 bd1 ba1.3k sqft502 Hoge St, Cincinnati, OH 45226Off Market
- $748,8003 bd1 ba2k sqft510 Hoge St, Cincinnati, OH 45226Off Market
- $352,2002 bd2 ba1.3k sqft3512 Handman Ave, Cincinnati, OH 45226Off Market
- $319,5004 bd2 ba1.5k sqft3514 Handman Ave, Cincinnati, OH 45226Off Market
- $--3 bd1 ba1.6k sqft3514 Handman Ave #2, Cincinnati, OH 45226Off Market
Nearby schools
GreatSchools rating
- 4/10Riverview East AcademyGrades: PK,4,6,9-12Distance: 0.3 mi
- 6/10Clark Montessori High SchoolGrades: 7-12Distance: 1.6 mi
- 3/10Withrow University High SchoolGrades: 7-12Distance: 1.9 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$819,800
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$819,800
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Cincinnati Topics
