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 'MIS203791661'/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 'MIS203791661'&$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 'MIS203791661'/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 'MIS203791661'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2834
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836
+post_id: "24387"
+post_author: 1
+"ListingKey": "MIS203791661"
+"ListingId": "25048048"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-07-11T23:18:38Z"
+"RFModificationTimestamp": "2025-07-11T23:22:07.103203+00:00"
+"ListPrice": 465000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2444.0
+"BuildingAreaTotal": 0
+"City": "St Louis"
+"PostalCode": "63110"
+"UnparsedAddress": "4247 Cleveland Avenue, St Louis, Missouri 63110"
+"Coordinates": array:2 [
0 => -90.255942
1 => 38.612159
]
+"Latitude": 38.612159
+"Longitude": -90.255942
+"YearBuilt": 1905
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Helen Reid"
+"ListOfficeName": "Coldwell Banker Realty - Gundaker"
+"ListAgentMlsId": "SHREID"
+"ListOfficeMlsId": "CBG24"
+"OriginatingSystemName": "MARIS"
+"PublicRemarks": """
Historic Charm, Modern Comfort!\n
Discover comfort and character in this beautifully updated home located in the heart of the sought-after Shaw neighborhood—just blocks from the Missouri Botanical Garden and Tower Grove Park. A bright open floorplan features a gourmet kitchen with center island, stainless appliances, granite counters, breakfast bar, and large breakfast room that flows into the living, dining, and sitting rooms—all tied together with warm hardwoods and a cozy brick fireplace. The main level also includes an updated half bath. Upstairs, the spacious primary suite includes a private study with access to a sunny deck, large walk-in closet, and full bath with double sinks and private commode. Two additional bedrooms, a second full bath, a renovated office, and 2nd-floor laundry provide both function and flexibility. Enjoy a redone patio and yard (2024), whole-house water filtration, new HVAC systems (2023–2024), and a 2-car parking pad. All within a vibrant, walkable community known for its charm and urban conveniences.
"""
+"AboveGradeFinishedArea": 24444
+"AboveGradeFinishedAreaSource": "Public Records"
+"Appliances": array:9 [
0 => "Stainless Steel Appliance(s)"
1 => "Gas Cooktop"
2 => "Dishwasher"
3 => "Disposal"
4 => "Microwave"
5 => "Electric Oven"
6 => "Range Hood"
7 => "Electric Range"
8 => "Gas Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Historic"
]
+"Basement": array:1 [
0 => "Unfinished"
]
+"BasementYN": true
+"BathroomsFull": 2
+"BelowGradeFinishedAreaSource": "Other"
+"CoListAgentAOR": "St. Louis Association of REALTORS"
+"CoListAgentFullName": "Missy Hampton"
+"CoListAgentKey": "92172136"
+"CoListAgentMlsId": "MEHAMPTO"
+"CoListOfficeKey": "830"
+"CoListOfficeMlsId": "CBG24"
+"CoListOfficeName": "Coldwell Banker Realty - Gundaker"
+"CoListOfficePhone": "314-993-8000"
+"ConstructionMaterials": array:2 [
0 => "Brick"
1 => "Other"
]
+"Cooling": array:3 [
0 => "Central Air"
1 => "Dual"
2 => "Electric"
]
+"CountyOrParish": "St Louis City"
+"CreationDate": "2025-07-11T23:02:04.109652+00:00"
+"Disclosures": array:3 [
0 => "Code Compliance Required"
1 => "Flood Plain No"
2 => "Occupancy Permit Required"
]
+"DocumentsAvailable": array:1 [
0 => "None Available"
]
+"DocumentsChangeTimestamp": "2025-07-11T23:18:38Z"
+"ElementarySchool": "Mann Elem."
+"FireplaceFeatures": array:1 [
0 => "Decorative"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:3 [
0 => "Dual Fuel/Off Peak"
1 => "Forced Air"
2 => "Natural Gas"
]
+"HighSchool": "Roosevelt High"
+"HighSchoolDistrict": "St. Louis City"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "St. Louis Association of REALTORS"
+"ListAgentAOR": "St. Louis Association of REALTORS"
+"ListAgentKey": "23994"
+"ListOfficeAOR": "St. Louis Association of REALTORS"
+"ListOfficeKey": "830"
+"ListOfficePhone": "314-993-8000"
+"ListingService": "Full Service"
+"ListingTerms": "Cash,Conventional,FHA,VA Loan"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:1 [
0 => "Cul-De-Sac"
]
+"LotSizeAcres": 0.0734
+"LotSizeDimensions": "27 x 124 x 27 x 124"
+"MLSAreaMajor": "3 - South City"
+"MajorChangeTimestamp": "2025-07-11T23:01:30Z"
+"MiddleOrJuniorSchool": "Fanning Middle Community Ed."
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-07-11"
+"OriginalEntryTimestamp": "2025-07-11T23:01:30Z"
+"OriginalListPrice": 465000
+"ParcelNumber": "4933-00-0410-0"
+"PhotosChangeTimestamp": "2025-07-11T23:02:38Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"RoomsTotal": "9"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Appointment Only"
]
+"SpecialListingConditions": array:1 [
0 => "Standard"
]
+"StateOrProvince": "MO"
+"StatusChangeTimestamp": "2025-07-11T23:01:30Z"
+"StreetName": "Cleveland"
+"StreetNumber": "4247"
+"StreetNumberNumeric": "4247"
+"StreetSuffix": "Avenue"
+"StructureType": array:1 [
0 => "House"
]
+"SubdivisionName": "Tyler Place Add"
+"TaxAnnualAmount": "5066"
+"TaxYear": "2024"
+"Township": "St. Louis City"
+"WaterSource": array:1 [
0 => "Public"
]
+"YearBuiltSource": "Public Records"
+"MIS_PoolYN": "0"
+"MIS_Section": "ST LOUIS CITY"
+"MIS_RoomCount": "9"
+"MIS_CurrentPrice": "465000.00"
+"MIS_Neighborhood": "Shaw"
+"MIS_SecondMortgageYN": "0"
+"MIS_LowerLevelBedrooms": "0"
+"MIS_UpperLevelBedrooms": "3"
+"MIS_MainLevelBathroomsFull": "0"
+"MIS_MainLevelBathroomsHalf": "1"
+"MIS_LowerLevelBathroomsFull": "0"
+"MIS_LowerLevelBathroomsHalf": "0"
+"MIS_UpperLevelBathroomsFull": "2"
+"MIS_UpperLevelBathroomsHalf": "0"
+"MIS_MainAndUpperLevelBedrooms": "3"
+"MIS_MainAndUpperLevelBathrooms": "3"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203791661')"
+"provider_name": "MARIS"
+"Media": array:1 [
0 => array:12 [
"Order" => 0
"MediaKey" => "687197d3470f5767926eee08"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203791661/b7766027fac223e8c349d232f7dc4efe.webp"
"MediaSize" => 23859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203791661/thumbnail-b7766027fac223e8c349d232f7dc4efe.webp"
"ImageWidth" => 408
"ImageHeight" => 240
"MediaCategory" => "Photo"
"LongDescription" => "View of front of house"
"ImageSizeDescription" => "408x240"
"MediaModificationTimestamp" => "2025-07-11T23:01:39.257Z"
]
]
+"ID": "24387"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]