$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



Half Baths

Sqr Footage









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
Lease Considered Y/N No
Levels Two
MLS Area Warren-E13
Miscellaneous 220 Volt
New Construction No
Property SubType Farm
Property Type Residential
School District Little Miami Local S
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 Dimensions 14 x 21
Bedroom 2 Length 14
Bedroom 2 Width 21
Bedroom 3 14x18 Level: 2
Bedroom 3 Dimensions 14 x 18
Bedroom 3 Length 14
Bedroom 3 Width 18
Bedroom 4 15x17 Level: 2
Bedroom 4 Dimensions 15 x 17
Bedroom 4 Length 15
Bedroom 4 Width 17
Bedroom 5 14x20 Level: 1
Bedroom 5 Dimensions 14 x 20
Bedroom 5 Length 14
Bedroom 5 Width 20
Bedroom Level 1 Yes
Breakfast Room 13x17 Level: 1
Breakfast Room Dimensions 13 x 17
Breakfast Room Length 13
Breakfast Room Width 17
Cooling Central Air
Dining Room 17x19 Level: 1
Dining Room Dimensions 17 x 19
Dining Room Feat Built-ins, Chandelier, Wood Floor
Dining Room Length 17
Dining Room Width 19
Entry 14x15 Level: 1
Entry (foyer) Closet, Double Doors, Wood Floor
Entry Area 210
Family Room 18x20 Level: 1
Family Room Dimensions 18 x 20
Family Room Features Fireplace, Panel Walls, Wood Floor, Other
Family Room Length 18
Family Room Width 20
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
Laundry Room Length 0
Laundry Room Width 0
Living Room Feat Fireplace, Wet Bar, Wood Floor
Living/Great Room Dimensions 20 x 32
Living/Great Room Length 20
Living/Great Room Width 32
Master Bedroom 15x28 Level: 2
Master Bedroom Dimensions 15 x 28
Master Bedroom Features Bath Adjoins, Dressing Area, Fireplace, Sitting Room, WW Carpet
Master Bedroom Length 15
Master Bedroom Width 28
Rec Room Length 0
Rec Room Width 0
Study 19x20 Level: 1
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:


Gallery (25 photos)

Ask Your Agent a Question

Property vs Zip Code Avg (45152)

Price 4.50M Avg 450K

Sqr Feet 7,536 Avg 1,250

Cost / Sqr Ft $597 Avg $360

Taxes $31,665 Avg $2,010

Acres 321 Avg 8.7

Visits 815 Avg 121

Days on Site 232 Avg 161

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