Skip To Content

174 Shaker Heights Lane

Crestview Hills, KY 41017
  • $279,900
  • STATUS: Active
  • ON SITE: 24 Days
  • MLS #: 638076
UPDATED: 55 min ago
$279,900
  • 3
    BEDS
  • 0.03
    ACRES
  • 1
    BATHS
  • 2
    1/2 BATHS

School Information

Elementary School:
Middle School:
High School:
School District:

Description

This gem awaits you! Three finished levels, 3 bedroom landominum in exceptionally convenient Lookout Farms. You'll love the new updates this units provide. Entirely renovated kitchen with granite, tons of cabinets, flooring, lighting etc. Master bath remodel includes all new tile, cabinets and fixtures. Additionally, this upgraded unit has new windows, doors and newer HVAC and roof, making maintenance issues less a concern. First floor electric fireplace adds warm ambiance to the wooded view and an additional wood burning fireplace in lower level with walkout to patio and private green space. HOA includes pool, clubhouse, walking trails and tennis courts. The Coveted Lookout Farms location with easy access to expressways, Towne Center, airport makes this an even more appealing place to call home!

Monthly Payment Calculator



Northern Kentucky MLS logo © 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2025-12-13T16:24:18.833.
www.jimsimpsonrealtors.com/homes/170043624
Print Image

174 Shaker Heights Lane Crestview Hills, KY 41017

  • Price: $279,900
  • Status: Active
  • On Site: 24 Days
  • Updated: 55 min ago
  • MLS #: 638076
3
Beds
1
Baths
2
½ Baths
0.03
Acres
Neighborhood:
Lakes Pk,Ft Mt/Crstvhill/Edgewd
County:
Kenton
Area:
Lakes Pk,Ft Mt/Crstvhill/Edgewd
Elementary School:
Ja Caywood Elementary
Middle School:
Turkey Foot Middle School
High School:
Dixie Heights High
School District:
Kenton Co Public
Property Description
This gem awaits you! Three finished levels, 3 bedroom landominum in exceptionally convenient Lookout Farms. You'll love the new updates this units provide. Entirely renovated kitchen with granite, tons of cabinets, flooring, lighting etc. Master bath remodel includes all new tile, cabinets and fixtures. Additionally, this upgraded unit has new windows, doors and newer HVAC and roof, making maintenance issues less a concern. First floor electric fireplace adds warm ambiance to the wooded view and an additional wood burning fireplace in lower level with walkout to patio and private green space. HOA includes pool, clubhouse, walking trails and tennis courts. The Coveted Lookout Farms location with easy access to expressways, Towne Center, airport makes this an even more appealing place to call home!
Exterior Features

Architectural Style Traditional Attached Garage YN Yes Construction Materials Aluminum SidingBrick Exterior Features Other Foundation Details Poured Concrete Garage YN Yes Levels Three Or More Parking Features AttachedDrivewayGarageGarage Door OpenerGarage Faces Front Patio And Porch Features DeckPatio Pool Features In Ground Roof Shingle View Trees/Woods View YN Yes

Interior Features

Appliances Electric RangeDishwasherDisposalMicrowave Basement Half Bath Rough InFireplace(s)FinishedWalk-Out Access Cooling Central Air Cooling YN Yes Entry Level 1 Fireplace Features CeramicWood Burning Fireplace YN Yes Fireplaces Total 1 Heating Natural GasForced Air Heating YN Yes Interior Features Entrance FoyerChandelierCeiling Fan(s)Recessed LightingWet Bar Living Area 1320 Rooms Total 7 Window Features Insulated Windows

Property Features

Association Amenities PoolTennis Court(s)ClubhouseTrail(s) Association Fee 332 Association Fee Frequency Monthly Association Fee Includes Association FeesMaintenance GroundsMaintenance StructureManagementSnow Removal Association YN Yes Lot Size Dimensions Of Record New Construction YN No Pets Allowed Call Property Attached YN Yes Property Class Residential Property Condition Existing Structure Property Sub Type Condominium Sewer Private Sewer Utilities Cable Available Water Source Public

Northern Kentucky MLS logo Courtesy of Sibcy Cline, REALTORS-Florence: 859-525-8888. © 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. Information has not been verified, is not guaranteed, and subject to change.


Northern Kentucky MLS logo © 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Northern Kentucky Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Jim Simpson Realtors Inc are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. All data provided is copyrighted by the Northern Kentucky Multiple Listing Service, Inc. Its use is strictly for consumers of real estate and may only be displayed on the internet by participating members of the Northern Kentucky Multiple Listing Service. All attempts to illegally reproduce or host this data will be prosecuted to the fullest extent of the law. Data last updated: 2025-12-13T16:24:18.833.
 
https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_3_638076-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_3_638076-2.jpg https://bt-photos.global.ssl.fastly.net/nkmls/1280_boomver_3_638076-2.jpg
Logo
Jim Simpson Realtors Inc
39 Broadway
Dry Ridge KY, 41035