Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$74,000 -$10,000 (-11.9%) Price Reduced Sale Pending

  • For Sale
  • Pending
  • Single Family
  • 3 Beds
  • 1 Full Bath
  • 1,147 Sq. Ft.
  • 1 Car Garage
  • Updated 2 days ago
See This Home
Save This Home
See This Home
Save This Home
Owner is selling this property to enjoy retirement, offering buyers a rare opportunity to purchase a home with potential for future growth. This 3-bedroom home is as-is, presenting a great opportunity for buyers looking to renovate, invest, or customize to their taste. Ideal for cash only buyers. Someone broke in the property and vandalized it. All the utilities are off.

Full Property Details for 2040 Queen City Ave

General

  • Price: $74,000
  • Status: Pending
  • Type: Single Family
  • Source: Cincinnati
  • MLS ID: 1862927
  • Updated: 1/14/2026
  • Added to Site: 54 day(s) ago

Interior

  • Number of Rooms: 6
  • Appliances: Oven/Range, Refrigerator

Rooms

Bathrooms

  • Total Bathrooms: 1
  • Full Bathrooms: 1
  • Primary Bathroom: Shower, Tub w/Shower, Marb/Gran/Slate
  • Bathroom 1: Full, Level 1

Bedrooms

  • Total Bedrooms: 3
  • Primary Bedroom: 12 x 10, Level 1, 120 Sq. Ft.
  • Bedroom 2: 14 x 14, Level 2, 196 Sq. Ft.
  • Bedroom 3: 12 x 10, Level 2, 120 Sq. Ft.

Other Rooms

  • Living Room: Wall-to-Wall Carpet, 13 x 10, Level 1, 130 Sq. Ft.
  • Kitchen: 8 x 9, 8x9, 72 Sq. Ft.
  • Dining Room: WW Carpet, 13 x 10, Level 1, 130 Sq. Ft.

Additional Information

  • Other Features: 220 Volts

Parking

  • Garage: Yes
  • Garage Spaces: 1
  • Parking: On-Street Parking, Driveway
  • Garage Description: Built-In, Front

Location

  • Area: Fairmount
  • County: Hamilton
  • Suburb: Fairmount
  • Driving Directions: Queen City Ave (Between Wyoming Ave & White Street)

School Information

  • School District: Cincinnati City SD
  • High School District: Cincinnati City SD

Community

  • Home Owners Assn.: False

Heating & Cooling

  • Cooling Type: None
  • Heating Type: Baseboard, Forced Air, Gas
  • Heating Fuel: At Street
  • Water Heater: Gas

Utilities

  • Sewer: Public Sewer
  • Water: At Street

Structural Information

  • Architectural Style: One And A Half Story Cape Cod
  • Description/Design: Single Family
  • Exterior Const.: Aluminum Siding
  • Basement: Yes
  • Basement Desc.: Full, Unfinished
  • Foundation: Poured
  • Roof: Shingle
  • Windows: Aluminum
  • Stories/Levels: One and One Half
  • Square Feet: 1,147
  • Year Built: 1928

Lot Features

  • Zoning: Residential

Financial Considerations

  • Semi-Annual Taxes: $285

Disclosures and Reports

  • APN: 205-0024-0090-00

Listed by Co-Bonds Realty Group (513) 543-4762, Ray Cook (513) 543-4762

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 2040 Queen City Ave —

  • Ray Cook

    Co-Bonds Realty Group

    513-543-4762

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 2040 Queen City Ave

School District:Cincinnati City School District
NameGradesDistance
Rees E. Price Elementary School
1228 Considine Avenue, Cincinnati, OH 45204
PK-61 mi
Aiken New Tech High School
5641 Belmont Avenue, Cincinnati, OH 45224
7-124.4 mi
Walnut Hills High School
3250 Victory Parkway, Cincinnati, OH 45207
7-124.8 mi
Western Hills University High School
2144 Ferguson Road, Cincinnati, OH 45238
7-121.7 mi
Gilbert A. Dater High School
2146 Ferguson Road, Cincinnati, OH 45238
7-121.8 mi
Hughes STEM High School
2515 Clifton Avenue, Cincinnati, OH 45219
7-122.5 mi
Withrow University High School
2488 Madison Road, Cincinnati, OH 45208
7-126.3 mi
Woodward Career Technical High School
7005 Reading Road, Cincinnati, OH 45237
7-126.9 mi
Shroder Paideia High School
5030 Duck Creek Road, Cincinnati, OH 45227
7-128.9 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 2040 Queen City Ave Get Price Alerts and Save Property

Date
Details
Price
Change
Source
1/10/2026
Price Reduced
$74,000
-11.9%
MLS
1/03/2026
Price Reduced
$84,000
-15.92%
MLS
11/24/2025
Listed
$99,900
—
MLS
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 2040 Queen City Ave

