Water Views - Primary on Main
Address
2622 Twin Hills Court, Union, KY
Price
$ 949,900
Property Attributes
- MLS#645173
- TypeSingle Family
- Listing Status Active
- CountyBoone
- CityUnion
- AreaRichwd-Un-Wal-Ver-SB
- NeighborhoodRed Stone Village
- Zip41091
- StyleTransitional
- Year Built2007
- Price$ 949,900
- Bedrooms4
- Full Bathrooms4
- Half Bathrooms1
- Lot Size1.3 Acres
Data Source:
Northern Kentucky MLS (NKAR)
Property Description
Experience luxury living with breathtaking water and golf course views from this stunning custom home situated on 1.3 acres. Offering over 5,000 square feet of beautifully designed living space, this exceptional residence features 4 bedrooms, 4.5 baths, and an expansive open-concept floor plan ideal for both everyday living and entertaining. The first-floor primary suite provides a private retreat with pond views and dual walk-in closets. Architectural details abound, including cathedral ceilings, tray ceilings, built-in shelving, and multi-panel doors that flood the home with natural light. The gourmet kitchen is equipped with granite countertops, a gas cooktop, double ovens, and abundant workspace for the home chef. Multiple living areas are anchored by two fireplaces, creating warm and inviting gathering spaces. Step outside from either the kitchen or the walkout lower level to enjoy the hot tub overlooking the pond, where you can relax, take in the scenery, or fish right from your own backyard. New roof 2023, New hardwood floors, New Refrigerator and dishwasher, New paint, Upgraded landscaping and flower beds to name a few upgrades.
| Elementary School | Middle School | High School |
|---|---|---|
| New Haven Elementary Elementary School | Gray Middle School Middle School | Ryle High High School |
| Price History | |
|---|---|
| 7/30/2026 | Listed $949,900 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Natural Gas,Forced Air |
| Cooling | Zoned,Multi Units,Central Air |
| Utilities | Cable Available,Natural Gas Available |
| Roof | Shingle |
| HOA Fee | 640 |
| Garage Spaces | 3 |
| Patio/Porch Features | Deck,Patio,Porch |
| Architectural Style | Transitional |
| Security Features | Security System,Smoke Detector(s) |
| Construction Materials | Brick,Stone |
| Year Built | 2007 |
| Electric | 220 Volts |
| View | Lake,Pond,Valley |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Assoc Fee Paid Per | Annually |
| County | Boone |
| New Construction | false |
| Property Type | Residential |
| Association Amenities | Management |
| HOA | true |
| Attached Garage | false |
| Subdivision Name | Red Stone Village |
| Garage Y/N | true |
| Total Rooms | 15 |
| Status | Active |
| Directions | South on US 42, Right on Rice, Right on Crayton, R on Twin Hills |
| High School | Ryle High |
| City | Union |
| Zoning Description | Residential |
| MLS Area | K11 - Richwd/Un/Wal/Ver/SB |
| Lot Size Units | Acres |
| Lot Size Square Feet | 56453 |
| Elementary School | New Haven Elementary |
| Property Attached Y/N | false |
| Middle/Junior High School | Gray Middle School |
| Property Condition | Existing Structure |
| MLS Area Minor | K11 - Richwd/Un/Wal/Ver/SB |
| Virtual Tour | https://player.vimeo.com/video/1213935535 |
| Structure Type | House |
| Living Area Units | Square Feet |
| Standard Status | Active |
Interior Features
| Interior Amenities | Walk-In Closet(s),Storage,Pantry,Entrance Foyer,Double Vanity,Dry Bar,Crown Molding,Bookcases,Breakfast Bar,Built-in Features,Cathedral Ceiling(s),Ceiling Fan(s),High Ceilings,Multi Panel Doors,Recessed Lighting,Vaulted Ceiling(s),Master Downstairs |
|---|---|
| Basement | Full Finished Bath,Full,Finished,Storage Space,Walk-Out Access |
| Total Fireplaces | 1 |
| Fireplace Features | Gas,Marble |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Insulated Windows,Bay Window(s),Bow Window(s),Double Hung,Garden Window(s),Picture Window(s),Storm Window(s) |
| Fireplace Y/N | true |
| Laundry Features | Main Level |
| Total Baths | 5 |
Exterior Features
| Exterior Amenities | Hot Tub,Lighting |
|---|---|
| Fencing | Fenced,Metal,Partial |
| Parking Features | Driveway,Garage,Garage Door Opener,Garage Faces Side |
| Lot Features | Cleared,Level |
| Water Source | Public |
| Lot Size Area | 1.3 |
| Foundation Details | Poured Concrete |
| Lot Dimensions | 1.27 |
| Lot Size Acres | 1.3 |
| Road Surface Type | Paved |
| Lot Size Source | Realist |
| Door Features | French Doors |
| Road Frontage Type | City Street |
| Other Equipment | Humidifier |
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
Property vs Single Family Average in 41091
Price
Year Built
© 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.
