My Company's Active Listings

$407,500 (USD)
Active

Clearwater Area Single Family Home

Active

1618 Ottawa Road Clearwater, FL 33756

2 Bed
3 Baths
1410 sqft
MLS# TB8511061
Virtual Tour
Don't miss this beautiful 1925 charmer. Located at the end of a dead end street providing superior privacy. Enjoy evenings on the expansive front porch that you won't find in many other homes. This home features 2 bedrooms, 2 full baths and a 3rd BONUS room that has a 1/2 bath and is an easy conversion to a 3rd bedroom or would make a great office/flex space for working from home. The home features beautiful original hardwood floors throughout in perfect condition. The dining room features an original built in china cabinet. The huge Master bedroom features an updated master bath with stand up shower, separate tub and a vanity with dual sinks. Kitchen features include Corian counters, stainless steel sink, new appliances and a large eating space for casual dining. Off the kitchen is a large screened porch with a hot tub that provides lots of space for entertaining. All but 1 window are newer double hung windows, the HVAC system was installed in 2019, septic system replaced in 2025 and new roof in 2025. The detached 12 x 20 storage shed in the back yard also provides massive storage for your toys, yard equipment or would make a great hobby/workshop. The home is in a great central Clearwater location with easy access to shopping, restaurants, schools, employment, airports and Clearwater's award winning beaches. This one is a must see.
Listing Courtesy of STELLAR as distributed by MLS GRID / Listed By: Thomas Schirr, Century 21 Coastal Alliance
$399,000 (USD)
Active

Bearsville Area Single Family Home

Active

281 Cold Brook Road Bearsville, NY 12409

0 Bed
0 Baths
1000 sqft
MLS# 1041431
There are homes that ask you to compromise, and then there are homes that ask you to dream.

Set against a backdrop of sweeping mountain views, this is a rare opportunity to create something that’s unmistakably yours. The hardest work has already been done. What’s left is the part that reflects your style, your vision, and the way you want to live.

Picture slow mornings with coffee overlooking the mountains, evenings spent watching the seasons change, and a home finished exactly the way you’ve always imagined—not someone else’s choices, but your own. Whether your vision includes warm natural finishes, clean modern lines, or a timeless mountain retreat, this property is ready for the next chapter.

In a market where finding the right location is nearly impossible, opportunities like this don’t come along often. For generations, Bearsville and neighboring Woodstock have drawn musicians, painters, writers, makers, and free spirits seeking inspiration, community, and a different pace of life. Here, you’re close enough to enjoy the galleries, live music, cafés, and creative energy that define the area, yet far enough away to hear little more than the wind through the trees and the sounds of nature. Bring your imagination, your contractor, and your plans. The canvas is waiting.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Ron Knowles, Century 21 Alliance Realty Group
$399,000 (USD)
Active

Woodstock Area Single Family Home

Active

281 Cold Brook Bearsville, NY 12409

0 Bed
0 Baths
1000 sqft
MLS# 20264318
There are homes that ask you to compromise, and then there are homes that ask you to dream.

Set against a backdrop of sweeping mountain views, this is a rare opportunity to create something that's unmistakably yours. The hardest work has already been done. What's left is the part that reflects your style, your vision, and the way you want to live.

Picture slow mornings with coffee overlooking the mountains, evenings spent watching the seasons change, and a home finished exactly the way you've always imagined--not someone else's choices, but your own. Whether your vision includes warm natural finishes, clean modern lines, or a timeless mountain retreat, this property is ready for the next chapter.

In a market where finding the right location is nearly impossible, opportunities like this don't come along often. For generations, Bearsville and neighboring Woodstock have drawn musicians, painters, writers, makers, and free spirits seeking inspiration, community, and a different pace of life. Here, you're close enough to enjoy the galleries, live music, cafés, and creative energy that define the area, yet far enough away to hear little more than the wind through the trees and the sounds of nature. Bring your imagination, your contractor, and your plans. The canvas is waiting.

Every opportunity begins with possibility this one begins for the Mountain View
Listing by: Hudson Valley Catskills MLS / Listed By: Ron Knowles, Century 21 Alliance Realty Group
$395,000 (USD)
Active

St Petersburg Area Condominium

Active

1036 North Shore Drive NE 1 St Petersburg, FL 33701

1 Bed
1 Baths
925 sqft
MLS# TB8463460
Virtual Tour
Priced Below Recent Appraisal—Seller Has Appraisal Available!

