Available Listings

$15,000,000
Active

N/A Area Single Family Home

Active

50 Compo Mill Cove Westport, CT 06880

5 Bed
7 Baths
3955 sqft
MLS# 24068879
WATERFRONT PARADISE! Tranquil location offers unrivaled access to Panoramic Ocean views of Long Island Sound. A short walk across the Wooden Footbridge w/ Sherwood Mill Pond on your left and LI Sound on your right leads to the gated private Island of Compo Mill Cove & a handful of unique waterfront homes. The property itself has been customized from top to bottom w/ exceptional thought & detail. Only house on the Cove w/ a secure, storm surge concrete wall. Featuring over 3950 sq ft of living space, 5 beds, 5.2 baths, an open floor plan w/ wall to wall windows that offer 180 degree views of the ocean from every room. First fl features a living room w/ fireplace, family room, beautifully appointed wet bar, dining area, & gourmet kitchen w/ exclusive granite, Viking appliances, modern design, & a first fl bedroom w/ ensuite bath. Upstairs offers 3 additional bedrooms including a primary w/ a fireplace, private balcony w/ outdoor fireplace, & bathroom w/ sauna shower, tub, & double vanity. The highest quality materials were used in every corner of the home, from beautiful marble to custom imported Italian sici tiles, to state of the art electronic & digital components that can be used from within the home or remotely no detail was overlooked. Outdoors is equally as impressive w/ an infinity pool, outdoor kitchen, shower, bathroom, terrace w/ fireplace, & impeccable landscaping that sit behind a gated, secure stone wall border. Just 1 hr from NYC
Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Robert Perriello
$4,100,000
Active

Durham Area Farm

Active

148 &Amp 153 Wallingford Road Durham, CT 06422

Bed
0 Baths
0 sqft
MLS# 24015202
Virtual Tour
The Greenbacker Brookfield is one of the largest farms now on the Connecticut market with over 400 acres. It has been in operation for over 100 years and is ready now for a new multi-generation family to take the reins or for a progressive investor. There is ample accommodation with 7 houses that have 29 bedrooms for the family to share. (The average size farm in CT is approximately 80 acres). The current owners are using 4 houses and renting 3 other homes. The investor agriculture buyer may also generate rental income from the farm's other rental property; 1. a Two story 35x50 horse barn, 2.a 35x80 stable with 1.5 story horse stalls. 3 a. Barn with double row stalls and indoor riding arena, 4. a 4-bay garage, 5. Dairy barn, and Chicken coops, etc.. These items may also be considered depreciable property (see your tax advisor). Other sources of income from the farm would include renting land for; 1, growing crops (92 acres of cropland leased, currently), 2, Durham Fair parking. 3, pastureland (20 acres of pasture leased, currently), 4, hunt club (land leased currently), 5, equestrian rental (stable & indoor/outdoor riding, currently leased) and for dairy farming. Potential income may come from establishing a farm stand, growing grapes/ winery, Christmas tree sales, blue berries, and more. The State of Connecticut Conservation Restriction requires this property to be 'agriculture in nature' according to development rights the state acquired approximately 70 years ag
Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Gary Dobratz
$3,550,000
Active

N/A Area Commercial

Active

273 Asylum Street Hartford, CT 06103

Bed
0 Baths
35277 sqft
MLS# 24066970
Virtual Tour
Welcome to an unparalleled opportunity in the heart of downtown Hartford-an exceptional chance to spearhead the development of a residential haven in an enviable location! Embraced by the city's vibrant pulse, this former high school site stands primed for transformation, boasting approved plans for a residential complex featuring 50 units. Among these are 22 studios, 11 studio pluses offering enhanced living space, and 17 one-bedroom apartments. With the City of Hartford's seal of approval, this canvas of possibility awaits the visionary buyer seeking to redefine urban living. Commanding impressive market rents of $1,400 for studios and $1,700 for one-bedroom dwellings, the potential for lucrative returns is undeniable. Furthermore, there is opportunity to include a small parking area nearby with the purchase. Situated at the center of downtown's bustling landscape, this property offers unrivaled proximity to iconic landmarks and entertainment venues. Just a stone's throw away from the XL Center and a mere two blocks from Bushnell Park and City Place, residents will revel in a lifestyle of convenience and excitement. Immerse yourself in the cultural tapestry of the city with TheaterWorks mere steps away, while an array of esteemed dining establishments and nightlife hotspots beckon within walking distance, including Black Eyed Sally's, Agave, and Max Downtown. Easy access to major thoroughfares including I-91, I-84, and Route 2 makes commuting effortless.
Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Lisa Cozzi
$3,250,000
Active

Destin Area Single Family Home

Active

514 Vera Cruz Drive Destin, FL 32541

6 Bed
6 Baths
3750 sqft
MLS# 964803
Nestled in the highly desirable area of Holiday Isle. This exceptional waterfront beach home offers the perfect blend of coastal living and modern convenience. Situated just one block from the beach with Gulf views and directly on a deep-water canal, this home is truly a rare find. What sets this property apart is its unique features, including a fully covered and enclosed outdoor entertainment area with observation deck and two covered boat slips with lifts, and an impressive 90 feet of deep-water frontage. The home boasts two separate living areas (2nd Level - Main Level and 3rd Level Lockout) each with their own private entrances totaling six spacious bedrooms, six full bathrooms and two fully equipped kitchens, providing ample room for family & guests. The main floor is comprised of 4 spacious bedrooms and 4 baths, large living area, gourmet kitchen with breakfast bar and an office. The 3rd Level Lockout is comprised of 2 bedrooms with 2 full baths, living area, kitchen with breakfast bar. These two living areas can be utilized together or kept separate. Additionally, the lower level offers 2,500 square feet of unfinished space, perfect for storage, work area or customized to suit your needs. With its prime location, you're only eight houses away from the private beach access of Holiday Isle and a 15-minute boat ride to Crab Island or the Gulf of Mexico. Whether you're seeking a luxurious permanent residence or a lucrative investment property, this home delivers on all fronts. Embrace the best of waterfront living in this stunning Holiday Isle retreat. Short term rentals are allowed. Rental projections are $150,000 - $175,000.
Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Ken Koger
$2,800,000
Active

Durham Center Area Single Family Home

Active

153 Wallingford Road Durham, CT 06422

15 Bed
8 Baths
0 sqft
MLS# 24045388
Virtual Tour
This unique farm complex is comprised of an equestrian area for 40 horses +, 5 residential houses and more. It has been in operation for over 100 years and is ready for new multi-generation owners to take the reins or for a progressive investor. There is nearly 280 acres of outstanding land, a pond, pastureland, rolling hills, stalls for 40+ horses and much more. There is, also, an outstanding mix of 5 houses that have 22 bedrooms for the families to share. The current owners are using 2 houses and renting 3 other homes. The investor may generate rental income from the farm's 5 residential homes and 1. a Two story 35x50 horse barn, 2.a 35x80 stable with 1.5 story horse stalls. 3 a Barn with double row stalls, 4. a 4-bay garage, etc.. These items may also be considered depreciable property (see your tax advisor). Other sources of income from the farm would include leases for pasture land and equestrian rental of the stable & indoor/outdoor riding, which is currently leased). Potential income may come from establishing a farm stand, growing grapes/ winery, Christmas tree sales, blue berries, and more The State of Connecticut Conservation Restriction requires this property to be 'agriculture in nature' according to development rights the state acquired approximately 70 years ago.
Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Gary Dobratz