Adorable brick home in Sycamore Hills. Updated kitchen, bath and flooring. Newer roof in 2022. Sewer replaced under the house and out in 2022. Home comes with refrigerator, microwave, gas stove, washer and dryer. Fully fenced yard with a shed for storage. New insulation added in 2025.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2837 +post_id: "25056" +post_author: 1 +"ListingKey": "MIS203893288" +"ListingId": "25050213" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-08-10T16:37:38Z" +"RFModificationTimestamp": "2025-08-10T16:40:10Z" +"ListPrice": 169500.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63114" +"UnparsedAddress": "2495 Oakland Avenue, St Louis, Missouri 63114" +"Coordinates": array:2 [ 0 => -90.34685747 1 => 38.70226939 ] +"Latitude": 38.70226939 +"Longitude": -90.34685747 +"YearBuilt": 1928 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jackie Wasser" +"ListOfficeName": "Jenah Realty Group" +"ListAgentMlsId": "JGARDNER" +"ListOfficeMlsId": "JNAH01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Adorable brick home in Sycamore Hills. Updated kitchen, bath and flooring. Newer roof in 2022. Sewer replaced under the house and out in 2022. Home comes with refrigerator, microwave, gas stove, washer and dryer. Fully fenced yard with a shed for storage. New insulation added in 2025." +"AboveGradeFinishedArea": 1080 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:6 [ 0 => "Dryer" 1 => "Exhaust Fan" 2 => "Microwave" 3 => "Gas Range" 4 => "Refrigerator" 5 => "Washer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Full" 1 => "Sump Pump" ] +"BasementYN": true +"BathroomsFull": 1 +"CoListAgentAOR": "St. Louis Association of REALTORS" +"CoListAgentFullName": "Nancy Harrison" +"CoListAgentKey": "12675" +"CoListAgentMlsId": "NHARRISO" +"CoListOfficeKey": "1225" +"CoListOfficeMlsId": "JNAH01" +"CoListOfficeName": "Jenah Realty Group" +"CoListOfficePhone": "314-426-7575" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:2 [ 0 => "Ceiling Fan(s)" 1 => "Central Air" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-07-21T17:31:02.548520+00:00" +"CrossStreet": "Graceland" +"CumulativeDaysOnMarket": 20 +"DaysOnMarket": 20 +"Directions": "Brown rd. to Graceland to Oakland" +"Disclosures": array:3 [ 0 => "Flood Plain No" 1 => "Occupancy Permit Required" 2 => "See Seller's Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "None Available" ] +"DocumentsChangeTimestamp": "2025-07-21T17:31:39Z" +"DocumentsCount": 3 +"ElementarySchool": "Wyland Elem." +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Ritenour Sr. High" +"HighSchoolDistrict": "Ritenour" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "11156" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "1225" +"ListOfficePhone": "314-426-7575" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LotFeatures": array:1 [ 0 => "Other" ] +"LotSizeAcres": 0.1882 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "91 - Ritenour" +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-08-10T16:36:08Z" +"MiddleOrJuniorSchool": "Ritenour Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active Under Contract" +"OnMarketDate": "2025-07-21" +"OriginalEntryTimestamp": "2025-07-21T17:30:36Z" +"OriginalListPrice": 175000 +"ParcelNumber": "15K-53-1005" +"ParkingFeatures": array:1 [ 0 => "Driveway" ] +"PhotosChangeTimestamp": "2025-07-21T21:30:38Z" +"PhotosCount": 15 +"PreviousListPrice": 175000 +"PriceChangeTimestamp": "2025-07-27T20:18:20Z" +"Roof": array:1 [ 0 => "Architectural Shingle" ] +"RoomsTotal": "6" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:4 [ 0 => "Appointment Only" 1 => "Lockbox" 2 => "Pet(s) on Premises" 3 => "Showing Service" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-08-10T16:36:08Z" +"StreetName": "Oakland" +"StreetNumber": "2495" +"StreetNumberNumeric": "2495" +"StreetSuffix": "Avenue" +"SubdivisionName": "Laughlins Add To Sycamore Hills" +"TaxAnnualAmount": "2165" +"TaxYear": "2024" +"Township": "Sycamore Hills" +"VirtualTourURLUnbranded": "https://mls.kuu.la/share/collection/7D5Cr?fs=1&vr=1&sd=1&initload=0&thumbs=1" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_Section": "SYCAMORE HILLS" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "6" +"MIS_CurrentPrice": "169500.00" +"MIS_EfficiencyYN": "0" +"MIS_OpenHouseCount": "0" +"MIS_PreviousStatus": "Active" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_ActiveOpenHouseCount": "0" +"MIS_OpenHousePublicCount": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "2" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203893288')" +"provider_name": "MARIS" +"Media": array:15 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "687ea770cefa4c4951fa33f2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/50da6671c1dbfe656f97673f85de61dc.webp" "MediaSize" => 189477 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-50da6671c1dbfe656f97673f85de61dc.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Bungalow-style house with covered porch and brick siding" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-07-21T20:47:44.276Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "687ea770cefa4c4951fa33f3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/3cbb7e191eef3e21c4756e2d176b6cf0.webp" "MediaSize" => 158617 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-3cbb7e191eef3e21c4756e2d176b6cf0.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of porch" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-07-21T20:47:44.232Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "687ea770cefa4c4951fa33f4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/1d8acecfca912f0f3b5fbb8569fc32cd.webp" "MediaSize" => 47689 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-1d8acecfca912f0f3b5fbb8569fc32cd.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-21T20:47:44.206Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "687ea770cefa4c4951fa33f5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/68d56d23c73011a8e025260f59ae8659.webp" "MediaSize" => 59810 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-68d56d23c73011a8e025260f59ae8659.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-21T20:47:44.288Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "687ea770cefa4c4951fa33f6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/c3e981fe0f1f6320cee15fdc16bed925.webp" "MediaSize" => 39025 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-c3e981fe0f1f6320cee15fdc16bed925.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-21T20:47:44.190Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "687ea770cefa4c4951fa33f7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/445ca8cc63b8a780755aa3cf95c0859d.webp" "MediaSize" => 41406 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-445ca8cc63b8a780755aa3cf95c0859d.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-21T20:47:44.195Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "687ea770cefa4c4951fa33f8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/19e175e924e84cc58a94f16bc28bf5ac.webp" "MediaSize" => 113528 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-19e175e924e84cc58a94f16bc28bf5ac.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-07-21T20:47:44.244Z" ] 7 => array:11 [ "Order" => 10 "MediaKey" => "687ea770cefa4c4951fa33fc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/d0a557e8e49870780ecee8d30cc6295d.webp" "MediaSize" => 50325 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-d0a557e8e49870780ecee8d30cc6295d.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-21T20:47:44.175Z" ] 8 => array:11 [ "Order" => 11 "MediaKey" => "687ea770cefa4c4951fa33fd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/f0224afc6406ebd97371bf0c196914f7.webp" "MediaSize" => 169281 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-f0224afc6406ebd97371bf0c196914f7.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-21T20:47:44.264Z" ] 9 => array:11 [ "Order" => 7 "MediaKey" => "687eb1484bf1d71424884cf8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/380555ba490bc08766995c237907a70f.webp" "MediaSize" => 49208 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-380555ba490bc08766995c237907a70f.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-21T21:29:44.966Z" ] 10 => array:11 [ "Order" => 8 "MediaKey" => "687eb1484bf1d71424884cf9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/07e9eeb3a842cfd9874f4c5fac97f6b5.webp" "MediaSize" => 52029 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-07e9eeb3a842cfd9874f4c5fac97f6b5.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-21T21:29:44.971Z" ] 11 => array:11 [ "Order" => 9 "MediaKey" => "687eb1484bf1d71424884cfa" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/0236833a7b1e45507fa086af05a1b208.webp" "MediaSize" => 69465 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-0236833a7b1e45507fa086af05a1b208.webp" "ImageWidth" => 576 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "576x768" "MediaModificationTimestamp" => "2025-07-21T21:29:44.996Z" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "687ea770cefa4c4951fa33ff" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/ceb46f9e58a942eba6f786d1dfb5472c.webp" "MediaSize" => 170845 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-ceb46f9e58a942eba6f786d1dfb5472c.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-07-21T20:47:44.243Z" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "687ea770cefa4c4951fa3400" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/d47e68abca55453665250cbf62bd98fe.webp" "MediaSize" => 168374 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-d47e68abca55453665250cbf62bd98fe.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-07-21T20:47:44.233Z" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "687ea770cefa4c4951fa3401" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/f31e27595a61ebfe022b80c735b95935.webp" "MediaSize" => 211522 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-f31e27595a61ebfe022b80c735b95935.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-07-21T20:47:44.301Z" ] ] +"ID": "25056" }
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 'MIS203893288'/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 'MIS203893288'&$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 'MIS203893288'/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 'MIS203893288'&$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: "25056" +post_author: 1 +"ListingKey": "MIS203893288" +"ListingId": "25050213" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-08-10T16:37:38Z" +"RFModificationTimestamp": "2025-08-10T16:40:10Z" +"ListPrice": 169500.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63114" +"UnparsedAddress": "2495 Oakland Avenue, St Louis, Missouri 63114" +"Coordinates": array:2 [ 0 => -90.34685747 1 => 38.70226939 ] +"Latitude": 38.70226939 +"Longitude": -90.34685747 +"YearBuilt": 1928 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jackie Wasser" +"ListOfficeName": "Jenah Realty Group" +"ListAgentMlsId": "JGARDNER" +"ListOfficeMlsId": "JNAH01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Adorable brick home in Sycamore Hills. Updated kitchen, bath and flooring. Newer roof in 2022. Sewer replaced under the house and out in 2022. Home comes with refrigerator, microwave, gas stove, washer and dryer. Fully fenced yard with a shed for storage. New insulation added in 2025." +"AboveGradeFinishedArea": 1080 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:6 [ 0 => "Dryer" 1 => "Exhaust Fan" 2 => "Microwave" 3 => "Gas Range" 4 => "Refrigerator" 5 => "Washer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Full" 1 => "Sump Pump" ] +"BasementYN": true +"BathroomsFull": 1 +"CoListAgentAOR": "St. Louis Association of REALTORS" +"CoListAgentFullName": "Nancy Harrison" +"CoListAgentKey": "12675" +"CoListAgentMlsId": "NHARRISO" +"CoListOfficeKey": "1225" +"CoListOfficeMlsId": "JNAH01" +"CoListOfficeName": "Jenah Realty Group" +"CoListOfficePhone": "314-426-7575" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:2 [ 0 => "Ceiling Fan(s)" 1 => "Central Air" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-07-21T17:31:02.548520+00:00" +"CrossStreet": "Graceland" +"CumulativeDaysOnMarket": 20 +"DaysOnMarket": 20 +"Directions": "Brown rd. to Graceland to Oakland" +"Disclosures": array:3 [ 0 => "Flood Plain No" 1 => "Occupancy Permit Required" 2 => "See Seller's Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "None Available" ] +"DocumentsChangeTimestamp": "2025-07-21T17:31:39Z" +"DocumentsCount": 3 +"ElementarySchool": "Wyland Elem." +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Ritenour Sr. High" +"HighSchoolDistrict": "Ritenour" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "11156" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "1225" +"ListOfficePhone": "314-426-7575" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LotFeatures": array:1 [ 0 => "Other" ] +"LotSizeAcres": 0.1882 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "91 - Ritenour" +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-08-10T16:36:08Z" +"MiddleOrJuniorSchool": "Ritenour Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active Under Contract" +"OnMarketDate": "2025-07-21" +"OriginalEntryTimestamp": "2025-07-21T17:30:36Z" +"OriginalListPrice": 175000 +"ParcelNumber": "15K-53-1005" +"ParkingFeatures": array:1 [ 0 => "Driveway" ] +"PhotosChangeTimestamp": "2025-07-21T21:30:38Z" +"PhotosCount": 15 +"PreviousListPrice": 175000 +"PriceChangeTimestamp": "2025-07-27T20:18:20Z" +"Roof": array:1 [ 0 => "Architectural Shingle" ] +"RoomsTotal": "6" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:4 [ 0 => "Appointment Only" 1 => "Lockbox" 2 => "Pet(s) on Premises" 3 => "Showing Service" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-08-10T16:36:08Z" +"StreetName": "Oakland" +"StreetNumber": "2495" +"StreetNumberNumeric": "2495" +"StreetSuffix": "Avenue" +"SubdivisionName": "Laughlins Add To Sycamore Hills" +"TaxAnnualAmount": "2165" +"TaxYear": "2024" +"Township": "Sycamore Hills" +"VirtualTourURLUnbranded": "https://mls.kuu.la/share/collection/7D5Cr?fs=1&vr=1&sd=1&initload=0&thumbs=1" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_Section": "SYCAMORE HILLS" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "6" +"MIS_CurrentPrice": "169500.00" +"MIS_EfficiencyYN": "0" +"MIS_OpenHouseCount": "0" +"MIS_PreviousStatus": "Active" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_ActiveOpenHouseCount": "0" +"MIS_OpenHousePublicCount": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "2" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203893288')" +"provider_name": "MARIS" +"Media": array:15 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "687ea770cefa4c4951fa33f2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/50da6671c1dbfe656f97673f85de61dc.webp" "MediaSize" => 189477 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-50da6671c1dbfe656f97673f85de61dc.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Bungalow-style house with covered porch and brick siding" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-07-21T20:47:44.276Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "687ea770cefa4c4951fa33f3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/3cbb7e191eef3e21c4756e2d176b6cf0.webp" "MediaSize" => 158617 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-3cbb7e191eef3e21c4756e2d176b6cf0.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of porch" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-07-21T20:47:44.232Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "687ea770cefa4c4951fa33f4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/1d8acecfca912f0f3b5fbb8569fc32cd.webp" "MediaSize" => 47689 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-1d8acecfca912f0f3b5fbb8569fc32cd.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-21T20:47:44.206Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "687ea770cefa4c4951fa33f5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/68d56d23c73011a8e025260f59ae8659.webp" "MediaSize" => 59810 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-68d56d23c73011a8e025260f59ae8659.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-21T20:47:44.288Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "687ea770cefa4c4951fa33f6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/c3e981fe0f1f6320cee15fdc16bed925.webp" "MediaSize" => 39025 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-c3e981fe0f1f6320cee15fdc16bed925.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-21T20:47:44.190Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "687ea770cefa4c4951fa33f7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/445ca8cc63b8a780755aa3cf95c0859d.webp" "MediaSize" => 41406 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-445ca8cc63b8a780755aa3cf95c0859d.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-21T20:47:44.195Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "687ea770cefa4c4951fa33f8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/19e175e924e84cc58a94f16bc28bf5ac.webp" "MediaSize" => 113528 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-19e175e924e84cc58a94f16bc28bf5ac.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-07-21T20:47:44.244Z" ] 7 => array:11 [ "Order" => 10 "MediaKey" => "687ea770cefa4c4951fa33fc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/d0a557e8e49870780ecee8d30cc6295d.webp" "MediaSize" => 50325 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-d0a557e8e49870780ecee8d30cc6295d.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-21T20:47:44.175Z" ] 8 => array:11 [ "Order" => 11 "MediaKey" => "687ea770cefa4c4951fa33fd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/f0224afc6406ebd97371bf0c196914f7.webp" "MediaSize" => 169281 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-f0224afc6406ebd97371bf0c196914f7.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-21T20:47:44.264Z" ] 9 => array:11 [ "Order" => 7 "MediaKey" => "687eb1484bf1d71424884cf8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/380555ba490bc08766995c237907a70f.webp" "MediaSize" => 49208 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-380555ba490bc08766995c237907a70f.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-21T21:29:44.966Z" ] 10 => array:11 [ "Order" => 8 "MediaKey" => "687eb1484bf1d71424884cf9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/07e9eeb3a842cfd9874f4c5fac97f6b5.webp" "MediaSize" => 52029 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-07e9eeb3a842cfd9874f4c5fac97f6b5.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-21T21:29:44.971Z" ] 11 => array:11 [ "Order" => 9 "MediaKey" => "687eb1484bf1d71424884cfa" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/0236833a7b1e45507fa086af05a1b208.webp" "MediaSize" => 69465 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-0236833a7b1e45507fa086af05a1b208.webp" "ImageWidth" => 576 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "576x768" "MediaModificationTimestamp" => "2025-07-21T21:29:44.996Z" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "687ea770cefa4c4951fa33ff" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/ceb46f9e58a942eba6f786d1dfb5472c.webp" "MediaSize" => 170845 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-ceb46f9e58a942eba6f786d1dfb5472c.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-07-21T20:47:44.243Z" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "687ea770cefa4c4951fa3400" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/d47e68abca55453665250cbf62bd98fe.webp" "MediaSize" => 168374 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-d47e68abca55453665250cbf62bd98fe.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-07-21T20:47:44.233Z" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "687ea770cefa4c4951fa3401" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/f31e27595a61ebfe022b80c735b95935.webp" "MediaSize" => 211522 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203893288/thumbnail-f31e27595a61ebfe022b80c735b95935.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-07-21T20:47:44.301Z" ] ] +"ID": "25056" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.16 seconds" ] ]