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 'MIS203589767'/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 'MIS203589767'&$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 'MIS203589767'/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 'MIS203589767'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2835
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2837
+post_id: "23115"
+post_author: 1
+"ListingKey": "MIS203589767"
+"ListingId": "25044074"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-07-01T13:31:38Z"
+"RFModificationTimestamp": "2025-07-01T13:31:58Z"
+"ListPrice": 194999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2194.0
+"BuildingAreaTotal": 0
+"City": "St Louis"
+"PostalCode": "63116"
+"UnparsedAddress": "3958 Fairview Avenue, St Louis, Missouri 63116"
+"Coordinates": array:2 [
0 => -90.252922
1 => 38.595198
]
+"Latitude": 38.595198
+"Longitude": -90.252922
+"YearBuilt": 1926
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Peter MacKercher"
+"ListOfficeName": "Mogul Realty"
+"ListAgentMlsId": "PMACKERC"
+"ListOfficeMlsId": "MOGL01"
+"OriginatingSystemName": "MARIS"
+"PublicRemarks": """
Tower Grove South renovation opportunity! A new roof in 2023, and the property is partially gutted with over 2100 sq ft! Don't miss your chance to turn your vision into reality with this property!\n
- Homes in the same neighborhood with this much square footage are selling for $500K or more. This is your perfect opportunity to flip for a profit or get exactly what you want.\n
-Property to be sold as is. Please complete inspections before making an offer. Seller to do no inspections or repairs. This is a great neighborhood \n
-Best use for this building, I believe, is to switch from a duplex to a single-family house, 3-bed 2.5 bath with a carport. \n
-Home is owned by a Licensed MO realtor.
"""
+"AboveGradeFinishedArea": 2194
+"AboveGradeFinishedAreaSource": "Public Records"
+"ArchitecturalStyle": array:1 [
0 => "Traditional"
]
+"Basement": array:1 [
0 => "Unfinished"
]
+"BasementYN": true
+"ConstructionMaterials": array:1 [
0 => "Stone"
]
+"Cooling": array:2 [
0 => "Central Air"
1 => "Dual"
]
+"CountyOrParish": "St Louis City"
+"CreationDate": "2025-06-25T15:35:51.067898+00:00"
+"CrossStreet": "Gustine ave"
+"CumulativeDaysOnMarket": 6
+"DaysOnMarket": 25
+"Disclosures": array:2 [
0 => "Agent Owned"
1 => "Flood Plain No"
]
+"DocumentsAvailable": array:1 [
0 => "None Available"
]
+"DocumentsChangeTimestamp": "2025-07-01T13:31:38Z"
+"DocumentsCount": 2
+"ElementarySchool": "Mann Elem."
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Roosevelt High"
+"HighSchoolDistrict": "St. Louis City"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Two"
]
+"ListAOR": "St. Louis Association of REALTORS"
+"ListAgentAOR": "St. Louis Association of REALTORS"
+"ListAgentKey": "19632"
+"ListOfficeAOR": "St. Louis Association of REALTORS"
+"ListOfficeKey": "7000914"
+"ListOfficePhone": "314-865-1170"
+"ListingService": "Full Service"
+"ListingTerms": "Cash,Conventional,Private"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:2 [
0 => "Back Yard"
1 => "Level"
]
+"LotSizeAcres": 0.0751
+"MLSAreaMajor": "3 - South City"
+"MajorChangeTimestamp": "2025-07-01T13:31:20Z"
+"MiddleOrJuniorSchool": "Long Middle Community Ed. Center"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-06-25"
+"OriginalEntryTimestamp": "2025-06-25T15:30:19Z"
+"OriginalListPrice": 199999
+"ParcelNumber": "4130-00-0050-0"
+"ParkingFeatures": array:1 [
0 => "Off Street"
]
+"PhotosChangeTimestamp": "2025-06-25T15:31:38Z"
+"PhotosCount": 1
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PreviousListPrice": 199999
+"PriceChangeTimestamp": "2025-07-01T13:31:20Z"
+"Roof": array:1 [
0 => "Flat"
]
+"RoomsTotal": "10"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:2 [
0 => "Appointment Only"
1 => "Combination Lock Box"
]
+"SpecialListingConditions": array:1 [
0 => "Listing As Is"
]
+"StateOrProvince": "MO"
+"StatusChangeTimestamp": "2025-06-25T15:30:19Z"
+"StreetName": "Fairview"
+"StreetNumber": "3958"
+"StreetNumberNumeric": "3958"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "Russells Add 02"
+"TaxAnnualAmount": "1947"
+"TaxYear": "2024"
+"Township": "St. Louis City"
+"WaterSource": array:1 [
0 => "Public"
]
+"YearBuiltSource": "Public Records"
+"MIS_MainAndUpperLevelBathrooms": "0"
+"MIS_RoomCount": "0"
+"MIS_CurrentPrice": "194999.00"
+"MIS_SecondMortgageYN": "0"
+"MIS_PoolYN": "0"
+"MIS_MainAndUpperLevelBedrooms": "0"
+"MIS_Neighborhood": "Tower Grove South"
+"MIS_Section": "ST LOUIS CITY"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203589767')"
+"provider_name": "MARIS"
+"Media": array:1 [
0 => array:12 [
"Order" => 0
"MediaKey" => "685c16311b22f0609d0046c5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203589767/497d6b002d67e1264cc9dc230101f038.webp"
"MediaSize" => 256264
"LongDescription" => "View of front of property featuring covered porch and brick siding"
"ImageHeight" => 1024
"MediaModificationTimestamp" => "2025-06-25T15:30:57.509Z"
"ImageWidth" => 768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203589767/thumbnail-497d6b002d67e1264cc9dc230101f038.webp"
"MediaCategory" => "Photo"
"ImageSizeDescription" => "768x1024"
]
]
+"ID": "23115"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.4 seconds"
]
]
