My Company's Active Listings

$2,200,000 (USD)
Active

Palm Harbor Area Single Family Home

Active

116 Carlyle Circle Palm Harbor, FL 34683

4 Bed
5 Baths
3344 sqft
MLS# TB8477239
Virtual Tour
The ultimate in waterfront living awaits you in this Key West style pool home on prestigious Indian Bluff Island. Brand New Roof!!!!! Updated Kitchen and beautiful leathered stone counter tops. With an open and yet warm presence, the floor plan in this beautiful three story home with elevator, wood floors, vaulted ceilings and architectural detail has the feel of casual sophistication. There are multiple balconies, French doors and large screened porch off family room to enjoy the ever changing water views, sunsets and Gulf breezes. The private backyard offers dock, covered boat lift, davits, seawall and direct Gulf access from a protected cove. Bring your boat and all your water toys. The deep water channel will take you out to St. Joseph Sound. Entertain poolside around the 25 meter lap pool in complete privacy surrounded by lush tropical landscaping and covered patio with beautiful pavers. Downstairs Bonus room, Game room or In law Suite with an outdoor entrance and a pool bathroom. Plenty of parking with the oversized garage and guest parking. There are many more surprises to be found when you view this unique property located in a tropical and secluded location close to beaches, Pinellas Trail, Wall Springs Park, schools and shopping. Live the Island lifestyle and vacation at home everyday
Listing Courtesy of STELLAR / Century 21 Coastal Alliance / Lisa Ulgenalp
$1,299,000 (USD)
Pending

Highland Area Single Family Home

Pending

243 Hawleys Corners Road Highland, NY 12528

3 Bed
3 Baths
3068 sqft
MLS# 921386
Discover the perfect blend of craftsmanship, comfort and opportunity in this stunning custom-built Craftsman home, offering over 3,000 square feet of living space on 20 picturesque acres. Previously subdivided with six additional parcels, this property offers exceptional potential for expansion, development or a private gathering retreat. Inside, you will find cathedral ceilings, custom woodwork, and an inviting open layout designed for both relaxation and entertaining. The home features 3/4 bedrooms, including a spacious primary suite with a huge walk-in closet. The partially finished walk-out basement provides flexible space perfect for a home studio or business. Enjoy hardwood floors, ceramic tile and new wall-to-wall carpeting throughout. The two car attached garage is complemented by a massive 4+ detached garage with upper level apartment potential offering room for guests, rental income or creative projects. Outdoors you will find a 31 ft x 73 ft sports pad perfect for basketball, pickleball or recreational use plus a charming 240 sq ft doll house that adds character and extra storage. The wooded setting provides privacy while keeping you just minutes from New Paltz and all the village has to offer, including restaurants, shopping, hiking and more. Situated on Marx Pond perfect for fishing, canoeing or kayaking making this property ideal for nature lovers, hobbyist or those seeking a serene yet connected lifestyle. A rare combination of space beauty and versatility - this Highland retreat is truly one of a kind.
Listing by: ONEKEY / Century 21 Alliance Realty Group / Melissa Pettinella
$1,250,000 (USD)
Active

Highland Area Single Family Home

Active

346 Crescent Avenue Highland, NY 12528

14 Bed
9 Baths
6406 sqft
MLS# 880487
The Historic “Clintondale Elixir Spring House”

A timeless treasure, the historic Clintondale Elixir Spring House—originally built in 1790—is a rare and remarkable offering to the market. Encompassing over 6,400 square feet of living space, this distinguished residence invites you to create your forever home amid rich character and architectural beauty.

Step through the welcoming rocking-chair front porch into a grand foyer, where a soaring cathedral ceiling and elegant cherry wood staircase set the tone for refined country living. A graceful balcony unites the upper and lower levels, creating a dramatic first impression.

Perfect for entertaining or quiet gatherings, the formal dining and living rooms exude warmth and heritage, featuring exposed bluestone walls, wide-plank hardwood floors, and striking beamed ceilings. The original hearth fireplace—once the heart of the home—restored, reviving its historic charm.

The main level continues with a sunlit gourmet eat-in kitchen, complete with chef worthy cooking appliances and ample space for culinary creativity. Upstairs, four generously sized bedrooms await, two with their own private en-suite baths. A spacious walk-up 1,800 soft attic with soaring ceilings, 3 sets of windows and fully insulated.

An attached addition houses a private bridal suite studio with its own entrance, while the first and second floors also offer two one-bedroom suites—each with separate entrances, their own kitchens and living rooms—ideal for guests or income-producing possibilities. The third level features eight additional bedrooms, several with connecting layouts and in-room sinks, living room and kitchenette all conveniently sharing two full and two half bathrooms.

Outside, manicured lawns and mature trees surround the property, enhancing its timeless ambiance. An antique four-stall outhouse stands as a charming nod to the past, completing the serene setting of the 1,000 sqft rear patio furnished with seating and table and umbrellas for 20 of your favorite guests.

Perfectly positioned just 86 miles from New York City and close to New Paltz, the NYS Thruway, Mohonk Mountain House, Lake Minnewaska, Dia Beacon, Storm King Art Center, the Walkway Over the Hudson, and Buttermilk Falls, this peaceful country haven offers both seclusion and convenience. Fine dining, boutique shopping, and world-class outdoor experiences are just moments away.

This is a once-in-a-generation opportunity. There is truly nothing else like it on the market today.
Listing by: ONEKEY / Century 21 Alliance Realty Group / Artur Galustyan
$950,000 (USD)
Active

