7474 Greenfarms Dr, Cincinnati, OH 45224

4 beds3.5 baths2,916 sqft Edit

Edit home facts for a more accurate Zestimate.
Sold: $284,000
Sold on 10/17/12
Zestimate®: $277,302
Est. Mortgage

Estimated Monthly Payment


Please enter a dollar amount between $0 and $200,000,000


Please enter a percent between 0% and 100%

30 Year Fixed:
15 Year Fixed:
5/1 ARM:
Estimated taxes & insurance of are not included.
See current rates On

A Zestimate® home valuation is Zillow's estimated market value. It is not an appraisal. Use it as a starting point to determine a home's value. Learn more

My Notes

A truly unique home not for the cookie cutter buyer. This 3400+ square foot home was architect designed and sits on part of the former Nieman Nursery. The parklike yard boasts a 50' diameter pond with fountain and waterfall, lily pads, goldfish, butterflies and dragonflies. Countless perennials grace this beautiful yard with stone paths and footbridge over the water. A Gunite pool sits at the back of the property. Fully fenced, you will truly feel the privacy of this gorgeous home. Enjoy breakfast, lunch, or dinner on the lovely patio. The style of the home is Mediteranean meets Frank Lloyd Wright. Smart built in storage, artistic tile showers, slate floors, spacious rooms, and so much more await you. With numerous large windows and 6 skylights, the home is bathed in natural light and allows for serene views of the grounds. The home features a built-in greenhouse complete with temperature control and overhead sprinkler. A true Euro man cave in the lower level features a bar, bath, and pool table. This home is located approximately 1.5 miles from P&G's Winton Hills, approximately 12 minute drive to UC and 15 minute drive to downtown. Amazing, Unique, Spacious, and Convenient!  More Less 


  • Lot: 0.61 acres
  • Single Family
  • Built in 1962
  • Views: 1,705 all time views
  • Cooling: Central
  • Last sold: Oct 2012 for $284,000
  • Last sale price/sqft: $97


  • Deck
  • Fenced Yard
  • Fireplace
  • Parking: Garage - Attached, 2 spaces, 529 sqft
  • Patio
  • Pool


  • Exterior material: Brick
  • Room count: 9
  • Stories: 1
  • Unit count: 1


  • Floor size: 2,916 sqft
  • Lot depth: 254 ft
  • Lot width: 112 ft
  • Parcel #: 5900214020500
  • Zillow Home ID: 34363970

Zestimate Details

A Zestimate home valuation is Zillow's estimated market value. It is not an appraisal. Use it as a starting point to determine a home's value. Learn more

The Value Range is the high and low estimate market value for which Zillow values a home. The more information, the smaller the range, and the more accurate the Zestimate. See data coverage and accuracy table

Don't agree with your home's Zestimate? Owners can edit their home facts to make the Zestimate more accurate. Plus, you can leave an opinion on your Zestimate value below. Just click "Owner Estimate".
+$6,415 Last 30 days
Zestimate range
Rent Zestimate A Rent Zestimate is Zillow's estimated monthly rental price, computed using a proprietary formula. It is a starting point in determining the monthly rental price for a specific property. Learn more

The Rent Range is the high and low estimate for which an apartment or home could rent. The more information we have, the smaller the range, and the more accurate the Rent Zestimate. See data coverage and accuracy table
+$106 Last 30 days
Zestimate range
Zestimate forecast
One year
To see Zestimate forecast
Create a free account

Improve This Home's Value

The right home project can make a significant impact to your home value! Compare average project costs in your area with estimated increases to your home value.

The return values below are estimates based on the region, home facts, and past sales data. Your situation may vary based on current finish level of the room, changing style trends, depreciation, and how much of the project budget is invested in structural changes vs. functional/cosmetic improvements.

Mid-Range Major Kitchen Remodel

  • Mid-Range Major Kitchen Remodel

  • + 28K VALUE
  • Project cost: $57,407
  • See kitchen ideas

Mid-Range Minor Kitchen Remodel

  • Mid-Range Minor Kitchen Remodel

  • + 6.8K VALUE
  • Project cost: $19,503
  • See kitchen ideas

Mid-Range Bathroom Remodel

Popularity on Zillow

If this home is listed on Zillow, it will reach the largest real estate network on the web.*
1,705 all-time views
of this home (chart)
177 forecasted views of this home
in the first 7 days after listing for sale

Comparable Homes

Homes like this sold for $139-228K.



Neighborhood: 45224

Zillow predicts 45224 home values will increase 0.5% next year, compared to a 2.1% rise for Finneytown as a whole. Among 45224 homes, this home is valued 218.7% more than the midpoint (median) home, and is valued 61.7% more per square foot.

Foreclosures will be a factor impacting home values in the next several years. In 45224, the number of foreclosures waiting to be sold is 48% greater than in Finneytown, and 138.1% higher than the national average. This higher local number may prevent 45224 home values from rising as quickly as other regions in Finneytown.
  read more Less 


    For Sale

    See all nearby listings


    See all nearby rentals

    Nearby Schools in Finneytown

    GreatSchools ratings give an overview of a school's test results. The ratings are based on a comparison of test results for all schools in the state.

    Disclaimer: School attendance zone boundaries are supplied by Maponics and are subject to change. Check with the applicable school district prior to making a decision based on these boundaries.

    Data by GreatSchools.org