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 {#3754 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "619349" +"ListingId": "619349" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-11T01:46:03Z" +"RFModificationTimestamp": "2025-10-11T01:55:16Z" +"ListPrice": 285000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.27 +"LivingArea": 1329.0 +"BuildingAreaTotal": 1329.0 +"City": "Columbia" +"PostalCode": "29204" +"UnparsedAddress": "2405 Barhamville Road, Columbia, SC 29204" +"Coordinates": array:2 [ 0 => -81.016289 1 => 34.026883 ] +"Latitude": 34.026883 +"Longitude": -81.016289 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Call it Closed International" +"ListAgentMlsId": "13703" +"ListOfficeMlsId": "1674" +"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.This is in a prime location near colleges & universities. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Refrigerator" +"ArchitecturalStyle": "Contemporary" +"AssociationYN": false +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Brick-Partial-AbvFound,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-10-11T01:49:54.100380+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." +"Heating": "Central" +"InteriorFeatures": "Garage Opener,Smoke Detector" +"LaundryFeatures": "Electric" +"ListAgentEmail": "jspremierrealestate@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2025-10-10" +"PhotosChangeTimestamp": "2025-10-11T01:44:55Z" +"PhotosCount": "9" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Cabinets-Other,Backsplash-Tiled,Counter Tops-Quartz" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Barhamville" +"StreetNumber": "2405" +"StreetSuffix": "Road" +"SubdivisionName": "BARHAMVILLE" +"WaterSource": "Public" +"TMS": "11507-03-10" +"Baths": "2" +"Garage": "Garage Attached, Front Entry" +"Address": "2405 Barhamville Road" +"LVTDate": "2025-10-10" +"BathsFull": "2" +"#ofStories": "1" +"BathsCombo": "2 / 0" +"HighSchool": "Eau Claire" +"IDXInclude": "Yes" +"LivingRoom": "Ceiling Fan" +"New/Resale": "New" +"class_name": "RE_1" +"LA1UserCode": "SINGLETJ" +"GarageSpaces": "1" +"MiddleSchool": "Perry" +"PricePerSQFT": "214.45" +"StatusDetail": "0" +"MasterBedroom": "Separate Shower,Ceiling Fan,Closet-Private,Floors-Luxury Vinyl Plank" +"Miscellaneous": "Warranty (New Const) Bldr" +"FullBaths-Main": "2" +"GeoSubdivision": "SC" +"HalfBaths-Main": "0" +"Level-Bedroom2": "Main" +"Level-Bedroom3": "Main" +"SchoolDistrict": "Richland One" +"LO1MainOfficeID": "1674" +"OtherHeatedSqFt": "0" +"ElementarySchool": "Watkins" +"FormalDiningRoom": "Butlers Pantry,Ceiling Fan,Floors-Luxury Vinyl Plank" +"LA1AgentLastName": "Singletary" +"Level-LivingRoom": "Main" +"ListPriceTotSqFt": "214.45" +"RollbackTax(Y/N)": "No" +"LA1AgentFirstName": "Justin" +"Level-WasherDryer": "Main" +"GeoUpdateTimestamp": "2025-10-11T01:44:54.7" +"AddressSearchNumber": "2405" +"LO1OfficeIdentifier": "1674" +"Level-MasterBedroom": "Main" +"ListingTypeAgreement": "Exclusive Right to Sell" +"PublishtoInternetY/N": "Yes" +"Interior#ofFireplaces": "0" +"LO1OfficeAbbreviation": "CICL01" +"FirstPhotoAddTimestamp": "2025-10-11T01:44:55.1" +"MlsAreaMajor": "City of Columbia, Denny terrace, Lake Elizabeth" +"Media": array:9 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6193490" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/619349/a63586218f0f878089745418a5faf6ed.webp" "ClassName" => "Single Family" "MediaSize" => 158098 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/619349/thumbnail-a63586218f0f878089745418a5faf6ed.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "619349" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6193491" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/619349/3461035520bcbcbac1729b38d2dceccd.webp" "ClassName" => "Single Family" "MediaSize" => 165623 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/619349/thumbnail-3461035520bcbcbac1729b38d2dceccd.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "619349" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6193492" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/619349/71e79fb18306242291a504b3ee78ef45.webp" "ClassName" => "Single Family" "MediaSize" => 174006 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/619349/thumbnail-71e79fb18306242291a504b3ee78ef45.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "619349" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6193493" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/619349/d63760d67ae55bb49443abe56acb6e1d.webp" "ClassName" => "Single Family" "MediaSize" => 345005 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/619349/thumbnail-d63760d67ae55bb49443abe56acb6e1d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "619349" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6193494" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/619349/bca72e29116ab86e3b09ef0212d1f2b1.webp" "ClassName" => "Single Family" "MediaSize" => 354471 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/619349/thumbnail-bca72e29116ab86e3b09ef0212d1f2b1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "619349" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6193495" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/619349/e5dba40448f0581d5a40d4e4f8810ef0.webp" "ClassName" => "Single Family" "MediaSize" => 335025 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/619349/thumbnail-e5dba40448f0581d5a40d4e4f8810ef0.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "619349" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6193496" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/619349/0cbc191d1b9ebc41eddc6c74f732f26f.webp" "ClassName" => "Single Family" "MediaSize" => 345005 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/619349/thumbnail-0cbc191d1b9ebc41eddc6c74f732f26f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "619349" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6193497" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/619349/a5e82aa481793b3f9d37c04c974f93bc.webp" "ClassName" => "Single Family" "MediaSize" => 299070 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/619349/thumbnail-a5e82aa481793b3f9d37c04c974f93bc.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "619349" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6193498" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/619349/fc06abac2f8855d83cbbfe6d773b3c18.webp" "ClassName" => "Single Family" "MediaSize" => 207648 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/619349/thumbnail-fc06abac2f8855d83cbbfe6d773b3c18.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "619349" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('619349')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } ] ]
