Why rent, when you can own this home. Charming Upper-Level Condominium with Private Balcony is an added bonus to this community
Welcome to your new sanctuary in the heart of Mehlville! This spacious upper-level condominium offers the perfect blend of comfort and convenience. Enjoy the modern kitchen with a stylish breakfast bar, ideal for casual dining or morning coffee. The inviting dining room and living room provide ample space for entertaining and relaxation, featuring updated flooring that adds a touch of elegance throughout.
Retreat to the expansive primary bedroom, complete with its own private balcony where you can unwind and soak in the views. With close proximity to shopping and dining, plus the highly regarded Mehlville schools, this condo is perfect for those seeking a vibrant maintenance free lifestyle, I mean who doesn’t despise yard work ;). Don’t miss out on this incredible opportunity to make this charming condominium your new home!
Schedule your tour today!
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835 +post_id: "16703" +post_author: 1 +"ListingKey": "MIS203116411" +"ListingId": "25033338" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T14:29:38Z" +"RFModificationTimestamp": "2025-06-16T14:31:33.998129+00:00" +"ListPrice": 67999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 810.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63125" +"UnparsedAddress": "1677 Herault Place Unit H, St Louis, Missouri 63125" +"Coordinates": array:2 [ 0 => -90.288681 1 => 38.527452 ] +"Latitude": 38.527452 +"Longitude": -90.288681 +"YearBuilt": 1969 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Holly Kennedy" +"ListOfficeName": "Exit Elite Realty" +"ListAgentMlsId": "HKENNEDY" +"ListOfficeMlsId": "EXER01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Why rent, when you can own this home. Charming Upper-Level Condominium with Private Balcony is an added bonus to this community\n Welcome to your new sanctuary in the heart of Mehlville! This spacious upper-level condominium offers the perfect blend of comfort and convenience. Enjoy the modern kitchen with a stylish breakfast bar, ideal for casual dining or morning coffee. The inviting dining room and living room provide ample space for entertaining and relaxation, featuring updated flooring that adds a touch of elegance throughout.\n Retreat to the expansive primary bedroom, complete with its own private balcony where you can unwind and soak in the views. With close proximity to shopping and dining, plus the highly regarded Mehlville schools, this condo is perfect for those seeking a vibrant maintenance free lifestyle, I mean who doesn't despise yard work ;). Don’t miss out on this incredible opportunity to make this charming condominium your new home!\n \n Schedule your tour today! """ +"AboveGradeFinishedArea": 810 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:5 [ 0 => "Dishwasher" 1 => "Microwave" 2 => "Electric Oven" 3 => "Electric Range" 4 => "Water Heater" ] +"ArchitecturalStyle": array:1 [ 0 => "Apartment Style" ] +"AssociationAmenities": "Association Management" +"AssociationFee": "360" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:13 [ 0 => "Clubhouse" 1 => "Insurance" 2 => "Maintenance Grounds" 3 => "Maintenance Parking/Roads" 4 => "Repairs" 5 => "Common Area Maintenance" 6 => "Exterior Maintenance" 7 => "Pool Maintenance" 8 => "Management" 9 => "Pool" 10 => "Sewer" 11 => "Trash" 12 => "Water" ] +"AssociationYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:2 [ 0 => "Brick Veneer" 1 => "Vinyl Siding" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Electric" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-05-16T10:19:31.097117+00:00" +"CrossStreet": "Lemay Ferry" +"CumulativeDaysOnMarket": 31 +"DaysOnMarket": 32 +"DevelopmentStatus": array:1 [ 0 => "Completed" ] +"Disclosures": array:3 [ 0 => "Flood Plain No" 1 => "Lead Paint" 2 => "See Seller's Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-16T14:29:38Z" +"DocumentsCount": 3 +"ElementarySchool": "Forder Elem." +"Heating": array:2 [ 0 => "Baseboard" 1 => "Electric" ] +"HighSchool": "Mehlville High School" +"HighSchoolDistrict": "Mehlville R-IX" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "Southern Gateway Association of REALTORS" +"ListAgentAOR": "Southern Gateway Association of REALTORS" +"ListAgentKey": "4972747" +"ListOfficeAOR": "Southern Gateway Association of REALTORS" +"ListOfficeKey": "2067" +"ListOfficePhone": "636-464-3222" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,Other" +"LivingAreaSource": "Assessor" +"LotFeatures": array:1 [ 0 => "Adjoins Common Ground" ] +"LotSizeAcres": 0.043 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "331 - Mehlville" +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-16T14:29:24Z" +"MiddleOrJuniorSchool": "Margaret Buerkle Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfUnitsInCommunity": 342 +"OnMarketDate": "2025-05-16" +"OriginalEntryTimestamp": "2025-05-16T01:03:32Z" +"OriginalListPrice": 85000 +"OwnershipType": "Private" +"ParcelNumber": "27H-31-1077" +"PhotosChangeTimestamp": "2025-05-16T01:04:38Z" +"PhotosCount": 14 +"PoolFeatures": array:1 [ 0 => "In Ground" ] +"PreviousListPrice": 69900 +"PriceChangeTimestamp": "2025-06-16T14:29:24Z" +"PropertyAttachedYN": true +"RoomsTotal": "4" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactPhone": "3142558274" +"ShowingContactType": array:1 [ 0 => "Listing Agent" ] +"ShowingRequirements": array:5 [ 0 => "Appointment Only" 1 => "Combination Lock Box" 2 => "Occupied" 3 => "Pet(s) on Premises" 4 => "Text Listing Agent" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-05-16T06:30:30Z" +"StreetName": "Herault" +"StreetNumber": "1677" +"StreetNumberNumeric": "1677" +"StreetSuffix": "Place" +"SubdivisionName": "Parc Lorraine Condo Aka Parc" +"TaxAnnualAmount": "1101" +"TaxYear": "2024" +"Township": "Unincorporated" +"UnitNumber": "H" +"VirtualTourURLUnbranded": "https://listings.studio724photography.com/sites/jnjoxel/unbranded" +"WaterSource": array:1 [ 0 => "Public" ] +"YearBuiltSource": "Public Records" +"MIS_PoolYN": "1" +"MIS_Section": "UNINCORPORATED" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "4" +"MIS_CurrentPrice": "67999.00" +"MIS_EfficiencyYN": "0" +"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('MIS203116411')" +"provider_name": "MARIS" +"Media": array:14 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "68268eee00a23760a8cfe153" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/9ee5c3dfa24fa9cfb401a2cb1461857a.webp" "MediaSize" => 161859 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-9ee5c3dfa24fa9cfb401a2cb1461857a.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of property featuring mansard roof, brick siding, a front yard, and central AC unit" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.174Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "68268eee00a23760a8cfe154" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/3f9418b90cdd597842bd593242523fdb.webp" "MediaSize" => 75268 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-3f9418b90cdd597842bd593242523fdb.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Stairway featuring carpet floors and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.075Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "68268eee00a23760a8cfe155" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/e656781c727f40c467a9b1a24d49f391.webp" "MediaSize" => 59036 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-e656781c727f40c467a9b1a24d49f391.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of doorway to property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.120Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "68268eee00a23760a8cfe156" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/56b3c4aa2786a8ee8398a46f0ceafabb.webp" "MediaSize" => 75854 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-56b3c4aa2786a8ee8398a46f0ceafabb.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living room featuring wood finished floors and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.075Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "68268eee00a23760a8cfe157" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/b7b8e7474b2ec74f2fe017fafe2ddf92.webp" "MediaSize" => 90928 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-b7b8e7474b2ec74f2fe017fafe2ddf92.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living area featuring a ceiling fan, a baseboard heating unit, wood finished floors, an office area, and a textured ceiling" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.072Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "68268eee00a23760a8cfe158" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/b40fcc3749f2253ac1f99218a9485603.webp" "MediaSize" => 50962 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-b40fcc3749f2253ac1f99218a9485603.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living area with light wood finished floors and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.112Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "68268eee00a23760a8cfe159" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/4c35472bd614fc88e102957d79bfeee3.webp" "MediaSize" => 72317 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-4c35472bd614fc88e102957d79bfeee3.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with stainless steel appliances, a sink, under cabinet range hood, a baseboard heating unit, and light countertops" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.118Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "68268eee00a23760a8cfe15a" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/b601b5ec65d02dd5c6f088d7b82d26b8.webp" "MediaSize" => 65941 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-b601b5ec65d02dd5c6f088d7b82d26b8.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring appliances with stainless steel finishes, a sink, light countertops, and white cabinetry" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.134Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "68268eee00a23760a8cfe15b" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/3cc9df8a884d52e42a9936d06ea352dd.webp" "MediaSize" => 77718 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-3cc9df8a884d52e42a9936d06ea352dd.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Bedroom featuring light wood-style flooring, access to outside, and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.097Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "68268eee00a23760a8cfe15c" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/ff160ac36b15fd8c2ce809f34c099349.webp" "MediaSize" => 75541 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-ff160ac36b15fd8c2ce809f34c099349.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Bedroom featuring wood finished floors and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.062Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "68268eee00a23760a8cfe15d" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/d7a077baa7b70024ea456921186087a5.webp" "MediaSize" => 42338 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-d7a077baa7b70024ea456921186087a5.webp" "ImageWidth" => 512 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Full bath featuring baseboard heating, toilet, wood finished floors, wallpapered walls, and vanity" "ImageSizeDescription" => "512x768" "MediaModificationTimestamp" => "2025-05-16T01:03:42.177Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "68268eee00a23760a8cfe15e" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/d42a0f291d1c996f21cb3dbdb0abac81.webp" "MediaSize" => 33382 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-d42a0f291d1c996f21cb3dbdb0abac81.webp" "ImageWidth" => 512 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Full bath featuring baseboard heating, wood finished floors, toilet, vanity, and wallpapered walls" "ImageSizeDescription" => "512x768" "MediaModificationTimestamp" => "2025-05-16T01:03:42.080Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "68268eee00a23760a8cfe15f" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/d0e66aa7f45d865c67d90708ba5d5d70.webp" "MediaSize" => 67061 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-d0e66aa7f45d865c67d90708ba5d5d70.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with white dishwasher, a sink, stainless steel microwave, ceiling fan, and decorative backsplash" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.094Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "68268eee00a23760a8cfe160" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/b5756d91b3702148aaa992a791685834.webp" "MediaSize" => 139005 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-b5756d91b3702148aaa992a791685834.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of wooden terrace" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.122Z" ] ] +"ID": "16703" }
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 'MIS203116411'/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 'MIS203116411'&$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 'MIS203116411'/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 'MIS203116411'&$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: "16703" +post_author: 1 +"ListingKey": "MIS203116411" +"ListingId": "25033338" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-16T14:29:38Z" +"RFModificationTimestamp": "2025-06-16T14:31:33.998129+00:00" +"ListPrice": 67999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 810.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63125" +"UnparsedAddress": "1677 Herault Place Unit H, St Louis, Missouri 63125" +"Coordinates": array:2 [ 0 => -90.288681 1 => 38.527452 ] +"Latitude": 38.527452 +"Longitude": -90.288681 +"YearBuilt": 1969 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Holly Kennedy" +"ListOfficeName": "Exit Elite Realty" +"ListAgentMlsId": "HKENNEDY" +"ListOfficeMlsId": "EXER01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Why rent, when you can own this home. Charming Upper-Level Condominium with Private Balcony is an added bonus to this community\n Welcome to your new sanctuary in the heart of Mehlville! This spacious upper-level condominium offers the perfect blend of comfort and convenience. Enjoy the modern kitchen with a stylish breakfast bar, ideal for casual dining or morning coffee. The inviting dining room and living room provide ample space for entertaining and relaxation, featuring updated flooring that adds a touch of elegance throughout.\n Retreat to the expansive primary bedroom, complete with its own private balcony where you can unwind and soak in the views. With close proximity to shopping and dining, plus the highly regarded Mehlville schools, this condo is perfect for those seeking a vibrant maintenance free lifestyle, I mean who doesn't despise yard work ;). Don’t miss out on this incredible opportunity to make this charming condominium your new home!\n \n Schedule your tour today! """ +"AboveGradeFinishedArea": 810 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:5 [ 0 => "Dishwasher" 1 => "Microwave" 2 => "Electric Oven" 3 => "Electric Range" 4 => "Water Heater" ] +"ArchitecturalStyle": array:1 [ 0 => "Apartment Style" ] +"AssociationAmenities": "Association Management" +"AssociationFee": "360" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:13 [ 0 => "Clubhouse" 1 => "Insurance" 2 => "Maintenance Grounds" 3 => "Maintenance Parking/Roads" 4 => "Repairs" 5 => "Common Area Maintenance" 6 => "Exterior Maintenance" 7 => "Pool Maintenance" 8 => "Management" 9 => "Pool" 10 => "Sewer" 11 => "Trash" 12 => "Water" ] +"AssociationYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:2 [ 0 => "Brick Veneer" 1 => "Vinyl Siding" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Electric" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-05-16T10:19:31.097117+00:00" +"CrossStreet": "Lemay Ferry" +"CumulativeDaysOnMarket": 31 +"DaysOnMarket": 32 +"DevelopmentStatus": array:1 [ 0 => "Completed" ] +"Disclosures": array:3 [ 0 => "Flood Plain No" 1 => "Lead Paint" 2 => "See Seller's Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-16T14:29:38Z" +"DocumentsCount": 3 +"ElementarySchool": "Forder Elem." +"Heating": array:2 [ 0 => "Baseboard" 1 => "Electric" ] +"HighSchool": "Mehlville High School" +"HighSchoolDistrict": "Mehlville R-IX" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "Southern Gateway Association of REALTORS" +"ListAgentAOR": "Southern Gateway Association of REALTORS" +"ListAgentKey": "4972747" +"ListOfficeAOR": "Southern Gateway Association of REALTORS" +"ListOfficeKey": "2067" +"ListOfficePhone": "636-464-3222" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,Other" +"LivingAreaSource": "Assessor" +"LotFeatures": array:1 [ 0 => "Adjoins Common Ground" ] +"LotSizeAcres": 0.043 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "331 - Mehlville" +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2025-06-16T14:29:24Z" +"MiddleOrJuniorSchool": "Margaret Buerkle Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfUnitsInCommunity": 342 +"OnMarketDate": "2025-05-16" +"OriginalEntryTimestamp": "2025-05-16T01:03:32Z" +"OriginalListPrice": 85000 +"OwnershipType": "Private" +"ParcelNumber": "27H-31-1077" +"PhotosChangeTimestamp": "2025-05-16T01:04:38Z" +"PhotosCount": 14 +"PoolFeatures": array:1 [ 0 => "In Ground" ] +"PreviousListPrice": 69900 +"PriceChangeTimestamp": "2025-06-16T14:29:24Z" +"PropertyAttachedYN": true +"RoomsTotal": "4" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactPhone": "3142558274" +"ShowingContactType": array:1 [ 0 => "Listing Agent" ] +"ShowingRequirements": array:5 [ 0 => "Appointment Only" 1 => "Combination Lock Box" 2 => "Occupied" 3 => "Pet(s) on Premises" 4 => "Text Listing Agent" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-05-16T06:30:30Z" +"StreetName": "Herault" +"StreetNumber": "1677" +"StreetNumberNumeric": "1677" +"StreetSuffix": "Place" +"SubdivisionName": "Parc Lorraine Condo Aka Parc" +"TaxAnnualAmount": "1101" +"TaxYear": "2024" +"Township": "Unincorporated" +"UnitNumber": "H" +"VirtualTourURLUnbranded": "https://listings.studio724photography.com/sites/jnjoxel/unbranded" +"WaterSource": array:1 [ 0 => "Public" ] +"YearBuiltSource": "Public Records" +"MIS_PoolYN": "1" +"MIS_Section": "UNINCORPORATED" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "4" +"MIS_CurrentPrice": "67999.00" +"MIS_EfficiencyYN": "0" +"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('MIS203116411')" +"provider_name": "MARIS" +"Media": array:14 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "68268eee00a23760a8cfe153" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/9ee5c3dfa24fa9cfb401a2cb1461857a.webp" "MediaSize" => 161859 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-9ee5c3dfa24fa9cfb401a2cb1461857a.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of property featuring mansard roof, brick siding, a front yard, and central AC unit" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.174Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "68268eee00a23760a8cfe154" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/3f9418b90cdd597842bd593242523fdb.webp" "MediaSize" => 75268 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-3f9418b90cdd597842bd593242523fdb.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Stairway featuring carpet floors and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.075Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "68268eee00a23760a8cfe155" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/e656781c727f40c467a9b1a24d49f391.webp" "MediaSize" => 59036 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-e656781c727f40c467a9b1a24d49f391.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of doorway to property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.120Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "68268eee00a23760a8cfe156" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/56b3c4aa2786a8ee8398a46f0ceafabb.webp" "MediaSize" => 75854 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-56b3c4aa2786a8ee8398a46f0ceafabb.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living room featuring wood finished floors and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.075Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "68268eee00a23760a8cfe157" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/b7b8e7474b2ec74f2fe017fafe2ddf92.webp" "MediaSize" => 90928 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-b7b8e7474b2ec74f2fe017fafe2ddf92.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living area featuring a ceiling fan, a baseboard heating unit, wood finished floors, an office area, and a textured ceiling" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.072Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "68268eee00a23760a8cfe158" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/b40fcc3749f2253ac1f99218a9485603.webp" "MediaSize" => 50962 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-b40fcc3749f2253ac1f99218a9485603.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living area with light wood finished floors and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.112Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "68268eee00a23760a8cfe159" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/4c35472bd614fc88e102957d79bfeee3.webp" "MediaSize" => 72317 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-4c35472bd614fc88e102957d79bfeee3.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with stainless steel appliances, a sink, under cabinet range hood, a baseboard heating unit, and light countertops" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.118Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "68268eee00a23760a8cfe15a" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/b601b5ec65d02dd5c6f088d7b82d26b8.webp" "MediaSize" => 65941 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-b601b5ec65d02dd5c6f088d7b82d26b8.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring appliances with stainless steel finishes, a sink, light countertops, and white cabinetry" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.134Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "68268eee00a23760a8cfe15b" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/3cc9df8a884d52e42a9936d06ea352dd.webp" "MediaSize" => 77718 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-3cc9df8a884d52e42a9936d06ea352dd.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Bedroom featuring light wood-style flooring, access to outside, and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.097Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "68268eee00a23760a8cfe15c" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/ff160ac36b15fd8c2ce809f34c099349.webp" "MediaSize" => 75541 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-ff160ac36b15fd8c2ce809f34c099349.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Bedroom featuring wood finished floors and baseboards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.062Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "68268eee00a23760a8cfe15d" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/d7a077baa7b70024ea456921186087a5.webp" "MediaSize" => 42338 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-d7a077baa7b70024ea456921186087a5.webp" "ImageWidth" => 512 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Full bath featuring baseboard heating, toilet, wood finished floors, wallpapered walls, and vanity" "ImageSizeDescription" => "512x768" "MediaModificationTimestamp" => "2025-05-16T01:03:42.177Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "68268eee00a23760a8cfe15e" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/d42a0f291d1c996f21cb3dbdb0abac81.webp" "MediaSize" => 33382 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-d42a0f291d1c996f21cb3dbdb0abac81.webp" "ImageWidth" => 512 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Full bath featuring baseboard heating, wood finished floors, toilet, vanity, and wallpapered walls" "ImageSizeDescription" => "512x768" "MediaModificationTimestamp" => "2025-05-16T01:03:42.080Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "68268eee00a23760a8cfe15f" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/d0e66aa7f45d865c67d90708ba5d5d70.webp" "MediaSize" => 67061 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-d0e66aa7f45d865c67d90708ba5d5d70.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with white dishwasher, a sink, stainless steel microwave, ceiling fan, and decorative backsplash" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.094Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "68268eee00a23760a8cfe160" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/b5756d91b3702148aaa992a791685834.webp" "MediaSize" => 139005 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MIS203116411/thumbnail-b5756d91b3702148aaa992a791685834.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of wooden terrace" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-05-16T01:03:42.122Z" ] ] +"ID": "16703" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.19 seconds" ] ]