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 'Common Lake,Deeded Lake Access' OR ArchitecturalStyle eq 'Common Lake,Deeded Lake Access' OR CommunityFeatures eq 'Common Lake,Deeded Lake Access' OR Cooling eq 'Common Lake,Deeded Lake Access' OR CountyOrParish eq 'Common Lake,Deeded Lake Access' OR ElementarySchool eq 'Common Lake,Deeded Lake Access' OR ExteriorFeatures eq 'Common Lake,Deeded Lake Access' OR Flooring eq 'Common Lake,Deeded Lake Access' OR Heating eq 'Common Lake,Deeded Lake Access' OR HighSchool eq 'Common Lake,Deeded Lake Access' OR InteriorFeatures eq 'Common Lake,Deeded Lake Access' OR ListingTerms eq 'Common Lake,Deeded Lake Access' OR MiddleOrJuniorSchool eq 'Common Lake,Deeded Lake Access' OR ParkingFeatures eq 'Common Lake,Deeded Lake Access' OR PoolFeatures eq 'Common Lake,Deeded Lake Access' OR PropertyType eq 'Common Lake,Deeded Lake Access' OR Roof eq 'Common Lake,Deeded Lake Access' OR SchoolDistrict eq 'Common Lake,Deeded Lake Access' OR Sewer eq 'Common Lake,Deeded Lake Access' OR Utilities eq 'Common Lake,Deeded Lake Access' OR WaterfrontFeatures eq 'Common Lake,Deeded Lake Access') 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] => 139378
[post_author] => 1
[ListingKey] => 645248
[ListingId] => 645248
[PropertyType] => Residential
[PropertySubType] => Single Family
[StandardStatus] => Active
[ModificationTimestamp] => 2026-10-18T00:39:46Z
[RFModificationTimestamp] => 2026-10-18T00:44:27Z
[ListPrice] => 335000
[BathroomsTotalInteger] => 2
[BathroomsHalf] => 0
[BedroomsTotal] => 2
[LotSizeArea] => 1.34
[LivingArea] => 1976
[BuildingAreaTotal] => 1976
[City] => Columbia
[PostalCode] => 29209
[UnparsedAddress] => 7106 Sunview Circle, Columbia, SC 29209
[Coordinates] => Array
(
[0] => -80.910972
[1] => 33.971214
)
[Latitude] => 33.971214
[Longitude] => -80.910972
[YearBuilt] => 1953
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => Coldwell Banker Realty
[ListAgentMlsId] => 20301
[ListOfficeMlsId] => 1097
[OriginatingSystemName] => columbiamls
[PublicRemarks] => INCREDIBLE WATERFRONT OPPORTUNITY ON SUNVIEW LAKE! Come SEE! Discover your own private hideaway on 1.34 beautiful acres in East Columbia! Featuring breathtaking lake views, a peaceful setting, and wonderful privacy, this property offers tremendous potential for the buyer with vision. Bring your imagination and transform this diamond in the rough into a spectacular lakeside retreat! Imagine enjoying your morning coffee overlooking the water, relaxing in the tranquility of nature, and creating a home that takes full advantage of this remarkable setting. The home has good bones but needs extensive repairs and renovation. Has its own dock and a separate large storage building with a half bath and kitchen area for parties and a she-shed with its own fireplace to read or relax or whatever. Rarely do you find this much acreage and waterfront beauty with the convenience of city living. An exceptional opportunity for investors, renovators, or anyone ready to bring new life to a truly special property. Sold AS IS. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[ArchitecturalStyle] => Ranch
[AssociationYN] =>
[Basement] => No Basement
[BuildingAreaUnits] => Sqft
[ConstructionMaterials] => Brick-Partial-AbvFound,Fiber Cement-Hardy Plank
[Cooling] => Central
[CountyOrParish] => Richland
[CreationDate] => 2026-10-18T00:27:09.599089+00:00
[Directions] => From downtown Columbia, take Garners Ferry Road (US-76/378) east. Turn right onto Leesburg Road (SC-262). Turn right onto Glengarry Drive, then left onto Sunview Circle. Continue to 7106 Sunview Circle, Columbia, SC 29209.
[Heating] => Central
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => clay.faulk@cbrealty.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-10-17
[PhotosChangeTimestamp] => 2026-10-18T00:22:44Z
[PhotosCount] => 13
[RoadFrontageType] => Paved
[Sewer] => Septic
[StateOrProvince] => SC
[StreetName] => Sunview
[StreetNumber] => 7106
[StreetSuffix] => Circle
[SubdivisionName] => NONE
[WaterSource] => Public
[WaterfrontFeatures] => Common Lake,Deeded Lake Access
[TMS] => 19209-02-02
[Baths] => 2
[Garage] => Carport Detached
[Address] => 7106 Sunview Circle
[LVTDate] => 2026-10-17
[BathsFull] => 2
[LotNumber] => A & 1A
[BathsCombo] => 2 / 0
[HighSchool] => Lower Richland
[IDXInclude] => Yes
[New/Resale] => Resale
[class_name] => RE_1
[LA1UserCode] => FAULKWI
[GarageSpaces] => 1
[MiddleSchool] => Hopkins
[PricePerSQFT] => 169.53
[StatusDetail] => 0
[LockboxNumber] => 2536627
[FullBaths-Main] => 2
[GeoSubdivision] => SC
[HalfBaths-Main] => 0
[SchoolDistrict] => Richland One
[LO1MainOfficeID] => 1089
[OtherHeatedSqFt] => 0
[ElementarySchool] => Caughman Road
[LA1AgentLastName] => Faulk
[ListPriceTotSqFt] => 169.53
[RollbackTax(Y/N)] => Unknown
[LA1AgentFirstName] => William
[GeoUpdateTimestamp] => 2026-10-18T00:22:43.9
[AddressSearchNumber] => 7106
[LO1OfficeIdentifier] => 1097
[Level-MasterBedroom] => Main
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 1
[LO1OfficeAbbreviation] => CBRB09
[FirstPhotoAddTimestamp] => 2026-10-18T00:22:44.1
[MlsAreaMajor] => East Columbia
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6452480
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/cbec31ceb5147305f78d7704166ce9fb.webp
[ClassName] => Single Family
[MediaSize] => 786141
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-cbec31ceb5147305f78d7704166ce9fb.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6452481
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/7d28d0630341a2e02c92845e85116e82.webp
[ClassName] => Single Family
[MediaSize] => 1428177
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-7d28d0630341a2e02c92845e85116e82.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6452482
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/2b1ea7a635288bf0ba17bf45e70db509.webp
[ClassName] => Single Family
[MediaSize] => 1364957
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-2b1ea7a635288bf0ba17bf45e70db509.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6452483
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/6e0a664642fadde6a8ac029e39fb697a.webp
[ClassName] => Single Family
[MediaSize] => 1466603
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-6e0a664642fadde6a8ac029e39fb697a.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6452484
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/e6d281a9a54257cd95e28c427438301d.webp
[ClassName] => Single Family
[MediaSize] => 1125628
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-e6d281a9a54257cd95e28c427438301d.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6452485
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/246ef25ec30072a43d89db4e5059347a.webp
[ClassName] => Single Family
[MediaSize] => 181180
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-246ef25ec30072a43d89db4e5059347a.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6452486
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/cd8f04687409b4f722607c6f9920c12c.webp
[ClassName] => Single Family
[MediaSize] => 530149
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-cd8f04687409b4f722607c6f9920c12c.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6452487
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/b6de033ee98bbaa444945a9154513604.webp
[ClassName] => Single Family
[MediaSize] => 1069450
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-b6de033ee98bbaa444945a9154513604.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6452488
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/f6fc3daa625878c4ef2dc34b4c8ee83a.webp
[ClassName] => Single Family
[MediaSize] => 1593012
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-f6fc3daa625878c4ef2dc34b4c8ee83a.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6452489
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/a9ab2f24220f12f943ff3cbe952f2213.webp
[ClassName] => Single Family
[MediaSize] => 762829
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-a9ab2f24220f12f943ff3cbe952f2213.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[10] => Array
(
[Order] => 10
[MediaKey] => 64524810
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/cf027e32a8ced3904982c1cbc5e8ae5d.webp
[ClassName] => Single Family
[MediaSize] => 270029
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-cf027e32a8ced3904982c1cbc5e8ae5d.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[11] => Array
(
[Order] => 11
[MediaKey] => 64524811
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/52dd555dbbf15f75cfd588e10001b3bb.webp
[ClassName] => Single Family
[MediaSize] => 413900
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-52dd555dbbf15f75cfd588e10001b3bb.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
[12] => Array
(
[Order] => 12
[MediaKey] => 64524812
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/645248/40765c5ea4e36ddbb1fcead95cd38bf6.webp
[ClassName] => Single Family
[MediaSize] => 698647
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/645248/thumbnail-40765c5ea4e36ddbb1fcead95cd38bf6.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 645248
)
)
[DaysOnMarket] => 1
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('645248')
[ID] => 139378
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.14 seconds
)
)