Beautifully Renovated Duplex in Prime Location – Live & Earn!
Don’t miss this stunning, fully renovated duplex nestled on a quiet street in the desirable Tiffany neighborhood—just minutes from SLU Medical Center, Cardinal Glennon Hospital, Tiffany Park, and more.
Each unit features 2 bedrooms and 1 bathroom, with extensive upgrades including:
Brand new TPO roof (installed less than 3 months ago)
Updated HVAC systems
Modern kitchen and bathroom remodels
New flooring throughout
Fresh finishes and fixtures
The first-floor unit is rented and generating $1,450/month, while the second-floor unit is vacant and move-in ready—ideal for owner-occupants looking to offset their mortgage with rental income or savvy investors seeking a turn-key property.
Showings available for the second-floor unit via Showtime.
Please do not disturb tenants.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2837 +post_id: "26539" +post_author: 1 +"ListingKey": "MIS204078313" +"ListingId": "25054106" +"PropertyType": "Residential Income" +"PropertySubType": "2-4 Units" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-11T01:03:38Z" +"RFModificationTimestamp": "2025-08-11T01:06:12Z" +"ListPrice": 349000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63110" +"UnparsedAddress": "3857 Blaine Avenue, St Louis, Missouri 63110" +"Coordinates": array:2 [ 0 => -90.244065 1 => 38.619703 ] +"Latitude": 38.619703 +"Longitude": -90.244065 +"YearBuilt": 1904 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Igal Alon" +"ListOfficeName": "STL Smart Realty" +"ListAgentMlsId": "IGALALON" +"ListOfficeMlsId": "SSMT01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Beautifully Renovated Duplex in Prime Location – Live & Earn!\n \n Don’t miss this stunning, fully renovated duplex nestled on a quiet street in the desirable Tiffany neighborhood—just minutes from SLU Medical Center, Cardinal Glennon Hospital, Tiffany Park, and more.\n \n Each unit features 2 bedrooms and 1 bathroom, with extensive upgrades including:\n \n Brand new TPO roof (installed less than 3 months ago)\n \n Updated HVAC systems\n \n Modern kitchen and bathroom remodels\n \n New flooring throughout\n \n Fresh finishes and fixtures\n \n The first-floor unit is rented and generating $1,450/month, while the second-floor unit is vacant and move-in ready—ideal for owner-occupants looking to offset their mortgage with rental income or savvy investors seeking a turn-key property.\n \n Showings available for the second-floor unit via Showtime.\n Please do not disturb tenants. """ +"AboveGradeFinishedArea": 3200 +"AboveGradeFinishedAreaSource": "Public Records" +"ArchitecturalStyle": array:1 [ 0 => "Traditional" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Wall/Window Unit(s)" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-08-11T01:06:07.543215+00:00" +"Directions": "GPS Friendly." +"Disclosures": array:2 [ 0 => "Agent Owned" 1 => "Lead Paint" ] +"DocumentsChangeTimestamp": "2025-08-11T01:03:38Z" +"DocumentsCount": 2 +"ElementarySchool": "Hodgen Elem." +"Heating": array:2 [ 0 => "Natural Gas" 1 => "Radiant" ] +"HighSchool": "Vashon High" +"HighSchoolDistrict": "St. Louis City" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "56085078" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "56084468" +"ListOfficePhone": "314-898-0048" +"ListingService": "Full Service" +"ListingTerms": "1031 Exchange,Cash,Contract,FHA,VA Loan" +"LotSizeAcres": 0.0735 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "3 - South City" +"MajorChangeTimestamp": "2025-08-11T01:02:28Z" +"MiddleOrJuniorSchool": "Fanning Middle Community Ed." +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfBuildings": 1 +"NumberOfUnitsInCommunity": 2 +"NumberOfUnitsLeased": 1 +"NumberOfUnitsTotal": "2" +"OnMarketDate": "2025-08-10" +"OriginalEntryTimestamp": "2025-08-11T01:02:28Z" +"OriginalListPrice": 349000 +"OwnershipType": "Private" +"ParcelNumber": "4956-00-0420-0" +"ParkingFeatures": array:1 [ 0 => "Off Street" ] +"PhotosChangeTimestamp": "2025-08-11T01:03:38Z" +"PhotosCount": 14 +"PostalCodePlus4": "2607" +"ShowingRequirements": array:1 [ 0 => "Showing Service" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-08-11T01:02:28Z" +"StreetName": "Blaine" +"StreetNumber": "3857" +"StreetNumberNumeric": "3857" +"StreetSuffix": "Avenue" +"StructureType": array:1 [ 0 => "Duplex" ] +"SubdivisionName": "Dundee Add" +"TaxAnnualAmount": "1398" +"TaxYear": "2024" +"Township": "St. Louis City" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_AuctionYN": "0" +"MIS_UnitCount": "1" +"MIS_CurrentPrice": "349000.00" +"MIS_Neighborhood": "Tiffany" +"MIS_SecondMortgageYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS204078313')" +"provider_name": "MARIS" +"short_address": "St Louis, Missouri 63110, USA" +"Media": array:14 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "6899413211b9342bd4d330a8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/18f7adedab11d284f27d8151378d1f74.webp" "MediaSize" => 77920 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-18f7adedab11d284f27d8151378d1f74.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "View of front of house featuring brick siding and a front yard" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.987Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6899413211b9342bd4d330a9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/57f4a46b3be1028664b6917b09e185e0.webp" "MediaSize" => 103771 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-57f4a46b3be1028664b6917b09e185e0.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living area featuring light wood-style flooring and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T01:02:42.006Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6899413211b9342bd4d330aa" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/522ed080b2a94f545ce956483be6e25f.webp" "MediaSize" => 46646 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-522ed080b2a94f545ce956483be6e25f.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Living room with wood finished floors" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.987Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6899413211b9342bd4d330ab" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/454e2e24b6dc605d3967103a2b5beffa.webp" "MediaSize" => 84673 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-454e2e24b6dc605d3967103a2b5beffa.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with appliances with stainless steel finishes, tasteful backsplash, light wood-type flooring, and white cabinetry" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T01:02:41.989Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6899413211b9342bd4d330ac" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/d07f98dd89d288c9113e2e281b2ec074.webp" "MediaSize" => 50528 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-d07f98dd89d288c9113e2e281b2ec074.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring stainless steel electric range oven, black microwave, backsplash, white cabinets, and light countertops" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.989Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6899413211b9342bd4d330ad" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/a50739f21924fcd2c10c69edafcdf9d1.webp" "MediaSize" => 72733 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-a50739f21924fcd2c10c69edafcdf9d1.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Bedroom featuring wood finished floors and radiator heating unit" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T01:02:42.020Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6899413211b9342bd4d330ae" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/2639b98eebcc08116d3e20eeffdf2253.webp" "MediaSize" => 49137 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-2639b98eebcc08116d3e20eeffdf2253.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Bedroom with wood finished floors and baseboards" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.995Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6899413211b9342bd4d330af" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/11c2531c3e31630f711792a5c6d94058.webp" "MediaSize" => 41231 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-11c2531c3e31630f711792a5c6d94058.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "View of carpeted bedroom" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:42.066Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6899413211b9342bd4d330b0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/bfead9509048d9524bdbc7427fd78f7e.webp" "MediaSize" => 46139 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-bfead9509048d9524bdbc7427fd78f7e.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Hall with an upstairs landing, light wood-style flooring, and radiator" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.985Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6899413211b9342bd4d330b1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/7ca635289cf5a106bad484f482c874f7.webp" "MediaSize" => 47261 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-7ca635289cf5a106bad484f482c874f7.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Staircase with wood finished floors and baseboards" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.990Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "6899413211b9342bd4d330b2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/6134c92d505ef8691257ebbd327b2f7a.webp" "MediaSize" => 38932 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-6134c92d505ef8691257ebbd327b2f7a.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Office space with radiator heating unit and light wood-style flooring" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.989Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "6899413211b9342bd4d330b3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/45ef403ba4efe3a30a40dad2135768ff.webp" "MediaSize" => 39204 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-45ef403ba4efe3a30a40dad2135768ff.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Office space featuring radiator heating unit and light wood finished floors" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.992Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "6899413211b9342bd4d330b4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/bbf1d9877d611db6e3f9681e0f8d5e3f.webp" "MediaSize" => 44977 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-bbf1d9877d611db6e3f9681e0f8d5e3f.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Full bathroom featuring vanity and curtained shower" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.987Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "6899413211b9342bd4d330b5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/6ba1e93d3e49e86a197645e26a35c845.webp" "MediaSize" => 48732 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-6ba1e93d3e49e86a197645e26a35c845.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Full bathroom featuring shower / bathtub combination with curtain" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:42.006Z" ] ] +"ID": "26539" }
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 'MIS204078313'/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 'MIS204078313'&$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 'MIS204078313'/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 'MIS204078313'&$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: "26539" +post_author: 1 +"ListingKey": "MIS204078313" +"ListingId": "25054106" +"PropertyType": "Residential Income" +"PropertySubType": "2-4 Units" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-11T01:03:38Z" +"RFModificationTimestamp": "2025-08-11T01:06:12Z" +"ListPrice": 349000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63110" +"UnparsedAddress": "3857 Blaine Avenue, St Louis, Missouri 63110" +"Coordinates": array:2 [ 0 => -90.244065 1 => 38.619703 ] +"Latitude": 38.619703 +"Longitude": -90.244065 +"YearBuilt": 1904 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Igal Alon" +"ListOfficeName": "STL Smart Realty" +"ListAgentMlsId": "IGALALON" +"ListOfficeMlsId": "SSMT01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Beautifully Renovated Duplex in Prime Location – Live & Earn!\n \n Don’t miss this stunning, fully renovated duplex nestled on a quiet street in the desirable Tiffany neighborhood—just minutes from SLU Medical Center, Cardinal Glennon Hospital, Tiffany Park, and more.\n \n Each unit features 2 bedrooms and 1 bathroom, with extensive upgrades including:\n \n Brand new TPO roof (installed less than 3 months ago)\n \n Updated HVAC systems\n \n Modern kitchen and bathroom remodels\n \n New flooring throughout\n \n Fresh finishes and fixtures\n \n The first-floor unit is rented and generating $1,450/month, while the second-floor unit is vacant and move-in ready—ideal for owner-occupants looking to offset their mortgage with rental income or savvy investors seeking a turn-key property.\n \n Showings available for the second-floor unit via Showtime.\n Please do not disturb tenants. """ +"AboveGradeFinishedArea": 3200 +"AboveGradeFinishedAreaSource": "Public Records" +"ArchitecturalStyle": array:1 [ 0 => "Traditional" ] +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Wall/Window Unit(s)" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-08-11T01:06:07.543215+00:00" +"Directions": "GPS Friendly." +"Disclosures": array:2 [ 0 => "Agent Owned" 1 => "Lead Paint" ] +"DocumentsChangeTimestamp": "2025-08-11T01:03:38Z" +"DocumentsCount": 2 +"ElementarySchool": "Hodgen Elem." +"Heating": array:2 [ 0 => "Natural Gas" 1 => "Radiant" ] +"HighSchool": "Vashon High" +"HighSchoolDistrict": "St. Louis City" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "56085078" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "56084468" +"ListOfficePhone": "314-898-0048" +"ListingService": "Full Service" +"ListingTerms": "1031 Exchange,Cash,Contract,FHA,VA Loan" +"LotSizeAcres": 0.0735 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "3 - South City" +"MajorChangeTimestamp": "2025-08-11T01:02:28Z" +"MiddleOrJuniorSchool": "Fanning Middle Community Ed." +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfBuildings": 1 +"NumberOfUnitsInCommunity": 2 +"NumberOfUnitsLeased": 1 +"NumberOfUnitsTotal": "2" +"OnMarketDate": "2025-08-10" +"OriginalEntryTimestamp": "2025-08-11T01:02:28Z" +"OriginalListPrice": 349000 +"OwnershipType": "Private" +"ParcelNumber": "4956-00-0420-0" +"ParkingFeatures": array:1 [ 0 => "Off Street" ] +"PhotosChangeTimestamp": "2025-08-11T01:03:38Z" +"PhotosCount": 14 +"PostalCodePlus4": "2607" +"ShowingRequirements": array:1 [ 0 => "Showing Service" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-08-11T01:02:28Z" +"StreetName": "Blaine" +"StreetNumber": "3857" +"StreetNumberNumeric": "3857" +"StreetSuffix": "Avenue" +"StructureType": array:1 [ 0 => "Duplex" ] +"SubdivisionName": "Dundee Add" +"TaxAnnualAmount": "1398" +"TaxYear": "2024" +"Township": "St. Louis City" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_AuctionYN": "0" +"MIS_UnitCount": "1" +"MIS_CurrentPrice": "349000.00" +"MIS_Neighborhood": "Tiffany" +"MIS_SecondMortgageYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS204078313')" +"provider_name": "MARIS" +"short_address": "St Louis, Missouri 63110, USA" +"Media": array:14 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "6899413211b9342bd4d330a8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/18f7adedab11d284f27d8151378d1f74.webp" "MediaSize" => 77920 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-18f7adedab11d284f27d8151378d1f74.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "View of front of house featuring brick siding and a front yard" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.987Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6899413211b9342bd4d330a9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/57f4a46b3be1028664b6917b09e185e0.webp" "MediaSize" => 103771 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-57f4a46b3be1028664b6917b09e185e0.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living area featuring light wood-style flooring and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T01:02:42.006Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6899413211b9342bd4d330aa" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/522ed080b2a94f545ce956483be6e25f.webp" "MediaSize" => 46646 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-522ed080b2a94f545ce956483be6e25f.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Living room with wood finished floors" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.987Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6899413211b9342bd4d330ab" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/454e2e24b6dc605d3967103a2b5beffa.webp" "MediaSize" => 84673 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-454e2e24b6dc605d3967103a2b5beffa.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with appliances with stainless steel finishes, tasteful backsplash, light wood-type flooring, and white cabinetry" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T01:02:41.989Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6899413211b9342bd4d330ac" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/d07f98dd89d288c9113e2e281b2ec074.webp" "MediaSize" => 50528 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-d07f98dd89d288c9113e2e281b2ec074.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring stainless steel electric range oven, black microwave, backsplash, white cabinets, and light countertops" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.989Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6899413211b9342bd4d330ad" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/a50739f21924fcd2c10c69edafcdf9d1.webp" "MediaSize" => 72733 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-a50739f21924fcd2c10c69edafcdf9d1.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Bedroom featuring wood finished floors and radiator heating unit" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-08-11T01:02:42.020Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6899413211b9342bd4d330ae" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/2639b98eebcc08116d3e20eeffdf2253.webp" "MediaSize" => 49137 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-2639b98eebcc08116d3e20eeffdf2253.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Bedroom with wood finished floors and baseboards" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.995Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6899413211b9342bd4d330af" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/11c2531c3e31630f711792a5c6d94058.webp" "MediaSize" => 41231 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-11c2531c3e31630f711792a5c6d94058.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "View of carpeted bedroom" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:42.066Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6899413211b9342bd4d330b0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/bfead9509048d9524bdbc7427fd78f7e.webp" "MediaSize" => 46139 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-bfead9509048d9524bdbc7427fd78f7e.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Hall with an upstairs landing, light wood-style flooring, and radiator" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.985Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6899413211b9342bd4d330b1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/7ca635289cf5a106bad484f482c874f7.webp" "MediaSize" => 47261 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-7ca635289cf5a106bad484f482c874f7.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Staircase with wood finished floors and baseboards" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.990Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "6899413211b9342bd4d330b2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/6134c92d505ef8691257ebbd327b2f7a.webp" "MediaSize" => 38932 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-6134c92d505ef8691257ebbd327b2f7a.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Office space with radiator heating unit and light wood-style flooring" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.989Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "6899413211b9342bd4d330b3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/45ef403ba4efe3a30a40dad2135768ff.webp" "MediaSize" => 39204 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-45ef403ba4efe3a30a40dad2135768ff.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Office space featuring radiator heating unit and light wood finished floors" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.992Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "6899413211b9342bd4d330b4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/bbf1d9877d611db6e3f9681e0f8d5e3f.webp" "MediaSize" => 44977 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-bbf1d9877d611db6e3f9681e0f8d5e3f.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Full bathroom featuring vanity and curtained shower" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:41.987Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "6899413211b9342bd4d330b5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/6ba1e93d3e49e86a197645e26a35c845.webp" "MediaSize" => 48732 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS204078313/thumbnail-6ba1e93d3e49e86a197645e26a35c845.webp" "ImageWidth" => 720 "ImageHeight" => 480 "MediaCategory" => "Photo" "LongDescription" => "Full bathroom featuring shower / bathtub combination with curtain" "ImageSizeDescription" => "720x480" "MediaModificationTimestamp" => "2025-08-11T01:02:42.006Z" ] ] +"ID": "26539" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.16 seconds" ] ]