My Company's Active Listings - Page 5 - Rolando Abin

$12,500,000 ^(USD)

Santa Rosa Beach Area Land

Active

78 Whispering Shr Cove Santa Rosa Beach, FL 32459

Bed

0 Baths

sqft

MLS# 978277

Discover an extraordinary opportunity on the shores of Choctawhatchee Bay. This unparalleled bay front acreage offers unlimited upside for development or the serene privacy of a secluded estate.
Conveniently located in world-renowned South Walton, the property is just minutes away from the pristine sugar-white beaches and extraordinary amenities of 30A and Sandestin.
Boasting over 2,285 feet of magnificent waterfront on 35.55 acres along Choctawhatchee Bay, this is a truly spectacular parcel like no other. The property is zoned Traditional Neighborhood, allowing for a density of up to 30 units per acre.
All structures on property are deemed without value.
All information is deemed reliable but not guaranteed, The buyer to verify for their particular use.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Jim Ball

$5,555,000 ^(USD)

N/A Area Commercial

Active

32 Huntington Street Hartford, CT 06154

0 Bed

4 Baths

12128 sqft

MLS# 24104951

VALUE-ADD OPPORTUNITY IN PRIME ASYLUM HILL LOCATION! Bring new life to these classic brick buildings-5 solid multifamily structures plus a vacant lot with gated, shared parking in the rear. Rarely does a portfolio of this scale and potential hit the market. Situated on a unified campus, this offering features a diverse unit mix ranging from studios to spacious 3-bedroom townhomes, many of which include 2 full bathrooms. Approximately 25-30 units have already been renovated with modern finishes, while the remaining units present significant upside for investors looking to add value. Additional highlights include laundry rooms in each building, an on-site office, updated electrical with subpanels in every unit, and numerous newer boilers and hot water heaters. Whether you're looking to reposition for long-term cash flow or a new value add project, this is a rare chance to acquire a substantial footprint in a rapidly developing urban market. Savvy investors-don't miss out!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Lisa Cozzi

$4,995,000 ^(USD)

Freeport Area Land

Active

Xx W St Highway 20 Highway Freeport, FL 32439

Bed

0 Baths

sqft

MLS# 971000

This exceptional 57.27-acre development parcel is situated in the heart of the rapidly growing Freeport market area. Strategically located just east of Hammock Bay with 1000 feet on Hwy 20, the property is only minutes from the thriving business district along Hwy 331, as well as Freeport Elementary, Middle, and High Schools. It's a quick 20-minute drive to the stunning beaches of 30A, along with world-class shopping and dining options. The property is zoned Commercial Residential and within the City of Freeport Zoning District, with development potential ranging from 2 to 14 dwelling units per acre. Commercial frontage along Hwy 20. The land is mostly uplands, with Four Mile Creek running through the southern portion and direct access to the bay. Buyer to verify data for its own useuse

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Jim Ball

$4,200,000 ^(USD)

Santa Rosa Beach Area Land

Active

Tract I Sandgrass Blvd Boulevard Santa Rosa Beach, FL 32459

Bed

0 Baths

sqft

MLS# 968983

Once, in a lifetime DEVELOPMENT OPPORTUNITY in the pristinely beautiful NatureWalk Community Development District. LOCATED IN THE HEART OF SEAGROVE BEACH. This would also make a This would also make an amazing PRIVATE ESTATE Parcel is NOT part of the HOA and are zoned mixed use/ multi family. Previous development order for townhomes was approved in Walton County, but will need renewing. Tract I is 2.63 acres Close to beach access at San Juan. Properties would also make great Beach Estate Homesites. Sellers may consider separating out parcels. New owners have the opportunity to join HOA.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Victoria Hughes

$4,100,000 ^(USD)

Durham Area Farm

Active

148 &Amp 153 Wallingford Road Durham, CT 06422

Bed

0 Baths

sqft

MLS# 24015202

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,375,000 ^(USD)

Sanibel Harbours Area Single Family Home

Active

1307 Isabel Dr Sanibel, FL 33957

3 Bed

4 Baths

1750 sqft

MLS# 225012659

Your search is over! STOP SCROLLING! All reasonable offers will be entertained. Welcome to 1307 Isabel Drive, an extraordinary island oasis located on the serene bay side of beautiful Sanibel Island. This 3-bedroom, 3.5-bathroom home offers the ultimate waterfront lifestyle, with every room boasting breathtaking water views. Situated at the end of a canal, the property features two docks, including a 10-ton boat lift, making it a true boater's paradise. Built with love and craftsmanship since 1991, this home was completely renovated in 2005. The house was transformed into a hurricane-proof haven with reinforced walls, PGT impact windows, and a sturdy metal roof capable of withstanding winds over 200mph. The wraparound deck, measuring 2,150 square feet, provides ample space for outdoor entertaining and overlooks the lush, tropical landscape and canal. The main living area spans 1,750 square feet and features vaulted ceilings, beautiful solid birch floors, and custom 1x6 cypress wood throughout. The gourmet kitchen is a chef’s dream, equipped with granite countertops, a gas range, wine cooler, and ample dining space for 10-12 guests. The living area flows seamlessly into a music room, offering a perfect spot to relax and entertain. The spacious master suite boasts a large walk-in closet, a spa-like bath with double granite vanities, a stone shower, soaking tub, and bidet. A standout feature of the property is the private 755-square-foot guest cottage, which offers a full gourmet kitchen, large bedroom and bathroom, and a spacious living area. The cottage opens to a 645-square-foot lanai and a 30'x15' pool, ideal for extended outdoor dining and relaxation. The tropical yard, with its royal palms, coconut trees, birds of paradise, and traveler’s palms, offers complete privacy and creates an idyllic setting for outdoor living. At the end of the canal, a 12'x18' chickee hut, built by O.B. Osceola of the Seminole Tribe, provides a magical retreat. The lush, mature foliage of this property is truly unmatched on Sanibel Island. Additional amenities include a large two-car garage, climate-controlled storage/workshop space, a newly renovated irrigation system, and a buried propane tank that can power a whole-house generator. For boaters, the property features two docks, multiple davit bases, and easy access to the bay. This home offers unparalleled privacy, a spacious lot, mature tropical landscaping, and the rare combination of a fully separate guest cottage and extensive boating facilities. This is a once-in-a-lifetime opportunity to own a piece of paradise on Sanibel Island.

Listing Courtesy of BONITA SPRINGS / Century 21 Allpoints Realty / Virginia Lesko

$3,300,000 ^(USD)

N/A Area Commercial

Active

273 Asylum Street Hartford, CT 06103

Bed

0 Baths

35277 sqft

MLS# 24121920

Seize the opportunity to reimagine a former high school site into a dynamic residential community in the heart of downtown Hartford. Approved plans are already in place for a 50-unit development featuring 22 studios, 11 studio-plus layouts, and 17 one-bedrooms-perfectly aligned with the growing demand for modern urban living. Market rents are projected at $1,400+ for studios and $1,700+ for one-bedrooms, highlighting the strong income potential. A nearby parking area may also be included, adding valuable convenience for future residents. The location is unmatched-just steps from the PeoplesBank Arena, two blocks from Bushnell Park and City Place, and within walking distance to TheaterWorks, Black Eyed Sally's, Agave, Max Downtown, and more. With easy access to I-91, I-84, and Route 2, connectivity is seamless. Bring your vision and creativity to one of Hartford's premier redevelopment opportunities!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Lisa Cozzi

$2,800,000 ^(USD)

Durham Center Area Single Family Home

Active

153 Wallingford Road Durham, CT 06422

15 Bed

8 Baths

10623 sqft

MLS# 24045388

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

$2,799,000 ^(USD)

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. Ask me about Investment Loan Options!

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Ken Koger

$2,700,000 ^(USD)

Miramar Beach Area Single Family Home

Active

28 Spyglass Drive Miramar Beach, FL 32550

6 Bed

5 Baths

4820 sqft

MLS# 975385

Massive $750,000 Price Reduction — Now Offered at $2.7M!
The seller says, 'Let's get this sold!' Don't miss this extraordinary opportunity to own a fully remodeled luxury beachside estate in one of the area's most desirable locations. At this new price, this property represents incredible value for the quality, size, and location offered.With rental projections between $235K-$300K annually, this property offers exceptional income potential as a high-performing vacation rental or the ultimate private coastal retreat. Indulge in unparalleled beachside elegance with this meticulously remodeled 3-story estate. Perfectly suited as an extraordinary rental or a lavish primary residence, this expansive 4,820 sq. ft. home offers 6 bedrooms, 5 baths, and ample space to accommodate 24 guests Upon entering, you're greeted by an open, airy main floor designed for seamless entertaining. The spacious living area flows effortlessly into the chef-inspired kitchen, featuring top-of-the-line Wolf and Sub Zero appliances and sleek quartz countertops- a dream for culinary enthusiasts. The adjacent patio extends the living space, ideal for al fresco dining or relaxing with loved ones.
An elevator provides effortless access to all levels of this stunning home, which also includes a versatile flex space, perfect as a media or game room. The master suite boasts panoramic Gulf views, a private sitting area, a wet bar, an expansive walk-in closet, and a secondary laundry room for added convenience.
Outside, unwind in your private resort-style oasis, complete with a heated pool, spa, and a beautifully landscaped Astroturf backyard perfect for playful moments with family. The luxurious poolside shower/changing room offers a unique space to rinse off the sand after a day at the beach. Every floor features a balcony, providing you with panoramic views of breathtaking Florida sunsets and views of The Gulf of America!
Situated 15 feet higher than the neighboring homes, this home is not in a flood zone and has no HOA fees. Recent enhancements include new HVAC systems, a new water heater, a resurfaced pool, new travertine tile patio, and a rejuvenated Astroturf backyard. This residence represents a 2022-2023 $800K renovation at the pinnacle of modern luxury, showcasing impeccable finishes throughout.
Just a short walk or golf cart ride from private beach access, and minutes from the excitement of Baytowne Wharf, Destin Commons, and world-class dining along the stunning Emerald Coast, this home promises a lifestyle of unparalleled luxury. Easy walk or golf cart ride to the private beach access! This luxury estate is located near the fun of Baytowne Wharf, Grand Boulevard, Destin Commons, fabulous restaurants and all that the stunning Emerald Coast has to offer. Furnishings are included with an acceptable offer!

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Rhonda Johnson

$2,632,000 ^(USD)

N/A Area Commercial

Active

46 Apel Place Manchester, CT 06042

0 Bed

1 Baths

77569 sqft

MLS# 24079470

Whether you need space for production, storage or operations, this facility is designed to support your business success. Expansive multi-building warehouse/manufacturing complex on 6.8 acres. Offering a series of small, med. and large warehouses, an office building and an 11 bay service garage with warehouse space and additional office space. This property is ideal for light industrial and a variety of commercial/industrial operations. Multiple warehouse buildings are perfect for storage, manufacturing or distribution. Convenient on site office space to manage operations. High ceilings, large doors, loading docks and parking areas accommodate trucks, employees, trailers, machinery and equipment with ease. Service garage can be equipped for fleet servicing, storage or converted to complimentary usable space. Easy access to major highways, shipping routes and local business hubs. Ideal for logistics and distribution centers, light manufacturing, storage and warehousing, construction and trade businesses. Clean phase 1 and 2 study available.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Denise Reale

$2,190,000 ^(USD)

N/A Area Single Family Home

Active

15 Highland Terrace Madison, CT 06443

5 Bed

3 Baths

1444 sqft

MLS# 24121616

COME SEE THIS ONE OF KIND FULLY RENOVATED MADISON HOME WITH PRIVATE BEACH RIGHTS!!! Just 300 feet from the sand, this home was once a traditional raised ranch and now has been brilliantly redesigned into a spacious 'elevated ranch' with an open-concept floor plan that feels airy, bright, and made for entertaining! Step into coastal luxury with this fully reimagined Madison home, where every detail has been carefully curated to blend modern elegance with seaside charm. Some of the primary level highlights include a stunning kitchen anchored by a nearly 10-foot white quartz island, upscale appliances, and an abundance of artificial and natural light from every angle. Flowing seamlessly into the living room and a breathtaking sunroom framed by brand-new oversized Marvin picture windows offering tranquil views reaching toward Long Island Sound. A spacious hallway passing by a renovated guest full bath, a conveniently placed laundry area, and the show-stopping primary suite. Once two large bedrooms, now transformed into a luxurious master oasis. A 9' x 12' walk-in closet designed for true wardrobe enthusiasts and a spa-inspired bathroom with a double vanity, dual rain showers, and two built-in shower benches for the ultimate relaxation. The lower level highlights include an additional three generous bedrooms with ample light and storage, a third meticulously renovated full bathroom with a double vanity, a 2nd brand new washer and dryer set, a voluminous additional living area

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / John Cronin

$2,190,000 ^(USD)

N/A Area Single Family Home

Active

74 Rogers Road Stamford, CT 06902

5 Bed

4 Baths

4764 sqft

MLS# 24128395

Welcome to 74 Rogers Rd in beautiful Shippan Point, one of the most sought after locations in Stamford. This lovely 5 bedroom, 3.5 bath home sits on 3/4 acre with plenty of room for a pool and just steps away from it's private deeded beach. On the main floor you will find a lovely eat-in kitchen with fireplace, family room with fireplace, formal dining room and stunning living room. Also on the main floor is the gorgeous master suite with office and a exercise room. On the second floor is an additional 3 bedrooms and 2 baths. Just minutes from downtown Stamford, Harbor Point, tons of amazing restaurants and the Stamford train station!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Patricia Giordano

$2,000,000 ^(USD)

N/A Area Commercial

Active

1532 West Street Southington, CT 06489

0 Bed

1 Baths

3100 sqft

MLS# 24033537

Headline: Prime Commercial Development Opportunity on Route 229 Description: Discover a rare development opportunity with these three adjacent parcels on high-visibility Route 229. Located just one mile from the global headquarters of ESPN and the popular Lake Compounce Amusement Park, this expansive property offers unparalleled potential for commercial growth. The site provides easy access to major transportation arteries, including Interstate 84 and State Highway Route 72, making it an ideal location for a project. Imagine a bustling commercial plaza, a modern hotel, or a spacious grocery store drawing traffic from nearby attractions and commuters. The possibilities are limited only by your vision. This unique property is also available with owner financing and a very long-term lease option, providing flexible solutions for serious investors.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Eric Adams

