Full brick mid century ranch home with three bedrooms and full basement. Hardwood floors under the carpet. Features concrete drive off street parking and fenced yard. Buyer(s) to verify Sq. Ft. of lot and structure. Property SOLD “AS-IS”. Financed offers must include: POF & lender pre-approval letter. Cash offers must include POF. Corporate offers must include Corporate Resolution reflecting authorized signer.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "23750" +post_author: 1 +"ListingKey": "MIS203702650" +"ListingId": "25046249" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-05T05:06:38Z" +"RFModificationTimestamp": "2025-07-05T05:09:21Z" +"ListPrice": 39900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63115" +"UnparsedAddress": "3114 Clarence Avenue, St Louis, Missouri 63115" +"Coordinates": array:2 [ 0 => -90.236321 1 => 38.665763 ] +"Latitude": 38.665763 +"Longitude": -90.236321 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Bret Hilbert" +"ListOfficeName": "Hilbert Nation Realty" +"ListAgentMlsId": "BHILBERT" +"ListOfficeMlsId": "HILB01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Full brick mid century ranch home with three bedrooms and full basement. Hardwood floors under the carpet. Features concrete drive off street parking and fenced yard. Buyer(s) to verify Sq. Ft. of lot and structure. Property SOLD “AS-IS”. Financed offers must include: POF & lender pre-approval letter. Cash offers must include POF. Corporate offers must include Corporate Resolution reflecting authorized signer." +"AboveGradeFinishedArea": 925 +"AboveGradeFinishedAreaSource": "Assessor" +"ArchitecturalStyle": array:1 [ 0 => "Ranch" ] +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-07-05T04:59:26.175719+00:00" +"Disclosures": array:1 [ 0 => "None" ] +"DocumentsAvailable": array:1 [ 0 => "None Available" ] +"DocumentsChangeTimestamp": "2025-07-05T05:06:38Z" +"DocumentsCount": 3 +"ElementarySchool": "Hickey Elem." +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Sumner High" +"HighSchoolDistrict": "St. Louis City" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "12434" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "1770" +"ListOfficePhone": "314-481-7355" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LotFeatures": array:1 [ 0 => "Back Yard" ] +"MLSAreaMajor": "5 - North" +"MajorChangeTimestamp": "2025-07-05T04:56:50Z" +"MiddleOrJuniorSchool": "Yeatman-Liddell Middle School" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-04" +"OriginalEntryTimestamp": "2025-07-05T04:56:50Z" +"OriginalListPrice": 39900 +"ParcelNumber": "4465-00-0140-0" +"PhotosChangeTimestamp": "2025-07-05T05:06:38Z" +"PhotosCount": 19 +"RoomsTotal": "5" +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-05T04:56:50Z" +"StreetName": "Clarence" +"StreetNumber": "3114" +"StreetNumberNumeric": "3114" +"StreetSuffix": "Avenue" +"SubdivisionName": "Storbecks" +"Township": "St. Louis City" +"MIS_MainAndUpperLevelBathrooms": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "39900.00" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_Neighborhood": "The Greater Ville" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203702650')" +"provider_name": "MARIS" +"Media": array:19 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "6868b2a80d64b0269030c9b4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/7ca24cd4b64cafc9099f13f2ece7d0a6.webp" "MediaSize" => 243201 "LongDescription" => "View of front of house featuring a front yard and brick siding" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.949Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-7ca24cd4b64cafc9099f13f2ece7d0a6.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6868b2a80d64b0269030c9b5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/c02f7580260da3737710ebe2ec347747.webp" "MediaSize" => 236184 "LongDescription" => "View of yard with a shed and a deck" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.941Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-c02f7580260da3737710ebe2ec347747.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6868b2a80d64b0269030c9b6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/0bbbce75df6541f9892da849cba7505a.webp" "MediaSize" => 262735 "LongDescription" => "Rear view of property featuring brick siding" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.898Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-0bbbce75df6541f9892da849cba7505a.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6868b2a80d64b0269030c9b7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/3b565a025179a0def93d75015686285d.webp" "MediaSize" => 268403 "LongDescription" => "View of home's exterior featuring brick siding" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.933Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-3b565a025179a0def93d75015686285d.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6868b2a80d64b0269030c9b8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/bdab6ae15664af3396c811b7fb378986.webp" "MediaSize" => 118672 "LongDescription" => "View of carpeted empty room" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.896Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-bdab6ae15664af3396c811b7fb378986.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6868b2a80d64b0269030c9b9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/e7765b4432cb78f46989d70ac4ca9c39.webp" "MediaSize" => 104765 "LongDescription" => "Kitchen with black appliances, under cabinet range hood, light flooring, a warming drawer, and tasteful backsplash" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.878Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-e7765b4432cb78f46989d70ac4ca9c39.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6868b2a80d64b0269030c9ba" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/a62ee7cc669a1ae63e7462fb6dade9a3.webp" "MediaSize" => 91706 "LongDescription" => "Full bathroom with shower / tub combination, tile patterned floors, and vanity" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.901Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-a62ee7cc669a1ae63e7462fb6dade9a3.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6868b2a80d64b0269030c9bb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/4d28f1ee3ce9055a51f80aa8b315b3b0.webp" "MediaSize" => 83589 "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.877Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-4d28f1ee3ce9055a51f80aa8b315b3b0.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6868b2a80d64b0269030c9bc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/da3f950fda1ad01e391c0e4f8336de83.webp" "MediaSize" => 80157 "LongDescription" => "Empty room with dark colored carpet and baseboards" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.961Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-da3f950fda1ad01e391c0e4f8336de83.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6868b2a80d64b0269030c9bd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/c530976279036029502cf388270eb9c7.webp" "MediaSize" => 118791 "LongDescription" => "Detailed view of wood finished floors" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.874Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-c530976279036029502cf388270eb9c7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "6868b2a80d64b0269030c9be" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/a38166f5f901c145382484ef3ec089be.webp" "MediaSize" => 80935 "LongDescription" => "Unfurnished bedroom with a closet" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.878Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-a38166f5f901c145382484ef3ec089be.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "6868b2a80d64b0269030c9bf" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/e59b615179e5ef08f31ce05c2d0c2c81.webp" "MediaSize" => 62270 "LongDescription" => "View of unfurnished room" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.867Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-e59b615179e5ef08f31ce05c2d0c2c81.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "6868b2a80d64b0269030c9c0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/1436f3165b62ade775346369999313dc.webp" "MediaSize" => 68023 "LongDescription" => "Unfurnished bedroom with a closet and carpet flooring" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.934Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-1436f3165b62ade775346369999313dc.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "6868b2a80d64b0269030c9c1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/0a2d428ef8c032957d3e9eebde013ea9.webp" "MediaSize" => 72278 "LongDescription" => "Unfurnished bedroom with a closet and carpet flooring" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.892Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-0a2d428ef8c032957d3e9eebde013ea9.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "6868b2a80d64b0269030c9c2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/fcabfb2f8fc2b32033fa85275eb0fe08.webp" "MediaSize" => 76045 "LongDescription" => "Detailed view of wood finished floors and baseboards" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.873Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-fcabfb2f8fc2b32033fa85275eb0fe08.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "6868b2a80d64b0269030c9c3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/164f95fe5c519718ccab7ffa1f1c61d1.webp" "MediaSize" => 72347 "LongDescription" => "View of staircase" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.869Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-164f95fe5c519718ccab7ffa1f1c61d1.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "6868b2a80d64b0269030c9c4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/31d770f94aef2b7f55aeb7f95b528d68.webp" "MediaSize" => 82630 "LongDescription" => "View of finished below grade area" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.997Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-31d770f94aef2b7f55aeb7f95b528d68.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "6868b2a80d64b0269030c9c5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/66161a866dd271ef261f37cf4ce9b8fc.webp" "MediaSize" => 96482 "LongDescription" => "Unfurnished room featuring tile patterned floors" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.905Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-66161a866dd271ef261f37cf4ce9b8fc.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 18 => array:12 [ "Order" => 18 "MediaKey" => "6868b2a80d64b0269030c9c6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/3f90ae997df4e9ed5f8a31c11b94557e.webp" "MediaSize" => 131180 "LongDescription" => "Basement with water heater, stairs, and heating unit" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.923Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-3f90ae997df4e9ed5f8a31c11b94557e.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] ] +"ID": "23750" }
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 'MIS203702650'/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 'MIS203702650'&$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 'MIS203702650'/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 'MIS203702650'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2834 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "23750" +post_author: 1 +"ListingKey": "MIS203702650" +"ListingId": "25046249" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-05T05:06:38Z" +"RFModificationTimestamp": "2025-07-05T05:09:21Z" +"ListPrice": 39900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63115" +"UnparsedAddress": "3114 Clarence Avenue, St Louis, Missouri 63115" +"Coordinates": array:2 [ 0 => -90.236321 1 => 38.665763 ] +"Latitude": 38.665763 +"Longitude": -90.236321 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Bret Hilbert" +"ListOfficeName": "Hilbert Nation Realty" +"ListAgentMlsId": "BHILBERT" +"ListOfficeMlsId": "HILB01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Full brick mid century ranch home with three bedrooms and full basement. Hardwood floors under the carpet. Features concrete drive off street parking and fenced yard. Buyer(s) to verify Sq. Ft. of lot and structure. Property SOLD “AS-IS”. Financed offers must include: POF & lender pre-approval letter. Cash offers must include POF. Corporate offers must include Corporate Resolution reflecting authorized signer." +"AboveGradeFinishedArea": 925 +"AboveGradeFinishedAreaSource": "Assessor" +"ArchitecturalStyle": array:1 [ 0 => "Ranch" ] +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-07-05T04:59:26.175719+00:00" +"Disclosures": array:1 [ 0 => "None" ] +"DocumentsAvailable": array:1 [ 0 => "None Available" ] +"DocumentsChangeTimestamp": "2025-07-05T05:06:38Z" +"DocumentsCount": 3 +"ElementarySchool": "Hickey Elem." +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Sumner High" +"HighSchoolDistrict": "St. Louis City" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "12434" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "1770" +"ListOfficePhone": "314-481-7355" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LotFeatures": array:1 [ 0 => "Back Yard" ] +"MLSAreaMajor": "5 - North" +"MajorChangeTimestamp": "2025-07-05T04:56:50Z" +"MiddleOrJuniorSchool": "Yeatman-Liddell Middle School" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-04" +"OriginalEntryTimestamp": "2025-07-05T04:56:50Z" +"OriginalListPrice": 39900 +"ParcelNumber": "4465-00-0140-0" +"PhotosChangeTimestamp": "2025-07-05T05:06:38Z" +"PhotosCount": 19 +"RoomsTotal": "5" +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-05T04:56:50Z" +"StreetName": "Clarence" +"StreetNumber": "3114" +"StreetNumberNumeric": "3114" +"StreetSuffix": "Avenue" +"SubdivisionName": "Storbecks" +"Township": "St. Louis City" +"MIS_MainAndUpperLevelBathrooms": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "39900.00" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_Neighborhood": "The Greater Ville" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203702650')" +"provider_name": "MARIS" +"Media": array:19 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "6868b2a80d64b0269030c9b4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/7ca24cd4b64cafc9099f13f2ece7d0a6.webp" "MediaSize" => 243201 "LongDescription" => "View of front of house featuring a front yard and brick siding" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.949Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-7ca24cd4b64cafc9099f13f2ece7d0a6.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6868b2a80d64b0269030c9b5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/c02f7580260da3737710ebe2ec347747.webp" "MediaSize" => 236184 "LongDescription" => "View of yard with a shed and a deck" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.941Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-c02f7580260da3737710ebe2ec347747.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6868b2a80d64b0269030c9b6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/0bbbce75df6541f9892da849cba7505a.webp" "MediaSize" => 262735 "LongDescription" => "Rear view of property featuring brick siding" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.898Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-0bbbce75df6541f9892da849cba7505a.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6868b2a80d64b0269030c9b7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/3b565a025179a0def93d75015686285d.webp" "MediaSize" => 268403 "LongDescription" => "View of home's exterior featuring brick siding" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.933Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-3b565a025179a0def93d75015686285d.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6868b2a80d64b0269030c9b8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/bdab6ae15664af3396c811b7fb378986.webp" "MediaSize" => 118672 "LongDescription" => "View of carpeted empty room" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.896Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-bdab6ae15664af3396c811b7fb378986.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6868b2a80d64b0269030c9b9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/e7765b4432cb78f46989d70ac4ca9c39.webp" "MediaSize" => 104765 "LongDescription" => "Kitchen with black appliances, under cabinet range hood, light flooring, a warming drawer, and tasteful backsplash" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.878Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-e7765b4432cb78f46989d70ac4ca9c39.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6868b2a80d64b0269030c9ba" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/a62ee7cc669a1ae63e7462fb6dade9a3.webp" "MediaSize" => 91706 "LongDescription" => "Full bathroom with shower / tub combination, tile patterned floors, and vanity" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.901Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-a62ee7cc669a1ae63e7462fb6dade9a3.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6868b2a80d64b0269030c9bb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/4d28f1ee3ce9055a51f80aa8b315b3b0.webp" "MediaSize" => 83589 "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.877Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-4d28f1ee3ce9055a51f80aa8b315b3b0.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6868b2a80d64b0269030c9bc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/da3f950fda1ad01e391c0e4f8336de83.webp" "MediaSize" => 80157 "LongDescription" => "Empty room with dark colored carpet and baseboards" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.961Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-da3f950fda1ad01e391c0e4f8336de83.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6868b2a80d64b0269030c9bd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/c530976279036029502cf388270eb9c7.webp" "MediaSize" => 118791 "LongDescription" => "Detailed view of wood finished floors" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.874Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-c530976279036029502cf388270eb9c7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "6868b2a80d64b0269030c9be" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/a38166f5f901c145382484ef3ec089be.webp" "MediaSize" => 80935 "LongDescription" => "Unfurnished bedroom with a closet" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.878Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-a38166f5f901c145382484ef3ec089be.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "6868b2a80d64b0269030c9bf" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/e59b615179e5ef08f31ce05c2d0c2c81.webp" "MediaSize" => 62270 "LongDescription" => "View of unfurnished room" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.867Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-e59b615179e5ef08f31ce05c2d0c2c81.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "6868b2a80d64b0269030c9c0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/1436f3165b62ade775346369999313dc.webp" "MediaSize" => 68023 "LongDescription" => "Unfurnished bedroom with a closet and carpet flooring" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.934Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-1436f3165b62ade775346369999313dc.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "6868b2a80d64b0269030c9c1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/0a2d428ef8c032957d3e9eebde013ea9.webp" "MediaSize" => 72278 "LongDescription" => "Unfurnished bedroom with a closet and carpet flooring" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.892Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-0a2d428ef8c032957d3e9eebde013ea9.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "6868b2a80d64b0269030c9c2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/fcabfb2f8fc2b32033fa85275eb0fe08.webp" "MediaSize" => 76045 "LongDescription" => "Detailed view of wood finished floors and baseboards" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.873Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-fcabfb2f8fc2b32033fa85275eb0fe08.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "6868b2a80d64b0269030c9c3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/164f95fe5c519718ccab7ffa1f1c61d1.webp" "MediaSize" => 72347 "LongDescription" => "View of staircase" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.869Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-164f95fe5c519718ccab7ffa1f1c61d1.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "6868b2a80d64b0269030c9c4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/31d770f94aef2b7f55aeb7f95b528d68.webp" "MediaSize" => 82630 "LongDescription" => "View of finished below grade area" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.997Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-31d770f94aef2b7f55aeb7f95b528d68.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "6868b2a80d64b0269030c9c5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/66161a866dd271ef261f37cf4ce9b8fc.webp" "MediaSize" => 96482 "LongDescription" => "Unfurnished room featuring tile patterned floors" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.905Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-66161a866dd271ef261f37cf4ce9b8fc.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 18 => array:12 [ "Order" => 18 "MediaKey" => "6868b2a80d64b0269030c9c6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/3f90ae997df4e9ed5f8a31c11b94557e.webp" "MediaSize" => 131180 "LongDescription" => "Basement with water heater, stairs, and heating unit" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-05T05:05:44.923Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203702650/thumbnail-3f90ae997df4e9ed5f8a31c11b94557e.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] ] +"ID": "23750" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.34 seconds" ] ]