$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (2144) "Let the fun begin and the income flow. Private pickleball court, pool and sp...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->PublicRemarks
Let the fun begin and the income flow. Private pickleball court, pool and spa, oversized corner lot, and an unbeatable location, this 3-bedroom, 2 full and 1 half bath home delivers the ultimate laid-back Florida lifestyle while checking every box. Designed for entertaining, the backyard is the true showpiece, featuring a sparkling pool and spa, private pickleball court, basketball area, gazebo, fire pit, generous yard space, and a convenient poolside half bath that keeps the fun outdoors. Ideally located just minutes steps from local favorites and minutes from downtown St. Petersburg, charming Gulfport, award-winning Gulf beaches, local restaurants, shopping, and everyday conveniences, this turnkey property is the perfect investment opportunity, vacation home, or full-time Florida retreat. Currently operating as a successful short-term rental with rental history available upon request, the home is ready to enjoy or begin generating income from day one. Situated on an oversized 79' x 160' fenced corner lot, the property offers 1,588 heated square feet of thoughtfully designed and easily maintained living space featuring tile, wood and laminate flooring (no carpet!), neutral finishes, white cabinetry, stainless steel appliances, a dedicated dining area, interior laundry, and a versatile Florida room off the kitchen that's perfect for casual dining, entertaining, or a convenient drop zone. The spacious primary suite features a walk-in closet, soaking tub, and separate walk-in shower, while the living room and one guest bedroom open through sliding glass doors, creating a seamless connection to the outdoor living spaces. A double side-entry gate provides easy access for boat, RV, or trailer storage. Located in Flood Zone X, with no flood insurance required and no flooding reported by the sellers, this exceptional property offers peace of mind while placing you just minutes from everything that makes St. Petersburg one of Florida's most sought-after destinations. Sold fully furnished and rental ready! Seller financing available with 30% down minimum, requirements, terms and conditions to be determined by owner.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->CreationDate
⇄public CumulativeDaysOnMarket -> integer 32
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 85
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->DaysOnMarket
⇄public DirectionFaces -> string (9) "Northeast"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->DirectionFaces
⇄⧉public Directions -> string (259) "One block away from intersection of Pasadena Ave & Central Ave. From West on...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->Directions
One block away from intersection of Pasadena Ave & Central Ave. From West on Central Avenue, Turn right onto Pasadena Avenue North, then take the immediate left onto Pinellas Way North. Continue a short distance, and the property will be located on your left.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_EscrowStreetNumber
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (2144) "Let the fun begin and the income flow. Private pickleball court, pool and sp...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_PublicRemarksAgent
Let the fun begin and the income flow. Private pickleball court, pool and spa, oversized corner lot, and an unbeatable location, this 3-bedroom, 2 full and 1 half bath home delivers the ultimate laid-back Florida lifestyle while checking every box. Designed for entertaining, the backyard is the true showpiece, featuring a sparkling pool and spa, private pickleball court, basketball area, gazebo, fire pit, generous yard space, and a convenient poolside half bath that keeps the fun outdoors. Ideally located just minutes steps from local favorites and minutes from downtown St. Petersburg, charming Gulfport, award-winning Gulf beaches, local restaurants, shopping, and everyday conveniences, this turnkey property is the perfect investment opportunity, vacation home, or full-time Florida retreat. Currently operating as a successful short-term rental with rental history available upon request, the home is ready to enjoy or begin generating income from day one. Situated on an oversized 79' x 160' fenced corner lot, the property offers 1,588 heated square feet of thoughtfully designed and easily maintained living space featuring tile, wood and laminate flooring (no carpet!), neutral finishes, white cabinetry, stainless steel appliances, a dedicated dining area, interior laundry, and a versatile Florida room off the kitchen that's perfect for casual dining, entertaining, or a convenient drop zone. The spacious primary suite features a walk-in closet, soaking tub, and separate walk-in shower, while the living room and one guest bedroom open through sliding glass doors, creating a seamless connection to the outdoor living spaces. A double side-entry gate provides easy access for boat, RV, or trailer storage. Located in Flood Zone X, with no flood insurance required and no flooding reported by the sellers, this exceptional property offers peace of mind while placing you just minutes from everything that makes St. Petersburg one of Florida's most sought-after destinations. Sold fully furnished and rental ready! Seller financing available with 30% down minimum, requirements, terms and conditions to be determined by owner.
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1601) "WATERFRONT 2BD/2BA property and resort style living in the exclusive gated Y...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->PublicRemarks
WATERFRONT 2BD/2BA property and resort style living in the exclusive gated Yacht & Tennis Club of St Pete Beach! Just a short walk to the sandy beaches of Treasure Island, this condo has tremendous views from its 5th floor balcony. To start with the condo itself... enjoy watching dolphins & sunsets from the comfort of your home, updated and open kitchen with an island, updated bathrooms, in-unit washer/dryer, hurricane shutters, an extra secured storage closet in the garage, and so many recent updates to the condo itself. Updates include: water heater (2024), furnace/ac including uv light (2022), water filter (2023), windows/sliders (2021), hurricane shutters (2018), Refrigerator (2019), Stove (2021), microwave (2025), dishwasher (2023), closet doors (2022), gemstone coating on balcony (2022).
The HOA/condo fee covers so many amenities! Included in the HOA is: water, sewer, trash, cable & internet, secure gated community with new gate access equipment, heated waterfront pool & spa, men’s/women’s saunas, clay tennis courts, pickle ball courts, updated clubhouse & activity room, new seawall, boardwalk, docks & kayak launch, state of the art fitness facility, shuffleboard, dedicated grilling area. This building has passed the milestone Engineering Study and the Structural Reserve requirements and is in great financial health.
If you are going to spend your time in Florida, spend it at a condo community that feels like the best vacation every day of the year. Enjoy countless amenities, sunset views from your condo living room, and the comfort of an updated home.
⇄⧉public Appliances -> string (153) "Convection Oven,Cooktop,Dishwasher,Dryer,Electric Water Heater,Exhaust Fan,I...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->Appliances
Convection Oven,Cooktop,Dishwasher,Dryer,Electric Water Heater,Exhaust Fan,Ice Maker,Microwave,Refrigerator,Washer,Water Filtration System,Water Softener
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->CreationDate
⇄public CumulativeDaysOnMarket -> integer 2
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 55
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->DaysOnMarket
⇄public DirectionFaces -> string (5) "South"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->DirectionFaces
⇄⧉public Directions -> string (153) "From Treasure Island, take Gulf Blvd towards St Pete Beach. Turn left on Bli...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->Directions
From Treasure Island, take Gulf Blvd towards St Pete Beach. Turn left on Blind Pass. Entry gate to Yacht & Tennis Club of St Pete Beach is on the left.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_EscrowStreetNumber
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1601) "WATERFRONT 2BD/2BA property and resort style living in the exclusive gated Y...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_PublicRemarksAgent
WATERFRONT 2BD/2BA property and resort style living in the exclusive gated Yacht & Tennis Club of St Pete Beach! Just a short walk to the sandy beaches of Treasure Island, this condo has tremendous views from its 5th floor balcony. To start with the condo itself... enjoy watching dolphins & sunsets from the comfort of your home, updated and open kitchen with an island, updated bathrooms, in-unit washer/dryer, hurricane shutters, an extra secured storage closet in the garage, and so many recent updates to the condo itself. Updates include: water heater (2024), furnace/ac including uv light (2022), water filter (2023), windows/sliders (2021), hurricane shutters (2018), Refrigerator (2019), Stove (2021), microwave (2025), dishwasher (2023), closet doors (2022), gemstone coating on balcony (2022).
The HOA/condo fee covers so many amenities! Included in the HOA is: water, sewer, trash, cable & internet, secure gated community with new gate access equipment, heated waterfront pool & spa, men’s/women’s saunas, clay tennis courts, pickle ball courts, updated clubhouse & activity room, new seawall, boardwalk, docks & kayak launch, state of the art fitness facility, shuffleboard, dedicated grilling area. This building has passed the milestone Engineering Study and the Structural Reserve requirements and is in great financial health.
If you are going to spend your time in Florida, spend it at a condo community that feels like the best vacation every day of the year. Enjoy countless amenities, sunset views from your condo living room, and the comfort of an updated home.
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_AvailableForLeaseYN
⇄public MFR_CondoLandIncludedYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_CondoLandIncludedYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_EscrowStreetNumber
⇄public MFR_ListingExclusionYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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).
⇄public MFR_ZoningCompatibleYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_ZoningCompatibleYN
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_AvailableForLeaseYN
⇄public MFR_LeaseRestrictionsYN -> string (1) "0"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_LeaseRestrictionsYN
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 (12) "0.07 seconds"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Elementary-PN\' OR ArchitecturalStyle eq \'Azalea Elementary-PN\' OR CommunityFeatures eq \'Azalea Elementary-PN\' OR Cooling eq \'Azalea Elementary-PN\' OR CountyOrParish eq \'Azalea Elementary-PN\' OR ElementarySchool eq \'Azalea Elementary-PN\' OR ExteriorFeatures eq \'Azalea Elementary-PN\' OR Flooring eq \'Azalea Elementary-PN\' OR Heating eq \'Azalea Elementary-PN\' OR HighSchool eq \'Azalea Elementary-PN\' OR InteriorFeatures eq \'Azalea Elementary-PN\' OR ListingTerms eq \'Azalea Elementary-PN\' OR MiddleOrJuniorSchool eq \'Azalea Elementary-PN\' OR ParkingFeatures eq \'Azalea Elementary-PN\' OR PoolFeatures eq \'Azalea Elementary-PN\' OR PropertyType eq \'Azalea Elementary-PN\' OR Roof eq \'Azalea Elementary-PN\' OR SchoolDistrict eq \'Azalea Elementary-PN\' OR Sewer eq \'Azalea Elementary-PN\' OR Utilities eq \'Azalea Elementary-PN\' OR WaterfrontFeatures eq \'Azalea Elementary-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response Time']
