Coldwell Banker Home Page
Skip to main contentColdwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Realty
Property view
Listing view 2
Listing view 3

174 Shaker Heights Lane, 
Crestview Hills, KY 41017

$274,900

3

Beds

3

Baths

1,320

Sq Ft

Condo

Active

Listed by

Mary Lou Calvert

Sibcy Cline, Realtors-Florence

Last updated:

January 17, 2026, 11:36 AM

MLS#

638792

Source:

KY NKMLS

About This Home

174 Shaker Heights Lane

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!

Home Facts

Condo

3 Baths

3 Bedrooms

Price Summary

274,900

$208 per Sq. Ft.

MLS #:

638792

Last Updated:

January 17, 2026, 11:36 AM

Added:

25 day(s) ago

Rooms & Interior

Bedrooms

Total Bedrooms:

3

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

1

Interior

Living Area:

1,320 Sq. Ft.

Structure

Structure

Architectural Style:

Traditional

Building Area:

1,320 Sq. Ft.

Lot

Lot Size (Sq. Ft):

1,216

Finances & Disclosures

Finances

Price:

$274,900

Price per Sq. Ft:

$208 per Sq. Ft.

Source:KY NKMLS
Information Deemed Reliable but Not Guaranteed. 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 Coldwell Banker Realty 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. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, 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 a Coldwell Banker affiliated agent 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®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, 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 a Coldwell Banker affiliated agent 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®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.