$4,500,000 3909 Stubbs Mills Road Union Twp, OH

MLS: 1582622   Type: Single Family   County: Warren   City: Union Twp   Area: Union Twp.   Zip: 45152   # Rooms: 16    Stories: 2   Taxes: $31,665

Mortgage $21,127 /mo

Beds

Baths

Half Baths

Sqr Footage

Acres

Built

5

4

2

7,536

321

1974

Newbridge Farm in Warren County 320 ac of fields & rolling woods, 7 ponds, 3000+ ft of frontage on Little Miami River, 2 homes & 8 stall stable. Homes secluded from rd. Main home brick/English Country Manor style, 16 rms, 5br/4 2/2 bath, 6 WBFP, 7536 sq ft, 4-car garage. 2nd home brick, 6000 sq ft total, 2 bd, 2 1/2 bath, 3 car garage, 2nd fl unfin

Elementary School

Middle School

High School

Click Here
Distance: N/A Miles
Click Here
Distance: N/A Miles
Little Miami Local S
Distance: N/A Miles

Price History

6/6/2018 Listed $4,500,000

Access County Road, Private Drive
Available Date 1800-01-01
Entry Dim 14 x 15
Flex Rooms 3 Season, Bedroom, Bonus Room, GuestSuite w/o Ktchn
HOA Fee 0.00
HOA Y/N No
Lease Considered Y/N No
Levels Two
MLS Area Warren-E13
Misc. 220 Volt
New Construction No
Property SubType Farm
Property Type Residential
School District Little Miami Local S
Subdivision Union Twp.
Subdivision Union Twp.
Suburb Union Twp.
Virtualtoururlunbranded https://www.youtube.com/embed/v2nx-wbI4FM?rel=0
Year Built 1974
Zoning Description Residential, Agricultural

Interior Features

1/4 Baths 0
3/4 Baths 0
Appliances Dishwasher, Double Oven, Microwave, Refrigerator, Trash Compactor, Other
Basement Full
Basement Features Bath Rough-In, Unfinished
Bath 1 Full
Bath 1 Level 2
Bath 2 Full
Bath 3 Full
Bath 4 Full
Bathroom Level 1 Yes
Bathrooms 6.00
Bedroom 2 14x21 Level: 2
Bedroom 2 Area 294
Bedroom 3 14x18 Level: 2
Bedroom 3 Area 252
Bedroom 4 15x17 Level: 2
Bedroom 4 Area 255
Bedroom 5 14x20 Level: 1
Bedroom 5 Area 280
Bedroom Level 1 Yes
Breakfast Room 13x17 Level: 1
Breakfast Room Area 221
Breakfast Room Dimensions 13 x 17
Cooling Central Air
Dining Room 17x19 Level: 1
Dining Room Area 323
Dining Room Dimensions 17 x 19
Dining Room Feat Built-ins, Chandelier, Wood Floor
Entry 14x15 Level: 1
Entry (foyer) Closet, Double Doors, Wood Floor
Entry Area 210
Family Room 18x20 Level: 1
Family Room Area 360
Family Room Dimensions 18 x 20
Family Room Features Fireplace, Panel Walls, Wood Floor, Other
Fireplace Features Brick, Ceramic, Marble
Formal Dining Room Yes
Full Baths 4
Gas None
Half Baths 2
Heating Heat Pump, Oil
Interior Features 9Ft + Ceiling, Multi Panel Doors
Kitchen Area 420
Kitchen Dimensions 20 x 21
Kitchen Features Counter Bar, Gourmet, Island, Planning Desk, Tile Floor, Walkout, Wood Cabinets
Laundryroom Area 0
Living Room Feat Fireplace, Wet Bar, Wood Floor
Living/Great Room Area 640
Living/Great Room Dimensions 20 x 32
Master Bedroom 15x28 Level: 2
Master Bedroom Area 420
Master Bedroom Dimensions 15 x 28
Master Bedroom Features Bath Adjoins, Dressing Area, Fireplace, Sitting Room, WW Carpet
Recreationroom Area 0
Study 19x20 Level: 1
Study Area 380
Study Dimensions 19 x 20
Study Features Bookcases, Fireplace, Panel Walls, Walkout, Wood Floor
Total Bedrooms 5
Total Fireplaces 6
Total Rooms 16
Window Features Wood

Exterior Features

Architectural Style Other
Buildings Guest House, Stable, Workshop
Construction Materials Block, Brick
Exterior Features Balcony, Covered Deck/Patio
Farm Type Crop(Grain, Corn, Soy)
Fencing Metal
Foundation Details Poured
Garage Spaces 4.00
Garage/Carport Built in, Garage Attached, Oversized
Land Description Over 100 Acres
Lot Dimensions Of Record
Lot Size Acres 321.00
Lot Size Square Feet 13982760.00
Lot Size Units Acres
Roof Slate
Sewer Septic
Topography Lake/Pond, Level, Low, Sloped, Steep, Undeveloped
Trees Hickory, Oak, Pine, Wooded-Partial
View Lake/Pond, Woods, Other
Water Source Well Water

Property Schools



Direct Link:

https://www.eraanderson.com/property/151-1582622-3909-Stubbs-Mills-Road-Union-Twp-OH-45152

Gallery (25 photos)

Ask Your Agent a Question

Property vs Zip Code Avg (45152)

Price 4.50M Avg 396K

Sqr Feet 7,536 Avg 1,347

Cost / Sqr Ft $597 Avg $294

Taxes $31,665 Avg $2,004

Acres 321 Avg 6.79

Visits 674 Avg 91

Days on Site 162 Avg 113

Ask How to Finance this Property

Download Our Mobile App

Download Millions Mapped

Listing Provided Courtesy Of: Amy Sigg Davis with Sibcy Cline, Inc. - 513-932-6334




Back to Search

Chat is Now Online! Ask Away!

Find Your Home's Value Instantly

Saved Properties

This is a list of your favorite properties. We will email you if a property is reduced or leaves the market.

Click 'Save' to add a property to this list.

Register / Login

New & returning visitors please enter your information to login.

By clicking 'register' you are agreeing to our terms of use & giving us expressed written consent to contact you.

Questions? Comments? Complaints?

This message will go directly to the head of our team.

Location & Address

ERA Real Solutions Realty
8006 Beechmont Ave
Cincinnati, OH
567-998-3494
513-297-5800