Charming and beautifully updated 3-bedroom home featuring 1 full bath and 1.5 baths! Step inside to discover brand new flooring and plush carpet throughout, offering a fresh, modern feel. The kitchen shines with newly installed cabinets, perfect for both everyday living and entertaining. A brand new roof adds peace of mind and long-term value. Don’t miss this move-in ready gem—schedule your showing today! New furnace has been installed.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2838 +post_id: "21327" +post_author: 1 +"ListingKey": "MIS203287785" +"ListingId": "25036696" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-07-28T15:45:38Z" +"RFModificationTimestamp": "2025-07-28T15:47:49Z" +"ListPrice": 154900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63135" +"UnparsedAddress": "168 Elbring Drive, Hazelwood, Missouri 63135" +"Coordinates": array:2 [ 0 => -90.319054 1 => 38.765197 ] +"Latitude": 38.765197 +"Longitude": -90.319054 +"YearBuilt": 1960 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ali Gomez Sanchez" +"ListOfficeName": "Keller Williams Realty STL" +"ListAgentMlsId": "AGOMEZSA" +"ListOfficeMlsId": "MADA01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Charming and beautifully updated 3-bedroom home featuring 1 full bath and 1.5 baths! Step inside to discover brand new flooring and plush carpet throughout, offering a fresh, modern feel. The kitchen shines with newly installed cabinets, perfect for both everyday living and entertaining. A brand new roof adds peace of mind and long-term value. Don’t miss this move-in ready gem—schedule your showing today! New furnace has been installed." +"AboveGradeFinishedArea": 1124 +"AboveGradeFinishedAreaSource": "Public Records" +"ArchitecturalStyle": array:1 [ 0 => "Traditional" ] +"Basement": array:3 [ 0 => "Full" 1 => "Unfinished" 2 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:2 [ 0 => "Frame" 1 => "Vinyl Siding" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Electric" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-05-30T18:26:57.276694+00:00" +"CumulativeDaysOnMarket": 53 +"DaysOnMarket": 73 +"DevelopmentStatus": array:1 [ 0 => "Completed" ] +"Disclosures": array:2 [ 0 => "Lead Paint" 1 => "Seller Property Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-30T13:31:38Z" +"DocumentsCount": 3 +"ElementarySchool": "Lee Hamilton Elem." +"Flooring": array:1 [ 0 => "Carpet" ] +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Mccluer High" +"HighSchoolDistrict": "Ferguson-Florissant R-II" +"InteriorFeatures": array:2 [ 0 => "Dining/Living Room Combo" 1 => "Open Floorplan" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "91638558" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "1905" +"ListOfficePhone": "314-677-6000" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.1435 +"LotSizeDimensions": "50x125" +"MLSAreaMajor": "765 - Florissant" +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-07-26T14:17:14Z" +"MiddleOrJuniorSchool": "Ferguson Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active Under Contract" +"OnMarketDate": "2025-06-05" +"OriginalEntryTimestamp": "2025-05-30T18:21:58Z" +"OriginalListPrice": 154900 +"OwnershipType": "Private" +"ParcelNumber": "10J-24-1975" +"ParkingFeatures": array:1 [ 0 => "Off Street" ] +"PatioAndPorchFeatures": array:1 [ 0 => "Deck" ] +"PhotosChangeTimestamp": "2025-06-10T01:28:38Z" +"PhotosCount": 14 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PriceChangeTimestamp": "2025-05-30T18:21:58Z" +"PropertyCondition": array:1 [ 0 => "Updated/Remodeled" ] +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactType": array:1 [ 0 => "Showing Service" ] +"ShowingRequirements": array:1 [ 0 => "Showing Service" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-26T14:17:14Z" +"StreetName": "Elbring" +"StreetNumber": "168" +"StreetNumberNumeric": "168" +"StreetSuffix": "Drive" +"StructureType": array:1 [ 0 => "House" ] +"SubdivisionName": "Burke City" +"TaxAnnualAmount": "946" +"TaxLegalDescription": "BURKE CITY LOT 36 & 37 BLOCK 29" +"TaxYear": "2024" +"Township": "Hazelwood" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_Section": "HAZELWOOD" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "154900.00" +"MIS_OpenHouseCount": "0" +"MIS_PreviousStatus": "Active" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_ActiveOpenHouseCount": "0" +"MIS_OpenHousePublicCount": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainAndUpperLevelBathrooms": "2" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203287785')" +"provider_name": "MARIS" +"Media": array:14 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "68478a0f32901756ff5b82b1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/b854c814029883aacae6daa3fe0a57af.webp" "MediaSize" => 214713 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-b854c814029883aacae6daa3fe0a57af.webp" "ImageWidth" => 1024 "ImageHeight" => 699 "MediaCategory" => "Photo" "LongDescription" => "Single story home featuring a shingled roof" "ImageSizeDescription" => "1024x699" "MediaModificationTimestamp" => "2025-06-10T01:27:43.301Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "68478a0f32901756ff5b82b2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/22738eaec3f050c1c1b826b6698777f0.webp" "MediaSize" => 75247 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-22738eaec3f050c1c1b826b6698777f0.webp" "ImageWidth" => 1024 "ImageHeight" => 597 "MediaCategory" => "Photo" "LongDescription" => "Foyer entrance with healthy amount of natural light, wood finished floors, baseboards, and a ceiling fan" "ImageSizeDescription" => "1024x597" "MediaModificationTimestamp" => "2025-06-10T01:27:43.337Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "68478a0f32901756ff5b82b3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/2c56b801bea952e49091eea34457296f.webp" "MediaSize" => 50279 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-2c56b801bea952e49091eea34457296f.webp" "ImageWidth" => 1024 "ImageHeight" => 559 "MediaCategory" => "Photo" "LongDescription" => "Spare room with light wood finished floors, baseboards, a ceiling fan, and a decorative wall" "ImageSizeDescription" => "1024x559" "MediaModificationTimestamp" => "2025-06-10T01:27:43.271Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "68478a0f32901756ff5b82b4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/fd52b767cf01e0fe217ffcba47b0de3b.webp" "MediaSize" => 79492 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-fd52b767cf01e0fe217ffcba47b0de3b.webp" "ImageWidth" => 1024 "ImageHeight" => 576 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with under cabinet range hood, electric range, wooden counters, and backsplash" "ImageSizeDescription" => "1024x576" "MediaModificationTimestamp" => "2025-06-10T01:27:43.284Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "68478a0f32901756ff5b82b5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/e09e0d5c38fa43856dba88808c4e31b5.webp" "MediaSize" => 217353 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-e09e0d5c38fa43856dba88808c4e31b5.webp" "ImageWidth" => 1024 "ImageHeight" => 711 "MediaCategory" => "Photo" "LongDescription" => "Back of property featuring a shingled roof and a wooden deck" "ImageSizeDescription" => "1024x711" "MediaModificationTimestamp" => "2025-06-10T01:27:43.356Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "68478a0f32901756ff5b82b6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/bdaf93153cdc7bdcd91c551482ea9eec.webp" "MediaSize" => 81885 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-bdaf93153cdc7bdcd91c551482ea9eec.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring white appliances, a sink, wood counters, white cabinets, and decorative backsplash" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.290Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "68478a0f32901756ff5b82b7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/61002ad52a49cfb6972ffd598cb1d827.webp" "MediaSize" => 57653 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-61002ad52a49cfb6972ffd598cb1d827.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Full bath featuring toilet and a stall shower" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.268Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "68478a0f32901756ff5b82b8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/1a99c7ab22f12199b588913cc448eafc.webp" "MediaSize" => 61462 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-1a99c7ab22f12199b588913cc448eafc.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished room featuring ceiling fan, wood finished floors, a decorative wall, and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.280Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "68478a0f32901756ff5b82b9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/e593ecd8b99cd40a245576d0d122f557.webp" "MediaSize" => 47947 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-e593ecd8b99cd40a245576d0d122f557.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Hall with wood finished floors" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.326Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "68478a0f32901756ff5b82ba" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/33c576e9a9c0b306fdc680297374991b.webp" "MediaSize" => 58818 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-33c576e9a9c0b306fdc680297374991b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Empty room with a ceiling fan, light wood-type flooring, and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.270Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "68478a0f32901756ff5b82bb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/6c400df51e527eec8d89136a323e81d7.webp" "MediaSize" => 84391 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-6c400df51e527eec8d89136a323e81d7.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Spare room featuring light wood-type flooring, baseboards, and a ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.312Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "68478a0f32901756ff5b82bc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/bf57a94874fe38dcc3b53691ffe9c704.webp" "MediaSize" => 61363 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-bf57a94874fe38dcc3b53691ffe9c704.webp" "ImageWidth" => 1024 "ImageHeight" => 576 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished room featuring a ceiling fan, a decorative wall, and baseboards" "ImageSizeDescription" => "1024x576" "MediaModificationTimestamp" => "2025-06-10T01:27:43.270Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "68478a0f32901756ff5b82bd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/4eff18b80095e4aa34dedb4bca6b8272.webp" "MediaSize" => 195606 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-4eff18b80095e4aa34dedb4bca6b8272.webp" "ImageWidth" => 1023 "ImageHeight" => 700 "MediaCategory" => "Photo" "LongDescription" => "Rear view of house with central AC, a wooden deck, a gate, and stairs" "ImageSizeDescription" => "1023x700" "MediaModificationTimestamp" => "2025-06-10T01:27:43.412Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "68478a0f32901756ff5b82be" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/f3dacdf252390c61a62a59c4f65c5f76.webp" "MediaSize" => 110244 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-f3dacdf252390c61a62a59c4f65c5f76.webp" "ImageWidth" => 1024 "ImageHeight" => 651 "MediaCategory" => "Photo" "LongDescription" => "Unfinished below grade area with gas water heater, electric panel, stairs, and heating unit" "ImageSizeDescription" => "1024x651" "MediaModificationTimestamp" => "2025-06-10T01:27:43.267Z" ] ] +"ID": "21327" }
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 'MIS203287785'/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 'MIS203287785'&$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 'MIS203287785'/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 'MIS203287785'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2836 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2838 +post_id: "21327" +post_author: 1 +"ListingKey": "MIS203287785" +"ListingId": "25036696" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-07-28T15:45:38Z" +"RFModificationTimestamp": "2025-07-28T15:47:49Z" +"ListPrice": 154900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63135" +"UnparsedAddress": "168 Elbring Drive, Hazelwood, Missouri 63135" +"Coordinates": array:2 [ 0 => -90.319054 1 => 38.765197 ] +"Latitude": 38.765197 +"Longitude": -90.319054 +"YearBuilt": 1960 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ali Gomez Sanchez" +"ListOfficeName": "Keller Williams Realty STL" +"ListAgentMlsId": "AGOMEZSA" +"ListOfficeMlsId": "MADA01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Charming and beautifully updated 3-bedroom home featuring 1 full bath and 1.5 baths! Step inside to discover brand new flooring and plush carpet throughout, offering a fresh, modern feel. The kitchen shines with newly installed cabinets, perfect for both everyday living and entertaining. A brand new roof adds peace of mind and long-term value. Don’t miss this move-in ready gem—schedule your showing today! New furnace has been installed." +"AboveGradeFinishedArea": 1124 +"AboveGradeFinishedAreaSource": "Public Records" +"ArchitecturalStyle": array:1 [ 0 => "Traditional" ] +"Basement": array:3 [ 0 => "Full" 1 => "Unfinished" 2 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:2 [ 0 => "Frame" 1 => "Vinyl Siding" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Electric" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-05-30T18:26:57.276694+00:00" +"CumulativeDaysOnMarket": 53 +"DaysOnMarket": 73 +"DevelopmentStatus": array:1 [ 0 => "Completed" ] +"Disclosures": array:2 [ 0 => "Lead Paint" 1 => "Seller Property Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-30T13:31:38Z" +"DocumentsCount": 3 +"ElementarySchool": "Lee Hamilton Elem." +"Flooring": array:1 [ 0 => "Carpet" ] +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Mccluer High" +"HighSchoolDistrict": "Ferguson-Florissant R-II" +"InteriorFeatures": array:2 [ 0 => "Dining/Living Room Combo" 1 => "Open Floorplan" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "91638558" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "1905" +"ListOfficePhone": "314-677-6000" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.1435 +"LotSizeDimensions": "50x125" +"MLSAreaMajor": "765 - Florissant" +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-07-26T14:17:14Z" +"MiddleOrJuniorSchool": "Ferguson Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active Under Contract" +"OnMarketDate": "2025-06-05" +"OriginalEntryTimestamp": "2025-05-30T18:21:58Z" +"OriginalListPrice": 154900 +"OwnershipType": "Private" +"ParcelNumber": "10J-24-1975" +"ParkingFeatures": array:1 [ 0 => "Off Street" ] +"PatioAndPorchFeatures": array:1 [ 0 => "Deck" ] +"PhotosChangeTimestamp": "2025-06-10T01:28:38Z" +"PhotosCount": 14 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PriceChangeTimestamp": "2025-05-30T18:21:58Z" +"PropertyCondition": array:1 [ 0 => "Updated/Remodeled" ] +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactType": array:1 [ 0 => "Showing Service" ] +"ShowingRequirements": array:1 [ 0 => "Showing Service" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-26T14:17:14Z" +"StreetName": "Elbring" +"StreetNumber": "168" +"StreetNumberNumeric": "168" +"StreetSuffix": "Drive" +"StructureType": array:1 [ 0 => "House" ] +"SubdivisionName": "Burke City" +"TaxAnnualAmount": "946" +"TaxLegalDescription": "BURKE CITY LOT 36 & 37 BLOCK 29" +"TaxYear": "2024" +"Township": "Hazelwood" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_Section": "HAZELWOOD" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "154900.00" +"MIS_OpenHouseCount": "0" +"MIS_PreviousStatus": "Active" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_ActiveOpenHouseCount": "0" +"MIS_OpenHousePublicCount": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainAndUpperLevelBathrooms": "2" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203287785')" +"provider_name": "MARIS" +"Media": array:14 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "68478a0f32901756ff5b82b1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/b854c814029883aacae6daa3fe0a57af.webp" "MediaSize" => 214713 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-b854c814029883aacae6daa3fe0a57af.webp" "ImageWidth" => 1024 "ImageHeight" => 699 "MediaCategory" => "Photo" "LongDescription" => "Single story home featuring a shingled roof" "ImageSizeDescription" => "1024x699" "MediaModificationTimestamp" => "2025-06-10T01:27:43.301Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "68478a0f32901756ff5b82b2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/22738eaec3f050c1c1b826b6698777f0.webp" "MediaSize" => 75247 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-22738eaec3f050c1c1b826b6698777f0.webp" "ImageWidth" => 1024 "ImageHeight" => 597 "MediaCategory" => "Photo" "LongDescription" => "Foyer entrance with healthy amount of natural light, wood finished floors, baseboards, and a ceiling fan" "ImageSizeDescription" => "1024x597" "MediaModificationTimestamp" => "2025-06-10T01:27:43.337Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "68478a0f32901756ff5b82b3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/2c56b801bea952e49091eea34457296f.webp" "MediaSize" => 50279 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-2c56b801bea952e49091eea34457296f.webp" "ImageWidth" => 1024 "ImageHeight" => 559 "MediaCategory" => "Photo" "LongDescription" => "Spare room with light wood finished floors, baseboards, a ceiling fan, and a decorative wall" "ImageSizeDescription" => "1024x559" "MediaModificationTimestamp" => "2025-06-10T01:27:43.271Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "68478a0f32901756ff5b82b4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/fd52b767cf01e0fe217ffcba47b0de3b.webp" "MediaSize" => 79492 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-fd52b767cf01e0fe217ffcba47b0de3b.webp" "ImageWidth" => 1024 "ImageHeight" => 576 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with under cabinet range hood, electric range, wooden counters, and backsplash" "ImageSizeDescription" => "1024x576" "MediaModificationTimestamp" => "2025-06-10T01:27:43.284Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "68478a0f32901756ff5b82b5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/e09e0d5c38fa43856dba88808c4e31b5.webp" "MediaSize" => 217353 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-e09e0d5c38fa43856dba88808c4e31b5.webp" "ImageWidth" => 1024 "ImageHeight" => 711 "MediaCategory" => "Photo" "LongDescription" => "Back of property featuring a shingled roof and a wooden deck" "ImageSizeDescription" => "1024x711" "MediaModificationTimestamp" => "2025-06-10T01:27:43.356Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "68478a0f32901756ff5b82b6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/bdaf93153cdc7bdcd91c551482ea9eec.webp" "MediaSize" => 81885 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-bdaf93153cdc7bdcd91c551482ea9eec.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring white appliances, a sink, wood counters, white cabinets, and decorative backsplash" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.290Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "68478a0f32901756ff5b82b7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/61002ad52a49cfb6972ffd598cb1d827.webp" "MediaSize" => 57653 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-61002ad52a49cfb6972ffd598cb1d827.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Full bath featuring toilet and a stall shower" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.268Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "68478a0f32901756ff5b82b8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/1a99c7ab22f12199b588913cc448eafc.webp" "MediaSize" => 61462 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-1a99c7ab22f12199b588913cc448eafc.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished room featuring ceiling fan, wood finished floors, a decorative wall, and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.280Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "68478a0f32901756ff5b82b9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/e593ecd8b99cd40a245576d0d122f557.webp" "MediaSize" => 47947 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-e593ecd8b99cd40a245576d0d122f557.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Hall with wood finished floors" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.326Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "68478a0f32901756ff5b82ba" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/33c576e9a9c0b306fdc680297374991b.webp" "MediaSize" => 58818 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-33c576e9a9c0b306fdc680297374991b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Empty room with a ceiling fan, light wood-type flooring, and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.270Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "68478a0f32901756ff5b82bb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/6c400df51e527eec8d89136a323e81d7.webp" "MediaSize" => 84391 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-6c400df51e527eec8d89136a323e81d7.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Spare room featuring light wood-type flooring, baseboards, and a ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-10T01:27:43.312Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "68478a0f32901756ff5b82bc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/bf57a94874fe38dcc3b53691ffe9c704.webp" "MediaSize" => 61363 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-bf57a94874fe38dcc3b53691ffe9c704.webp" "ImageWidth" => 1024 "ImageHeight" => 576 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished room featuring a ceiling fan, a decorative wall, and baseboards" "ImageSizeDescription" => "1024x576" "MediaModificationTimestamp" => "2025-06-10T01:27:43.270Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "68478a0f32901756ff5b82bd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/4eff18b80095e4aa34dedb4bca6b8272.webp" "MediaSize" => 195606 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-4eff18b80095e4aa34dedb4bca6b8272.webp" "ImageWidth" => 1023 "ImageHeight" => 700 "MediaCategory" => "Photo" "LongDescription" => "Rear view of house with central AC, a wooden deck, a gate, and stairs" "ImageSizeDescription" => "1023x700" "MediaModificationTimestamp" => "2025-06-10T01:27:43.412Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "68478a0f32901756ff5b82be" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/f3dacdf252390c61a62a59c4f65c5f76.webp" "MediaSize" => 110244 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203287785/thumbnail-f3dacdf252390c61a62a59c4f65c5f76.webp" "ImageWidth" => 1024 "ImageHeight" => 651 "MediaCategory" => "Photo" "LongDescription" => "Unfinished below grade area with gas water heater, electric panel, stairs, and heating unit" "ImageSizeDescription" => "1024x651" "MediaModificationTimestamp" => "2025-06-10T01:27:43.267Z" ] ] +"ID": "21327" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.14 seconds" ] ]