Year
Property Taxes
Change
Tax Assessment
Change
2024
$1,147
—
$17,948
—
2023
$1,149
49%
$17,948
64%
2021
$770
-18%
$10,970
—
2022
$934
21%
$10,970
—
2020
$770
-9%
$10,970
—
2019
$845
—
$10,970
—
2018
$846
4%
$10,970
—
2017
$814
-22%
$10,970
-20%
2016
$1,044
12%
$13,738
—
2015
$934
-1%
$13,738
—
2014
$939
-4%
$13,738
-2%
2013
$974
—
$14,018
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 2040 Queen City Ave

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Co-Bonds Realty Group (513) 543-4762, Ray Cook (513) 543-4762

Similar Properties near 2040 Queen City Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1705 Wyoming Ave, Cincinnati, OH 45205 - Photo 1
$75,000

1705 Wyoming Ave  Cincinnati, OH 45205

  • Single Family
  • Active
  • 2
    Beds
  • 1
    Total Bath
  • 821
    Sq. Ft.
2425 Glenway Ave, Cincinnati, OH 45204 - Photo 1
$79,000

2425 Glenway Ave  Cincinnati, OH 45204

  • Single Family
  • Active
  • 2
    Beds
  • 1
    Total Bath
  • 1,024
    Sq. Ft.
395 Purcell Ave, Cincinnati, OH 45205 - Photo 1 Just Listed
$69,900

395 Purcell Ave  Cincinnati, OH 45205

  • Single Family
  • Active
  • Updated 6 hours ago
  • 2
    Beds
  • 1
    Total Bath
  • 1,005
    Sq. Ft.
1136 Columbia St, Newport, KY 41071 - Photo 1 Just Listed
$73,000

1136 Columbia St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 8 hours ago
  • 1
    Bed
  • 1
    Total Bath
  • 570
    Sq. Ft.
Listed by Nicole Rankin (859) 394-4930

Just Listed near 2040 Queen City Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

196 Main St, Newport, KY 41071 - Photo 1 Just Listed
$350,000

196 Main St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,572
    Sq. Ft.
Listed by Todd Blersch (513) 604-3138
1136 Columbia St, Newport, KY 41071 - Photo 1 Just Listed
$73,000

1136 Columbia St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 8 hours ago
  • 1
    Bed
  • 1
    Total Bath
  • 570
    Sq. Ft.
Listed by Nicole Rankin (859) 394-4930
341 Riddle Pl, Newport, KY 41071 - Photo 1 Just Listed
$210,000
Open House

341 Riddle Pl  Newport, KY 41071

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 1
    Total Bath
  • 1,248
    Sq. Ft.
Listed by The Twin Team
506 Center St, Newport, KY 41071 - Photo 1 Just Listed
$320,000
Open House

506 Center St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 2 days ago
  • 2
    Beds
  • 1
    Total Bath
  • 990
    Sq. Ft.
Listed by Edward Lindenschmidt (513) 207-1040

Price Reduced near 2040 Queen City Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

327 W 11th St, Newport, KY 41071 - Photo 1 Price Reduced
-$5,000 (-1.64%)
$299,900

327 W 11th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,886
    Sq. Ft.
2023 New Linden Rd, Newport, KY 41071 - Photo 1 Price Reduced
-$5,000 (-2.17%)
$225,000

2023 New Linden Rd  Newport, KY 41071

  • Single Family
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,039
    Sq. Ft.
29 15th St, Newport, KY 41071 - Photo 1 Price Reduced
-$15,000 (-4.41%)
$325,000

29 15th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 3 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,912
    Sq. Ft.
120 Main St, Newport, KY 41071 - Photo 1 Price Reduced
-$5,100 (-1.62%)
$309,900

120 Main St  #205  Newport, KY 41071

  • Condo
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 960
    Sq. Ft.

Recent Sales near 2040 Queen City Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2085 N Teralta Cir, Cincinnati, OH 45211 - Photo 1 Sold
$70,000

2085 N Teralta Cir  Cincinnati, OH 45211

  • Single Family
  • Closed
  • 3
    Beds
  • 1
    Total Bath
  • 1,019
    Sq. Ft.
1248 Drott Ave, Cincinnati, OH 45205 - Photo 1 Sold
$82,000

1248 Drott Ave  Cincinnati, OH 45205

  • Single Family
  • Closed
  • 3
    Beds
  • 1
    Total Bath
  • 1,159
    Sq. Ft.
1124 Elberon Ave, Cincinnati, OH 45205 - Photo 1 Sold
$70,000

1124 Elberon Ave  Cincinnati, OH 45205

  • Single Family
  • Closed
  • 4
    Beds
  • 1
    Total Bath
  • 934
    Sq. Ft.
1233 Considine Ave, Cincinnati, OH 45204 - Photo 1 Sold
$75,000

1233 Considine Ave  Cincinnati, OH 45204

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 2,074
    Sq. Ft.

2040 Queen City Avenue, Cincinnati, OH 45214 (MLS# 1862927) is a Single Family property with 3 bedrooms and 1 full bathroom. 2040 Queen City Avenue is currently listed for $74,000 and was received on November 24, 2025. Want to learn more about 2040 Queen City Avenue? Do you have questions about finding other Single Family real estate for sale in Fairmount? You can browse all Fairmount real estate or contact a Coldwell Banker agent to request more information.

Tour this property