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.
Sold for $1,850,000
$1,850,000
15 Saint Andrews Dr, North Bend, OH 45052
4beds
6,088sqft
Single Family Residence
Built in 1998
1.89 Acres Lot
$1,725,800 Zestimate®
$304/sqft
$5,625 Estimated rent
Home value
$1,725,800
$1.64M - $1.81M
$5,625/mo
Zestimate® history
Owner options
List your home for rent
$5,625/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,625/mo
Rent Zestimate®
Refinance and save
$10,537/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$10,537/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Finished lower levelDetailed woodwork throughoutHardwood floorsGourmet kitchen
Zillow last checked:
Listing updated:
Listed by:
Rakesh Ram 513-608-1199,
Coldwell Banker Realty 513-922-9400,
Mitchell Ram 513-703-7774,
Coldwell Banker Realty
Bought with:
Rakesh Ram, 0000342857
Coldwell Banker Realty
Source: Cincy MLS,MLS#: 1869192
Originating MLS: Cincinnati Area Multiple Listing Service
Originating MLS: Cincinnati Area Multiple Listing Service
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 6
- Full bathrooms: 4
- 1/2 bathrooms: 2
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Walkout, Fireplace, Sitting Room
- Level: First
- Area: 420
- Dimensions: 28 x 15
Bedroom 2
- Level: First
- Area: 234
- Dimensions: 18 x 13
Bedroom 3
- Level: Lower
- Area: 228
- Dimensions: 19 x 12
Bedroom 4
- Level: Lower
- Area: 300
- Dimensions: 20 x 15
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Built-In Shower Seat, Shower, Tile Floor, Tub, Jetted Tub, Marb/Gran/Slate
Bathroom 1
- Features: Full
- Level: First
Bathroom 2
- Features: Full
- Level: First
Bathroom 3
- Features: Full
- Level: First
Bathroom 4
- Features: Partial
- Level: Second
Dining room
- Features: Wood Floor, Other
- Level: First
- Area: 208
- Dimensions: 16 x 13
Family room
- Features: Fireplace, Wet Bar, Wood Floor
- Area: 594
- Dimensions: 27 x 22
Kitchen
- Features: Counter Bar, Eat-in Kitchen, Gourmet, Kitchen Island, Wood Floor, Marble/Granite/Slate
- Area: 432
- Dimensions: 24 x 18
Living room
- Features: Other
- Area: 208
- Dimensions: 16 x 13
Office
- Features: Wall-to-Wall Carpet, French Doors
- Level: First
- Area: 234
- Dimensions: 18 x 13
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Gas Water Heater
Features
- Windows: Aluminum Frames, Wood Frames
- Basement: Full,Finished,Walk-Out Access,WW Carpet
- Number of fireplaces: 2
- Fireplace features: Gas, Family Room, Master Bedroom
Interior area
- Total structure area: 6,088
- Total interior livable area: 6,088 sqft
Property
Parking
- Total spaces: 3
- Parking features: Driveway
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
Lot
- Size: 1.89 Acres
Details
- Parcel number: 5730009001500
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick, Stone
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 1998
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: Yes
- HOA fee: $480 annually
- HOA name: L&B Managament Firm
Location
- Region: North Bend
Financial & listing details
- Price per square foot: $304/sqft
- Tax assessed value: $975,450
- Annual tax amount: $1,834
- Date on market: 4/24/2026
- Listing terms: No Special Financing,Cash
Price history
| Date | Event | Price |
|---|---|---|
| 5/15/2026 | Sold | $1,850,000+5.7%$304/sqft |
Source:  Cincy MLS #1869192 Report a problem | ||
| 4/27/2026 | Pending sale | $1,750,000$287/sqft |
Source: Cincy MLS #1869192 Report a problem | ||
| 4/24/2026 | Listed for sale | $1,750,000+308.1%$287/sqft |
Source: Cincy MLS #1869192 Report a problem | ||
| 1/12/2017 | Sold | $428,800+564.8%$70/sqft |
Source: Public Record Report a problem | ||
| 9/2/2016 | Sold | $64,500-35.4%$11/sqft |
Source: Cincy MLS #1453593 Report a problem | ||
| 8/16/2016 | Pending sale | $99,900$16/sqft |
Source: Coldwell Banker West Shell - Ohio Indiana West Regional #1453593 Report a problem | ||
| 9/16/2014 | Price change | $99,900-16.7%$16/sqft |
Source: Coldwell Banker West Shell - Ohio Indiana West Regional #1388121 Report a problem | ||
| 1/28/2014 | Price change | $119,900-7.7%$20/sqft |
Source: Coldwell Banker West Shell - Ohio Indiana West Regional #1388121 Report a problem | ||
| 7/4/2013 | Listed for sale | $129,900$21/sqft |
Source: Coldwell Banker West Shell #1364773 Report a problem | ||
| 6/1/2013 | Listing removed | $129,900$21/sqft |
Source: Coldwell Banker West Shell - Ohio Indiana West Regional #1208267 Report a problem | ||
| 3/3/2012 | Listed for sale | $129,900-54.4%$21/sqft |
Source: Coldwell Banker West Shell - Westbourne Drive Office #1208267 Report a problem | ||
| 11/26/1996 | Sold | $285,000$47/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $17,246 -0.4% | $341,408 |
| 2023 | $17,324 +81% | $341,408 +120.9% |
| 2022 | $9,570 +3.6% | $154,557 |
| 2021 | $9,238 | $154,557 +0% |
| 2020 | $9,238 +7.2% | $154,556 +3% |
| 2019 | $8,619 +5.4% | $150,056 |
| 2018 | $8,175 | $150,056 |
| 2017 | $8,175 -50.6% | $150,056 -50% |
| 2016 | $16,555 +0% | $300,108 |
| 2015 | $16,555 -1.1% | $300,108 |
| 2014 | $16,735 -0.5% | $300,108 |
| 2013 | $16,814 +3.9% | $300,108 |
| 2012 | $16,179 -1.2% | $300,108 |
| 2011 | $16,384 +8.7% | $300,108 +4.6% |
| 2010 | $15,074 +11.1% | $287,000 |
| 2009 | $13,572 +3% | $287,000 |
| 2008 | $13,172 +1.2% | $287,000 |
| 2007 | $13,020 +1.1% | $287,000 |
| 2006 | $12,875 +4.6% | $287,000 |
| 2005 | $12,311 -5.6% | $287,000 -1.3% |
| 2003 | $13,041 -0.3% | $290,710 |
| 2002 | $13,082 +7.2% | $290,710 +12.4% |
| 2001 | $12,207 +3% | $258,650 |
| 2000 | $11,846 | $258,650 |
Find assessor info on the county website
Neighborhood: 45052
Nearby homes
- $1,662,8004 bd7 ba73k sqft13 Saint Andrews Dr, North Bend, OH 45052Off Market
- $4,013,900-- bd8 ba10k sqft17 Saint Andrews Dr, North Bend, OH 45052Off Market
- $1,092,8003 bd3 ba3.5k sqft11 Saint Andrews Dr, North Bend, OH 45052Off Market
- $846,8003 bd2 ba3.4k sqft9 Saint Andrews Dr, North Bend, OH 45052Off Market
- $2,002,9005 bd7 ba6.9k sqft21 Saint Andrews Dr, North Bend, OH 45052Off Market
- $423,300-- bd-- ba-- sqft103 Cincinnati Ave, North Bend, OH 45052Off Market
- $597,2004 bd3 ba2.4k sqft16 Saint Andrews Dr, North Bend, OH 45052Off Market
- $200,0000.559 Acres14 Saint Andrews Dr, North Bend, OH 45052Sold
Nearby schools
GreatSchools rating
- 8/10Taylor Middle SchoolGrades: 5-8Distance: 1.8 mi
- 7/10Taylor High SchoolGrades: 9-12Distance: 1.8 mi
- 8/10Three Rivers ElementaryGrades: PK-4Distance: 1.8 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,725,800
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,725,800
- Ohio
- Hamilton County
- North Bend
- 45052
- 15 Saint Andrews Dr
Nearby cities
Nearby zip codes
Other North Bend Topics
