x
Showing 1 of 0
X
Save

123 Lookout Farm Drive
Crestview Hills KY 41017 US

$420,000

Active Listing ID 633846
bed icon
4 bed
bath icon
4.00 Bath (3 Full , 1 Half)
lot icon
Lot: 0.23 Acres
home icon
Single Family Residence

$420,000

Active Listing ID 633846
Save

123 Lookout Farm Drive Gorgeous brick home in the highly desired Lookout Farm Community. Enjoy all this home has to offer including: quartz counters, stainless steel appliances, gas range, open concept kitchen/living room, hardwood flooring, 3 finished levels, wood burning fireplace, basement walk-out, front porch, composite deck, wooded view, and large usable yard. Roof=2020. HVAC=2022. Water heater= 2023. Extremely convenient location and many great community amenities. Don't miss out on this one!

Collapse all

Property Features

  • Facts
  • Lot Size: 0.23 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Exterior Finish: Deck, Porch
  • Roof Type: Shingle
  • Heating Fuels: Fireplace(s), Forced Air
  • Additional Features
  • Fireplace
  • Patio

School Information

  • School
  • JA Caywood Elementary(Elementary)
  • Turkey Foot Middle School(MiddleSchool)
  • Dixie Heights High(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 420000
  • unparsedaddress: 123 Lookout Farm Drive
  • postalcity: Crestview Hills
  • stateorprovince: KY
  • country: US
  • postalcode: 41017
  • bathroomsfull: 3
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.23
  • lotsizeunits: Acres
  • lotsizearea: 0.23
  • livingarea: 0
  • livingareaunits: Square Feet
  • latitude: 39.032701
  • longitude: -84.577039
  • listagentfullname: The Brock Hart Home Group
  • listagentemail: BrockHartRealtor@gmail.com
  • listagentkey: 3yd-NKARKY-444411190
  • listagentmlsid: 444411190
  • listagentpreferredphone: 8594967596
  • listagentofficephone: 8592400727
  • listofficekey: 3yd-NKARKY-o432501236
  • listofficemlsid: o432501236
  • disclaimer: Copyright © 2025 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: NKARKY
  • yearbuilt: 1980
  • listingcontractdate: 2025-06-27
  • listagenturl: http://www.sellingnorthernkentucky.com
  • countyorparish: Kenton
  • parcelnumber: 014-40-00-203.00
  • elementaryschool: JA Caywood Elementary
  • highschool: Dixie Heights High
  • elementaryschooldistrict: Kenton Co Public
  • middleorjuniorschooldistrict: Kenton Co Public
  • highschooldistrict: Kenton Co Public
  • appliances: Dishwasher, Microwave, Range, Range - Gas, Refrigerator, Washer
  • cooling: Central Air
  • constructionmaterials: Brick
  • heating: Fireplace(s), Forced Air
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: Driveway, Garage, Off Street
  • roof: Shingle
  • waterfrontyn: False
  • franchiseaffiliation: Keller Williams Realty
  • exteriorfeatures: Deck, Porch
  • architecturalstyle: New Traditional
  • rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Family Room, Game Room, Kitchen, Living Room, Loft
  • patioandporchfeatures: Porch, Deck
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -84.57704, 39.0327
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Keller Williams Realty Services", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":"Monthly", "ExpenseValue":83}], "GeocodeOptions":null, "LeadRoutingEmail":"BrockHartRealtor@gmail.com", "ListBrokerageCity":"Florence", "ListBrokerageCountry":"US", "ListBrokerageEmail":"klrw866@kw.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/NKARKY/fa219a916a6d11dfb4ac00219b994c72/20100614164901720.png", "ListBrokerageName":"Keller Williams Realty Services", "ListBrokeragePhone":"(859) 240-0727", "ListBrokeragePostalCode":"41042", "ListBrokerageStateOrProvince":"KY", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"7210 Turfway Rd", "ListBrokerageWebsiteUrl":"http://www.sellingnorthernkentucky.com", "ListOfficeAddress1":"7210 Turfway Rd", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"432508281", "ListOfficeCity":"Florence", "ListOfficeCountry":"US", "ListOfficeEmail":"mrottinghaus@kw.com", "ListOfficePostalCode":"41042", "ListOfficeStateOrProvince":"KY", "ListPriceCurrencyType":"USD", "ListingTitle":"Single Family Residence, Traditional - Crestview Hills, KY", "ListingURL":"https://listings.listhub.net/pages/NKARKY/633846/?channel=rexren", "MLSModificationTimestamp":null, "Neighborhoods":[{"Description":null, "Name":"K08 - Lakes PK"}, {"Description":null, "Name":"FT Mt/CrstvHill/Edgewd"}], "PostalCode":null, "RawPropertySubType":"Single Family Residence", "RawPropertyType":"Residential", "RoomCount":11, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 8/1/2025 12:01:38 AM GMT
Source Updated Date: 12/5/2025 6:45:57 AM GMT

Courtesy of: The Brock Hart Home Group, Keller Williams Realty Services, BrockHartRealtor@gmail.com

Copyright © 2025 Northern Kentucky MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.