$1,999,900 ^(USD)

Lakoya Area Single Family Home

Active

6597 Costa Cir Naples, FL 34113

4 Bed

5 Baths

3276 sqft

MLS# 225073747

Get ready to have your breath taken away! This isn't just a home; it's a masterpiece of luxury
living nestled within the prestigious Lakoya community at Lely Resort. We are thrilled to present
this exceptional, Stock-built Muirfield IV residence, offering the perfect trifecta of elegance,
comfort, and unmatched privacy. Your Exclusive Naples Oasis. Imagine waking up to this:
your home is set on a prime lot with sweeping, expansive views of both the sparkling water and
the lush golf course! This spectacular four-bedroom-plus-den, four-and-a-half-bathroom haven is
custom-designed for those who demand the absolute finest. And here’s the best part: it’s offered
turnkey/furnished! That means you literally pack a bag, unlock the front door, and instantly start
soaking up the magnificent Naples lifestyle. No waiting, just immediate, luxurious enjoyment!
Step through the striking modern double entry door and prepare to be dazzled. The open floor
plan flows effortlessly across large, seamless tile flooring, creating an incredibly spacious and
inviting atmosphere. The gourmet kitchen is a true showstopper and a chef’s ultimate fantasy,
boasting a gas cooktop, brilliant quartz countertops, and custom cabinetry that’s as beautiful as it
is functional. The dedicated den/office is a refined sanctuary, complete with custom-built-in
cabinets perfect for work, reading, or quiet relaxation. Privacy? Check! Each of the four
spacious bedrooms features its own private en-suite bathroom, offering ultimate convenience for
family and guests alike. Outdoor living doesn't get any better than this! The oversized lanai is an
absolute entertainment destination. It features a fantastic outdoor kitchen, a large, custom gas-
heated pool and spa, and impressive custom teak tray ceilings that create a resort-style ambiance.
Gather around the cozy fire pit with a glass of wine and watch the sunset—it's pure magic!
Owning this Muirfield IV means more than just a gorgeous home; it means gaining a VIP pass to
the incredible Lely Resort lifestyle! Golf Heaven: Tee off on your choice of three championship
golf courses. The Players Club & Spa: You get access to this award-winning, world-class
amenity center! Enjoy two resort-style pools, a lap pool, a state-of-the-art fitness center, tennis
courts, pickleball, and bocce. Dining & Social: The club features a full-service restaurant
(indoor/outdoor), a lively tiki bar, and a grill. Plus, a full-time activities director keeps the
calendar packed with fun events, making it easy to meet friends and live an active, social life!
This Muirfield IV home in Lakoya at Lely Resort is the unparalleled combination of modern
luxury, impeccable design, and a vibrant community you’ve been searching for. Don't just dream
about the Lely life—Start Living, Laughing, and Loving it Today!

Listing Courtesy of SWFMLS / Century 21 Allpoints Realty / Julie Cologero

$1,999,000 ^(USD)

Durham Center Area Single Family Home

Active

148 Wallingford Road Durham, CT 06422

7 Bed

3 Baths

3308 sqft

MLS# 24045370

The Greenbacker's Brookfield Farm located midway between Hartford and New Haven in Durham Connecticut has two houses, dairy barn and many other outbuildings. There is approximately 140 acres and approximately 100 acres are least to other farmers for growing crop, etc.. The investor may generate income from the farm's rentals 1. Dairy barn, 2, growing crops (92 acres of cropland leased, currently), 3, Durham Fair parking. 4, pastureland (20 acres of pasture leased, currently), 5, hunt club (land leased currently). 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. Both 148 and 153 Wallingford Road may be sold together.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Gary Dobratz

$1,900,000 ^(USD)

N/A Area Single Family Home

Active

120 Chamberlain Hill Road Middletown, CT 06457

4 Bed

5 Baths

5661 sqft

MLS# 24130406

Situated on almost 13 acres in the heart of CT, this stunning Colonial offers peace and nature while being located conveniently to everything including beaches, highways, Middlesex hospital, Wesleyan University, CT river, and Middletown's thriving downtown with an abundance of shops, restaurants and activities. An entertainer's paradise with a backyard oasis boasting a heated, gunite, in-ground pool with splash pad and jacuzzi, fireplace, wet bar with propane grill and flat top, and new wood fired steam sauna. The chef's kitchen features all GE Profile smart appliances, 2 hidden spice racks and has a walk-in pantry and an additional smaller one. The family room off the kitchen is a perfect link to the outdoor parties and features a hidden tv that is lowered out of the way of the patio entrance. The 21' high great room offers a floor to ceiling stone fireplace and windows flooding the home with natural light. An office with a gas fireplace is off the front foyer with a beautiful, crystal chandelier with a switch to lower it for cleaning. The first floor master suite has a slider to the patio and gorgeous ensuite and walk-in closet. The upper level features a bonus room and 3 bedrooms, all with ensuites and walk-in closets. The kitchen and all full baths have heated floors, surround sound speakers throughout the whole house, smart thermostats and appliances, heated garage, whole house water filtration with UV light, irrigation system, whole house generator plus much, much more.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Jeff Petersen

$1,899,000 ^(USD)

Santa Rosa Beach Area Land

Active

Xx Nellie Drive Santa Rosa Beach, FL 32459

Bed

0 Baths

sqft

MLS# 922046

A rare prime 20-acre parcel for residential development in the booming South Walton Santa Rosa Beach area, which is one of the highest growth districts in the county; and Walton County is one of the highest growth markets in the state as well as the Southeast. All measurements and information are approximations based on available data and to be verified by buyer as to suitability for intended use. Call listing agent for details.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Jim Ball

$1,890,000 ^(USD)

Santa Rosa Beach Area Land

Active

Xx W Co Highway 30A Santa Rosa Beach, FL 32459

Bed

0 Baths

sqft

MLS# 964694

NEW PRICE! Unparalleled Coastal Dune Lake Homesite. Ultimate coastal luxury with this rare dune lake homesite in Dune Allen Beach. Enjoy breathtaking views and sunsets over Stallworth Lake of the emerald Gulf waters and direct access to pristine sugar-white sands just a short walk away. Own a piece of paradise on this extraordinary 0.34-acre dune lake-front home site with 169 feet of waterfront and the unique opportunity to build your dream home in one of South Walton's most sought-after locations along 30A. Immerse yourself in the vibrant 30A lifestyle, just moments away from world-class dining, shopping, and entertainment at Grand Boulevard, Gulf Place, and Seaside. A portion of the site is in Flood Zone ''X''. All information is deemed accurate and Buyers should verify for their needs. Survey and rough building footprint in documents.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Jim Ball

$1,725,000 ^(USD)

Esplanade By The Islands Area Single Family Home

Active

15408 Turin Dr Naples, FL 34114

3 Bed

4 Baths

2941 sqft

MLS# 225074089

The opportunity to purchase a Lincoln model in the highly sought after community of Esplanade by the Islands on the largest lake in the community is now available! Enjoy your coffee every morning while you enjoy the sunrise over the water on your extended Lanai with plenty of space to add a pool/spa. A pool bath was built and is ready to use.The interior of the home offers 12 foot ceilings to include trays in the great room, master bedroom, dinning room and foyer. High end monogram appliances, level 5 upgraded cabinets and an open concept for the chef in the family. 3 bedrooms, large den, 3.5 bathrooms and 3 car garage. Amenities include a resort style pool, spa, wellness center, eight pickle ball courts, five tennis courts, 4 bocce courts, Bahama bar and restaurant poolside, fine dinning restaurant currently being built. A short drive to downtown Naples and Marco Island.

Listing Courtesy of SWFMLS / Century 21 Allpoints Realty / Richard "Rich" Kasparian

$1,688,000 ^(USD)

N/A Area Single Family Home

Active

215 Old Mountain Road Farmington, CT 06032

5 Bed

7 Baths

5951 sqft

MLS# 24110946

Welcome to 215 Old Mountain Road, where timeless brick Colonial elegance meets grand Connecticut living. Perched on 3.5 private acres in sought-after Farmington, this nearly 6,000 sq ft masterpiece is designed for those who demand space, style, and substance. Step inside to soaring ceilings and sunlit rooms that flow effortlessly for everyday living or unforgettable entertaining. The gourmet kitchen is the heart of the home, perfect for morning coffee or hosting the holidays, with premium appliances and generous prep space. Multiple living areas, formal dining, and a stately home office balance comfort with sophistication. Five spacious bedrooms and six full plus one half baths ensure everyone has room to relax, while the expansive primary suite is your own private sanctuary, complete with spa-like bath and custom closets. Outside, discover well maintained grounds framed by mature trees, ideal for gatherings, play, or simply soaking in the serenity. A 3-car garage completes this rare offering. Minutes from West Hartford Center, UConn Health Center, and I-84, and yet tucked away on a quiet road for ultimate privacy. This is not just a home, it's a lifestyle.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Robert Perriello

$1,600,000 ^(USD)

N/A Area Commercial

Active

264 Queen Street Southington, CT 06489

0 Bed

4 Baths

5343 sqft

MLS# 24081570

Great commercial investment available right in the heart of Queen Street! Fully leased building that houses two long standing, local businesses! Surrounded by Walmart Plaza, two car washes, two condo complexes across the street. Heavy traffic area at a traffic light.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Karen Polak Bobik

$1,579,000 ^(USD)

Destin Area Condominium

Active

5 Calhoun Avenue Ph705 Destin, FL 32541

4 Bed

4 Baths

2836 sqft

MLS# 987516

Renovated Corner Penthouse features expansive views of the Gulf, East Pass, Destin Harbor, Crab Island, Choctawhatchee Bay, & the tree top canopies of Destin. This stunning waterfront condo was completely renovated in 2020 and offers 4 bedroom with ensuite bathrooms. One of the bedrooms has been converted into a cozy den. This unit has 2 balconies that wrap around and offer abundant space for entertaining, watching wildlife, gardening & the most spectacular sunsets. Completely renovated which includes beautiful new honed marble kitchen counters, shiplap, pecks cypress ceilings, new flooring, paint, & cabinets, surround sound, outside speakers and separate storage locker & 2 dedicated covered parking spaces. There is also a Marina on site

Walk to restaurants, bars

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Jerry Sullivan

$1,559,000 ^(USD)

Miramar Beach Area Single Family Home

Active

115 Alamo Street Miramar Beach, FL 32550

5 Bed

7 Baths

2706 sqft

MLS# 943284

Amazing vacation rental opportunity!!! This incredible beach compound is located less than 500 feet from the beautiful white sands and crystal clear waters of the Gulf of Mexico and the newly constructed beach access! The home is designed for absolute relaxation and pure enjoyment of the beach. This is truly a special find in this area as it's so close to the water, yet with so much privacy. No neighbors on three sides, a short walk to the beach and not to mention your own glorious private heated pool. Another coveted benefit of this property, is the detached carriage house. This is a perfect additional living area, if you're having a larger family gathering but still want to have your own space. Vacationers absolutely love this and book this property out for this very reason.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Chris Irons

$1,550,000 ^(USD)

Tolland Area Commercial Land

Active

Tolland Stage Road Tolland, CT 06084

Bed

0 Baths

0 sqft

MLS# 24101836

Exceptional Opportunity!! Incredible potential to fully develop over 80 acres of raw land with easy access to interstate 84. Fantastic possibility awaits you on this large level lot zoned Residential Design District which encourages a flexible site design that covers many options from single family homes to village type cluster housing. Expand your options with special permit uses which include senior housing, assisted living facility, a private school, nonprofit club or take advantage of the natural landscape for a sporting club, campground or resort, just to name a few. (See Section 5.1 - 5.2 attached for more details) Use your imagination, so many options available for an investor or real estate developer. Ideally located with 1,200 feet of frontage on Tolland Stage Road/Route 74 and additional access on Buff Cap Road only minutes to local amenities and attractions, easy commute to Boston in under 90 minutes. Some wetlands which enhance the beauty of the property. This parcel of land is a true gem, visit today for more details and information.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Elaine AbouAkar

$1,550,000 ^(USD)

N/A Area Land

Active

00 Tolland Stage Road Tolland, CT 06084

Bed

0 Baths

0 sqft

MLS# 24052420

Exceptional Opportunity!! Incredible potential to fully develop over 80 acres of raw land with easy access to interstate 84. Fantastic possibility awaits you on this large level lot zoned Residential Design District which encourages a flexible site design that covers many options from single family homes to village type cluster housing. Expand your options with special permit uses which include senior housing, assisted living facility, a private school, nonprofit club or take advantage of the natural landscape for a sporting club, campground or resort, just to name a few. (See Section 5.1 - 5.2 attached for more details) Use your imagination, so many options available for an investor or real estate developer. Ideally located with 1,200 feet of frontage on Tolland Stage Road/Route 74 and additional access on Buff Cap Road only minutes to local amenities and attractions, easy commute to Boston in under 90 minutes. Some wetlands which enhance the beauty of the property. This parcel of land is a true gem, visit today for more details and information.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Elaine AbouAkar

$1,498,000 ^(USD)

Inlet Beach Area Single Family Home

Active

15 E Queen Palm Drive Inlet Beach, FL 32461

5 Bed

5 Baths

3045 sqft

MLS# 969962

Better then NEW - ( almost new ) home comes fully furnished and turn key ready for your rental investment. Amazing 5 bedrooms and 4.5 Baths. Would be a great rental machine or an amazing 2nd home/full time residence. With a two car garage and roof top views of the gulf- 15 Queen Palm Dr. is awaiting you and your family. The open concept 1st floor offers a chefs kitchen with dinning and living rooms attached and open. Light flows through the high ceilings making the nearly 3K SQFT feel even larger. Truly a must see!! Call and make appointment today.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Presley Sullivan

$1,488,000 ^(USD)

North Stamford Area Single Family Home

Active

501 Woodbine Road Stamford, CT 06903

4 Bed

5 Baths

5285 sqft

MLS# 24096838

