FAIRFIELD TERRACE
3 Properties
Sort by:
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: 2875cc7e6d119f762d231ba69dd35f6c177b624e988574b827fafb616c508bdc" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3770 +items: array:3 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "605086" +"ListingId": "605086" +"PropertyType": "Land" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-09-03T20:49:08Z" +"RFModificationTimestamp": "2025-09-03T20:55:30Z" +"ListPrice": 27000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.9 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Columbia" +"PostalCode": "29203" +"UnparsedAddress": "W S Wakefield Rd, Columbia, Sc 29203" +"Coordinates": array:2 [ 0 => -81.0199 1 => 34.0689 ] +"Latitude": 34.0689 +"Longitude": -81.0199 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "United Real Estate SC" +"ListAgentMlsId": "11445" +"ListOfficeMlsId": "946" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Build your dream home on this wooded lot located off Wakefield. Easy access to I-20. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"AssociationYN": false +"BuildingAreaUnits": "Sqft" +"CountyOrParish": "Richland" +"CreationDate": "2025-03-28T03:05:11.136581+00:00" +"Directions": "Wakefield Rd across from the power of Grace Church" +"ListAgentEmail": "ajoyner723@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-03-27" +"PhotosChangeTimestamp": "2025-09-03T20:49:08Z" +"PhotosCount": "4" +"RoadFrontageType": "City" +"RoadSurfaceType": "Paved" +"Sewer": "Available,Public" +"StateOrProvince": "SC" +"StreetName": "W S Wakefield RD" +"SubdivisionName": "FAIRFIELD TERRACE" +"WaterSource": "Available,Public" +"TMS": "11807-04-06" +"Address": "W S Wakefield RD" +"LVT Date": "2025-03-27" +"class_name": "LD_2" +"High School": "Keenan High" +"LA1User Code": "GASSAWAY" +"Unit #/Lot #": "7-9, 21" +"Middle School": "Alcorn" +"Agent Hit Count": "102" +"School District": "Richland One" +"Elementary School": "John P. Thomas" +"LO1Main Office ID": "946" +"LA1Agent Last Name": "Gassaway" +"Rollback Tax (Y/N)": "No" +"LA1Agent First Name": "Adrianna" +"Geo Update Timestamp": "2025-03-28T02:55:49.3" +"LO1Office Identifier": "946" +"LO1Office Abbreviation": "REGA01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-03-28T02:55:50.4" +"Media": array:4 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6050860" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605086/afacf32030b32fda7cc7e7f9f756acc8.webp" "ClassName" => null "MediaSize" => 1453975 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605086/thumbnail-afacf32030b32fda7cc7e7f9f756acc8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "605086" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6050861" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605086/c4098f2c9aeeddb320a4c28841ba316d.webp" "ClassName" => null "MediaSize" => 1439093 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605086/thumbnail-c4098f2c9aeeddb320a4c28841ba316d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "605086" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6050862" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605086/6759009a13a106c2d287d49cd545e5ba.webp" "ClassName" => null "MediaSize" => 1150969 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605086/thumbnail-6759009a13a106c2d287d49cd545e5ba.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "605086" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6050863" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605086/d6505ffa5a3e43ba43e7362b194437f6.webp" "ClassName" => null "MediaSize" => 1376371 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605086/thumbnail-d6505ffa5a3e43ba43e7362b194437f6.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "605086" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('605086')" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3209 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "611330" +"ListingId": "611330" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-26T18:13:22Z" +"RFModificationTimestamp": "2025-08-26T18:15:39Z" +"ListPrice": 29000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.38 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Columbia" +"PostalCode": "29203" +"UnparsedAddress": "305 Bertha Avenue, Columbia, SC 29203" +"Coordinates": array:2 [ 0 => -81.017471 1 => 34.071752 ] +"Latitude": 34.071752 +"Longitude": -81.017471 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "South Strand Group" +"ListAgentMlsId": "11692" +"ListOfficeMlsId": "1673" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Excellent Lot Just Hit The Market with Access to Public Utilities Located on a Paved Road Right off of I-20! This .38 acre lot is ideal for any builder or future home owner to come on in and start designing your future custom single family home (must be stick built or modular) with direct access off a nicely paved street with direct street frontage access for an entire 100 feet across the front of the lot! Water and Sewer serviced by City of Columbia preventing a costly septic/well installation, this lot is ready to go with convenient public utilities just a phone call away! This property offers several gorgeous mature trees for plenty of desirable shade. Nestled in a quiet, established neighborhood with both brick homes and new builds on surrounding streets for tons of potential growth and development potential, with easy and convenient access to I-20 located right off of Exit 70 for Fairfield Rd, this lot will not last long! Drive on out to take a look 305 Berth Ave and see it for yourself! Recent Survey just completed and Stakes are still visible from the road for an easy driveway visualization. Small stream located in the setbacks of the back portion of the property! Title insurance can not be obtained at the time of purchase but is available after a Quiet Title action due to previous tax sale history in previous ownership. Seller related to Agent. Seller Financing Available! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"AssociationYN": false +"BuildingAreaUnits": "Sqft" +"CountyOrParish": "Richland" +"CreationDate": "2025-08-18T20:59:35.466079+00:00" +"Directions": "Left off Exit 70 for Fairfield Rd, Make the First Right, then second left, and right onto Bertha. Mailbox is about 35 feet in from left property boundary line." +"ListAgentEmail": "britt@southstrandliving.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2025-06-20" +"PhotosChangeTimestamp": "2025-07-04T22:58:50Z" +"PhotosCount": "5" +"RoadFrontageType": "City,County,State" +"RoadSurfaceType": "Paved" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Bertha" +"StreetNumber": "305" +"StreetSuffix": "Avenue" +"SubdivisionName": "FAIRFIELD TERRACE" +"WaterSource": "Public" +"TMS": "11806-03-12" +"Address": "305 Bertha Avenue" +"LVT Date": "2025-06-20" +"class_name": "LD_2" +"LA1User Code": "MINOGUEB" +"Agent Hit Count": "31" +"Avail Financing": "Cash,Owner,Lease Purchase" +"Geo Subdivision": "SC" +"School District": "Richland Two" +"LO1Main Office ID": "1673" +"LA1Agent Last Name": "Grace" +"Rollback Tax (Y/N)": "Unknown" +"LA1Agent First Name": "Brittany" +"Geo Update Timestamp": "2025-06-20T17:17:58.6" +"LO1Office Identifier": "1673" +"Address Search Number": "305" +"LO1Office Abbreviation": "SSGR01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-06-20T17:17:59.1" +"Media": array:5 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6113300" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611330/e1442833a6280ee437655412fc77ac57.webp" "ClassName" => null "MediaSize" => 1556416 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611330/thumbnail-e1442833a6280ee437655412fc77ac57.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611330" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6113301" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611330/65d5b1fe217c8aad7add385fa444d91c.webp" "ClassName" => null "MediaSize" => 1650058 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611330/thumbnail-65d5b1fe217c8aad7add385fa444d91c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611330" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6113302" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611330/8293c1294ded40364a3f1b0ff0050fb8.webp" "ClassName" => null "MediaSize" => 1379272 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611330/thumbnail-8293c1294ded40364a3f1b0ff0050fb8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611330" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6113303" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611330/69033f8bc71b74f36f313198f3762042.webp" "ClassName" => null "MediaSize" => 1424799 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611330/thumbnail-69033f8bc71b74f36f313198f3762042.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611330" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6113304" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611330/6991376176c8b0207cfe08c6a00c5f7f.webp" "ClassName" => null "MediaSize" => 1505313 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611330/thumbnail-6991376176c8b0207cfe08c6a00c5f7f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611330" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('611330')" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3207 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "605083" +"ListingId": "605083" +"PropertyType": "Land" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-04-30T01:41:14Z" +"RFModificationTimestamp": "2025-04-30T01:49:45Z" +"ListPrice": 22000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.48 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Columbia" +"PostalCode": "29203" +"UnparsedAddress": "Jerome Dr, Columbia, Sc 29203" +"Coordinates": array:2 [ 0 => -81.0199 1 => 34.0689 ] +"Latitude": 34.0689 +"Longitude": -81.0199 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "United Real Estate SC" +"ListAgentMlsId": "11445" +"ListOfficeMlsId": "946" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Build your dream home on this wooded lot located on Wakefield Rd. Easy access to I-20 Disclaimer: CMLS has not reviewed and, therefore does not endorse vendors who may appear in listings. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"AssociationYN": false +"BuildingAreaUnits": "Sqft" +"CountyOrParish": "Richland" +"CreationDate": "2025-03-28T02:33:03.770168+00:00" +"Directions": "Wakefield Rd and Fairfield" +"ListAgentEmail": "ajoyner723@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-03-27" +"PhotosChangeTimestamp": "2025-04-30T01:41:14Z" +"PhotosCount": "4" +"RoadFrontageType": "County" +"RoadSurfaceType": "Paved" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Jerome Dr" +"SubdivisionName": "FAIRFIELD TERRACE" +"WaterSource": "Available,Public" +"Rollback Tax (Y/N)": "No" +"Address": "Jerome Dr" +"LO1Office Abbreviation": "REGA01" +"School District": "Richland One" +"Elementary School": "John P. Thomas" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-03-28T02:25:51.3" +"LVT Date": "2025-03-27" +"High School": "Keenan High" +"Middle School": "Alcorn" +"# of Lots Remaining": "5" +"Agent Hit Count": "22" +"LA1Agent Last Name": "Gassaway" +"LO1Office Identifier": "946" +"Unit #/Lot #": "23-25" +"LA1User Code": "GASSAWAY" +"Listing Type Agreement": "Exclusive Right to Sell" +"TMS": "11807-04-21" +"LA1Agent First Name": "Adrianna" +"class_name": "LD_2" +"LO1Main Office ID": "946" +"Geo Update Timestamp": "2025-03-28T02:25:50.4" +"Media": array:4 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6050830" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605083/ce0316f2031396b09547772c15d4fd52.webp" "MediaSize" => 1376371 "ResourceRecordKey" => "605083" "ResourceName" => "Property" "ClassName" => null "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605083/thumbnail-ce0316f2031396b09547772c15d4fd52.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6050831" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605083/709f7598118964962400d3cb02b6a1c7.webp" "MediaSize" => 1150969 "ResourceRecordKey" => "605083" "ResourceName" => "Property" "ClassName" => null "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605083/thumbnail-709f7598118964962400d3cb02b6a1c7.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6050832" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605083/fddc5c69e075201c4524e4bd265d627e.webp" "MediaSize" => 1453975 "ResourceRecordKey" => "605083" "ResourceName" => "Property" "ClassName" => null "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605083/thumbnail-fddc5c69e075201c4524e4bd265d627e.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6050833" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605083/5250f6a2d7a7252f3412602cc5fa3d5e.webp" "MediaSize" => 1439093 "ResourceRecordKey" => "605083" "ResourceName" => "Property" "ClassName" => null "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605083/thumbnail-5250f6a2d7a7252f3412602cc5fa3d5e.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('605083')" } ] +success: true +page_size: 3 +page_count: 1 +count: 3 +after_key: "" } ] ]
