Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$499,000 Sale Pending

  • For Sale
  • Pending
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 1,838 Sq. Ft.
  • 0.1 Acres
  • 1 Car Garage
See This Home
Save This Home
See This Home
Save This Home
Come home to this charming 3-bedroom, 2 full bath home that offers 1,838 sq ft on a quiet no-outlet street with private access to the Wasson Trail. This classic Oakley home features hardwood floors, stained glass windows, and pocket doors. Modern updates include custom built-in shelving, new 1st floor bathroom vanity, beautiful kitchen with quartz countertops, gas-range + breakfast & coffee nook. Upstairs, the spacious primary bedroom includes a walk-in closet with ample storage and tons of natural light. The third floor provides a large but cozy space that's perfect as a bedroom, office or bonus space with great storage and separate Daikin HVAC unit. Step outside to enjoy a private, fully fenced in backyard featuring a wood deck and a newly added flagstone patio - perfect for entertaining! A rare opportunity to own a timeless home in an unbeatable location!

Full Property Details for 2823 Andrew Pl

General

  • Price: $499,000
  • Status: Pending
  • Type: Single Family
  • Source: Cincinnati
  • MLS ID: 1876169
  • Updated: 4/24/2026
  • Added to Site: 35 day(s) ago

Interior

  • Number of Rooms: 8
  • Interior Features: High Ceiling (9 Feet or More)
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Inoperable
  • Appliances: Dishwasher, Garbage Disposal, Microwave, Oven/Range, Refrigerator, Warming Drawer

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2
  • Primary Bathroom: Tub w/Shower
  • Bathroom 1: Full, Level 2
  • Bathroom 2: Full, Level 1

Bedrooms

  • Total Bedrooms: 3
  • Primary Bedroom: Adjoining Bathroom, Walk-In Closet, Wood Floor, 20 x 12, Level 2, 240 Sq. Ft.
  • Bedroom 2: 9 x 10, Level 2, 90 Sq. Ft.
  • Bedroom 3: 17 x 13, Level 3, 221 Sq. Ft.

Other Rooms

  • Foyer/Entry: Wood Floor, Level 1
  • Living Room: Wood Floor, 15 x 13, Level 1, 195 Sq. Ft.
  • Kitchen: Quartz Counters, Counter Bar, Eat-In, Wood Floor, 10 x 11, 10x11, 110 Sq. Ft.
  • Dining Room: Built-Ins, Fireplace, Wood Floor, 12 x 12, Level 1, 144 Sq. Ft.

Additional Information

  • Other Features: CO Detector, Smoke Alarm

Exterior

  • Exterior Features: Cul de sac, Deck, Patio, Porch

Parking

  • Garage: Yes
  • Garage Spaces: 1
  • Parking: On-Street Parking, Driveway
  • Garage Description: Garage Detached

Location

  • Area: Oakley
  • County: Hamilton
  • Suburb: Oakley
  • Driving Directions: Madison to Andrew (between Millsbrae & Hyde Park Ave)

School Information

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

Community

  • Home Owners Assn.: False

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Central Air Conditioning, Mini-Split
  • Heating Type: Mini-Split, Forced Air, Gas
  • Heating Fuel: Natural
  • Water Heater: Gas

Utilities

  • Sewer: Public Sewer
  • Water: Public

Structural Information

  • Architectural Style: Traditional
  • Description/Design: Single Family
  • Exterior Const.: Aluminum Siding
  • Basement: Yes
  • Basement Desc.: Full, Concrete Floor, Unfinished
  • Foundation: Poured
  • Roof: Shingle
  • Windows: Storm, Double-Hung
  • Stories/Levels: 0
  • Square Feet: 1,838
  • Year Built: 1910

Lot Features

  • Lot Size (Acres): 0.1
  • Lot Dimensions: 35 x 115
  • Zoning: Residential
  • Fencing (Description): Privacy, Wood

Financial Considerations

  • Semi-Annual Taxes: $39639

Disclosures and Reports

  • APN: 040-0004-0169-00

Listed by Bruns Realty Group, LLC (937) 339-2300, Kristen Richard

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

— 2823 Andrew Pl —

  • Kristen Richard

    Bruns Realty Group, LLC

    937-339-2300

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 2823 Andrew Pl

School District:Cincinnati City School District
NameGradesDistance
Hyde Park School
3401 Edwards Road, Cincinnati, OH 45208
K-60.6 mi
Withrow University High School
2488 Madison Road, Cincinnati, OH 45208
7-120.8 mi
Riverview East Academy
3555 Kellogg Avenue, Cincinnati, OH 45226
9-122.1 mi
Clark Montessori High School
3030 Erie Avenue, Cincinnati, OH 45208
7-120.7 mi
Hughes STEM High School
2515 Clifton Avenue, Cincinnati, OH 45219
7-124.6 mi
Robert A. Taft Information Technology High School
420 Ezzard Charles Drive, Cincinnati, OH 45214
7-125.2 mi
Shroder Paideia High School
5030 Duck Creek Road, Cincinnati, OH 45227
7-122.1 mi
Walnut Hills High School
3250 Victory Parkway, Cincinnati, OH 45207
7-122.2 mi
Woodward Career Technical High School
7005 Reading Road, Cincinnati, OH 45237
7-123.3 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 2823 Andrew Pl Get Price Alerts and Save Property

