My Company's Active Listings

$2,990,000
Pending

Tierra Verde Area Condominium

Pending

455 Pinellas Bayway S 5A Tierra Verde, FL 33715

4 Bed
4 Baths
3126 sqft
MLS# U8169570
Virtual Tour
One or more photo(s) has been virtually staged. Under Construction. Completion Summer 2023. Luxury and serenity await you in your Quiet Cove waterfront residence, one of the last new constructions on the island paradise of Tierra Verde. This exclusive gated condominium development features 8 designer residences with the perfect blend of lifestyle, location, and one-level living. Your semi-private elevator opens to your foyer and entrance to your 3,126 square foot, four bedroom, four bathroom wheelchair accessible home with 10 foot ceilings throughout. Enjoy the morning breeze and picture-perfect sunrises on your balcony with panoramic views of the Skyway Bridge, Tampa Bay, and the marina, including your personal 50’ boat slip with sailboat deep open water access to the Gulf of Mexico. The open floor plan features a gourmet kitchen with quartz countertops, upscale appliances, and custom cabinetry with walk-in pantry. Relax in your master bedroom with a waterfront view and luxurious master bath, plus expansive his and her closets. Two car garages are provided for each unit plus guest parking onsite. Each garage is prewired for electric charging. Additionally, each unit includes an onsite private climate controlled storage space. Amenities include a heated saltwater pool and spa, an outdoor furnished lanai at pool/marina side with gas fireplace, club bar, and outdoor kitchen facility. Additional amenities include fitness room with lounge, TV, and a half bath. Quiet Cove offers contemporary elegance and smart pricing. Call today to secure your slice of paradise and lock in your selections of flooring, appliances, cabinets, and lighting. Tierra Verde is in the heart of Champa Bay (home to the Bucs, Bolts, Rays, and Rowdies), minutes from the top-rated beaches of Fort De Soto Park, 15 minutes from Downtown St. Pete (theatre, museums, culture, restaurants, and vibrant nightlife), and less and 40 minutes from Tampa International Airport (TPA). One or more photo(s) has been virtually staged
Listing Courtesy of STELLAR / Century 21 Coastal Alliance / Blanka Prusova White
$1,850,000
Pending

St Pete Beach Area Single Family Home

Pending

3988 Belle Vista Drive E St Pete Beach, FL 33706

3 Bed
3 Baths
2237 sqft
MLS# U8222404
Virtual Tour
Under contract-accepting backup offers. Introducing the Frog House – a whimsical original beach sanctuary with timeless allure. Nestled in the relaxed Belle Vista neighborhood, this coastal piece of paradise is just a golf cart ride away from the pristine sands of Saint Pete Beach and the iconic Don CeSar hotel. A large paved circular driveway welcomes you before approaching the grand red French doors, signaling your entrance into a personal realm of magic. The courtyard, draped in vibrant greenery and welcoming seating, sets the stage for a spellbinding experience. Once you enter this home, the bright, gourmet chic kitchen, and openness take you by surprise. The well thought-trough spacious layout, the upscale appliances featuring a Sub Zero refrigerator, the six-burner Wolf gas range complemented by a sizable hood finishing the style, two additional paneled-in beverage chill drawers, dishwasher, light pastel tone well-crafted wood cabinetry, large island with a second sink, microwave, ample seating by the breakfast bar, and walk-in pantry is every beach chef's fantasy. The open-concept design of the kitchen, dining room, and living room magnifies the endless entertainment possibilities. Elegant dining room with custom-built cabinets, ideal for hosting exquisite meals and serving beverages. Includes a convenient wine refrigerator for added sophistication. Plenty of newly updated windows and sliding doors make mingling from indoor charm to stunning outdoor water views an easy breeze. High wood-planked ceilings with expansive wood beams, and cascading natural sunlight create a magical ambiance, perfect for cherished family tales. The primary bedroom presents a wall of sliding doors to ensure complete water vistas, overlooking the swimming pool and a meticulously landscaped backyard. Indulge in luxury in the oversized primary bathroom featuring a freestanding tub with more water vistas and a roomy dual shower. The generously proportioned walk-in closet adds the finishing touch to this suite. Guest quarters include a suite with courtyard views, a bright shower bathroom, and ample closet space. The versatile third bedroom would fit nicely a pull down bed. Although a snug feel, this room has an entrance to the backyard and generous walk-in closet. Nearby laundry room with side by side washer, dryer, and cabinets ideal for cleaning supply. An office with a view of the front courtyard offers a serene workspace. The backyard of this property unveils captivating settings for you and your guests - a dining table under a wooden patio cover with a retractable sunshade and rope night lights, creating a mystical space for gatherings beneath the Florida sky. On the opposite side, a solar panel heated pool with a jacuzzi and waterfall feature, surrounded by ample lounge space on the paved deck and even more by the seawall and the updated large boat dock for the ultimate relaxation. Deep protected water like this is every boater’s paradise. To complete the property, the East side one-car garage caters to storage of your beach toys and your golf cart, while a spacious two-car garage on the West side has more of true functionality. Just bring your beach attire and enjoy the laid-back luxury lifestyle at the Frog House, where every detail resonates with timeless magic, creating unforgettable memories! Only 5 mins to the beach, 10 mins to restaurants, coffee shops, and grocery store, 15 mins to downtown St Pete, 40 mins to TPA International. Motivated Seller
Listing Courtesy of STELLAR / Century 21 Coastal Alliance / Blanka Prusova White
$1,500,000
Active

