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 'MIS95472734'/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 'MIS95472734'&$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 'MIS95472734'/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 'MIS95472734'&$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: "16541"
+post_author: 1
+"ListingKey": "MIS95472734"
+"ListingId": "MIS24074077"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-04-28T23:53:55Z"
+"RFModificationTimestamp": "2025-05-27T06:41:53.829937+00:00"
+"ListPrice": 1749000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.38
+"LivingArea": 4800.0
+"BuildingAreaTotal": 0
+"City": "St Louis"
+"PostalCode": "63141"
+"UnparsedAddress": "9820 Warington Square Court, Olivette, Missouri 63132"
+"Coordinates": array:2 [
0 => 0
1 => 0
]
+"Latitude": 0.01
+"Longitude": 0.01
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Doug G Cohen"
+"ListOfficeName": "Douglas Properties"
+"ListAgentMlsId": "MISSDOCOHEN"
+"ListOfficeMlsId": "MISDGCR01"
+"OriginatingSystemName": "MARIS"
+"PublicRemarks": "Construction to start Spring 25 - Douglas Properties is pleased to present this new construction custom home in the best central location of town and in Creve Coeur off of Warson Road. Located minutes from Old Bonhomme School & Stacy Park, this "CRAFTSMAN STYLE" 1 1/2 story home offers a totally open floor plan and master suite located on the 1st floor with an impressive hearth room plus an additional three bedrooms & two full baths on the 2nd floor. This home features stylish stone work, hardwood flooring, quaaartz tops and many other fine features. Other features include a finished lower level, 1st floor laundry, a large patio off the family room. There will be two fireplaces & the kitchen will feature a large breakfast bar and top of the line Markus Custom cabinetry. This home is perfect for the family who wants a new home the opportunity to put their children in Ladue schools! We have flexibility with the elevation / floor plan to address changes for your clients"
+"AboveGradeFinishedArea": 3600
+"AboveGradeFinishedAreaSource": "Builder"
+"AboveGradeFinishedAreaUnits": "Square Feet"
+"Appliances": array:11 [
0 => "Dishwasher"
1 => "Disposal"
2 => "Double Oven"
3 => "Microwave"
4 => "Electric Range"
5 => "Electric Oven"
6 => "Refrigerator"
7 => "Range Hood"
8 => "Vented Exhaust Fan"
9 => "Humidifier"
10 => "Gas Water Heater"
]
+"ArchitecturalStyle": array:2 [
0 => "Traditional"
1 => "Other"
]
+"AssociationFee": "60"
+"AssociationFeeFrequency": "Annually"
+"AttachedGarageYN": true
+"Basement": array:5 [
0 => "9 ft + Pour"
1 => "Bathroom"
2 => "Full"
3 => "Sleeping Area"
4 => "Sump Pump"
]
+"BasementYN": true
+"BathroomsFull": 4
+"BelowGradeFinishedArea": 1200
+"BelowGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaUnits": "Square Feet"
+"BuilderName": "Douglas Properties"
+"BuyerOfficeAOR": "St. Louis Association of REALTORS"
+"CoBuyerAgentAOR": "St. Louis Association of REALTORS"
+"CoListAgentAOR": "St. Louis Association of REALTORS"
+"CoListAgentFullName": "Esther S Cohen"
+"CoListAgentKey": "MIS37240931"
+"CoListAgentMlsId": "MISESCOHEN"
+"CoListOfficeKey": "MIS3113"
+"CoListOfficeMlsId": "MISDGCR01"
+"CoListOfficeName": "Douglas Properties"
+"CoListOfficePhone": "314-280-2041"
+"ConstructionMaterials": array:2 [
0 => "Brick Veneer"
1 => "Fiber Cement"
]
+"Cooling": array:3 [
0 => "Central Air"
1 => "Electric"
2 => "Zoned"
]
+"CountyOrParish": "St. Louis"
+"CreationDate": "2024-12-02T20:29:31.506670+00:00"
+"CrossStreet": "Fairgreen"
+"CumulativeDaysOnMarket": 142
+"DaysOnMarket": 188
+"Directions": "Take Olive to south on Old Bonhomme to east on Lindley to Hastings to Payson"
+"Disclosures": array:2 [
0 => "Unknown"
1 => "Occupancy Permit Required"
]
+"DocumentsChangeTimestamp": "2025-04-28T23:53:55Z"
+"DoorFeatures": array:2 [
0 => "Panel Door(s)"
1 => "Pocket Door(s)"
]
+"ElementarySchool": "Old Bonhomme Elem."
+"FireplaceFeatures": array:3 [
0 => "Recreation Room"
1 => "Family Room"
2 => "Kitchen"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Carpet"
1 => "Hardwood"
]
+"GarageSpaces": "3"
+"GarageYN": true
+"Heating": array:2 [
0 => "Forced Air"
1 => "Zoned"
]
+"HighSchool": "Ladue Horton Watkins High"
+"HighSchoolDistrict": "Ladue"
+"HomeWarrantyYN": true
+"InteriorFeatures": array:17 [
0 => "Separate Dining"
1 => "Bookcases"
2 => "Coffered Ceiling(s)"
3 => "Open Floorplan"
4 => "Special Millwork"
5 => "High Ceilings"
6 => "Breakfast Bar"
7 => "Breakfast Room"
8 => "Butler Pantry"
9 => "Kitchen Island"
10 => "Eat-in Kitchen"
11 => "Granite Counters"
12 => "Walk-In Pantry"
13 => "Walk-In Closet(s)"
14 => "Double Vanity"
15 => "Tub"
16 => "Entrance Foyer"
]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Main Level"
]
+"Levels": array:1 [
0 => "One and One Half"
]
+"ListAOR": "St. Louis Association of REALTORS"
+"ListAgentKey": "MIS25712"
+"ListOfficeAOR": "St. Louis Association of REALTORS"
+"ListOfficeKey": "MIS3113"
+"ListOfficePhone": "314-725-9911"
+"ListingService": "Full Service"
+"ListingTerms": "Conventional"
+"LivingAreaSource": "Builder"
+"LotFeatures": array:1 [
0 => "Level"
]
+"LotSizeAcres": 0.375
+"LotSizeDimensions": "125 x 138"
+"LotSizeSource": "Builder"
+"LotSizeSquareFeet": 16335
+"MLSAreaMajor": "151 - Ladue"
+"MainLevelBedrooms": 1
+"MajorChangeTimestamp": "2024-12-02T20:22:01Z"
+"MiddleOrJuniorSchool": "Ladue Middle"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"NewConstructionYN": true
+"OffMarketDate": "2026-01-01"
+"OnMarketDate": "2024-12-02"
+"OriginalEntryTimestamp": "2024-12-02T20:21:57Z"
+"OriginalListPrice": 1749000
+"ParcelNumber": "l7m-22-0321"
+"ParkingFeatures": array:4 [
0 => "Garage"
1 => "Garage Door Opener"
2 => "Off Street"
3 => "Attached"
]
+"ParkingTotal": "3"
+"PhotosChangeTimestamp": "2025-04-28T23:53:55Z"
+"PhotosCount": 1
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PropertyCondition": array:2 [
0 => "To Be Built"
1 => "New Construction"
]
+"RoadSurfaceType": array:1 [
0 => "Concrete"
]
+"Roof": array:1 [
0 => "Composition"
]
+"RoomsTotal": "9"
+"SecurityFeatures": array:1 [
0 => "Smoke Detector(s)"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingContactPhone": "314-725-9911"
+"ShowingRequirements": array:4 [
0 => "Appointment Only"
1 => "Showing Service"
2 => "List Agent Accompany"
3 => "Under Construction"
]
+"SpecialListingConditions": array:1 [
0 => "Standard"
]
+"StateOrProvince": "MO"
+"StatusChangeTimestamp": "2024-12-02T20:21:57Z"
+"StreetName": "Warington Square"
+"StreetNumber": "9820"
+"StreetNumberNumeric": "9820"
+"StreetSuffix": "Court"
+"SubdivisionName": "Oak Estates"
+"TaxAnnualAmount": "9697"
+"TaxYear": "25"
+"Township": "Creve Coeur"
+"Utilities": array:2 [
0 => "Natural Gas Available"
1 => "Underground Utilities"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"WindowFeatures": array:2 [
0 => "Low Emissivity Windows"
1 => "Tilt-In Windows"
]
+"MAR_BALL": "4"
+"MAR_BASE": "Over 1 Million"
+"MAR_BEDD": "Main Floor Primary,Primary Bdr. Suite"
+"MAR_BELL": "4"
+"MAR_CBLA": "1"
+"MAR_DING": "Separate Dining"
+"MAR_FRPL": "Family Room,Hearth Room"
+"MAR_KITC": "Breakfast Bar,Breakfast Room,Butler Pantry,Center Island,Eat-In Kitchen,Granite Countertops,Hearth Room,Walk-In Pantry"
+"MAR_LOWR": "1"
+"MAR_LWFL": "1"
+"MAR_LWHF": "0"
+"MAR_MISC": "Builders Warranty,Smoke Alarm/Detec,Some Carpeting,Some Underground Utl,Some Wood Floors,Walk-In Closets"
+"MAR_MNFL": "1"
+"MAR_MNHF": "1"
+"MAR_MSTB": "Double Sink,Tub & Separate Shwr"
+"MAR_PRPL": "To Be Built"
+"MAR_SPEC": "Entry Foyer,Family Room,Main Floor Laundry"
+"MAR_SQRG": "4000 - 5000"
+"MAR_TYPE": "Single Family"
+"MAR_UPFL": "2"
+"MAR_UPHF": "0"
+"MAR_UPPR": "3"
+"MAR_Driveway": "Concrete"
+"MAR_IsDeleted": "0"
+"MAR_LastStatus": "Incomplete"
+"MAR_price_per_sf": "485.83"
+"MAR_MatrixTesting": "0"
+"MAR_Office_Area_Code": "314"
+"MAR_Office_Long_Name": "Douglas Properties"
+"MAR_StyleDescription": "Other"
+"MAR_Transaction_Type": "Sale"
+"MAR_Co_Agent_Nickname": "Esther"
+"MAR_Listing_Agent_Nickname": "Doug"
+"MAR_Phone_to_Show_Area_Code": "314"
+"MAR_Co_Office_Phone_Area_Code": "314"
+"MAR_SellerConsiderConcessionYN": "1"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS95472734')"
+"MIS_PoolYN": "0"
+"full_address": "9820 Warington Square Court, St Louis, Missouri 63141"
+"MIS_FloorPlan": "Primary Bed on Main,Primary Bed Suite"
+"MIS_RoomCount": "9"
+"MIS_UnitCount": "0"
+"provider_name": "Stellar"
+"short_address": "St Louis, Missouri 63141, USA"
+"MIS_CurrentPrice": "1749000.00"
+"MIS_OpenHouseCount": "0"
+"MIS_PreviousStatus": "Incomplete"
+"location_extra_data": array:1 [
"source" => "MLS"
]
+"MIS_LowerLevelBedrooms": "1"
+"MIS_UpperLevelBedrooms": "3"
+"MIS_ActiveOpenHouseCount": "0"
+"MIS_OpenHousePublicCount": "0"
+"MIS_MainLevelBathroomsFull": "1"
+"MIS_MainLevelBathroomsHalf": "1"
+"MIS_LowerLevelBathroomsFull": "1"
+"MIS_LowerLevelBathroomsHalf": "0"
+"MIS_OpenHousePublicUpcoming": "0"
+"MIS_UpperLevelBathroomsFull": "2"
+"MIS_UpperLevelBathroomsHalf": "0"
+"MIS_MainAndUpperLevelBedrooms": "4"
+"MIS_MainAndUpperLevelBathrooms": "4"
+"Media": array:1 [
0 => array:12 [
"Order" => 0
"MediaKey" => "674e167ed81b7458a42913f2"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95472734/84ca1ef0d23d7b18635ca01cae05f56c.webp"
"MediaSize" => 288020
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95472734/thumbnail-84ca1ef0d23d7b18635ca01cae05f56c.webp"
"ImageWidth" => 1024
"ImageHeight" => 684
"LongDescription" => "This is a similar home prviously built "
"ResourceRecordKey" => "MAR95472734"
"ImageSizeDescription" => "1024x684"
"MediaModificationTimestamp" => "2024-12-02T20:20:14.814Z"
]
]
+"ID": "16541"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]