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.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 139377
[post_author] => 1
[ListingKey] => 645247
[ListingId] => 645247
[PropertyType] => Residential
[PropertySubType] => Single Family
[StandardStatus] => Active
[ModificationTimestamp] => 2026-10-18T00:48:23Z
[RFModificationTimestamp] => 2026-10-18T00:53:03Z
[ListPrice] => 414999
[BathroomsTotalInteger] => 4
[BathroomsHalf] => 1
[BedroomsTotal] => 4
[LotSizeArea] => 2.17
[LivingArea] => 2625
[BuildingAreaTotal] => 2625
[City] => Rock Hill
[PostalCode] => 29732
[UnparsedAddress] => 1260 Russell Road, Rock Hill, SC 29732
[Coordinates] => Array
(
[0] => -81.146668
[1] => 34.931303
)
[Latitude] => 34.931303
[Longitude] => -81.146668
[YearBuilt] => 1978
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => NorthGroup Real Estate LLC
[ListAgentMlsId] => 17062
[ListOfficeMlsId] => 1479
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Discover your private retreat in Rock Hill! Situated on over 2.10 acres, this spacious ranch-style home offers the perfect combination of land, flexibility, and modern updates. Featuring a 4-bedroom, 3.5-bath layout, this home includes two primary suites on opposite sides, ideal for multi-generational living or added privacy. With over 2,600+ square feet, there is also potential for a 5th bedroom or flex space. Inside, you'll find new flooring throughout, giving the home a fresh, updated feel. The kitchen is designed for both functionality. Plus, there's a covered front porch, a double car garage, and a storage shed! 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] => Vinyl
[Cooling] => Central
[CountyOrParish] => York
[CreationDate] => 2026-10-18T00:27:09.763162+00:00
[Directions] => Take State Rte 285/Friedheim Rd. Slight left onto S Dave Lyle Blvd, continue onto E Friedheim Rd. Keep right on State Rte 285. Take SC-322 W to State Rte 536. Right on SC-5/SC-901 N/Heckle Blvd. Left on SC-322 W. Right on SC-324 W. Follow State Rte 536. Left on State Rd S-46-536, property on the rig
[Heating] => Central,Electric
[InternetEntireListingDisplayYN] => 1
[ListAgentEmail] => kenishathaagent@gmail.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-10-13
[PhotosChangeTimestamp] => 2020-01-01T00:00:00Z
[PhotosCount] => 0
[RoadFrontageType] => Gravel
[Sewer] => Septic
[StateOrProvince] => SC
[StreetName] => Russell
[StreetNumber] => 1260
[StreetSuffix] => Road
[SubdivisionName] => NONE
[WaterSource] => Well
[TMS] => 440-00-00-025
[Baths] => 4
[Garage] => Garage Attached, Front Entry
[Address] => 1260 Russell Road
[LVTDate] => 2026-10-17
[BathsFull] => 3
[#ofStories] => 1
[BathsCombo] => 3 / 1
[HighSchool] => South Pointe
[IDXInclude] => Yes
[New/Resale] => Resale
[class_name] => RE_1
[GarageLevel] => Main
[LA1UserCode] => INGRK
[GarageSpaces] => 2
[MiddleSchool] => Saluda Trail
[PricePerSQFT] => 158.09
[StatusDetail] => 0
[Level-Kitchen] => Main
[FullBaths-Main] => 3
[GeoSubdivision] => SC
[HalfBaths-Main] => 1
[Level-Bedroom2] => Main
[Level-Bedroom3] => Main
[Level-Bedroom4] => Main
[SchoolDistrict] => York County District 3
[LO1MainOfficeID] => 1479
[OtherHeatedSqFt] => 0
[ElementarySchool] => Ebenezer Avenue
[LA1AgentLastName] => Ingram
[Level-LivingRoom] => Main
[ListPriceTotSqFt] => 158.09
[RollbackTax(Y/N)] => No
[LA1AgentFirstName] => Kenisha
[Level-WasherDryer] => Main
[GeoUpdateTimestamp] => 2026-10-18T00:22:19.3
[AddressSearchNumber] => 1260
[BrokerAttribContact] => Phone: 803-320-3717
[LO1OfficeIdentifier] => 1479
[Level-MasterBedroom] => Main
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 1
[LO1OfficeAbbreviation] => NORE01
[Level-FormalDiningRoom] => Main
[MlsAreaMajor] => All Others SC Counties
[DaysOnMarket] => 5
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('645247')
[ID] => 139377
)
MLS On The Fly Debug Panel
Array
(
[RF Query: /Property?$select=ALL&$top=20&$filter=(PropertyType eq 'Land' or PropertyType eq 'Residential' or PropertyType eq 'Residential Income') and ListingKey eq 645248 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.11 seconds
)
)
MLS On The Fly Debug Panel
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147
[Warning] Undefined array key "file" in /nas/content/live/wilsonprd/wp-content/plugins/houzez-theme-functionality/extensions/meta-box/inc/fields/image.php on line 147