LOCATION, LOCATION, OPPORTUNITY! In the middle of the Gold Coast (Greenwich, New Canaan and Darien).Save One Million Dollars from comparable homes in Queens, N.Y. which is 33 miles away. Luxurious Colonial with Smart Design for Modern Living. North Stamford is one of the Safest Areas in the country. Corner of Woodbine Road and Reservoir Lane. A stones' throw from the Laurel Reservoir. Total 7,568 square feet* Stunning 5,285 sq ft of sophisticated living space plus 2,283 sq.ft. of Walk-out Finished Basement with high ceilings.* Dramatic two-story foyer with elegant double curved staircases * Brick front with cedar siding exterior* New roof (5 years old)* 15 spacious rooms with premium hardwood floors * Dedicated in-law/nanny suite with separate entrance on Main Level.* Summer kitchen in basement in Open Space (2,200 square feet) Great for Large Parties!* Five bathrooms with marble finishes * Versatile Living/bedroom above oversized three-car garage (30' x 15') LUXURY COMFORT * Three wood-burning fireplaces/stove (one was never used)*State-of-the-art Hydro-Air Heating and AC with auxiliary Heat pump (dual source for heat) * Gourmet kitchen with high-end stainless steel appliances (Two Separate Sinks) *SECURITY & CONVENIENCE * Whole house emergency generator * Integrated security system (burglar/fire alarm) * Lightning arrestor system * Epoxy paint applied on Garage Floor. Whole House water filtration system. LED lighting installed throughout for brightness and Energy Efficiency

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Cosmo Iadanza

$1,384,000 ^(USD)

Niceville Area Single Family Home

Active

120 Bahia Vista Drive Niceville, FL 32578

4 Bed

4 Baths

2800 sqft

MLS# 970270

Property is under contract with a 48 Hour Kick Out Clause. Buyer is offering $10,000 in Buyer Bucks! Seller will consider ALL reasonable offers! Stunning waterfront home nestled on a .51 acre lot with 75 feet of waterfront and a deep-water dock. This fully remodeled 2800 SF home offers breathtaking views of Rocky Bayou. Upgrades Galore! This beauty is complemented with 4 bedrooms, 3.5 baths, spacious walkout balcony, New Interior & Exterior Paint, Revwood Laminate flooring, LED lighting, Elegant Quartz countertops throughout, High-end soft-close cabinets & drawers in the kitchen and baths, Stylish new staircase and railing, Electric fireplace & new interior doors. The open-concept kitchen shines with a breakfast bar, coffee bar, and plenty of space to entertain. Bring us an offer

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Ken Koger

$1,375,000 ^(USD)

Destin Area Single Family Home

Active

3551 Scenic Hwy 98 20 Destin, FL 32541

4 Bed

4 Baths

1920 sqft

MLS# 982568

Destiny Beach Villas rock!! Two fully furnished 2 bedroom/2 full bath rental units on Scenic Hwy 98 - just steps away from popular Crystal Beach. Each unit is fully furnished and sleeps 8 people. Recent improvements include back deck furniture 2024, new king size mattresses 2024, new floors and kitchen cabinets in down unit 2024. Back yard is Four Prong Lake with lots of nature - fish, ducks and turtles. Extended paver deck on down unit for barbecue.
Everything is near by - shopping and recreation. Large community pool for owners and rental guests. A totally relaxing property on a lake. Walking access over and under Scenic Hwy 98 to Destin's white sand beaches!!! Each unit has 2 assigned parking spaces with added guest parking. A top investment opportunity on the Emerald Coast.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Paul Maryeski

$1,310,000 ^(USD)

Noroton Area Single Family Home

Active

3 Turnabout Lane Darien, CT 06820

4 Bed

3 Baths

2124 sqft

MLS# 24112310

Stunning, fully updated 4-bedroom Colonial in highly sought-after Noroton Heights. Featuring an ideal first-floor primary suite for convenience and privacy. Enjoy a spacious, level backyard perfect for outdoor entertaining or play. This home is in move-in condition with modern finishes throughout, located close to all area amenities-shopping, dining, top-rated schools, parks, and beaches. Superb commuter location with easy access to the train, I-95, and town center. Experience comfortable living in a vibrant, walkable neighborhood! ALSO AVAILABLE FOR RENT - 7k Monthly.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Tara Travers

$1,300,000 ^(USD)

Miramar Beach Area Land

Active

Lot 12 Hollywood Street Miramar Beach, FL 32550

Bed

0 Baths

sqft

MLS# 966448

PRIME BUILDING LOT in Frangista Beach. Build your dream home at the beach or if money making is your thing build that perfect rental home. Location is everything and this lot has it. Located directly across the street from amazing white sand beach and emerald green waters. Close to restaurants, shopping and entertainment. Additional lot next-door available for purchase if you're looking for a larger property, you can put them together and enjoy your own estate.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Victoria Hughes

$1,300,000 ^(USD)

N/A Area Single Family Home

Active

16 Chevas Road Avon, CT 06001

4 Bed

4 Baths

3482 sqft

MLS# 24131693

To be completed in Fall/Winter 2025 -- Welcome home for the holidays! Luxury living in the Farmington Valley! A ~3,500 sq ft modern farmhouse boasts an open-concept 1st floor w/ 9+ ft ceilings, wide-plank hardwood floors, and Anderson 400 windows. The gourmet kitchen has a large center island with breakfast bar, abundant storage, and modern finishes, opening to a dedicated dining space perfect for hosting or quiet family mornings. The adjoining family room, anchored by a cozy gas fireplace, is bathed in natural light; a warm, inviting space for making memories. A generous mudroom off the 3-car garage, private office/study and a half bath complete the vast 1st floor. Upstairs, the primary suite is a retreat with two walk-in closets and a spa-like ensuite featuring a wet room and soaking tub. There are 3 additional bedrooms including one with a private bath, ideal for guests, au pair or multi-generational living. A dual-vanity hall bath and second-floor laundry enhance comfort and convenience. The expansive bonus room offers endless possibilities as a playroom, home theater or fitness space. Nestled in award-winning Avon, this home combines top-rated schools, country clubs, and community charm with easy access to West Hartford, Route 44, Downtown Hartford, and Bradley International Airport. Crafted to elevate everyday living, this home is truly exceptional and not your standard new construction. Next door to the beautiful 455 Lovely St, already completed

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Molly Sullivan

$1,300,000 ^(USD)

Miramar Beach Area Land

Active

Lot 13 Hollywood Street Miramar Beach, FL 32550

Bed

0 Baths

sqft

MLS# 966449

PRIME LOT in Frangista Beach. Build your dream home at the beach or if money making is your thing build that perfect rental home. Location is everything. And this lot has it. Located directly across the street from amazing white sand beach and emerald green waters. Close to restaurants, shopping and entertainment. Additional lot next-door available for purchase if you're looking for a larger property, you can put them together and enjoy your own estate.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Victoria Hughes

$1,295,000 ^(USD)

Burnside Area Commercial

Active

135 Burnside Avenue East Hartford, CT 06108

0 Bed

6 Baths

18502 sqft

MLS# 24121857

Prime office property located on Burnside Avenue in East Hartford. This well-maintained 18,000 square foot building is fully occupied and generating a Net Operating Income of $121,000 annually. Parking for approximately 90 vehicles. Possible seller financing available with an 8.6% cap rate and 9.5% cash-on-cash return. Excellent visibility and convenient East Hartford location. Space could be made available for an owner/occupant This is a strong investment opportunity with steady income and flexible ownership options. Four new HVAC units recently installed.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / John Zubretsky Jr.

$1,279,999 ^(USD)

Bay Park Manor Area Single Family Home

Active

700 E 2nd Street Lynn Haven, FL 32444

4 Bed

4 Baths

3300 sqft

MLS# 765673

Just Reduced! Discover the ultimate waterfront retreat in this stunning 4-bedroom, 3.5-bath home located in the highly desirable Lynn Haven area. Nestled on a quiet street near beautiful parks, this modern masterpiece is just three years old and built to the latest hurricane codes, offering peace of mind. Situated on a high and dry lot, the property boasts breathtaking bayfront views with a private dock, perfect for boating, fishing, or simply enjoying the serene surroundings. The spacious backyard is an outdoor paradise, featuring a sparkling pool and plenty of space for entertaining or relaxing.

Inside, the thoughtfully designed split floor plan offers privacy and functionality, with the luxurious primary suite set apart from the additional bedrooms. Two bonus rooms upstairs provide flexible spaces for a home theatre, large gym, or playroom, while abundant storage ensures every item has its place. The gourmet kitchen is a chef's dream, complete with premium appliances, an oversized island, custom cabinetry, and sleek quartz countertops. The open-concept living areas are filled with natural light, creating a seamless flow between indoor and outdoor spaces.

This home also includes an oversized 2-car garage. Located in a quiet, family-friendly neighborhood close to top-rated schools and local amenities, this property combines luxury and convenience. Don't miss the chance to make this exquisite waterfront oasis your forever home—schedule your private showing today!

Listing Courtesy of CENTRAL PANHANDLE / Century 21 Allpoints Realty / Courtney Harris

$1,240,000 ^(USD)

N/A Area Multi-Family Home

Active

373 Blatchley Avenue New Haven, CT 06513

15 Bed

9 Baths

7716 sqft

MLS# 24110007

This rare 9-unit multifamily offers tremendous value-add potential and strong cash flow upside. Each oversized unit is filled with natural light and features updated kitchens and baths, with several equipped with high-efficiency Navien systems for reduced operating costs. All utilities are separate and tenant-paid, maximizing income. Several units are already rent-ready and marketed-market comps show 1-bedrooms renting for $1,350/month and 2-bedrooms for $1,600/month. The local market is strong, with a recent 8-unit sale nearby closing at $1.88M. Prime location just minutes to State Street, I-91, I-95, and Yale University keeps demand high. With large square footage, solid rental demand, and room for renovations or lease-up, this property is poised for immediate returns and long-term appreciation. Don't miss this rare chance to invest in a thriving New Haven market!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Lisa Cozzi

$1,215,000 ^(USD)

N/A Area Multi-Family Home

Pending

269 West Washington Street Bristol, CT 06010

17 Bed

9 Baths

8238 sqft

MLS# 24124984

Rare 9 unit investment opportunity in Bristol! This well-maintained property features two buildings on one lot. The front building has one 3-bedroom/1-bath unit, two 1-bedroom/1-bath units, and an attached garage (currently unused), with owner paid utilities. The brick building offers six spacious 2-bedroom/1-bath units, with tenant paid electric and owner paid oil heat and hot water. There is ample designated tenant parking and on-site coin-op laundry for added tenant convenience. Located in a quiet residential neighborhood with easy access to ESPN and highways, this is an attractive choice for tenants. With solid rental history and desirable unit mix, this property is a fantastic addition to any portfolio or for investors looking to scale in a stable market.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Maddy Ceruti

$1,200,000 ^(USD)

N/A Area Single Family Home

Active

455 Lovely Street Avon, CT 06001

4 Bed

4 Baths

3482 sqft

MLS# 24120165

Luxury living in the Farmington Valley! This ~3,500 sq ft modern farmhouse boasts an open-concept 1st floor w/ 9+ ft ceilings, wide-plank hardwood floors, and Anderson 400 windows. The gourmet kitchen has a large center island with breakfast bar, abundant storage, and modern finishes, opening to a dedicated dining space perfect for hosting or quiet family mornings. The adjoining family room, anchored by a cozy gas fireplace, is bathed in natural light; a warm, inviting space for making memories. A generous mudroom off the 3-car garage, private office/study and a half bath complete the vast 1st floor. Upstairs, the primary suite is a retreat with two walk-in closets and a spa-like ensuite featuring a wet room and soaking tub. There are 3 additional bedrooms including one with a private bath, ideal for guests, au pair or multi-generational living. A dual-vanity hall bath and second-floor laundry enhance comfort and convenience. The expansive bonus room offers endless possibilities as a playroom, home theater or fitness space. Nestled in award-winning Avon, this home combines top-rated schools, country clubs, and community charm with easy access to West Hartford, Route 44, Downtown Hartford, and Bradley International Airport. Crafted to elevate everyday living, this home is truly exceptional and not your standard new construction.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Molly Sullivan

$1,150,000 ^(USD)

Pawson Park Area Single Family Home

Active

13 Fenway Road Branford, CT 06405

2 Bed

2 Baths

1998 sqft

MLS# 24132129

Scenic home on Branford River is an ideal opportunity to be a part of a water community with amazing views and access to swimming, fishing, kayaking situated within the Linden Shores district. This two bedroom two bath cape awaits modern updating and expansion, plans from previous owners are available upon request. Property is being sold "As-Is". Driveway is located in rear of property on Pawson Road

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Vicki Imperato

$1,150,000 ^(USD)

Inlet Beach Area Single Family Home

Active

234 Grande Pointe Circle Inlet Beach, FL 32461

5 Bed

4 Baths

2914 sqft

MLS# 979048

Stunning Coastal Retreat in Grande Pointe - Inlet Beach

SELLER SAYS LET'S GET THIS SOLD! Don't miss this incredible opportunity to own a turnkey furnished coastal retreat in the sought-after Grande Pointe community of Inlet Beach. Discover this exceptional 5-bedroom, 3.5-bath home in the highly sought-after Grande Pointe neighborhood of Inlet Beach. Showcasing superior craftsmanship and thoughtful upgrades, this residence offers both beauty and efficiency, thanks to solar panels that of which have been paid in full, ensure remarkably low power bills. A home warranty is also included for added peace of mind.

Step inside to find raised ceilings, rich wood floors, an open-concept layout, and charming shiplap accents. The gourmet kitchen features a gas cooktop, and built in wall oven. The primary suite is conveniently located on the main level, just off the living area, offering privacy and comfort. Upstairs, you'll find four spacious guest bedrooms, including two that share a stylish Jack and Jill bathroom. A second living area on the upper floor provides additional space for relaxation, entertainment, or family gatherings, this would be a great space for a home theatre or a game room with a pool table and other fun activities to enjoy playing with friends and family.

Grande Pointe is a waterfront community on Lake Powell, mere minutes from 30A's world-famous beaches, dining, and shopping. Residents enjoy exclusive access to a clubhouse, community pool, and a dock, ideal for paddleboarding, kayaking, and all your waterfront adventures. Close to several public and private golf courses. The beach access is only a couple miles away!

This home is being sold turnkey fully furnished, solar panels are paid off in full, 6 seater golf cart included with an acceptable offer!

