Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$338,000 Just Listed

  • For Sale
  • Active
  • Single Family
  • 4 Beds
  • 1 Full Bath
  • 1 Partial Bath
  • 2,412 Sq. Ft.
  • 0.31 Acres
  • Updated 13 hours ago
See This Home
Save This Home
See This Home
Save This Home
Meticulously maintained! Check out this picture perfect 4 bedroom Cape Cod! This home radiates charm from the moment you pull into the driveway! Inside, you'll find cozy rooms with an inviting atmosphere that makes you feel right at home! Finished basement featuring a spacious family room & bar area for entertaining! Fenced in back yard! The deck off of dining/kitchen offers a private oasis for morning coffee or weekend gatherings! Nestled in the sought after Hidden Valley Lake community, you're just minutes away from lake access, the sandy beach, and community pool! Only 30 minutes west of Cincinnati, Ohio! Schedule your private viewing today!

Full Property Details for 957 Greentree Rd

General

  • Price: $338,000
  • Status: Active
  • Type: Single Family
  • Source: SE_Indiana
  • MLS ID: 207044
  • Updated: Today (3/20/2026)
  • Added to Site: Today

Interior

  • Interior Features: Crown Molding, Other, Vinyl Plank
  • Appliances: Dishwasher, Microwave, Oven/Range, Refrigerator

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Bathrooms-L1: Yes
  • Primary Bathroom: Other, Tile Floor, Tub w/Shower
  • Bathroom 1: Full
  • Bathroom 2: Partial, Level 2

Bedrooms

  • Total Bedrooms: 4
  • Primary Bedroom: 21.00 x 14.00, Level: 2, 294 Sq. Ft.
  • Bedroom 1: Yes
  • Bedroom 2: 15.00 x 8.00, Level: 2, 120 Sq. Ft.
  • Bedroom 3: 11.00 x 10.00, Level: 1, 110 Sq. Ft.
  • Bedroom 4: 10.00 x 9.00, Level: 1, 90 Sq. Ft.

Other Rooms

  • Living Room: 18.00 x 14.00, 252 Sq. Ft.
  • Family Room: 21.00 x 12.00, Basement, 252 Sq. Ft.
  • Kitchen: 10.00 x 10.00, Level: 1, 100 Sq. Ft.
  • Dining Room: 12.00 x 7.00, Level: 1, 84 Sq. Ft.
  • Office/Den/Study: 9.00 x 9.00, 81 Sq. Ft.
  • Study: Basement
  • Laundry: 15.00 x 12.00, Basement, 180 Sq. Ft.
  • Other Room 1: 16.00 x 12.00, Basement, 192 Sq. Ft.

Exterior

  • Exterior Features: Fire Pit, Other

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Other Parking Type: Driveway
  • Parking: Concrete Floor, Front, Garage Attached
  • Garage Description: Concrete Floor, Front, Garage Attached

Location

  • County: Dearborn
  • Township: Miller

School Information

  • School District: Sunman Dearborn
  • Elementary School: Bright Elementary
  • High School: East Central High Sc

Community

  • Community Type: Boating, Other, Fishing, Fitness, Social Clubs, Sports-Organized, Golf Course, Tennis, Golf Cart, Walk/Run Paths, Lake, Water Features
  • Association: Yes
  • Assoc. Fees Include: Association Dues, Clubhouse, Other, Play Area, Pool, Snow Removal, Walking Trails

Heating & Cooling

  • Cooling Type: Ceiling Fans, Central Air Conditioning
  • Heating Type: Electric, Forced Air
  • Water Heater: Electric

Utilities

  • Gas: None
  • Sewer: Public Sewer
  • Water: Public

Structural Information

  • Architectural Style: Cape Cod
  • Exterior Const.: Brick, Vinyl Siding
  • Basement: Yes
  • Basement Desc.: Built-Ins, Concrete Floor, Other, Walkout, WW Carpet, Full
  • Foundation: Poured
  • Roof: Shingle
  • Windows: Other, Double Hung, Vinyl
  • Stories/Levels: Two
  • Square Feet: 2,412
  • Living Area: 2,412 Sq. Ft.
  • Year Built: 1973

Manufactured Home

  • Land Information: Other

Lot Features

  • Property View: Other
  • Lot Size (Acres): 0.31
  • Lot Size (Sq. Ft.): 13,504
  • Frontage: City Street
  • Street/Road Desc.: Asphalt
  • Fence: Yes
  • Fencing (Description): Chain Link, Other

Water Features

  • Lake Front: Yes

Disclosures and Reports

  • APN: 15-06-24-302-047.000-020

Listed by Keller Williams Realty Services, Ericka Schnur and Keller Williams Realty Services

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 agents

— 957 Greentree Rd —

  • Ericka Schnur

    Keller Williams Realty Services

  • Keller Williams Realty Services

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 957 Greentree Rd

School District:Sunman-Dearborn Community School Corporation
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 957 Greentree Rd Get Price Alerts and Save Property

Date
Details
Price
Change
Source
3/20/2026
Listed
$338,000
35.2%
MLS
4/28/2022
Sold
$250,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 957 Greentree Rd

Year
Property Taxes
Change
Tax Assessment
Change
2024
$1,934
—
$250,500
17%
2024
$1,934
14%
$214,900
8%
2023
$1,701
9%
$199,000
9%
2022
$1,557
9%
$183,100
8%
2020
$1,428
14%
$169,900
—
2019
$1,254
—
$169,900
10%
2018
$1,254
8%
$154,900
3%
2017
$1,161
7%
$150,900
8%
2016
$1,084
—
$140,200
—
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 957 Greentree Rd