Hopewell Junction Area Single Family Home

Active

13 Tompkins Lane Hopewell Junction, NY 12533

3 Bed
3 Baths
3320 sqft
MLS# 959751
You weren’t planning to stop, but this is the kind of Colonial that makes you slow down and look twice! Once you step inside, you realize why this home checks boxes you didn’t even know were must-haves. The main-level primary suite isn’t just a feature it’s the lifestyle upgrade buyers are searching for, offering comfort, privacy, and convenience without stairs at the end of a long day. Hardwood flooring throughout the main living areas adds warmth and durability, while soft carpeting in the primary and upstairs creates the cozy balance every home should have. With three bedrooms and three full bathrooms, space and function come easy, whether it’s daily routines, guests staying over, or simply having room to breathe. The bonus loft gives you flexibility most homes don’t offer perfect for a home office, media space, playroom, or workout zone, whatever your life needs next. The full unfinished basement provides opportunity to grow with storage now and future finished living space later, adding long-term value. Step outside and you’ll understand what truly sets this home apart, two back patios overlooking lush gardens that create a peaceful outdoor setting buyers hope for but rarely find, ideal for morning coffee, entertaining, or quiet evenings. The lifestyle extends beyond your front door with community amenities that feel like a membership rather than an extra errand, including a clubhouse, gym, playground and pool. Homes with this layout, flexibility, and setting are consistently in demand because they solve real-life needs while still feeling special, making this not just a home you like, but one that makes sense the moment you walk in. Home also offers handicapped accessibility and handicapped equipped.
Listing by: ONEKEY / Century 21 Alliance Realty Group / Tony De Gelormo
$875,000 (USD)
Pending

Hyde Park Area Single Family Home

Pending

4354-4356 Albany Post Road Hyde Park, NY 12538

4 Bed
5 Baths
3911 sqft
MLS# 908289
Wonderful mixed-use commercial/residential property located in the Historic Village of Hyde Park! The two-story home (1869sf) was built in 1928 and has the charm of yesteryear: appointed with beautiful moldings, gleaming wood floors, arched doorways, a wood mantel/brick fireplace, three bedrooms and a primary suite with a full bath. Updates include kitchen and baths, lighting, furnace, and basement drain lines. This would make a perfect live/work environment with all of the conveniences. The commercial building was constructed in 2009 (~1750sf).--architecturally designed by a local firm, and built by Mid Hudson Construction Management. The design and finish work are impeccable; features include vaulted ceilings, private offices (6), open spaces (conference/showroom/dining/retail) designer lighting, wood floors, a large kitchen/task center, three bathrooms, a utility room and a control room. The space lends itself to so many possible uses: professional/medical office space, retail/specialty stores, Salon/Spa, Conference center, restaurant/bakery, Gym/Yoga/Health Center, Air BNB, Bed and Breakfast/Inn, Daycare Center, rentals (office/co-work space solutions/pay as you go), event space for small gatherings (weddings, birthdays, small events), catering, residential rental conversion, art studios . . . the list goes on! In 2024, a Burnham high efficiency system and Heil natural gas direct vent furnace were installed to provide gas heat/hot water to both buildings. Three tank commercial septic system is in place to service both buildings. Its location on Albany Post Road (Rt. 9) gives you perfect visibility! Close to National Historic sites (FDR Home/Vanderbilt Estate), tourist sites, restaurants, shopping, medical facilities, retail, library, post office, The Culinary Institute of America, Marist University, the Hudson River, and so much more!
Listing by: ONEKEY / Century 21 Alliance Realty Group / Eben Yager
$869,900 (USD)
Pending

Tampa Area Single Family Home

Pending

5801 Cay Cove Court Tampa, FL 33615

3 Bed
3 Baths
2585 sqft
MLS# TB8453769
Virtual Tour
Under contract-accepting backup offers. Discover refined Florida living with this beautifully appointed residence tucked inside a gated community within another gated community. Perfectly poised at the end of a quiet cul-de-sac, this home boasts one of the largest parcels in the entire community, offering an exceptional sense of space, privacy, and exclusivity. Thoroughly updated, all that's left is for you to settle in and enjoy!
Backing to expansive, protected mangroves that stretch toward the bay, the property enjoys unobstructed, forever-natural vistas; a breathtaking backdrop that enhances both daily living and entertaining. Step inside and instantly feel the impact of the home's dramatic architectural details. Soaring ceilings, elegant sightlines, and thoughtfully curated finishes create a sophisticated yet highly livable floor plan. Expansive spaces flow seamlessly for both everyday comfort and upscale entertaining, while refined design elements throughout the home add a sense of style, depth, and timeless character. The ground floor impresses with French stone-patterned marble flooring, creating a cohesive flow throughout the main living areas. High ceilings and generous windows welcome natural light and frame the serene nature preserve views. The backyard is a private oasis, designed for true indoor-outdoor living. A resort-style pool and spa, an expansive resurfaced pool deck, and a well-equipped outdoor kitchen make this an ideal setting for hosting gatherings, lounging in the sun, or unwinding while taking in the coastal scenery. Thoughtfully landscaped spaces surround the home, including the owners beloved secret garden, a charming enclosed garden tucked privately along the side of the home. Screened and covered, it is the perfect spot for quiet mornings or evening relaxation. Blending rare lot size, exclusive double-gated living, elegant interior finishes, and protected views, this home offers a lifestyle that is nearly impossible to replicate within the community or beyond.
Listing Courtesy of STELLAR / Century 21 Coastal Alliance / Edward Schebilski