Don't miss this opportunity to own a beautifully maintained home in one of Inlet Beach's most desirable neighborhoods.
Call today to schedule your private showing! Ask me about our Investor Loan Options!!!

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Rhonda Johnson

$1,100,000 ^(USD)

N/A Area Commercial

Active

88 New Britain Avenue Rocky Hill, CT 06067

Bed

0 Baths

6054 sqft

MLS# 24121064

Investment opportunity in PRIME Rocky Hill location at 88 New Britain Avenue. Anchored by 2 well established and long term tenants, this 6000+ SQFT medical/office space is in IMMACULATE condition and welcomes new ownership. This property also features over 6000+ SQFT of unfinished basement space, divided into 2 units, with the potential to lease to add additional income and increase NOI. 88 New Britain Avenue is conveniently located and offers easy access to Interstate 91 and just 10 minutes away from Hartford.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / LJ Bunker

$999,999 ^(USD)

N/A Area Single Family Home

Active

1 Lake Louise Drive Westbrook, CT 06498

5 Bed

6 Baths

3870 sqft

MLS# 24113877

Custom-Built Waterfront Home in Coveted Lake Louise Neighborhood Welcome to this stunning custom-built home located in the highly desirable Lake Louise community, offering beautiful water views and 1/3 ownership of the lake. Enjoy peaceful waterfront living with private access for kayaking, canoeing, and more. Step inside to find gleaming hardwood floors throughout the main level and an open dining layout ideal for everyday lving and entertain. This thoughtfully designed home features 2 luxurious 1st Flr primary ensuites each with walk in closets and custom bathrooms. 1 suite offers direct access to deck via elegant French doors w/serene lake views from BR. Expansive DR w/fireplace is perfect for hosting, featuring twin sets of French doors opening to 40'x11' deck overlooking the lake. Spacious kit features granite counters, tile flrs, matching appls, lrg center island & ample cabinetry, flowing into DR. Main lvl also offers cozy den, priv study, laundry rm, 1/2 BA & direct access to att 2-car garage." LL features shaded stone patio across back of home w/direct yard & lake access-great for relaxing or entertaining. Indoor pool lvl includes sitting area & 1/2 bath for yr-round enjoyment. Upstairs offers 3 spacious BRs, full BA & bright, airy loft sitting area.and a lrg walk-in carpeted attic. Set on a prof landscaped lot, this home also includes a new oversized shed w/garage door, whole-house generator & paved drive. A perfect blend of comfort, elegance & premium waterfront li

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / David Hughes

$999,000 ^(USD)

N/A Area Multi-Family Home

Active

452 East Street Plainville, CT 06062

7 Bed

7 Baths

4608 sqft

MLS# 24124990

Amazing 8 unit opportunity in the desirable Plainville market! 2 buildings on 1 lot - this property offers a versatile mix of spacious studios, 1-bedroom apartments, and one commercial tenant. The property has ample off-street parking, a partially finished basement with future opportunities to explore and is well-located with easy access to everything the area has to offer. Several units have been recently updated with high-end finishes, providing an excellent base and opportunity to add value by bringing other units up to market rates. With tenant-paid electric utilities and a prime location close to shopping, dining, and major routes, this property is both a stable income producer and a strong growth opportunity. Don't miss your chance to own a well-positioned asset in an unbeatable location!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Maddy Ceruti

$995,000 ^(USD)

Niceville Area Single Family Home

Active

446 Marion Drive Niceville, FL 32578

5 Bed

5 Baths

3571 sqft

MLS# 972280

Big Price Drop!!! Truly Unique property - Golf Course and Lakefront home on a big lot in popular Rocky Bayou Country Club Estates. Close to everything in Niceville - schools, churches, medical, shopping, recreation and Eglin AFB. 15 minutes to Destin and world class beaches. Direct golf cart access to Rocky Bayou Golf Club next to the 10th hole green. Short ride to the Club House with restaurant, bar, and pool. Spacious and well-lit kitchen featuring a central island. Living room features vaulted ceiling with gas log fireplace and big windows. 5 bedrooms with 4.5 bathrooms. 4 bedrooms have adjoining baths. Solid surface counters in all bathrooms. Crown molding and other fine appointments throughout the home. Whole house vacuum. New garage floor just installed. Brand new roof!! Newer expansive 75 foot deck with serene view of Lake Werk. Private dock for fishing and boating. Basement apartment (lockout) with full bathroom and private entrance. Large garage with room for golf cart. $20,000 seller concession for paint refresh and flooring. No popcorn!! Call today to see.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Paul Maryeski

$995,000 ^(USD)

N/A Area Land

Active

208 State Route 37 New Fairfield, CT 06812

Bed

0 Baths

0 sqft

MLS# 24067945

Developers take notice!-Lot consept design attached, Deep holes and Perk test completed, updated survey and wetlands delineation report are attached. Perk data attached for seven lots. Perfect for a large 33.4 acre Camp, Horse farm, private estate or to develope on multiple lots. Lightly wooded and wooded areas with classic New England stone walls and stone out croppings Being the former Lollipop Stables this land is abundant with horse/ATV trails. This raw land is a perfect place to build your own 33.4 acre private estate or be developed with multiple lots Located less than six miles from I84 through Danbury also is a short ride to New York City. Note: See photo of main gate at the street, the house to left of driveway is not part of this property. See attached documents for map and survey. Town of New Fairfield zoning is 3 acre min per buildin lot there is a large mix of open land, wooded and ledged throughout this property. SEE ATTACHED SURVEY, MAPS AND DOCUMENTS-

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / David Hughes

$989,900 ^(USD)

N/A Area Single Family Home

Pending

73 Hannah Lane Monroe, CT 06468

4 Bed

4 Baths

3772 sqft

MLS# 24123350

Tucked away at the end of a quiet cul-de-sac and backing up to protected open space, this exceptional four-bedroom, four-bathroom home offers an unmatched blend of privacy, luxury, and comfort in one of Monroe's most desirable neighborhoods - all within the boundaries of award-winning schools. The moment you step outside, you're greeted by a true backyard oasis. The in-ground heated pool with a tranquil water feature is surrounded by beautifully landscaped gardens, a dedicated play area, a vegetable garden with garden shed and lush open space that provides both serenity and seclusion. Whether you're entertaining guests or enjoying a quiet afternoon by the pool, this yard offers the perfect setting for outdoor living at its very best. Inside, the heart of the home is the stunning kitchen - a true showstopper for culinary enthusiasts and entertainers alike. Featuring commercial-grade appliances, pot filler over the range, custom cabinetry, an expansive center island, walk-in pantry, and a peninsula large enough for everyone's breakfast adjacent to the coffee bar means mornings will be a breeze. This space leaves nothing to be desired. The open-concept design flows seamlessly into a spacious great room with a cozy gas fireplace, creating an inviting environment for gatherings of all sizes. Currently, two of the home's flexible rooms are being used as a billiards room and a craft room, but they can easily transition into formal dining or living spaces to suit your needs.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Stacy Pfannkuch

$950,000 ^(USD)

Shippan Area Single Family Home

Active

1814 Shippan Avenue Stamford, CT 06902

3 Bed

3 Baths

1501 sqft

MLS# 24132447

Shippan Colonial near the Point. Walk to the water down Hobson is only 3/10 of a mile. Seasonal water views. Professionally landscaped with fenced rear yard. Separately fenced garden area. The generous size kitchen has been updated to include Sub-zero refrigerator, Bosch Dishwasher and Wolfe range and Hood. With the Center Island, there is ample cabinets and counter space. The oversized one car garage provides ample storage for garden equipment. The full clean basement is kept dry with a curtain drain and sump pump. The present owners installed Central Air and an emergency Generator. They have loveingly maintained this home for 40 years.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Louise Petersen

$950,000 ^(USD)

N/A Area Multi-Family Home

Active

1259 Wolcott Road Wolcott, CT 06716

12 Bed

4 Baths

3281 sqft

MLS# 24127105

Welcome to 1259 Wolcott Road - a turnkey six-unit multifamily residence offering the perfect combination of modernized interiors and extensive capital upgrades. Inside, four of the six apartments have been tastefully updated with new flooring, refreshed bathrooms, upgraded appliances, energy-efficient windows, enhanced electrical systems, fresh paint, new cabinetry, and interior doors. The property's recent exterior enhancements include rebuilt front and back staircases and decks, new walkways, a re-graded gravel parking area, a brand-new oil tank, boiler room upgrades, roof repairs, and refreshed exterior finishes. The grounds are neat, well-kept, and easy to maintain. With these major updates already completed, this low-maintenance investment offers stable income potential and long-term durability-an excellent opportunity for both investors and owner-occupants seeking a reliable asset in a strong rental market.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Tyler DeVecchis

$925,000 ^(USD)

Diamond Lake Area Single Family Home

Active

1667 Diamond Lake Road Glastonbury, CT 06033

4 Bed

5 Baths

3205 sqft

MLS# 24130550

DON'T MISS THIS OPPORTUNITY! Step into refined living with this stunning 4,200+ SF residence where design and comfort meet. From the moment you enter, soaring ceilings and sunlit spaces set the tone for elegance. At the center, an exquisite new chef's kitchen showcases quartz counters, professional-grade appliances, an oversized island, coffee station, and custom banquet-flowing into a dramatic great room framed by windows and fireplace.The upstairs primary suite is a true sanctuary with a sitting room, dual walk-in closets, and spa bath. Additional ensuite and Jack-and-Jill bedrooms create private retreats for family or guests. A finished lower level (1,000+ SF) extends living space for a theatre, fitness studio, office, or guests. Timeless updates include a new A/C system, refreshed baths, fresh paint, and invisible dog fencing. Outdoors, the 750SF paver patio and serene yard overlook preserved open space-perfect for sophisticated entertaining or quiet mornings with sunrise views. With three fireplaces, a flexible first-floor office/5th bedroom, and a 3-car garage, this home balances practicality with prestige. This home delivers elegance, comfort, and lifestyle in one extraordinary package. Reach out today to schedule your private showing.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Bonnie Call

$919,000 ^(USD)

Inlet Beach Area Multi-Family Home

Active

336 Milestone Drive Unit B Inlet Beach, FL 32461

3 Bed

3 Baths

1677 sqft

MLS# 969477

$5K SELLER CONCESSIONS TO USE FOR CLOSING COSTS, RATE BUYDOWN (WITH LENDER APPROVAL) OR PREPAIDS WITH FULL PRICE OFFER!

30A LIVING!! SOPHISTICATED LUXURY MEETS MODERN ELEGANCE- Exquisite luxury townhome, where top-of-the-line design and impeccable style come together to create the ultimate living experience. From the moment you step inside you are greeted with an open-concept layout that seamlessly blends spaciousness and sophistication, perfect for both relaxation and entertaining. Every detail has been carefully curated, from the high-end finishes to the designer lighting and sleek custom cabinetry. There is a gourmet, chef's kitchen complete with premium appliances, quartz countertops and oversized island. High ceilings, and elegant decor offers a seamless flow throughout. Located in the well sought-after community of Prominence 30A. Just steps from the vibrant amenities of The Big Chill, and offering easy access to 30A's renowned beaches, dining, and boutique shopping, this home is perfectly positioned for a relaxed yet upscale coastal lifestyle. Enjoy the luxury and convenience of two resort style pools, a well equipped fitness center, and the convenience of community trolley that can take you to the pristine beach access at Deer Lake State Park, less than a mile away!
Nature enthusiasts and trail lovers will appreciate the trails this state park affords!
Don't miss this opportunity to own a slice of paradise in one of the most sought-after locations on 30A. Schedule your private tour today! Sold Turnkey Fully Furnished with a 2022 6 seater golf cart with an acceptable offer! Ask me about Investment Loan Options!

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Rhonda Johnson

$875,000 ^(USD)

Tanglewood Area Single Family Home

Active

813 Saint Andrews Blvd Naples, FL 34113

3 Bed

3 Baths

2584 sqft

MLS# 225045819

'Seller Motivated This beautifully renovated single-family home has a great west facing sunset views making this prime property a unique hidden gem. Upon entering, one will encounter a light and bright open concept living and dining area with high ceilings. The gourmet chef’s kitchen includes a large island and breakfast bar, white shaker-style cabinets, quartz Countertops and matching quartz Backsplash as well as all stainless steel appliances. The entire home features beautiful tile flooring, modern baseboards and trim. Additionally, the baths have been fully updated, and the home has been painted with new light and plumbing fixtures installed. The primary bedroom is generously sized, featuring two walk-in closets and sliding doors that lead to the lanai. The guest bedrooms are positioned on the opposite side of the home for privacy. Enjoy your morning coffee or evening cocktails from the expansive screened lanai with pool and spa offering quiet serene tranquility views of the lake and golf course views / preserves that are often visited by deer. The New impact sliders and doors installed in 2024, along with manual shutters for most windows, providing peace of mind. This property is conveniently about six miles from downtown 5th Avenue Naples, offering easy beach access, boating, shopping, dining and more. Don’t miss this wonderful opportunity to start living in paradise today. Items that I have fixed in the house or replaced.
2 ton AC unit replaced
New pool pump
New gutters throughout the house
Ventless dryer
New screens in the lanai area
New impact sliders and kitchen window
New lanai fans
Landscaping
New flooring in the second guest bedroom
Fresh paint throughout the kitchen and bedroom bathrooms
New appliances
New cabinets in laundry room.
New custom window treatments in the family room as well as the two guest bedrooms.

Items to leave in the house
Family room furniture, except for the bar hutch
Master bedroom set
Lanai sitting area
Outdoor dining set
Two wicker chairs in the lanai
Kitchen counter, chairs, set of six
Refrigerator in the garage
The hutch in the garage
The second guest twin bedroom set
TV in the formal area

Listing Courtesy of SWFMLS / Century 21 Allpoints Realty / Richard "Rich" Kasparian

$859,900 ^(USD)

Santa Rosa Beach Area Single Family Home

Active

101 Sweet Breeze Drive Santa Rosa Beach, FL 32459

3 Bed

2 Baths

1808 sqft

MLS# 985223

This charming 3-bedroom, 2-bath beach home is nestled in a gated community located near Shunk Gulley, Gulf Place, and the Ed Walline Beach Access, placing shopping, dining, and our gorgeous white-sand beaches right at your fingertips.

