Located in the highly desired neighborhood of Westbrook, this immaculate and well-cared for 4 bedroom, 3.5 bathroom Arlinghaus Mariemont floorplan offers a generous amount of space! This feels like a new home as you walk through. Gorgeous hardwood floors on the first floor, 9 ft ceilings, modern and large eat-in kitchen with walk-in pantry & mudroom from the garage entry. The second floor has a large, yet cozy loft space, generous-sized bedrooms all with walk-in closets, a convenient Jack and Jill bathroom between 2 bedrooms, and laundry room. The owner's suite includes a sitting area, vaulted ceilings, double sink and vanity, walk-in closet, shower, and soaker tub. Get ready for your summer plans of lounging by the new neighborhood pool and relaxing on your front porch that overlooks the quiet and lovely cul-de-sac street. Schedule your private showing today!
Sold for $539,900
Street View
$539,900
1904 Camelot Ct, Union, KY 41091
4beds
3,034sqft
Single Family Residence, Residential
Built in 2015
0.33 Acres Lot
$577,900 Zestimate®
$178/sqft
$3,272 Estimated rent
Home value
$577,900
$549,000 - $607,000
$3,272/mo
Zestimate® history
Owner options
List your home for rent
$3,272/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,272/mo
Rent Zestimate®
Refinance and save
$3,898/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,898/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Generous - sized bedroomsDouble sinkNew homeLaundry roomCozy loft spaceNew neighborhood poolFront porch
Zillow last checked:
Listing updated:
Listed by:
Carol Elliott 859-912-2065,
Huff Realty - Ft. Mitchell,
Linda Glover 859-341-7400,
Huff Realty - Ft. Mitchell
Bought with:
Jennifer Oney Hill, 190950
RE/MAX Victory + Affiliates
Source: NKMLS,MLS#: 622015
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins, Sitting Room, Ceiling Fan(s)
- Level: Second
- Area: 336
- Dimensions: 21 x 16
Bedroom 2
- Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 3
- Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins
- Level: Second
- Area: 156
- Dimensions: 13 x 12
Bedroom 4
- Features: Carpet Flooring, Walk-In Closet(s)
- Level: Second
- Area: 143
- Dimensions: 13 x 11
Other
- Features: Wood Flooring
- Level: First
- Area: 132
- Dimensions: 12 x 11
Family room
- Features: Fireplace(s), Carpet Flooring, Wood Flooring, Window Treatments
- Level: First
- Area: 323
- Dimensions: 19 x 17
Kitchen
- Features: Walk-Out Access, Wood Flooring, Kitchen Island, Eat-in Kitchen, Pantry, Wood Cabinets, Recessed Lighting
- Level: First
- Area: 360
- Dimensions: 24 x 15
Loft
- Features: Carpet Flooring
- Level: Second
- Area: 168
- Dimensions: 14 x 12
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Stainless Steel Appliance(s), Electric Oven, Electric Range, Dishwasher, Disposal, Microwave, Refrigerator, Tankless Water Heater
- Laundry: Electric Dryer Hookup, Laundry Room, Upper Level, Washer Hookup
Features
- Kitchen Island, Walk-In Closet(s), Pantry, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Bookcases, Ceiling Fan(s), High Ceilings, Recessed Lighting
- Windows: Vinyl Frames
- Basement: Full
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 3,034
- Total interior livable area: 3,034 sqft
Property
Parking
- Total spaces: 3
- Parking features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front, Garage Faces Side, Off Street
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Patio
- Has view: Yes
- View description: Neighborhood
Lot
- Size: 0.33 Acres
- Features: Cul-De-Sac
Details
- Parcel number: 051.0013015.00
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Brick, Stone, Vinyl Siding
- Foundation: Poured Concrete
- Roof: Shingle
Condition
- Existing Structure
- New construction: No
- Year built: 2015
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Natural Gas Available, Sewer Available, Water Available
Community & HOA
Community
- Security: Smoke Detector(s)
HOA
- Has HOA: Yes
- Amenities included: See Remarks, Landscaping, Lake Year Round, Pool
- Services included: See Remarks, Maintenance Grounds, Snow Removal
- HOA fee: $600 annually
Location
- Region: Union
Financial & listing details
- Price per square foot: $178/sqft
- Tax assessed value: $460,000
- Annual tax amount: $5,128
- Date on market: 10/20/2025
- Cumulative days on market: 44 days
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 5/28/2024 | Sold | $539,900$178/sqft |
Source:  NKMLS #622015 Report a problem | ||
| 4/18/2024 | Pending sale | $539,900$178/sqft |
Source: NKMLS #622015 Report a problem | ||
| 4/16/2024 | Listed for sale | $539,900$178/sqft |
Source: NKMLS #622015 Report a problem | ||
| 4/11/2024 | Listing removed | $539,900$178/sqft |
Source:  Huff Realty #620745 Report a problem | ||
| 3/15/2024 | Price change | $539,900-1.8%$178/sqft |
Source: NKMLS #620745 Report a problem | ||
| 2/27/2024 | Listed for sale | $549,900+19.5%$181/sqft |
Source: NKMLS #620745 Report a problem | ||
| 9/22/2021 | Sold | $460,000+2.2%$152/sqft |
Source: Public Record Report a problem | ||
| 7/16/2021 | Pending sale | $450,000$148/sqft |
Source: NKMLS #550694 Report a problem | ||
| 7/12/2021 | Listed for sale | $450,000+32.5%$148/sqft |
Source: NKMLS #550694 Report a problem | ||
| 6/1/2015 | Sold | $339,750$112/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $5,128 -3.4% | $460,000 |
| 2023 | $5,310 +2.8% | $460,000 |
| 2022 | $5,164 +35.1% | $460,000 +35.4% |
| 2021 | $3,822 -3.6% | $339,750 |
| 2020 | $3,964 | $339,750 |
| 2019 | $3,964 +0.3% | $339,750 |
| 2018 | $3,952 +1.9% | $339,750 |
| 2017 | $3,877 | $339,750 +661.1% |
| 2015 | $3,877 +685.2% | $44,640 |
| 2013 | $494 | $44,640 |
| 2012 | -- | $44,640 |
| 2011 | -- | $44,640 |
Find assessor info on the county website
Neighborhood: 41091
Nearby homes
- $496,1004 bd2 ba2.8k sqft1908 Camelot Ct, Union, KY 41091Off Market
- $519,3004 bd3 ba1.9k sqft1900 Camelot Ct, Union, KY 41091Off Market
- $502,5004 bd3 ba2.9k sqft1912 Camelot Ct, Union, KY 41091Off Market
- $624,2004 bd3 ba3.6k sqft9489 Rainbow Ter, Union, KY 41091Off Market
- $642,1004 bd4 ba2.9k sqft9501 Rainbow Ter, Union, KY 41091Off Market
- $465,8003 bd3 ba1.7k sqft1905 Camelot Ct, Union, KY 41091Off Market
- $513,9004 bd3 ba2k sqft1909 Camelot Ct, Union, KY 41091Off Market
- $530,1004 bd3 ba1.8k sqft1901 Camelot Ct, Union, KY 41091Off Market
Nearby schools
GreatSchools rating
- 8/10Erpenbeck Elementary SchoolGrades: PK-5Distance: 1.3 mi
- 6/10Ballyshannon Middle SchoolGrades: 6-8Distance: 1.1 mi
- 8/10Randall K. Cooper High SchoolGrades: 9-12Distance: 2.1 mi
Schools provided by the listing agent
- Elementary: Erpenbeck Elementary
- Middle: Ballyshannon Middle School
- High: Cooper High School
Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$577,900
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$577,900
- Kentucky
- Boone County
- Union
- 41091
- 1904 Camelot Ct
Nearby cities
Nearby zip codes
Other Union Topics
