Property Attributes
- MLS#644756
- TypeSingle Family
- Listing Status Active
- CountyKenton
- CityCrestview Hills
- AreaLakes PK,FT Mt-CrstvHill-Edgewd
- NeighborhoodCollege Park
- Zip41017
- StyleTraditional
- Price$ 430,000
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms1
- Sqr Footage4694
- Lot Size0.59 Acres
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
A truly one-of-a-kind home, inside and out! This 4-bedroom, 3.5-bath property is situated on .59 acres at the end of a quiet cul-de-sac and offers a private yard, generous living spaces, and endless potential for a buyer ready to add their own finishing touches. The standout feature is the massive addition at the rear of the home, which nearly doubles the home's square footage and creates a spectacular two-story greenhouse-style living space. Fully enclosed and conditioned, this dramatic indoor space is unlike anything else you will find in Northern Kentucky and offers countless possibilities for entertaining, gardening, a studio, recreation area, or a truly unique year-round retreat. Located in the heart of Crestview Hills, this home is close to shopping, outdoor concerts, hospitals, dining, and everyday conveniences. With its private setting, spacious lot, flexible floor plan, great bones, and unforgettable architectural addition, this property is ready to be transformed into a remarkable custom home.
| Elementary School | Middle School | High School |
|---|---|---|
| JA Caywood Elementary Elementary School | Turkey Foot Middle School Middle School | Dixie Heights High High School |
| Price History | |
|---|---|
| 7/17/2026 | Listed $460,000 |
| 8/12/2026 | 3$445,000 |
| 9/1/2026 | 3$430,000 |
General Features
| Living Area | 4694 |
|---|---|
| Sewer | Public Sewer |
| Heating | Forced Air |
| Cooling | Central Air |
| Utilities | Natural Gas Available |
| Roof | Shingle |
| Garage Spaces | 2 |
| Patio/Porch Features | Covered,Deck,Enclosed,Patio,Porch |
| Architectural Style | Traditional |
| Security Features | Smoke Detector(s) |
| Construction Materials | Vertical Siding,Brick,Wood Siding |
| View | Trees/Woods |
| Levels | Two |
| Property Subtype | Single Family Residence |
| County | Kenton |
| New Construction | false |
| Property Type | Residential |
| HOA | false |
| Attached Garage | true |
| Subdivision Name | College Park |
| Garage Y/N | true |
| Other Structures | Shed(s) |
| Total Rooms | 16 |
| Status | Active |
| Directions | Turkeyfoot Rd to College Park Dr. Right on University Circle to Cul-de-Sac. |
| High School | Dixie Heights High |
| City | Crestview Hills |
| MLS Area | K08 - Lakes PK,FT Mt/CrstvHill/Edgewd |
| Lot Size Units | Acres |
| Lot Size Square Feet | 25635 |
| Elementary School | JA Caywood Elementary |
| Property Attached Y/N | false |
| Middle/Junior High School | Turkey Foot Middle School |
| Property Condition | Existing Structure |
| MLS Area Minor | K08 - Lakes PK,FT Mt/CrstvHill/Edgewd |
| Standard Status | Active |
Interior Features
| Interior Amenities | Walk-In Closet(s),Track Lighting,Tile Counters,Open Floorplan,Eat-in Kitchen,Crown Molding,Chandelier,Built-in Features,High Ceilings,Recessed Lighting |
|---|---|
| Basement | Full Bath Rough In,Finished,Storage Space,Unfinished |
| Total Fireplaces | 2 |
| Fireplace Features | Brick |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Aluminum Frames,Vinyl Frames |
| Fireplace Y/N | true |
| Laundry Features | Lower Level,Main Level |
| Total Baths | 4 |
Exterior Features
| Exterior Amenities | Private Yard |
|---|---|
| Fencing | Wood |
| Parking Features | Attached,Driveway,Garage |
| Lot Features | Cul-De-Sac,Sloped |
| Water Source | Public |
| Lot Size Area | 0.59 |
| Foundation Details | Concrete Perimeter |
| Building Area Total | 4694 |
| Lot Size Acres | 0.59 |
| Lot Size Source | Other |
| Door Features | French Doors,Sliding Doors |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
© 2026 Dayton Area Board of Realtors. All rights reserved. Information deemed to be reliable but not guaranteed. The data relating to real estate for sale on this website comes from Dayton Area Board of Realtors and the Broker Reciprocity Program.sm. Real estate listings held by brokerage firms other than Comey & Shepherd, REALTORS are marked with the BR logo and detailed information about them includes the name of the listing brokers. Listing broker has attempted to offer accurate data, but
The data relating to real estate for sale on this web site comes
in part from the Broker Reciprocity™ program of the Multiple
Listing Service of Greater Cincinnati. Real estate listings held by
brokerage firms other than Comey & Shepherd, REALTORS are marked with the MLS ™ logo
(the small logo to the left) and detailed information about them includes
the name of the listing brokers. The information herein is furnished by the property owner in
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawl. Neither listing broker(s) nor SE IN BD REALTORS shall be held responsible for typographical errors, misinformation, misprints and shall be held totally harmless.