Water Views
3909 Stubbs Mills Road Union Twp, OH
$ 3,890,000
Property Attributes
  • MLS#1582622
  • TypeSingle Family
  • CountyWARREN
  • CityUnion Twp
  • AreaUnion Twp.
  • Zip45152
  • Style
  • Year Built1974
  • Taxes31665
  • Price$ 3,890,000
  • Bedrooms5
  • Full Bathrooms4
  • Half Bathrooms2
  • Sqr Footage7536
  • Lot Size321 Acres
Listing Provided Courtesy Of:
Amy Sigg Davis with Sibcy Cline, Inc. - 513-932-6334
Property Description

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

High School
Little Miami Local S High School
Price History
6/6/2018 Listed $4,500,000
9/27/2019 14% - $3,890,000

General Features

Access County Road, Private Drive
Association Y/N No
Directions Montgomery Road (US22/3) to L on Stubbs Mill Rd to property on L with black board fence entrance. No sign.
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

Interior Features

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 2 Level 2
Bath 3 Full
Bath 3 Level 2
Bath 4 Full
Bath 4 Level 1
Bath Lvl 1 Type Full, Partial
Bathroom Level 1 Yes
Bedroom 2 14x21 Level: 2
Bedroom 3 14x18 Level: 2
Bedroom 4 15x17 Level: 2
Bedroom 5 14x20 Level: 1
Bedroom Level 1 Yes
Breakfast Room 13x17 Level: 1
Cooling Central Air
Dining Room 17x19 Level: 1
Dining Room Feat Built-ins, Chandelier, Wood Floor
Entry 14x15 Level: 1
Entry Area 210
Entry Dimensions 14 x 15
Family Room 18x20 Level: 1
Family Room Features Fireplace, Panel Walls, Wood Floor, Other
Fireplace Features Brick, Ceramic, Marble
Formal Dining Room Yes
Foyer Closet, Double Doors, Wood Floor
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
Living Room Feat Fireplace, Wet Bar, Wood Floor
Master Bathroom Bidet, Double Vanity, Shower, Tile Floor, Tub
Master Bedroom 15x28 Level: 2
Master Bedroom Features Bath Adjoins, Dressing Area, Fireplace, Sitting Room, WW Carpet
Study 19x20 Level: 1
Study Features Bookcases, Fireplace, Panel Walls, Walkout, Wood Floor
Total Bedrooms 5
Total Fireplaces 6
Total Rooms 16
Window Features Wood

Exterior Features

Available Date 1800-01-01
Bathrooms 6.00
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 Tank
Trees Hickory, Oak, Pine, Wooded-Partial
View Lake/Pond, Woods, Other
Water Source Well


  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Master On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Zip Code Average in 45152

AVG $420K
AVG $2,330
AVG 88
Year Built
AVG 1981

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.