Sprinkler,Gutters - Partial,Front Porch - Covered
27 Properties
Sort by:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:1 [ "RF Cache Key: ba8058050bb2e0f67fc25bba2a431b111713b57feb691984d31ca51e3ca35146" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3913 +items: array:7 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "611645" +"ListingId": "611645" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-07-21T14:14:16Z" +"RFModificationTimestamp": "2025-07-21T14:20:56Z" +"ListPrice": 244999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1742.0 +"BuildingAreaTotal": 1742.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "255 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.143861 1 => 33.856972 ] +"Latitude": 33.856972 +"Longitude": -81.143861 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "August 2025 Move In! Welcome to the beautifully designed 3-bedroom, 2.5-bath Bishop plan—perfectly located in Lexington County, just 26 minutes from downtown Columbia and offering convenient access to shopping, Lake Murray, and top-rated schools in Gaston, SC. Ideal for every lifestyle this home blends comfort, style, and smart design throughout. Step inside to discover wood-look vinyl plank flooring that flows throughout the main level, enhancing the spacious great room and open-concept layout. The kitchen is a standout, featuring an expansive island, generous counter space, and elegant quartz countertops in both the kitchen and bathrooms. Stainless steel appliances—including a gas stove, microwave, and dishwasher—add modern functionality, while the open flow between the kitchen, dining, and great room creates an ideal space for entertaining and everyday living. Upstairs, all bedrooms are thoughtfully placed for privacy. A central loft offers additional flex space—perfect for a media area, playroom, or home office. The owner’s suite is a relaxing retreat with a large walk-in closet and a private bathroom complete with a double vanity and sleek finishes. Two additional bedrooms share a full bathroom, conveniently located to provide separation from the owner’s suite—ideal for family or overnight guests. Additional highlights in this community include large homesites, a tankless water heater, gutters, a garage door opener, coach lights (per plan), and a zoned irrigation system to keep your yard looking its best year-round. The Bishop plan combines timeless design with everyday practicality—come see why it’s the perfect place to call home. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-06-25T15:27:18.634374+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-06-25" +"PhotosChangeTimestamp": "2025-07-21T14:14:16Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "255" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/558/modelhome/2926/virtualtour/2933" +"WaterSource": "Well" +"TMS": "008902-01-038" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "255 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-06-25" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "38" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Double Vanity,Bath-Shared,Closet-Walk in,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Loft" +"# of Stories": "2.5" +"Garage Level": "Main" +"LA1User Code": "JGOULD" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Full Baths-2nd": "2" +"Half Baths-2nd": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "140.64" +"Agent Hit Count": "72" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Full Baths- Lower": "0" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"LA1Agent Last Name": "Gould" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "140.64" +"Geo Update Timestamp": "2025-06-25T15:21:19.3" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "255" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"LA1Agent Middle Initial": "M" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-06-25T15:21:21.6" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6116450" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/dd717282590550be90a89b23557be08e.webp" "ClassName" => "Single Family" "MediaSize" => 223141 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-dd717282590550be90a89b23557be08e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6116451" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/10c179ef38e9205b7258554a73320981.webp" "ClassName" => "Single Family" "MediaSize" => 99568 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-10c179ef38e9205b7258554a73320981.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6116452" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/7f56d894620048662909172794ee04be.webp" "ClassName" => "Single Family" "MediaSize" => 117957 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-7f56d894620048662909172794ee04be.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6116453" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/c2cc89d5935e0de0a0b391f80777aa34.webp" "ClassName" => "Single Family" "MediaSize" => 46300 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-c2cc89d5935e0de0a0b391f80777aa34.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6116454" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/95a00c49bf842806b6aef5e703a401d3.webp" "ClassName" => "Single Family" "MediaSize" => 302786 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-95a00c49bf842806b6aef5e703a401d3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6116455" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/7e380a1dfec991c65b545b9869719d13.webp" "ClassName" => "Single Family" "MediaSize" => 371921 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-7e380a1dfec991c65b545b9869719d13.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6116456" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/26a49e9c031274d8db4bc76126cff167.webp" "ClassName" => "Single Family" "MediaSize" => 327530 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-26a49e9c031274d8db4bc76126cff167.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6116457" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/caf181fc70fc9de9a3fe6de2e013dcdb.webp" "ClassName" => "Single Family" "MediaSize" => 305892 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-caf181fc70fc9de9a3fe6de2e013dcdb.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6116458" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/ebd9f083e08698d99157d8bed0d3edac.webp" "ClassName" => "Single Family" "MediaSize" => 377569 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-ebd9f083e08698d99157d8bed0d3edac.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6116459" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/6e44455115e1d7cc3e1162d956b9aaf8.webp" "ClassName" => "Single Family" "MediaSize" => 302655 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-6e44455115e1d7cc3e1162d956b9aaf8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61164510" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/437869a996a22db05e03b97502188150.webp" "ClassName" => "Single Family" "MediaSize" => 337276 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-437869a996a22db05e03b97502188150.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61164511" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/4cf442cbc41a4b689f0b0b9b33fdcb00.webp" "ClassName" => "Single Family" "MediaSize" => 368552 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-4cf442cbc41a4b689f0b0b9b33fdcb00.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61164512" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/b7f6586a94488564f9395c71505812f9.webp" "ClassName" => "Single Family" "MediaSize" => 291549 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-b7f6586a94488564f9395c71505812f9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61164513" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/367b3fe2bbfd52d183843693bff07ecd.webp" "ClassName" => "Single Family" "MediaSize" => 304455 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-367b3fe2bbfd52d183843693bff07ecd.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61164514" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/54b7fcac208e1c3ef341553132288dcb.webp" "ClassName" => "Single Family" "MediaSize" => 348880 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-54b7fcac208e1c3ef341553132288dcb.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "61164515" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/a123af3763298ea9d1be6421ca4d9835.webp" "ClassName" => "Single Family" "MediaSize" => 300815 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-a123af3763298ea9d1be6421ca4d9835.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "61164516" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/0d93fa2f4c0b5c30a08121f4b34a9258.webp" "ClassName" => "Single Family" "MediaSize" => 231951 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-0d93fa2f4c0b5c30a08121f4b34a9258.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "61164517" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/3ce1f23a8ff4dc184745fbe9737249a8.webp" "ClassName" => "Single Family" "MediaSize" => 278304 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-3ce1f23a8ff4dc184745fbe9737249a8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "61164518" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/8d0c4fa9fdc47da716e4d904fa44bc0e.webp" "ClassName" => "Single Family" "MediaSize" => 350340 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-8d0c4fa9fdc47da716e4d904fa44bc0e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "61164519" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/294b00bbf0965ef619d869dbe1f8d69f.webp" "ClassName" => "Single Family" "MediaSize" => 371021 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-294b00bbf0965ef619d869dbe1f8d69f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "61164520" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/9c537a4097a690959a4e410788e95f84.webp" "ClassName" => "Single Family" "MediaSize" => 222835 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-9c537a4097a690959a4e410788e95f84.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "61164521" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/2b871d443cfc6ac23de4799cba0b22f9.webp" "ClassName" => "Single Family" "MediaSize" => 262906 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-2b871d443cfc6ac23de4799cba0b22f9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "61164522" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/342306b0547be90d45adebeb7f8570e2.webp" "ClassName" => "Single Family" "MediaSize" => 992881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-342306b0547be90d45adebeb7f8570e2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "61164523" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/611645/8ef8bd7f6db832e44ea079738839a999.webp" "ClassName" => "Single Family" "MediaSize" => 61212 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/611645/thumbnail-8ef8bd7f6db832e44ea079738839a999.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "611645" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('611645')" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3209 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "612331" +"ListingId": "612331" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-07-21T14:13:11Z" +"RFModificationTimestamp": "2025-07-21T14:20:33Z" +"ListPrice": 242999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1532.0 +"BuildingAreaTotal": 1532.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "259 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.143987 1 => 33.857072 ] +"Latitude": 33.857072 +"Longitude": -81.143987 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "August 2025 Move in! Welcome to your stunning NEW 3-bedroom, 2-bath Shelley plan in Lexington County, perfectly situated for easy commuting in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertops in the kitchen and baths, wood-inspired vinyl plank flooring throughout the first floor. Set on .28 acres, this home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, subway tile backsplash, and modern stainless-steel appliances, including a gas stove, microwave, Refrigerator, and dishwasher. The largest first-floor owner’s suite includes a full walk in closet and double vanity bathroom. An additional full bathroom is conveniently located near 2 bedrooms, ideal for main floor living, hosting overnight guests, or creating a home office. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Brick-Partial-AbvFound,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-07-03T19:12:20.037336+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77 turn left onto Hwy 321 then go to Fish Hatchery Road and turn right and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-07-03" +"PhotosChangeTimestamp": "2025-07-21T14:13:11Z" +"PhotosCount": "21" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "259" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/646/modelhome/3602/virtualtour/3614" +"WaterSource": "Well" +"TMS": "008092-01-039" +"Baths": "2" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "259 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-07-03" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "39" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Floors - Carpet" +"3rd Bedroom": "Floors - Carpet" +"Baths Combo": "2 / 0" +"High School": "Airport" +"IDX Include": "Yes" +"# of Stories": "1" +"Garage Level": "Main" +"LA1User Code": "JGOULD" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "158.62" +"Short Sale Y/N": "No" +"Agent Hit Count": "44" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Main": "2" +"Geo Subdivision": "SC" +"Half Baths-Main": "0" +"Level-Bedroom 2": "Main" +"Level-Bedroom 3": "Main" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Elementary School": "Congaree" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance,Green Areas" +"Formal Dining Room": "Area" +"LA1Agent Last Name": "Gould" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"Foreclosed Property": "No" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "158.62" +"Geo Update Timestamp": "2025-07-03T19:08:12" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Main" +"Address Search Number": "259" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"LA1Agent Middle Initial": "M" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-07-03T19:08:12.4" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:21 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6123310" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/edbace5690a70b0ae2939cb37a229019.webp" "ClassName" => "Single Family" "MediaSize" => 384035 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-edbace5690a70b0ae2939cb37a229019.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6123311" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/e00e1dc40b9e5f080769e395e1fe64bc.webp" "ClassName" => "Single Family" "MediaSize" => 119118 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-e00e1dc40b9e5f080769e395e1fe64bc.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6123312" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/1b0f8315d75e5e1dab12915209bf35e5.webp" "ClassName" => "Single Family" "MediaSize" => 45546 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-1b0f8315d75e5e1dab12915209bf35e5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6123313" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/0ab946b8bde6b0a77299b622c105105a.webp" "ClassName" => "Single Family" "MediaSize" => 219466 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-0ab946b8bde6b0a77299b622c105105a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6123314" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/b89f449ea805318a56bfbd9a116f2c7c.webp" "ClassName" => "Single Family" "MediaSize" => 254102 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-b89f449ea805318a56bfbd9a116f2c7c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6123315" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/caee049c20cff68426520191bb1091d5.webp" "ClassName" => "Single Family" "MediaSize" => 244096 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-caee049c20cff68426520191bb1091d5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6123316" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/712de8f81f80b9cda1c3f9887244aa45.webp" "ClassName" => "Single Family" "MediaSize" => 355856 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-712de8f81f80b9cda1c3f9887244aa45.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6123317" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/0be6d377e3486a751f8873261cd035c5.webp" "ClassName" => "Single Family" "MediaSize" => 380294 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-0be6d377e3486a751f8873261cd035c5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6123318" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/ee45c8322cec2781f56d6324266bad4c.webp" "ClassName" => "Single Family" "MediaSize" => 370443 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-ee45c8322cec2781f56d6324266bad4c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6123319" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/e4105b1ab0cb74b0411334fc395f82a8.webp" "ClassName" => "Single Family" "MediaSize" => 355327 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-e4105b1ab0cb74b0411334fc395f82a8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61233110" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/938c97d2ef7219b61bfdd4a85b5a9f32.webp" "ClassName" => "Single Family" "MediaSize" => 413175 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-938c97d2ef7219b61bfdd4a85b5a9f32.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61233111" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/6c5288da8fafe27e4cc0e1a1fa420e3b.webp" "ClassName" => "Single Family" "MediaSize" => 372318 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-6c5288da8fafe27e4cc0e1a1fa420e3b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61233112" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/83cb91d664072f3a369f323b44bfede9.webp" "ClassName" => "Single Family" "MediaSize" => 303990 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-83cb91d664072f3a369f323b44bfede9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61233113" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/7e8b5cc2f9701175f3c92a6921e428a9.webp" "ClassName" => "Single Family" "MediaSize" => 280247 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-7e8b5cc2f9701175f3c92a6921e428a9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61233114" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/fc1941eab9dc124277300a43c1d62009.webp" "ClassName" => "Single Family" "MediaSize" => 181721 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-fc1941eab9dc124277300a43c1d62009.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "61233115" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/550818da93e64a059553a80c1a0e49ca.webp" "ClassName" => "Single Family" "MediaSize" => 181942 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-550818da93e64a059553a80c1a0e49ca.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "61233116" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/d4ff87f6f30748fe231f26bceaef5ecd.webp" "ClassName" => "Single Family" "MediaSize" => 187369 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-d4ff87f6f30748fe231f26bceaef5ecd.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "61233117" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/34d09a07197bd1b48735e6914bf78e5d.webp" "ClassName" => "Single Family" "MediaSize" => 304825 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-34d09a07197bd1b48735e6914bf78e5d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "61233118" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/aeccc118da789c2fd28fd95d511f61bd.webp" "ClassName" => "Single Family" "MediaSize" => 327884 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-aeccc118da789c2fd28fd95d511f61bd.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "61233119" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/32d34af1c98f1b890c78634cd6167464.webp" "ClassName" => "Single Family" "MediaSize" => 992881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-32d34af1c98f1b890c78634cd6167464.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "61233120" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612331/8a5660184286305ce48409cda260e156.webp" "ClassName" => "Single Family" "MediaSize" => 91583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612331/thumbnail-8a5660184286305ce48409cda260e156.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612331" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('612331')" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3207 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "604427" +"ListingId": "604427" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-07-16T13:38:07Z" +"RFModificationTimestamp": "2025-07-16T13:41:35Z" +"ListPrice": 256999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.26 +"LivingArea": 2213.0 +"BuildingAreaTotal": 2213.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "202 Hazel Rain Road, Gaston, Sc 29053" +"Coordinates": array:2 [ 0 => -81.141598 1 => 33.856199 ] +"Latitude": 33.856199 +"Longitude": -81.141598 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Move-in April 2025! Amazing NEW 5-bedroom, 2.5-bath Dickenson plan in Lexington County, perfectly situated for easy commuting in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant granite countertops in the kitchen, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. The open kitchen has spacious counters, tiled backsplash, an expansive island, and modern stainless-steel appliances, including gas stove, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes a full walk in closet and double vanity bathroom with a large shower. An additional full bathroom is conveniently located near 4 quaint bedrooms. Utilize your open and versatile loft space for creating a home office, additional living space, or even an exercise room. Don't miss the amazing community features of large homesites, gutters, coach lights (per plan), garage door opener, tankless water heater and zoned irrigation. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20,Gas Water Heater" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-03-21T09:15:43.031452+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77 turn left onto Hwy 321 then go to Fish Hatchery Road and turn right and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access,Attic Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-03-19" +"PhotosChangeTimestamp": "2025-07-16T13:38:07Z" +"PhotosCount": "31" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Counter Tops-Granite,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "202" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-062" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "202 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-03-19" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "62" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Closet-Private,Floors - Carpet" +"3rd Bedroom": "Closet-Private,Floors - Carpet" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"5th Bedroom": "Closet-Walk in,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Loft" +"# of Stories": "2" +"Garage Level": "Main" +"LA1User Code": "JGOULD" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Full Baths-2nd": "2" +"Half Baths-2nd": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Closet-Private,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "116.13" +"Agent Hit Count": "125" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"Level-Bedroom 5": "Second" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Full Baths- Lower": "0" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"LA1Agent Last Name": "Gould" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "116.13" +"Geo Update Timestamp": "2025-03-19T19:59:31.7" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "202" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"LA1Agent Middle Initial": "M" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-03-19T19:59:32.4" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:31 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6044270" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/4af2fe3d0bf1050a8e989c7da63d74c6.webp" "ClassName" => "Single Family" "MediaSize" => 326277 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-4af2fe3d0bf1050a8e989c7da63d74c6.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6044271" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/637f4a054b95651be721b49b7acbb26a.webp" "ClassName" => "Single Family" "MediaSize" => 106023 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-637f4a054b95651be721b49b7acbb26a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6044272" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/808e3338eba57211dfe3f4817a1e0952.webp" "ClassName" => "Single Family" "MediaSize" => 108169 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-808e3338eba57211dfe3f4817a1e0952.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6044273" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/1de5a2a86f84d7a55254528df9b5fb58.webp" "ClassName" => "Single Family" "MediaSize" => 52886 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-1de5a2a86f84d7a55254528df9b5fb58.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6044274" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/2682a1b707c1f00e266c1cf02f7ca450.webp" "ClassName" => "Single Family" "MediaSize" => 293915 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-2682a1b707c1f00e266c1cf02f7ca450.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6044275" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/65e1e0b503aef40df20139098c24d6a0.webp" "ClassName" => "Single Family" "MediaSize" => 292207 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-65e1e0b503aef40df20139098c24d6a0.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6044276" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/75c008b1fdc40a2f395a83b01d720359.webp" "ClassName" => "Single Family" "MediaSize" => 319173 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-75c008b1fdc40a2f395a83b01d720359.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6044277" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/7d39996e6952838d9c4a03e6dd464003.webp" "ClassName" => "Single Family" "MediaSize" => 305732 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-7d39996e6952838d9c4a03e6dd464003.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6044278" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/b86458710bc1563a6bd1c0b32941d418.webp" "ClassName" => "Single Family" "MediaSize" => 369141 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-b86458710bc1563a6bd1c0b32941d418.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6044279" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/d40bf4b99427e75fd923c5178a905c7b.webp" "ClassName" => "Single Family" "MediaSize" => 323435 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-d40bf4b99427e75fd923c5178a905c7b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "60442710" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/83778df84249b005b35a809d0e445515.webp" "ClassName" => "Single Family" "MediaSize" => 257571 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-83778df84249b005b35a809d0e445515.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "60442711" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/12f33de84c5badba8740da610ecf2e04.webp" "ClassName" => "Single Family" "MediaSize" => 250055 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-12f33de84c5badba8740da610ecf2e04.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "60442712" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/dd4a1970aed244454ebe121b712d7416.webp" "ClassName" => "Single Family" "MediaSize" => 185247 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-dd4a1970aed244454ebe121b712d7416.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "60442713" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/dd4d2120970e50bc9a84beb3808d0820.webp" "ClassName" => "Single Family" "MediaSize" => 171619 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-dd4d2120970e50bc9a84beb3808d0820.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "60442714" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/eff3a7d98c2dbbb7f23b6d3914898c3f.webp" "ClassName" => "Single Family" "MediaSize" => 329308 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-eff3a7d98c2dbbb7f23b6d3914898c3f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "60442715" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/600b28e8c21b97a1c8cd07fd9de93fdd.webp" "ClassName" => "Single Family" "MediaSize" => 329685 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-600b28e8c21b97a1c8cd07fd9de93fdd.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "60442716" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/ebc5427480877a423c7f570804018736.webp" "ClassName" => "Single Family" "MediaSize" => 394596 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-ebc5427480877a423c7f570804018736.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "60442717" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/e30787223b9d682f4b690d4bf394f54e.webp" "ClassName" => "Single Family" "MediaSize" => 302908 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-e30787223b9d682f4b690d4bf394f54e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "60442718" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/dd211b2a2790b88d52bb9f3de9968b55.webp" "ClassName" => "Single Family" "MediaSize" => 266064 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-dd211b2a2790b88d52bb9f3de9968b55.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "60442719" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/34db62b5fefc7a1bdf3c108b002615a9.webp" "ClassName" => "Single Family" "MediaSize" => 192930 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-34db62b5fefc7a1bdf3c108b002615a9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "60442720" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/1dd07f1774e9e2df42103d69b7c3ed78.webp" "ClassName" => "Single Family" "MediaSize" => 329657 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-1dd07f1774e9e2df42103d69b7c3ed78.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "60442721" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/641d4a5ec8f9becca98dec7aff125f7e.webp" "ClassName" => "Single Family" "MediaSize" => 248006 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-641d4a5ec8f9becca98dec7aff125f7e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "60442722" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/4fbe6481a139156fb2d498c3d302dd41.webp" "ClassName" => "Single Family" "MediaSize" => 384820 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-4fbe6481a139156fb2d498c3d302dd41.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "60442723" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/29e69c953fcb21b240ac84dc4ff662b3.webp" "ClassName" => "Single Family" "MediaSize" => 319108 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-29e69c953fcb21b240ac84dc4ff662b3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 24 => array:11 [ "Order" => 24 "MediaKey" => "60442724" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/95e482ca362f591ceafb35ac6b3379ef.webp" "ClassName" => "Single Family" "MediaSize" => 323185 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-95e482ca362f591ceafb35ac6b3379ef.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 25 => array:11 [ "Order" => 25 "MediaKey" => "60442725" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/f10d41ea25895b670dd9236888a4db4c.webp" "ClassName" => "Single Family" "MediaSize" => 195903 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-f10d41ea25895b670dd9236888a4db4c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 26 => array:11 [ "Order" => 26 "MediaKey" => "60442726" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/32f876aa3a8ddff07d0055b1c412ea63.webp" "ClassName" => "Single Family" "MediaSize" => 346848 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-32f876aa3a8ddff07d0055b1c412ea63.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 27 => array:11 [ "Order" => 27 "MediaKey" => "60442727" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/470ce6e9d7e69c73f97f6d5c439a1c77.webp" "ClassName" => "Single Family" "MediaSize" => 331675 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-470ce6e9d7e69c73f97f6d5c439a1c77.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 28 => array:11 [ "Order" => 28 "MediaKey" => "60442728" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/54709ad68844471fbb8d1e2f0962b20b.webp" "ClassName" => "Single Family" "MediaSize" => 227003 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-54709ad68844471fbb8d1e2f0962b20b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 29 => array:11 [ "Order" => 29 "MediaKey" => "60442729" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/5e8cd00bea3db78ba116ec0917290dfa.webp" "ClassName" => "Single Family" "MediaSize" => 992881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-5e8cd00bea3db78ba116ec0917290dfa.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] 30 => array:11 [ "Order" => 30 "MediaKey" => "60442730" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/604427/8b84972c2fec3a6d20899c5e2efb1de4.webp" "ClassName" => "Single Family" "MediaSize" => 61212 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/604427/thumbnail-8b84972c2fec3a6d20899c5e2efb1de4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "604427" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('604427')" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3214 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "612327" +"ListingId": "612327" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-07-14T13:21:04Z" +"RFModificationTimestamp": "2025-07-14T13:26:22Z" +"ListPrice": 249999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1928.0 +"BuildingAreaTotal": 1928.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "251 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.143742 1 => 33.856872 ] +"Latitude": 33.856872 +"Longitude": -81.143742 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "1766" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "August 2025 Move-In! Just in time to get ready for Fall gatherings! Welcome to your stunning NEW 3-bedroom, 2.5-bath Anderson plan in Lexington County,, perfectly situated for easy commuting in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertops in the kitchen and baths, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. This home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, tiled backsplash, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes 2 full walk-in closets and double vanity bathroom. An additional full bathroom is conveniently located near 2 bedrooms, ideal for privacy from main floor living, hosting overnight guests, or creating a home office. Enjoy the exceptional included features that include 9 foot ceilings on the main level, white square cabinets in 36” and 42” heights with crown moulding, garage coach lights (per plan), large outside patios, gutters and more! Schedule your tour today! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-07-03T19:13:08.550066+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "sharee.hairston@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-07-03" +"PhotosChangeTimestamp": "2025-07-14T13:21:04Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "251" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-036" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "251 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-07-03" +"Lot Size": "0.28" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "37" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Double Vanity,Bath-Shared,Closet-Walk in,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Loft" +"# of Stories": "2" +"Garage Level": "Main" +"LA1User Code": "HAIRSTS" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Full Baths-2nd": "2" +"Half Baths-2nd": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "129.67" +"Agent Hit Count": "33" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Elementary School": "Congaree" +"Full Baths- Lower": "0" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"LA1Agent Last Name": "Hairston" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Sharee" +"List Price Tot SqFt": "129.67" +"Geo Update Timestamp": "2025-07-03T19:04:28.4" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "251" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-07-03T19:04:29.4" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6123270" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/03c6bf8c96438dcd3d9128787ca360b9.webp" "ClassName" => "Single Family" "MediaSize" => 458897 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-03c6bf8c96438dcd3d9128787ca360b9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6123271" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/f7d291c2dcb02ca4937c86df551d7198.webp" "ClassName" => "Single Family" "MediaSize" => 111103 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-f7d291c2dcb02ca4937c86df551d7198.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6123272" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/0b8de02b4017cf7c1d3f00832b708871.webp" "ClassName" => "Single Family" "MediaSize" => 120610 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-0b8de02b4017cf7c1d3f00832b708871.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6123273" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/d20d92fe08c512bd40a35acb37596b47.webp" "ClassName" => "Single Family" "MediaSize" => 45874 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-d20d92fe08c512bd40a35acb37596b47.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6123274" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/e871a2194666efdd376adef281d2ffc8.webp" "ClassName" => "Single Family" "MediaSize" => 406255 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-e871a2194666efdd376adef281d2ffc8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6123275" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/237b02f4f65e643e95f04a8d7199dcf3.webp" "ClassName" => "Single Family" "MediaSize" => 376988 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-237b02f4f65e643e95f04a8d7199dcf3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6123276" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/553028d595d8cd55f5500a477c5a6785.webp" "ClassName" => "Single Family" "MediaSize" => 323135 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-553028d595d8cd55f5500a477c5a6785.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6123277" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/28749bf9018243b9fb3fdf8e4e0fc188.webp" "ClassName" => "Single Family" "MediaSize" => 313849 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-28749bf9018243b9fb3fdf8e4e0fc188.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6123278" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/4bf77c5c2b23ea2ece04c785ebdec151.webp" "ClassName" => "Single Family" "MediaSize" => 259886 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-4bf77c5c2b23ea2ece04c785ebdec151.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6123279" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/b65861b6c5fe0cd570cae5072fb7d837.webp" "ClassName" => "Single Family" "MediaSize" => 245228 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-b65861b6c5fe0cd570cae5072fb7d837.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61232710" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/6ce6b5be58131b27919b56a0c66126ad.webp" "ClassName" => "Single Family" "MediaSize" => 143489 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-6ce6b5be58131b27919b56a0c66126ad.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61232711" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/ab28ed501d3a8f668ac7afb622d862db.webp" "ClassName" => "Single Family" "MediaSize" => 335508 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-ab28ed501d3a8f668ac7afb622d862db.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61232712" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/8c38983a335c52cefe45456a42542e74.webp" "ClassName" => "Single Family" "MediaSize" => 315888 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-8c38983a335c52cefe45456a42542e74.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61232713" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/6af56cf275197f9c4589b3df1caa4241.webp" "ClassName" => "Single Family" "MediaSize" => 190201 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-6af56cf275197f9c4589b3df1caa4241.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61232714" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/7af5dc3c8d2689a6af1a1577da391148.webp" "ClassName" => "Single Family" "MediaSize" => 379032 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-7af5dc3c8d2689a6af1a1577da391148.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "61232715" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/d45ab09f6cd325b7dd37ef2873d93f00.webp" "ClassName" => "Single Family" "MediaSize" => 382692 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-d45ab09f6cd325b7dd37ef2873d93f00.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "61232716" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/9b08fa765d4aa3bd3c6c6760a4a181a8.webp" "ClassName" => "Single Family" "MediaSize" => 291053 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-9b08fa765d4aa3bd3c6c6760a4a181a8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "61232717" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/d8cc2c2810f0710f1b2cfe8a55617b27.webp" "ClassName" => "Single Family" "MediaSize" => 166231 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-d8cc2c2810f0710f1b2cfe8a55617b27.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "61232718" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/857b4e0d4e29d28e2b1b7a944abacd67.webp" "ClassName" => "Single Family" "MediaSize" => 143014 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-857b4e0d4e29d28e2b1b7a944abacd67.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "61232719" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/6378ed664c439a1262e61e5ba03eecdb.webp" "ClassName" => "Single Family" "MediaSize" => 209613 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-6378ed664c439a1262e61e5ba03eecdb.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "61232720" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/908acf4bc4bce74057f9741ce22f4531.webp" "ClassName" => "Single Family" "MediaSize" => 172664 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-908acf4bc4bce74057f9741ce22f4531.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "61232721" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/69ef389f0783b9ba556148aa4cff6146.webp" "ClassName" => "Single Family" "MediaSize" => 245044 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-69ef389f0783b9ba556148aa4cff6146.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "61232722" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/3689f4e4488076286612d00a9a390bd7.webp" "ClassName" => "Single Family" "MediaSize" => 992881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-3689f4e4488076286612d00a9a390bd7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "61232723" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/612327/5dd484667b2d79174d65a9c9fd923484.webp" "ClassName" => "Single Family" "MediaSize" => 91583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/612327/thumbnail-5dd484667b2d79174d65a9c9fd923484.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "612327" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('612327')" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3216 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "609114" +"ListingId": "609114" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-24T19:15:05Z" +"RFModificationTimestamp": "2025-06-27T09:08:25Z" +"ListPrice": 254999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1755.0 +"BuildingAreaTotal": 1755.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "243 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.143517 1 => 33.85668 ] +"Latitude": 33.85668 +"Longitude": -81.143517 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "August 2025 Move In! Welcome to your open concept NEW 4-bedroom, 2.5-bath Crane plan in Lexington County, perfectly situated in Heron Pointe; a location great for easy commuting located in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertops in the kitchen, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. This home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes a full walk in closet and double vanity bathroom. An additional full bathroom is also located near the 3 quaint bedrooms. You will also love your new versatile loft space, ideal for another living area while hosting overnight guests with a pull out couch, or creating a home office or an exercise room. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-05-21T20:36:04.712924+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-05-21" +"PhotosChangeTimestamp": "2025-06-24T19:15:05Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "243" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/558/modelhome/2926/virtualtour/2933" +"WaterSource": "Well" +"Baths Full": "2" +"2nd Bedroom": "Double Vanity,Bath-Shared,Closet-Walk in,Floors - Carpet" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Address": "243 Hazel Rain Road" +"Assn Fee": "411" +"Great Room": "Floors-Luxury Vinyl Plank" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"New/Resale": "New" +"# of Stories": "2.5" +"Baths": "3" +"LO1Office Identifier": "1577" +"Power On": "No" +"LO1Main Office ID": "1577" +"Level-Kitchen": "Main" +"Half Baths-Main": "1" +"Full Baths-Main": "0" +"Price Per SQFT": "145.3" +"LO1Office Abbreviation": "LENC01" +"Range": "Gas" +"High School": "Airport" +"Agent Hit Count": "75" +"Garage Spaces": "2" +"Level-Washer Dryer": "Main" +"LA1User Code": "JGOULD" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"LA1Agent First Name": "Jeremy" +"Baths Combo": "2 / 1" +"Garage Level": "Main" +"Half Baths-2nd": "0" +"Address Search Number": "243" +"Lot Number": "35" +"Level-Master Bedroom": "Second" +"School District": "Lexington Two" +"LVT Date": "2025-05-21" +"Middle School": "Pine Ridge" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Interior # of Fireplaces": "0" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Energy": "Thermopane" +"Other Heated SqFt": "0" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "RE_1" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Level-Bedroom 3": "Second" +"Level-Great Room": "Main" +"Level-Bedroom 4": "Second" +"Rollback Tax (Y/N)": "No" +"IDX Include": "Yes" +"Level-Bedroom 2": "Second" +"List Price Tot SqFt": "145.3" +"LA1Agent Middle Initial": "M" +"Full Baths-2nd": "2" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-05-21T20:26:41.8" +"Garage": "Garage Attached, Front Entry" +"LA1Agent Last Name": "Gould" +"Assn/Regime Fee Per": "6 Months" +"Full Baths- Lower": "0" +"TMS": "008902-01-035" +"Geo Update Timestamp": "2025-05-21T20:26:40.8" +"Other Rooms": "Loft" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6091140" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/4cdb0a6fb72fa5b8aa069cb9af063a51.webp" "MediaSize" => 476661 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-4cdb0a6fb72fa5b8aa069cb9af063a51.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6091141" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/5fa3c5072192470bb8140b5b20f3eae6.webp" "MediaSize" => 99568 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-5fa3c5072192470bb8140b5b20f3eae6.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6091142" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/caed92d9bc39bf73761f98346b961aca.webp" "MediaSize" => 117957 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-caed92d9bc39bf73761f98346b961aca.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6091143" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/4bad2662d8fdf9eaf65fe76a0a88b750.webp" "MediaSize" => 46032 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-4bad2662d8fdf9eaf65fe76a0a88b750.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6091144" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/6617dea89daa2c1ff26008090b7209ec.webp" "MediaSize" => 302786 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-6617dea89daa2c1ff26008090b7209ec.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6091145" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/b7232ff7a7105721bc74b2a4143bcbf8.webp" "MediaSize" => 371921 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-b7232ff7a7105721bc74b2a4143bcbf8.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6091146" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/98e76ef3f0500202cb43cd3645897d4e.webp" "MediaSize" => 327530 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-98e76ef3f0500202cb43cd3645897d4e.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6091147" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/9b281d34e5f16a60d9b765c6c040a8ea.webp" "MediaSize" => 305892 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-9b281d34e5f16a60d9b765c6c040a8ea.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6091148" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/0c3cff3c182dacde591db09331cee299.webp" "MediaSize" => 377569 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-0c3cff3c182dacde591db09331cee299.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6091149" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/0d8c3f2ba598451676bb2f47ece144a6.webp" "MediaSize" => 302655 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-0d8c3f2ba598451676bb2f47ece144a6.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "60911410" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/cd139b2fefa2d56453db7e937b1d4c85.webp" "MediaSize" => 337276 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-cd139b2fefa2d56453db7e937b1d4c85.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "60911411" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/eef209cb4b0a0d1424a91ec9c0341784.webp" "MediaSize" => 368552 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-eef209cb4b0a0d1424a91ec9c0341784.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "60911412" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/889e91d113f5659678537c40efe4d317.webp" "MediaSize" => 291549 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-889e91d113f5659678537c40efe4d317.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "60911413" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/e2f0fa71dad93acc0a41adf0cf208fb5.webp" "MediaSize" => 304455 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-e2f0fa71dad93acc0a41adf0cf208fb5.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "60911414" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/921de4c7baeb2e209fda522543340c80.webp" "MediaSize" => 348880 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-921de4c7baeb2e209fda522543340c80.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "60911415" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/7baae0f6fed588b827cc4a018f6833a0.webp" "MediaSize" => 300815 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-7baae0f6fed588b827cc4a018f6833a0.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "60911416" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/faff27e518c09600a5aa374101b63f66.webp" "MediaSize" => 231951 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-faff27e518c09600a5aa374101b63f66.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "60911417" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/01ab837fb06cc229cb86761eda8f54fc.webp" "MediaSize" => 278304 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-01ab837fb06cc229cb86761eda8f54fc.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "60911418" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/742a0227086c9dbf2b98c4193bb54df7.webp" "MediaSize" => 350340 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-742a0227086c9dbf2b98c4193bb54df7.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "60911419" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/c44f3011ece36fa34d6ae8b568c1b87a.webp" "MediaSize" => 371021 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-c44f3011ece36fa34d6ae8b568c1b87a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "60911420" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/30aada9110ffa75e56d5aabc4dc5a80b.webp" "MediaSize" => 222835 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-30aada9110ffa75e56d5aabc4dc5a80b.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "60911421" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/e96cca42889295bb29eaf79f7b7003b1.webp" "MediaSize" => 262906 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-e96cca42889295bb29eaf79f7b7003b1.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "60911422" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/2311e4caccd7193016293e0e44c7fd29.webp" "MediaSize" => 992881 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-2311e4caccd7193016293e0e44c7fd29.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "60911423" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/7ea44cfc6536a16b51b407a026c22e3a.webp" "MediaSize" => 61212 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-7ea44cfc6536a16b51b407a026c22e3a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('609114')" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3217 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "606899" +"ListingId": "606899" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-16T15:14:02Z" +"RFModificationTimestamp": "2025-06-16T15:20:03Z" +"ListPrice": 272999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.28 +"LivingArea": 1955.0 +"BuildingAreaTotal": 1955.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "235 Hazel Rain Road, Gaston, Sc 29053" +"Coordinates": array:2 [ 0 => -81.143283 1 => 33.856488 ] +"Latitude": 33.856488 +"Longitude": -81.143283 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "July 2025 Move In! Welcome to your open concept NEW 4-bedroom, 2.5-bath Crane plan in Lexington County, perfectly situated in Heron Pointe; a location great for easy commuting located in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertops in the kitchen, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. This home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes a full walk in closet and double vanity bathroom. An additional full bathroom is also located near the 3 quaint bedrooms. You will also love your new versatile loft space, ideal for another living area while hosting overnight guests with a pull out couch, or creating a home office or an exercise room. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-04-21T17:43:55.351540+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-04-21" +"PhotosChangeTimestamp": "2025-06-16T15:14:02Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "235" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"Baths Full": "2" +"2nd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Address": "235 Hazel Rain Road" +"Assn Fee": "411" +"Great Room": "Floors-Luxury Vinyl Plank" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"New/Resale": "New" +"# of Stories": "2" +"Baths": "3" +"LO1Office Identifier": "1577" +"Power On": "No" +"LO1Main Office ID": "1577" +"Level-Kitchen": "Main" +"Half Baths-Main": "1" +"Full Baths-Main": "0" +"Price Per SQFT": "139.64" +"LO1Office Abbreviation": "LENC01" +"Range": "Gas" +"High School": "Airport" +"Agent Hit Count": "121" +"Garage Spaces": "2" +"Level-Washer Dryer": "Main" +"LA1User Code": "JGOULD" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"LA1Agent First Name": "Jeremy" +"Baths Combo": "2 / 1" +"Garage Level": "Main" +"Half Baths-2nd": "0" +"Address Search Number": "235" +"Lot Number": "33" +"Level-Master Bedroom": "Second" +"School District": "Lexington Two" +"LVT Date": "2025-04-21" +"Middle School": "Pine Ridge" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Interior # of Fireplaces": "0" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Energy": "Thermopane" +"Other Heated SqFt": "0" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "RE_1" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Level-Bedroom 3": "Second" +"Level-Great Room": "Main" +"Level-Bedroom 4": "Second" +"Rollback Tax (Y/N)": "No" +"IDX Include": "Yes" +"Level-Bedroom 2": "Second" +"List Price Tot SqFt": "139.64" +"LA1Agent Middle Initial": "M" +"Full Baths-2nd": "2" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-04-21T17:32:20.8" +"Garage": "Garage Attached, Front Entry" +"LA1Agent Last Name": "Gould" +"Assn/Regime Fee Per": "6 Months" +"Full Baths- Lower": "0" +"TMS": "008902-01-033" +"Geo Update Timestamp": "2025-04-21T17:32:19.8" +"Other Rooms": "Loft" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6068990" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/3141d5c84ceabbc569df28ae0166afc1.webp" "MediaSize" => 354947 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-3141d5c84ceabbc569df28ae0166afc1.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6068991" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/8356bf159b7718f33e168b2546d85dfc.webp" "MediaSize" => 99568 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-8356bf159b7718f33e168b2546d85dfc.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6068992" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/7f29c656ca30ba371a26c2679ef9becb.webp" "MediaSize" => 117957 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-7f29c656ca30ba371a26c2679ef9becb.webp" …2 ] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] 22 => array:11 [ …11] 23 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('606899')" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3218 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "605499" +"ListingId": "605499" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-05-02T13:02:01Z" +"RFModificationTimestamp": "2025-05-02T13:07:24Z" +"ListPrice": 292249.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.26 +"LivingArea": 1955.0 +"BuildingAreaTotal": 1955.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "226 Hazel Rain Road, Gaston, Sc 29053" +"Coordinates": array:2 [ 0 => -81.142299 1 => 33.856772 ] +"Latitude": 33.856772 +"Longitude": -81.142299 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "June 2025 Move In! Welcome to your open concept NEW 4-bedroom, 2.5-bath Crane plan in Lexington County, perfectly situated in Heron Pointe; a location great for easy commuting located in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant granite countertops in the kitchen, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. This home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes a full walk in closet and double vanity bathroom. An additional full bathroom is also located near the 3 quaint bedrooms. You will also love your new versatile loft space, ideal for another living area while hosting overnight guests with a pull out couch, or creating a home office or an exercise room. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-04-02T20:00:55.734362+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-04-01" +"PhotosChangeTimestamp": "2025-05-02T13:02:01Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Counter Tops-Granite,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "226" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"Baths Full": "2" +"2nd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Address": "226 Hazel Rain Road" +"Assn Fee": "411" +"Great Room": "Floors-Luxury Vinyl Plank" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"New/Resale": "New" +"# of Stories": "2" +"Baths": "3" +"LO1Office Identifier": "1577" +"Power On": "No" +"LO1Main Office ID": "1577" +"Level-Kitchen": "Main" +"Half Baths-Main": "1" +"Full Baths-Main": "0" +"Price Per SQFT": "149.49" +"LO1Office Abbreviation": "LENC01" +"Range": "Gas" +"High School": "Airport" +"Agent Hit Count": "82" +"Garage Spaces": "2" +"Level-Washer Dryer": "Main" +"LA1User Code": "JGOULD" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"LA1Agent First Name": "Jeremy" +"Baths Combo": "2 / 1" +"Garage Level": "Main" +"Half Baths-2nd": "0" +"Address Search Number": "226" +"Lot Number": "56" +"Level-Master Bedroom": "Second" +"School District": "Lexington Two" +"LVT Date": "2025-04-02" +"Middle School": "Pine Ridge" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Interior # of Fireplaces": "0" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Energy": "Thermopane" +"Other Heated SqFt": "0" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "RE_1" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Level-Bedroom 3": "Second" +"Level-Great Room": "Main" +"Level-Bedroom 4": "Second" +"Rollback Tax (Y/N)": "No" +"IDX Include": "Yes" +"Level-Bedroom 2": "Second" +"List Price Tot SqFt": "149.49" +"LA1Agent Middle Initial": "M" +"Full Baths-2nd": "2" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-04-02T19:28:22.3" +"Garage": "Garage Attached, Front Entry" +"LA1Agent Last Name": "Gould" +"Assn/Regime Fee Per": "6 Months" +"Full Baths- Lower": "0" +"TMS": "008902-01-056" +"Geo Update Timestamp": "2025-04-02T19:28:20.9" +"Other Rooms": "Loft" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] 22 => array:11 [ …11] 23 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('605499')" } ] +success: true +page_size: 10 +page_count: 3 +count: 27 +after_key: "" } ] ]
