$939,900

Change currency

Select Currency

Antillean Guilder

Argentina Peso

Aruban Florin

Australian Dollar

Bahamian Dollar

Barbadian Dollar

Belize Dollar

Bermudan Dollar

Bitcoin

Brazil Real

Bulgarian Lev

Canadian Dollar

Cayman Islands Dollar

Chile Peso

China Yuan Renminbi

Columbian Peso

Costa Rican Colón

Czech Republic Koruna

Denmark Krone

Dominican Peso

Euros

Fiji Dollar

Ghanaian Cedi

Honduras Lempira

Hong Kong Dollar

Hungary Forint

Iceland Krona

India Rupee

Indonesia Rupiah

Israel Shekel

Jamaican Dollar

Japan Yen

Korea (South) Won

Lebanese Pound

Malaysia Ringgit

Mexico Peso

Mauritian Rupee

New Zealand Dollar

Nicaraguan Córdoba

Nigerian Naira

Norway Krone

Pakistan Rupee

Panamanian Balboa

Peruvian Sol

Philippine Peso

Poland Zloty

Russia Ruble

Singapore Dollar

South Africa Rand

Sweden Krona

Switzerland Franc

Taiwan New Dollar

Thailand Baht

Trinidad & Tobago Dollar

Turkey Lira

United Arab Emirates Dirham

United Kingdom Pound

Uruguayan Peso

US Dollar

Viet Nam Dong

Qatar Riyal

 

450 Ivy Trails Drive Union Twp, OH, United States 45244

HOUSE BEAUTIFUL-Former Model Home! Custom-built w/soaring ceilings & dramatic walls of windows, this stunning residence blends refined luxury w/everyday comfort. Great Rm features beam ceilings & built-in bookshelves & flows seamlessly into a FABULOUS Dining Room with transom windows. A private 1st floor study with Bookshelves! Entertainer's Kitchen. Designed for both style & function, opens to the HEARTH ROOM w/VAULTED CEILINGS & STONE FIREPLACE! Walk out to the PRIVATE outdoor Retreat, the perfect setting for gatherings, a true private oasis with a built-in saltwater pool, koi pond, & oversized fireplace all framed by a large private lot. A 1st floor Primary Suite with spa-like bath. Expansive lower level offers endless possibilities w/media room, bar, recreation areas, two additional bedrooms and full bath. This remarkable property truly offers the best of both worlds: LUXURY LIVING in a private natural setting! Three Car Side Entry Garage!

Amenities

  • Bedrooms: 3
  • Full Bathrooms: 2
  • Partial Bathrooms: 1
  • Property Type: Residential
  • Architectural Style: Ranch
  • Year Built: 2004
  • Built in 2004
  • Home size: 4,785 ft2 / 444.54 m2
  • MLS: 1855219
  • Status: Pending
Copyright © 2025 MLS of Greater Cincinnati, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Property brokered by

Comey & Shepherd REALTORS

(513) 527-3011

Presented by Pam Steiner

  • (513) 231-2800
  • (513) 231-2800 (Office Phone)

Contact Pam Steiner

Contact Agent


Language

Sign In

To save and share favorite properties