$
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 Keller Williams Realty Services, Ericka Schnur and Keller Williams Realty Services

Similar Properties near 957 Greentree Rd

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

9388 Sr 48, Aurora, IN 47001 - Photo 1
$342,000

9388 Sr 48  Aurora, IN 47001

  • Single Family
  • Active
  • 4
    Beds
  • 2
    Total Baths
  • 1,882
    Sq. Ft.
Listed by Sibcy Cline - Lawrenceburg, Myra Clary
9388 St Rt 48, Aurora, IN 47001 - Photo 1
$342,000

9388 St Rt 48  Aurora, IN 47001

  • Single Family
  • Active
  • 4
    Beds
  • 2
    Total Baths
  • 1,882
    Sq. Ft.
237 Cook Ave, Lawrenceburg, IN 47025 - Photo 1
$330,000

237 Cook Ave  Lawrenceburg, IN 47025

  • Single Family
  • Active
  • 3
    Beds
  • 3
    Total Baths
  • 1,544
    Sq. Ft.
Listed by Keller Williams Realty Services, Gage Lainhart and Keller Williams Realty Services
14100 Red Brg Rd, Aurora, IN 47001 - Photo 1
$339,900

14100 Red Brg Rd  Aurora, IN 47001

  • Single Family
  • Active
  • 3
    Beds
  • 1
    Total Bath
  • 1,753
    Sq. Ft.
Listed by Cornerstone Realty, Dale Lutz

Just Listed near 957 Greentree Rd

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

5394 Belleview Rd, Petersburg, KY 41080 - Photo 1 Just Listed
$499,900

5394 Belleview Rd  Petersburg, KY 41080

  • Single Family
  • Active
  • Updated 2 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,100
    Sq. Ft.
5225 Whitton Rd, Petersburg, KY 41080 - Photo 1 Just Listed
$900,000

5225 Whitton Rd  Petersburg, KY 41080

  • Single Family
  • Active
  • Updated 1 hour ago
  • 5
    Beds
  • 3
    Total Baths
  • 4,064
    Sq. Ft.
19685 Collier Ridge Rd, Guilford, IN 47022 - Photo 1 Just Listed
$649,900

19685 Collier Ridge Rd  Guilford, IN 47022

  • Single Family
  • Active
  • Updated 8 hours ago
  • 2
    Beds
  • 1
    Total Bath
  • 1,104
    Sq. Ft.
Listed by Fehrman Realty, Brett Fehrman
8982 Harrison Ave, Cleves, OH 45002 - Photo 1 Just Listed
$399,900

8982 Harrison Ave  Cleves, OH 45002

  • Single Family
  • Active
  • Updated 11 hours ago
  • 3
    Beds
  • 1
    Total Bath
  • 1,154
    Sq. Ft.

Price Reduced near 957 Greentree Rd

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

5225 Whitton Rd, Petersburg, KY 41080 - Photo 1 Price Reduced
-$50,000 (-6.25%)
$750,000

5225 Whitton Rd  Petersburg, KY 41080

  • Single Family
  • Active
  • Updated 1 hour ago
  • 5
    Beds
  • 3
    Total Baths
  • 4,064
    Sq. Ft.
311 Broadway St, Aurora, IN 47001 - Photo 1 Price Reduced
-$40,000 (-10.26%)
$349,900

311 Broadway St  Aurora, IN 47001

  • Business
  • Active
  • Updated 8 hours ago
Listed by Rider Realty LLC, Joseph Rider
2443 Wernz Dr, Hebron, KY 41048 - Photo 1 Price Reduced
-$5,000 (-0.94%)
$525,000
Open House

2443 Wernz Dr  Hebron, KY 41048

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,942
    Sq. Ft.
815 Westview Dr, Hebron, KY 41048 - Photo 1 Price Reduced
-$2,000 (-2.06%)
$94,999

815 Westview Dr  Hebron, KY 41048

  • Lots/Land
  • Active
  • Updated 2 days ago
  • 2.08
    Acres

Recent Sales near 957 Greentree Rd

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

747 Hickory Rd, Lawrenceburg, IN 47025 - Photo 1 Sold
$325,000

747 Hickory Rd  Lawrenceburg, IN 47025

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 1,382
    Sq. Ft.
Listed by Tammy Schroer
Sold by Joan Lane
20013 Ravenda Dr, Lawrenceburg, IN 47025 - Photo 1 Sold
$359,900

20013 Ravenda Dr  Lawrenceburg, IN 47025

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,293
    Sq. Ft.
Listed and Sold by Anne Bedinghaus
19930 Alpine Dr, Lawrenceburg, IN 47025 - Photo 1 Sold
$345,000

19930 Alpine Dr  Lawrenceburg, IN 47025

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 1,864
    Sq. Ft.
18632 Whispering Woods Dr, Lawrenceburg, IN 47025 - Photo 1 Sold
$343,750

18632 Whispering Woods Dr  Lawrenceburg, IN 47025

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

957 Greentree Road, Lawrenceburg, IN 47025 (MLS# 207044) is a Single Family property with 4 bedrooms, 1 full bathroom and 1 partial bathroom. 957 Greentree Road is currently listed for $338,000 and was received on March 20, 2026. Want to learn more about 957 Greentree Road? Do you have questions about finding other Single Family real estate for sale in Hidden Valley? You can browse all Hidden Valley real estate or contact a Coldwell Banker agent to request more information.

Tour this property