Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$1,499,000

  • For Sale
  • Under Contract
  • Single Family
  • 3 Beds
  • 3 Full Baths
  • 2 Partial Baths
  • 8,418 Sq. Ft.
  • 9.074 Acres
  • 4 Car Garage
See This Home
Save This Home
See This Home
Save This Home
Truly remarkable custom luxury ranch in Union Twp/Kings SD. 9.07 rolling acres with gorgeous views of Little Miami River & valley. Country feel with convenient access to I-71, 30 min to WEC & Caesars Creek trails. Built w/Insulated Concrete Form construction, brick exterior & vinyl trim/decking equals low maintenance. At 8418 total sq ft, this home has 2 full floors of living space that would be ideal for multi generational buyers. Soaring ceilings; handmade cabinetry in foyer, both kitchens, all bathrooms, both laundry rooms; hand stained woodwork top to bottom, Pella solid wood doors, pocket doors, 2 FP, HDWD & tile floors. Barn features concrete floors, front & back double sliding doors, electric, water, outdoor pens. Detached garage has RV hookup/clean out, front & back garage doors, half bath, electric, heat, water. The 4 car attached garage also has heat/water. Expansive deck overlooks valley & in ground pool, stone patio; LL has separate garage entry. Agent related to seller

Full Property Details for 507 Shawhan Rd

General

  • Price: $1,499,000
  • Status: Under Contract
  • Type: Single Family
  • Source: 506
  • MLS ID: 937526
  • Updated: 1/24/2026
  • Added to Site: 247 day(s) ago

Interior

  • Number of Rooms: 11
  • Interior Features: Wet Bar, Ceiling Fan(s), Kitchen Island, Pantry, Second Kitchen, Solid Surface Counters, Vaulted Ceiling(s), Bar, Walk-In Closet(s), Central Vacuum
  • Fireplace: Yes
  • Number of Fireplaces: 2
  • Fireplace(s): Two, Gas, Wood Burning
  • Appliances: Built-In Oven, Dryer, Dishwasher, Microwave, Range, Refrigerator, Washer, Gas Water Heater

Rooms

Bathrooms

  • Total Bathrooms: 5
  • Full Bathrooms: 3
  • Half Bathrooms: 2
  • Main Floor Baths: 4

Bedrooms

  • Total Bedrooms: 3

Additional Information

  • Pool: Yes
  • Pool Description: In Ground, Pool
  • Security/Safety: Smoke Detector(s)
  • Equipment: Generator

Exterior

  • Exterior Features: Deck, Fence, Pool, Porch, Patio
  • Porch/Patio/Deck: Deck, Patio, Porch

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 4
  • Parking Features: Attached, Detached, Four or more Spaces, Garage, Heated Garage

Location

  • County: Warren
  • Subdivision: Union
  • Cross Streets: Mason Morrow

School Information

  • Elem School District: Kings
  • Midd School District: Kings
  • High School District: Kings

Heating & Cooling

  • Central air: Yes
  • Air Conditioning: Yes
  • Cooling Type: Central Air
  • Heating Type: Electric, Forced Air, Propane

Utilities

  • Sewer: Septic Tank
  • Water: Public
  • Utility Description: Septic Available, Water Available

Structural Information

  • Architectural Style: Ranch
  • Construction: Brick, Other, Vinyl Siding
  • Basement: Yes
  • Basement Desc.: Full, Finished
  • Windows: Casement Window(s), Insulated Windows, Wood Frames
  • Stories/Levels: 1
  • Square Feet: 8,418
  • Sq. Ft. Source: Assessor
  • Living Area: 8,418 Sq. Ft.
  • Year Built: 1999

Lot Features

  • Lot Size (Acres): 9.074
  • Lot Size (Sq. Ft.): 395,263
  • Lot Size: 395263
  • Lot Size Source: Assessor
  • Lot Dimensions: 9.07 acre
  • Fence: Yes
  • Zoning: Residential

Financial Considerations

  • For Sale/Rent/Lease: For Sale

Disclosures and Reports

  • Legal Description: 3-5-31 9.0740 AC.
  • Property ID: 13312000070

Listed by Coldwell Banker Heritage (513) 899-9990, Heather Frisch (513) 509-1221

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

— 507 Shawhan Rd —

  • Heather Frisch

    Coldwell Banker Heritage

    (513) 899-9990

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 507 Shawhan Rd

School District:Kings Local School District
NameGradesDistance
Kings Junior High School
5620 Columbia Road, Kings Mills, OH 45034
7-83.1 mi
Kings High School
5500 Columbia Road, Kings Mills, OH 45034
9-123 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 507 Shawhan Rd Get Price Alerts and Save Property

Date
Details
Price
Change
Source
9/24/2025
Price Reduced
$1,499,000
-9.15%
MLS
6/25/2025
Listed
$1,650,000
—
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 507 Shawhan Rd

Year
Property Taxes
Change
Tax Assessment
Change
2025
$22,054
-2%
$436,349
—
2024
$22,457
9%
$436,349
22%
2023
$20,537
1%
$358,803
—
2022
$20,305
19%
$358,803
—
2021
$17,001
—
$358,803
11%
2021
$17,013
-8%
$322,021
—
2019
$18,493
—
$322,022
—
2018
$18,554
-5%
$322,022
7%
2017
$19,542
4%
$301,795
—
2016
$18,849
11%
$301,795
—
2015
$17,036
1%
$301,795
6%
2014
$16,933
—
$283,714
—
2013
$16,957
—
$283,714
—
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 507 Shawhan 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 Coldwell Banker Heritage (513) 899-9990, Heather Frisch (513) 509-1221

