$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (704) "Move-in Ready! This incredible Aspen II inventory home by ABD has been price...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->PublicRemarks
Move-in Ready! This incredible Aspen II inventory home by ABD has been priced to sell! It would cost you $250k more to build this new - so hurry! This is a fantastic deal. This home is LOADED. Contemporary luxury finishes throughout including gourmet kitchen, tile throughout first floor, wood stairs and wood floors upstairs, glass railing overlooking first floor great room, electric fireplace with gorgeous soaring stone wall, huge rear lanai with hidden roll down screens, AND a 3 car garage. This is a contemporary masterpiece - all located directly on the pond at the par 3 17th hole at Hampton Green at Providence Golf Club. Come live your dream for WAY less than building off-plan. Call us today.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> string (704) "Move-in Ready! This incredible Aspen II inventory home by ABD has been price...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[0]->MFR_PublicRemarksAgent
Move-in Ready! This incredible Aspen II inventory home by ABD has been priced to sell! It would cost you $250k more to build this new - so hurry! This is a fantastic deal. This home is LOADED. Contemporary luxury finishes throughout including gourmet kitchen, tile throughout first floor, wood stairs and wood floors upstairs, glass railing overlooking first floor great room, electric fireplace with gorgeous soaring stone wall, huge rear lanai with hidden roll down screens, AND a 3 car garage. This is a contemporary masterpiece - all located directly on the pond at the par 3 17th hole at Hampton Green at Providence Golf Club. Come live your dream for WAY less than building off-plan. Call us today.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (2196) "2BR/2BA Condo in The Madison, located in the Waterfront District of downtown...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->PublicRemarks
2BR/2BA Condo in The Madison, located in the Waterfront District of downtown St. Petersburg.
Welcome to The Madison, located in the Waterfront District of downtown St. Petersburg. 2br/2ba/covered garage, one assigned parking. Annual/Unfurnished rental. This Mediterranean style building is gated and complete with tropical landscaping, swimming pool, clubhouse, workout room, grills, outdoor seating, and is close to everything! Easy access to Publix, shops, museums, fine dining, live entertainment and sports venues, farmers market, USF St. Pete Campus, hospitals, banks, dali museum, the pier, Al Lang Stadium and list goes on. The unit features high ceilings 10 ft, open/split concept floor plan, freshly painted, dual master suites with large bathrooms, walkin in closets, a large soak bathtub in one and standing shower in the other, laundry room with newer full size washer and dryer, open balcony overlooking pool courtyard, extra storage, updated kitchen and baths, newer luxury vinyl plank flooring, newer HVAC, newer water heater, and a parking spot located in the garage #194. Home has an open and airy floor plan with lots of natural lighting. This is resort style living at it's best! First full month's rent and equal security deposit apply. Water Sewer Trash & basic cable/internet included. No pets. HOA fee: garage transmitter sticker for $25.00, $150 application fee for association.
If you decide to apply for one of our properties:
Screening includes credit/background check, income verification of 2.5 to 3 times the monthly rent and rental history verification.
APPLICANT CHARGES:
Application Fee: $75 each adult, 18 years of age and older (non-refundable).
Lease Initiation Admin Fee: $150.00 after approval and upon signing.
Security Deposit: Equal to one month’s rent on approved credit.
All Rent Solutions residents are enrolled in the Resident Benefits Package (RBP) for $49.95/month which includes liability insurance, credit building to help boost the resident’s credit score with timely rent payments, HVAC air filter delivery (for applicable properties), our best-in-class resident rewards program, and much more! More details upon application.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_BuildingElevatorYN
⇄public MFR_BuildingNameNumber -> string (11) "THE MADISON"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_BuildingNameNumber
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (2196) "2BR/2BA Condo in The Madison, located in the Waterfront District of downtown...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[1]->MFR_PublicRemarksAgent
2BR/2BA Condo in The Madison, located in the Waterfront District of downtown St. Petersburg.
Welcome to The Madison, located in the Waterfront District of downtown St. Petersburg. 2br/2ba/covered garage, one assigned parking. Annual/Unfurnished rental. This Mediterranean style building is gated and complete with tropical landscaping, swimming pool, clubhouse, workout room, grills, outdoor seating, and is close to everything! Easy access to Publix, shops, museums, fine dining, live entertainment and sports venues, farmers market, USF St. Pete Campus, hospitals, banks, dali museum, the pier, Al Lang Stadium and list goes on. The unit features high ceilings 10 ft, open/split concept floor plan, freshly painted, dual master suites with large bathrooms, walkin in closets, a large soak bathtub in one and standing shower in the other, laundry room with newer full size washer and dryer, open balcony overlooking pool courtyard, extra storage, updated kitchen and baths, newer luxury vinyl plank flooring, newer HVAC, newer water heater, and a parking spot located in the garage #194. Home has an open and airy floor plan with lots of natural lighting. This is resort style living at it's best! First full month's rent and equal security deposit apply. Water Sewer Trash & basic cable/internet included. No pets. HOA fee: garage transmitter sticker for $25.00, $150 application fee for association.
If you decide to apply for one of our properties:
Screening includes credit/background check, income verification of 2.5 to 3 times the monthly rent and rental history verification.
APPLICANT CHARGES:
Application Fee: $75 each adult, 18 years of age and older (non-refundable).
Lease Initiation Admin Fee: $150.00 after approval and upon signing.
Security Deposit: Equal to one month’s rent on approved credit.
All Rent Solutions residents are enrolled in the Resident Benefits Package (RBP) for $49.95/month which includes liability insurance, credit building to help boost the resident’s credit score with timely rent payments, HVAC air filter delivery (for applicable properties), our best-in-class resident rewards program, and much more! More details upon application.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1198) "Presenting an exceptional waterfront opportunity on desirable Indian Rocks B...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->PublicRemarks
Presenting an exceptional waterfront opportunity on desirable Indian Rocks Beach, this is an opportunity not to be missed! Situated on a generous lot of over 7,000 square feet with an impressive 65 feet of deep water frontage, this property features a robust seawall—offering an invaluable head start and solid foundation for your coastal vision. The existing structure, which sustained damage during the recent hurricane and is being sold as-is, currently features a functional split-floor plan with three bedrooms, two bathrooms, an air-conditioned Florida room, an in-ground pool, dedicated storage spaces, and a wide driveway. This is a premier blank canvas for investors, builders, or visionary homeowners looking to craft a personalized beachside haven in an exclusive community. Embrace the IRB lifestyle where your days can be spent boating and fishing right from your backyard, taking a stroll to the beaches and local parks, fine dining, and shopping, or enjoying a short drive to world-class golf destinations. Do not miss this outstanding chance to claim your slice of paradise and build or re-create the waterfront home of your dreams in this peaceful, highly desirable seaside town.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->DirectionFaces
⇄⧉public Directions -> string (165) "West on Walsingham Rd, to north on Gulf Blvd, to east on 8th Ave, to north o...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->Directions
West on Walsingham Rd, to north on Gulf Blvd, to east on 8th Ave, to north on E Gulf Blvd, to east on La Hacienda Dr, the property is on the south end of the street.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1198) "Presenting an exceptional waterfront opportunity on desirable Indian Rocks B...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[2]->MFR_PublicRemarksAgent
Presenting an exceptional waterfront opportunity on desirable Indian Rocks Beach, this is an opportunity not to be missed! Situated on a generous lot of over 7,000 square feet with an impressive 65 feet of deep water frontage, this property features a robust seawall—offering an invaluable head start and solid foundation for your coastal vision. The existing structure, which sustained damage during the recent hurricane and is being sold as-is, currently features a functional split-floor plan with three bedrooms, two bathrooms, an air-conditioned Florida room, an in-ground pool, dedicated storage spaces, and a wide driveway. This is a premier blank canvas for investors, builders, or visionary homeowners looking to craft a personalized beachside haven in an exclusive community. Embrace the IRB lifestyle where your days can be spent boating and fishing right from your backyard, taking a stroll to the beaches and local parks, fine dining, and shopping, or enjoying a short drive to world-class golf destinations. Do not miss this outstanding chance to claim your slice of paradise and build or re-create the waterfront home of your dreams in this peaceful, highly desirable seaside town.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (447) "CASH - ONLY Opportunity is knocking! 3 bedroom, 2 bathroom block home locate...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->PublicRemarks
CASH - ONLY Opportunity is knocking! 3 bedroom, 2 bathroom block home located on ¼ acre lot in Auburndale. No HOA Bring your vision and transform this property into a valuable investment or homestead. Buyer to conduct their own due diligence and verify all property details, measurements, zoning, and intended use. Conveniently located to the Polk Parkway for easy access to I-4. Centrally located between Orlando and Tampa. Shed does not convey.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxAnnualAmount
⇄public TaxBookNumber -> string (5) "17-50"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxBookNumber
⇄⧉public TaxLegalDescription -> string (166) "KOSSUTHVILLE SUB UNIT NO 1 PB 17 PG 50 TRACT 32F S 99.3 FT OF N 397.2 FT OF ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxLegalDescription
KOSSUTHVILLE SUB UNIT NO 1 PB 17 PG 50 TRACT 32F S 99.3 FT OF N 397.2 FT OF W 78.5 FT LESS ST & LESS ROWELL RD R/W & E 55 FT OF S 97.7 FT OF N 390.80 FT OF TRACT 31-F
⇄public TaxLot -> string (3) "31F"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxLot
⇄public TaxYear -> string (4) "2025"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->TaxYear
⇄public Township -> string (2) "28"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->Township
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (447) "CASH - ONLY Opportunity is knocking! 3 bedroom, 2 bathroom block home locate...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[3]->MFR_PublicRemarksAgent
CASH - ONLY Opportunity is knocking! 3 bedroom, 2 bathroom block home located on ¼ acre lot in Auburndale. No HOA Bring your vision and transform this property into a valuable investment or homestead. Buyer to conduct their own due diligence and verify all property details, measurements, zoning, and intended use. Conveniently located to the Polk Parkway for easy access to I-4. Centrally located between Orlando and Tampa. Shed does not convey.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->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&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->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&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->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&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->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&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[4]->MFR_PublicRemarksAgent
This recently constructed 2024 contemporary custom-built home has it all. Enjoy breathtaking wide open Intracoastal Waterway views from every room in the house! Beautiful solid white oak stair treads with a welded aluminum stair frame, beautifully lighted. The mid-level features a great room plan with incredible panoramic water views. A gourmet kitchen with gleaming marble surfaces, quality stainless steel appliances, gas cooking, a pot filler, custom cabinetry and a huge center island. The second-level covered porch overlooks the water. Hardwired for music throughout every level, inside and out. Large principal bedroom with cathedral ceilings that extend into the luxurious bathroom, complete with a soaking tub, separate shower, and top-of-the-line fixtures. The third level includes a guest suite, a third bedroom, two bathrooms and another balcony with fantastic Intracoastal views. The first level has all the room you need for cars, tools and toys. The garage is 30 x 33 with an epoxied floor and 2 electric car charging stations. The lower level has a covered patio that overlooks the salt water pool and spa (travertine tile deck) . This home is equipped with Solar power, a generator, natural gas for the cooktop & dryer, and a propane system that runs the Generac generator, pool heater & water heater (The electric bill in the summer is approximately $270). Pool and spa. 13,000-pound boat lift, jet ski lift & kayak rack. Second and third-floor balconies include filtered water power washers for easy maintenance. New seawall. There is also an assumable $1,200,000 loan at 3.375% (Buyer must be qualified).
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (1198) "NO HOA and NO LOT RENT....Own the land under this two bedroom, one and a hal...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->PublicRemarks
NO HOA and NO LOT RENT....Own the land under this two bedroom, one and a half bath manufactured home in Leesburg, complete with lake front views right from your enclosed lanai. The fully enclosed lanai with heat and air offers an additional 272 SF of living space, so you get a comfortable spot to watch the water any time of year. Luxury vinyl plank flooring runs throughout the home. The kitchen and bathroom have both been fully renovated, with soft close cabinetry and a new walk in shower and vanity in the bath. The primary bedroom has its own renovated half bath. There is a spacious utility room adds extra storage and workspace as well as an additional bonus room. Over the last four years the home has had updates to the electrical, windows, lighting, and sub flooring. The metal roof got a rubber coating four years ago, and the HVAC was recently serviced. A propane heater serves as a backup source of heat. A single carport and two storage sheds round things out. This is fee simple (NO LOT RENT), land owned, in an all age community with no HOA. Move in ready with the big ticket items already handled. Schedule a showing to see this lake front property and all the updates in person.
⇄public Appliances -> string (50) "Dryer,Electric Water Heater,Microwave,Range,Washer"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->Appliances
⇄public BathroomsFull -> integer 1
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->BathroomsFull
⇄⧉public BodyType -> array (1)
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->BodyType
⇄0 => string (11) "Single Wide"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->BodyType[0]
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_EscrowStreetNumber
⇄⧉public MFR_PublicRemarksAgent -> string (1198) "NO HOA and NO LOT RENT....Own the land under this two bedroom, one and a hal...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[5]->MFR_PublicRemarksAgent
NO HOA and NO LOT RENT....Own the land under this two bedroom, one and a half bath manufactured home in Leesburg, complete with lake front views right from your enclosed lanai. The fully enclosed lanai with heat and air offers an additional 272 SF of living space, so you get a comfortable spot to watch the water any time of year. Luxury vinyl plank flooring runs throughout the home. The kitchen and bathroom have both been fully renovated, with soft close cabinetry and a new walk in shower and vanity in the bath. The primary bedroom has its own renovated half bath. There is a spacious utility room adds extra storage and workspace as well as an additional bonus room. Over the last four years the home has had updates to the electrical, windows, lighting, and sub flooring. The metal roof got a rubber coating four years ago, and the HVAC was recently serviced. A propane heater serves as a backup source of heat. A single carport and two storage sheds round things out. This is fee simple (NO LOT RENT), land owned, in an all age community with no HOA. Move in ready with the big ticket items already handled. Schedule a showing to see this lake front property and all the updates in person.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->OriginatingSystemName
⇄⧉public PublicRemarks -> string (2137) "One rare opportunity in the heart of Pinellas County. Five subdivided lots. ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->PublicRemarks
One rare opportunity in the heart of Pinellas County. Five subdivided lots. Approximately 1.53 acres.
Welcome to 7621 75th Ave N, a unique Pinellas Park property offering the freedom to think bigger. Currently enjoyed as one expansive residential homestead, the property combines a 5-bedroom, 3-bath home with a fireplace, private pool, three-car garage, and an additional building used as an office but could potentially be an ADU. Five subdivided lots being offered together over approximately 1.53 acres.
For the buyer dreaming of their own private homestead, this is an increasingly rare opportunity to have space without giving up the convenience of a central Pinellas County location. Create gardens, enjoy the expansive lawn, make room for hobbies and recreational vehicles, or simply preserve the land around you and enjoy the privacy that comes with owning more than the typical neighborhood lot.
The existing home offers 2,387 square feet of living space with 5 bedrooms and 3 full baths. Bright living areas flow outdoors to a private pool and cabana designed for year-round Florida living. A detached four-car garage provides exceptional additional space for vehicles, equipment, storage, hobbies or a workshop.
And for those looking beyond the homestead, the opportunity becomes even more interesting.
With five subdivided lots, buyers can explore a variety of possibilities for the property. Maintain the entire acreage as a private estate or family homestead. Explore creating a multi-generational compound. Investigate new construction on additional lots. Or hold the additional land as part of a longer-term investment strategy.
It's a property that allows you to choose what matters most: space to live now, options for the future, or a combination of both. One exceptional Pinellas County opportunity.
Whether your vision is a private homestead with room to breathe or a property whose individual lots offer intriguing development possibilities, 7621 75th Ave N gives you something increasingly valuable in Pinellas County:
options.
Use it. Build on it. Hold it. Reimagine it. The opportunity is yours.
⇄public Appliances -> string (57) "Dishwasher,Disposal,Electric Water Heater,Microwave,Range"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->Appliances
⇄public AttachedGarageYN -> boolean true
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->AttachedGarageYN
⇄public BathroomsFull -> integer 3
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->BathroomsFull
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_EscrowStreetNumber
⇄⧉public MFR_PublicRemarksAgent -> string (2137) "One rare opportunity in the heart of Pinellas County. Five subdivided lots. ...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[6]->MFR_PublicRemarksAgent
One rare opportunity in the heart of Pinellas County. Five subdivided lots. Approximately 1.53 acres.
Welcome to 7621 75th Ave N, a unique Pinellas Park property offering the freedom to think bigger. Currently enjoyed as one expansive residential homestead, the property combines a 5-bedroom, 3-bath home with a fireplace, private pool, three-car garage, and an additional building used as an office but could potentially be an ADU. Five subdivided lots being offered together over approximately 1.53 acres.
For the buyer dreaming of their own private homestead, this is an increasingly rare opportunity to have space without giving up the convenience of a central Pinellas County location. Create gardens, enjoy the expansive lawn, make room for hobbies and recreational vehicles, or simply preserve the land around you and enjoy the privacy that comes with owning more than the typical neighborhood lot.
The existing home offers 2,387 square feet of living space with 5 bedrooms and 3 full baths. Bright living areas flow outdoors to a private pool and cabana designed for year-round Florida living. A detached four-car garage provides exceptional additional space for vehicles, equipment, storage, hobbies or a workshop.
And for those looking beyond the homestead, the opportunity becomes even more interesting.
With five subdivided lots, buyers can explore a variety of possibilities for the property. Maintain the entire acreage as a private estate or family homestead. Explore creating a multi-generational compound. Investigate new construction on additional lots. Or hold the additional land as part of a longer-term investment strategy.
It's a property that allows you to choose what matters most: space to live now, options for the future, or a combination of both. One exceptional Pinellas County opportunity.
Whether your vision is a private homestead with room to breathe or a property whose individual lots offer intriguing development possibilities, 7621 75th Ave N gives you something increasingly valuable in Pinellas County:
options.
Use it. Build on it. Hold it. Reimagine it. The opportunity is yours.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (905) "UNMATCHED VALUE & BUYER INCENTIVES | MOVE-IN READY GEM! The sellers are read...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->PublicRemarks
UNMATCHED VALUE & BUYER INCENTIVES | MOVE-IN READY GEM! The sellers are ready for their next chapter, creating an exceptional opportunity for a motivated buyer to step into a completely updated, pristine home with incredible built-in savings! $5,000 Seller Credit Toward Buyer Closing Costs. This beautifully renovated 3-Bedroom + BONUS Room, 2-Bath residence offers turnkey modern luxury on a spacious, private corner lot. Every detail has been thoughtfully curated for effortless Florida living and stylish entertaining. Designer Chef’s Kitchen: Sleek contemporary countertops, brand-new stainless steel appliances, custom cabinetry, and a bright open-concept layout. Flexible Living Spaces: 3 generous bedrooms plus an adaptable bonus room perfect for a home office, media room, or guest retreat. Prime Corner Lot: Extra yard space, enhanced privacy, lush curb appeal, and room to enjoy the outdoors.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->DirectionFaces
⇄⧉public Directions -> string (172) "Head south on US-41 S/Tamiami Trail toward S Access Rd, turn left onto Corne...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->Directions
Head south on US-41 S/Tamiami Trail toward S Access Rd, turn left onto Cornelius Blvd, Turn right onto Ingraham Blvd, Turn left onto Edison Dr. Turn right onto Romford Ave.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (905) "UNMATCHED VALUE & BUYER INCENTIVES | MOVE-IN READY GEM! The sellers are read...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[7]->MFR_PublicRemarksAgent
UNMATCHED VALUE & BUYER INCENTIVES | MOVE-IN READY GEM! The sellers are ready for their next chapter, creating an exceptional opportunity for a motivated buyer to step into a completely updated, pristine home with incredible built-in savings! $5,000 Seller Credit Toward Buyer Closing Costs. This beautifully renovated 3-Bedroom + BONUS Room, 2-Bath residence offers turnkey modern luxury on a spacious, private corner lot. Every detail has been thoughtfully curated for effortless Florida living and stylish entertaining. Designer Chef’s Kitchen: Sleek contemporary countertops, brand-new stainless steel appliances, custom cabinetry, and a bright open-concept layout. Flexible Living Spaces: 3 generous bedrooms plus an adaptable bonus room perfect for a home office, media room, or guest retreat. Prime Corner Lot: Extra yard space, enhanced privacy, lush curb appeal, and room to enjoy the outdoors.
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (965) "Located in Patriots Landing at Reunion Resort, this newly built 5-bedroom, 5...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->PublicRemarks
Located in Patriots Landing at Reunion Resort, this newly built 5-bedroom, 5.5-bath pool home is fully furnished, hardly used, and features all ensuite bedrooms, making it ideal as a vacation rental, second home, or primary residence. Designed with an open-concept floor plan, the home offers multiple gathering spaces, abundant natural light, themed décor throughout, and a converted garage play/entertainment area.
Enjoy seamless indoor-outdoor living with a private pool and patio, perfect for relaxing or entertaining. The main level features a Mickey and Minnie–themed bedroom with two full beds and a nearby full bath. Upstairs, a Juliet balcony overlooks the pool and leads to the spacious primary suite with a luxurious ensuite featuring double vanities and a double walk-in shower. Three additional themed bedrooms, a movie room in the loft, and an upstairs laundry room complete the second floor. Fully rental-ready—schedule your private tour today!
⇄public Appliances -> string (72) "Cooktop,Dishwasher,Disposal,Dryer,Electric Water Heater,Microwave,Washer"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->Appliances
⇄public AssociationFee -> string (3) "550"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->AssociationFee
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->CumulativeDaysOnMarket
⇄public DaysOnMarket -> integer 275
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->DaysOnMarket
⇄public DirectionFaces -> string (4) "East"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->DirectionFaces
⇄⧉public Directions -> string (252) "I 4 to exit 58, make a left on 532 (if coming from East), make a left on Reu...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->Directions
I 4 to exit 58, make a left on 532 (if coming from East), make a left on Reunion Blvd. you will have to show your ID and real estate license to Security, make a left on Linkside Loop and then a right onto Fairview Circle, the home will be on your right
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (965) "Located in Patriots Landing at Reunion Resort, this newly built 5-bedroom, 5...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[8]->MFR_PublicRemarksAgent
Located in Patriots Landing at Reunion Resort, this newly built 5-bedroom, 5.5-bath pool home is fully furnished, hardly used, and features all ensuite bedrooms, making it ideal as a vacation rental, second home, or primary residence. Designed with an open-concept floor plan, the home offers multiple gathering spaces, abundant natural light, themed décor throughout, and a converted garage play/entertainment area.
Enjoy seamless indoor-outdoor living with a private pool and patio, perfect for relaxing or entertaining. The main level features a Mickey and Minnie–themed bedroom with two full beds and a nearby full bath. Upstairs, a Juliet balcony overlooks the pool and leads to the spacious primary suite with a luxurious ensuite featuring double vanities and a double walk-in shower. Three additional themed bedrooms, a movie room in the loft, and an upstairs laundry room complete the second floor. Fully rental-ready—schedule your private tour today!
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->OriginatingSystemName
⇄⧉public PublicRemarks -> UTF-8 string (1886) "Under Construction. Pulte Homes is selling new construction home at Longmead...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->PublicRemarks
Under Construction. Pulte Homes is selling new construction home at Longmeadow at North River Ranch, ideally located in Parrish, FL. Enjoy endless amenities including a clubhouse, resort-style pool, beautiful walking trails, and a fitness center. Plus, relish in the ease of reaching Downtown Tampa, St. Petersburg, and Sarasota.
Featuring the popular Mystique floor plan with an open-concept home design, this home has all the upgraded finishes you've been looking for. The designer kitchen showcases a center island and a large, single-bowl sink, frost cabinets and 3cm quartz countertops with 4”x12” tiled backsplash, a spacious pantry, and Whirlpool stainless steel appliances including a built-in oven and microwave, dishwasher, counter depth refrigerator and stovetop with range hood.
The bathrooms have matching white cabinets and quartz countertops, dual sinks in the Owner's bath and walk-in shower with heavy glass door. There is luxury vinyl plank flooring in the main living areas, 18”x18” tile flooring in the baths and laundry room and plush, stain resistant carpet in the bedrooms.
This home makes great use of space with an enclosed flex room, a covered lanai with screen enclosure, a convenient laundry room and a 2-car garage with epoxy flooring.
Additional upgrades and features include LED downlights in gathering room, faux wood blinds and a Smart Home technology package with a video doorbell.
Enjoy peace of mind with Pulte’s transferable, 10-year Limited Structural Warranty that covers materials and workmanship in the 1st year, workability of plumbing, electrical, HVAC, and other mechanical systems through the 2nd year, various types of water infiltration and internal leaks through the 5th year, and the structural integrity of the home through the 10th year. Plus, we’re currently offering limited-time incentives and below-market rates!
⇄⧉public Appliances -> string (92) "Built-In Oven,Cooktop,Dishwasher,Disposal,Gas Water Heater,Microwave,Range H...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->Appliances
Built-In Oven,Cooktop,Dishwasher,Disposal,Gas Water Heater,Microwave,Range Hood,Refrigerator
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->DirectionFaces
⇄⧉public Directions -> string (286) "Head south on I-75 From 1-75 S, take exit 229 toward Parrish Take a sharp le...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->Directions
Head south on I-75
From 1-75 S, take exit 229 toward Parrish
Take a sharp left onto 97th St E/Moccasin Wallow Rd (signs for US-301). Turn left onto Fort Hammer Rd
Continue for 1 mile then turn left onto Camp Creek Trl, then left onto Longmeadow Ave
Destination will be on your right
⇄public ElementarySchool -> string (28) "Barbara A. Harvey Elementary"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->ElementarySchool
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_ListingExclusionYN
⇄⧉public MFR_PublicRemarksAgent -> UTF-8 string (1866) "Pulte Homes is selling new construction home at Longmeadow at North River Ra...
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response']->items[9]->MFR_PublicRemarksAgent
Pulte Homes is selling new construction home at Longmeadow at North River Ranch, ideally located in Parrish, FL. Enjoy endless amenities including a clubhouse, resort-style pool, beautiful walking trails, and a fitness center. Plus, relish in the ease of reaching Downtown Tampa, St. Petersburg, and Sarasota.
Featuring the popular Mystique floor plan with an open-concept home design, this home has all the upgraded finishes you've been looking for. The designer kitchen showcases a center island and a large, single-bowl sink, frost cabinets and 3cm quartz countertops with 4”x12” tiled backsplash, a spacious pantry, and Whirlpool stainless steel appliances including a built-in oven and microwave, dishwasher, counter depth refrigerator and stovetop with range hood.
The bathrooms have matching white cabinets and quartz countertops, dual sinks in the Owner's bath and walk-in shower with heavy glass door. There is luxury vinyl plank flooring in the main living areas, 18”x18” tile flooring in the baths and laundry room and plush, stain resistant carpet in the bedrooms.
This home makes great use of space with an enclosed flex room, a covered lanai with screen enclosure, a convenient laundry room and a 2-car garage with epoxy flooring.
Additional upgrades and features include LED downlights in gathering room, faux wood blinds and a Smart Home technology package with a video doorbell.
Enjoy peace of mind with Pulte’s transferable, 10-year Limited Structural Warranty that covers materials and workmanship in the 1st year, workability of plumbing, electrical, HVAC, and other mechanical systems through the 2nd year, various types of water infiltration and internal leaks through the 5th year, and the structural integrity of the home through the 10th year. Plus, we’re currently offering limited-time incentives and below-market rates!
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.13 seconds"
$admin_bar_mls_requests['RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=140&$filter=(Appliances eq \'Open Floorplan\' OR ArchitecturalStyle eq \'Open Floorplan\' OR CommunityFeatures eq \'Open Floorplan\' OR Cooling eq \'Open Floorplan\' OR CountyOrParish eq \'Open Floorplan\' OR ElementarySchool eq \'Open Floorplan\' OR ExteriorFeatures eq \'Open Floorplan\' OR Flooring eq \'Open Floorplan\' OR Heating eq \'Open Floorplan\' OR HighSchool eq \'Open Floorplan\' OR InteriorFeatures eq \'Open Floorplan\' OR ListingTerms eq \'Open Floorplan\' OR MiddleOrJuniorSchool eq \'Open Floorplan\' OR ParkingFeatures eq \'Open Floorplan\' OR PoolFeatures eq \'Open Floorplan\' OR PropertyType eq \'Open Floorplan\' OR Roof eq \'Open Floorplan\' OR SchoolDistrict eq \'Open Floorplan\' OR Sewer eq \'Open Floorplan\' OR Utilities eq \'Open Floorplan\' OR WaterfrontFeatures eq \'Open Floorplan\') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true']['RF Response Time']