My Company's Active Listings

$410,000 (USD)
Active

St Petersburg Area Condominium

Active

6104 Palma Del Mar Boulevard S 404 St Petersburg, FL 33715

2 Bed
2 Baths
1050 sqft
MLS# TB8460253
Virtual Tour
An abundance of natural light and updates in this welcoming, corner condo featuring 2 bedrooms and 2 baths. The open-concept floor plan is designed to impress, with expansive windows and sliding glass doors that open to breathtaking views of the Isla Del Sol Golf Course and a partial water view. The kitchen boasts beautiful cabinetry, stainless steel appliances, sleek granite countertops, and tiled backsplash. The master suite is a true retreat, complete with built-in cabinetry, a dedicated workspace ideal for remote work, an updated ensuite bath, and a walk-in closet. Your guests will enjoy their own private suite with picturesque views of the lush tropical landscape and golf course, plus an updated guest bath for added comfort. Modern touches like smooth ceilings (no popcorn!), hurricane shutters, new interior doors, upgraded lighting, and ceiling fans enhance the condo's appeal. New AC and Hot Water Heater in 2025.Step outside onto your private balcony to soak in the golf course views, partial water glimpses, and incredible sunsets. Included is one of the best parking spots in the building's under-building garage (19, just steps from the lobby). This mostly furnished condo offers incredible value with HOA fees covering Spectrum TV Select Plus, internet, DVR, trash, and water/sewer. Located in the desirable Palma Del Mar community on Isla Del Sol, residents enjoy resort-style amenities such as a seaside pool, spa, and social room. With a prime location just minutes from world-renowned Gulf Beaches, the Pinellas Bike Trail, Ft. DeSoto Park, and downtown St. Petersburg's cultural hotspots, plus easy access to I-275 and airports, this condo offers the best of both convenience and coastal living. Milestone and SIRS have been completed. Don't miss your chance to embrace a lifestyle waiting to be lived!
Listing Courtesy of STELLAR / Century 21 Coastal Alliance / Nancy LaBare
$399,999 (USD)
Pending

Wappingers Falls Area Single Family Home

Pending

106 New Hamburg Road Wappingers Falls, NY 12590

3 Bed
2 Baths
1359 sqft
MLS# 939724
Charming Ranch Style Home for Sale in the Heart of Wappingers Falls. Beautifully Maintained 3-Bedroom, 2-Bath Residence with Modern Upgrades. Welcome to this well-maintained home. This inviting property features three comfortable bedrooms and two full bathrooms, offering both style and functionality for today's homeowner. The front yard is a standout, meticulously cared for with a lush green lawn and neatly trimmed bushes that provide excellent Curb appeal. Whether you’re relaxing on the porch or enjoying the view from inside, the beautifully landscaped surroundings set a welcoming tone for the entire home.
Step inside to a spacious living room designed with a modern aesthetic, highlighted by natural elements. The hardwood flooring, finished in a warm honey tone, pairs perfectly with crisp white walls and recessed ceiling lights, creating a bright and airy atmosphere ideal for gatherings or quiet evenings at home.
Master Bedroom: Enjoy the convenience of three walk-in closets, providing ample storage and organization solutions.
Additional Bedrooms: Two additional nicely sized bedrooms offer flexibility for guests, or a home office.
A full bath with a tub is easily accessible from the hallway, perfect for guests.
The eat-in kitchen is both stylish and practical, featuring white cabinets with elegant gold handles, a marble-patterned tile backsplash for a touch of sophistication, and modern stainless steel appliances. There is also a washer/dryer hookup for added convenience. Just off the kitchen, a warm sunroom area provides a relaxing retreat and includes a full bath for guests. This space opens directly to a large backyard, perfect for entertaining, gardening, or simply unwinding in your own private oasis.
This exceptional home blends comfort, modern design, and outdoor appeal in a prime Wappingers Falls location. Don’t miss your chance to make this beautifully maintained property your next home!
Listing by: ONEKEY / Century 21 Alliance Realty Group / Tijuana Vann
$399,000 (USD)
Pending

Tarpon Springs Area Single Family Home

Pending

751 Bayshore Drive Tarpon Springs, FL 34689

3 Bed
1 Baths
1008 sqft
MLS# TB8402215
Virtual Tour
Under contract-accepting backup offers. Perched majestically on one of Bayshore Drive's premier elevations in historic Tarpon Springs, this impeccable residence commands stunning views of the Anclote River from the front of the house and the bedrooms. The robust cinder block construction ensures peace of mind, as this elevated property has maintained its pristine condition without ever experiencing flooding. Inside, you'll appreciate the thoughtfully renovated kitchen featuring elegant granite countertops and modern stainless steel appliances, complemented by an oversized deep sink with a new water filtration system.

