Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
Array
(
[RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(PropertyType eq 'Land' or PropertyType eq 'Residential' or PropertyType eq 'Residential Income') and (Appliances eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR ArchitecturalStyle eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR CommunityFeatures eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR Cooling eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR CountyOrParish eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR ElementarySchool eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR ExteriorFeatures eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR Flooring eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR Heating eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR HighSchool eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR InteriorFeatures eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR ListingTerms eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR MiddleOrJuniorSchool eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR ParkingFeatures eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR PoolFeatures eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR PropertyType eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR Roof eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR SchoolDistrict eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR Sewer eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR Utilities eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened' OR WaterfrontFeatures eq 'Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true] => Array
(
[RF Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
[0] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 134595
[post_author] => 1
[ListingKey] => 639903
[ListingId] => 639903
[PropertyType] => Residential
[PropertySubType] => Single Family
[StandardStatus] => Pending
[ModificationTimestamp] => 2026-10-13T18:00:43Z
[RFModificationTimestamp] => 2026-10-13T18:05:41Z
[ListPrice] => 289900
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 1
[BedroomsTotal] => 3
[LotSizeArea] => 0.41
[LivingArea] => 1774
[BuildingAreaTotal] => 1774
[City] => Elgin
[PostalCode] => 29045
[UnparsedAddress] => 208 Hickory Hill Trail, Elgin, SC 29045
[Coordinates] => Array
(
[0] => -80.859556
[1] => 34.147531
)
[Latitude] => 34.147531
[Longitude] => -80.859556
[YearBuilt] => 1980
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => BHHS Midlands Real Estate
[ListAgentMlsId] => 5016
[ListOfficeMlsId] => 682
[OriginatingSystemName] => columbiamls
[PublicRemarks] => SELLER OFFERING 10K TO GO TOWARDS BUYERS CLOSING COSTS WITH AN ACCEPTABLE OFER!! Welcome home to this charming two-story traditional home situated on a spacious 0.41-acre lot in Briarcliffe Estates. Offering over 1,700 square feet, this 3-bedroom, 2.5-bath home features a functional layout designed for comfortable everyday living. The open-concept living room, dining area, and kitchen create a warm and inviting space perfect for both entertaining and daily life. The living room features a cozy fireplace and opens to a bright and airy sunroom, providing the perfect spot to relax with a book or enjoy your morning coffee. The eat-in kitchen features granite countertops, stainless steel appliances, recessed lighting, and ample cabinet space. A convenient half bath on the main level is perfect for guests. The spacious primary suite serves as a private retreat with dual closets and an ensuite bathroom featuring a walk-in shower. Two additional bedrooms and a full bath provide plenty of room for family or guests. Step outside to the screened porch overlooking the fully fenced backyard, where you'll find a workshop offering endless possibilities for hobbies, storage, or a home workspace. Additional highlights include an attached two-car garage, covered front porch, new luxury vinyl plank flooring upstairs, a new water heater, and mature landscaping. Conveniently located less than five minutes from the Village at Sandhill, you'll enjoy easy access to shopping, dining, and entertainment, with a quick commute to Columbia, Lugoff, Camden, and major interstates. Don't miss your opportunity to make this beautiful Elgin home your own! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[Appliances] => Dishwasher,Disposal,Dryer,Washer,Microwave Above Stove,Electric Water Heater
[ArchitecturalStyle] => Traditional
[AssociationYN] => 1
[Basement] => No Basement
[BuildingAreaUnits] => Sqft
[CoListAgentEmail] => kmckissick@bhhsmidlands.com
[ConstructionMaterials] => Vinyl
[Cooling] => Central
[CountyOrParish] => Richland
[CreationDate] => 2026-07-31T21:57:00.397892+00:00
[Directions] => From Sandhills, take Rhame Road into Briarcliffe. Go 1.7 miles and turn right at stop sign onto Branch Hill Drive. Take first left onto Hickory Hill Drive. House will be on the left.
[ExteriorFeatures] => Shed,Gutters - Partial,Front Porch - Covered,Back Porch - Screened
[Fencing] => Chain Link,Rear Only-Chain Link
[FireplaceFeatures] => Wood Burning
[Heating] => Central
[InteriorFeatures] => Attic Storage,Garage Opener,Attic Pull-Down Access,Attic Access
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Unheated Space
[ListAgentEmail] => areynolds@bhhsmidlands.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => Pending Contngnt/Inspect
[OriginalEntryTimestamp] => 2026-07-31
[PhotosChangeTimestamp] => 2026-10-13T18:00:43Z
[PhotosCount] => 21
[RoadFrontageType] => Paved
[RoomKitchenFeatures] => Eat In,Island,Counter Tops-Granite,Floors-Tile,Cabinets-Other
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Hickory Hill
[StreetNumber] => 208
[StreetSuffix] => Trail
[SubdivisionName] => BRIARCLIFFE ESTATES
[WaterSource] => Public
[TMS] => 25908-01-23
[Baths] => 3
[Range] => Free-standing,Smooth Surface
[Garage] => Garage Attached, Front Entry
[Address] => 208 Hickory Hill Trail
[AssnFee] => 85
[LVTDate] => 2026-07-31
[LotSize] => .410
[PowerOn] => Yes
[BathsFull] => 2
[#ofStories] => 2
[2ndBedroom] => Bath-Shared,Tub-Shower,Ceiling Fan,Closet-Private,Floors-Luxury Vinyl Plank
[3rdBedroom] => Bath-Shared,Tub-Garden,Ceiling Fan,Closet-Private,Floors-Luxury Vinyl Plank
[BathsCombo] => 2 / 1
[HighSchool] => Ridge View
[IDXInclude] => Yes
[LivingRoom] => Fireplace,Molding,Ceiling Fan,Floors-Luxury Vinyl Plank
[New/Resale] => Resale
[OtherRooms] => Sun Room
[class_name] => RE_1
[GarageLevel] => Main
[LA1UserCode] => REYNOA
[Co-ListAgent] => 17711
[GarageSpaces] => 2
[MiddleSchool] => Summit
[PricePerSQFT] => 163.42
[ShortSaleY/N] => No
[StatusDetail] => 3
[AgentHitCount] => 92
[Co-ListOffice] => 682
[FullBaths-2nd] => 2
[MasterBedroom] => Closet-His & Her,Bath-Private,Separate Shower,Ceiling Fan
[Miscellaneous] => Built-ins
[AvailFinancing] => Cash,Conventional,FHA,VA
[FullBaths-Main] => 0
[GeoSubdivision] => SC
[HalfBaths-Main] => 1
[SchoolDistrict] => Richland Two
[LO1MainOfficeID] => 682
[OtherHeatedSqFt] => 0
[SeniorLivingY/N] => N
[AssocFeeIncludes] => Common Area Maintenance,Playground
[ElementarySchool] => Bookman Road
[FormalDiningRoom] => Built-ins,Molding,Floors-Luxury Vinyl Plank
[LA1AgentLastName] => Reynolds
[ListPriceTotSqFt] => 163.42
[RollbackTax(Y/N)] => No
[Assn/RegimeFeePer] => Yearly
[DetitledMobileY/N] => N
[LA1AgentFirstName] => Andrea
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2026-07-31T21:50:11.2
[AddressSearchNumber] => 208
[LO1OfficeIdentifier] => 682
[Level-MasterBedroom] => Main
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 1
[LO1OfficeAbbreviation] => PRUM01
[FirstPhotoAddTimestamp] => 2026-07-31T21:50:11.6
[MlsAreaMajor] => Columbia Northeast
[PrivatePoolYN] => No
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6399030
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/4b74bac9de9c5561ef12ec4cae81702f.webp
[ClassName] => Single Family
[MediaSize] => 764771
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-4b74bac9de9c5561ef12ec4cae81702f.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6399031
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/5ac60855e2fb5b3f296f3d9e1cdd3415.webp
[ClassName] => Single Family
[MediaSize] => 701725
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-5ac60855e2fb5b3f296f3d9e1cdd3415.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6399032
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/14de36d99ba8b50ad9df79957113520f.webp
[ClassName] => Single Family
[MediaSize] => 522217
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-14de36d99ba8b50ad9df79957113520f.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6399033
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/059df30a3b3bd87b9f5435736afdc5ca.webp
[ClassName] => Single Family
[MediaSize] => 625842
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-059df30a3b3bd87b9f5435736afdc5ca.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6399034
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/30fc1b41fde25b395a1a230b17a8960d.webp
[ClassName] => Single Family
[MediaSize] => 593958
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-30fc1b41fde25b395a1a230b17a8960d.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6399035
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/9d0af0aacbac9a8ee8cef3c95ef636ae.webp
[ClassName] => Single Family
[MediaSize] => 529673
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-9d0af0aacbac9a8ee8cef3c95ef636ae.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6399036
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/9751319cfac6b557e9b516360c07149c.webp
[ClassName] => Single Family
[MediaSize] => 473508
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-9751319cfac6b557e9b516360c07149c.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6399037
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/6e3a86a27e1a208ff06eed706d4ebe3a.webp
[ClassName] => Single Family
[MediaSize] => 506976
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-6e3a86a27e1a208ff06eed706d4ebe3a.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6399038
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/dd6bf0d3c668e21da1f88a129bc57602.webp
[ClassName] => Single Family
[MediaSize] => 582396
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-dd6bf0d3c668e21da1f88a129bc57602.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6399039
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/01ca86be69799f1e369583c786591e0f.webp
[ClassName] => Single Family
[MediaSize] => 633504
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-01ca86be69799f1e369583c786591e0f.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[10] => Array
(
[Order] => 10
[MediaKey] => 63990310
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/2d690eb541131ec4af9b6a4eb46cbd30.webp
[ClassName] => Single Family
[MediaSize] => 601262
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-2d690eb541131ec4af9b6a4eb46cbd30.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[11] => Array
(
[Order] => 11
[MediaKey] => 63990311
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/f949de14a7a21f8c1328632f5611eef4.webp
[ClassName] => Single Family
[MediaSize] => 477770
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-f949de14a7a21f8c1328632f5611eef4.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[12] => Array
(
[Order] => 12
[MediaKey] => 63990312
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/38608151a6737b8226c2404112be3b76.webp
[ClassName] => Single Family
[MediaSize] => 601343
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-38608151a6737b8226c2404112be3b76.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[13] => Array
(
[Order] => 13
[MediaKey] => 63990313
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/a4d36055447e4304216b4220a6d12fb7.webp
[ClassName] => Single Family
[MediaSize] => 492280
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-a4d36055447e4304216b4220a6d12fb7.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[14] => Array
(
[Order] => 14
[MediaKey] => 63990314
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/6c0900aa2ba33eb728f6e0fbedc95a48.webp
[ClassName] => Single Family
[MediaSize] => 529308
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-6c0900aa2ba33eb728f6e0fbedc95a48.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[15] => Array
(
[Order] => 15
[MediaKey] => 63990315
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/67df9668f2048e81a76c2dc9b9ca6a54.webp
[ClassName] => Single Family
[MediaSize] => 554669
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-67df9668f2048e81a76c2dc9b9ca6a54.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[16] => Array
(
[Order] => 16
[MediaKey] => 63990316
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/dec8da2b040dff01643c4f333c72d8ad.webp
[ClassName] => Single Family
[MediaSize] => 493577
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-dec8da2b040dff01643c4f333c72d8ad.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[17] => Array
(
[Order] => 17
[MediaKey] => 63990317
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/0514126bbd54de95ff930701f6676c9c.webp
[ClassName] => Single Family
[MediaSize] => 1107429
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-0514126bbd54de95ff930701f6676c9c.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[18] => Array
(
[Order] => 18
[MediaKey] => 63990318
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/0caeeed640d587cd209f69e7c913c352.webp
[ClassName] => Single Family
[MediaSize] => 885562
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-0caeeed640d587cd209f69e7c913c352.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[19] => Array
(
[Order] => 19
[MediaKey] => 63990319
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/ef5143ee57d871abf4cbaa37572018ed.webp
[ClassName] => Single Family
[MediaSize] => 744001
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-ef5143ee57d871abf4cbaa37572018ed.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
[20] => Array
(
[Order] => 20
[MediaKey] => 63990320
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/639903/204037a57666c984f0c66a0f621cc40a.webp
[ClassName] => Single Family
[MediaSize] => 1120666
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/639903/thumbnail-204037a57666c984f0c66a0f621cc40a.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 639903
)
)
[DaysOnMarket] =>
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('639903')
[ID] => 134595
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.15 seconds
)
)