My Company's Active Listings

$3,950,000 (USD)
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 / Listed By: Gary Dobratz, Century 21 Allpoints Realty
$3,495,000 (USD)
Active

Miramar Beach Area Single Family Home

Active

28 Spyglass Drive Miramar Beach, FL 32550

6 Bed
5 Baths
4820 sqft
MLS# 1012238
COASTAL LUXURY BETWEEN DESTIN HARBOR & 30A, GULF VIEWS, NO HOA & NO FLOOD ZONE!
Experience the ultimate Emerald Coast lifestyle in this exceptional 4,820-SF remodeled beach estate, ideally positioned in a quiet neighborhood less than a quarter mile from the Gulf and perfectly situated between the vibrant energy of Destin Harbor and the iconic 30A corridor.
One of the property's most distinctive advantages is its elevation. Sitting at the highest elevation in the neighborhood and located in a NO FLOOD ZONE, this remarkable property offers added peace of mind rarely found this close to the Gulf with NO HOA, you have the freedom and flexibility to enjoy the property on your terms.
The three-story residence showcases impressive scale, sophistication, and relaxed coastal elegance, offering 6 bedrooms and 5 beautifully appointed bathrooms with generous living spaces and high-end finishes throughout.
On the third floor, the luxurious primary suite captures beautiful Gulf views, creating an exceptional private retreat where you can wake up to the shimmering waters of the Emerald Coast and unwind with breathtaking coastal vistas.
Outside, you're just minutes from the area's legendary sugar-white beaches and emerald-green waters. Spend your days enjoying the Gulf, boating and fishing from Destin Harbor, playing golf, exploring 30A, or taking advantage of the area's renowned dining, shopping, and entertainment. Rental PJ's up to $250K Whether you're seeking a luxury primary residence, second home, private beach retreat, or income-producing investment, this property offers an extraordinary combination of size, elevation, Gulf views, location, and flexibility.
High elevation. Gulf views. No flood zone. No HOA. Less than a quarter mile to the beach.
This is more than a coastal home--it's an exceptional Emerald Coast lifestyle and an investment in one of Florida's most coveted destinations.
Listing Courtesy of EMERALD COAST / Listed By: Rhonda Johnson, Century 21 Allpoints Realty
$3,200,000 (USD)
Active

Wethersfield Area Commercial

Active

30 Jordan Lane Wethersfield, CT 06109

Bed
0 Baths
31758 sqft
MLS# 24175635
Virtual Tour
Striking three-story brick office building set on a beautifully landscaped, established site in Wethersfield's professional corridor! Find presentable curb appeal with red brick, a dormered roofline, and mature plantings. Three floors served by elevator, with a sizable ~158-space parking lot. Substantially renovated and significantly upgraded, with over $1.1M of documented capital investment in building systems, common areas, a refreshed lobby, and a full medical-grade second-floor buildout. Two long-term tenants anchor the building today, a medical practice and a home-care services group, providing strong in-place income. Well-suited for an owner-user: a medical group, specialty practice, or professional firm can occupy anywhere from 5,000 to 18,000 SF while the in-place leases help carry the building. The available space is flexible, with a spacious first floor (~10,000 SF) subdivideable into multiple configurations, and a large, light-filled open-plan upper floor (~8,000 SF) that works as a single tenant's space or carved into smaller suites. The building is a natural fit for a range of medical specialties, as well as professional users. The established medical cluster a mile away on Silas Deane Highway reinforces the address for any healthcare user. Easy highway access is an advantage too, with I-91 less than a mile away and downtown Hartford a ten-minute drive. An excellent opportunity to own a substantially improved, income-producing professional address!
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$3,000,000 (USD)
Active

Hartford Area Commercial

Active

11 Charter Oak Place Hartford, CT 06106