The split-bedroom floor plan ensures privacy, with the primary suite tucked away at the back of the home, while the open-concept main living area offers the perfect setting for entertaining, relaxing, or enjoying meals together. This home boasts a newer A/C as well as a new stainless steel french door refrigerator (2024), all adding to the comfort of this well-cared-for home.

What makes this property special? Backing up to a protected nature preserve, the home offers a private and tranquil setting where you can bask in the sun while observing all forms of nature & birdwatching while enjoying the Florida breeze. The recently added outdoor space has been thoughtfully designed for comfortable gatherings, featuring fresh brick pavers, custom landscaping, two oversized swings, and plenty of seating around a firepit and BBQ area. When not at the beach, enjoy the massive resort style swimming pool featuring gated access, stone boulders with swim shelves & intimate enclaves with numerous waterfalls thus making it an amazing water experience for you and your guests.

With a durable hardie board & partial brick exterior, as well as easy pull-down Hurricane window & door shutters, this beach retreat combines beauty and peace of mind, making it the perfect second home or coastal escape.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Cheryl Gustavson

$850,000 ^(USD)

Huntington Area Single Family Home

Active

15 Windy Acres Drive Shelton, CT 06484

4 Bed

3 Baths

2363 sqft

MLS# 24124162

This custom-built, center-hall Colonial combines timeless design with thoughtful updates - and it is in move-in condition ready for you to enjoy from day one. The main level features a beautifully remodeled open-concept kitchen, dining area, and family room - the perfect setting for everyday living and entertaining. A formal living room with a stunning fireplace, a formal dining room, a private home office (or possible optional 5th bedroom), and a stylishly remodeled half bath provide versatility and comfort. Added to all this is a mudroom entry from the attached two-car garage which includes full walk-up attic storage. Upstairs, you'll find 4 spacious bedrooms and 2 newly remodeled full baths featuring fresh, designer finishes. Rich hardwood floors and custom millwork throughout the home adds warmth, character, and craftsmanship rarely found in newer builds. The walk-out lower level includes a 2nd fireplace, designer ceiling beam, and direct access to a lower patio, offering excellent potential for additional living space, or an in-law set-up. Set at the end of a quiet cul-de-sac, the private one full acre property is a gardener's dream - rolling lawn, mature plantings, colorful established gardens with flowers galore, stone walls, woods, and walking paths. Outdoor living is enhanced by a large bluestone patio bordered by a custom-built stone wall. A matching bluestone front walkway and entry steps provide a gracious welcome.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Gary Dobratz

$849,900 ^(USD)

N/A Area Single Family Home

Active

565 Lincoln Street New Britain, CT 06457

3 Bed

3 Baths

3167 sqft

MLS# 24084488

Meet the "ATWATER" Imagine waking up each morning to breathtaking views of the prestigious Shuttle Meadow Country Club, with the serene 7th hole right at your doorstep. This stunning property, artfully designed by the renowned Meehan Group, offers a unique opportunity to own a piece of paradise. Key Features: Prime Location: Situated on the picturesque 7th hole, this home boasts unobstructed views and direct access to the golf course. Custom Design: Crafted with precision and style built by Coccomo, ensuring a blend of elegance and functionality. Future Home: This is your chance to make this wonderful home-to-be truly yours. Work with the Meehan and Coccomo to customize every detail, from colors to finishes, to create your dream home. Lifestyle Benefits: Golf Enthusiast's Paradise: Enjoy the ultimate golf lifestyle with easy access to the course and clubhouse amenities. Nature's Beauty: Surrounded by lush greenery and scenic views, this property is a haven for those seeking tranquility and luxury. Don't miss this rare opportunity to own a piece of Shuttle Meadow Country Club's prestige. Schedule a meeting today and make this stunning property your forever home! Builder related to agent

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Thomas Coccomo

$849,000 ^(USD)

Indian Neck Area Townhouse

Coming Soon

74 Quarry Dock Road 74 Branford, CT 06405

2 Bed

3 Baths

1818 sqft

Luxurious 2 Bedroom, 2.1 bathroom end unit condo in the Sylvan Point complex spans 1,818 square feet of meticulously renovated water view living space. Perched with enviable river views of Branford River and the adjacent marinas, this residence offers a seamless blend of contemporary design and upscale finishes. Every detail from the new sheetrock to new hardwood flooring has been thoughtfully updated to create a timeless, sun drenched home that exudes sophistication. Step into an expansive, open concept living space. Adjacent to the living area with focal fireplace, the brand new modern kitchen with high end appliances, with oversized island and eat in kitchen area serves as entertaining area for guests. The main floor primary bedroom has a cozy fell with fireplace, his and her closets and an elegant ensuite primary bathroom complete with jacuzzi bath. The second upstairs bedroom and guest bathroom have been equally well appointed with a contemporary feel. The residence includes a modern powder room and first floor laundry with state of the art all in one energy efficient washer/ dryer. This condo comes with a one car underneath garage with an extra storage area. Sylvan Point Residents enjoy premium amenities including a heated pool, clubhouse, tennis and pickleball courts, and kayak racks with direct river access. Come and enjoy the waterfront lifestyle, proximity to dining and marinas and turnkey luxury living.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Lisa Liscio

$840,000 ^(USD)

N/A Area Single Family Home

Active

941 Constitution Boulevard North Shelton, CT 06484

4 Bed

4 Baths

2954 sqft

MLS# 24113885

Nestled in the desirable Old Dairy Estates, this custom colonial is the perfect blend of comfort, functionality, and fun! The spacious eat- in kitchen flows seamlessly into the family room with soaring ceiling and cozy fireplace. Front to back living room and dining room provide the ideal gathering spaces. A first floor office and full bath complete the main level. The upper level offers a generous sized primary bedroom with en-suite, 3 additional bedrooms, full bath,laundry and ample storage for convenience. Expansive walkout lower level features high ceilings, a gas fireplace, a workout area, sitting room, half bath, and plenty of storage with direct access to the private backyard. Enjoy relaxing on the large deck, take a swim, gather at the fire pit, practice pickle ball, and end the day with an outdoor shower!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Lisa Valenti

$829,000 ^(USD)

Imagine Living Here

Active

343 Oaklake Lane Niceville, FL 32578

3 Bed

2 Baths

2403 sqft

MLS# 987235

Imagine Living Here. Imagine the Possibilities. This 3-bedroom, 2-bath, 2,403 sq. ft. home offers the rare blend of lifestyle, space, & future potential—situated on one of Bluewater Bay's largest cul-de-sac lots. Extensively updated from 2019-2024 with hurricane-impact windows, new roof, Trane HVAC and ducting, copper wiring, spray foam insulation, & a hurricane-rated garage door. Inside features quartzite countertops, solid maple cabinetry, vaulted ceilings, & a luxurious master suite with whirlpool tub & dual shower heads. Enjoy a Florida room, screened porch, paver driveway, & fresh landscaping with irrigation. Zoning may allow a pool, pool house, or garage apartment (buyer to verify). Bluewater Bay amenities include marina access, waterfront dining, pools, golf, tennis, & pickleball.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Kenneth Wright

$824,000 ^(USD)

North End Area Single Family Home

Active

20 Brinsmayd Avenue Stratford, CT 06614

4 Bed

5 Baths

2814 sqft

MLS# 24131180

MAGNIFICENT Ranch Retreat. Prepare to be swept away by this truly special, custom-crafted ranch-style masterpiece, a home that radiates elegance, comfort, and charm at every turn. From the moment you arrive, this unique & extraordinary property makes its presence known, with a newly gated driveway, exquisite stone steps, & breathtaking professional landscaping that frames the home like a work of art. Step inside & feel the wow factor of over 2,800 square feet of refined living space on the main floor (not including the fully finished lower level!). At the heart of the home, a designer kitchen - fully outfitted with high-end finishes, custom cabinetry, & expansive counters that will ignite your inner chef. All of it flows seamlessly across gleaming hardwood floors into sun-drenched living areas designed for both celebration & serenity. Dual primary suites - one at each end of the home create an ideal layout for multi-generational living, guests, or those who crave space and privacy. In total, enjoy 4 generously sized bedrooms and 3 luxurious full baths on the main floor. The finished LL is a retreat all its own, complete with a game room, private gym or office and guest room, with a full bath. Whether you're entertaining, working, or unwinding, there's a perfect place for it here. Regarding mechanicals, Natural gas heat, a whole house generator, 2 hot water heaters & C/A, you can move right in. For the car enthusiast or hobbyist, the home offers not just one, but TWO garages

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Stacy Pfannkuch

$800,000 ^(USD)

N/A Area Commercial

Active

93 East Main Street Plainville, CT 06062

0 Bed

2 Baths

2944 sqft

MLS# 24097797

This Popular Local Eatery / Pizza Location has been in business at it's current location since 2000 and down the street for many years before this. Serving a full menu of favorites. PLEASE DO NOT TALK WITH STAFF, BARTENDERS, OR THE OWNER IF YOU VISIT TO HAVE A MEAL. ALL QUESTIONS TO THE LISTING AGENTS

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Jay Steeves

$799,999 ^(USD)

N/A Area Commercial

Active

497 Winthrop Road Deep River, CT 06417

0 Bed

4 Baths

1550 sqft

MLS# 24094162

Small strip plaza consisting of 3 retail spaces, two garages(rented separately) a single family ranch with garage/storage (rented separately). all situated on 4 acres. Two of the spaces have longer term leases and the single family is yearly. Two beautiful ponds with picnic tables to enjoy your lunch and watch the beautiful blue heron at their nest in the rear of the property. Property is located on a state road which has a good traffic count per day. Many updates and renovations have been done to the property within the past 6 years. Come visit.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Kathleen Thuerling

$799,900 ^(USD)

N/A Area Commercial

Active

7 Liberty Drive Hebron, CT 06248

0 Bed

7 Baths

7380 sqft

MLS# 24094182

Excellent Investment Opportunity. Fully Leased Mult 5 unit commercial building in the heart of Hebron's Main Street Business District! Prime Location with excellent visibility and traffic count! Situated on .79 Acre land parcel with 44 parking spaces with great pedestrian access by extensive town and on-site sidewalk system! Well Maintained 7380 SF Building with several long term established businesses comprised of a mix of professional office space, fitness center, barber shop, and retail/service tenants.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / James "Jim" Celio

$799,900 ^(USD)

Splash Condo Area Condominium

Active

17739 Front Beach Road 401W Panama City Beach, FL 32413

3 Bed

3 Baths

1702 sqft

MLS# 777071

*** LOW FLOOR ALERT *** This is the low floor unit that you've been waiting for ! Finally a property that checks all the boxes : LOW Floor Unit, End Unit, all bedrooms gulf-front, and LOW quarterly condominium dues of $2277.00, all within a Resort atmosphere on the coveted ''West'' end of PCB, but just two miles West of Pier Park and the heart of PCB ! ! IF wait times for elevators are ever longer than you'd like, this 4th floor condominium makes using the stairs a breeze to get down to the beach, pool or Lobby floor. This 4th floor Splash Resort three bedroom and three full bath condo won't be on the market for sale very long. Each bedroom is facing the beach and Gulf, featuring its OWN balcony creating more privacy and special moments overlooking the sugar white sand and emerald Gulf water. The flexibility this turn-key rental ready ''lock-out'' style condo offers is second-to-none, as it can be rented as a three bedroom condo, OR rented individually as a two bedroom two bath, and a separate one bedroom one bath suite with kitchenette. Everything you see stays including the furnishings, kitchen package, linens and Kaba brand front door lock. Splash is a wonderful ''resort'' property with multiple swimming pools, splash pad, ''water park'' for the littles, lazy river feature, Coco Loco's poolside food and beverage, full snack-bar on the lobby floor with food and beverage, fitness center, and even community grills to make dining in convenient. Splash's unique on-site owner maintenance program truly makes self-management of the rentals by Owners easy. Call to set up your personal showing of this phenomenal property today. Strong consistent rental income history, with even more potential income to be had. Room measurements taken from Developers floor plans, if important to the Buyer please verify.

Listing Courtesy of CENTRAL PANHANDLE / Century 21 Allpoints Realty / Allison Albano

$799,000 ^(USD)

Freeport Area Single Family Home

Active

68 Hemingway Lane Freeport, FL 32439

6 Bed

4 Baths

4298 sqft

MLS# 972735

If your family is looking for a large home, this is the perfect place for you. This six bedroom 3 1/2 bath home features many upgrades, including fireplace, high ceilings, eat in kitchen with walk-in pantry and island. Gas Stove.There's a balcony from the second floor overlooking the living room. Wall to wall carpeting in the bedrooms. Additional study and separate dining room. Game room and Fence to backyard. Hammock Bay is a great place to raise your kids. Has large clubhouse with swimming pool, exercise room, playground, and sports Center, Neighborhood country store, pub and many other amenities.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Victoria Hughes

$775,000 ^(USD)

N/A Area Single Family Home

Active

1498 Little Meadow Road Guilford, CT 06437

4 Bed

3 Baths

2600 sqft

MLS# 24066933

Welcome to 1498 Little Meadow Road-a quintessential center-hall colonial set on nearly two peaceful acres in one of Guilford's most desirable neighborhoods in one of New England's best towns. This home offers the perfect blend of space, privacy, and timeless charm, just minutes from the shoreline, shopping, and the Guilford Green designated as a National Historic Landmark. If you like the outdoors, Guilford has great trails - Westwood Trails with over 39 miles of hiking at all levels, or East River Preserve with 7 miles through meadows over a stone bridge perfect for families - both within minutes of this home. Or maybe an early round at the Guilford Lakes Golf Course, just 3.6 miles away is a 9-hole par-3 course recognized as the #1 par-3 golf course in New England for its playability and maintenance. New Haven is only 20 minutes away for pizza, museums or shopping. Come see this warm and welcoming, perfect for everyday life and entertaining. The kitchen features premium Wolf and Sub-Zero appliances-a rare find at this price point. The backyard is a true highlight. With almost two acres of open, usable land, there's more than enough space for family outdoor activities, pets to roam, or maybe even add a vegetable garden and a chicken coop. The deck is great for relaxing or hosting friends and family. A peaceful setting offers a feeling of retreat while still being close to everything you need.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Janet Colello

$775,000 ^(USD)

N/A Area Commercial

Active

740 Enfield Street Enfield, CT 06082

