Array
(
[RF Query: /Property?$select=ALL&$top=20&$filter=(PropertyType eq 'Land' or PropertyType eq 'Residential' or PropertyType eq 'Residential Income') and ListingKey eq 636140 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] => 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
[BathroomsTotalInteger] => 9
[BathroomsHalf] => 2
[BedroomsTotal] => 6
[LotSizeArea] => 1.73
[LivingArea] => 9466
[BuildingAreaTotal] => 10942
[City] => Columbia
[PostalCode] => 29209
[UnparsedAddress] => 714 Hampton Hill Road, Columbia, SC 29209
[Coordinates] => Array
(
[0] => -80.969634
[1] => 33.987021
)
[Latitude] => 33.987021
[Longitude] => -80.969634
[YearBuilt] => 2008
[InternetAddressDisplayYN] => 1
[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] =>
[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] => 1
[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
(
[0] => Array
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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
(
[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] => 113
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('636140')
[ID] => 131005
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.13 seconds
)
)