x
Water Views
Address
3909 Stubbs Mills Road Union Twp, OH
Price
$ 4,500,000
Property Attributes
  • MLS#1582622
  • TypeSingle Family
  • CountyWARREN
  • CityUnion Twp
  • AreaUnion Twp.
  • Zip45152
  • Style
  • Year Built1974
  • Taxes31665
  • Price$ 4,500,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

Elementary School Middle School High School
Unknown Elementary School Unknown Middle School Little Miami Local S High School
Price History
6/6/2018 Listed $4,500,000

General Features

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

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 (foyer) Closet, Double Doors, Wood Floor
Entry Area 210
Family Room 18x20 Level: 1
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
Living Room Feat Fireplace, Wet Bar, Wood Floor
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
Topography Lake/Pond, Level, Low, Sloped, Steep, Undeveloped
Trees Hickory, Oak, Pine, Wooded-Partial
View Lake/Pond, Woods, Other
Water Source Well

Amenities

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

Property vs Zip Code Average in 45152

Price
AVG $400K
$4.5M
Taxes
AVG $2,457
$31,665
Visits
AVG 76
1153
Year Built
AVG 1992
1974

Looking for more comfortable experience?

Check out our mobile application and browse the properties as no other.

// ViewContent: // On each listing details page: