$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 83
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1982) "Welcome to this beautifully updated 2-bedroom, 1-bath home in the heart of G...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->PublicRemarks
Welcome to this beautifully updated 2-bedroom, 1-bath home in the heart of GULFPORT, Florida—one of Pinellas County's most sought-after waterfront communities known for its artsy vibe, walkable downtown, and coastal charm. Combining CLASSIC CHARACTER and MAJOR MODERN UPGRADES, this move-in-ready property offers comfort, convenience, and an exceptional location near Gulfport Beach, St. Pete Beach, and downtown St. Petersburg. SIGNIFICANT IMPROVEMENTS completed in 2018 include a NEW ROOF, HVAC system, 200-amp ELECTRIC PANEL, updated electrical outlets and switches, and a FULLY RENOVATED KITCHEN featuring contemporary finishes and functionality. BRAND NEW TANKLESS WATER HEATER 2026. Original HARDWOOD FLOORS have been beautifully refinished, preserving the home's timeless appeal, while ceiling fans throughout enhance year-round comfort. A fully enclosed, air-conditioned FLEX SPACE provides valuable ADDITIONAL SQUARE FOOTAGE and endless possibilities for a home office, art studio, gym, guest space, or bonus room. The versatile layout makes this property ideal for remote workers, creatives, seasonal residents, first-time homebuyers, or investors seeking a Gulfport rental property. Located just 1.5 miles from GULFPORT BEACH and the vibrant Gulfport Waterfront District, you'll enjoy easy access to local restaurants, coffee shops, boutiques, art galleries, waterfront parks, and community events. ST. PETE BEACH is only 3.5 miles away, offering world-famous beaches, boating, fishing, and outdoor recreation. DOWNTOWN ST. PETERSBURG, with its thriving dining, entertainment, and cultural scene, is just a short drive away, while nearby INTERSTATE 275 access provides convenient commuting throughout the Tampa Bay area. Whether you're searching for a Gulfport Florida home for sale, a charming beach-area bungalow, or a property close to St. Petersburg and the Gulf beaches, this exceptional home delivers the perfect combination of location, updates, and lifestyle.
⇄public Appliances -> string (62) "Electric Water Heater,Range,Refrigerator,Tankless Water Heater"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->Appliances
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->CreationDate
⇄public DirectionFaces -> string (5) "North"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->DirectionFaces
⇄⧉public Directions -> string (166) "From 49th Street, turn westbound on 12th Avenue South and travel 2 blocks. T...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->Directions
From 49th Street, turn westbound on 12th Avenue South and travel 2 blocks. The home is on the left on the southeast corner of 12th Avenue South and York Street South.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1982) "Welcome to this beautifully updated 2-bedroom, 1-bath home in the heart of G...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_PublicRemarksAgent
Welcome to this beautifully updated 2-bedroom, 1-bath home in the heart of GULFPORT, Florida—one of Pinellas County's most sought-after waterfront communities known for its artsy vibe, walkable downtown, and coastal charm. Combining CLASSIC CHARACTER and MAJOR MODERN UPGRADES, this move-in-ready property offers comfort, convenience, and an exceptional location near Gulfport Beach, St. Pete Beach, and downtown St. Petersburg. SIGNIFICANT IMPROVEMENTS completed in 2018 include a NEW ROOF, HVAC system, 200-amp ELECTRIC PANEL, updated electrical outlets and switches, and a FULLY RENOVATED KITCHEN featuring contemporary finishes and functionality. BRAND NEW TANKLESS WATER HEATER 2026. Original HARDWOOD FLOORS have been beautifully refinished, preserving the home's timeless appeal, while ceiling fans throughout enhance year-round comfort. A fully enclosed, air-conditioned FLEX SPACE provides valuable ADDITIONAL SQUARE FOOTAGE and endless possibilities for a home office, art studio, gym, guest space, or bonus room. The versatile layout makes this property ideal for remote workers, creatives, seasonal residents, first-time homebuyers, or investors seeking a Gulfport rental property. Located just 1.5 miles from GULFPORT BEACH and the vibrant Gulfport Waterfront District, you'll enjoy easy access to local restaurants, coffee shops, boutiques, art galleries, waterfront parks, and community events. ST. PETE BEACH is only 3.5 miles away, offering world-famous beaches, boating, fishing, and outdoor recreation. DOWNTOWN ST. PETERSBURG, with its thriving dining, entertainment, and cultural scene, is just a short drive away, while nearby INTERSTATE 275 access provides convenient commuting throughout the Tampa Bay area. Whether you're searching for a Gulfport Florida home for sale, a charming beach-area bungalow, or a property close to St. Petersburg and the Gulf beaches, this exceptional home delivers the perfect combination of location, updates, and lifestyle.
⇄public MFR_AvailableForLeaseYN -> string (1) "1"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->CreationDate
⇄public CumulativeDaysOnMarket -> integer 2
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 53
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->DaysOnMarket
⇄public DirectionFaces -> string (5) "South"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_LeaseRestrictionsYN
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->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 Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->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.09 seconds"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq \'Azalea Middle-PN\' OR ArchitecturalStyle eq \'Azalea Middle-PN\' OR CommunityFeatures eq \'Azalea Middle-PN\' OR Cooling eq \'Azalea Middle-PN\' OR CountyOrParish eq \'Azalea Middle-PN\' OR ElementarySchool eq \'Azalea Middle-PN\' OR ExteriorFeatures eq \'Azalea Middle-PN\' OR Flooring eq \'Azalea Middle-PN\' OR Heating eq \'Azalea Middle-PN\' OR HighSchool eq \'Azalea Middle-PN\' OR InteriorFeatures eq \'Azalea Middle-PN\' OR ListingTerms eq \'Azalea Middle-PN\' OR MiddleOrJuniorSchool eq \'Azalea Middle-PN\' OR ParkingFeatures eq \'Azalea Middle-PN\' OR PoolFeatures eq \'Azalea Middle-PN\' OR PropertyType eq \'Azalea Middle-PN\' OR Roof eq \'Azalea Middle-PN\' OR SchoolDistrict eq \'Azalea Middle-PN\' OR Sewer eq \'Azalea Middle-PN\' OR Utilities eq \'Azalea Middle-PN\' OR WaterfrontFeatures eq \'Azalea Middle-PN\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response Time']