Similar Properties near 507 Shawhan Rd

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

0 Wilmington Rd, Oregonia, OH 45054 - Photo 1
$1,504,500

0 Wilmington Rd  #18  Oregonia, OH 45054

  • Single Family
  • Active
  • Updated 5 hours ago
  • 4
    Beds
  • 4
    Total Baths
4870 Bunnell Hill Rd, Lebanon, OH 45036 - Photo 1
$1,495,000
Open House

4870 Bunnell Hill Rd  Lebanon, OH 45036

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 4,180
    Sq. Ft.
Listed by Ullery Real Estate LLC (937) 999-4010, Lara Ullery (937) 673-8874
2220 Wilmington Rd, Lebanon, OH 45036 - Photo 1
$1,250,000
Open House

2220 Wilmington Rd  Lebanon, OH 45036

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 3,176
    Sq. Ft.
4904 Bunnell Hill Rd, Lebanon, OH 45036 - Photo 1
$1,390,000

4904 Bunnell Hill Rd  Lebanon, OH 45036

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 5,044
    Sq. Ft.
Listed by Design Homes & Development Co. (937) 438-3667, Tara Miller (937) 418-4538

Just Listed near 507 Shawhan Rd

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

8524 Main St, Butlerville, OH 45162 - Photo 1 Just Listed
$225,000

8524 Main St  Butlerville, OH 45162

  • Duplex
  • Active
  • Updated 2 days ago
  • 1,738
    Sq. Ft.
329 Stone Ridge Blvd, South Lebanon, OH 45065 - Photo 1 Just Listed
$485,000

329 Stone Ridge Blvd  South Lebanon, OH 45065

  • Single Family
  • Active
  • Updated 4 hours ago
  • 5
    Beds
  • 4
    Total Baths
  • 2,920
    Sq. Ft.
6636 Honey Suckle Ln, Hamilton Township, OH 45039 - Photo 1 Just Listed
$360,000
Open House

6636 Honey Suckle Ln  Hamilton Township, OH 45039

  • Single Family
  • Active
  • Updated 10 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,899
    Sq. Ft.
Listed by Tanya Tchervinski (513) 307-1891
1065 Dunstan Ct, Hamilton Township, OH 45152 - Photo 1 Just Listed
$489,900

1065 Dunstan Ct  Hamilton Township, OH 45152

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,880
    Sq. Ft.

Price Reduced near 507 Shawhan Rd

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

3797 E Foster-Maineville Rd, Salem Township, OH 45152 - Photo 1 Price Reduced
-$40,000 (-16.67%)
$200,000

3797 E Foster-Maineville Rd  Salem Township, OH 45152

  • Acreage
  • Active
  • Updated 3 days ago
  • 3.069
    Acres
5777 E US Rt 22 & 3, Salem Township, OH 45152 - Photo 1 Price Reduced
-$10,100 (-3.26%)
$299,900

5777 E US Rt 22 & 3  Salem Township, OH 45152

  • Single Family
  • Active
  • Updated 20 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,354
    Sq. Ft.
9143 Swigert Rd, Hamilton Township, OH 45140 - Photo 1 Price Reduced
-$55,000 (-4.4%)
$1,195,000

9143 Swigert Rd  Hamilton Township, OH 45140

  • Single Family
  • Active
  • Updated 4 days ago
  • 4
    Beds
  • 6
    Total Baths
  • 5,845
    Sq. Ft.
880 Sunrise Ridge Ct, Maineville, OH 45039 - Photo 1 Price Reduced
-$2,500 (-0.44%)
$564,500
Open House

880 Sunrise Ridge Ct  Maineville, OH 45039

  • Single Family
  • Active
  • Updated 6 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 3,090
    Sq. Ft.
Listed by RE/MAX Time (513) 492-9472, Michelle Sloan (513) 600-5277

Recent Sales near 507 Shawhan Rd

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

894 Winding River Blvd, Hamilton Township, OH 45039 - Photo 1 Sold
$1,299,000

894 Winding River Blvd  Hamilton Township, OH 45039

  • Single Family
  • Closed
  • 5
    Beds
  • 7
    Total Baths
  • 7,968
    Sq. Ft.
Listed by Luke Luther and Leslie Graham
5720 Grand Legacy Dr, Hamilton Township, OH 45039 - Photo 1 Sold
$1,415,000

5720 Grand Legacy Dr  Hamilton Township, OH 45039

  • Single Family
  • Closed
  • 4
    Beds
  • 5
    Total Baths
  • 6,494
    Sq. Ft.
113 W Orchard Ave, Lebanon, OH 45036 - Photo 1 Sold
$1,300,000

113 W Orchard Ave  Lebanon, OH 45036

  • Single Family
  • Closed
  • 5
    Beds
  • 4
    Total Baths
  • 5,445
    Sq. Ft.
2841 St Rt 123, Salem Township, OH 45152 - Photo 1 Sold
$1,340,000

2841 St Rt 123  Salem Township, OH 45152

  • Farm
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 2,016
    Sq. Ft.

507 Shawhan Road, Morrow, OH 45152 (MLS# 937526) is a Single Family property with 3 bedrooms, 3 full bathrooms and 2 partial bathrooms. 507 Shawhan Road is currently listed for $1,499,000 and was received on June 25, 2025. Want to learn more about 507 Shawhan Road? Do you have questions about finding other Single Family real estate for sale in Morrow? You can browse all Morrow real estate or contact a Coldwell Banker agent to request more information.

Tour this property