0 Bed

8 Baths

5638 sqft

MLS# 24026131

Great Property 4,000 Sq. Foot Brick commercial Building. New Roof On Building. Great Corner Location. The 5 apartment building Next Door is included in sale with includes Two Small Store Fronts. All Rented. Good Tenants. One Car Garage Out Back. And 3 Car Garage. Driveway On Route 5 And Alden Ave. Parking In Front And Parking In Rear. Town Owns Small Rectangular Piece On The Corner. Great Income. City Water And City Sewer. Property To Be Sold AS IS. Taxes Per Year $10,345.46. Water Bill Every 3 months $332.13. Electric Landlord $61.16 Per Month. Owner of CT Tenants Pay All Utilities. Landlord Pays Water and Sewer.This 4,000 Sq Ft Building Has Central Air, Many Uses Warehouse,Storage.Call Town Great Place To Start Your New Venture.And Get All The Rents To Help Pay .Owner Retiring After 50 Years.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Henry Foley

$769,000 ^(USD)

Moodus Area Single Family Home

Active

154 Falls Road East Haddam, CT 06469

3 Bed

3 Baths

1165 sqft

MLS# 24083525

Beautiful direct waterfront home on Moodus Lake. Fully renovated 1925 Farmhouse with a bright open concept & layout. The stunning "Cooks Kitchen" with panoramic view of the lake, includes state of art appliances including double wall convection ovens & air fryer, large center island with gas cooktop, Microwave drawer, open beam cathedral ceiling and Breakfast Nook with slider to a large deck facing the lake. The living room has a gas fireplace and 9 foot sliders out to the deck with stunning views of the lake and waterfall. There is also a first floor bedroom, a full bath and Dining Room plus a study area just off the main Foyer. The second floor has the Primary Bedroom with walk-in closet, stunning full bath and views of the lake. There is also a third bedroom and an additional half bath as well. The front of the house features a beautiful stone wall, landscaping and a brick walkway. The back yard slopes gently down to the water with lots of grassy area to host friends and family for summer get togethers. Just a short 11 minute drive to The Goodspeed Opera House plus local eateries including the Gelston House Restaurant right on the Connecticut River. It is also just a short drive to Route 9 for access to many other shoreline communities and activities. This Moodus Lake location also includes a Town Beach with playground and two boat launches. The septic system is new as well. New Well and new 4 bedroom capable septic system.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Peter Allam

$759,900 ^(USD)

Ludlow Area Single Family Home

Active

1172 East St Ludlow, MA 01056

3 Bed

3 Baths

2500 sqft

MLS# 73390873

This custom-built 3-bedroom, 3-bath Ranch offers exceptional living with high-end finishes and thoughtful design throughout. The kitchen features rich cherry cabinets, granite countertops, and a double oven, ideal for both everyday use and entertaining. A formal dining room and a spacious living room with a fireplace provide elegant gathering spaces, while gleaming hardwood floors flow throughout the main level. For added convenience, the laundry room is on the main level. Enjoy year-round comfort with central air and the convenience of central vacuum. The finished lower level boasts 1,350 sq. ft. of additional living space, including a bedroom area and full bath—perfect for a potential in-law apartment. Additional highlights include a whole house generator, professionally landscaped grounds with stone wall entry, concrete driveway, fully fenced backyard, deck with an awning, a gazebo, sprinkler system and much more.

Listing Courtesy of MLS PIN / Century 21 Allpoints Realty / Lori Kroh

$759,900 ^(USD)

Players Cove Area Single Family Home

Active

8069 Players Cove Dr 101 Naples, FL 34113

3 Bed

3 Baths

2091 sqft

MLS# 225073137

Welcome to Paradise in Players Cove at Lely Resort! Stop dreaming and start living the Lely
Life in this spectacular, turnkey-ready, ground-floor condo. Positioned to capture magnificent
lake views from every angle, this 3-bedroom, 2.5-bath gem in Players Cove has been
thoughtfully refreshed for immediate enjoyment. The interior boasts brand-new paint, ensuring
a crisp, clean welcome, while the primary closet has been transformed with custom
organization—a detail you will appreciate daily. Practical luxuries include a newer AC for
effortless comfort and a small bar with a beverage fridge ready for your next gathering. The
roofs are only 4 years old and exterior paint on the buildings is fresh. As a resident, you unlock
the doors to the famed, Eight-time Club of the Year Players Club & Spa. Imagine your
weekends spent by the cascading 22-foot waterfall pool, enjoying drinks at the tiki hut, or
challenging friends on the premier tennis and pickleball courts. With gourmet restaurants, a state-
of-the-art fitness center, a full spa, and three championship golf courses all at your fingertips,
you're not just buying a condo—you're securing a life of unparalleled resort amenity and Naples
bliss. LIVE THE LELY LIFE TODAY!!

Listing Courtesy of SWFMLS / Century 21 Allpoints Realty / Julie Cologero

$749,000 ^(USD)

Nichols Area Single Family Home

Active

2945 Huntington Road Trumbull, CT 06611

4 Bed

3 Baths

2408 sqft

MLS# 24113373

AMAZING DEAL!!! This remarkable ranch-style home has captivating features. Great interior layout, great outdoor space. As you enter, you'll be greeted by a spacious bright living room with fireplace. Updated kitchen, inspiring the chef in you with the new Kutcht professional gas stove and well-designed layout complete with ample cabinets and counter-tops. Adjacent to the kitchen, the dining room opens up to a secluded patio area, providing the perfect ambiance for morning coffee, afternoon tea/cocktails or post-meal conversations. This residence seamlessly blends indoor and outdoor areas perfect for entertaining. Three generously proportioned bedrooms, including an upgraded primary bedroom with an en suite bath. Additionally, an in-law suite awaits, featuring its own dining and living spaces, a bedroom, and a full bath. Enjoy the convenience of a separate entrance and a delightful three-season porch. Descend to the lower level to discover an additional living area, adding versatility to the home's offerings. New Shed with electricity that owners use as an art studio/workshop. Composite deck, Roof 3 years old, new boiler and water heater, Every aspect of this property is poised to accommodate the needs of its new occupants for many years to come.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Maria Garcia-Gonzalez

$745,000 ^(USD)

Manatee Cove Area Single Family Home

Active

2076 Yellowfin Cir Naples, FL 34114

3 Bed

2 Baths

2076 sqft

MLS# 225072830

Beautiful 3 Bedroom/2 bathrooms plus den located in the highly sought after community of Manatee Cove! No CDD and low assessments! Located within walking distance to Manatee elementary and middle schools. Manatee is a gated community and the home is on a large lot which provides privacy and space. The garage is 4-ft extended air-conditioned. The home boasts 2,076 square feet of pure enjoyment offering you the perfect blend of modern luxury, sophistication, and functionality. This open floor plan and split bedroom layout keeps everyone connected while respecting personal space. The gourmet kitchen dazzles with top-of-the-line Kitchen Aid appliances, gas range with hood, double convection oven, 42” cabinetry with under-cabinet lighting, large island with extra storage, and a spacious walk-in pantry—this kitchen is the perfect backdrop for the culinary enthusiast. The primary suite has the space to be the private sanctuary you deserve, featuring a spa-like bathroom with double vanities, frame-less glass shower, and a spacious walk-in closet. Guests and family will appreciate the two generously sized bedrooms and a den which can be a great place to home office or an extra bedroom. Zero-corner sliders open to an expansive screened lanai, ideal for entertaining or relaxing, complete with an large heated saltwater pool with a fountain and automatic draining system, ample covered seating with space for an outdoor kitchen. Pet owners will appreciate the option to add a fence. Luxury Vinyl Plank flooring, crown molding, recessed lighting, custom motorized blinds, 8-ft solid-core doors, and tray ceilings flow throughout the home adding elegance at every turn. Centrally located to both downtown Naples and Marco Island.

Listing Courtesy of SWFMLS / Century 21 Allpoints Realty / Richard "Rich" Kasparian

$739,900 ^(USD)

Ludlow Area Single Family Home

Active

235 James St Ludlow, MA 01056

3 Bed

2 Baths

3462 sqft

MLS# 73426321

Discover this magnificent 3-bedroom, 2-bath mini castle tucked away on a cul-de-sac, offering the perfect blend of charm, comfort, and modern luxury. Step inside to find an updated kitchen with a center island, ideal for both everyday living and entertaining. Features include Great Room with pellet stove and sliders to patio, formal dining room, living room with fireplace and sliders to patio and first floor primary also with sliders to the deck. This unique home is packed with upgrades—too many to list—including a new septic system, roof, central air, whole house propane generator and solar panels for added efficiency. Engineered wood flooring and hardwood throughout. Cozy up by one of the three fireplaces or enjoy summer days by the stunning built-in pool surrounded by beautifully landscaped grounds, amazing stone work, two patios and a deck. Abuts the State Forest for additional privacy. A rare gem that combines timeless character with thoughtful updates.

Listing Courtesy of MLS PIN / Century 21 Allpoints Realty / Lori Kroh

$739,000 ^(USD)

Glenbrook Area Single Family Home

Active

71 Deleo Drive Stamford, CT 06906

2 Bed

2 Baths

1357 sqft

MLS# 24129919

Tucked away on one of the last homes at the end of a quiet, sought-after cul-de-sac in Glenbrook, this versatile 2-3 bedroom Ranch is full of potential and ready for its next chapter. Step inside to a warm and inviting living room - a perfect spot to relax by the fireplace. The spacious family room, featuring vaulted ceilings, creates an ideal space for gatherings, entertaining, or simply unwinding. A bright, eat-in kitchen includes a breakfast bar and opens directly to a private, fenced-in patio - perfect for enjoying peaceful mornings or quiet evenings. Additional room off the family room offers flexibility as a third bedroom, home office, or dining room. Additional features include gleaming hardwood floors, a full basement and attic for extra storage, and an attached one-car garage. All this, just minutes from the train, shopping, restaurants, and I-95. Enjoy both privacy and convenience - and discover the tranquility of living on a true dead-end street. Come see the possibilities! Upgrades: Roof approximately 7 years old, siding about 5 years old, new gutters 2 years old, new fenced yard, fresh paint almost through the home, brand new kitchen appliances, new water heater 2 years old, and brand new garage door and outdoor stairs.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Elke Seperak

$739,000 ^(USD)

Academy Hill Area Single Family Home

Active

58 Academy Hill Terrace Stratford, CT 06615

4 Bed

3 Baths

2533 sqft

MLS# 24132422

Welcome to 58 Academy Hill Terrace on a quiet cul-de-sac in the heart of Stratford's Historic District. This quintessential barn red saltbox-style Colonial overlooks the salt marsh and views of the Housatonic River. On the main level is a large living room with wood-burning fireplace, home office/den, family room with wood-burning fireplace, separate dining room with bowed bay window, remodeled kitchen and laundry room. On the second level is the primary bedroom, 2 other bedrooms, an over-sized cedar closet, and a remodeled bathroom with walk-in shower. The third level has a generous-sized bedroom, an adjoining study with built-in bookshelves and a full bath as well as storage under the eaves. All three of the living levels have oak hardwood floors. A one car attached garage (former inside door connecting to garage is now a closet), a rear slate patio and storage shed complete the main level. On the lower garden-level is an in-ground pool (now covered). This property is a short walk to MetroNorth, bus service, the public library, Sterling Community Center, restaurants, marinas, a private school and churches. Enjoy Stratford's two public beaches on Long Island Sound, the public golf course and tennis courts at Short Beach and Roosevelt Forest in the north end for hiking and biking trails. Close to I-95 and the Merritt Parkway.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Emily O'Connor Karolyi

$736,500 ^(USD)

Freeport Area Single Family Home

Active

120 Darrell Court Freeport, FL 32439

4 Bed

4 Baths

2403 sqft

MLS# 981514

BRING ALL OFFERS!!!! Tucked away in a quiet corner of Choctaw Beach, this private lakeside retreat is a dream come true for nature lovers and avid anglers alike. Welcome to 120 Darrell Court - a peaceful, two-story escape with stunning water views and a lifestyle built around relaxation, recreation, and privacy.

The main home offers 3 spacious bedrooms and 3 full bathrooms, designed with both comfort and functionality in mind. Two upstairs bedrooms open directly onto a balcony overlooking the lake—the perfect spot to enjoy your morning coffee or unwind with a sunset view Downstairs, a screened-in porch lets you take in the serene setting in comfort, while the attached two-car garage provides ample space for vehicles, gear, and storage.

Step outside to your personal outdoor haven: a refreshing saltwater pool, perfect for cooling off after a day of fishing or boating. Just steps away, the guest house offers incredible flexibility ideal as an in-law suite, pool house, or private retreat for visiting friends and family.

Soak in the peaceful lake views from your newly built dock, perfect for morning reflections, sunset watching or casting a line. And for even more adventure, you're just minutes from Bay Front Park, featuring a free public boat launch serving as a gateway to the bay and gulf.

Whether you're casting a line in the nearby waters, enjoying the breeze from the back porch or balcony, or relaxing in your own poolside sanctuary, this property captures the best of Florida Panhandle living: peaceful, picturesque, and full of possibility.

Don't miss this rare opportunity to own a slice of secluded paradise.

-Shingle Roof (18K) will be replaced before closing with acceptable offer (buyer can choose color).

-Owner offering 10K credit to replace pool plaster with acceptable offer along with replacing the water heaters.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Hector Gonzalez

$725,000 ^(USD)

Cranbury Area Single Family Home

Active

27 Stonecrop Road Norwalk, CT 06851

4 Bed

2 Baths

2434 sqft

MLS# 24105569

Expansive 4 bedroom, 2 bath ranch in the sought-after Cranbury section of Norwalk is ready for backyard BBQs, poolside lounging, and unforgettable gatherings. Enjoy a spacious layout with a bright, sunny kitchen featuring skylights, a large living room, and a generous family room - ideal for entertaining. Step outside onto the beautiful brand-new oversized deck accessible from both the family room and primary suite, overlooking your level yard and private in-ground pool. Located on a quiet street, this stylish single-level with a new roof and hardwood floors awaits your personal touches. Welcome home!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Cheryl Farley

$725,000 ^(USD)

South Meriden Area Commercial

Active

854 Hanover Road Meriden, CT 06451

0 Bed

1 Baths