0 Bed
0 Baths
0 sqft
MLS# 24219881
A 1.93-acre campus redevelopment opportunity in one of Hartford's most historic neighborhoods, just a short walk to downtown, major employers, and cultural attractions. The site includes the former St. Peter's School, the adjacent convent at 11 Charter Oak Place, and the church, with potential for 65 residential units across the two buildings. Built in 1913, the 56,296 SF brownstone school has received Hartford Historic Preservation Commission approval for adaptive reuse as residential. Architect's concept plans lay out 49 units: 38 studios, 4 one-bedrooms, 5 two-bedrooms, and 2 three-bedroom lofts, plus a laundry facility and unit storage. The former convent, in the Charter Oak Place Historic District, also has Historic Preservation Commission approval for residential conversion. City-reviewed plans show 16 units: seven studios (438 SF), eight one-bedrooms (582 SF), and one two-bedroom (860 SF). The church invites buyers to bring their creativity, with potential to become a community gathering place, event venue, or another use that complements the residential campus. The local rental market supports strong pricing. Nearby studios rent for $1,300 to $1,380, new one-bedrooms achieve $1,650, and two-bedrooms command about $1,800.. Zoned MX-2. Historic approvals, concept plans, and a planning status letter are available to qualified buyers. Can be purchased as a package at a discount with 20 Clifford St and 273 Asylum
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$2,995,000 (USD)
Active

Aqua Area Condominium

Active

13675 Vanderbilt Drive 406 Naples, FL 34110

4 Bed
4 Baths
3590 sqft
MLS# 2026012623
Virtual Tour
Experience elevated coastal living at AQUA at Pelican Isle, one of North Naples’ most exclusive luxury waterfront towers. This spacious 3,590 sq. ft. residence offers a rare opportunity to own a beautifully designed, Gulf-facing condominium positioned to capture sweeping views of the marina, mangroves, and the Gulf beyond—without overlooking parking areas or close neighboring buildings.
Designed with a desirable front-to-back floor plan, the residence features two expansive balconies that invite seamless indoor-outdoor living. Start your mornings overlooking vibrant landscape over the newly manicured Kinsale Golf course and end each evening with spectacular Gulf sunsets and afterglows from your private balcony overlooking a peaceful yacht harbor. Dolphins, manatees, and passing boats create a constantly changing waterfront backdrop.
Originally built as a model residence by the renowned Antonacci Design Group, this home showcases refined contemporary coastal design with luxury finishes and architectural details throughout. The residence includes 4 bedrooms plus a den, 4 full bathrooms, and two secured garage parking spaces, and is offered furnished, making it ideal for a seasonal resident seeking a move-in-ready Naples retreat.
A private elevator vestibule entry welcomes you into a sophisticated interior highlighted by elegant wood flooring, custom Italian cabinetry, and thoughtfully curated design elements that blend comfort with luxury.
Residents of AQUA enjoy the privacy of a low-density luxury tower combined with an exceptional collection of resort-style amenities. The community features a private marina with boat slips, cabanas, and direct Gulf access, along with kayaks for exploring the surrounding waterways. Additional amenities include a concierge attended lobby with 24/7 security, fitness center with sauna and steam rooms, theater, billiards lounge with golf simulator and bar, two grand social rooms, and beautifully designed outdoor gathering spaces.
Outdoors, enjoy the resort-style pool and spa areas, grills stations, marina pavilion, fire pits, and a Sky Lounge—perfect for entertaining or simply relaxing while taking in the waterfront setting. AQUA is also pet-friendly with dedicated dog park areas.
For those seeking an elevated club lifestyle, optional memberships are available next door at Pelican Isle Yacht Club, offering waterfront dining, tennis, pickleball, instructed fitness, and a shuttle boat to the beach. Golf enthusiasts may also consider opportunities at the newly opened Kinsale Golf Club, an exclusive course for 250 members.
Combining expansive living space, breathtaking waterfront views, and one of Naples’ most refined amenity offerings, this residence delivers a truly exceptional luxury coastal lifestyle in North Naples. Virtual renderings are included with photos.
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Miranda Pitts, Century 21 Allpoints Realty