Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR ArchitecturalStyle eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR CommunityFeatures eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR Cooling eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR CountyOrParish eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR ElementarySchool eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR ExteriorFeatures eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR Flooring eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR Heating eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR HighSchool eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR InteriorFeatures eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR ListingTerms eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR MiddleOrJuniorSchool eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR ParkingFeatures eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR PoolFeatures eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR PropertyType eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR Roof eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR SchoolDistrict eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR Sewer eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR Utilities eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar' OR WaterfrontFeatures eq 'Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3429 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3427 +post_id: "131005" +post_author: 1 +"ListingKey": "636140" +"ListingId": "636140" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-11T00:45:38Z" +"RFModificationTimestamp": "2026-06-11T00:51:05Z" +"ListPrice": 5000000.0 +"BathroomsTotalInteger": 9.0 +"BathroomsHalf": 2 +"BedroomsTotal": 6.0 +"LotSizeArea": 1.73 +"LivingArea": 9466.0 +"BuildingAreaTotal": 10942.0 +"City": "Columbia" +"PostalCode": "29209" +"UnparsedAddress": "714 Hampton Hill Road, Columbia, SC 29209" +"Coordinates": array:2 [ 0 => -80.969634 1 => 33.987021 ] +"Latitude": 33.987021 +"Longitude": -80.969634 +"YearBuilt": 2008 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "7437" +"ListOfficeMlsId": "1084" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Please find the details below regarding a unique Mediterranean-inspired Spanish Colonial estate currently available for consideration.This exceptional property features spacious living areas centered around an open-concept kitchen with an island, den,dining area, complete with a fireplace and vaulted ceilings. The main floor offers multiple formal and informal living spaces, including a study and a formal living room overlooking the courtyard. This level also includes three ensuite bedrooms—including the primary suite—as well as a private office, a large laundry room, and ample storage.The estate further includes a separate guest suite with a private den and two additional ensuite bedrooms. The lower level opens directly onto the courtyard and is equipped with a great room, fireplace, second kitchen area, dining space, gym, and half bath. Additionally, a versatile carriage house is located adjacent to the pool and loggia.This is a remarkable property that must be seen to be fully appreciated. Please let me know if you would like to schedule a viewing. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Icemaker,Microwave Built In,Refrigerator,Stove Exhaust Vented Exte,Wine Cooler" +"ArchitecturalStyle": "Other" +"AssociationYN": false +"Basement": "Yes Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Brick-All Sides-AbvFound" +"Cooling": "Central,Multiple Units" +"CountyOrParish": "Richland" +"CreationDate": "2026-06-10T16:38:39.266312+00:00" +"Directions": "Kilbourne to Hampton Hill Road . House is on the left." +"ExteriorFeatures": "Deck,Grill,Guest House,Patio,Sprinkler,Landscape Lighting,Gutters - Partial,Fireplace,Back Porch - Uncovered,Other Porch - Covered" +"Fencing": "Rear Only Other" +"FireplaceFeatures": "Gas Log-Natural,Masonry,Wood Burning" +"Heating": "Central,Multiple Units" +"InteriorFeatures": "Attic Access,Attic Storage,BookCase,Ceiling Fan,Garage Opener,Smoke Detector,Wetbar" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Electric,Heated Space,Mud Room" +"ListAgentEmail": "michelmooregroup@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "6" +"OriginalEntryTimestamp": "2026-06-09" +"PhotosChangeTimestamp": "2026-06-10T16:32:13Z" +"PhotosCount": "19" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Bar,Eat In,Island,Pantry,Counter Tops-Granite,Floors-Tile,Backsplash-Tiled,Cabinets-Painted,Ceiling Fan,Recessed Lights" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Hampton Hill" +"StreetNumber": "714" +"StreetSuffix": "Road" +"SubdivisionName": "HAMPTON HILLS" +"WaterSource": "Public" +"TMS": "13813-02-03" +"Baths": "9" +"Range": "Free-standing,Gas" +"Garage": "Garage Attached, Rear Entry" +"Address": "714 Hampton Hill Road" +"LVTDate": "2026-06-10" +"LotSize": "363x173x382x247" +"PowerOn": "Yes" +"Location": "Corner" +"PoolType": "Inground-Gunite" +"BathsFull": "7" +"GreatRoom": "Fireplace,Molding,Skylight,Wetbar,Ceiling-Vaulted,Ceilings-High (over 9 Ft),Recessed Lights,Floors - Tile" +"#ofStories": "3" +"2ndBedroom": "Bath-Private,Tub-Shower,Ceilings-High (over 9 Ft),Built-ins,Closet-Private,Floors-Hardwood,Recessed Lighting" +"3rdBedroom": "Bath-Private,Closet-Walk in,Tub-Shower,Built-ins,Ceiling Fan,Closet-Private,Floors-Hardwood" +"4thBedroom": "Bath-Private,Closet-Walk in,Tub-Shower,Ceiling Fan,Closet-Private,Floors-Hardwood" +"5thBedroom": "Bath-Private,Tub-Shower,Ceiling Fan,Recessed Lighting" +"6thBedroom": "Bath-Private,Ceiling Fan,Closet-Private,Closet-Walk in,Floors-Hardwood,Recessed Lighting,Tub-Shower" +"BathsCombo": "7 / 2" +"HighSchool": "A. C. Flora" +"IDXInclude": "Yes" +"LivingRoom": "Fireplace,French Doors,Molding,Wetbar,Ceiling Fan,Recessed Lights,Floors - Tile" +"LowerLevel": "Finished" +"New/Resale": "Resale" +"OtherRooms": "Enclosed Garage,In Law Suite,Library,Office,Other" +"class_name": "RE_1" +"GarageLevel": "Lower" +"LA1UserCode": "MIMOORE" +"GarageSpaces": "2" +"MiddleSchool": "Crayton" +"PricePerSQFT": "528.21" +"ShortSaleY/N": "No" +"StatusDetail": "0" +"AgentHitCount": "69" +"FullBaths-2nd": "3" +"Level-Kitchen": "Main" +"MasterBedroom": "Double Vanity,Tub-Garden,Bath-Private,Separate Shower,Closet-Walk in,Ceilings-High (over 9 Ft),Built-ins,Ceiling Fan,Closet-Private,Recessed Lighting" +"FullBaths-Main": "3" +"GeoSubdivision": "SC" +"HalfBaths-Main": "2" +"Level-Bedroom2": "Main" +"Level-Bedroom3": "Main" +"Level-Bedroom4": "Second" +"Level-Bedroom5": "Second" +"Level-Bedroom6": "Second" +"Level-Kitchen2": "Lower" +"SchoolDistrict": "Richland One" +"FullBaths-Lower": "1" +"LO1MainOfficeID": "1089" +"Level-GreatRoom": "Main" +"Level-OtherRoom": "Main" +"OtherHeatedSqFt": "1476" +"ElementarySchool": "Brennen" +"FormalDiningRoom": "Built-ins,French Doors,Floors-Hardwood,Molding,Ceilings-High (over 9 Ft)" +"FormalLivingRoom": "Fireplace,French Doors,Floors-Hardwood,Molding,Ceilings-High (over 9 Ft),Recessed Lights" +"LA1AgentLastName": "Moore" +"Level-GreatRoom2": "Lower" +"Level-LivingRoom": "Main" +"Level-OtherRoom2": "Main" +"ListPriceTotSqFt": "528.21" +"RollbackTax(Y/N)": "No" +"LA1AgentFirstName": "Michel" +"Level-WasherDryer": "Main" +"ForeclosedProperty": "No" +"GeoUpdateTimestamp": "2026-06-10T16:32:12.5" +"AddressSearchNumber": "714" +"LO1OfficeIdentifier": "1084" +"Level-MasterBedroom": "Main" +"ListingTypeAgreement": "Exclusive Right to Sell" +"PublishtoInternetY/N": "Yes" +"Interior#ofFireplaces": "3" +"LA1AgentMiddleInitial": "G" +"LO1OfficeAbbreviation": "CBRB01" +"FirstPhotoAddTimestamp": "2026-06-10T16:32:13.5" +"Level-FormalDiningRoom": "Main" +"Level-FormalLivingRoom": "Main" +"MlsAreaMajor": "East Columbia" +"PrivatePoolYN": "Yes" +"Media": array:19 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6361400" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/9d23339ff50e630cacd0a5b0b3f9e511.webp" "ClassName" => "Single Family" "MediaSize" => 1415396 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-9d23339ff50e630cacd0a5b0b3f9e511.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6361401" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/992c03c6378f6626120417d7d55d5fa1.webp" "ClassName" => "Single Family" "MediaSize" => 1451360 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-992c03c6378f6626120417d7d55d5fa1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6361402" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/8afd8fc132fa0d9944e86a23da23b414.webp" "ClassName" => "Single Family" "MediaSize" => 831384 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-8afd8fc132fa0d9944e86a23da23b414.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6361403" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/a328a07f95d7494e146329f3ddacd020.webp" "ClassName" => "Single Family" "MediaSize" => 761924 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-a328a07f95d7494e146329f3ddacd020.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6361404" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/825686bfe1917c22da148634fcd3e31b.webp" "ClassName" => "Single Family" "MediaSize" => 758846 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-825686bfe1917c22da148634fcd3e31b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6361405" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/4bc5de4dddf34fc1f30e04352f1555c4.webp" "ClassName" => "Single Family" "MediaSize" => 807979 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-4bc5de4dddf34fc1f30e04352f1555c4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6361406" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/b841f52a32996afa94f24adcfd0cf29f.webp" "ClassName" => "Single Family" "MediaSize" => 756933 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-b841f52a32996afa94f24adcfd0cf29f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6361407" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/205a380fedf93a0ebc34605e14d9b04f.webp" "ClassName" => "Single Family" "MediaSize" => 762423 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-205a380fedf93a0ebc34605e14d9b04f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6361408" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/d1434f557aa716d080b4f827997fd9be.webp" "ClassName" => "Single Family" "MediaSize" => 770636 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-d1434f557aa716d080b4f827997fd9be.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6361409" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/3437d1bdf719eda2b4b1c71c402696e1.webp" "ClassName" => "Single Family" "MediaSize" => 780384 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-3437d1bdf719eda2b4b1c71c402696e1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "63614010" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/16ea0cc016ab96532dfa42863153637a.webp" "ClassName" => "Single Family" "MediaSize" => 704853 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-16ea0cc016ab96532dfa42863153637a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "63614011" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/8a69f3546cc03669f5b62a6b3b6a3788.webp" "ClassName" => "Single Family" "MediaSize" => 694063 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-8a69f3546cc03669f5b62a6b3b6a3788.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "63614012" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/3850bc5b1c2a20753a5a58682db8f87e.webp" "ClassName" => "Single Family" "MediaSize" => 766423 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-3850bc5b1c2a20753a5a58682db8f87e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "63614013" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/0f8bb16a48456df64ec592651df36910.webp" "ClassName" => "Single Family" "MediaSize" => 835039 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-0f8bb16a48456df64ec592651df36910.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "63614014" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/15ec1c80970b47c415c363190654e532.webp" "ClassName" => "Single Family" "MediaSize" => 1168614 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-15ec1c80970b47c415c363190654e532.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "63614015" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/1be80b2719c16f556b84ed4ffecd36dc.webp" "ClassName" => "Single Family" "MediaSize" => 1185817 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-1be80b2719c16f556b84ed4ffecd36dc.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "63614016" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/bbb8ef80816826de71b06c5d45464467.webp" "ClassName" => "Single Family" "MediaSize" => 1405333 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-bbb8ef80816826de71b06c5d45464467.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "63614017" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/bf9dfb4c73ddcef30fb7a846bc03465e.webp" "ClassName" => "Single Family" "MediaSize" => 667440 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-bf9dfb4c73ddcef30fb7a846bc03465e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "63614018" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/636140/97469d6452cd741b268fd235ebe2cc0e.webp" "ClassName" => "Single Family" "MediaSize" => 1522246 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/636140/thumbnail-97469d6452cd741b268fd235ebe2cc0e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "636140" ] ] +"DaysOnMarket": 8 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('636140')" +"ID": "131005" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.13 seconds" ] "RF Cache Key: d3ec62601fddf8433627007048eeb7012d69dd2063ec246b492cfb001e775888" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3422 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3427} ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } ] ]
