Seller's Agent in 2022
Andrea Destefano
Sibcy Cline
(513) 309-3184
9 in this area
345 Total Sales
Estimated Value: $2,218,000 - $2,349,000
5
Beds
4.5
Baths
5,669
Sq Ft
$399/Sq Ft
Est. Value
Highlights
- Lake View
- Fireplace in Primary Bedroom
- Transitional Architecture
- Mason Intermediate Elementary School Rated A
- Deck
- Wood Flooring
About This Home
As of September 2022High end living on the exclusive Long Cove waterway!Former HOMEARMA by Robert Lucke Homes!Over 8600sq.ft!!Unique ceiling designs & one of a kind spiral staircase!2 Offices!High-End Thermador Appliances in the STUNNING white Kitchen!2 Laundry Rms!1st FLR Primary bdrm w/ sitting area & walks out to hot tub!LL:Rec Rm,Exercise,Full Kitchen w/Serving area,2nd Office,BDRM & Oversized Bar!Outdoor entertainers dream with covered porch & views of the water way in every room!*Deerfield Twp*No Earnings Tax
Last Agent to Sell the Property
Sibcy Cline, Inc. License #2002005515 Listed on: 07/29/2022
Co-Listed By
Linda deStefano
Sibcy Cline, Inc. License #2019001103
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $25,282
Year Built
- Built in 2005
Lot Details
- 0.57 Acre Lot
- Cul-De-Sac
- Sprinkler System
HOA Fees
- $246 Monthly HOA Fees
Parking
- 3 Car Attached Garage
- Side Facing Garage
- Driveway
- On-Street Parking
Property Views
- Lake
- Pond
Home Design
- Transitional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Stone
Interior Spaces
- 2-Story Property
- Crown Molding
- Beamed Ceilings
- High Ceiling
- Marble Fireplace
- Gas Fireplace
- Insulated Windows
- Window Treatments
- Wood Frame Window
- Casement Windows
- French Doors
- Sliding Doors
- Entryway
- Family Room with Fireplace
- 2 Fireplaces
- Great Room with Fireplace
- Breakfast Room
- Dining Room
- Home Office
- Library
- Game Room
- Wood Flooring
- Home Security System
Kitchen
- Eat-In Kitchen
- Double Oven
- Gas Cooktop
- Microwave
- Dishwasher
- Wine Cooler
- Granite Countertops
- Disposal
Bedrooms and Bathrooms
- 5 Bedrooms
- Fireplace in Primary Bedroom
Laundry
- Laundry Room
- Dryer
- Washer
Finished Basement
- Basement Fills Entire Space Under The House
- Sump Pump
Outdoor Features
- Deck
- Enclosed Patio or Porch
- Built-In Barbecue
Utilities
- Humidifier
- 95% Forced Air Zoned Heating and Cooling System
- Heating System Uses Natural Gas
- Gas Water Heater
- Water Softener
Community Details
- Association fees include pool, water, clubhouse, playground
- Long Cove Subdivision
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Feb 14, 2023
Sold by
Gill Baljit Singh and Gill Priya
Bought by
Gill Baljit Singh and Gill Priya
Current Estimated Value
Purchase Details
Listed on
Jul 29, 2022
Closed on
Sep 26, 2022
Sold by
Shehata Wagih M and Shehata Sonia W
Bought by
Singh Gill Baljit
Seller's Agent
Andrea Destefano
Sibcy Cline, Inc.
Buyer's Agent
Rose Nassar
Plum Tree Realty
List Price
$2,100,000
Sold Price
$1,950,000
Premium/Discount to List
-$150,000
-7.14%
Views
30
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.44%
Purchase Details
Closed on
Mar 6, 2020
Sold by
Shehata Sonia W and Shehata Wagih M
Bought by
Shehata Wagih M and Shehata Sonia W
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$452,000
Interest Rate
3.37%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 17, 2005
Sold by
Robert Lucke Homes Inc
Bought by
Shehata Sonia W
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,280,000
Interest Rate
5.37%
Mortgage Type
Fannie Mae Freddie Mac
Purchase Details
Closed on
Dec 7, 2004
Sold by
Long Cove Llc
Bought by
Robert Lucke Homes Inc
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Gill Baljit Singh | -- | None Listed On Document | |
| Singh Gill Baljit | $1,950,000 | -- | |
| Shehata Wagih M | -- | None Available | |
| Shehata Sonia W | $1,625,000 | First Assurance Title Agency | |
| Robert Lucke Homes Inc | $245,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Shehata Wagih M | $452,000 | |
| Previous Owner | Shehata Sonia W | $1,280,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 09/26/2022 09/26/22 | Sold | $1,950,000 | -1.3% | $344 / Sq Ft |
| 09/01/2022 09/01/22 | Pending | -- | -- | -- |
| 08/23/2022 08/23/22 | Price Changed | $1,975,000 | -6.0% | $348 / Sq Ft |
| 07/29/2022 07/29/22 | For Sale | $2,100,000 | -- | $370 / Sq Ft |
Source: MLS of Greater Cincinnati (CincyMLS)
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $28,073 | $658,710 | $126,000 | $532,710 |
| 2024 | $28,073 | $658,710 | $126,000 | $532,710 |
| 2023 | $27,081 | $523,736 | $129,780 | $393,956 |
| 2022 | $26,586 | $523,737 | $129,780 | $393,957 |
| 2021 | $25,282 | $523,737 | $129,780 | $393,957 |
| 2020 | $28,937 | $508,484 | $126,000 | $382,484 |
| 2019 | $27,559 | $508,484 | $126,000 | $382,484 |
| 2018 | $27,606 | $508,484 | $126,000 | $382,484 |
| 2017 | $27,613 | $468,115 | $105,574 | $362,541 |
| 2016 | $28,428 | $468,115 | $105,574 | $362,541 |
| 2015 | $27,918 | $468,115 | $105,574 | $362,541 |
| 2014 | $27,918 | $445,820 | $100,550 | $345,280 |
| 2013 | $27,978 | $558,670 | $126,000 | $432,670 |
Source: Public Records
Agents Affiliated with this Home
-
Andrea Destefano
-
L
Seller Co-Listing Agent in 2022
Linda deStefano
Sibcy Cline
-
Rose Nassar
Buyer's Agent in 2022
Rose Nassar
Plum Tree Realty
(513) 288-6629
2 in this area
105 Total Sales
Map
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1748230
APN: 16-33-400-037
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Nearby Homes
- 5576 Winding Cape Way
- 5369 N Shore Place
- 9018 Boylston St
- 9024 Beacon St
- 9240 Beacon St
- 9246 Beacon St
- 5449 Old Farm Dr
- 5434 Old Farm Dr
- 5686 Farm Field Dr
- 5850 Homecrest Ln
- 6285 Greenwood Ct
- 6315 Greenwood Ct
- 9867 Kensington Ln
- 8588 Charleston Creek Dr
- 9907 Kensington Ln
- 12173 Crestfield Ct
- 12168 Crestfield Ct
- 6304 Trailwood Ct
- 4796 White Blossom Blvd
- 4390 S Mallard Cove
- 8667 Hampton Bay Place
- 8675 Hampton Bay Place
- 8663 Hampton Bay Place
- 8670 Hampton Bay Place
- 8679 Hampton Bay Place
- 8674 Hampton Bay Place
- 8668 Emerald Isle
- 8664 Hampton Bay Place
- 8672 Emerald Isle
- 8678 Hampton Bay Place
- 8664 Emerald Isle
- 8655 Hampton Bay Place
- 8662 Hampton Bay Place
- 8676 Emerald Isle
- 5606 Winding Cape Way
- 15 Emerald Isle
- L Emerald Isle
- 8660 Emerald Isle
- 8658 Hampton Bay Place
- 8653 Hampton Bay Place
Your Personal Tour Guide
Ask me questions while you tour the home.