For Sale626d on market
150 Shamrock Ln
Fort Thomas, KY, 41075 • 41075 • Campbell County
$2,500,000
$793/sqft
-$400,000 since Aug 16, 2023
Down payment assistance available
5Beds
4Baths
3,151Sqft
60 acLot
1969Built
Property DNA
Waterfront Property
Creek
Scenic Views
River · Trees/Woods
Traditional Style
Built 1969 · 57 years of history
Outdoor Living
Covered · Patio · Porch
3 Fireplaces
Stone · Wood Burning
Barn(s)
Barn(s)
3-Car Garage
Driveway · Garage · Garage Faces Side
Premium Finishes
Walk-In Closet(s)
This home is getting attention
Listed 626 days ago · 3,592 views · 53 saves
Market activity
Demand and pricing signals for this listing
3,592 views
People checking out this listing
53 saves
Buyers have saved this home
626 days on market
Established listing
$793/sqft
Price per square foot
About this home
Single Family · Built 1969
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!
Standout features identified
Our analysis highlights huge recreation rooms, inground pool, and large barn as key attractions of this home.
Estimated monthly payment
Based on current rates
$16,305/month
Principal & Interest$12,972
Property Tax$2,500
Insurance$833
Down payment20% ($500,000)
3%50%
Est. 6.75% rate · 30yr fixed · $2,000,000 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence, Residential
Year Built1969
HeatingForced Air
CoolingCentral Air
Parking3 Garage spaces
Lot60 Acres
Days on Zillow626 Days
Price/sqft$793
Property
Home typeSingle Family
Sub-typeSingle Family Residence, Residential
StyleTraditional
ConditionExisting Structure
Year built1969
Stories2
Systems
HeatingForced Air
CoolingCentral Air
RoofAsphalt,Shingle
ConstructionBrick
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingDriveway, Garage, Garage Faces Side
Garage3 spaces
Fireplaces3
Lot60 Acres
Location & Tax
Neighborhood41075
Annual tax$2,855
Parcel999991730500
Bathrooms & Fees
Full baths3
Features & details
17 categories of property features
Interior Features
Interior
Wet Bar
Walk-In Closet(s)
Storage
Pantry
Open Floorplan
Double Vanity
Chandelier
Built-in Features
Beamed Ceilings
Ceiling Fan(s)
Natural Woodwork
Appliances
Electric Range
Dishwasher
Microwave
Refrigerator
Heating
Forced Air
Cooling
Central Air
Laundry
Lower Level
Fireplace
Stone
Wood Burning
Windows
Picture Window(s)
Exterior Features
Exterior
Private Yard
Balcony
Parking
Driveway
Garage
Garage Faces Side
Construction
Brick
Patio & Porch
Covered
Patio
Porch
Lot Features
Cleared
Cul-De-Sac
Rolling Slope
Steep Slope
Wooded
Views
River
Trees/Woods
Pool Features
In Ground
Utilities
Natural Gas Available
Sewer Available
Water Available
Other Equipment
Intercom
Other Structures
Barn(s)
Room details
15 rooms detailed
Primary Bedroom
First20×15 ft300 sqft
Bath AdjoinsWalk-In Closet(s)
Bedroom2
First12×10 ft120 sqft
Bedroom3
Second15×14 ft210 sqft
Walk-In Closet(s)
Bedroom4
Second15×12 ft180 sqft
Walk-In Closet(s)
Bedroom5
Second11×10 ft110 sqft
Walk-In Closet(s)
Other
Lower29×20 ft580 sqft
Closet(s)Walk-Out Access
Listing insights
Market data and value estimates
StatusFor Sale
Days on market626
Tax rate1.01%
Price/sqft$793
On marketJul 21, 2024
PostedJul 21, 2024
MLS updatedMar 31, 2026
Tour days9
Views3,592
Favorites53
How are the schools in Fort Thomas?
3 schools rated nearby
Location
Fort Thomas, KY, 41075
Price history
10 events
DateEventPrice$/sqftSource
Mar 31, 2026Listed For Sale$2,500,000$793NKMLS
Jan 22, 2026Pending Sale$2,500,000$793NKMLS
Jul 28, 2025Listed For Sale$2,500,000$793NKMLS
Jul 24, 2024Pending Sale$2,500,000$793NKMLS
Aug 16, 2023Price Change$2,500,000$793NKMLS
Jun 29, 2023Listed For Sale$2,900,000$920NKMLS
Jun 13, 2023Pending Sale$2,900,000$920NKMLS
Apr 28, 2023Listed For Sale$2,900,000$920NKMLS
Feb 14, 2023Listing Removed——Owner
Nov 16, 2022Listed For Sale$2,900,000$920Owner
Listed For Sale$2,500,000
Mar 31, 2026•$793/sqft•NKMLS
Pending Sale$2,500,000
Jan 22, 2026•$793/sqft•NKMLS
Listed For Sale$2,500,000
Jul 28, 2025•$793/sqft•NKMLS
Pending Sale$2,500,000
Jul 24, 2024•$793/sqft•NKMLS
Price Change$2,500,000
Aug 16, 2023•$793/sqft•NKMLS
Listed For Sale$2,900,000
Jun 29, 2023•$920/sqft•NKMLS
Pending Sale$2,900,000
Jun 13, 2023•$920/sqft•NKMLS
Listed For Sale$2,900,000
Apr 28, 2023•$920/sqft•NKMLS
Listing Removed—
Feb 14, 2023•Owner
Listed For Sale$2,900,000
Nov 16, 2022•$920/sqft•Owner
Tax history
22 years of records
YearTax paidAssessed value
Apr 9, 2023$2,855$722,700
Apr 9, 2022$2,927$722,700
Apr 9, 2021$2,043$490,000
Apr 9, 2018$2,072$490,000
Apr 9, 2017$2,142$490,000
Apr 9, 2016$2,102$490,000
Apr 9, 2015$2,102$490,000
Apr 9, 2014$2,053$490,000
Apr 9, 2013—$490,000
Apr 9, 2012—$490,000
Apr 9, 2011—$490,000
Apr 9, 2010—$490,000
Apr 9, 2009—$392,700
Apr 9, 2008—$392,700
Apr 9, 2007—$392,700
Apr 9, 2006—$392,700
Apr 9, 2005—$389,000
Apr 9, 2004—$389,000
Apr 9, 2003—$389,000
Apr 9, 2002$1,261$389,000
Apr 9, 2001—$284,230
Apr 9, 2000—$284,230
Nearby homes
Neighborhood details
Local context around this listing
Fort Thomas, KY • Campbell County
Nearby cities
AlexandriaBellevueCold SpringDaytonFort ThomasHighland HeightsMelbourneNewport
Nearby zip codes
41075
Similar homes
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Zillow, Inc. are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers. Listing information is deemed reliable, but not guaranteed. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
No obligation · Same-day response