Rarely does a home offer the perfect blend of location, charm, value, and peace of mind. This beautifully maintained Mid-Century Modern condominium is tucked away in the highly sought-after Whispering Waters, a premier 55+ community in the heart of downtown St. Petersburg.

This spacious ground-floor corner residence features one bedroom, one bath, and an inviting floor plan with generously sized rooms that are difficult to find in today's construction. Three screened lanais create the perfect spaces to enjoy morning coffee, afternoon reading, or evening breezes while embracing Florida's indoor-outdoor lifestyle.

The updated kitchen is equipped with attractive modern appliances and opens seamlessly to the living and dining areas, making entertaining effortless. The oversized primary suite offers a large walk-in closet, while the in-unit washer and dryer provide everyday convenience. A private one-car garage with additional storage completes this exceptional package.

This home is truly move-in ready, and the community has already completed many of the major improvements buyers are looking for, including exterior painting (2023), a new roof (2024), a resurfaced community pool (2024), plus the required Milestone Inspection and Structural Integrity Reserve Study completed in 2023—offering added confidence for your investment.

The location is simply outstanding. Whispering Waters overlooks a beautiful city park and sits directly across from the scenic Tampa Bay waterfront promenade, where miles of walking and biking paths invite you to enjoy spectacular sunrises and waterfront views every day.

Leave the car behind and stroll to North Shore Park, The St. Pete Pier, and vibrant Beach Drive, home to award-winning restaurants, sidewalk cafés, boutiques, art galleries, and waterfront dining. Travel + Leisure recognized St. Petersburg as the #1 foodie town among America's coastal cities, and it's easy to see why.

Nearby you'll also enjoy world-class attractions including The Dalí Museum, Tropicana Field, Al Lang Stadium, the historic St. Petersburg Shuffleboard Club, the St. Petersburg Yacht Club, museums, theaters, concerts, and year-round festivals that make downtown one of Florida's most vibrant places to live.

Whether you're searching for a full-time residence or the perfect seasonal escape, this exceptional condominium offers an unbeatable combination of classic Mid-Century Modern style, a premier downtown waterfront location, completed community improvements, and outstanding value—all priced below its recent appraised value.
Listing Courtesy of STELLAR as distributed by MLS GRID / Listed By: Randall Ierna, Century 21 Coastal Alliance
$375,000 (USD)
Pending

Spuyten Duyvil Area Stock Cooperative

Pending

2500 Johnson Avenue 20F Riverdale, NY 10463

1 Bed
1 Baths
1059 sqft
MLS# 917925
Welcome to Winston Churchill — Where Luxury Meets Convenience!
Apartment 20F is all about views, views, and more views! Step into this beautifully renovated, oversized apartment and be greeted by an open, airy layout and wall-to-wall windows that flood the space with natural light. A Kitchen You’ll Love: This chef’s dream kitchen features ceiling-height cabinetry adorned with elegant moldings, glass doors, and decorative end panels. You’ll find abundant storage, including a built-in pantry and extra drawers, as well as designated zones for entertaining:
Wine bar with wine fridge, Coffee station, Breakfast bar.

Whether you're hosting or just enjoying your morning brew, this kitchen offers the perfect blend of style and function.

Spacious Living
The open-concept living and dining area is perfect for entertaining or relaxing while taking in the panoramic views. The oversized bedroom offers plenty of space for a king-size bed and more. Need additional space..... Just step through the French doors into a versatile den/office complete with a closet—ideal for guests, or work-from-home setups. There are also two generous sized Walk-in closets for all of your storage needs.
Location, Location, Location
Situated in the highly desirable Spuyten Duyvil neighborhood, you're less than 10 miles from Midtown Manhattan. Commuting is a breeze with nearby access to Metro-North, subway lines, and local buses.
Enjoy walking to parks, shops, restaurants, and other everyday conveniences.
About the Building

The Winston Churchill is a full-service, luxury building with top-tier amenities:

An elegant lobby with 24-hour doorman and concierge.
Glass-enclosed indoor heated pool with sundeck and sauna.
Updated fitness center
Indoor playroom, community room with pool table and ping pong.
Bike storage, laundry room, and mail room.
Garage parking available (extra fee). Cable and internet included for just $79.50/month

This is more than just an apartment — it's a lifestyle. Come experience luxury living with city convenience at Winston Churchill, Apt. 20F.
Listing by: ONEKEY as distributed by MLS GRID / Listed By: Anne Marie Vigorita, Century 21 Alliance Realty Group