Build Your Dream Home Near Larimore Park & Future St. Louis Zoo WildCare Park. Situated between Larimore Park and the upcoming St. Louis Zoo WildCare Park (opening 2027), this flat residential lot offers both convenience and future value. With electric and water nearby, it’s ready for your building plans. Whether you’re creating your dream home, adding to your investment portfolio, or holding for future appreciation. This lot is for you!
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2837 +post_id: "26556" +post_author: 1 +"ListingKey": "MIS204130699" +"ListingId": "25055206" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-11T20:18:38Z" +"RFModificationTimestamp": "2025-08-11T20:23:35Z" +"ListPrice": 12000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63138" +"UnparsedAddress": "2 Barcelona Avenue, St Louis, Missouri 63138" +"Coordinates": array:2 [ 0 => -90.196606 1 => 38.788734 ] +"Latitude": 38.788734 +"Longitude": -90.196606 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Scott Stieven" +"ListOfficeName": "Berkshire Hathaway HomeServices Alliance Real Estate" +"ListAgentMlsId": "SSTIEVEN" +"ListOfficeMlsId": "BHAL14" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Build Your Dream Home Near Larimore Park & Future St. Louis Zoo WildCare Park. Situated between Larimore Park and the upcoming St. Louis Zoo WildCare Park (opening 2027), this flat residential lot offers both convenience and future value. With electric and water nearby, it’s ready for your building plans. Whether you’re creating your dream home, adding to your investment portfolio, or holding for future appreciation. This lot is for you!" +"CountyOrParish": "St. Louis" +"CreationDate": "2025-08-11T20:23:06.295048+00:00" +"DevelopmentStatus": array:1 [ 0 => "Raw Land" ] +"Disclosures": array:1 [ 0 => "None" ] +"DocumentsAvailable": array:1 [ 0 => "None Available" ] +"DocumentsChangeTimestamp": "2025-08-11T20:18:38Z" +"Electric": "Ameren" +"ElementarySchool": "Larimore Elem." +"Fencing": array:2 [ 0 => "Back Yard" 1 => "Partial" ] +"HighSchool": "Hazelwood East High" +"HighSchoolDistrict": "Hazelwood" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "83545362" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "36100762" +"ListOfficePhone": "636-343-7800" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LotFeatures": array:1 [ 0 => "Cleared" ] +"LotSizeAcres": 0.2009 +"LotSizeDimensions": "70' x 125'" +"LotSizeSquareFeet": 8751.2 +"MLSAreaMajor": "46 - Hazelwood East" +"MajorChangeTimestamp": "2025-08-11T20:16:50Z" +"MiddleOrJuniorSchool": "Southeast Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-08-11" +"OriginalEntryTimestamp": "2025-08-11T20:16:50Z" +"OriginalListPrice": 12000 +"OwnershipType": "Private" +"ParcelNumber": "08D-12-1246" +"ParkingFeatures": array:2 [ 0 => "Off Site" 1 => "Off Street" ] +"PhotosChangeTimestamp": "2025-08-11T20:18:38Z" +"PhotosCount": 3 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PossibleUse": "Residential,Residential Lots" +"RoadFrontageType": array:1 [ 0 => "City Street" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactPhone": "3149549155" +"ShowingRequirements": array:1 [ 0 => "Register and Show" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-08-11T20:16:50Z" +"StreetName": "Barcelona" +"StreetNumber": "2" +"StreetNumberNumeric": "2" +"StreetSuffix": "Avenue" +"SubdivisionName": "Eldorado 1 Blk 19 Lts 5 Thru 7 Bdy" +"TaxAnnualAmount": "383" +"TaxYear": "2024" +"Topography": "Flat" +"Township": "Unincorporated" +"View": "Neighborhood,Trees/Woods" +"WaterSource": array:1 [ 0 => "Public" ] +"Zoning": "Residential" +"MIS_Section": "UNINCORPORATED" +"MIS_AuctionYN": "0" +"MIS_CurrentPrice": "12000.00" +"MIS_Restrictions": "Architectural Approval" +"MIS_SecondMortgageYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS204130699')" +"provider_name": "MARIS" +"short_address": "St Louis, Missouri 63138, USA" +"Media": array:3 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "689a4fefbd4ba00c884843e9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/c6a9dba4970eba00ca87be080369714e.webp" "MediaSize" => 214530 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/thumbnail-c6a9dba4970eba00ca87be080369714e.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T20:17:51.081Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "689a4fefbd4ba00c884843ea" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/230509de208d323050570d7bfe27d784.webp" "MediaSize" => 211985 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/thumbnail-230509de208d323050570d7bfe27d784.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T20:17:51.121Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "689a4fefbd4ba00c884843eb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/35479ef6f597e39094ccf1344fcffaef.webp" "MediaSize" => 210583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/thumbnail-35479ef6f597e39094ccf1344fcffaef.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T20:17:51.076Z" ] ] +"ID": "26556" }
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 'MIS204130699'/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 'MIS204130699'&$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 'MIS204130699'/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 'MIS204130699'&$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: "26556" +post_author: 1 +"ListingKey": "MIS204130699" +"ListingId": "25055206" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-11T20:18:38Z" +"RFModificationTimestamp": "2025-08-11T20:23:35Z" +"ListPrice": 12000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63138" +"UnparsedAddress": "2 Barcelona Avenue, St Louis, Missouri 63138" +"Coordinates": array:2 [ 0 => -90.196606 1 => 38.788734 ] +"Latitude": 38.788734 +"Longitude": -90.196606 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Scott Stieven" +"ListOfficeName": "Berkshire Hathaway HomeServices Alliance Real Estate" +"ListAgentMlsId": "SSTIEVEN" +"ListOfficeMlsId": "BHAL14" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Build Your Dream Home Near Larimore Park & Future St. Louis Zoo WildCare Park. Situated between Larimore Park and the upcoming St. Louis Zoo WildCare Park (opening 2027), this flat residential lot offers both convenience and future value. With electric and water nearby, it’s ready for your building plans. Whether you’re creating your dream home, adding to your investment portfolio, or holding for future appreciation. This lot is for you!" +"CountyOrParish": "St. Louis" +"CreationDate": "2025-08-11T20:23:06.295048+00:00" +"DevelopmentStatus": array:1 [ 0 => "Raw Land" ] +"Disclosures": array:1 [ 0 => "None" ] +"DocumentsAvailable": array:1 [ 0 => "None Available" ] +"DocumentsChangeTimestamp": "2025-08-11T20:18:38Z" +"Electric": "Ameren" +"ElementarySchool": "Larimore Elem." +"Fencing": array:2 [ 0 => "Back Yard" 1 => "Partial" ] +"HighSchool": "Hazelwood East High" +"HighSchoolDistrict": "Hazelwood" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "83545362" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "36100762" +"ListOfficePhone": "636-343-7800" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LotFeatures": array:1 [ 0 => "Cleared" ] +"LotSizeAcres": 0.2009 +"LotSizeDimensions": "70' x 125'" +"LotSizeSquareFeet": 8751.2 +"MLSAreaMajor": "46 - Hazelwood East" +"MajorChangeTimestamp": "2025-08-11T20:16:50Z" +"MiddleOrJuniorSchool": "Southeast Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-08-11" +"OriginalEntryTimestamp": "2025-08-11T20:16:50Z" +"OriginalListPrice": 12000 +"OwnershipType": "Private" +"ParcelNumber": "08D-12-1246" +"ParkingFeatures": array:2 [ 0 => "Off Site" 1 => "Off Street" ] +"PhotosChangeTimestamp": "2025-08-11T20:18:38Z" +"PhotosCount": 3 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PossibleUse": "Residential,Residential Lots" +"RoadFrontageType": array:1 [ 0 => "City Street" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactPhone": "3149549155" +"ShowingRequirements": array:1 [ 0 => "Register and Show" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-08-11T20:16:50Z" +"StreetName": "Barcelona" +"StreetNumber": "2" +"StreetNumberNumeric": "2" +"StreetSuffix": "Avenue" +"SubdivisionName": "Eldorado 1 Blk 19 Lts 5 Thru 7 Bdy" +"TaxAnnualAmount": "383" +"TaxYear": "2024" +"Topography": "Flat" +"Township": "Unincorporated" +"View": "Neighborhood,Trees/Woods" +"WaterSource": array:1 [ 0 => "Public" ] +"Zoning": "Residential" +"MIS_Section": "UNINCORPORATED" +"MIS_AuctionYN": "0" +"MIS_CurrentPrice": "12000.00" +"MIS_Restrictions": "Architectural Approval" +"MIS_SecondMortgageYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS204130699')" +"provider_name": "MARIS" +"short_address": "St Louis, Missouri 63138, USA" +"Media": array:3 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "689a4fefbd4ba00c884843e9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/c6a9dba4970eba00ca87be080369714e.webp" "MediaSize" => 214530 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/thumbnail-c6a9dba4970eba00ca87be080369714e.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T20:17:51.081Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "689a4fefbd4ba00c884843ea" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/230509de208d323050570d7bfe27d784.webp" "MediaSize" => 211985 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/thumbnail-230509de208d323050570d7bfe27d784.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T20:17:51.121Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "689a4fefbd4ba00c884843eb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/35479ef6f597e39094ccf1344fcffaef.webp" "MediaSize" => 210583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204130699/thumbnail-35479ef6f597e39094ccf1344fcffaef.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T20:17:51.076Z" ] ] +"ID": "26556" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.13 seconds" ] ]