array:1 [
"RF Query: /Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS88115353'/Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS88115353'&$expand=Media/Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS88115353'/Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS88115353'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2833
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835
+post_id: "16522"
+post_author: 1
+"ListingKey": "MIS88115353"
+"ListingId": "MIS22063361"
+"PropertyType": "Land"
+"PropertySubType": "Residential Lots"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-04-29T00:27:00Z"
+"RFModificationTimestamp": "2025-05-27T06:41:25.491552+00:00"
+"ListPrice": 2965020.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 14.33
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St Charles"
+"PostalCode": "63303"
+"UnparsedAddress": " , St Charles, Missouri 63303, USA"
+"Coordinates": array:2 [
0 => -90.524837
1 => 38.745045
]
+"Latitude": 38.745045
+"Longitude": -90.524837
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Cindy L Burcham"
+"ListOfficeName": "Berkshire Hathaway HomeServices Select Properties"
+"ListAgentMlsId": "MISCBURCHAM"
+"ListOfficeMlsId": "MISBHSP02"
+"OriginatingSystemName": "MARIS"
+"PublicRemarks": """
Amazing development opportunity right off Highway 364 in St. Charles County. This property is in a prime location and is perfect for anything from residential lots to luxury apartments or even a nursing home! The land is currently zoned R1E but can be easily converted to mixed use per St. Charles County. Arena Parkway frontage! Please call for more information. MLS 22060176 also available. Photo outlined in red is the 14.33 acres Hemsath Rd. and the property outlined in green is MLS 22060176 365 Clarence Drive which is also available for sale.\r\n
\r\n
duplicate listing of MLS# 22058650
"""
+"BuyerOfficeAOR": "St. Charles County Association of REALTORS"
+"Country": "US"
+"CountyOrParish": "St. Charles"
+"CreationDate": "2023-08-18T12:05:13.478242+00:00"
+"CrossStreet": "Arena Parkway"
+"CumulativeDaysOnMarket": 938
+"DaysOnMarket": 984
+"DevelopmentStatus": array:1 [
0 => "Raw Land"
]
+"Directions": "From St. Louis interstate 364 West to Arena Parkway exit in St. Charles. Exit right (towards family arena) property will be on your left side after you pass Hemsath Rd. 1 block from Page Extension. Entrance will be right before the sign."
+"Disclosures": array:2 [
0 => "Unknown"
1 => "Flood Plain Yes"
]
+"DocumentsAvailable": array:1 [
0 => "None Available"
]
+"DocumentsChangeTimestamp": "2025-04-29T00:27:00Z"
+"ElementarySchool": "Harvest Ridge Elem."
+"HighSchool": "Francis Howell North High"
+"HighSchoolDistrict": "Francis Howell R-III"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetEntireListingDisplayYN": true
+"ListAOR": "St. Charles County Association of REALTORS"
+"ListAgentAOR": "St. Charles County Association of REALTORS"
+"ListAgentKey": "MIS7282"
+"ListOfficeAOR": "St. Charles County Association of REALTORS"
+"ListOfficeKey": "MIS36103024"
+"ListOfficePhone": "636-720-1100"
+"ListingService": "Full Service"
+"ListingTerms": "Cash,Conventional"
+"LotFeatures": array:9 [
0 => "Wooded"
1 => "Natural Foliage"
2 => "Irregular Lot"
3 => "Gently Rolling"
4 => "Level"
5 => "Heavy Woods"
6 => "Sloped"
7 => "Rolling Slope"
8 => "Pasture"
]
+"LotSizeAcres": 14.33
+"LotSizeDimensions": "SEE TAX RECORD"
+"LotSizeSource": "Public Records"
+"LotSizeSquareFeet": 624215
+"MLSAreaMajor": "411 - Francis Howell North"
+"MajorChangeTimestamp": "2022-09-28T21:56:17Z"
+"MiddleOrJuniorSchool": "Barnwell Middle"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"NumberOfLots": "1"
+"OffMarketDate": "2025-12-31"
+"OnMarketDate": "2022-09-28"
+"OriginalEntryTimestamp": "2022-09-28T21:56:17Z"
+"OriginalListPrice": 2965020
+"OtherStructures": array:1 [
0 => "Barn(s)"
]
+"OwnershipType": "Private"
+"ParcelNumber": "3-0117-1198-00-0021.0000000"
+"PhotosChangeTimestamp": "2025-04-29T00:27:00Z"
+"PhotosCount": 5
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"RoadFrontageType": array:1 [
0 => "City Street"
]
+"RoadSurfaceType": array:2 [
0 => "Concrete"
1 => "Gravel"
]
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "Standard"
]
+"StateOrProvince": "MO"
+"StatusChangeTimestamp": "2022-09-28T21:56:17Z"
+"StreetName": "Hemsath"
+"StreetNumber": "0"
+"StreetSuffix": "Road"
+"SubdivisionName": "None"
+"TaxAnnualAmount": "4317"
+"TaxLegalDescription": "PT SUR 1198"
+"TaxYear": "2021"
+"Township": "Unincorporated"
+"Utilities": array:1 [
0 => "None"
]
+"MAR_FOLI": "Heavy Woods,Natural State"
+"MAR_IMPR": "None"
+"MAR_OPTI": "Sell Entirely,Subject to Zoning"
+"MAR_REST": "Unknown"
+"MAR_TYPE": "Other"
+"MAR_IsDeleted": "0"
+"MAR_LastStatus": "Incomplete"
+"MAR_MatrixTesting": "0"
+"MAR_PropAssesCtyTx": "0"
+"MAR_Office_Area_Code": "636"
+"MAR_Office_Long_Name": "Berkshire Hathaway HomeServices Select Properties"
+"MAR_Transaction_Type": "Sale"
+"MAR_Listing_Agent_Nickname": "Cindy "
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS88115353')"
+"MIS_PoolYN": "0"
+"MIS_RoomCount": "0"
+"MIS_UnitCount": "0"
+"provider_name": "Stellar"
+"MIS_CurrentPrice": "2965020.00"
+"MIS_EasementType": "Utility"
+"MIS_Restrictions": "Unspecified"
+"MIS_OpenHouseCount": "0"
+"MIS_PreviousStatus": "Incomplete"
+"MIS_ActiveOpenHouseCount": "0"
+"MIS_OpenHousePublicCount": "0"
+"MIS_OpenHousePublicUpcoming": "0"
+"MIS_MainAndUpperLevelBedrooms": "0"
+"MIS_MainAndUpperLevelBathrooms": "0"
+"Media": array:5 [
0 => array:10 [
"Order" => 0
"MediaKey" => "6334bddb261c992269397c6c"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/bf5d122d4db77e6d22bb7ccfb13b7bea.jpeg"
"MediaSize" => 272515
"MediaType" => "Image"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/thumbnail-bf5d122d4db77e6d22bb7ccfb13b7bea.jpeg"
"ImageWidth" => 1280
"ImageHeight" => 825
"ImageSizeDescription" => "1280x825"
"MediaModificationTimestamp" => "2022-09-28T21:34:19.046Z"
]
1 => array:10 [
"Order" => 1
"MediaKey" => "6334bddb261c992269397c6d"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/9a9d034cc0aa3a1857c90307e2f560c9.jpeg"
"MediaSize" => 69530
"MediaType" => "Image"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/thumbnail-9a9d034cc0aa3a1857c90307e2f560c9.jpeg"
"ImageWidth" => 960
"ImageHeight" => 1021
"ImageSizeDescription" => "960x1021"
"MediaModificationTimestamp" => "2022-09-28T21:34:19.065Z"
]
2 => array:10 [
"Order" => 2
"MediaKey" => "6334bddb261c992269397c6e"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/b22d4b38f888f736907b38063e8455ce.jpeg"
"MediaSize" => 287735
"MediaType" => "Image"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/thumbnail-b22d4b38f888f736907b38063e8455ce.jpeg"
"ImageWidth" => 1280
"ImageHeight" => 924
"ImageSizeDescription" => "1280x924"
"MediaModificationTimestamp" => "2022-09-28T21:34:19.091Z"
]
3 => array:10 [
"Order" => 3
"MediaKey" => "6334bddb261c992269397c6f"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/b6d09b04d4cb566f60324bd07e656081.jpeg"
"MediaSize" => 143004
"MediaType" => "Image"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/thumbnail-b6d09b04d4cb566f60324bd07e656081.jpeg"
"ImageWidth" => 1073
"ImageHeight" => 960
"ImageSizeDescription" => "1073x960"
"MediaModificationTimestamp" => "2022-09-28T21:34:19.050Z"
]
4 => array:10 [
"Order" => 4
"MediaKey" => "64236d3f7e5abf3eb48a2dad"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/e1b32df31e2ccd477bb50655381965e2.jpeg"
"MediaSize" => 193144
"MediaType" => "Image"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR88115353/thumbnail-e1b32df31e2ccd477bb50655381965e2.jpeg"
"ImageWidth" => 927
"ImageHeight" => 1200
"ImageSizeDescription" => "927x1200"
"MediaModificationTimestamp" => "2023-03-28T22:42:07.340Z"
]
]
+"ID": "16522"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]
