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: b35e71c004b47e824bd37cfe58f891b0caf791632f27407cc7647fa10a910283" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3737 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3190 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "590452" +"ListingId": "590452" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2024-11-05T19:01:20Z" +"RFModificationTimestamp": "2025-03-21T06:29:53.048366+00:00" +"ListPrice": 270000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.27 +"LivingArea": 1329.0 +"BuildingAreaTotal": 1329.0 +"City": "Columbia" +"PostalCode": "29204" +"UnparsedAddress": "2405 Barhamvillie Road, Columbia, Sc 29204" +"Coordinates": array:2 [ 0 => -81.016289 1 => 34.026883 ] +"Latitude": 34.026883 +"Longitude": -81.016289 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "JS Premier Real Estate LLC" +"ListAgentMlsId": "13703" +"ListOfficeMlsId": "1693" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Stunning California-Style Contemporary Home in the Barhamville Community.Experience modern luxury in the heart of Columbia with this proposed new construction California-style contemporary home. Boasting 1,329 sqft of thoughtfully designed living space, this 3-bedroom, 2-bathroom gem offers an array of upscale features and customizable upgrades. Some key features about this amazing home enjoy abundant natural light through the grand 10ft front windows, brightening up the entire home.Gourmet Kitchen quartz countertops and stainless steel appliances make cooking a pleasure.Stylish Flooring luxury vinyl flooring throughout adds a touch of sophistication and durability.Comfortable Bedrooms All three bedrooms are spacious and come equipped with ceiling fans for optimal comfort.Outdoor oasis A full deck overlooks a beautifully landscaped backyard, perfect for relaxing and entertaining. Homes builder’s warranty peace of mind with a comprehensive builder’s warranty included.This home offers an opportunity to customize further to your taste. Don’t miss out on this exceptional property in one of Columbia’s most desirable communities.**Act Now!** Contact us today to learn more and secure this incredible home before it's gone.**Estimated Completion:** March,2025, This is in a prime location near colleges & universities. "The photos shown feature the upgraded version of this model. For details on the basic finishes, please consult the listing agent."" +"Appliances": "Dishwasher,Disposal,Refrigerator" +"ArchitecturalStyle": "Contemporary" +"AssociationYN": false +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-03-21T06:29:52.859242+00:00" +"Directions": "From Main St Columbia, Turn R onto Lady St, Turn L onto Sumter St, Turn R onto Taylor St, Turn L onto Two Notch, Turn L onto Tremain, Turn R onto Barhamville." +"ExteriorFeatures": "Front Porch - Covered" +"Heating": "Central" +"InteriorFeatures": "Ceiling Fan,Garage Opener,Smoke Detector,Attic Access" +"LaundryFeatures": "Electric" +"ListAgentEmail": "jspremierrealestate@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2024-07-31" +"PhotosChangeTimestamp": "2024-11-05T19:01:20Z" +"PhotosCount": "19" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Cabinets-Stained,Backsplash-Tiled,Counter Tops-Quartz" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Barhamvillie" +"StreetNumber": "2405" +"StreetSuffix": "Road" +"SubdivisionName": "BARHAMVILLE" +"WaterSource": "Public" +"TMS": "11507-03-10" +"Baths": "2" +"Garage": "Carport Attached" +"Address": "2405 Barhamvillie Road" +"LVT Date": "2024-07-31" +"Power On": "No" +"Baths Full": "2" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Ceiling Fan" +"3rd Bedroom": "Ceiling Fan" +"Baths Combo": "2 / 0" +"High School": "Eau Claire" +"IDX Include": "Yes" +"Living Room": "Ceiling Fan" +"# of Stories": "1" +"Garage Level": "Main" +"LA1User Code": "SINGLETJ" +"Garage Spaces": "1" +"Level-Kitchen": "Main" +"Middle School": "Perry" +"Miscellaneous": "Warranty (New Const) Bldr" +"Status Detail": "0" +"Master Bedroom": "Closet-His & Her,Separate Shower,Ceiling Fan,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "203.16" +"Short Sale Y/N": "No" +"Agent Hit Count": "215" +"Avail Financing": "Cash,Conventional,FHA,VA" +"Full Baths-Main": "2" +"Geo Subdivision": "SC" +"Half Baths-Main": "0" +"Level-Bedroom 2": "Main" +"Level-Bedroom 3": "Main" +"School District": "Richland One" +"Elementary School": "Watkins" +"LO1Main Office ID": "1693" +"Level-Living Room": "Main" +"Other Heated SqFt": "0" +"Senior Living Y/N": "N" +"Formal Dining Room": "Butlers Pantry,Ceiling Fan,Floors-Luxury Vinyl Plank" +"LA1Agent Last Name": "Singletary" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Detitled Mobile Y/N": "N" +"Foreclosed Property": "No" +"LA1Agent First Name": "Justin" +"List Price Tot SqFt": "203.16" +"Geo Update Timestamp": "2024-08-01T01:11:45.4" +"LO1Office Identifier": "1693" +"Level-Master Bedroom": "Main" +"Address Search Number": "2405" +"LO1Office Abbreviation": "JSPR01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2024-08-01T01:20:14.9" +"MlsAreaMajor": "City of Columbia, Denny terrace, Lake Elizabeth" +"PrivatePoolYN": "No" +"Media": array:19 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "5904520" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/ca5f81dd22fcfde985d6f8a3de554073.webp" "ClassName" => "Single Family" "MediaSize" => 1140516 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-ca5f81dd22fcfde985d6f8a3de554073.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "5904521" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/fb888df0733e608374dff961e9103177.webp" "ClassName" => "Single Family" "MediaSize" => 275217 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-fb888df0733e608374dff961e9103177.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "5904522" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/af0319ca4514445bb3d0eb87ef9f3139.webp" "ClassName" => "Single Family" "MediaSize" => 275527 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-af0319ca4514445bb3d0eb87ef9f3139.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "5904523" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/406527c2a344b9bcfdd94d1a178989db.webp" "ClassName" => "Single Family" "MediaSize" => 578126 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-406527c2a344b9bcfdd94d1a178989db.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "5904524" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/b6509d8f868198b621bc109632ba2ea5.webp" "ClassName" => "Single Family" "MediaSize" => 674727 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-b6509d8f868198b621bc109632ba2ea5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "5904525" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/2a23d742602e327b45b1739f828e9cb7.webp" "ClassName" => "Single Family" "MediaSize" => 448641 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-2a23d742602e327b45b1739f828e9cb7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "5904526" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/acfe5c393758fa8982657cae72d5df1c.webp" "ClassName" => "Single Family" "MediaSize" => 401111 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-acfe5c393758fa8982657cae72d5df1c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "5904527" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/9cd4bf1b6d327dea2a8f7aa566dc7b18.webp" "ClassName" => "Single Family" "MediaSize" => 577987 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-9cd4bf1b6d327dea2a8f7aa566dc7b18.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "5904528" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/5b8c4a98ccf0e3db6cd5460422fdcc08.webp" "ClassName" => "Single Family" "MediaSize" => 587491 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-5b8c4a98ccf0e3db6cd5460422fdcc08.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "5904529" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/e27ced95c9bc1577a9bf890c070e6f76.webp" "ClassName" => "Single Family" "MediaSize" => 399011 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-e27ced95c9bc1577a9bf890c070e6f76.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "59045210" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/653b5e2d91ea7bd48e21dbcd434ac97e.webp" "ClassName" => "Single Family" "MediaSize" => 140903 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-653b5e2d91ea7bd48e21dbcd434ac97e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "59045211" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/3a8b32730bb32622ed7156da49d12a3d.webp" "ClassName" => "Single Family" "MediaSize" => 358050 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-3a8b32730bb32622ed7156da49d12a3d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "59045212" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/9b81403a12074383dd075b530537e42b.webp" "ClassName" => "Single Family" "MediaSize" => 353220 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-9b81403a12074383dd075b530537e42b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "59045213" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/a418ad6284b0517ef1c3fb5073c857ac.webp" "ClassName" => "Single Family" "MediaSize" => 432547 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-a418ad6284b0517ef1c3fb5073c857ac.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "59045214" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/fcde0b595e2296020410c1d9b96c00c3.webp" "ClassName" => "Single Family" "MediaSize" => 696128 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-fcde0b595e2296020410c1d9b96c00c3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "59045215" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/1514482c783bb648c1dc7bc5b7f14f2a.webp" "ClassName" => "Single Family" "MediaSize" => 825064 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-1514482c783bb648c1dc7bc5b7f14f2a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "59045216" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/66534993b733fe7479dd48f72755795d.webp" "ClassName" => "Single Family" "MediaSize" => 1157631 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-66534993b733fe7479dd48f72755795d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "59045217" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/c1219e2e42342b1aedae1bdb4873180c.webp" "ClassName" => "Single Family" "MediaSize" => 1155340 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-c1219e2e42342b1aedae1bdb4873180c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "59045218" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/9413ce65ad654f1ee4ff759836f7bc8d.webp" "ClassName" => "Single Family" "MediaSize" => 1103484 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/121/590452/thumbnail-9413ce65ad654f1ee4ff759836f7bc8d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "590452" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('590452')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } ] ]
