Incredible investment opportunity! This bundle includes 4 residential lots for a bargain of $100K total—sold AS IS. All structures are unsafe and should be considered tear-downs, with no interior access allowed. Potential may exist for rezoning to commercial—buyer to verify. Located in the Ritenour School District with public water/sewer. Note: 3000 Ashby is in Non-Build tax status—buyer should contact St. Louis County regarding building options. Ideal for future development or investment. Additional Rooms: Other
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "19887" +post_author: 1 +"ListingKey": "MIS96526827" +"ListingId": "MIS25021074" +"PropertyType": "Land" +"PropertySubType": "Residential Lots" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-28T23:43:29Z" +"RFModificationTimestamp": "2025-05-27T06:41:52.063509+00:00" +"ListPrice": 25000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.16 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63114" +"UnparsedAddress": "10515 Clarendon Avenue, St Louis, Missouri 63114" +"Coordinates": array:2 [ 0 => -90.389856 1 => 38.710455 ] +"Latitude": 38.710455 +"Longitude": -90.389856 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "AnnLee F Campbell" +"ListOfficeName": "Strait Realty" +"ListAgentMlsId": "MISACAMPBEL" +"ListOfficeMlsId": "MISSTRA01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Incredible investment opportunity! This bundle includes 4 residential lots for a bargain of $100K total—sold AS IS. All structures are unsafe and should be considered tear-downs, with no interior access allowed. Potential may exist for rezoning to commercial—buyer to verify. Located in the Ritenour School District with public water/sewer. Note: 3000 Ashby is in Non-Build tax status—buyer should contact St. Louis County regarding building options. Ideal for future development or investment. Additional Rooms: Other" +"BuyerOfficeAOR": "St. Louis Association of REALTORS" +"CountyOrParish": "St. Louis" +"CreationDate": "2025-04-07T16:27:34.890696+00:00" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 91 +"DevelopmentStatus": array:1 [ 0 => "Finished Lot(s)" ] +"Disclosures": array:2 [ 0 => "Other" 1 => "Flood Plain No" ] +"DocumentsAvailable": array:2 [ 0 => "Aerial Photos" 1 => "Legal Description" ] +"DocumentsChangeTimestamp": "2025-04-28T23:43:29Z" +"ElementarySchool": "Buder Elem." +"HighSchool": "Ritenour Sr. High" +"HighSchoolDistrict": "Ritenour" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "MIS35595103" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "MIS1490" +"ListOfficePhone": "314-4414444" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LotFeatures": array:2 [ 0 => "Other" 1 => "Level" ] +"LotSizeAcres": 0.1579 +"LotSizeDimensions": "80x80" +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 6878 +"MLSAreaMajor": "91 - Ritenour" +"MajorChangeTimestamp": "2025-04-07T16:12:00Z" +"MiddleOrJuniorSchool": "Hoech Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfLots": "1" +"OffMarketDate": "2025-10-04" +"OnMarketDate": "2025-04-07" +"OriginalEntryTimestamp": "2025-04-07T16:10:51Z" +"OriginalListPrice": 25000 +"OwnershipType": "Private" +"ParcelNumber": "14M-62-0025" +"PhotosChangeTimestamp": "2025-04-28T23:43:29Z" +"PhotosCount": 15 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCodePlus4": "1005" +"RoadFrontageType": array:1 [ 0 => "City Street" ] +"RoadSurfaceType": array:1 [ 0 => "Asphalt" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Showing Service" 1 => "Appointment Only" 2 => "Call Listing Agent" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-04-07T16:10:51Z" +"StreetName": "Clarendon" +"StreetNumber": "10515" +"StreetNumberNumeric": "10515" +"StreetSuffix": "Avenue" +"SubdivisionName": "Tower View" +"TaxAnnualAmount": "1176" +"TaxLegalDescription": "TOWER VIEW LOT PT 23, W PART" +"TaxYear": "2024" +"Township": "Unincorporated" +"Utilities": array:1 [ 0 => "None" ] +"WaterSource": array:1 [ 0 => "Public" ] +"MAR_TYPE": "Other" +"MAR_REST": "Unknown" +"MAR_OPTI": "Other" +"MAR_ShowingsYN": "1" +"MAR_LastStatus": "Coming Soon" +"MAR_ExpectedActiveDate": "2025-04-09" +"MAR_SellerConsiderConcessionYN": "1" +"MAR_Listing_Agent_Nickname": "Ann" +"MAR_Office_Area_Code": "314" +"MAR_IMPR": "None" +"MAR_IsDeleted": "0" +"MAR_MatrixTesting": "0" +"MAR_Transaction_Type": "Sale" +"MAR_Office_Long_Name": "Strait Realty" +"MAR_FOLI": "Other" +"MIS_OpenHousePublicCount": "0" +"MIS_OpenHousePublicUpcoming": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"MIS_CurrentPrice": "25000.00" +"MIS_OpenHouseCount": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS96526827')" +"MIS_RoomCount": "0" +"MIS_UnitCount": "0" +"MIS_PreviousStatus": "Coming Soon" +"MIS_ActiveOpenHouseCount": "0" +"MIS_PoolYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"provider_name": "Stellar" +"MIS_Restrictions": "Unspecified" +"MIS_Section": "UNINCORPORATED" +"Media": array:15 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "67f3334f7b7c65595f287add" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/92e31053c9e6f205b00977a75ad314de.webp" "MediaSize" => 257491 "LongDescription" => "10515 Clarendon" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T02:07:11.299Z" "ImageWidth" => 1591 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-92e31053c9e6f205b00977a75ad314de.webp" "ImageSizeDescription" => "1591x1200" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "67f3334f7b7c65595f287adf" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/581369aac93c4afba627d716c1225b70.webp" "MediaSize" => 254706 "LongDescription" => "3000 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T02:07:11.269Z" "ImageWidth" => 1583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-581369aac93c4afba627d716c1225b70.webp" "ImageSizeDescription" => "1583x1200" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "67f3334f7b7c65595f287ae0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/bb2a7c3299642be0640a409f75feff97.webp" "MediaSize" => 257953 "LongDescription" => "3001 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T02:07:11.315Z" "ImageWidth" => 1540 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-bb2a7c3299642be0640a409f75feff97.webp" "ImageSizeDescription" => "1540x1200" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "67f3334f7b7c65595f287ae1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/75dead1841d217dd8dfc8a685f7bbd40.webp" "MediaSize" => 256741 "LongDescription" => "3005 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1150 "MediaModificationTimestamp" => "2025-04-07T02:07:11.361Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-75dead1841d217dd8dfc8a685f7bbd40.webp" "ImageSizeDescription" => "1600x1150" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "67f3334f7b7c65595f287ade" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/68c7a00d62e9148f3bb0a0099d58a7d3.webp" "MediaSize" => 253753 "LongDescription" => "Map of complete package" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T02:07:11.338Z" "ImageWidth" => 1547 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-68c7a00d62e9148f3bb0a0099d58a7d3.webp" "ImageSizeDescription" => "1547x1200" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "67f3e3cfc8d3da60a764dabb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/97f1ac5058c78ffa46869f1d2f707515.webp" "MediaSize" => 577268 "LongDescription" => "3000 Ashby Non-buildable" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.489Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-97f1ac5058c78ffa46869f1d2f707515.webp" "ImageSizeDescription" => "1600x1200" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "67f3e3cfc8d3da60a764dabf" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/95e6536b4a1e9366dd2c947b43f2084b.webp" "MediaSize" => 479856 "LongDescription" => "3000 Ashby Non-buildable across from the other 3 properties" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.507Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-95e6536b4a1e9366dd2c947b43f2084b.webp" "ImageSizeDescription" => "1600x1200" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "67f3e3cfc8d3da60a764dabc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/8289e136119f13c5d99d9c2f13e0e9fe.webp" "MediaSize" => 676224 "LongDescription" => "View from Ashby of 3001 and 3005 " "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.510Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-8289e136119f13c5d99d9c2f13e0e9fe.webp" "ImageSizeDescription" => "1600x1200" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "67f3e3cfc8d3da60a764dabd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/3affdce1fdd7c7c7e7e74a253530c3ec.webp" "MediaSize" => 744188 "LongDescription" => "3005 Ashby is a double lot going back along 3001 and behind 10515 Clarendon" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-3affdce1fdd7c7c7e7e74a253530c3ec.webp" "ImageSizeDescription" => "1600x1200" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "67f3e3cfc8d3da60a764dabe" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/662be14fd85ef698b1bac6e340eb91ab.webp" "MediaSize" => 655742 "LongDescription" => "3005 Ashby corner looking up to 3001 and corner of Clarendon" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-662be14fd85ef698b1bac6e340eb91ab.webp" "ImageSizeDescription" => "1600x1200" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "67f3e3cfc8d3da60a764dac0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/b4f089fddcdf554e5cc7d0ebe714fc24.webp" "MediaSize" => 576717 "LongDescription" => " Corner of Clarendon and 3001 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-b4f089fddcdf554e5cc7d0ebe714fc24.webp" "ImageSizeDescription" => "1600x1200" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "67f3e3cfc8d3da60a764dac1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/588654f34f1c6b886462ae39a252ed89.webp" "MediaSize" => 642795 "LongDescription" => " Corner of Clarendon and 3001 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-588654f34f1c6b886462ae39a252ed89.webp" "ImageSizeDescription" => "1600x1200" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "67f3e3cfc8d3da60a764dac2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/040f8fd01b6620ea6df63b0235295b8c.webp" "MediaSize" => 673715 "LongDescription" => "Corner of Clarendon and Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-040f8fd01b6620ea6df63b0235295b8c.webp" "ImageSizeDescription" => "1600x1200" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "67f3e3cfc8d3da60a764dac3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/15df73853af0eb82e9cea98256b11fe5.webp" "MediaSize" => 467393 "LongDescription" => "View of street" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-15df73853af0eb82e9cea98256b11fe5.webp" "ImageSizeDescription" => "1600x1200" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "67f3e3cfc8d3da60a764dac4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/eed8711a320070ddc625865dc3d631da.webp" "MediaSize" => 574157 "LongDescription" => "10515 Clarendon front" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-eed8711a320070ddc625865dc3d631da.webp" "ImageSizeDescription" => "1600x1200" ] ] +"ID": "19887" }
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 'MIS96526827'/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 'MIS96526827'&$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 'MIS96526827'/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 'MIS96526827'&$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: "19887" +post_author: 1 +"ListingKey": "MIS96526827" +"ListingId": "MIS25021074" +"PropertyType": "Land" +"PropertySubType": "Residential Lots" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-28T23:43:29Z" +"RFModificationTimestamp": "2025-05-27T06:41:52.063509+00:00" +"ListPrice": 25000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.16 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63114" +"UnparsedAddress": "10515 Clarendon Avenue, St Louis, Missouri 63114" +"Coordinates": array:2 [ 0 => -90.389856 1 => 38.710455 ] +"Latitude": 38.710455 +"Longitude": -90.389856 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "AnnLee F Campbell" +"ListOfficeName": "Strait Realty" +"ListAgentMlsId": "MISACAMPBEL" +"ListOfficeMlsId": "MISSTRA01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Incredible investment opportunity! This bundle includes 4 residential lots for a bargain of $100K total—sold AS IS. All structures are unsafe and should be considered tear-downs, with no interior access allowed. Potential may exist for rezoning to commercial—buyer to verify. Located in the Ritenour School District with public water/sewer. Note: 3000 Ashby is in Non-Build tax status—buyer should contact St. Louis County regarding building options. Ideal for future development or investment. Additional Rooms: Other" +"BuyerOfficeAOR": "St. Louis Association of REALTORS" +"CountyOrParish": "St. Louis" +"CreationDate": "2025-04-07T16:27:34.890696+00:00" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 91 +"DevelopmentStatus": array:1 [ 0 => "Finished Lot(s)" ] +"Disclosures": array:2 [ 0 => "Other" 1 => "Flood Plain No" ] +"DocumentsAvailable": array:2 [ 0 => "Aerial Photos" 1 => "Legal Description" ] +"DocumentsChangeTimestamp": "2025-04-28T23:43:29Z" +"ElementarySchool": "Buder Elem." +"HighSchool": "Ritenour Sr. High" +"HighSchoolDistrict": "Ritenour" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "MIS35595103" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "MIS1490" +"ListOfficePhone": "314-4414444" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LotFeatures": array:2 [ 0 => "Other" 1 => "Level" ] +"LotSizeAcres": 0.1579 +"LotSizeDimensions": "80x80" +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 6878 +"MLSAreaMajor": "91 - Ritenour" +"MajorChangeTimestamp": "2025-04-07T16:12:00Z" +"MiddleOrJuniorSchool": "Hoech Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfLots": "1" +"OffMarketDate": "2025-10-04" +"OnMarketDate": "2025-04-07" +"OriginalEntryTimestamp": "2025-04-07T16:10:51Z" +"OriginalListPrice": 25000 +"OwnershipType": "Private" +"ParcelNumber": "14M-62-0025" +"PhotosChangeTimestamp": "2025-04-28T23:43:29Z" +"PhotosCount": 15 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCodePlus4": "1005" +"RoadFrontageType": array:1 [ 0 => "City Street" ] +"RoadSurfaceType": array:1 [ 0 => "Asphalt" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Showing Service" 1 => "Appointment Only" 2 => "Call Listing Agent" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-04-07T16:10:51Z" +"StreetName": "Clarendon" +"StreetNumber": "10515" +"StreetNumberNumeric": "10515" +"StreetSuffix": "Avenue" +"SubdivisionName": "Tower View" +"TaxAnnualAmount": "1176" +"TaxLegalDescription": "TOWER VIEW LOT PT 23, W PART" +"TaxYear": "2024" +"Township": "Unincorporated" +"Utilities": array:1 [ 0 => "None" ] +"WaterSource": array:1 [ 0 => "Public" ] +"MAR_TYPE": "Other" +"MAR_REST": "Unknown" +"MAR_OPTI": "Other" +"MAR_ShowingsYN": "1" +"MAR_LastStatus": "Coming Soon" +"MAR_ExpectedActiveDate": "2025-04-09" +"MAR_SellerConsiderConcessionYN": "1" +"MAR_Listing_Agent_Nickname": "Ann" +"MAR_Office_Area_Code": "314" +"MAR_IMPR": "None" +"MAR_IsDeleted": "0" +"MAR_MatrixTesting": "0" +"MAR_Transaction_Type": "Sale" +"MAR_Office_Long_Name": "Strait Realty" +"MAR_FOLI": "Other" +"MIS_OpenHousePublicCount": "0" +"MIS_OpenHousePublicUpcoming": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"MIS_CurrentPrice": "25000.00" +"MIS_OpenHouseCount": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS96526827')" +"MIS_RoomCount": "0" +"MIS_UnitCount": "0" +"MIS_PreviousStatus": "Coming Soon" +"MIS_ActiveOpenHouseCount": "0" +"MIS_PoolYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"provider_name": "Stellar" +"MIS_Restrictions": "Unspecified" +"MIS_Section": "UNINCORPORATED" +"Media": array:15 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "67f3334f7b7c65595f287add" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/92e31053c9e6f205b00977a75ad314de.webp" "MediaSize" => 257491 "LongDescription" => "10515 Clarendon" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T02:07:11.299Z" "ImageWidth" => 1591 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-92e31053c9e6f205b00977a75ad314de.webp" "ImageSizeDescription" => "1591x1200" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "67f3334f7b7c65595f287adf" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/581369aac93c4afba627d716c1225b70.webp" "MediaSize" => 254706 "LongDescription" => "3000 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T02:07:11.269Z" "ImageWidth" => 1583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-581369aac93c4afba627d716c1225b70.webp" "ImageSizeDescription" => "1583x1200" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "67f3334f7b7c65595f287ae0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/bb2a7c3299642be0640a409f75feff97.webp" "MediaSize" => 257953 "LongDescription" => "3001 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T02:07:11.315Z" "ImageWidth" => 1540 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-bb2a7c3299642be0640a409f75feff97.webp" "ImageSizeDescription" => "1540x1200" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "67f3334f7b7c65595f287ae1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/75dead1841d217dd8dfc8a685f7bbd40.webp" "MediaSize" => 256741 "LongDescription" => "3005 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1150 "MediaModificationTimestamp" => "2025-04-07T02:07:11.361Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-75dead1841d217dd8dfc8a685f7bbd40.webp" "ImageSizeDescription" => "1600x1150" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "67f3334f7b7c65595f287ade" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/68c7a00d62e9148f3bb0a0099d58a7d3.webp" "MediaSize" => 253753 "LongDescription" => "Map of complete package" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T02:07:11.338Z" "ImageWidth" => 1547 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-68c7a00d62e9148f3bb0a0099d58a7d3.webp" "ImageSizeDescription" => "1547x1200" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "67f3e3cfc8d3da60a764dabb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/97f1ac5058c78ffa46869f1d2f707515.webp" "MediaSize" => 577268 "LongDescription" => "3000 Ashby Non-buildable" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.489Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-97f1ac5058c78ffa46869f1d2f707515.webp" "ImageSizeDescription" => "1600x1200" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "67f3e3cfc8d3da60a764dabf" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/95e6536b4a1e9366dd2c947b43f2084b.webp" "MediaSize" => 479856 "LongDescription" => "3000 Ashby Non-buildable across from the other 3 properties" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.507Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-95e6536b4a1e9366dd2c947b43f2084b.webp" "ImageSizeDescription" => "1600x1200" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "67f3e3cfc8d3da60a764dabc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/8289e136119f13c5d99d9c2f13e0e9fe.webp" "MediaSize" => 676224 "LongDescription" => "View from Ashby of 3001 and 3005 " "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.510Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-8289e136119f13c5d99d9c2f13e0e9fe.webp" "ImageSizeDescription" => "1600x1200" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "67f3e3cfc8d3da60a764dabd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/3affdce1fdd7c7c7e7e74a253530c3ec.webp" "MediaSize" => 744188 "LongDescription" => "3005 Ashby is a double lot going back along 3001 and behind 10515 Clarendon" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-3affdce1fdd7c7c7e7e74a253530c3ec.webp" "ImageSizeDescription" => "1600x1200" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "67f3e3cfc8d3da60a764dabe" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/662be14fd85ef698b1bac6e340eb91ab.webp" "MediaSize" => 655742 "LongDescription" => "3005 Ashby corner looking up to 3001 and corner of Clarendon" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-662be14fd85ef698b1bac6e340eb91ab.webp" "ImageSizeDescription" => "1600x1200" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "67f3e3cfc8d3da60a764dac0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/b4f089fddcdf554e5cc7d0ebe714fc24.webp" "MediaSize" => 576717 "LongDescription" => " Corner of Clarendon and 3001 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-b4f089fddcdf554e5cc7d0ebe714fc24.webp" "ImageSizeDescription" => "1600x1200" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "67f3e3cfc8d3da60a764dac1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/588654f34f1c6b886462ae39a252ed89.webp" "MediaSize" => 642795 "LongDescription" => " Corner of Clarendon and 3001 Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-588654f34f1c6b886462ae39a252ed89.webp" "ImageSizeDescription" => "1600x1200" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "67f3e3cfc8d3da60a764dac2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/040f8fd01b6620ea6df63b0235295b8c.webp" "MediaSize" => 673715 "LongDescription" => "Corner of Clarendon and Ashby" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-040f8fd01b6620ea6df63b0235295b8c.webp" "ImageSizeDescription" => "1600x1200" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "67f3e3cfc8d3da60a764dac3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/15df73853af0eb82e9cea98256b11fe5.webp" "MediaSize" => 467393 "LongDescription" => "View of street" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-15df73853af0eb82e9cea98256b11fe5.webp" "ImageSizeDescription" => "1600x1200" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "67f3e3cfc8d3da60a764dac4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/eed8711a320070ddc625865dc3d631da.webp" "MediaSize" => 574157 "LongDescription" => "10515 Clarendon front" "ResourceRecordKey" => "MAR96526827" "ImageHeight" => 1200 "MediaModificationTimestamp" => "2025-04-07T14:40:15.547Z" "ImageWidth" => 1600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR96526827/thumbnail-eed8711a320070ddc625865dc3d631da.webp" "ImageSizeDescription" => "1600x1200" ] ] +"ID": "19887" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.18 seconds" ] ]