Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:1 [ "RF Cache Key: 20ff63b20bd5c0fd797234ff3ceef61deeb2534fa1fd3621d90ef220ec8d1dcb" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3757 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "608620" +"ListingId": "608620" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-29T19:04:50Z" +"RFModificationTimestamp": "2025-06-29T19:08:53.140982+00:00" +"ListPrice": 359900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.15 +"LivingArea": 2833.0 +"BuildingAreaTotal": 2833.0 +"City": "West Columbia" +"PostalCode": "29170" +"UnparsedAddress": "190 Turnfield Drive, West Columbia, SC 29170" +"Coordinates": array:2 [ 0 => -81.159434 1 => 33.91285 ] +"Latitude": 33.91285 +"Longitude": -81.159434 +"YearBuilt": 2019 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Home Advantage Realty" +"ListAgentMlsId": "12195" +"ListOfficeMlsId": "1335" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Immaculate 5 bedroom 3 full bathroom home that has a nice open concept kitchen with a huge island, gas stove and oven, coffee bar with cabinetry and a butlers pantry leading into the formal dining room. The floors are gleaming throughout the downstairs and the stairs, carpet in the bedrooms and upstairs. The Owner’s Suite upstairs has 2 walk-in closets and a bathroom with double vanities, tub and separate shower. Nice quiet neighborhood conveniently located in West Columbia close to the airport, and minutes from Columbia or Lexington. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Dryer,Gas Water Heater,Refrigerator,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Brick-Partial-AbvFound,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-05-15T01:06:11.094586+00:00" +"Directions": "Platt Springs to Ramblin Rd Left on Turnfield" +"Fencing": "Partial,Privacy Fence" +"Heating": "Central" +"InteriorFeatures": "Attic Access,Security System-Owned" +"LaundryFeatures": "Electric,Gas,Heated Space" +"ListAgentEmail": "loveschomes@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OpenParkingSpaces": "4" +"OriginalEntryTimestamp": "2025-05-14" +"PhotosChangeTimestamp": "2025-06-29T19:04:50Z" +"PhotosCount": "27" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Nook,Pantry,Counter Tops-Granite,Cabinets-Stained,Floors-Vinyl,Recessed Lights" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Turnfield" +"StreetNumber": "190" +"StreetSuffix": "Drive" +"SubdivisionName": "FIELD CREST" +"WaterSource": "Public" +"Baths Full": "3" +"2nd Bedroom": "Bath-Shared,Ceiling Fan,Floors - Carpet" +"Miscellaneous": "Cable,Security Cameras" +"Address": "190 Turnfield Drive" +"Assn Fee": "250" +"Assoc Fee Includes": "Common Area Maintenance,Green Areas,Street Light Maintenance" +"New/Resale": "Resale" +"# of Stories": "2" +"Baths": "3" +"LO1Office Identifier": "1335" +"Power On": "Yes" +"LO1Main Office ID": "182" +"Level-Kitchen": "Main" +"Half Baths-Main": "0" +"Full Baths-Main": "1" +"Price Per SQFT": "127.04" +"LO1Office Abbreviation": "HOMA02" +"Range": "Double Oven,Gas" +"High School": "Airport" +"Level-Formal Dining Room": "Main" +"Agent Hit Count": "80" +"Garage Spaces": "2" +"Level-Washer Dryer": "Second" +"Green Construction": "Energy Star" +"LA1User Code": "PENWARDK" +"Avail Financing": "Cash,Conventional,FHA,VA" +"LA1Agent First Name": "Kristina" +"Baths Combo": "3 / 0" +"Garage Level": "Main" +"Address Search Number": "190" +"Level-Master Bedroom": "Second" +"School District": "Lexington Two" +"LVT Date": "2025-05-14" +"Middle School": "Fulmer" +"3rd Bedroom": "Bath-Private,Ceiling Fan,Closet-Private,Floors - Carpet" +"Interior # of Fireplaces": "1" +"Status Detail": "0" +"Master Bedroom": "Tub-Garden,Bath-Private,Separate Shower,Ceilings-High (over 9 Ft),Ceiling Fan,Floors - Carpet" +"Other Heated SqFt": "0" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "RE_1" +"4th Bedroom": "Bath-Shared,Ceiling Fan,Closet-Private,Floors - Carpet" +"Short Sale Y/N": "No" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"Rollback Tax (Y/N)": "Yes" +"IDX Include": "Yes" +"Level-Bedroom 2": "Second" +"List Price Tot SqFt": "127.04" +"Full Baths-2nd": "2" +"Elementary School": "Springdale" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-05-15T01:30:49.7" +"Level-Bedroom 5": "Main" +"Garage": "Garage Attached, Front Entry" +"LA1Agent Last Name": "Penwarden" +"Living Room": "Fireplace,Floors-Hardwood,Ceilings-High (over 9 Ft),Ceiling Fan" +"Assn/Regime Fee Per": "Yearly" +"TMS": "007737-01-021" +"5th Bedroom": "Bath-Shared,Tub-Shower,Ceiling Fan,Closet-Private,Floors - Carpet" +"Formal Dining Room": "Floors-Hardwood,Butlers Pantry" +"Geo Update Timestamp": "2025-05-15T01:01:59.8" +"Foreclosed Property": "No" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:27 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6086200" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/c9b09b09db28caf8071595fd8a8879b8.webp" "MediaSize" => 589883 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-c9b09b09db28caf8071595fd8a8879b8.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6086201" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/66ad905343649346af45383168c20cf5.webp" "MediaSize" => 637116 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-66ad905343649346af45383168c20cf5.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6086202" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/90b3201ad1159342994e80c084297d2a.webp" "MediaSize" => 255708 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-90b3201ad1159342994e80c084297d2a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6086203" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/0d93a588581984efeeef61c8d6b88485.webp" "MediaSize" => 315435 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-0d93a588581984efeeef61c8d6b88485.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6086204" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/ea6ce137724781da9dcee801a425e4b2.webp" "MediaSize" => 173650 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-ea6ce137724781da9dcee801a425e4b2.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6086205" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/af3541e3883e3b9f06aeef0bae64fd98.webp" "MediaSize" => 214012 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-af3541e3883e3b9f06aeef0bae64fd98.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6086206" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/5c37d0d12d469e374dc53ce0922010e9.webp" "MediaSize" => 289956 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-5c37d0d12d469e374dc53ce0922010e9.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6086207" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/d62fce749bc6873e25539b2a00e29d78.webp" "MediaSize" => 349915 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-d62fce749bc6873e25539b2a00e29d78.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6086208" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/3a1d0b3de6f188349bf9338c3d2b2f2c.webp" "MediaSize" => 244523 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-3a1d0b3de6f188349bf9338c3d2b2f2c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6086209" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/6cc892e5a0d2faa7f6b1eef84b46971a.webp" "MediaSize" => 245345 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-6cc892e5a0d2faa7f6b1eef84b46971a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "60862010" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/c420e82b4686b8b7226872103489b2be.webp" "MediaSize" => 331742 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-c420e82b4686b8b7226872103489b2be.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "60862011" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/41fbd3d8d80784e5cce54bf8b4647090.webp" "MediaSize" => 284356 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-41fbd3d8d80784e5cce54bf8b4647090.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "60862012" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/ebef8264e91acebb3eeebbc762937e33.webp" "MediaSize" => 312479 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-ebef8264e91acebb3eeebbc762937e33.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "60862013" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/02d53a345be1d6a8aa6cf77f9678626a.webp" "MediaSize" => 281737 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-02d53a345be1d6a8aa6cf77f9678626a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "60862014" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/7e39cbe374de3089c9167f87243b0b59.webp" "MediaSize" => 208939 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-7e39cbe374de3089c9167f87243b0b59.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "60862015" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/890eba5a10c33b7eb21c32a1d901161d.webp" "MediaSize" => 221429 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-890eba5a10c33b7eb21c32a1d901161d.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "60862016" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/638977f13526cf5ce36f303190634c61.webp" "MediaSize" => 122270 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-638977f13526cf5ce36f303190634c61.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "60862017" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/235192069027351f22a7c9be87fa0fe7.webp" "MediaSize" => 275707 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-235192069027351f22a7c9be87fa0fe7.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "60862018" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/c67f3549707d57f6bfcb635d13bef58f.webp" "MediaSize" => 241529 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-c67f3549707d57f6bfcb635d13bef58f.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "60862019" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/3cd28b51b6e9495aa1a6ce7162fde9ff.webp" "MediaSize" => 180302 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-3cd28b51b6e9495aa1a6ce7162fde9ff.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "60862020" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/53b2ab237181bf554b6d1b8d30158390.webp" "MediaSize" => 135868 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-53b2ab237181bf554b6d1b8d30158390.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "60862021" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/48d4320105a747fc7b093a5f6af75653.webp" "MediaSize" => 173707 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-48d4320105a747fc7b093a5f6af75653.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "60862022" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/7b42b1f366cf83e1fd5f6edf616e7973.webp" "MediaSize" => 211612 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-7b42b1f366cf83e1fd5f6edf616e7973.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "60862023" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/7aac3de943d7daf767e6763f8519d648.webp" "MediaSize" => 187807 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-7aac3de943d7daf767e6763f8519d648.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 24 => array:11 [ "Order" => 24 "MediaKey" => "60862024" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/cc8be27e03cf9bd2cc976dc140fb9361.webp" "MediaSize" => 284981 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-cc8be27e03cf9bd2cc976dc140fb9361.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 25 => array:11 [ "Order" => 25 "MediaKey" => "60862025" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/74f19e0934a5bd6d486456bb169cf03c.webp" "MediaSize" => 154632 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-74f19e0934a5bd6d486456bb169cf03c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 26 => array:11 [ "Order" => 26 "MediaKey" => "60862026" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/608620/132fac1bf2516d2a1b9560aecbb78eae.webp" "MediaSize" => 806536 "ResourceRecordKey" => "608620" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/608620/thumbnail-132fac1bf2516d2a1b9560aecbb78eae.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('608620')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } ] ]
