Sprinkler,Gutters - Partial,Front Porch - Covered
25 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: 2a66f81eabb5f8a08a847537f22019b49391aaace448a24ca765b0c51a116833" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3992 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "615645" +"ListingId": "615645" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-09-26T19:14:02Z" +"RFModificationTimestamp": "2025-09-26T19:31:04Z" +"ListPrice": 285999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.4 +"LivingArea": 2577.0 +"BuildingAreaTotal": 2577.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "547 Happy Hollow Drive, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.1411704369 1 => 33.8577141919 ] +"Latitude": 33.8577141919 +"Longitude": -81.1411704369 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Move-in November 2025! Welcome to your stunning NEW 5-bedroom, 3-bath Frost plan in Lexington County, SC, perfectly situated for easy commuting in Gaston, SC. Featuring a first-floor private suite, this home has all the features a homeowner wants in a new home! 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.The open kitchen has spacious counters, tiled backsplash, an expansive island, large walk-in pantry, and modern stainless-steel appliances, including a gas stove, microwave and dishwasher. Located on the first floor is a full bedroom/suite, perfect for overnight guests or family members. The second- floor owner’s suite includes 2 full walk-in closets and double vanity bathroom. On the second floor a third full bathroom is conveniently located near 3 additional bedrooms as well as a versatile entertainment room, ideal for privacy from main floor living, hosting overnight guests, or creating a home office. 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": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-08-19T19:57:19.740500+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": "Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OpenParkingSpaces": "2" +"OriginalEntryTimestamp": "2025-08-19" +"PhotosChangeTimestamp": "2025-09-26T19: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": "Happy Hollow" +"StreetNumber": "547" +"StreetSuffix": "Drive" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/656/modelhome/3208/virtualtour/3219" +"WaterSource": "Well" +"TMS": "008902-01-145" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "547 Happy Hollow Drive" +"Assn Fee": "411" +"LVT Date": "2025-08-19" +"Baths Full": "3" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "145" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Bath-Shared,Closet-Private,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Closet-Private,Floors - Carpet" +"4th Bedroom": "Bath-Shared,Closet-Walk in,Closet-Private,Floors - Carpet" +"5th Bedroom": "Bath-Shared,Closet-Walk in,Closet-Private,Floors-Luxury Vinyl Plank" +"Baths Combo": "3 / 0" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Media Room" +"# 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" +"Master Bedroom": "Double Vanity,Closet-His & Her,Bath-Private,Separate Shower,Closet-Walk in,Closet-Private,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "110.98" +"Agent Hit Count": "86" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Main": "1" +"Half Baths-Main": "0" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"Level-Bedroom 5": "Main" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"Formal Dining Room": "Area,Floors-Luxury Vinyl Plank" +"LA1Agent Last Name": "Gould" +"Level-Washer Dryer": "Second" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "110.98" +"Geo Update Timestamp": "2025-08-19T19:47:41.7" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "547" +"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-08-19T19:47:42.6" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6156450" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/0c14d3feb5b092064305abbe1e053835.webp" "ClassName" => "Single Family" "MediaSize" => 574467 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-0c14d3feb5b092064305abbe1e053835.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6156451" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/b66b598976f589c76a013c1e72d44ffd.webp" "ClassName" => "Single Family" "MediaSize" => 119515 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-b66b598976f589c76a013c1e72d44ffd.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6156452" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/480ec79d2cc303c6b50e8a7a855c896f.webp" "ClassName" => "Single Family" "MediaSize" => 121506 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-480ec79d2cc303c6b50e8a7a855c896f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6156453" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/6fd99de9e56c362c64fe863da2880413.webp" "ClassName" => "Single Family" "MediaSize" => 44379 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-6fd99de9e56c362c64fe863da2880413.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6156454" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/7664f9eb71d79114fed0590a33544696.webp" "ClassName" => "Single Family" "MediaSize" => 218687 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-7664f9eb71d79114fed0590a33544696.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6156455" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/450ebe5e2d7f0d4e46e1e85301e08178.webp" "ClassName" => "Single Family" "MediaSize" => 312332 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-450ebe5e2d7f0d4e46e1e85301e08178.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6156456" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/0b7f4deea60e110d370c6ff652063876.webp" "ClassName" => "Single Family" "MediaSize" => 341367 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-0b7f4deea60e110d370c6ff652063876.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6156457" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/e94e10e84bb0143a9e57e7f84297e4ec.webp" "ClassName" => "Single Family" "MediaSize" => 291907 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-e94e10e84bb0143a9e57e7f84297e4ec.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6156458" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/79a29680abdfd095d453767bfb8f88f1.webp" "ClassName" => "Single Family" "MediaSize" => 178774 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-79a29680abdfd095d453767bfb8f88f1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6156459" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/afd139f95d2b72d0981f01340e2d71e4.webp" "ClassName" => "Single Family" "MediaSize" => 297244 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-afd139f95d2b72d0981f01340e2d71e4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61564510" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/6fa8ad801ddd445e122ab2b9ee4ab9d4.webp" "ClassName" => "Single Family" "MediaSize" => 358620 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-6fa8ad801ddd445e122ab2b9ee4ab9d4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61564511" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/293dd3e73ce68d0f9d46a476338da0f4.webp" "ClassName" => "Single Family" "MediaSize" => 175692 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-293dd3e73ce68d0f9d46a476338da0f4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61564512" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/63beedbfef2c20b63cf6b56ed970d486.webp" "ClassName" => "Single Family" "MediaSize" => 330846 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-63beedbfef2c20b63cf6b56ed970d486.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61564513" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/5237ad6f368564ace9eb7c7a651a30b3.webp" "ClassName" => "Single Family" "MediaSize" => 335326 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-5237ad6f368564ace9eb7c7a651a30b3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61564514" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/f519dc8a58625e4b9006e6ab8dda6a85.webp" "ClassName" => "Single Family" "MediaSize" => 263922 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-f519dc8a58625e4b9006e6ab8dda6a85.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "61564515" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/064eccbc1485b0573593e188ad504169.webp" "ClassName" => "Single Family" "MediaSize" => 283427 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-064eccbc1485b0573593e188ad504169.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "61564516" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/7d3b4367735576f00454845cb67a6492.webp" "ClassName" => "Single Family" "MediaSize" => 296864 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-7d3b4367735576f00454845cb67a6492.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "61564517" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/69324db3bdadd7e5cccb24ff366456b1.webp" "ClassName" => "Single Family" "MediaSize" => 271189 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-69324db3bdadd7e5cccb24ff366456b1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "61564518" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/7ad5a3e135b6767085c2624f84337543.webp" "ClassName" => "Single Family" "MediaSize" => 174790 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-7ad5a3e135b6767085c2624f84337543.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "61564519" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/d7856d3ba0a97a1a19bee9a1bf827c71.webp" "ClassName" => "Single Family" "MediaSize" => 302534 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-d7856d3ba0a97a1a19bee9a1bf827c71.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "61564520" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/be98970d11fe1a60e02162627c7c123e.webp" "ClassName" => "Single Family" "MediaSize" => 286901 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-be98970d11fe1a60e02162627c7c123e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "61564521" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/b5af1dc7f8347868c5dfb0125622bcd7.webp" "ClassName" => "Single Family" "MediaSize" => 217276 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-b5af1dc7f8347868c5dfb0125622bcd7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "61564522" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/de87b513ea8ed8368d53a1422f18dad2.webp" "ClassName" => "Single Family" "MediaSize" => 992881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-de87b513ea8ed8368d53a1422f18dad2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "61564523" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615645/cda4816f3d1c48d6c9a1ff97a5548f7c.webp" "ClassName" => "Single Family" "MediaSize" => 91583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615645/thumbnail-cda4816f3d1c48d6c9a1ff97a5548f7c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615645" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('615645')" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3209 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "615743" +"ListingId": "615743" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-09-23T14:42:59Z" +"RFModificationTimestamp": "2025-09-23T14:47:16Z" +"ListPrice": 249999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.29 +"LivingArea": 1955.0 +"BuildingAreaTotal": 1955.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "615 Blue Jay Avenue, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.1417068787 1 => 33.857072707 ] +"Latitude": 33.857072707 +"Longitude": -81.1417068787 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "November 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 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": "Brick-Partial-AbvFound,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-08-21T13:17:18.604210+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-08-21" +"PhotosChangeTimestamp": "2025-09-23T14:42:59Z" +"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": "Blue Jay" +"StreetNumber": "615" +"StreetSuffix": "Avenue" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-151" +"Baths": "3" +"Range": "Free-standing,Smooth Surface" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "615 Blue Jay Avenue" +"Assn Fee": "411" +"LVT Date": "2025-08-21" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "151" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "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": "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": "127.88" +"Agent Hit Count": "114" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"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": "127.88" +"Geo Update Timestamp": "2025-08-21T13:15:01.3" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "615" +"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-08-21T13:15:02.5" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6157430" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/bf8d25bee13239434e816f2f1a4aa933.webp" "ClassName" => "Single Family" "MediaSize" => 358191 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-bf8d25bee13239434e816f2f1a4aa933.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6157431" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/37e4ae290908cc25d494a8116aa1c63e.webp" "ClassName" => "Single Family" "MediaSize" => 99568 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-37e4ae290908cc25d494a8116aa1c63e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6157432" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/46b8508329f88ff4d18a56eef44b37ad.webp" "ClassName" => "Single Family" "MediaSize" => 117957 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-46b8508329f88ff4d18a56eef44b37ad.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6157433" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/d20b3d1ef215565714c1327b81cc8e77.webp" "ClassName" => "Single Family" "MediaSize" => 46058 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-d20b3d1ef215565714c1327b81cc8e77.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6157434" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/4742ab032c2aa32d028a8694a2424f5f.webp" "ClassName" => "Single Family" "MediaSize" => 302786 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-4742ab032c2aa32d028a8694a2424f5f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6157435" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/a3847ca11de9356947be7c45cca61b2f.webp" "ClassName" => "Single Family" "MediaSize" => 371921 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-a3847ca11de9356947be7c45cca61b2f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6157436" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/0f789b2685693671bbc6b651a1c8b3ee.webp" "ClassName" => "Single Family" "MediaSize" => 327530 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-0f789b2685693671bbc6b651a1c8b3ee.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6157437" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/b0caa49c86a2898d7c07c78516714e12.webp" "ClassName" => "Single Family" "MediaSize" => 305892 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-b0caa49c86a2898d7c07c78516714e12.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6157438" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/73d3a37605046c185e7c4c854e4c7070.webp" "ClassName" => "Single Family" "MediaSize" => 377569 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-73d3a37605046c185e7c4c854e4c7070.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6157439" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/eb8c7bcc89288694c2a32f798c09b8fb.webp" "ClassName" => "Single Family" "MediaSize" => 302655 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-eb8c7bcc89288694c2a32f798c09b8fb.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61574310" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/64872824192b99cde855047081bdd3ba.webp" "ClassName" => "Single Family" "MediaSize" => 337276 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-64872824192b99cde855047081bdd3ba.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61574311" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/10d0f7cce0ccf06dbd5487e296a01fe0.webp" "ClassName" => "Single Family" "MediaSize" => 368552 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-10d0f7cce0ccf06dbd5487e296a01fe0.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61574312" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/5d4a75b05950497e14ccd426696bf020.webp" "ClassName" => "Single Family" "MediaSize" => 291549 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-5d4a75b05950497e14ccd426696bf020.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61574313" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/6a3fa94b4def39979e651228343516b0.webp" "ClassName" => "Single Family" "MediaSize" => 304455 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-6a3fa94b4def39979e651228343516b0.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61574314" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/6bcb41a0939fdd873bf6307e86a09191.webp" "ClassName" => "Single Family" "MediaSize" => 348880 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-6bcb41a0939fdd873bf6307e86a09191.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "61574315" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/bd7f5908d1e7882ee9eee1e9243c3ca8.webp" "ClassName" => "Single Family" "MediaSize" => 300815 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-bd7f5908d1e7882ee9eee1e9243c3ca8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "61574316" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/3ced280794ae17138e7ccd553d78ffa6.webp" "ClassName" => "Single Family" "MediaSize" => 231951 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-3ced280794ae17138e7ccd553d78ffa6.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "61574317" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/07d70a31b5d8e7ee1bd6b0ac6bbf4cc6.webp" "ClassName" => "Single Family" "MediaSize" => 278304 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-07d70a31b5d8e7ee1bd6b0ac6bbf4cc6.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "61574318" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/bf465bed22b635092b63e9ee3c60aa6b.webp" "ClassName" => "Single Family" "MediaSize" => 350340 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-bf465bed22b635092b63e9ee3c60aa6b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "61574319" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/b4d8ff1b287f8a2d323ad21a55e3dd3e.webp" "ClassName" => "Single Family" "MediaSize" => 371021 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-b4d8ff1b287f8a2d323ad21a55e3dd3e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "61574320" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/1d2860c294157fc3685203c714f8a0f3.webp" "ClassName" => "Single Family" "MediaSize" => 222835 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-1d2860c294157fc3685203c714f8a0f3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "61574321" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/8116f2e62faddbf47a677578a12837a8.webp" "ClassName" => "Single Family" "MediaSize" => 262906 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-8116f2e62faddbf47a677578a12837a8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "61574322" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/504c25331a9ed1f5affe785318e1aab8.webp" "ClassName" => "Single Family" "MediaSize" => 992881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-504c25331a9ed1f5affe785318e1aab8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "61574323" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615743/a3a05fb196ad4270d9f8463223b5506e.webp" "ClassName" => "Single Family" "MediaSize" => 61212 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615743/thumbnail-a3a05fb196ad4270d9f8463223b5506e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615743" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('615743')" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3207 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "615647" +"ListingId": "615647" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-09-18T15:14:37Z" +"RFModificationTimestamp": "2025-09-18T15:20:51Z" +"ListPrice": 284999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.33 +"LivingArea": 2577.0 +"BuildingAreaTotal": 2577.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "607 Blue Jay Avenue, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.1416425056 1 => 33.8576072781 ] +"Latitude": 33.8576072781 +"Longitude": -81.1416425056 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Move-in November 2025! Welcome to your stunning NEW 5-bedroom, 3-bath Frost plan in Lexington County, SC, perfectly situated for easy commuting in Gaston, SC. Featuring a first-floor private suite, this home has all the features a homeowner wants in a new home! 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.The open kitchen has spacious counters, tiled backsplash, an expansive island, large walk-in pantry, and modern stainless-steel appliances, including a stove, microwave and dishwasher. Located on the first floor is a full bedroom/suite, perfect for overnight guests or family members. The second- floor owner’s suite includes 2 full walk-in closets and double vanity bathroom. On the second floor a third full bathroom is conveniently located near 3 additional bedrooms as well as a versatile entertainment room, ideal for privacy from main floor living, hosting overnight guests, or creating a home office. 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": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-08-19T19:56:29.660016+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": "Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OpenParkingSpaces": "2" +"OriginalEntryTimestamp": "2025-08-19" +"PhotosChangeTimestamp": "2025-09-18T15:14:37Z" +"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": "Blue Jay" +"StreetNumber": "607" +"StreetSuffix": "Avenue" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/656/modelhome/3208/virtualtour/3219" +"WaterSource": "Well" +"TMS": "008902-01-150" +"Baths": "3" +"Range": "Free-standing,Smooth Surface" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "607 Blue Jay Avenue" +"Assn Fee": "411" +"LVT Date": "2025-08-19" +"Baths Full": "3" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "150" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Bath-Shared,Closet-Private,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Closet-Private,Floors - Carpet" +"4th Bedroom": "Bath-Shared,Closet-Walk in,Closet-Private,Floors - Carpet" +"5th Bedroom": "Bath-Shared,Closet-Walk in,Closet-Private,Floors-Luxury Vinyl Plank" +"Baths Combo": "3 / 0" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Media Room" +"# 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" +"Master Bedroom": "Double Vanity,Closet-His & Her,Bath-Private,Separate Shower,Closet-Walk in,Closet-Private,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "110.59" +"Agent Hit Count": "82" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Main": "1" +"Half Baths-Main": "0" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"Level-Bedroom 5": "Main" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"Formal Dining Room": "Area,Floors-Luxury Vinyl Plank" +"LA1Agent Last Name": "Gould" +"Level-Washer Dryer": "Second" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "110.59" +"Geo Update Timestamp": "2025-08-19T19:50:02.6" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "607" +"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-08-19T19:50:03.2" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6156470" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/fb789bf929dd4061715fce1fadd45e63.webp" "ClassName" => "Single Family" "MediaSize" => 574467 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-fb789bf929dd4061715fce1fadd45e63.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6156471" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/bf9ee4faa8a34bbeecc51a54e039bb26.webp" "ClassName" => "Single Family" "MediaSize" => 119515 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-bf9ee4faa8a34bbeecc51a54e039bb26.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6156472" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/9cb5ec8ae2bcc005203d03e3cf07b063.webp" "ClassName" => "Single Family" "MediaSize" => 121506 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-9cb5ec8ae2bcc005203d03e3cf07b063.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6156473" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/9f42e26dd583b6beb552255c4063f006.webp" "ClassName" => "Single Family" "MediaSize" => 44501 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-9f42e26dd583b6beb552255c4063f006.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6156474" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/1dce7f7b0e457ec69b77423cfead6e3c.webp" "ClassName" => "Single Family" "MediaSize" => 218687 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-1dce7f7b0e457ec69b77423cfead6e3c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6156475" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/fa50492d0c4a3071af14f977966d365e.webp" "ClassName" => "Single Family" "MediaSize" => 312332 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-fa50492d0c4a3071af14f977966d365e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6156476" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/63c8017f5109b30233e844bef261c2e1.webp" "ClassName" => "Single Family" "MediaSize" => 341367 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-63c8017f5109b30233e844bef261c2e1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6156477" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/e8c10de81e1f3cb06f8a59b1c0fc37a4.webp" "ClassName" => "Single Family" "MediaSize" => 291907 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-e8c10de81e1f3cb06f8a59b1c0fc37a4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6156478" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/377e47f27cd56afd0821c9f2028ce5f7.webp" "ClassName" => "Single Family" "MediaSize" => 178774 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-377e47f27cd56afd0821c9f2028ce5f7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6156479" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/a19159266e830d98f18095b2e200b0d6.webp" "ClassName" => "Single Family" "MediaSize" => 297244 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-a19159266e830d98f18095b2e200b0d6.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61564710" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/78bb4225169c3081b2224755669d6f76.webp" "ClassName" => "Single Family" "MediaSize" => 358620 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-78bb4225169c3081b2224755669d6f76.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61564711" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/03b9d9cc0b67db976c3658060e8c9513.webp" "ClassName" => "Single Family" "MediaSize" => 175692 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-03b9d9cc0b67db976c3658060e8c9513.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61564712" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/445a04daf6c9ba18322a88b9d531182b.webp" "ClassName" => "Single Family" "MediaSize" => 330846 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-445a04daf6c9ba18322a88b9d531182b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61564713" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/e86b9224c1b85ec89db5cff5b979dc47.webp" "ClassName" => "Single Family" "MediaSize" => 335326 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-e86b9224c1b85ec89db5cff5b979dc47.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61564714" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/46d194ba92735979b29abc5a5687b663.webp" "ClassName" => "Single Family" "MediaSize" => 263922 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-46d194ba92735979b29abc5a5687b663.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "61564715" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/7f14bf6e2ae9577253528eae6a14f30d.webp" "ClassName" => "Single Family" "MediaSize" => 283427 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-7f14bf6e2ae9577253528eae6a14f30d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "61564716" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/b07f681d6f1ab35e868006e2c2ec21bb.webp" "ClassName" => "Single Family" "MediaSize" => 296864 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-b07f681d6f1ab35e868006e2c2ec21bb.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "61564717" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/332840f964293b6f59c003314a41fcff.webp" "ClassName" => "Single Family" "MediaSize" => 271189 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-332840f964293b6f59c003314a41fcff.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "61564718" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/9c7a93ae0659ec7c0608c71f0ebd122a.webp" "ClassName" => "Single Family" "MediaSize" => 174790 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-9c7a93ae0659ec7c0608c71f0ebd122a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "61564719" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/7b863890d24293212191e5288be577b3.webp" "ClassName" => "Single Family" "MediaSize" => 302534 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-7b863890d24293212191e5288be577b3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "61564720" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/ced261a032d2f5004ec5acf8df8674fa.webp" "ClassName" => "Single Family" "MediaSize" => 286901 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-ced261a032d2f5004ec5acf8df8674fa.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "61564721" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/5bcfb5ee0af90372bcf6917bc57f5aab.webp" "ClassName" => "Single Family" "MediaSize" => 217276 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-5bcfb5ee0af90372bcf6917bc57f5aab.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "61564722" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/3ee3c1acb4ceeca3339f0f0be6d28c22.webp" "ClassName" => "Single Family" "MediaSize" => 992881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-3ee3c1acb4ceeca3339f0f0be6d28c22.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "61564723" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615647/b80111c65b27c75727e5bd6827f455dc.webp" "ClassName" => "Single Family" "MediaSize" => 91583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615647/thumbnail-b80111c65b27c75727e5bd6827f455dc.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615647" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('615647')" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3214 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "614094" +"ListingId": "614094" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-09-16T12:28:00Z" +"RFModificationTimestamp": "2025-09-16T12:30:30Z" +"ListPrice": 244999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1532.0 +"BuildingAreaTotal": 1532.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "271 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.144327 1 => 33.857366 ] +"Latitude": 33.857366 +"Longitude": -81.144327 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "September 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 countertop 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, 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": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-07-28T20:41:47.033537+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-24" +"PhotosChangeTimestamp": "2025-08-14T20:42:24Z" +"PhotosCount": "20" +"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": "271" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/646/modelhome/3602/virtualtour/3614" +"WaterSource": "Well" +"TMS": "008092-01-042" +"Baths": "2" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "271 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-07-28" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "42" +"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": "159.92" +"Short Sale Y/N": "No" +"Agent Hit Count": "89" +"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": "159.92" +"Geo Update Timestamp": "2025-07-28T20:35:59.6" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Main" +"Address Search Number": "271" +"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-28T20:36:00.5" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:20 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6140940" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/87cbd21fc148cdd784d4f287304c3ed3.webp" "ClassName" => "Single Family" "MediaSize" => 384035 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-87cbd21fc148cdd784d4f287304c3ed3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6140941" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/f035faffca3757ce3480932b74ad7dcc.webp" "ClassName" => "Single Family" "MediaSize" => 119118 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-f035faffca3757ce3480932b74ad7dcc.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6140942" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/bec989bb533cc6ddd267b9d2a38fcbbe.webp" "ClassName" => "Single Family" "MediaSize" => 46293 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-bec989bb533cc6ddd267b9d2a38fcbbe.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6140943" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/a2faaf1223236918a2aa5251191f5292.webp" "ClassName" => "Single Family" "MediaSize" => 219466 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-a2faaf1223236918a2aa5251191f5292.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6140944" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/6feb8eccd19df22aa93e3621e488e360.webp" "ClassName" => "Single Family" "MediaSize" => 254102 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-6feb8eccd19df22aa93e3621e488e360.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6140945" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/fb8e493a92aa59f32914ce7337c04cfb.webp" "ClassName" => "Single Family" "MediaSize" => 244096 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-fb8e493a92aa59f32914ce7337c04cfb.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6140946" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/4c384332cf32bae98640a23e8edc8f0f.webp" "ClassName" => "Single Family" "MediaSize" => 355856 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-4c384332cf32bae98640a23e8edc8f0f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6140947" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/12f51eda3db9e760851331778cd97e3a.webp" "ClassName" => "Single Family" "MediaSize" => 380294 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-12f51eda3db9e760851331778cd97e3a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6140948" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/153963b57ab14b107eb30446f6ff460d.webp" "ClassName" => "Single Family" "MediaSize" => 370443 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-153963b57ab14b107eb30446f6ff460d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6140949" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/b7b77da833a92dcce6cc5215e6bad7e2.webp" "ClassName" => "Single Family" "MediaSize" => 355327 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-b7b77da833a92dcce6cc5215e6bad7e2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61409410" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/a1cd9a80f822c6017a020dd3625a5202.webp" "ClassName" => "Single Family" "MediaSize" => 413175 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-a1cd9a80f822c6017a020dd3625a5202.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61409411" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/3b515666676ffda779db8de751b3107e.webp" "ClassName" => "Single Family" "MediaSize" => 372318 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-3b515666676ffda779db8de751b3107e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61409412" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/9cd8c2bfffbec31a016dfd75df0b5f8e.webp" "ClassName" => "Single Family" "MediaSize" => 303990 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-9cd8c2bfffbec31a016dfd75df0b5f8e.webp" …4 ] 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] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('614094')" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3216 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "615646" +"ListingId": "615646" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-09-16T12:28:00Z" +"RFModificationTimestamp": "2025-09-16T12:30:30Z" +"ListPrice": 267999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.26 +"LivingArea": 2213.0 +"BuildingAreaTotal": 2213.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "555 Happy Hollow Drive, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.1413206406 1 => 33.8574290881 ] +"Latitude": 33.8574290881 +"Longitude": -81.1413206406 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "February 2026 move in! 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 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. 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. Access the second floor with an upgraded first floor handrail and iron balusters. 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": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-08-19T19:56:44.451180+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-08-19" +"PhotosChangeTimestamp": "2025-08-28T16:17:48Z" +"PhotosCount": "31" +"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": "Happy Hollow" +"StreetNumber": "555" +"StreetSuffix": "Drive" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-147" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "555 Happy Hollow Drive" +"Assn Fee": "411" +"LVT Date": "2025-08-19" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "147" +"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": "121.1" +"Agent Hit Count": "65" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"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": "121.1" +"Geo Update Timestamp": "2025-08-19T19:49:08.2" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "555" +"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-08-19T19:49:08.9" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:31 [ 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] 24 => array:11 [ …11] 25 => array:11 [ …11] 26 => array:11 [ …11] 27 => array:11 [ …11] 28 => array:11 [ …11] 29 => array:11 [ …11] 30 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('615646')" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3217 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "615744" +"ListingId": "615744" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-09-03T20:35:08Z" +"RFModificationTimestamp": "2025-09-03T20:40:19Z" +"ListPrice": 239999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.27 +"LivingArea": 1532.0 +"BuildingAreaTotal": 1532.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "619 Blue Jay Avenue, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.1411060638 1 => 33.8568588776 ] +"Latitude": 33.8568588776 +"Longitude": -81.1411060638 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "January 2026 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 countertop in the kitchen and baths, wood-inspired vinyl plank flooring throughout the first floor. Set on .27 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": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-08-21T13:21:16.882425+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-08-21" +"PhotosChangeTimestamp": "2025-09-03T20:35:08Z" +"PhotosCount": "20" +"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": "Blue Jay" +"StreetNumber": "619" +"StreetSuffix": "Avenue" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/646/modelhome/3602/virtualtour/3614" +"WaterSource": "Well" +"TMS": "008902-01-152" +"Baths": "2" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "619 Blue Jay Avenue" +"Assn Fee": "411" +"LVT Date": "2025-08-21" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "152" +"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": "156.66" +"Agent Hit Count": "82" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Main": "2" +"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" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "156.66" +"Geo Update Timestamp": "2025-08-21T13:15:48.6" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Main" +"Address Search Number": "619" +"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-08-21T13:15:49" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:20 [ 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] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('615744')" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3218 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "613121" +"ListingId": "613121" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-27T19:42:24Z" +"RFModificationTimestamp": "2025-08-27T19:50:11Z" +"ListPrice": 289900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.12 +"LivingArea": 1726.0 +"BuildingAreaTotal": 1726.0 +"City": "Blythewood" +"PostalCode": "29016" +"UnparsedAddress": "1117 Turtle Stone Road, Blythewood, SC 29016" +"Coordinates": array:2 [ 0 => -80.90306 1 => 34.1768495788 ] +"Latitude": 34.1768495788 +"Longitude": -80.90306 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Mac's Real Estate Services Inc" +"ListAgentMlsId": "12213" +"ListOfficeMlsId": "1091" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Welcome to 1117 Turtle Stone Road in Blythewood, SC – just minutes from the future home of Scout Motors! This beautifully maintained 4-bedroom, 2.5-bathroom home was built in 2022 and offers modern comfort and convenience throughout. Step inside to discover a spacious open-concept layout featuring high ceilings, vaulted ceilings in the great room, and high-end blinds throughout the home. The kitchen is perfect for entertaining with its gas range, granite countertops, bar seating, pantry, and abundant cabinet space. The great room boasts a ceiling fan and tons of natural light, creating a welcoming space for family and friends. The owner’s suite is located on the main level, complete with a large walk-in closet, double vanity, garden tub, and separate shower. A convenient half bath downstairs is perfect for guests, while the additional bedrooms are located upstairs for added privacy. Enjoy extras like a spacious laundry room, tankless gas water heater, 2-car garage with opener, covered front porch, and a fully fenced backyard. The sprinkler system helps keep your curb appeal looking sharp year-round. Located in a community with a pool, this home offers both lifestyle and location. Don’t miss your chance to own in one of Blythewood’s most desirable areas! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Tankless H20,Gas Water Heater" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-07-15T17:31:57.149896+00:00" +"Directions": "From I-77 take Exit 24. Right on Wilson Blvd. Continue 1.6 miles and turn right on Rimer Pond Rd. Continue 4 miles and turn right on Hard Scrabble Rd. Continue 1 mile and turn right into The Falls. Turn left on South Sage Drop Rd. Road will turn into Turtle Stone at Curve. Home will be on left." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Fencing": "Privacy Fence,Rear Only Wood" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl,Split System" +"InteriorFeatures": "Attic Storage,Ceiling Fan,Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "benbrysonmcc@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "3" +"OriginalEntryTimestamp": "2025-07-15" +"PhotosChangeTimestamp": "2025-07-15T17:23:25Z" +"PhotosCount": "30" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Bar,Pantry,Counter Tops-Granite,Cabinets-Stained,Floors-Luxury Vinyl Plank" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Turtle Stone" +"StreetNumber": "1117" +"StreetSuffix": "Road" +"SubdivisionName": "The Falls" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/1117_turtle_stone_rd_blythewood_sc/" +"WaterSource": "Public" +"TMS": "20415-04-10" +"Baths": "3" +"Range": "Free-standing,Gas,Self Clean" +"Garage": "Garage Attached, Front Entry" +"Address": "1117 Turtle Stone Road" +"Assn Fee": "425" +"LVT Date": "2025-07-15" +"Power On": "Yes" +"Baths Full": "2" +"Great Room": "Ceiling-Vaulted,Ceiling Fan,Floors-Luxury Vinyl Plank" +"New/Resale": "Resale" +"class_name": "RE_1" +"2nd Bedroom": "Bath-Shared,Tub-Shower,Closet-Private,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Tub-Shower,Floors - Carpet" +"4th Bedroom": "Bath-Shared,Closet-Walk in,Tub-Shower,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Blythewood" +"House Faces": "Northwest" +"IDX Include": "Yes" +"# of Stories": "2" +"Garage Level": "Main" +"LA1User Code": "MCCARB" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Blythewood" +"Miscellaneous": "Cable TV Available,Community Pool" +"Status Detail": "0" +"Full Baths-2nd": "1" +"Half Baths-2nd": "0" +"Lockbox Number": "32796839" +"Master Bedroom": "Double Vanity,Tub-Garden,Bath-Private,Separate Shower,Closet-Walk in,Ceilings-High (over 9 Ft),Floors - Carpet" +"Price Per SQFT": "167.96" +"Short Sale Y/N": "No" +"Agent Hit Count": "113" +"Avail Financing": "Cash,Conventional,FHA,VA" +"Full Baths-Main": "1" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"School District": "Richland Two" +"Level-Great Room": "Main" +"Elementary School": "Lake Carolina" +"Int School Choice": "No" +"LO1Main Office ID": "1091" +"Other Heated SqFt": "0" +"Senior Living Y/N": "N" +"Assoc Fee Includes": "Common Area Maintenance,Pool,Green Areas" +"Formal Dining Room": "Area,Ceilings-High (over 9 Ft),Floors-Luxury Vinyl Plank" +"High School Choice": "No" +"LA1Agent Last Name": "McCarter" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "Yearly" +"Detitled Mobile Y/N": "N" +"Foreclosed Property": "No" +"LA1Agent First Name": "Ben" +"List Price Tot SqFt": "167.96" +"Geo Update Timestamp": "2025-07-15T17:23:23.6" +"LO1Office Identifier": "1091" +"Level-Master Bedroom": "Main" +"Middle School Choice": "No" +"Address Search Number": "1117" +"LO1Office Abbreviation": "MACS01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Other Elementary School": "Lake Carolina" +"Publish to Internet Y/N": "Yes" +"Elementary School Choice": "No" +"Interior # of Fireplaces": "0" +"Level-Formal Dining Room": "Main" +"First Photo Add Timestamp": "2025-07-15T17:23:25" +"MlsAreaMajor": "Columbia Northeast" +"Media": array:30 [ 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] 24 => array:11 [ …11] 25 => array:11 [ …11] 26 => array:11 [ …11] 27 => array:11 [ …11] 28 => array:11 [ …11] 29 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('613121')" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3219 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "609080" +"ListingId": "609080" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-27T15:42:16Z" +"RFModificationTimestamp": "2025-08-27T15:51:16Z" +"ListPrice": 239999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1532.0 +"BuildingAreaTotal": 1532.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "227 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.143056 1 => 33.856293 ] +"Latitude": 33.856293 +"Longitude": -81.143056 +"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 countertop 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": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-05-21T14:09:36.547015+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-05-20" +"PhotosChangeTimestamp": "2025-08-27T15:42:16Z" +"PhotosCount": "23" +"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": "227" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/646/modelhome/3602/virtualtour/3614" +"WaterSource": "Well" +"TMS": "008902-01-031" +"Baths": "2" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "227 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-05-21" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "31" +"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": "156.66" +"Agent Hit Count": "76" +"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" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "156.66" +"Geo Update Timestamp": "2025-05-21T14:01:09.6" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Main" +"Address Search Number": "227" +"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-05-21T14:01:10.6" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:23 [ 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] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('609080')" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3220 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "615747" +"ListingId": "615747" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-25T14:11:55Z" +"RFModificationTimestamp": "2025-08-25T14:18:41Z" +"ListPrice": 244999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.26 +"LivingArea": 1928.0 +"BuildingAreaTotal": 1928.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "250 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.142999 1 => 33.857366 ] +"Latitude": 33.857366 +"Longitude": -81.142999 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "October 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": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-08-21T13:26:53.840538+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-08-21" +"PhotosChangeTimestamp": "2025-08-25T14:11:55Z" +"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": "250" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-050" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "250 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-08-21" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "50" +"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": "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": "127.07" +"Agent Hit Count": "57" +"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": "Gould" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "127.07" +"Geo Update Timestamp": "2025-08-21T13:21:32.6" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "250" +"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-08-21T13:21:33.2" +"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('615747')" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3221 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "615530" +"ListingId": "615530" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-18T13:52:01Z" +"RFModificationTimestamp": "2025-08-18T13:59:40Z" +"ListPrice": 284999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.33 +"LivingArea": 2213.0 +"BuildingAreaTotal": 2213.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "603 Blue Jay Avenue, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.1391395 1 => 33.8536699 ] +"Latitude": 33.8536699 +"Longitude": -81.1391395 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Sold before listed for comp purposes only! 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 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. The open kitchen has spacious counters, tiled backsplash, an expansive island, and modern stainless-steel appliances, including 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-08-18T13:59:33.905549+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-08-16" +"PhotosChangeTimestamp": "2025-08-18T13:52:01Z" +"PhotosCount": "30" +"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": "Blue Jay" +"StreetNumber": "603" +"StreetSuffix": "Avenue" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-149" +"Baths": "3" +"Range": "Free-standing,Smooth Surface" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "603 Blue Jay Avenue" +"Assn Fee": "411" +"LVT Date": "2025-08-18" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "149" +"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": "128.78" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"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": "128.78" +"Geo Update Timestamp": "2025-08-18T13:51:34.8" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "603" +"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-08-18T13:51:35.3" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:30 [ 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] 24 => array:11 [ …11] 25 => array:11 [ …11] 26 => array:11 [ …11] 27 => array:11 [ …11] 28 => array:11 [ …11] 29 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('615530')" } ] +success: true +page_size: 10 +page_count: 3 +count: 25 +after_key: "" } ] ]
