$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2357) "A rare opportunity in the gated community of Brookstone! Situated on 1.09 ac...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->PublicRemarks
A rare opportunity in the gated community of Brookstone! Situated on 1.09 acres, this custom-built 2007 home offers just under 4,500 square feet of living space with 5 bedrooms, 3 full baths and 2 half baths, along with a tile roof, whole-house generator and an impressive combination of space, character and thoughtful custom features.
One of the home's most memorable features is its architecturally distinctive main living space, where a curved wall of windows fills the room with natural light and creates multiple areas for gathering, conversation and relaxation. A centrally positioned gas fireplace serves as a striking focal point and adds to the truly custom character of the space.
The spacious gourmet kitchen features granite countertops, abundant cabinetry, a large center island, multiple pantries, a gas range and dual ovens, including a convection oven. An adjoining breakfast area provides plenty of room for casual dining, while the separate formal dining room with crown molding offers a more traditional setting for entertaining.
The first floor also includes a private office with an adjoining half bath, plus a bedroom and full bath — an excellent arrangement for overnight guests or multigenerational living.
Upstairs, the oversized primary suite features a double inset tray ceiling with crown molding, generous walk-in closets and a spacious private bath. The additional bedrooms offer excellent closet space, including walk-in closets, while the upstairs laundry is conveniently located near the bedrooms. An additional den/flex space opens directly onto a covered second-floor balcony, creating an inviting spot for a second living area, reading room, hobby space or private retreat.
Outdoor living continues with a covered front porch, rear patio and outdoor kitchen, all surrounded by more than an acre of property. Additional highlights include natural gas, a whole-house generator and a separate air-conditioned storage room within the garage, providing valuable temperature-controlled space for storage, hobbies or collectibles.
With its distinctive architecture, generous room sizes, exceptional storage, tile roof, expansive homesite and hard-to-find location within gated Brookstone, this custom home offers a combination of space, functionality and character you simply don't find in many newer homes.
⇄⧉public Appliances -> string (93) "Convection Oven,Cooktop,Dishwasher,Dryer,Gas Water Heater,Microwave,Range,Re...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->Appliances
Convection Oven,Cooktop,Dishwasher,Dryer,Gas Water Heater,Microwave,Range,Refrigerator,Washer
⇄public AssociationFee -> string (3) "900"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->AssociationFee
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->DirectionFaces
⇄⧉public Directions -> string (201) "From S. Pine Ave (US 441) Head West on SE 32nd St., T/L onto SE 3rd Ave. Go ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->Directions
From S. Pine Ave (US 441) Head West on SE 32nd St., T/L onto SE 3rd Ave. Go 1/4 mile T/L into the Brookstone entrance at SE 36th Lane. Follow around curve toward back of neighborhood property on Right.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (2357) "A rare opportunity in the gated community of Brookstone! Situated on 1.09 ac...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_PublicRemarksAgent
A rare opportunity in the gated community of Brookstone! Situated on 1.09 acres, this custom-built 2007 home offers just under 4,500 square feet of living space with 5 bedrooms, 3 full baths and 2 half baths, along with a tile roof, whole-house generator and an impressive combination of space, character and thoughtful custom features.
One of the home's most memorable features is its architecturally distinctive main living space, where a curved wall of windows fills the room with natural light and creates multiple areas for gathering, conversation and relaxation. A centrally positioned gas fireplace serves as a striking focal point and adds to the truly custom character of the space.
The spacious gourmet kitchen features granite countertops, abundant cabinetry, a large center island, multiple pantries, a gas range and dual ovens, including a convection oven. An adjoining breakfast area provides plenty of room for casual dining, while the separate formal dining room with crown molding offers a more traditional setting for entertaining.
The first floor also includes a private office with an adjoining half bath, plus a bedroom and full bath — an excellent arrangement for overnight guests or multigenerational living.
Upstairs, the oversized primary suite features a double inset tray ceiling with crown molding, generous walk-in closets and a spacious private bath. The additional bedrooms offer excellent closet space, including walk-in closets, while the upstairs laundry is conveniently located near the bedrooms. An additional den/flex space opens directly onto a covered second-floor balcony, creating an inviting spot for a second living area, reading room, hobby space or private retreat.
Outdoor living continues with a covered front porch, rear patio and outdoor kitchen, all surrounded by more than an acre of property. Additional highlights include natural gas, a whole-house generator and a separate air-conditioned storage room within the garage, providing valuable temperature-controlled space for storage, hobbies or collectibles.
With its distinctive architecture, generous room sizes, exceptional storage, tile roof, expansive homesite and hard-to-find location within gated Brookstone, this custom home offers a combination of space, functionality and character you simply don't find in many newer homes.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1468) "Turnkey furnished 4 bedroom, 2.5 bath pool home with direct Gulf access and ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->PublicRemarks
Turnkey furnished 4 bedroom, 2.5 bath pool home with direct Gulf access and a highly desirable Southwest Cape Coral location. The outdoor living area is designed for enjoying the waterfront lifestyle with a resurfaced saltwater pool and sunshelf completed in 2023, electric heat, composite dock with captain’s walk around, 10,000 lb boat lift and tiki hut. The fully fenced yard adds privacy while the canal views create a relaxing setting throughout the property. Inside, the spacious island kitchen features wood shaker cabinets, ample counter space, bar seating for 8, a pot filler and pass through impact window to the lanai. The large primary suite offers sliding glass doors to the pool area with views of the canal and a beautifully renovated en suite bath with a freestanding soaking tub, oversized walk in shower and large vanity. Two spacious guest bedrooms are located toward the back of the home and share a large bath that also functions as a pool bath. The fourth bedroom sits just off the kitchen with French doors and works perfectly as a home office, gym, playroom or additional guest space. A half bath and interior laundry room add convenience and functionality. Located within walking distance to Rotary Park and nature trails and just a short bike ride to Tarpon Point Marina with waterfront dining, shopping and entertainment, this property also places you minutes from everyday conveniences while offering the best of Southwest Florida living.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1468) "Turnkey furnished 4 bedroom, 2.5 bath pool home with direct Gulf access and ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_PublicRemarksAgent
Turnkey furnished 4 bedroom, 2.5 bath pool home with direct Gulf access and a highly desirable Southwest Cape Coral location. The outdoor living area is designed for enjoying the waterfront lifestyle with a resurfaced saltwater pool and sunshelf completed in 2023, electric heat, composite dock with captain’s walk around, 10,000 lb boat lift and tiki hut. The fully fenced yard adds privacy while the canal views create a relaxing setting throughout the property. Inside, the spacious island kitchen features wood shaker cabinets, ample counter space, bar seating for 8, a pot filler and pass through impact window to the lanai. The large primary suite offers sliding glass doors to the pool area with views of the canal and a beautifully renovated en suite bath with a freestanding soaking tub, oversized walk in shower and large vanity. Two spacious guest bedrooms are located toward the back of the home and share a large bath that also functions as a pool bath. The fourth bedroom sits just off the kitchen with French doors and works perfectly as a home office, gym, playroom or additional guest space. A half bath and interior laundry room add convenience and functionality. Located within walking distance to Rotary Park and nature trails and just a short bike ride to Tarpon Point Marina with waterfront dining, shopping and entertainment, this property also places you minutes from everyday conveniences while offering the best of Southwest Florida living.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2755) "**This house comes with a REDUCED RATE through the seller's preferred lender...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->PublicRemarks
**This house comes with a REDUCED RATE through the seller's preferred lender. This is a lender-paid rate buydown that reduces the buyer's interest rate and monthly payment.** Welcome to this gorgeous, move-in-ready 3-bedroom, 2.5-bath POOL home in the desirable Oakland Shores neighborhood of Maitland! Situated on an oversized, beautifully landscaped lot, this exceptional home welcomes you with mature landscaping, a large circular driveway, and additional side parking ideal for a boat or RV. Inside, you’ll immediately appreciate the light and bright open feel, luxury vinyl flooring, and crown molding throughout the main living areas. The formal living room flows seamlessly into the dining and family rooms, all overlooking the spectacular resort-style pool and backyard. The expansive sparkling pool is surrounded by a custom pavered patio with multiple spaces for lounging, dining, and entertaining, while the generous green space and privacy create your own backyard retreat. The beautifully appointed kitchen features quartz countertops, white shaker cabinetry, stainless steel appliances, a center island with sink, walk-in pantry, and a charming dining nook with custom seating. The spacious primary suite offers direct pool access, a huge walk-in closet with a custom organizing system, and a spa-like ensuite bath complete with dual sinks, vanity, garden tub, and separate glass-enclosed shower. Two generously sized secondary bedrooms share an upgraded full bath, while an additional upgraded half bath provides convenience for guests. A well-designed interior laundry room includes built-in cabinetry and direct access to the yard. One of the home’s most versatile features is the large bonus room, complete with a spacious walk-in, air-conditioned storage room. Whether you envision a home gym, classroom, office, creative space, or potential mother-in-law suite, the possibilities are endless. Recent updates provide additional peace of mind, including a roof and septic system replaced in 2017. The septic was recently cleaned in 2025 with the filter replaced. Additional upgrades include electrical, fencing, water heater, pool pump, interior paint, HVAC, irrigation pump, plumbing, and windows. Oakland Shores offers a wonderful neighborhood setting for walking and includes deeded access to Lake Faith, a non-motorized lake great for paddle boarding and kayaking, with a community access point on Lake Shore Drive. Conveniently located near shopping, dining, major roadways, and the newly planned Maitland Trader Joe’s, this home combines comfort, versatility, privacy, and an ideal Maitland location. With its beautiful pool, oversized lot, extensive updates, and flexible living spaces, this is one you won’t want to miss!
⇄⧉public Appliances -> string (83) "Dishwasher,Disposal,Dryer,Electric Water Heater,Microwave,Range,Refrigerator...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->Appliances
Dishwasher,Disposal,Dryer,Electric Water Heater,Microwave,Range,Refrigerator,Washer
⇄public BathroomsFull -> integer 2
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->BathroomsFull
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (2755) "**This house comes with a REDUCED RATE through the seller's preferred lender...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_PublicRemarksAgent
**This house comes with a REDUCED RATE through the seller's preferred lender. This is a lender-paid rate buydown that reduces the buyer's interest rate and monthly payment.** Welcome to this gorgeous, move-in-ready 3-bedroom, 2.5-bath POOL home in the desirable Oakland Shores neighborhood of Maitland! Situated on an oversized, beautifully landscaped lot, this exceptional home welcomes you with mature landscaping, a large circular driveway, and additional side parking ideal for a boat or RV. Inside, you’ll immediately appreciate the light and bright open feel, luxury vinyl flooring, and crown molding throughout the main living areas. The formal living room flows seamlessly into the dining and family rooms, all overlooking the spectacular resort-style pool and backyard. The expansive sparkling pool is surrounded by a custom pavered patio with multiple spaces for lounging, dining, and entertaining, while the generous green space and privacy create your own backyard retreat. The beautifully appointed kitchen features quartz countertops, white shaker cabinetry, stainless steel appliances, a center island with sink, walk-in pantry, and a charming dining nook with custom seating. The spacious primary suite offers direct pool access, a huge walk-in closet with a custom organizing system, and a spa-like ensuite bath complete with dual sinks, vanity, garden tub, and separate glass-enclosed shower. Two generously sized secondary bedrooms share an upgraded full bath, while an additional upgraded half bath provides convenience for guests. A well-designed interior laundry room includes built-in cabinetry and direct access to the yard. One of the home’s most versatile features is the large bonus room, complete with a spacious walk-in, air-conditioned storage room. Whether you envision a home gym, classroom, office, creative space, or potential mother-in-law suite, the possibilities are endless. Recent updates provide additional peace of mind, including a roof and septic system replaced in 2017. The septic was recently cleaned in 2025 with the filter replaced. Additional upgrades include electrical, fencing, water heater, pool pump, interior paint, HVAC, irrigation pump, plumbing, and windows. Oakland Shores offers a wonderful neighborhood setting for walking and includes deeded access to Lake Faith, a non-motorized lake great for paddle boarding and kayaking, with a community access point on Lake Shore Drive. Conveniently located near shopping, dining, major roadways, and the newly planned Maitland Trader Joe’s, this home combines comfort, versatility, privacy, and an ideal Maitland location. With its beautiful pool, oversized lot, extensive updates, and flexible living spaces, this is one you won’t want to miss!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (2167) "**SELLER INCENTIVE: Seller is currently offering up to $25,000 toward buyer ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->PublicRemarks
**SELLER INCENTIVE: Seller is currently offering up to $25,000 toward buyer closing costs, prepaid expenses, and/or an interest-rate buydown subject to lender and program guidelines.**
Discover resort-style living and a private wellness retreat at 3819 W. San Miguel Street in South Tampa. This beautifully updated smart home features a 3-bedroom, 2-bath main residence along with a detached 1-bedroom, 1-bath guest house/ADU with a private entrance, offering flexible space for guests, a home office, studio, fitness area, or additional living space.
The centerpiece of the property is the private backyard retreat, thoughtfully designed for wellness, relaxation, and entertaining. Enjoy an in-ground saltwater pool, heated spa, cold plunge, sauna, cabana-style entertaining area, mature landscaping, and a fully fenced yard. A rear porch and deck provide additional outdoor living space for relaxing or gathering poolside.
Inside, the open-concept layout connects the kitchen and family room for comfortable everyday living and entertaining. The updated kitchen features quartz countertops, newer cabinetry, appliances, and casual dining space. A separate dining area with wet bar provides additional entertaining space. Other features include smart-home technology, updated flooring, remodeled interior spaces, walk-in closets, a spacious primary suite, and fresh exterior paint on both the main residence and detached guest house.
The property is situated on approximately 0.21 acres in Southland Addition and includes a circular driveway, attached one-car garage, storage, rain gutters, mature oak trees, and multiple indoor and outdoor living areas.
Conveniently located near Plant High School and within easy reach of Bayshore Boulevard, Hyde Park, Downtown Tampa, dining, shopping, recreation, and entertainment.
With a detached guest house, extensive wellness amenities, updated interiors, and flexible indoor-outdoor living spaces, 3819 W. San Miguel Street offers a distinctive opportunity to enjoy a private resort-inspired lifestyle in South Tampa.
Schedule your private showing and experience everything this property has to offer.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->DirectionFaces
⇄⧉public Directions -> string (155) "Head south on S Dale Mabry Highway, then turn right onto W San Miguel Street...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->Directions
Head south on S Dale Mabry Highway, then turn right onto W San Miguel Street. Continue west on W San Miguel Street to 3819 W San Miguel St, Tampa, FL 33629
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (2167) "**SELLER INCENTIVE: Seller is currently offering up to $25,000 toward buyer ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_PublicRemarksAgent
**SELLER INCENTIVE: Seller is currently offering up to $25,000 toward buyer closing costs, prepaid expenses, and/or an interest-rate buydown subject to lender and program guidelines.**
Discover resort-style living and a private wellness retreat at 3819 W. San Miguel Street in South Tampa. This beautifully updated smart home features a 3-bedroom, 2-bath main residence along with a detached 1-bedroom, 1-bath guest house/ADU with a private entrance, offering flexible space for guests, a home office, studio, fitness area, or additional living space.
The centerpiece of the property is the private backyard retreat, thoughtfully designed for wellness, relaxation, and entertaining. Enjoy an in-ground saltwater pool, heated spa, cold plunge, sauna, cabana-style entertaining area, mature landscaping, and a fully fenced yard. A rear porch and deck provide additional outdoor living space for relaxing or gathering poolside.
Inside, the open-concept layout connects the kitchen and family room for comfortable everyday living and entertaining. The updated kitchen features quartz countertops, newer cabinetry, appliances, and casual dining space. A separate dining area with wet bar provides additional entertaining space. Other features include smart-home technology, updated flooring, remodeled interior spaces, walk-in closets, a spacious primary suite, and fresh exterior paint on both the main residence and detached guest house.
The property is situated on approximately 0.21 acres in Southland Addition and includes a circular driveway, attached one-car garage, storage, rain gutters, mature oak trees, and multiple indoor and outdoor living areas.
Conveniently located near Plant High School and within easy reach of Bayshore Boulevard, Hyde Park, Downtown Tampa, dining, shopping, recreation, and entertainment.
With a detached guest house, extensive wellness amenities, updated interiors, and flexible indoor-outdoor living spaces, 3819 W. San Miguel Street offers a distinctive opportunity to enjoy a private resort-inspired lifestyle in South Tampa.
Schedule your private showing and experience everything this property has to offer.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2652) "Discover an extraordinary expression of luxury at The Ritz-Carlton Beach Res...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->PublicRemarks
Discover an extraordinary expression of luxury at The Ritz-Carlton Beach Residences, where timeless sophistication, exceptional service, and the legendary standards of Ritz-Carlton management come together in one remarkable coastal retreat. This residence, fully furnished and move-in ready, was re-envisioned and completely transformed in 2024 with a million dollars renovation. It offers generous proportions, refined European-inspired design, and the enduring quality of Amish craftsmanship. Every detail was considered to create a sophisticated yet comfortable enclave—a private sanctuary. Breathtaking views, framed by dramatic floor-to-ceiling glass, capture the very essence of coastal living. Watch nature unfold from the expansive balcony, with sweeping views across a lagoon, bird sanctuary and the Intracoastal Waterway. As day turns to evening, the downtown Sarasota skyline comes alive with twinkling lights, creating an enchanting backdrop for cocktails, intimate dinners, and moonlit evenings. The versatile floor plan offers two bedrooms and three baths. The office/den includes a murphy bed for ultimate flexibility. Two beautifully appointed primary suites provide exceptional privacy and spa-like ambiance. A gourmet kitchen sits at the heart of this home, perfect for refined entertaining or relaxed family gatherings. Ten-foot ceilings, custom finishes, and an understated elegance carry throughout, while a private elevator foyer provides an exclusive arrival experience. The Beach Residences offer an extraordinary collection of amenities designed around wellness, relaxation, work and social connection. Residents enjoy access to a private boardroom, theater, sauna, massage room, guest suites and flexible recreation space for yoga, ping-pong, and more—all complemented by the attentive, discreet service synonymous with Ritz-Carlton. The Beach Club is one of Lido Key's most coveted amenities, and membership is included with this residence - complete with tiki bar, pool, restaurant and bar, to add another layer of effortless convenience. St. Armands Circle is also close at hand, easily reached by foot, bicycle, car, or the Ritz-Carlton shuttle for exceptional dining, boutique shopping, and Sarasota's vibrant coastal lifestyle. Here, luxury is not simply something you see—it is something you experience every day. From spectacular sunrise and moonlight views to private evenings overlooking the water, from impeccable interiors to world-class service, this is a rare opportunity to enjoy coastal beauty, sophisticated design, and quiet opulence in the perfect seasonal escape or year-round haven.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->Appliances
Bar Fridge,Built-In Oven,Convection Oven,Dishwasher,Disposal,Dryer,Electric Water Heater,Exhaust Fan,Microwave,Range,Range Hood,Refrigerator,Washer,Wine Refrigerator
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 263
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->DaysOnMarket
⇄public DirectionFaces -> string (4) "West"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->DirectionFaces
⇄⧉public Directions -> string (229) "From North Tamiami Trail and Bayfront Drive, head west on John Ringling Blvd...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->Directions
From North Tamiami Trail and Bayfront Drive, head west on John Ringling Blvd to St. Armands Circle. 2nd exit from the Circle to stay on John Ringling Blvd. Left on Benjamin Franklin Drive. Turn right into The Beach Residences.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (2652) "Discover an extraordinary expression of luxury at The Ritz-Carlton Beach Res...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_PublicRemarksAgent
Discover an extraordinary expression of luxury at The Ritz-Carlton Beach Residences, where timeless sophistication, exceptional service, and the legendary standards of Ritz-Carlton management come together in one remarkable coastal retreat. This residence, fully furnished and move-in ready, was re-envisioned and completely transformed in 2024 with a million dollars renovation. It offers generous proportions, refined European-inspired design, and the enduring quality of Amish craftsmanship. Every detail was considered to create a sophisticated yet comfortable enclave—a private sanctuary. Breathtaking views, framed by dramatic floor-to-ceiling glass, capture the very essence of coastal living. Watch nature unfold from the expansive balcony, with sweeping views across a lagoon, bird sanctuary and the Intracoastal Waterway. As day turns to evening, the downtown Sarasota skyline comes alive with twinkling lights, creating an enchanting backdrop for cocktails, intimate dinners, and moonlit evenings. The versatile floor plan offers two bedrooms and three baths. The office/den includes a murphy bed for ultimate flexibility. Two beautifully appointed primary suites provide exceptional privacy and spa-like ambiance. A gourmet kitchen sits at the heart of this home, perfect for refined entertaining or relaxed family gatherings. Ten-foot ceilings, custom finishes, and an understated elegance carry throughout, while a private elevator foyer provides an exclusive arrival experience. The Beach Residences offer an extraordinary collection of amenities designed around wellness, relaxation, work and social connection. Residents enjoy access to a private boardroom, theater, sauna, massage room, guest suites and flexible recreation space for yoga, ping-pong, and more—all complemented by the attentive, discreet service synonymous with Ritz-Carlton. The Beach Club is one of Lido Key's most coveted amenities, and membership is included with this residence - complete with tiki bar, pool, restaurant and bar, to add another layer of effortless convenience. St. Armands Circle is also close at hand, easily reached by foot, bicycle, car, or the Ritz-Carlton shuttle for exceptional dining, boutique shopping, and Sarasota's vibrant coastal lifestyle. Here, luxury is not simply something you see—it is something you experience every day. From spectacular sunrise and moonlight views to private evenings overlooking the water, from impeccable interiors to world-class service, this is a rare opportunity to enjoy coastal beauty, sophisticated design, and quiet opulence in the perfect seasonal escape or year-round haven.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_AssociationFeeRequirement
⇄⧉public MFR_AdditionalWaterInformation -> string (240) "Wonderful view of Sarasota Skyline, Big Pass, Sarasota Bay, quiet lagoons wi...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_AdditionalWaterInformation
Wonderful view of Sarasota Skyline, Big Pass, Sarasota Bay, quiet lagoons with fish jumping. Partial views of the John Ringling Bridge and Gulf of Mexico. One of the best views in Sarasota especially during the Fourth of July and New Years.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1122) "A Rare Opportunity on North Siesta Key with exceptional weekly income, prime...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->PublicRemarks
A Rare Opportunity on North Siesta Key with exceptional weekly income, prime location 350 Feet of Waterfront!
Discover this unique multi-family income producing single-story property on Bay Island, offering both beauty and potential. High and dry, the home remained unaffected by recent storms, with 4–5 feet of elevation to spare. Set on a tranquil, tropical lot, this historic location on Garden Lane—once home to the Siesta Key Fish Market—with easy fast access to the bay and Big Pass it is truly a boater’s and fisherman’s paradise. Just a few steps to Shell Beach and its breathtaking sunsets, minutes from the world famous Siesta Beach, Siesta Village with restaurants, shopping, nightlife, quick access to downtown, and St. Armands Circle. You have it all!
The property features a classic Florida ranch-style 4-bedroom, 2-bathroom home with a pool, large deck, and lush backyard designed for entertaining, plus a detached 2-bedroom, 2-bathroom guest house. Whether you choose to renovate, rebuild, or divide the lot (buyers to verify with the City), the possibilities are endless with this property!
⇄public Appliances -> string (61) "Dishwasher,Dryer,Electric Water Heater,Microwave,Range,Washer"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Appliances
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 414
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->DaysOnMarket
⇄public DirectionFaces -> string (4) "West"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->DirectionFaces
⇄⧉public Directions -> string (156) "Take the North Siesta Key bridge onto the island and continue over the hump ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Directions
Take the North Siesta Key bridge onto the island and continue over the hump back bridge around the large corner. Garden Lane is the 3rd. street on the left.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxAnnualAmount
⇄public TaxBlock -> string (2) "23"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxBlock
⇄public TaxBookNumber -> string (4) "A-38"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxBookNumber
⇄⧉public TaxLegalDescription -> string (163) "LOTS 2 & 3, BLK 23 & LOTS 4 & 5, BLK 22 & VAC ST BETWEEN SAID LOTS & E 1/2 V...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxLegalDescription
LOTS 2 & 3, BLK 23 & LOTS 4 & 5, BLK 22 & VAC ST BETWEEN SAID LOTS & E 1/2 VAC ST W LOT 3 BLK 23 REVISED PLAT OF SIESTA, BEING SAME LANDS AS DESC IN ORI 2016003221
⇄public TaxLot -> string (1) "2"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxLot
⇄public TaxYear -> string (4) "2024"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->TaxYear
⇄public Township -> string (3) "36S"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Township
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1122) "A Rare Opportunity on North Siesta Key with exceptional weekly income, prime...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_PublicRemarksAgent
A Rare Opportunity on North Siesta Key with exceptional weekly income, prime location 350 Feet of Waterfront!
Discover this unique multi-family income producing single-story property on Bay Island, offering both beauty and potential. High and dry, the home remained unaffected by recent storms, with 4–5 feet of elevation to spare. Set on a tranquil, tropical lot, this historic location on Garden Lane—once home to the Siesta Key Fish Market—with easy fast access to the bay and Big Pass it is truly a boater’s and fisherman’s paradise. Just a few steps to Shell Beach and its breathtaking sunsets, minutes from the world famous Siesta Beach, Siesta Village with restaurants, shopping, nightlife, quick access to downtown, and St. Armands Circle. You have it all!
The property features a classic Florida ranch-style 4-bedroom, 2-bathroom home with a pool, large deck, and lush backyard designed for entertaining, plus a detached 2-bedroom, 2-bathroom guest house. Whether you choose to renovate, rebuild, or divide the lot (buyers to verify with the City), the possibilities are endless with this property!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1626) "This recently constructed 2024 contemporary custom-built home has it all. En...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->PublicRemarks
This recently constructed 2024 contemporary custom-built home has it all. Enjoy breathtaking wide open Intracoastal Waterway views from every room in the house! Beautiful solid white oak stair treads with a welded aluminum stair frame, beautifully lighted. The mid-level features a great room plan with incredible panoramic water views. A gourmet kitchen with gleaming marble surfaces, quality stainless steel appliances, gas cooking, a pot filler, custom cabinetry and a huge center island. The second-level covered porch overlooks the water. Hardwired for music throughout every level, inside and out. Large principal bedroom with cathedral ceilings that extend into the luxurious bathroom, complete with a soaking tub, separate shower, and top-of-the-line fixtures. The third level includes a guest suite, a third bedroom, two bathrooms and another balcony with fantastic Intracoastal views. The first level has all the room you need for cars, tools and toys. The garage is 30 x 33 with an epoxied floor and 2 electric car charging stations. The lower level has a covered patio that overlooks the salt water pool and spa (travertine tile deck) . This home is equipped with Solar power, a generator, natural gas for the cooktop & dryer, and a propane system that runs the Generac generator, pool heater & water heater (The electric bill in the summer is approximately $270). Pool and spa. 13,000-pound boat lift, jet ski lift & kayak rack. Second and third-floor balconies include filtered water power washers for easy maintenance. New seawall. There is also an assumable $1,200,000 loan at 3.375% (Buyer must be qualified).
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Appliances
Built-In Oven,Convection Oven,Cooktop,Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Microwave,Range Hood,Refrigerator,Tankless Water Heater,Washer,Water Softener
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (1626) "This recently constructed 2024 contemporary custom-built home has it all. En...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_PublicRemarksAgent
This recently constructed 2024 contemporary custom-built home has it all. Enjoy breathtaking wide open Intracoastal Waterway views from every room in the house! Beautiful solid white oak stair treads with a welded aluminum stair frame, beautifully lighted. The mid-level features a great room plan with incredible panoramic water views. A gourmet kitchen with gleaming marble surfaces, quality stainless steel appliances, gas cooking, a pot filler, custom cabinetry and a huge center island. The second-level covered porch overlooks the water. Hardwired for music throughout every level, inside and out. Large principal bedroom with cathedral ceilings that extend into the luxurious bathroom, complete with a soaking tub, separate shower, and top-of-the-line fixtures. The third level includes a guest suite, a third bedroom, two bathrooms and another balcony with fantastic Intracoastal views. The first level has all the room you need for cars, tools and toys. The garage is 30 x 33 with an epoxied floor and 2 electric car charging stations. The lower level has a covered patio that overlooks the salt water pool and spa (travertine tile deck) . This home is equipped with Solar power, a generator, natural gas for the cooktop & dryer, and a propane system that runs the Generac generator, pool heater & water heater (The electric bill in the summer is approximately $270). Pool and spa. 13,000-pound boat lift, jet ski lift & kayak rack. Second and third-floor balconies include filtered water power washers for easy maintenance. New seawall. There is also an assumable $1,200,000 loan at 3.375% (Buyer must be qualified).
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1494) "Virtually Staged. Nearly two acres. No HOA. Five bedrooms, four bathrooms, a...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->PublicRemarks
Virtually Staged. Nearly two acres. No HOA. Five bedrooms, four bathrooms, a heated saltwater pool, and a detached garage with 12-foot doors built for a boat, RV, cars, or your toys. The in-law suite is the standout. Private entrance, full bathroom, its own laundry room, and interior access through the kitchen. Ideal for multi-generational living, extended family, or guests who want their own space. Three wood-burning fireplaces run through the home. One in the living room, flanked by built-in shelving. One in the family room, where brick flooring, built-in window seats, and a wall of windows look out to the pool. The third is in the primary suite. The great room joins kitchen, living, and dining with deep cabinetry, stainless steel appliances, and a walk-in pantry. The primary suite opens to the lanai through French doors and includes dual walk-in closets and built-in bench seating. Its bathroom has a soaking tub with waterfall feature, a glass-enclosed shower, and its own lanai access. A second laundry room sits down the hall. Outside, the screened lanai holds the heated pool and spa, multiple lounging areas, ceiling fans, and an outdoor shower. The pool is heated for the cold months of the year. Hidden Waters Nature Preserve is within walking distance for trail access. The Harris Chain of Lakes is close by for boating and fishing. SR 429 puts Orlando's business and entertainment districts and the east coast beaches within easy reach. Schedule your private tour today.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->Appliances
Built-In Oven,Cooktop,Dishwasher,Disposal,Dryer,Exhaust Fan,Microwave,Range,Range Hood,Refrigerator,Tankless Water Heater,Washer,Water Filtration System
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (1476) "Nearly two acres. No HOA. Five bedrooms, four bathrooms, a heated saltwater ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_PublicRemarksAgent
Nearly two acres. No HOA. Five bedrooms, four bathrooms, a heated saltwater pool, and a detached garage with 12-foot doors built for a boat, RV, cars, or your toys. The in-law suite is the standout. Private entrance, full bathroom, its own laundry room, and interior access through the kitchen. Ideal for multi-generational living, extended family, or guests who want their own space. Three wood-burning fireplaces run through the home. One in the living room, flanked by built-in shelving. One in the family room, where brick flooring, built-in window seats, and a wall of windows look out to the pool. The third is in the primary suite. The great room joins kitchen, living, and dining with deep cabinetry, stainless steel appliances, and a walk-in pantry. The primary suite opens to the lanai through French doors and includes dual walk-in closets and built-in bench seating. Its bathroom has a soaking tub with waterfall feature, a glass-enclosed shower, and its own lanai access. A second laundry room sits down the hall. Outside, the screened lanai holds the heated pool and spa, multiple lounging areas, ceiling fans, and an outdoor shower. The pool is heated for the cold months of the year. Hidden Waters Nature Preserve is within walking distance for trail access. The Harris Chain of Lakes is close by for boating and fishing. SR 429 puts Orlando's business and entertainment districts and the east coast beaches within easy reach. Schedule your private tour today.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1120) "Spacious Potential 3 or 4 Bedroom 2 bath Rental in Frostproof-City Convenien...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->PublicRemarks
Spacious Potential 3 or 4 Bedroom 2 bath Rental in Frostproof-City Convenience with Plenty of Outdoor Living! This Charming home in the heart of Frostproof offers generous living space and practical features, perfect for comfortable everyday living. Inside, you'll find large, spacious rooms with ceramic tile throughout, making for easy maintenance and a clean, modern look. The floor plan includes some unique characteristics , including a layout where on bedroom provides access to the second bedroom and bathroom--a functional but unconventional setup. Enjoy multiple outdoor living areas with a screen-enclosed front porch, an open covered rear porch, and an additional screened and enclosed side porch, ideal for relaxing or entertaining. The fenced yard with gates add privacy and security, while the double car carport and inside laundry add convenience. Situated within Frostproof city limits, the home benefits from city maintained paved roads, water and sewer services. Don't miss the opportunity to enjoy spacious living and a variety of indoor and outdoor spaces, all just minutes from local amenities.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_AttributionContact
⇄⧉public MFR_PublicRemarksAgent -> string (1120) "Spacious Potential 3 or 4 Bedroom 2 bath Rental in Frostproof-City Convenien...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_PublicRemarksAgent
Spacious Potential 3 or 4 Bedroom 2 bath Rental in Frostproof-City Convenience with Plenty of Outdoor Living! This Charming home in the heart of Frostproof offers generous living space and practical features, perfect for comfortable everyday living. Inside, you'll find large, spacious rooms with ceramic tile throughout, making for easy maintenance and a clean, modern look. The floor plan includes some unique characteristics , including a layout where on bedroom provides access to the second bedroom and bathroom--a functional but unconventional setup. Enjoy multiple outdoor living areas with a screen-enclosed front porch, an open covered rear porch, and an additional screened and enclosed side porch, ideal for relaxing or entertaining. The fenced yard with gates add privacy and security, while the double car carport and inside laundry add convenience. Situated within Frostproof city limits, the home benefits from city maintained paved roads, water and sewer services. Don't miss the opportunity to enjoy spacious living and a variety of indoor and outdoor spaces, all just minutes from local amenities.
new \Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse($body)
/**
* RFResponse constructor.
*/
Defined in <ROOT>/wp-content/plugins/mls-on-the-fly/src/Components/CloudPost/SubComponents/RFClient/SDK/RF/RFResponse.php:43
⇄RF Response Time => string (11) "0.1 seconds"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Circular Driveway\' OR ArchitecturalStyle eq \'Circular Driveway\' OR CommunityFeatures eq \'Circular Driveway\' OR Cooling eq \'Circular Driveway\' OR CountyOrParish eq \'Circular Driveway\' OR ElementarySchool eq \'Circular Driveway\' OR ExteriorFeatures eq \'Circular Driveway\' OR Flooring eq \'Circular Driveway\' OR Heating eq \'Circular Driveway\' OR HighSchool eq \'Circular Driveway\' OR InteriorFeatures eq \'Circular Driveway\' OR ListingTerms eq \'Circular Driveway\' OR MiddleOrJuniorSchool eq \'Circular Driveway\' OR ParkingFeatures eq \'Circular Driveway\' OR PoolFeatures eq \'Circular Driveway\' OR PropertyType eq \'Circular Driveway\' OR Roof eq \'Circular Driveway\' OR SchoolDistrict eq \'Circular Driveway\' OR Sewer eq \'Circular Driveway\' OR Utilities eq \'Circular Driveway\' OR WaterfrontFeatures eq \'Circular Driveway\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response Time']