Palmetto Area Farm / Ranch

Active

9510 36th Avenue E Palmetto, FL 34221

5 Bed
4 Baths
3946 sqft
MLS# U8245626
Saddle Up! The Skyway Equestrian Center is on the market!! This 5 acre horse ranch located in Palmetto, Florida is just waiting for your Equestrian needs. The property is 4.99 acres and is board fenced and cross fenced. The meandering paved driveway leads you around a pond with footbridge to a 3,946 sq. ft., 2 story, 5 bedroom, 3 bathroom Spanish style home with a barrel tile trim flat roof and 3 car attached garage. Home has large eat-in kitchen, family room with wood burning fireplace and an impressive entrance foyer. The house has modern appliances, tile and carpeted floors upstairs with spacious bedrooms and an elevated deck spanning the width of the house. Out back has a big screened-in porch overlooking the firepit, paddock, vinyl log cabin guest house and barn. The cabin is a one bedroom, one bath, with modern kitchen and great room. This cabin can be guest quarters or residence for a farm manager. The crowning touch to this beautiful property is the 20 stall horse barn, with tack room and half bath. The barn has pavers for the common area floor and the stalls are full sized. To the back of the barn leads to a fenced training area. The location is short drive to interstate I75 and is equidistant to Tampa, St. Petersburg and Sarasota-Bradenton. Research indicates that full service horse stall rent in this area is $800-$1,000 per month. You do the math! This is a real winner! All room sizes are approximate.
Listing Courtesy of STELLAR / Century 21 Coastal Alliance / Randall Ierna
$1,500,000
Pending

Hyde Park Area Single Family Home

Pending

8 Spy Glass Lane Staatsburg, NY 12580

4 Bed
4 Baths
4606 sqft
MLS# H6297212
Discover luxury living in this stunning contemporary home boasting 5,200 sq. ft. of finished space nestled on 4.49 acres of beautifully landscaped grounds. The property features a detached three-car garage with an in-home office offering both convenience and ample storage. With four bedrooms, a library/den, 4 full baths, and 2 half baths, this home provides spacious comfort for you and your loved ones. Step inside and be greeted by high-quality hardwood floors that flow seamlessly through the living areas, complemented by an elegantly tiled gourmet kitchen with a dining area. The primary bedroom on the main floor is a true retreat, featuring an en suite bathroom complete with a spa-like tub for ultimate relaxation. Outdoor enthusiasts will delight in the in-ground pool, framed by lush landscaping that provides a serene oasis. Revel in the changing seasons with captivating river views that enhance the charm of this property. The exterior of the home showcases a perfect blend of attractive stone and siding. Experience the harmonious blend of luxury, comfort, and natural beauty in this contemporary masterpiece. Your dream home awaits. Nestled in an ideal location, this contemporary gem offers more than just a beautiful home. Enjoy the convenience of being in close proximity to a diverse array of culinary restaurants that will surely satisfy your gastronomic cravings. For those seeking educational opportunities, the esteemed Culinary Institute of America, Marist College, and Vassar College are close by. Commute with ease, as this home provides quick access to major roads that lead to a plethora of shopping venues and entertainment options. Whether you're in search of retail therapy, leisurely outings, or cultural experiences you'll find them all within reach. You will find two major villages nearby, HP Village and Rhinebeck Village, for leisurely shopping with historic sites such as the Vanderbilt Mansion, Mills Mansion, FDR Museum, Mills Norrie State Park, Milea Estate Vineyard, and Walkway over the Hudson. Includes a Home Warranty that transfers to buyers for one (1) full year. New Whole house generator installed 2024.
Listing by: ONEKEY / Century 21 Alliance Realty Group / Dorota Lasota-Lopez
$1,250,000
Active

