Charming brick home with great floor plan.
Updated kitchen with all Kitchen Aid stainless steel appliances. Stained wood cabinets and ceramic tile floor.
The home has beautiful original hardwood floors, Art Deco sconces and architectural arches.
Great updated bathroom by Bath Fitter. Counter height vanity, ceramic tile floor, tall commode and custom glass shower doors.
You will enjoy entertaining or just relaxing on your large covered deck. Well landscaped yard.
The home comes with a newer 2 car garage off the alley.
Most of the windows have been replaced. There are some double hung tilt ins for easy cleaning 4 of the windows have cranks. Plantation shutters or 2″ blinds.
Home is freshly painted through out.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2837 +post_id: "23773" +post_author: 1 +"ListingKey": "MIS203703134" +"ListingId": "25046259" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-09T20:15:38Z" +"RFModificationTimestamp": "2025-08-09T20:19:35Z" +"ListPrice": 255000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1077.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63139" +"UnparsedAddress": "5023 Fairrview Ave, St Louis, Missouri 63039" +"Coordinates": array:2 [ 0 => -90.276218 1 => 38.598753 ] +"Latitude": 38.598753 +"Longitude": -90.276218 +"YearBuilt": 1937 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Debbie Haas" +"ListOfficeName": "Coldwell Banker Realty - Gundaker" +"ListAgentMlsId": "SDHAAS" +"ListOfficeMlsId": "CBG15" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Charming brick home with great floor plan. \n Updated kitchen with all Kitchen Aid stainless steel appliances. Stained wood cabinets and ceramic tile floor.\n The home has beautiful original hardwood floors, Art Deco sconces and architectural arches. \n Great updated bathroom by Bath Fitter. Counter height vanity, ceramic tile floor, tall commode and custom glass shower doors. \n You will enjoy entertaining or just relaxing on your large covered deck. Well landscaped yard.\n The home comes with a newer 2 car garage off the alley. \n Most of the windows have been replaced. There are some double hung tilt ins for easy cleaning 4 of the windows have cranks. Plantation shutters or 2" blinds.\n Home is freshly painted through out. """ +"AboveGradeFinishedArea": 1077 +"AboveGradeFinishedAreaSource": "Assessor" +"Appliances": array:10 [ 0 => "Stainless Steel Appliance(s)" 1 => "Dishwasher" 2 => "Disposal" 3 => "Dryer" 4 => "Microwave" 5 => "Double Oven" 6 => "Self Cleaning Oven" 7 => "Free-Standing Gas Range" 8 => "Refrigerator" 9 => "Washer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"BackOnMarketDate": "2025-08-06" +"Basement": array:6 [ 0 => "Concrete" 1 => "Full" 2 => "Interior Entry" 3 => "Storage Space" 4 => "Unfinished" 5 => "Walk-Up Access" ] +"BasementYN": true +"BathroomsFull": 1 +"BelowGradeFinishedAreaSource": "Assessor" +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-07-04T02:12:14.671419+00:00" +"CrossStreet": "Hereford" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 9 +"Directions": "South on Kingshighway to West on Fairview Avenue (one way street)" +"DocumentsAvailable": array:1 [ 0 => "Legal Description" ] +"DocumentsChangeTimestamp": "2025-07-12T13:26:38Z" +"DocumentsCount": 3 +"Electric": "Ameren" +"ElementarySchool": "Mason Elem." +"ExteriorFeatures": array:1 [ 0 => "Awning(s)" ] +"Fencing": array:1 [ 0 => "Back Yard" ] +"FireplaceFeatures": array:2 [ 0 => "Decorative" 1 => "Living Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:2 [ 0 => "Ceramic Tile" 1 => "Hardwood" ] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Roosevelt High" +"HighSchoolDistrict": "St. Louis City" +"InteriorFeatures": array:1 [ 0 => "Ceiling Fan(s)" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "22234" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "827" +"ListOfficePhone": "314-965-3030" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:1 [ 0 => "Back Yard" ] +"LotSizeAcres": 0.1028 +"LotSizeDimensions": "35' X 128"" +"LotSizeSource": "Public Records" +"MLSAreaMajor": "3 - South City" +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-08-06T11:33:32Z" +"MiddleOrJuniorSchool": "Long Middle Community Ed. Center" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-06" +"OriginalEntryTimestamp": "2025-07-04T02:10:19Z" +"OriginalListPrice": 255000 +"ParcelNumber": "6076-00-2220-0" +"ParkingFeatures": array:1 [ 0 => "Alley Access" ] +"PatioAndPorchFeatures": array:2 [ 0 => "Covered" 1 => "Deck" ] +"PhotosChangeTimestamp": "2025-08-09T20:15:38Z" +"PhotosCount": 10 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCodePlus4": "1309" +"Roof": array:1 [ 0 => "Architectural Shingle" ] +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactPhone": "800-746-9464" +"ShowingContactType": array:1 [ 0 => "Listing Agent" ] +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-08-06T11:33:32Z" +"StreetName": "Fairview" +"StreetNumber": "5023" +"StreetNumberNumeric": "5023" +"StreetSuffix": "Avenue" +"SubdivisionName": "T Kingshighway Hills Addn" +"TaxAnnualAmount": "2541" +"TaxYear": "2023" +"Township": "St. Louis City" +"Utilities": array:1 [ 0 => "Cable Connected" ] +"WaterSource": array:1 [ 0 => "Public" ] +"WindowFeatures": array:6 [ 0 => "Blinds" 1 => "Double Pane Windows" 2 => "Insulated Windows" 3 => "Plantation Shutters" 4 => "Screens" 5 => "Tilt-In Windows" ] +"YearBuiltSource": "Assessor" +"MIS_PoolYN": "0" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "6" +"MIS_CurrentPrice": "255000.00" +"MIS_EfficiencyYN": "0" +"MIS_Neighborhood": "Southwest Garden" +"MIS_PreviousStatus": "Hold" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_GarageSizeDescription": "21' X 21'" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "2" +"MIS_MainAndUpperLevelBathrooms": "1" +"MIS_TaxAnnualAmountDescription": "No Exemptions" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203703134')" +"provider_name": "MARIS" +"Media": array:10 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "686bdf026f9b2b3a775b29eb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/f89b5d0405dc6aebec4eb5eb21b43a6c.webp" "MediaSize" => 207748 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-f89b5d0405dc6aebec4eb5eb21b43a6c.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of front of house with brick siding and a front yard" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-07-07T14:51:46.111Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6897ac313debc02cd72b7c96" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/af3e6a982cfbc9a2d5e844637b81affc.webp" "MediaSize" => 77677 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-af3e6a982cfbc9a2d5e844637b81affc.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished living room with a brick fireplace and wood finished floors" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-08-09T20:14:41.781Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6897ac313debc02cd72b7c97" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/375f352c7cde1c88a5594bd864053851.webp" "MediaSize" => 28173 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-375f352c7cde1c88a5594bd864053851.webp" "ImageWidth" => 576 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Empty room featuring baseboards and wood-type flooring" "ImageSizeDescription" => "576x768" "MediaModificationTimestamp" => "2025-08-09T20:14:41.770Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6897ac313debc02cd72b7c98" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/14e2b98ef4da5087da93657d62282abc.webp" "MediaSize" => 71784 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-14e2b98ef4da5087da93657d62282abc.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with stainless steel appliances, brown cabinetry, tasteful backsplash, light tile patterned floors, and glass insert cabinets" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-08-09T20:14:41.765Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6897ac313debc02cd72b7c99" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/41d1e24dd806e90f3a4c389f20c0777d.webp" "MediaSize" => 44849 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-41d1e24dd806e90f3a4c389f20c0777d.webp" "ImageWidth" => 576 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom featuring wood finished floors and ceiling fan" "ImageSizeDescription" => "576x768" "MediaModificationTimestamp" => "2025-08-09T20:14:41.776Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6890a0adfdb7230d7d48a8db" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/e96bbae7bf09e1f101577baeff5f4506.webp" "MediaSize" => 252163 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-e96bbae7bf09e1f101577baeff5f4506.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of yard featuring a patio and stairs" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.763Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6890a0adfdb7230d7d48a8d9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/197449181574f978161b77145e830ebb.webp" "MediaSize" => 270998 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-197449181574f978161b77145e830ebb.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.761Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6890a0adfdb7230d7d48a8da" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/9b600c7d6a2efa03aa6ef09716fecf78.webp" "MediaSize" => 240408 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-9b600c7d6a2efa03aa6ef09716fecf78.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.764Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6890a0adfdb7230d7d48a8dc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/a6be83913fbecaae31d72f89bc39d071.webp" "MediaSize" => 193848 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-a6be83913fbecaae31d72f89bc39d071.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of home's exterior" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.793Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6890a0adfdb7230d7d48a8dd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/e7cdf4e7a60938ce9514351aedb9fc8d.webp" "MediaSize" => 188980 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-e7cdf4e7a60938ce9514351aedb9fc8d.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of detached garage" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.801Z" ] ] +"ID": "23773" }
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 'MIS203703134'/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 'MIS203703134'&$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 'MIS203703134'/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 'MIS203703134'&$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: "23773" +post_author: 1 +"ListingKey": "MIS203703134" +"ListingId": "25046259" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-09T20:15:38Z" +"RFModificationTimestamp": "2025-08-09T20:19:35Z" +"ListPrice": 255000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1077.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63139" +"UnparsedAddress": "5023 Fairrview Ave, St Louis, Missouri 63039" +"Coordinates": array:2 [ 0 => -90.276218 1 => 38.598753 ] +"Latitude": 38.598753 +"Longitude": -90.276218 +"YearBuilt": 1937 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Debbie Haas" +"ListOfficeName": "Coldwell Banker Realty - Gundaker" +"ListAgentMlsId": "SDHAAS" +"ListOfficeMlsId": "CBG15" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Charming brick home with great floor plan. \n Updated kitchen with all Kitchen Aid stainless steel appliances. Stained wood cabinets and ceramic tile floor.\n The home has beautiful original hardwood floors, Art Deco sconces and architectural arches. \n Great updated bathroom by Bath Fitter. Counter height vanity, ceramic tile floor, tall commode and custom glass shower doors. \n You will enjoy entertaining or just relaxing on your large covered deck. Well landscaped yard.\n The home comes with a newer 2 car garage off the alley. \n Most of the windows have been replaced. There are some double hung tilt ins for easy cleaning 4 of the windows have cranks. Plantation shutters or 2" blinds.\n Home is freshly painted through out. """ +"AboveGradeFinishedArea": 1077 +"AboveGradeFinishedAreaSource": "Assessor" +"Appliances": array:10 [ 0 => "Stainless Steel Appliance(s)" 1 => "Dishwasher" 2 => "Disposal" 3 => "Dryer" 4 => "Microwave" 5 => "Double Oven" 6 => "Self Cleaning Oven" 7 => "Free-Standing Gas Range" 8 => "Refrigerator" 9 => "Washer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"BackOnMarketDate": "2025-08-06" +"Basement": array:6 [ 0 => "Concrete" 1 => "Full" 2 => "Interior Entry" 3 => "Storage Space" 4 => "Unfinished" 5 => "Walk-Up Access" ] +"BasementYN": true +"BathroomsFull": 1 +"BelowGradeFinishedAreaSource": "Assessor" +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-07-04T02:12:14.671419+00:00" +"CrossStreet": "Hereford" +"CumulativeDaysOnMarket": 8 +"DaysOnMarket": 9 +"Directions": "South on Kingshighway to West on Fairview Avenue (one way street)" +"DocumentsAvailable": array:1 [ 0 => "Legal Description" ] +"DocumentsChangeTimestamp": "2025-07-12T13:26:38Z" +"DocumentsCount": 3 +"Electric": "Ameren" +"ElementarySchool": "Mason Elem." +"ExteriorFeatures": array:1 [ 0 => "Awning(s)" ] +"Fencing": array:1 [ 0 => "Back Yard" ] +"FireplaceFeatures": array:2 [ 0 => "Decorative" 1 => "Living Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:2 [ 0 => "Ceramic Tile" 1 => "Hardwood" ] +"GarageSpaces": "2" +"GarageYN": true +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Roosevelt High" +"HighSchoolDistrict": "St. Louis City" +"InteriorFeatures": array:1 [ 0 => "Ceiling Fan(s)" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "22234" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "827" +"ListOfficePhone": "314-965-3030" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:1 [ 0 => "Back Yard" ] +"LotSizeAcres": 0.1028 +"LotSizeDimensions": "35' X 128"" +"LotSizeSource": "Public Records" +"MLSAreaMajor": "3 - South City" +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-08-06T11:33:32Z" +"MiddleOrJuniorSchool": "Long Middle Community Ed. Center" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-06" +"OriginalEntryTimestamp": "2025-07-04T02:10:19Z" +"OriginalListPrice": 255000 +"ParcelNumber": "6076-00-2220-0" +"ParkingFeatures": array:1 [ 0 => "Alley Access" ] +"PatioAndPorchFeatures": array:2 [ 0 => "Covered" 1 => "Deck" ] +"PhotosChangeTimestamp": "2025-08-09T20:15:38Z" +"PhotosCount": 10 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCodePlus4": "1309" +"Roof": array:1 [ 0 => "Architectural Shingle" ] +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactPhone": "800-746-9464" +"ShowingContactType": array:1 [ 0 => "Listing Agent" ] +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-08-06T11:33:32Z" +"StreetName": "Fairview" +"StreetNumber": "5023" +"StreetNumberNumeric": "5023" +"StreetSuffix": "Avenue" +"SubdivisionName": "T Kingshighway Hills Addn" +"TaxAnnualAmount": "2541" +"TaxYear": "2023" +"Township": "St. Louis City" +"Utilities": array:1 [ 0 => "Cable Connected" ] +"WaterSource": array:1 [ 0 => "Public" ] +"WindowFeatures": array:6 [ 0 => "Blinds" 1 => "Double Pane Windows" 2 => "Insulated Windows" 3 => "Plantation Shutters" 4 => "Screens" 5 => "Tilt-In Windows" ] +"YearBuiltSource": "Assessor" +"MIS_PoolYN": "0" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "6" +"MIS_CurrentPrice": "255000.00" +"MIS_EfficiencyYN": "0" +"MIS_Neighborhood": "Southwest Garden" +"MIS_PreviousStatus": "Hold" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_GarageSizeDescription": "21' X 21'" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "2" +"MIS_MainAndUpperLevelBathrooms": "1" +"MIS_TaxAnnualAmountDescription": "No Exemptions" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203703134')" +"provider_name": "MARIS" +"Media": array:10 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "686bdf026f9b2b3a775b29eb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/f89b5d0405dc6aebec4eb5eb21b43a6c.webp" "MediaSize" => 207748 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-f89b5d0405dc6aebec4eb5eb21b43a6c.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of front of house with brick siding and a front yard" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-07-07T14:51:46.111Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6897ac313debc02cd72b7c96" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/af3e6a982cfbc9a2d5e844637b81affc.webp" "MediaSize" => 77677 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-af3e6a982cfbc9a2d5e844637b81affc.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished living room with a brick fireplace and wood finished floors" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-08-09T20:14:41.781Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6897ac313debc02cd72b7c97" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/375f352c7cde1c88a5594bd864053851.webp" "MediaSize" => 28173 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-375f352c7cde1c88a5594bd864053851.webp" "ImageWidth" => 576 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Empty room featuring baseboards and wood-type flooring" "ImageSizeDescription" => "576x768" "MediaModificationTimestamp" => "2025-08-09T20:14:41.770Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6897ac313debc02cd72b7c98" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/14e2b98ef4da5087da93657d62282abc.webp" "MediaSize" => 71784 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-14e2b98ef4da5087da93657d62282abc.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with stainless steel appliances, brown cabinetry, tasteful backsplash, light tile patterned floors, and glass insert cabinets" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-08-09T20:14:41.765Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6897ac313debc02cd72b7c99" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/41d1e24dd806e90f3a4c389f20c0777d.webp" "MediaSize" => 44849 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-41d1e24dd806e90f3a4c389f20c0777d.webp" "ImageWidth" => 576 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom featuring wood finished floors and ceiling fan" "ImageSizeDescription" => "576x768" "MediaModificationTimestamp" => "2025-08-09T20:14:41.776Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6890a0adfdb7230d7d48a8db" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/e96bbae7bf09e1f101577baeff5f4506.webp" "MediaSize" => 252163 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-e96bbae7bf09e1f101577baeff5f4506.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of yard featuring a patio and stairs" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.763Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6890a0adfdb7230d7d48a8d9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/197449181574f978161b77145e830ebb.webp" "MediaSize" => 270998 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-197449181574f978161b77145e830ebb.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.761Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6890a0adfdb7230d7d48a8da" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/9b600c7d6a2efa03aa6ef09716fecf78.webp" "MediaSize" => 240408 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-9b600c7d6a2efa03aa6ef09716fecf78.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.764Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6890a0adfdb7230d7d48a8dc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/a6be83913fbecaae31d72f89bc39d071.webp" "MediaSize" => 193848 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-a6be83913fbecaae31d72f89bc39d071.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of home's exterior" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.793Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6890a0adfdb7230d7d48a8dd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/e7cdf4e7a60938ce9514351aedb9fc8d.webp" "MediaSize" => 188980 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203703134/thumbnail-e7cdf4e7a60938ce9514351aedb9fc8d.webp" "ImageWidth" => 768 "ImageHeight" => 1024 "MediaCategory" => "Photo" "LongDescription" => "View of detached garage" "ImageSizeDescription" => "768x1024" "MediaModificationTimestamp" => "2025-08-04T11:59:41.801Z" ] ] +"ID": "23773" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.16 seconds" ] ]