15 St Andrews Drive, North Bend, OH 45052

Local realty services provided by:CENTURY 21 The Gene Group
15 St Andrews Drive,North Bend, OH 45052
$1,750,000
  • 4 Beds
  • 6 Baths
  • 6,088 sq. ft.
  • Single family
  • Active
Listed by: rakesh ram, mitchell ram
Office: coldwell banker realty513-922-9400
MLS#:1869192
Source:OH_CINCY

Price summary

  • Price:$1,750,000
  • Price per sq. ft.:$287.45
  • Monthly HOA dues:$40

About this home

CENTURY 21 Fine Homes & Estates
OPEN HOUSE Sunday 4/26/2016 from 1pm - 3pm. Enjoy breathtaking, panoramic views of the Ohio River and the rolling hills of Kentucky from this exceptional home in the Aston Oaks Golf Course community. Offering over 4,000 square feet of single floor plan living plus a finished lower level, this Hensley custom built home showcases award winning architectural design and craftsmanship. Features include detailed woodwork throughout, hardwood floors, and 12' and 15' ceilings. The gourmet kitchen is perfect for everyday living and entertaining, while the thoughtfully designed layout provides both comfort and functionality. This one of a kind home is being offered of the market for the first time and is ideally situated just 20 minutes from downtown.

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an independent agent affiliated with the CENTURY 21®  brand to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an independent agent affiliated with the CENTURY 21®  brand is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , Coldwell Banker® , Corcoran® , ERA® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:1998
  • Listing ID #:1869192
  • Added:4 day(s) ago
  • Updated:April 24, 2026 at 03:42 PM

Rooms and interior

  • Bedrooms:4
  • Total bathrooms:6
  • Full bathrooms:4
  • Half bathrooms:2
  • Rooms Total:12
  • Dining Description:Wood Floor
  • Kitchen Description:Counter Bar, Eat-In, Gourmet, Island, Marble/Granite/Slate, Wood Floor
  • Bedroom Description:Bath Adjoins, Fireplace, Sitting Room, Walk-in Closet, Walkout
  • Basement Description:Finished, Full, Walkout, Wall-to-Wall Carpet
  • Living area:6,088 sq. ft.

Heating and cooling

  • Cooling:Central Air
  • Heating:Forced Air, Gas

Structure and exterior

  • Roof:Shingle
  • Year built:1998
  • Building area:6,088 sq. ft.
  • Lot area:1.89 Acres
  • Architectural Style:Ranch
  • Construction Materials:Brick, Stone
  • Foundation Description:Poured
  • Levels:1 Story

Utilities

  • Water:Public
  • Sewer:Public Sewer

Finances and disclosures

  • Price:$1,750,000
  • Price per sq. ft.:$287.45

Parking

  • Parking description:Driveway
  • Garage:Yes
  • Garage spaces:3
MLS LogoInformation deemed reliable but not guaranteed. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than CENTURY 21 The Gene Group are marked with the Broker Reciprocity&#8482 logo (the small house as shown to the left) and detailed information about them includes the name of the listing brokers. 2026, MLS of Greater Cincinnati, Inc. All rights reserved.