Reload the page to update with the latest MLS information available.

Reload the page to update with the latest MLS information available.

Reload the page to update with the latest MLS information available.

Listing provided courtesy of YOUR TOWN REALTORS - MLS#613131MLS Provider

150 Shamrock LaneFort Thomas, KY 41075

Single Family · 5 Beds · 3 Full Baths · 1 Partial Bath · 3,151 Sq. ft. | 60.00 Acres

$2,500,000 Active


Time on Site:
214 days

This is a Rare Opportunity to own an Incredible Ft. Thomas Home on 60 acres with Amazing River Views. Spacious 5 Bedroom, One Owner Home is perfect for Entertaining or simply Enjoying Quiet, Peaceful Living. The Centerpiece of the home is a Magnificent 3 Story Stone Fireplace that adds Character and Warmth. There are Formal Spaces as well as Cozy Family Hangout Spaces. The walls of windows on the backside take in the Stunning Views. Walkout Lower Level features huge Recreation Rooms, providing even more space for Entertaining and Relaxing. The Primary Bedroom is a True Oasis with a Balcony that is perfect for enjoying the view. As you approach the home, you'll appreciate the Long, Private Driveway that provides a sense of Seclusion and Privacy. When you're ready to cool off you can take a dip in the inground pool. In addition to the Home there are Large Lawn Areas, Trails, Creeks and a Large Barn that has endless possibilities. This Nature Lover's Dream is Truly a Gem. Located in Desirable Ft. Thomas School District and just a short drive to Downtown Cincy. Don't miss out on the Chance to make it Yours!

View Map

Facts & Features

  • Type Single Family
  • Sq. ft. 3,151
  • Price/Sq.ft. $793
  • Lot 60.00 Acres


  • Association: No
School Information
  • Elementary School: Woodfill Elementary
  • Middle Or Junior School: Highlands Middle School
  • High School: Highlands High
Building Information
  • New Construction: No
  • Sewer: Public Sewer: true
  • Year Built: 1969
  • County Or Parish: Campbell
  • MLS Area Major: K16 - Ft Thomas/S Gate
  • MLS Area Minor: K16 - Ft Thomas/S Gate
Parking Information
  • Parking Features: Garage Faces Side: true
General Information
  • Parcel Number: 999-99-17-305.00
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Property Type: Residential


Building Information
  • Cooling: Central Air: true
  • Heating: Forced Air: true
Parking Information
  • Garage Spaces: 3.0
  • Garage: Yes
  • Bathrooms Full: 3
  • Bathrooms Half: 1
  • Bathrooms Total: 4
  • Bedrooms Total: 5
Building Interior
  • Fireplace Features: Wood Burning: true
  • Interior Features: Beamed Ceilings: true
  • Interior Features: Ceiling Fan: true
  • Interior Features: Open Floorplan: true
General Information
  • Appliances: Electric Range, Dishwasher, Microwave, Refrigerator
  • Fireplace Features: Stone, Wood Burning
  • Fireplace: Yes
  • Fireplaces Total: 3
  • Flooring: Carpet
  • Foundation Details: Poured Concrete
  • Interior Features: Wet Bar, Walk-In Closet(s), Storage, Pantry, Open Floorplan, Double Vanity, Chandelier, Built-in Features, Beamed Ceilings, Ceiling Fan(s), Intercom, Multi Panel Doors, Natural Woodwork
  • Laundry Features: Lower Level
  • Living Area: 3151.0
  • Rooms Total: 14


Parking Information
  • Parking Features: Driveway, Garage, Garage Faces Side
Lot Information
  • Additional Parcels Description: sale includes 444 & 408 River Road
  • Lot Features: Cleared, Creek, Cul-De-Sac, Rolling Slope, Steep Slope, Wooded
  • Lot Size Acres: 60.0
  • Lot Size Area: 60.0
  • Lot Size Dimensions: 60+Acres
  • Lot Size Square Feet: 973522.0
  • Lot Size Units: Acres
  • Water Source: Public
  • View: River, Trees/Woods
  • View: River: true
  • View: TreesWoods: true
Building Exterior/Construction
  • Attached Garage: No
  • Construction Materials: Brick
  • Patio And Porch Features: Covered, Patio, Porch
  • Property Attached: No
General Information
  • Exterior Features: Private Yard, Balcony
  • Other Structures: Barn(s)
  • Pool Features: In Ground
  • Road Frontage Type: City Street
  • Sewer: Public Sewer
  • Utilities: Natural Gas Available, Sewer Available, Water Available



41075 (Fort Thomas) Demographics
Median Age
Population Density (per sq. mile)
College Educated
Estimated Median Income
Estimated Total Home Owners
Estimated Total Renters
70% / 30%
Estimated Owner / Renter Divide
Estimated Average Household Size
Community data courtesy of LiveBy, Inc.


Elementary Schools
Johnson Elementary School
  • Grades: PK - 5
  • Enrollment: 399
Moyer Elementary School
  • Grades: PK - 5
  • Enrollment: 577
Woodfill Elementary School
  • Grades: KG - 5
  • Enrollment: 387
Middle Schools
Highlands Middle School
  • Grades: 6 - 8 /
  • Enrollment: 786
High Schools
Highlands High School
  • Grades: 9 - 12 /
  • Enrollment: 1,028
School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

Monthly Cost

$ %
* Assumes 7.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information.

Market Data

Based on the last 30 days in this zip code

Median Sales Price
Median Price per Square Foot
Properties Sold
New on Market
Average Days on Market
Properties for Sale
Calculations provided by Reliance Network


Date Event Value Agent
8/16/2023Source: Northern Kentucky MLS Price Reduction
$2,500,000 -13.8%
6/29/2023Source: Northern Kentucky MLS Status Change
6/13/2023Source: Northern Kentucky MLS Status Change
4/28/2023Source: Northern Kentucky MLS Added to Database
April 28, 2023