Apollo Beach Area Single Family Home

Active

6616 Seabird Way Apollo Beach, FL 33572

4 Bed
3 Baths
2545 sqft
MLS# U8237492
Virtual Tour
Welcome to waterfront paradise! This stunning 4 bedroom, 3 bathroom home, located in the highly desirable community of Cobia Cay (with no HOA or CDD), boasts luxurious living with a private pool and a dock, with a boat lift, offering the epitome of Florida lifestyle. Spanning 2,545 square feet, this residence greets you with elegance and charm from the moment you step inside. This lovely home sits at the end of a cul-de-sac and as you pull in the driveway you are greeted by a beautiful water fountain. The first thing you will notice is how well the yard has been well maintained and there is a well for the irrigation system. The AC is brand new, it was installed in February 2024 and the exterior was freshly painted in March 2024. The spacious and airy layout is designed for both relaxation and entertainment. The well-appointed kitchen features modern appliances, ample counter space, and a convenient kitchen bar, perfect for casual meals or hosting gatherings. Adjacent to the kitchen, the dining area flows seamlessly into the living room, complemented by views of the pool and waterfront. Retreat to the master suite, a serene haven offering tranquility and comfort and a beautiful view of the pool and waterfront. Complete with 2 walk-in closets and an en-suite bathroom featuring dual vanities, a soaking tub, and a separate shower, it's the ideal retreat after a long day. The additional bedrooms provide versatility for guests, home offices, or hobby rooms. Step outside to discover your private oasis. The screened-in pool area is perfect for enjoying the Florida sunshine, whether you're lounging in the spa or poolside or taking a refreshing dip. Beyond the pool, the waterfront beckons, with a dock with a boat lift and jet ski docks offering direct access to the water, ideal for boating, fishing, or simply taking in the scenic views. With easy access to shopping, dining, parks, and entertainment, as well as being just a short drive from the vibrant city of Tampa, it's a true gem in the heart of Florida's Gulf Coast. Don't miss your opportunity to own this exceptional waterfront retreat. Schedule your showing today and start living the Florida dream. $5000.00 credit to the buyer to have the house repainted. SELLER MOTIVATED TO SELL. Seller willing to see all REASONABLE OFFERS.
Listing Courtesy of STELLAR / Century 21 Coastal Alliance / Dennis Chamberlain
$1,188,000
Active

Queens Area Single Family Home

Active

195-12 McLaughlin Avenue Holliswood, NY 11423

4 Bed
3 Baths
sqft
MLS# 3566951
Welcome to this exquisite and exceptional colonial 10 rooms or more legal single-family home located at 195-12 McLaughlin Avenue in Holliswood, Queens NY 11423. Holliswood is an exclusive suburban, tranquil, and serene neighborhood zoned for Blue Ribbon School District 26. This charming residence features 4 bedrooms, 3 bathrooms closets, and a pull-down attic staircase. The second floor has a landing, a linen closet, another closet space, 3 bedrooms, and a bathroom. The first floor features one bedroom, a powder room, and a laundry room with a washer and dryer for your convenience-Eat-in kitchen with pantry and appliances, and with entrances to the basement and backyard. A formal dining room, with huge windows, a spacious living room, an inviting foyer, and a deck all come together to create an ideal living space for customization to your desire and imagination. The living room and foyer have expansive windows that capture the sunlight and illuminate the living space with serenity, peace, and an inviting glow to the entire home. This serves as a focal point of the home and provides a seamless connection between indoor and outdoor living. The large private backyard has a shed that is a tranquil oasis that can be customized to your liking or desire. The property has an extended fully finished basement and a huge cedar closet. This home has a private walk-out garage attached to an extra long and spacious private walk-out driveway and front yard, providing security and convenience to accommodate several cars. The zoning permits extension up to 0.5 FAR on this 4356 square foot that offers the potential to customize to your desire to make this home your dream mansion. Close to houses of worship, colleges, nurseries, shopping, transportation, bus, subways, highways, and parks. A property of this caliber in such a prime location on a serene tree-lined street is rarely available in Holliswood Queens New York. Explore this exquisite neighborhood.
Listing by: ONEKEY / Century 21 Alliance Realty Group / Nereida Cruz Rivera