Date
Details
Price
Change
Source
4/24/2026
Listed
$499,000
35.6%
MLS
7/23/2020
Sold
$368,000
—
Public Record
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 2823 Andrew Pl

Year
Property Taxes
Change
Tax Assessment
Change
2025
$7,928
3%
$128,801
—
2024
$7,690
-2%
$128,799
—
2023
$7,862
17%
$128,799
29%
2021
$6,718
-1%
$99,754
—
2022
$6,788
1%
$99,754
—
2020
$6,718
10%
$99,754
20%
2019
$6,128
—
$83,129
—
2018
$6,138
5%
$83,129
—
2017
$5,832
—
$83,129
1%
2016
$5,855
11%
$82,251
—
2015
$5,277
-1%
$82,251
—
2014
$5,314
35%
$82,250
38%
2013
$3,927
—
$59,700
—
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 2823 Andrew Pl

$
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 Bruns Realty Group, LLC (937) 339-2300, Kristen Richard

Similar Properties near 2823 Andrew Pl

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

880 BELLE Rdg Lp, Bellevue, KY 41073 - Photo 1
$499,000

880 BELLE Rdg Lp  Bellevue, KY 41073

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
  • 1,685
    Sq. Ft.
3633 Tarpis Ave, Cincinnati, OH 45208 - Photo 1
$499,000

3633 Tarpis Ave  Cincinnati, OH 45208

  • Single Family
  • Active
  • Updated 12 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,872
    Sq. Ft.
961 Marion Ave, Cincinnati, OH 45229 - Photo 1
$499,000

961 Marion Ave  Cincinnati, OH 45229

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 1,906
    Sq. Ft.
3531 Eden Ave, Cincinnati, OH 45229 - Photo 1
$499,000

3531 Eden Ave  Cincinnati, OH 45229

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 2,398
    Sq. Ft.

Just Listed near 2823 Andrew Pl

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

418 W 8th St, Newport, KY 41071 - Photo 1 Price Reduced
-$9,900 (-14.16%)
$60,000

418 W 8th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 1 hour ago
  • 909
    Sq. Ft.
110 Saffron Cir, Newport, KY 41076 - Photo 1 Just Listed
$479,000

110 Saffron Cir  Newport, KY 41076

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 2,043
    Sq. Ft.
236 W 9th St, Newport, KY 41071 - Photo 1 Just Listed
$525,000

236 W 9th St  Newport, KY 41071

  • Multi-Family
  • Active
  • Updated 1 day ago
611 Oak St, Newport, KY 41071 - Photo 1 Just Listed
$285,000

611 Oak St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 16 hours ago
  • 2
    Beds
  • 1
    Total Bath
  • 1,033
    Sq. Ft.

Price Reduced near 2823 Andrew Pl

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

711 Roberts St, Newport, KY 41071 - Photo 1 Price Reduced
-$6,000 (-2.18%)
$269,000

711 Roberts St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 5 days ago
  • 2
    Beds
  • 2
    Total Baths
418 W 8th St, Newport, KY 41071 - Photo 1 Price Reduced
-$9,900 (-14.16%)
$60,000

418 W 8th St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 1 hour ago
  • 909
    Sq. Ft.
1017 Saratoga St, Newport, KY 41071 - Photo 1 Price Reduced
-$24,900 (-5.53%)
$425,000

1017 Saratoga St  Newport, KY 41071

  • Single Family
  • Active
  • Updated 3 days ago
  • 4
    Beds
  • 2
    Total Baths
  • 2,500
    Sq. Ft.
600 Ovation Way, Newport, KY 41071 - Photo 1 Price Reduced
-$50,100 (-4.47%)
$1,069,900

600 Ovation Way  #312  Newport, KY 41071

  • Condo
  • Active
  • Updated 6 days ago
  • 2
    Beds
  • 2
    Total Baths

Recent Sales near 2823 Andrew Pl

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

3733 Andrew Ave, Cincinnati, OH 45209 - Photo 1 Sold
$450,000

3733 Andrew Ave  Cincinnati, OH 45209

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,364
    Sq. Ft.
3759 Andrew Ave, Cincinnati, OH 45209 - Photo 1 Sold
$492,000

3759 Andrew Ave  Cincinnati, OH 45209

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,514
    Sq. Ft.
Sold by Hinckley Group
2803 Madison Rd, Cincinnati, OH 45209 - Photo 1 Sold
$545,000

2803 Madison Rd  Cincinnati, OH 45209

  • Triplex
  • Closed
  • 2,994
    Sq. Ft.
2872 Madison Rd, Cincinnati, OH 45209 - Photo 1 Sold
$455,000

2872 Madison Rd  Cincinnati, OH 45209

  • Single Family
  • Closed
  • 5
    Beds
  • 3
    Total Baths
  • 2,484
    Sq. Ft.
Sold by Leah Slicer and Jenna Thompson

2823 Andrew Place, Cincinnati, OH 45209 (MLS# 1876169) is a Single Family property with 3 bedrooms and 2 full bathrooms. 2823 Andrew Place is currently listed for $499,000 and was received on April 22, 2026. Want to learn more about 2823 Andrew Place? Do you have questions about finding other Single Family real estate for sale in Oakley? You can browse all Oakley real estate or contact a Coldwell Banker agent to request more information.

Tour this property