Step into luxury with the completely transformed bathroom, showcasing sophisticated floor-to-ceiling subway tiles. A bright and airy sunroom addition creates the perfect space for dining or unwinding, with sliding glass doors leading to your private outdoor oasis. The exterior has been masterfully landscaped with flourishing citrus, palm, fig and avocado trees, supported by a convenient well irrigation system. Entertaining is a breeze with the newly installed paver patio, while the circular paver driveway provides ample space for multiple vehicles and boat storage. Security and privacy are enhanced by a new cedar fence with sophisticated solar lighting. Modern amenities include newer double-paned windows throughout and an updated hot water heater and Inside Laundry room. Located just minutes from Fred Howard Park beaches, the famous sponge docks, charming downtown Tarpon Springs, and the Pinellas Trail, this versatile property is ideal for year-round living, seasonal enjoyment.
Listing Courtesy of STELLAR / Century 21 Coastal Alliance / Lisa Ulgenalp
$399,000 (USD)
Pending

Hyde Park Area Single Family Home

Pending

142 Pinebrook Drive Hyde Park, NY 12538

2 Bed
3 Baths
1517 sqft
MLS# 937404
Absolutely stunning townhome located in the desirable Pinebrook development in Hyde Park! You'll love the wide open, clean lines of this home--it shows like a model. First floor; living room, kitchen,1/2 bath, laundry room, and a family room/den that may have a variety of uses. Second floor; Primary bedroom suite, second bedroom with its own en-suite bathroom. Enjoy the outside living space with a semi-private deck off of the kitchen, and a lovely back yard. The many updates/amenities include; beautifully renovated kitchen (2023) with top of the line Samsung appliances (gas range/french door refrigerator/microwave/dishwasher), solid surface counters, subway tile backsplash, industrial style sink/faucet. Hardwood floors throughout the home, with exception of the Primary bathroom and guest room bathroom, which have ceramic tile, the laundry room (vinyl). Bluetooth speaker in ceiling of primary bathroom, double vanity in this room as well. New vents and plumbing installed in the home. Water heater replaced in 2023, HVAC system is new, garage, laundry room, and guest bathroom were updated in 2024, basement electric was updated in 2021. The home is wired for an ADT security system. So many updates, such a beautiful home, you'll truly love it! Close to Marist University, the CIA, hospitals, shopping, restaurants, Metro North, historic sites, hiking, the Hudson River and so much more!
Listing by: ONEKEY / Century 21 Alliance Realty Group / Diane Crittenden
$392,500 (USD)
Active

Land O Lakes Area Single Family Home

Active

15762 Cedar Elm Terrace Land O Lakes, FL 34638

3 Bed
2 Baths
1973 sqft
MLS# TB8398219
Virtual Tour
MOTIVATED SELLER!! Beautiful 3-Bedroom, 2 Bath Home with Conservation Views in Desirable Suncoast Lakes! This home has great curb appeal and features a split bedroom plan and 2-car garage. NEW ROOF 2023, NEW A/C SYSTEM 2024, DOUBLE PANE WINDOWS, NOT IN A FLOOD ZONE, NO CDD. A water softener system is also included. An estate sale was held in December and the home is now unfurnished and ready to close! As you enter into the large foyer you'll take in the serene view of the lush conservation area behind the home. The open floor plan boasts high ceilings, recessed can lighting, wood laminate flooring throughout, and ceramic tile in the kitchen and bathrooms — no carpeting! The spacious kitchen is a cook’s dream with Corian countertops with an integrated sink, raised panel cabinetry with roll out shelves, a breakfast bar, and an abundance of counter space. Enjoy meals in the charming breakfast nook. A nearby laundry room offers convenient access to the garage and a NEWER LG WASHER/DRYER PAIR are included in the purchase. The great room design includes a stylish architectural divider with a column and arch, separating the dining area from the living room. The living room is pre-wired for surround sound and includes ceiling speakers — perfect for entertaining. Two secondary bedrooms are situated at the front of the home, with the front bedroom showcasing a beautiful bay window. The spacious master suite boasts a double tray ceiling, a huge walk-in closet, and an ensuite bath with dual sinks, a large walk-in shower with a seat, and a glass enclosure. Enjoy peaceful mornings or relaxing evenings in the oversized screened porch, which features both open and covered lanai space, all overlooking the tranquil conservation area for added privacy and natural beauty. Suncoast Lakes offers NO CDD fees, just a low HOA fee of just $75/month, which includes access to amenities such as a community pool, tennis courts, basketball courts, a playground, and an open sports field. Trash and recycling pick-up are also included. Outdoor enthusiasts will love direct trail access from Pond Rush Ct. to the Suncoast Trail, a 50-mile paved trail ideal for biking, walking, or running. Conveniently located near the Suncoast Parkway (589), I-75, and US-19, with easy access to Publix, gas stations, restaurants, and more. Sight unseen offers will not be considered. SPECIAL FINANCING...LENDER PAID 12 MONTH BUYDOWN ON A REDUCED INTEREST RATE FOR THE FIRST 12 MONTHS. Details available.
Listing Courtesy of STELLAR / Century 21 Coastal Alliance / Gail Urban