2160 sqft

MLS# 24133722

Liquor Store Business with Real Estate for sale on Busy Hanover road sitting on .32 ac lot . High visibility & strong demographics well known store in community .Present owner Successfully operated over 15 year many upside Potential with online present .Liquor Store Business with All fixtures , Security camera , POS , Walking Cooler included on Asking price Inventory is not Included in Asking price ,Not to be missed opportunity at this location .

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Dhaval Patel

$699,999 ^(USD)

Chippens Hill Area Single Family Home

Pending

335 Pennwood Place Bristol, CT 06010

4 Bed

3 Baths

3609 sqft

MLS# 24122122

Welcome to 335 Pennwood Place! This beautifully maintained home offers comfort today and room to grow tomorrow. Highlights include a bright, open layout, spacious Family room with teak wood accent wall open to living room making this a front to back space, dining room open to eat-in kitchen for big family gatherings, and a first-floor office to make working from home a pleasure. Upstairs, 4 generously sized bedrooms include a primary suite. 3 full baths. Loads of closet space including 3 walk-in's. Enjoy endless expandable potential with an unfinished basement featuring a optional home gym setup, plus a large unfinished space above the oversized 3-car garage-ideal for storage or future living space. Step outside to your own resort-style retreat featuring a Juliano-built saltwater in-ground propane heated pool 2023 and a saltwater Aria hot tub 2020, complemented by a private new composite deck & large embossed concrete patio perfect for relaxing or entertaining. 4 gas torches to light up the night pool party. Set in a desirable Bristol neighborhood near golf, shopping, dining, schools, and commuter routes, this move-in ready home at the end of a cul-de-sac offers the best of everyday living with private vacation vibes right at home. Property is surrounded on two sides by Bristol Water Department land. Shed and fence 2023. Irrigation system front and back yard 2022. New Kitchen appliances 2021. Furnace replaced 2018. (Agent Owner)

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Sabina Sitaru

$699,900 ^(USD)

South End Area Multi-Family Home

Active

49 Benton Street Hartford, CT 06114

12 Bed

6 Baths

5553 sqft

MLS# 24129561

Fantastic 6 unit opportunity in Hartford's South End. This property offers immediate cash flow with continual growth and upside. 8+% in place CAP and all tenants current! Numerous units have recently been renovated with updated finishes, the roof is 3 years old and separate/tenant paid utilities make for low management costs. This solid, brick property has ample off street parking for tenant convenience and an established tenant base. Well-managed and maintained, this property is the perfect addition to your portfolio!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Maddy Ceruti

$699,900 ^(USD)

N/A Area Single Family Home

Active

21 Lasalette Way North Branford, CT 06471

4 Bed

4 Baths

2262 sqft

MLS# 24132724

Nestled on a quiet cul-de-sac & set on a beautifully private, 1.37-acre lot, this immaculate & completely remodeled 4BR Colonial will not disappoint! A welcoming paver walkway leads to your covered front porch, offering a warm introduction to what awaits inside. The foyer features custom tile flooring that opens to an amazing eat-in kitchen w/travertine floors & backsplash, ample cabinets, pantry & SS appliances. From the bright & airy kitchen, a slider opens to a spacious 700 sq. ft. Azek deck w/reinforced LVL beams..ready for a future hot tub & ideal for entertaining. You'll love the sun-filled great rm boasting cathedral ceilings, FP w/pellet stove insert & gleaming hardwood floors. A newly remodeled half bath with a Toto toilet, along with a formal dining rm & living rm..both showcasing hardwood floors-complete the 1st floor. Ascent to your 2nd floor where you'll find the primary suite that includes a walk-in closet & a fully remodeled bath w/high-end travertine tile shower & flooring. 3 additional bedrooms share a remodeled guest bath w/custom tile finishes. Walk-up attic is plumbed & ready to be finished, offering excellent expansion potential. The basement has also been beautifully finished, featuring a full bath, workshop & generous storage space. Other wonderful features include a new roof & gutter guards, new A/C compressor & freshly painted throughout. Every inch of this home reflects attention to detail & pride of ownership! This home truly needs nothing but YOU!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Michelle Travali

$699,000 ^(USD)

N/A Area Single Family Home

Active

5 Stegos Drive Wallingford, CT 06492

3 Bed

3 Baths

3013 sqft

MLS# 24125177

This bright and inviting Contemporary home is located on a quiet family friendly cul-de-sac. This home offers 3 bedrooms, 2.5 baths, large eat in kitchen, spacious dining room, extra large living room with a propane fireplace and custom built in bar. Upstairs has 3 bedrooms and 2 fully updated baths. The oversized master suite has multiple closets and a sitting area. There is also a room that can be an office or playroom! The partially finished basement is perfect for a man cave and has plenty of storage. This home also has new windows that are guaranteed for life. Outside features an above ground pool, a large deck and patio perfect for entertaining. There also is a whole house generator, large shed and an attached 3 car garage. Subject to seller finding suitable housing.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Sandra Morales

$679,000 ^(USD)

Niceville Area Single Family Home

Active

410 Anchors Street Niceville, FL 32578

5 Bed

4 Baths

2279 sqft

MLS# 982172

Stunning New Construction Home - Completed in 2025! Nestled on a serene 0.74-acre lot, this brand-new 5-bedroom, 3.5-bathroom home seamlessly blends luxury, comfort, and modern design. Step inside to discover premium finishes throughout, including, polished porcelain tile downstairs, luxury vinyl plank flooring upstairs and rounded corners for added elegance. The chef's kitchen features sleek quartz countertops, frameless high-gloss Palena White cabinetry, and upgraded stainless steel appliances, including a gas stove, 4-French Door Fridge, and dishwasher. Tankless gas water heater! The exterior showcases German Schmear brick paired with Nichiha shake siding dormers! Expansive composite wraparound deck, with modern wire railing, and gas connection for your grill - - Perfectly perched to overlook the tranquil pond surrounded by trees, offering a natural escape right in your backyard.

Additional highlights include an oversized concrete driveway, gas utilities. Tucked away for privacy yet just minutes from local schools, restaurants, shopping, and military bases, this hidden gem is the ideal balance of peaceful retreat and everyday convenience.

Don't miss your opportunity to own this thoughtfully designed home!

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Rufina Marte Candelario

$665,000 ^(USD)

Santa Rosa Beach Area Townhouse

Active

106 Courtyard Circle Santa Rosa Beach, FL 32459

3 Bed

4 Baths

1862 sqft

MLS# 975823

A Great Location!! This furnished home is in a quiet, gated and well sought out neighborhood backed up to a preserve. A short walk to the beach and 1 block from the Santa Rosa Golf Course. Plantation shutters throughout entire home. There is a swimming pool and cabana within the community. The houses are attached two by two with a carport and garage attached to each unit. Parking for two cars and golf cart. Golf cart conveys with property. There is a front and back courtyard for relaxing and privacy. This community does not have short term rentals.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Tim Norris

$659,900 ^(USD)

N/A Area Single Family Home

Active

121 Lewis Road Trumbull, CT 06611

3 Bed

2 Baths

2386 sqft

MLS# 24125028

This tranquil 3 bedroom 2 bath cape is located in an ideal Daniels Farm location. Driving through the stone piers to the circular drive you will feel home. The grounds are manicured and offer plenty of quiet time in nature. The brand new roof, new landscaping, new paint, and so much more make this home one to see. Walk up the front porch that has your matching rocking chairs as you sit and listen to the birds chirp and enjoy your favorite hot/cold beverage. Enter into a large living room as the fire hypnotizes you into forgetting every deadline. The kitchen is updated with white cabinets and granite counter tops. The playroom ( pool table & hot Tub can stay ) is huge with ceiling to floor views of the outside yard. The first floor offers a versatile floor plan for work and play.....be "home " for the holidays. The oversized primary bedroom offers endless possibilities. The charm of the butterfly stairway offers privacy from the two other bedrooms. The level backyard offers a gazebo and detached garage. Let's get you HOME for the holidays!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Mike Robinson

$658,900 ^(USD)

Gulf Crest Condo Area Condominium

Active

8715 Surf Drive 1606 Panama City, FL 32408

2 Bed

2 Baths

1310 sqft

MLS# 771986

Live the coastal dream in this beautifully updated 2-bedroom, 2-bathroom Gulf-front condo with bonus bunks, located on the 16th floor of the sought-after Gulf Crest Condominiums. This spacious unit features an open-concept layout, wide-open views of the Gulf, and an expansive beachfront balcony—perfect for morning coffee, sunset cocktails, or simply soaking in the sounds of the surf. Thoughtfully upgraded throughout, the condo includes new appliances, a new A/C, and a new hot water heater for enhanced comfort and efficiency. Both bedrooms feature new plank style tile flooring along with new mattresses and comforter sets. A new dining table and chairs complement the bright and airy space, while updated light fixtures in the kitchen and bathrooms add a modern touch. Freshly painted and decorated with coastal charm, the unit also includes new balcony furniture to enjoy the panoramic Gulf views. Whether you're looking for a primary residence, a second home, or an excellent vacation rental opportunity, this condo checks every box. Gulf Crest offers resort-style amenities including two beachfront pools, hot tubs, a tiki bar, fitness center, and direct beach access—all in the heart of Panama City Beach.

Listing Courtesy of CENTRAL PANHANDLE / Century 21 Allpoints Realty / Courtney Harris

$649,900 ^(USD)

Clintonville Area Single Family Home

Active

20 Fawn Ridge Drive North Haven, CT 06473

5 Bed

4 Baths

2662 sqft

MLS# 24131774

Welcome to this pristine neighborhood on a cul-de-sac where homes rarely go on the market! Home is set off the road with a beautifully maintained yard and plenty of parking for multiple guests. It is a 5 bedroom/4 bath well-kept raised ranch and it's almost like having 2 homes in one! 2 full kitchens and 2 full baths on each level and the perfect in-law situation! Two large decks, one covered and one open for viewing the morning sunrise or star gazing at night. 3 bedrooms upstairs and 2 on lower level. Downstairs has its own entrance access. New roof in 2024, central air with dual zones, natural gas, and 2 fireplaces. Upstairs fireplace has a gas insert which is capable of heating entire upstairs. Downstairs fireplace is regular wood burning. All appliances stay with the home. Extra garage in rear of home for either a workshop, greenhouse or one's favorite hobby. Large level lot yard with the capability of installing a swimming pool. Grounds have a sprinkler system and also invisible fence capability for pet safety. The possibilities are endless with plenty of storage and entertaining space inside and out! Home has great accessibility to shopping, restaurants, entertainment and local businesses. Schedule your appointment today to view this fantastic home!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Bonita Roggow

$649,900 ^(USD)

N/A Area Single Family Home

Active

1063 Main Street South Windsor, CT 06074

9 Bed

3 Baths

3834 sqft

MLS# 24129689

Welcome to the John P. Jones House, an iconic home that captures the romance of another era while embracing today's comforts. This gorgeous home is rich in distinctive features such as a wraparound porch, decorative woodwork, gingerbread trim, Monson slate shingles, stained glass and intricate millwork that highlights its artistry. Inside you'll find soaring ceilings, gleaming hardwood floors and natural woodwork that showcases the craftsmanship of its day. Four original fireplaces provide warmth and charm, while period light fixtures add to its allure. Spacious yet inviting rooms flow seamlessly, blending elegance with everyday comfort. The updated custom kitchen boasts high-end appliances, a Harman pellet stove and a walk-in butler's pantry with ample storage. Renovated baths echo the same thoughtful design, offering modern touches without sacrificing character. You'll enjoy outdoor living with a screened porch, paver patio, covered lanai and nearly an acre of beautiful grounds, ideal for gardening, entertaining or quiet relaxation. A four-car carriage house adds versatility for vehicles or creative pursuits. Nestled in one of South Windsor's most desirable neighborhoods, this home offers privacy with the convenience of nearby shops and restaurants. With easy access to Hartford, Boston and New York, South Windsor delivers small-town appeal with big-city reach. This is more than a home - it's a rare opportunity to own a piece of history.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Sheri Whiting

$639,900 ^(USD)

N/A Area Condo

Active

81 Fieldstone Lane 81 Beacon Falls, CT 06403

2 Bed

2 Baths

1988 sqft

MLS# 24133207

Welcome to 81 Fieldstone Lane! This one level Ranch home located in a 55+ Luxury Community of Chatfield Farms. These homes are rarely available. This Meticulously kept home offers 6 rooms, 2 bdms & 2 full baths. Walk through the front door and immediately feel welcomed by the large foyer that leads to the Gorgeous Kitchen w/White Quartz counters, tiled backsplash, Large Island, SS Appls including a 5-burner gas cooktop & wall oven with custom hood, a pantry and recessed lighting. The Kitchen opens to the Dining Rm and Family Rm offering a floor to ceiling Stone Gas Fireplace. There are Wide Plank Hardwood Flrs & Crown Molding throughout the main level. The French doors lead to the 1st floor office with custom cabinetry and built ins. The Primary Bedroom features a large walk-in closet, a full-on suite bathroom with double sinks, quartz counters and a walk-in tiled shower. Down the hall is the 2nd bedroom and 2nd Full Bath. The laundry room is located on the main level. Off the back is a Maintenance Free Trex Deck for your outdoor Enjoyment! The Lower level has been partially finished offering an addl 700 sq ft to your living area and tons of storage. The home's additional features include a 2 Car Attached Garage, a Generator & an Irrigation System. This Community offers a Clubhouse, Inground Heated Pool, Health Club w/Spa, Pickle Ball Courts, Library, Nature Trails & so much more. Don't miss this rare opportunity to make this Stunning unit in Chatfield Farms your New Home!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Kim Lambert

$639,900 ^(USD)

Long Hill Area Single Family Home

Active

33 Rexview Circle Trumbull, CT 06611

4 Bed

3 Baths

1976 sqft

MLS# 24085078

