Situated squarely in one of STL’s most sought after neighborhoods (The Hill), do not miss this incredible opportunity to enjoy the perfect blend of old-world charm and modern updates. Located right in the center of all of the restaurants and entertainment that The Hill has to offer! This all-brick home has it all! As you enter, you’ll notice the new flooring that runs through most of the house! Custom windows allow light into the large living room and sitting area. A beautifully updated large kitchen with white shaker cabinets, modern appliances and custom tile flooring. The bathroom has been updated with luxury finishes including new fixtures and custom tile work. The home also features main floor laundry. All the systems have been updated with a newer HVAC system, hot water heater, electric panel, plumbing, sewer line replaced in yard and even a new TPO roof! This is one you REALLY don’t want to miss!
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835 +post_id: "21182" +post_author: 1 +"ListingKey": "MIS203178665" +"ListingId": "25034710" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T14:23:38Z" +"RFModificationTimestamp": "2025-06-14T14:24:50.751655+00:00" +"ListPrice": 199900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63139" +"UnparsedAddress": "5525 Magnolia Avenue, St Louis, Missouri 63139" +"Coordinates": array:2 [ 0 => -90.28151483 1 => 38.61039532 ] +"Latitude": 38.61039532 +"Longitude": -90.28151483 +"YearBuilt": 1894 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mark Davis" +"ListOfficeName": "Davis Real Estate" +"ListAgentMlsId": "MDAVIS1" +"ListOfficeMlsId": "DVSR01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Situated squarely in one of STL’s most sought after neighborhoods (The Hill), do not miss this incredible opportunity to enjoy the perfect blend of old-world charm and modern updates. Located right in the center of all of the restaurants and entertainment that The Hill has to offer! This all-brick home has it all! As you enter, you'll notice the new flooring that runs through most of the house! Custom windows allow light into the large living room and sitting area. A beautifully updated large kitchen with white shaker cabinets, modern appliances and custom tile flooring. The bathroom has been updated with luxury finishes including new fixtures and custom tile work. The home also features main floor laundry. All the systems have been updated with a newer HVAC system, hot water heater, electric panel, plumbing, sewer line replaced in yard and even a new TPO roof! This is one you REALLY don’t want to miss!" +"AboveGradeFinishedArea": 826 +"AboveGradeFinishedAreaSource": "Public Records" +"ArchitecturalStyle": array:2 [ 0 => "Historic" 1 => "Traditional" ] +"Basement": array:1 [ 0 => "8 ft + Pour" ] +"BathroomsFull": 1 +"BuildingFeatures": array:1 [ 0 => "Basement" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:2 [ 0 => "Ceiling Fan(s)" 1 => "Central Air" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-05-22T13:13:25.983074+00:00" +"CrossStreet": "Sublette" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 28 +"DevelopmentStatus": array:1 [ 0 => "Completed" ] +"Disclosures": array:4 [ 0 => "Flood Plain No" 1 => "Lead Paint" 2 => "Occupancy Permit Required" 3 => "Seller Property Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-14T14:23:38Z" +"DocumentsCount": 2 +"Electric": "Ameren" +"ElementarySchool": "Mason Elem." +"FireplaceFeatures": array:1 [ 0 => "None" ] +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Roosevelt High" +"HighSchoolDistrict": "St. Louis City" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "14534" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "33040357" +"ListOfficePhone": "314-749-3792" +"ListingService": "Full Service" +"ListingTerms": "Cash,FHA" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.07 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "3 - South City" +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-13T19:19:54Z" +"MiddleOrJuniorSchool": "Long Middle Community Ed. Center" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-05-29" +"OriginalEntryTimestamp": "2025-05-22T13:07:42Z" +"OriginalListPrice": 209900 +"ParcelNumber": "4054-02-0410-0" +"PhotosChangeTimestamp": "2025-05-22T13:09:38Z" +"PhotosCount": 13 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCodePlus4": "1637" +"PreviousListPrice": 209900 +"PriceChangeTimestamp": "2025-06-13T19:19:54Z" +"RoomsTotal": "6" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactType": array:1 [ 0 => "Showing Service" ] +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-05-29T14:48:01Z" +"StreetName": "Magnolia" +"StreetNumber": "5525" +"StreetNumberNumeric": "5525" +"StreetSuffix": "Avenue" +"SubdivisionName": "Wenzlick Darrs Add" +"TaxAnnualAmount": "1875" +"TaxYear": "2024" +"Township": "St. Louis City" +"WaterSource": array:1 [ 0 => "Public" ] +"YearBuiltSource": "Public Records" +"MIS_PoolYN": "0" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "199900.00" +"MIS_Neighborhood": "The Hill" +"MIS_PreviousStatus": "Coming Soon" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "1" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203178665')" +"provider_name": "MARIS" +"Media": array:13 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "682f21da6571326bb1426732" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/a7736589ddccaeb452af4461f3041013.webp" "MediaSize" => 177638 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-a7736589ddccaeb452af4461f3041013.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Front of home with old world charm!" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.762Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "682f21da6571326bb1426733" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/2a5eb4d0c12b1d9c7601e63c0e72c297.webp" "MediaSize" => 77654 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-2a5eb4d0c12b1d9c7601e63c0e72c297.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.765Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "682f21da6571326bb1426734" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/bffb199927a024c37ab1bb762dbce556.webp" "MediaSize" => 77840 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-bffb199927a024c37ab1bb762dbce556.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with white shaker cabinets and modern appliances." "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.752Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "682f21da6571326bb1426735" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/da7cd1350c628766c9a0c5d19c018702.webp" "MediaSize" => 90742 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-da7cd1350c628766c9a0c5d19c018702.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.752Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "682f21da6571326bb1426736" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/6b443c6938eddaa1b6bf481061a28a9c.webp" "MediaSize" => 63252 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-6b443c6938eddaa1b6bf481061a28a9c.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living room with large sitting area and modern light fixtures." "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.765Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "682f21da6571326bb1426737" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/a70ddfa92d2eabfd73a4505d64543712.webp" "MediaSize" => 60843 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-a70ddfa92d2eabfd73a4505d64543712.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.777Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "682f21da6571326bb1426738" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/248525090956d2e7b9dff2a973e465ee.webp" "MediaSize" => 68732 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-248525090956d2e7b9dff2a973e465ee.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Check out the custom tile work!" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.796Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "682f21da6571326bb1426739" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/2b4c15660a3b53c07f1a3ec7b20afc52.webp" "MediaSize" => 58448 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-2b4c15660a3b53c07f1a3ec7b20afc52.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.788Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "682f21da6571326bb142673a" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/ff015002d25094569caeb162b4e7bcbd.webp" "MediaSize" => 82815 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-ff015002d25094569caeb162b4e7bcbd.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Primary bedroom with exposed brick!" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.785Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "682f21da6571326bb142673b" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/1ad66c5f6a71a5e37626ec374cfcfdce.webp" "MediaSize" => 60808 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-1ad66c5f6a71a5e37626ec374cfcfdce.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.768Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "682f21da6571326bb142673c" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/93e783f72c84e939697beea3a8d90b51.webp" "MediaSize" => 73027 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-93e783f72c84e939697beea3a8d90b51.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.742Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "682f21da6571326bb142673d" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/b10a3d51220b1ed442b15250ffe86832.webp" "MediaSize" => 65483 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-b10a3d51220b1ed442b15250ffe86832.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Main floor laundry!!" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.766Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "682f21da6571326bb142673e" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/8ed797691bc9c1c017025062fc2b849b.webp" "MediaSize" => 188382 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-8ed797691bc9c1c017025062fc2b849b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Nice level backyard, perfect for entertaining." "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.767Z" ] ] +"ID": "21182" }
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 'MIS203178665'/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 'MIS203178665'&$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 'MIS203178665'/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 'MIS203178665'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2833 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835 +post_id: "21182" +post_author: 1 +"ListingKey": "MIS203178665" +"ListingId": "25034710" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-14T14:23:38Z" +"RFModificationTimestamp": "2025-06-14T14:24:50.751655+00:00" +"ListPrice": 199900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63139" +"UnparsedAddress": "5525 Magnolia Avenue, St Louis, Missouri 63139" +"Coordinates": array:2 [ 0 => -90.28151483 1 => 38.61039532 ] +"Latitude": 38.61039532 +"Longitude": -90.28151483 +"YearBuilt": 1894 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mark Davis" +"ListOfficeName": "Davis Real Estate" +"ListAgentMlsId": "MDAVIS1" +"ListOfficeMlsId": "DVSR01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Situated squarely in one of STL’s most sought after neighborhoods (The Hill), do not miss this incredible opportunity to enjoy the perfect blend of old-world charm and modern updates. Located right in the center of all of the restaurants and entertainment that The Hill has to offer! This all-brick home has it all! As you enter, you'll notice the new flooring that runs through most of the house! Custom windows allow light into the large living room and sitting area. A beautifully updated large kitchen with white shaker cabinets, modern appliances and custom tile flooring. The bathroom has been updated with luxury finishes including new fixtures and custom tile work. The home also features main floor laundry. All the systems have been updated with a newer HVAC system, hot water heater, electric panel, plumbing, sewer line replaced in yard and even a new TPO roof! This is one you REALLY don’t want to miss!" +"AboveGradeFinishedArea": 826 +"AboveGradeFinishedAreaSource": "Public Records" +"ArchitecturalStyle": array:2 [ 0 => "Historic" 1 => "Traditional" ] +"Basement": array:1 [ 0 => "8 ft + Pour" ] +"BathroomsFull": 1 +"BuildingFeatures": array:1 [ 0 => "Basement" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:2 [ 0 => "Ceiling Fan(s)" 1 => "Central Air" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-05-22T13:13:25.983074+00:00" +"CrossStreet": "Sublette" +"CumulativeDaysOnMarket": 16 +"DaysOnMarket": 28 +"DevelopmentStatus": array:1 [ 0 => "Completed" ] +"Disclosures": array:4 [ 0 => "Flood Plain No" 1 => "Lead Paint" 2 => "Occupancy Permit Required" 3 => "Seller Property Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-14T14:23:38Z" +"DocumentsCount": 2 +"Electric": "Ameren" +"ElementarySchool": "Mason Elem." +"FireplaceFeatures": array:1 [ 0 => "None" ] +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Roosevelt High" +"HighSchoolDistrict": "St. Louis City" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "14534" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "33040357" +"ListOfficePhone": "314-749-3792" +"ListingService": "Full Service" +"ListingTerms": "Cash,FHA" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.07 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "3 - South City" +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-13T19:19:54Z" +"MiddleOrJuniorSchool": "Long Middle Community Ed. Center" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-05-29" +"OriginalEntryTimestamp": "2025-05-22T13:07:42Z" +"OriginalListPrice": 209900 +"ParcelNumber": "4054-02-0410-0" +"PhotosChangeTimestamp": "2025-05-22T13:09:38Z" +"PhotosCount": 13 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCodePlus4": "1637" +"PreviousListPrice": 209900 +"PriceChangeTimestamp": "2025-06-13T19:19:54Z" +"RoomsTotal": "6" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactType": array:1 [ 0 => "Showing Service" ] +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-05-29T14:48:01Z" +"StreetName": "Magnolia" +"StreetNumber": "5525" +"StreetNumberNumeric": "5525" +"StreetSuffix": "Avenue" +"SubdivisionName": "Wenzlick Darrs Add" +"TaxAnnualAmount": "1875" +"TaxYear": "2024" +"Township": "St. Louis City" +"WaterSource": array:1 [ 0 => "Public" ] +"YearBuiltSource": "Public Records" +"MIS_PoolYN": "0" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "199900.00" +"MIS_Neighborhood": "The Hill" +"MIS_PreviousStatus": "Coming Soon" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "1" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203178665')" +"provider_name": "MARIS" +"Media": array:13 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "682f21da6571326bb1426732" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/a7736589ddccaeb452af4461f3041013.webp" "MediaSize" => 177638 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-a7736589ddccaeb452af4461f3041013.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Front of home with old world charm!" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.762Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "682f21da6571326bb1426733" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/2a5eb4d0c12b1d9c7601e63c0e72c297.webp" "MediaSize" => 77654 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-2a5eb4d0c12b1d9c7601e63c0e72c297.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.765Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "682f21da6571326bb1426734" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/bffb199927a024c37ab1bb762dbce556.webp" "MediaSize" => 77840 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-bffb199927a024c37ab1bb762dbce556.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with white shaker cabinets and modern appliances." "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.752Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "682f21da6571326bb1426735" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/da7cd1350c628766c9a0c5d19c018702.webp" "MediaSize" => 90742 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-da7cd1350c628766c9a0c5d19c018702.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.752Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "682f21da6571326bb1426736" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/6b443c6938eddaa1b6bf481061a28a9c.webp" "MediaSize" => 63252 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-6b443c6938eddaa1b6bf481061a28a9c.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living room with large sitting area and modern light fixtures." "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.765Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "682f21da6571326bb1426737" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/a70ddfa92d2eabfd73a4505d64543712.webp" "MediaSize" => 60843 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-a70ddfa92d2eabfd73a4505d64543712.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.777Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "682f21da6571326bb1426738" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/248525090956d2e7b9dff2a973e465ee.webp" "MediaSize" => 68732 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-248525090956d2e7b9dff2a973e465ee.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Check out the custom tile work!" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.796Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "682f21da6571326bb1426739" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/2b4c15660a3b53c07f1a3ec7b20afc52.webp" "MediaSize" => 58448 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-2b4c15660a3b53c07f1a3ec7b20afc52.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.788Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "682f21da6571326bb142673a" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/ff015002d25094569caeb162b4e7bcbd.webp" "MediaSize" => 82815 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-ff015002d25094569caeb162b4e7bcbd.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Primary bedroom with exposed brick!" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.785Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "682f21da6571326bb142673b" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/1ad66c5f6a71a5e37626ec374cfcfdce.webp" "MediaSize" => 60808 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-1ad66c5f6a71a5e37626ec374cfcfdce.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.768Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "682f21da6571326bb142673c" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/93e783f72c84e939697beea3a8d90b51.webp" "MediaSize" => 73027 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-93e783f72c84e939697beea3a8d90b51.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.742Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "682f21da6571326bb142673d" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/b10a3d51220b1ed442b15250ffe86832.webp" "MediaSize" => 65483 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-b10a3d51220b1ed442b15250ffe86832.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Main floor laundry!!" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.766Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "682f21da6571326bb142673e" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/8ed797691bc9c1c017025062fc2b849b.webp" "MediaSize" => 188382 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203178665/thumbnail-8ed797691bc9c1c017025062fc2b849b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Nice level backyard, perfect for entertaining." "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-22T13:08:42.767Z" ] ] +"ID": "21182" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.16 seconds" ] ]