Union Rd, Franklin, OH 45005
Property image
Property image
PENDING
149.67 ACRES

$16,313,768

    Union Rd, Franklin, OH 45005

    Est. Mortgage $101,954/mo*
    Get Pre-Qualified

    Home Highlights

    Lot/Land
    149.67 acre lot

    Local Information

    • Map ViewExplore the area around Union Rd.
    • Schools1 Preschool School3 Elementary Schools2 Middle Schools1 High School
    • Shop & Eat
    -- mins to
    Commute Destination

    About this House

    Who's looking for available land with loads of potential in a very desirable location? This farm has been in the family for
    7 generations and been well loved and farmed. The 2 available parcels of land border Union Road and Hendrickson Road
    in Turtlecreek Township. Sellers prefer to sell both Parcel 07022000090 (81.55 acres) & Parcel 08321000080 (68.12
    acres) together. Currently zoned Mixed Use. Almost 1.5 miles of road frontage with existing water line on its entirety.
    Sanitary sewer line at the north property line near the city of Middletown Corp Line. Amazing opportunity for someone
    with the upcoming plans for the area.
    Last check for updates: about 22 hours ago
    Listing courtesy of Amy Hamilton, (937) 530-4904
    Keller Williams Community Part
    Originating MLS: Dayton Area Board of REALTORS
    Source: DABR MLS, MLS#964836
    Also Listed on DABR MLS, DABR MLS.

    Home Details for Union Rd

    Days on Market

    Days on Market: 52

    Property Information

    Property Type / Style
    Property Type: LandProperty Subtype: Unimproved Land
    Property Information
    Parcel Number: 07022000090

    Price & Status

    Price
    List Price: $16,313,768
    Status Change & Dates
    Off Market Date: Thu Jul 23 2026

    Active Status

    MLS Status: Pending

    Location

    Direction & Address
    City: Turtlecreek Twp
    School Information
    Elementary School District: LebanonJr High / Middle School District: LebanonHigh School District: Lebanon

    Agent Information

    Listing Agent
    Listing ID: 964836

    HOA

    Association for this Listing: Dayton Area Board of REALTORS

    Lot Information

    Lot Area: 149.6676 Acres

    Miscellaneous

    Mls Number: 964836Living Area Range Units: Square FeetAttribution Contact: (937) 530-4904Universal Property Id: US-39165-N-07022000090-R-N

    Around this home

    What Locals Say about Franklin

    At least 66 Trulia users voted on each feature.

    • 86 % Say parking is easy

    • 85 % Say there are sidewalks

    • 81 % Say yards are well-kept

    • 80 % Say car is needed

    • 80 % Say it's dog friendly

    • 80 % Say kids play outside

    • 75 % Say there's holiday spirit

    • 66 % Say people would walk alone at night

    • 59 % Say it's quiet

    • 54 % Say streets are well-lit

    • 47 % Say neighbors are friendly

    • 44 % Say there's wildlife

    • 41 % Say it's walkable to grocery stores

    • 38 % Say it's walkable to restaurants

    • 35 % Say they plan to stay for at least 5 years

    • 24 % Say there are community events

    Sourced by Trulia users. Learn more about our methodology.
    • Sandra Lester
      "It has a Down to earth community and small town feel! Lots of upgrades citywide as well! Plenty of expansion opportunities "
      0
      Flag
    • Ljsmith26
      "Franklin is small and comforting. Nice people and good businesses. Growing community, great school, and lots of opportunities for kids in sports or creativity. "
      2
      Flag
    • Sadie N.
      "Walking distant to downtown. Minutes away from highway. Everything is semi close together. There is no public transportation Such as buses. "
      0
      Flag
    • Kristiewarren88
      "fall festival is very fun, and the churches around here put on free events for everyone around different Holidays, you dont even have to be a member. "
      2
      Flag
    • Briannadurham2014
      "Don’t let kids ride their bikes on the roads. It’s unsafe! Reckless drivers. I also wouldn’t recommend going to Walmart alone as well. "
      1
      Flag
    • shawnmachelle
      "We have lived here for almost a year, and we love the quiet country feel! Neighbors are friendly and we feel welcomed and safe here!"
      0
      Flag
    • Tgbarnes
      "Kid friendly, little traffic, dogs are fenced in. Good school system. At least one police officer per block lives in the community"
      2
      Flag
    • Jen Chappel
      "I love it here use to play here as a kid and I decided to move my kids for better schooling and for myself a better job haven't had any problems I gotta say best decision I made was moving here 3 years ago my kids are happy and so I'm i"
      0
      Flag
    • Tina T.
      "No public transportation need to have a car. My job is seven minutes away so it’s a good commute. People are not nice."
      1
      Flag
    • Kristiewarren88
      "I have a pretty quiet neighborhood. Though I live right behind a gas station, I never have any trouble with anyone or anything. Kids play outside all the time, people take care of their yards, barely any stray animals, and everyone is pretty respectful :)"
      3
      Flag
    • Tristanfaye66
      "some stay to them selfs and some are drug dealers my left hand neighbors are cool were good freinds. the rest dont really interact often"
      0
      Flag
    • Kristiewarren88
      "People in my neighborhood always take care of their lawns and houses. My neighborhood is relatively quiet and a good place for kids! "
      1
      Flag
    • darcomurphy
      "We have lived in this peaceful neighborhood for years and have been extremely happy with our decision to plant roots in this area."
      2
      Flag

    Market trends in Franklin

    Last updated August 2026
    Buyer'sMarketSeller'sMarket
    Avg. sale price
    $231K
    $23K    MoM
    Sale-to-List Price
    —
    Price per sq ft
    $165
    $1    MoM
    Available listings
    75
    4    MoM

    Home Value

    Learn more about this home's value by checking out the value of nearby homes and how much similar homes have sold for.

    Comparable sales

    These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
    Address
    Distance
    Property Type
    Sold Price
    Sold Date
    Bed
    Bath
    Sqft
    4819 Caprice Dr, Middletown, OH
    1.28
    Lot/Land
    $23,000
    08/31/26
    -
    -
    3545 Robinson Vail Rd, Franklin, OH
    2.31
    Lot/Land
    $40,000
    05/01/26
    -
    -
    806 Eaton Ave, Middletown, OH
    2.66
    Lot/Land
    $20,000
    05/19/26
    -
    -
    5031 Gerber Dr, Middletown, OH
    2.96
    Lot/Land
    $80,000
    01/29/26
    -
    -
    2121 N State Route 741, Franklin, OH
    2.84
    Lot/Land
    $500,000
    04/16/26
    -
    -
    5696 Woodcreek Dr, Middletown, OH
    3.28
    Lot/Land
    $35,000
    02/04/26
    -
    -
    2227 Winton St, Middletown, OH
    3.04
    Lot/Land
    $307,000
    03/11/26
    -
    -
    3119 Seneca St, Middletown, OH
    3.68
    Lot/Land
    $23,500
    05/22/26
    -
    -
    Colton Ct, Lebanon, OH
    4.07
    Lot/Land
    $110,000
    12/03/25
    -
    -

    Nearby home prices

    Get a sense of expected prices in the area by checking the value of nearby homes.
    Address
    Distance
    Price
    Bed
    Bath
    Sqft
    Status
    5937 Hendrickson Rd, Franklin, OH 45005
    0.12
    $414,300
    3
    2
    1,665
    Off Market
    6171 Hendrickson Rd, Middletown, OH 45044
    0.14
    $373,700
    5
    2.5
    2,159
    Off Market
    2396 Union Rd, Middletown, OH 45044
    0.18
    $296,600
    3
    2
    2,468
    Off Market
    6185 Hendrickson Rd, Middletown, OH 45044
    0.20
    $481,600
    4
    3.5
    -
    Off Market
    5819 Hendrickson Rd, Franklin, OH 45005
    0.25
    $239,000
    3
    1.5
    1,160
    Off Market
    5740 Hendrickson Rd, Franklin, OH 45005
    0.32
    $600,000
    4
    3
    2,863
    Recently Sold
    2281 Union Rd, Middletown, OH 45044
    0.36
    $359,900
    3
    2.5
    2,132
    For Sale
    6451 Hendrickson Rd, Middletown, OH 45044
    0.42
    $273,400
    3
    2
    1,823
    Off Market
    2280 Trinity Dr, Middletown, OH 45044
    0.43
    $315,000
    3
    2
    1,452
    Recently Sold
    2234 Trinity Dr, Middletown, OH 45044
    0.46
    $425,900
    3
    3.5
    2,601
    Off Market
    6485 Calloway Ct, Middletown, OH 45044
    0.46
    $259,500
    3
    2
    1,212
    Off Market
    2374 Trinity Dr, Middletown, OH 45044
    0.46
    $275,000
    3
    1.5
    1,192
    Recently Sold

    Price and Tax history

    DateEventPrice
    Jul 24, 2026
    Source: DABR MLS #964836
    		Pending
    $16,313,768
    Jul 23, 2026
    Source: DABR MLS #964836
    		Listed For Sale
    $16,313,768
    Jun 21, 2025
    Source: DABR MLS #896174
    		ListingRemoved
    $16,313,768
    Jun 20, 2024
    Source: DABR MLS #896174
    		PriceChange
    $16,313,768
    Price decreased by 1%
    Sep 28, 2023
    Source: DABR MLS #896174
    		Listed For Sale
    $16,463,436

    LGBTQ Local Legal Protections

    Amy Hamilton, Keller Williams Community Part
    Agent Phone: (937) 530-4904
    IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
    Copyright Dayton Area Board of Realtors. All rights reserved. Information is deemed reliable but not guaranteed.

    Similar Homes You May Like

    Skip to last item
    Skip to first item

    New Listings near Union Rd

    Skip to last item
    • Results are loading
    Skip to first item

    Frequently asked questions about Union Rd

    • How big is Union Rd?
      Union Rd in Franklin, OH is about 149.7 acres.
    • What is the price per acre for Union Rd?
      Union Rd in Franklin, OH is listed at $16,313,768, or about $110K per acre.
    • What are the closest schools to Union Rd?
      The closest schools to Union Rd in Franklin, OH are Berry Intermediate School (Elementary, rated 7/10), Bowman Primary School (Pre-K), Donovan Elementary School (rated 9/10).
    • What is the price history for Union Rd?
      Union Rd in Franklin, OH last sold for $40,000 in June 2021.
    Union Rd, Franklin, OH 45005 is a lot/land. This property is currently available for sale and was listed by DABR MLS on Jul 23, 2026. The MLS # for this home is MLS# 964836.