Did you hear about Trumbull's new ranking....the 06611 is sweet 16! 33 Rexview Circle is even sweeter with a price improvement!!! 4 bedroom 2.5 bath center hall colonial located on a cul-de-sac with its own trailhead to the Pequonnock Rails to Trail. This home has been freshly painted and offers front to back living room with hardwood floors. The spacious kitchen and adjoining dining room offer great entertainment space. Dinner al fresco on the oversized deck is the perfect place for summer evenings. The upper lever offers 4 nice size bedrooms with hardwood flooring, the primary suite with renovated bath is awaiting it new owner. You will find an additional 950 square feet in the walk out lower level. There are endless possibilities for this space: in-law, rec room, home gym ....there is a section for a home office and unfinished side is available for storage and a laundry room. This room has been freshly painted and new carpet installed. The home offers an ideal location for commuting and an active lifestyle. The trail head at the end off the road offers easy access to downtown Trumbull and hiking the vast Pequonnock Trail. This home is cost effective to run with the solar panels. Agents please make sure clients are aware of solar panels and qualified to assume lease. (documents attached)

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Lisa Valenti

$629,000 ^(USD)

Granada Area Single Family Home

Active

1455 Curlew Ave 1 Naples, FL 34102

2 Bed

2 Baths

975 sqft

MLS# 225069620

Dazzling coastal gem with modern designer finishes, perfectly poised in an ideal location, just a mile+ to downtown 5th Ave.! Exquisitely and newly rebuilt from floor to ceiling in 2023. Stylish accents include; all tile flooring throughout, full wall backsplash, marble style kitchen counters, white cabinetry, spa-like showers, custom wall-to-wall closet in primary bedroom. Nearby is fine dining, shopping, dancing, luxury resorts, Naples famed white sand beaches! Just a short stroll or scenic bike ride to the marina, Tin City, Bayfront restaurants or multiple parks. Beach lovers will revel in the coastal lifestyle with year-round Florida sunshine and breathtaking sunsets. Boaters will have direct access to the Gulf from your boat dock included. Investors, opportunity knocks in this coveted 34102 sweet spot. Single story, desirable open concept floor plan with breakfast bar. Laundry area contains full size washer and dryer. 2 assigned parking spaces. New appliances. New impact resistant windows. Slider door from main area leads to the private patio for tranquil living whether outdoors or in. Revel in the quintessential Naples lifestyle that many dream of, and don't miss this unique property which has it all!

Listing Courtesy of SWFMLS / Century 21 Allpoints Realty / Heidi White

$625,000 ^(USD)

Santa Rosa Beach Area Single Family Home

Active

2672 Chat Holley Road Santa Rosa Beach, FL 32459

6 Bed

6 Baths

2947 sqft

MLS# 979296

GREAT INVESTMENT OPPORTUNITY FOR AN AIRBNB!!! 1 ACRE LOT!! NEW CONSTRUCTION!! MOTIVATED SELLER -!!! In beautiful Santa Rosa Beach, FL — where modern luxury, space, and privacy come together in perfect harmony.

This brand-NEW CONSTRUCTION home sits on a rare 1-acre lot and offers an expansive 2,947 square feet of thoughtfully designed living space. The open, flowing floor plan features two master suites, ideal for multi-generational living or hosting guests in comfort and style. High-end finishes include quartz countertops and elegant detailing throughout, while beautiful professional landscaping enhances the home's curb appeal. The generous living areas, combined with state-of-the-art features, make this residence the perfect blend of modern design and coastal charm. With eight parking spaces and a private patio, this property offers plenty of room to relax, entertain, or expand. Make this your own private compound the expansive backyard (approximately 0.20 acres) provides ample space to build a mother-in-law suite, custom pool, and outdoor dining area, creating the ultimate personal retreat.
Ideally located just three miles from both Ed Walline Park public beach access and Cessna Landing bay access, this home offers the best of Santa Rosa Beach coastal living.

A rare opportunity to own new construction with unmatched space and potential in a prime location! Short Term Rentals are allowed.
NO HOA!!!
Call me today for a showing! It is vacant and easy to show!

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Rhonda Johnson

$625,000 ^(USD)

N/A Area Single Family Home

Active

240 Jude Lane Southington, CT 06489

3 Bed

3 Baths

2424 sqft

MLS# 24132006

Have you been patiently waiting for the perfect home? Your wait is over! This stunning 3-Bedroom Colonial in a prime location won't last long! Welcome home to this beautifully maintained custom-built Colonial, offering over 3,000 sq ft of living space including a finished 700 sq ft lower level. Built in 2001, this residence combines timeless charm and has been meticulously maintained. Step inside to find a freshly painted interior and trim, and refinished hardwood floors that gleam throughout the main level. The home features 3 spacious bedrooms and 2.5 baths, designed for both comfort and functionality. The kitchen flows seamlessly into the dining and living areas-perfect for entertaining or everyday living. Large windows fill the home with natural light Enjoy city water and sewer, and relax outdoors in your deep, level, and private yard, ideal for gatherings, play, or quiet moments surrounded by nature. Located in a great commuter area, this home provides easy access to major routes, shopping, and local amenities-offering the perfect blend of convenience and tranquility.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Erin O'Connor Mancino

$620,000 ^(USD)

Fort Walton Beach Area Condominium

Active

1150 Santa Rosa Boulevard 322 Fort Walton Beach, FL 32548

3 Bed

2 Baths

1282 sqft

MLS# 951039

Azure Condo offers a beautiful Mediterranean style luxury vacation property. Azure boasts beautiful landscape, fabulous pool and splash area and of course the Gulf of Mexico with it's stunning white sand beaches and crystal clear water. The minute you pull up to the fabulous entry way, you will be impressed.
Condo Unit 322 has a large balcony with beautiful water and beach views. This is a wonderful place to relax and enjoy everything that Fort Walton Beach, Destin and surrounding areas has to offer.
Azure is one of the most sought after condominium properties on Okaloosa Island. You just may want to live here.
Buyer to verify all important information about property.

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Trish "Patricia" Duggan

$599,999 ^(USD)

N/A Area Commercial

Pending

11 Charter Oak Place Hartford, CT 06106

0 Bed

3 Baths

0 sqft

MLS# 24077320

Excited to present 11 Charter Oak Place, a well-priced adaptive reuse opportunity in one of Hartford's most historic and sought-after neighborhoods. Adjacent to a stunning row of brownstones selling for $225K-$315K, this former convent has city-reviewed plans for conversion into 16 residential units: one 2-bed (860 SF), eight 1-beds (582 SF), and seven studios (438 SF). The local rental market supports strong pricing. Nearby 500-700 SF units at 37 Charter Oak Place rent for $1,250/month with average finishes, while new 1-beds achieve $1,650. Studios (330-466 SF) rent for $1,300-$1,380, and 2-beds command ~$1,800/month. Located in the Charter Oak Place Historic District, the property offers a rare mix of charm and modern convenience, just a short walk to Downtown Hartford, major employers, and cultural attractions-ideal for young professionals and renters seeking character-rich residences. This investment benefits from rising values, strong rental demand, and excellent walkability. With city-reviewed plans and a proven rental market, this is a rare chance to capitalize on a well-positioned development in a high-demand area.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Lisa Cozzi

$599,900 ^(USD)

N/A Area Single Family Home

Active

505 Savage Street Southington, CT 06489

4 Bed

4 Baths

1964 sqft

MLS# 24116113

Welcome to this beautiful & spacious home, ideally located just steps from the Southington Golf Course & minutes to downtown. A thoughtfully designed addition in 2018 expanded the home to include a luxurious master bedroom suite with hardwood floors, a walk-in closet plus an add'l closet, a sitting area, great for relaxing with a book & your favorite beverage, plus an oversized 2 car garage with storage, work bench, door to patio & the 2nd staircase to upstairs. The master bath features a jetted Jacuzzi tub, stand up shower & an expansive granite vanity with makeup area. At the same time, the roof & windows were replaced (except front bow Anderson window) offering peace of mind & energy efficiency. The main level features gleaming hardwood floors throughout, a total of 4 good sized bedrooms-including the expansive master suite and 3 full baths! The sun drenched, open concept living room/dining areas include 1 of 2 fireplaces, a sliding glass door to the deck overlooking the fenced in back yard, 2 storage sheds & a stamped concrete patio with fire pit, perfect for summer gatherings! The finished walk out lower level offers a cozy family room with the 2nd fireplace, a 1/2 bath with laundry, an exercise room & a massive walk in storage closet. The yard is private, serene and fully fenced, ideal for relaxing or entertaining. With ample space inside & out, and a location that's both peaceful & convenient, this home truly checks all the boxes!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Linda Conchado

$599,900 ^(USD)

N/A Area Single Family Home

Active

26 Stony Hill Road Holland, MA 01521

3 Bed

2 Baths

2564 sqft

MLS# 24084495

Just in time for summer, this beautifully remodeled year-round waterfront home offers stunning views of Hamilton Reservoir, a fully recreational lake. With 3 bedrooms, 2 full baths, and a home office that could easily serve as a 4th bedroom, this home is perfect for both relaxation and entertaining. The open-concept floor plan creates a spacious living room with sliding doors that lead to a covered deck - an ideal spot for gatherings.The newly updated kitchen boasts granite countertops, stainless steel appliances, and a breakfast bar, all centrally located and opening into a sunroom with panoramic lake views. The sunroom's sliding windows allow fresh breezes to flow through, and a propane space heater keeps it cozy on cooler nights.Additional features include central air, propane heat, an on-demand propane water heater, a water filtration system, a generator with a switching panel, a new roof, and new siding. Storage shed is perfect to keep organized.

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Laura Ennis

$599,900 ^(USD)

Destin Area Single Family Home

Active

197 Kel-Wen Circle Kel-Wen Destin, FL 32541

3 Bed

2 Baths

1749 sqft

MLS# 974082

OPEN HOUSE Sunday 10/12/25 (12-2) Totally remodeled and move in ready 3BR 2BA gem in the highly desired community of Emerald Breeze Estates! Just 2.5 blocks from the sugar sand beaches, Destin Commons, top-rated restaurants, and premier golf courses, the location is unbeatable! Soaring cathedral ceilings and a bright formal living area featuring an electric fireplace. LVP flooring throughout. The new and spacious kitchen offers a breakfast bar and opens to a formal dining area, ideal for gatherings and entertaining. The large master suite boasts a walk-in closet, his/her vanities and a walk-in shower. Two additional bedrooms provide ample storage and comfort for family/guests. Enjoy the privacy of a fenced backyard with a screened-in patio and an extra outdoor patio space. NO HOA!

Listing Courtesy of EMERALD COAST / Century 21 Allpoints Realty / Ken Koger

$599,900 ^(USD)

Plantsville Area Single Family Home

Active

45 Jeanette Court Southington, CT 06479

3 Bed

3 Baths

1878 sqft

MLS# 24130140

A must see! Meticulously maintained 3 bedroom, 2.5 bath, 2,293 SF Colonial set on a beautifully landscaped cul-de-sac lot. Enter the bright two-story foyer with Palladian window and discover gleaming hardwood floors throughout. The spacious and inviting living room with pellet stove opens to the dining area and kitchen featuring an island, built-in desk, and granite countertops. A versatile office/flex space, half bath, and laundry room complete the first level. Upstairs, the private primary suite offers a tray ceiling, walk-in closet, and en-suite bath with double sink vanity and towel warmer. Two additional bedrooms share a full hall bath. The expansive bonus room provides endless possibilities, complete with wet bar, beverage fridge, and surround sound wiring. Enjoy outdoor living in the private fenced yard, where deck access from the dining area creates the perfect spot for morning coffee or relaxing at day's end. Additional highlights include motorized window shades, epoxy-floored two-car garage with workbench, wireless security system, shed with power, irrigation system, and updated landscaping. This lovingly cared for home is ideally located near Panthorn Park, offering outdoor recreation and playgrounds, with quick access to I-84 for an easy commute. Photos don't do it justice - a standout property you'll want to see firsthand!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / Renee Meuse Lovley

$599,900 ^(USD)

N/A Area Commercial

Active

27 Main Street Hebron, CT 06248

0 Bed

4 Baths

3638 sqft

MLS# 24105955

27 Main Street is a fully modernized and updated 3638 Sq.Ft. commercial building located on 2.835 Acres featuring a High Visibility Site with an Excellent Traffic Count Location on Hebron's Main Street (CT RT 66) in the Quaint Hebron Green Zoning District. Currently housing a medical practice this space's current floor plan offers THREE separate rental spaces with separate utilities as well as the potential to create additional rental units with egress improvements. The original 1890 Building has been the subject of major improvements and additions in the Mid 1980s, Mid 1990s, 2014, and most recently 2017. Medical Ready with ideal sub-let floor plan or suitable for Mixed General and Professional Combined Office Uses! Pedestrian Friendly sidewalk connection to entire Hebron Green and Main Street Business Zones! Excellent On Site Parking for 24 Vehicles! Service by Public Water, Sewer, Natural Gas, Central A/C and Mini Split Cooling Systems! This Site offers the strong potential for further expansion and is as a key property in the continued growth and ongoing improvements being made in the HEBRON GREEN Zoning District!

Listing Courtesy of SMART MLS / Century 21 Allpoints Realty / James "Jim" Celio

$585,000 ^(USD)

Tradewinds Apts Of Marco Island Area Single Family Home

Active

180 Seaview Ct 612 Marco Island, FL 34145

2 Bed

2 Baths

846 sqft

MLS# 225060643

The Tradewinds in Marco Island is a highly sought after destination which provides beachfront living with direct beach access to the pristine white sand beaches of the Gulf of America. This beautiful 2-bedroom, 2-bathroom condominium boasts tropical island views. This stunning residence is the perfect space to relax and enjoy the sunrise every morning from your expansive lanai while you sip your morning coffee. In the evening you can enjoy an amazing sunset while you take a dip in the newly renovated heated pool or sip a drink by the tiki area where you can grill your favorite island meal. The community room provides an opportunity to host an event or socialize with your neighbors at bingo or one of the many scheduled events throughout the year. Feel like a good read, there is a library room on-site and on every floor you will find common laundry facilities, a garbage shoot and your own private storage locker to store all your favorite beach goodies. Have a bike? There is an indoor room to store your bike and an outdoor bike rack. Marco Island is bike friendly and offers some of the best dining within walking distance to the Tradewinds! You will have an assigned carport parking spot and there is plenty of parking for guests. Management is on-site. This condo has impact resistant lanai doors and custom remote patio lanai door coverings throughout. Priced to sell! Do not miss this opportunity to own your slice of paradise!

Listing Courtesy of SWFMLS / Century 21 Allpoints Realty / Lisa Kasparian