# 174 Preston Green Drive, Columbia, SC 29209 > **TL;DR:** 2bd/3ba single family, $248,000 ($149/sqft), built 2008, 1,664 sqft. > Fireplace, A/C, 2-car garage. Est. $1,568/mo. Listed 239 days. ## Property at a Glance | Attribute | Value | |-----------|-------| | Price | $248,000 | | Price/sqft | $149 | | Bedrooms | 2 | | Bathrooms | 2 full, 1 half | | Square Feet | 1,664 | | Year Built | 2008 | | Lot Size | 436 sqft (0.01 acres) | | Garage | 2-car | | Property Type | Single Family (Other) | | Status | Active | | Days on Market | 239 | ## Estimated Monthly Costs | Category | Amount | |----------|--------| | Principal & Interest (20% down, 30-year at 6.5%) | $1,254 | | Estimated Insurance | $72 | | HOA | $242 | | **Total** | **$1,568** | ## Nearby Schools - **Elementary:** Meadowfield - **Middle:** Hand - **High:** Dreher ## Key Amenities - Fireplace - A/C - 2-car garage ## Property Highlights - Built in 2008 - 0.01 acre lot - Fireplace ## Description ### Agent Description Welcome to this well maintained home. Home features a spacious great room featuring beautiful laminate flooring, a cozy fireplace and a convenient hall bath ideal for entertaining guest. The eat in kitchen has ample cabinet space with a large pantry. Kitchen has new floors and fresh paint and a very nice refrigerator. Enjoy quiet mornings on the inviting front porch and relax in the evenings on the large private deck that would ge great for outdoor dining or unwinding in the afternoon. The deck has been freshly painted and has new caps on deck fencing and is very private. The main level owners suite is very spacious with a large walk in closet. Master bathroom has a double vanity with new faucets and a new soft close toilet seat. The upstairs you will find a second sizable bedroom with its own walk in closet that has new carpet and blinds. There is a versatile bonus room that can serve as a third bedroom, an office, playroom, or game room. The room has new carpet as well. Conveniently located near Grocery stores, restaurants and shopping. Conveniet to Downton Columbia, Sysco Food Distributors, Schneider Electric, Minutes fro I-77 and the VA. Quick access to Williams-Brice Stadium. Front Yard is Maintained by HOA. Clean and move in ready. Call and schedule an appointment to see this home today before it is gone! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings. ## Location - **Address:** 174 Preston Green Drive, Columbia, SC 29209 - **County:** Richland - **Neighborhood:** PRESTON GREEN GARDEN HOMES - **Coordinates:** 33.958796, -80.943717 - **Google Maps:** https://www.google.com/maps?q=33.958796,-80.943717 ## Listing Agent - **Name:** Debra Carter - **Brokerage:** ERA Wilder Realty - **Broker Phone:** (803) 728-8400 - **Listing URL:** [View original listing](https://www.realtor.com/realestateandhomes-detail/174-Preston-Green-Dr_Columbia_SC_29209_M64561-48090?f=listhub&s=CMLSSC&m=628719&c=propsimple) ## Photos ![174 Preston Green Drive - Photo 1](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1317701626r.jpg) ![174 Preston Green Drive - Photo 2](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f833413333r.jpg) ![174 Preston Green Drive - Photo 3](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1044305207r.jpg) ![174 Preston Green Drive - Photo 4](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2926036741r.jpg) ![174 Preston Green Drive - Photo 5](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1049882261r.jpg) ![174 Preston Green Drive - Photo 6](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f151708375r.jpg) ![174 Preston Green Drive - Photo 7](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1429688883r.jpg) ![174 Preston Green Drive - Photo 8](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1075563990r.jpg) ![174 Preston Green Drive - Photo 9](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2814529761r.jpg) ![174 Preston Green Drive - Photo 10](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1675111195r.jpg) ![174 Preston Green Drive - Photo 11](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f578081170r.jpg) ![174 Preston Green Drive - Photo 12](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2435884309r.jpg) ![174 Preston Green Drive - Photo 13](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f3141121584r.jpg) ![174 Preston Green Drive - Photo 14](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1390151414r.jpg) ![174 Preston Green Drive - Photo 15](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f3679341164r.jpg) ![174 Preston Green Drive - Photo 16](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2544887829r.jpg) ![174 Preston Green Drive - Photo 17](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f878467803r.jpg) ![174 Preston Green Drive - Photo 18](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2982763753r.jpg) ![174 Preston Green Drive - Photo 19](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2729844552r.jpg) ![174 Preston Green Drive - Photo 20](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f578081170r.jpg) ![174 Preston Green Drive - Photo 21](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1532048091r.jpg) ![174 Preston Green Drive - Photo 22](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1334853434r.jpg) ![174 Preston Green Drive - Photo 23](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2038258199r.jpg) ![174 Preston Green Drive - Photo 24](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2953539406r.jpg) ![174 Preston Green Drive - Photo 25](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f3489420233r.jpg) ![174 Preston Green Drive - Photo 26](http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f77398262r.jpg) --- **MLS#:** 628719 | **Updated:** 2026-10-27 **Source:** listhub *Copyright © 2026 Consolidated MLS, SC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.* [View on PropertySimple](https://staging.propertysimple.ai/listing/174-preston-green-drive-columbia-sc-29209-5f8bcbe5873e42898d3278a27624756d) --- ## Structured Data ```json { "@context": "https://schema.org", "@type": "RealEstateListing", "@id": "https://staging.propertysimple.ai/listing/174-preston-green-drive-columbia-sc-29209-5f8bcbe5873e42898d3278a27624756d#listing", "url": "https://staging.propertysimple.ai/listing/174-preston-green-drive-columbia-sc-29209-5f8bcbe5873e42898d3278a27624756d", "name": "174 Preston Green Drive, Columbia, SC 29209", "description": "Welcome to this well maintained home. Home features a spacious great room featuring beautiful laminate flooring, a cozy fireplace and a convenient hall bath ideal for entertaining guest. The eat in kitchen has ample cabinet space with a large pantry. Kitchen has new floors and fresh paint and a very nice refrigerator. Enjoy quiet mornings on the inviting front porch and relax in the evenings on the large private deck that would ge great for outdoor dining or unwinding in the afternoon. The deck has been freshly painted and has new caps on deck fencing and is very private. The main level owners suite is very spacious with a large walk in closet. Master bathroom has a double vanity with new faucets and a new soft close toilet seat. The upstairs you will find a second sizable bedroom with its own walk in closet that has new carpet and blinds. There is a versatile bonus room that can serve as a third bedroom, an office, playroom, or game room. The room has new carpet as well. Conveniently located near Grocery stores, restaurants and shopping. Conveniet to Downton Columbia, Sysco Food Distributors, Schneider Electric, Minutes fro I-77 and the VA. Quick access to Williams-Brice Stadium. Front Yard is Maintained by HOA. Clean and move in ready. Call and schedule an appointment to see this home today before it is gone! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.", "image": [ "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1317701626r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f833413333r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1044305207r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2926036741r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1049882261r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f151708375r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1429688883r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1075563990r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2814529761r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1675111195r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f578081170r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2435884309r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f3141121584r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1390151414r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f3679341164r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2544887829r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f878467803r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2982763753r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2729844552r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1532048091r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1334853434r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2038258199r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2953539406r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f3489420233r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f77398262r.jpg" ], "primaryImageOfPage": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1317701626r.jpg", "caption": "174 Preston Green Drive - Columbia, SC" }, "datePosted": "2026-03-09", "dateModified": "2026-10-27T20:33:45.844Z", "mainEntity": { "@type": "Accommodation", "@id": "https://staging.propertysimple.ai/listing/174-preston-green-drive-columbia-sc-29209-5f8bcbe5873e42898d3278a27624756d#property", "name": "174 Preston Green Drive, Columbia, SC 29209", "address": { "@type": "PostalAddress", "streetAddress": "174 Preston Green Drive", "addressLocality": "Columbia", "addressRegion": "SC", "postalCode": "29209", "addressCountry": "US" }, "geo": { "@type": "GeoCoordinates", "latitude": 33.958796, "longitude": -80.943717 }, "image": [ "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1317701626r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f833413333r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1044305207r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2926036741r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1049882261r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f151708375r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1429688883r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1075563990r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2814529761r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1675111195r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f578081170r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2435884309r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f3141121584r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1390151414r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f3679341164r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2544887829r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f878467803r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2982763753r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2729844552r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1532048091r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f1334853434r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2038258199r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f2953539406r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f3489420233r.jpg", "http://lh.rdcpix.com/beb2ccc4aa289685051debb68b0e4104l-f77398262r.jpg" ], "identifier": { "@type": "PropertyValue", "propertyID": "MLS", "value": "628719" }, "accommodationCategory": "Other", "numberOfBedrooms": 2, "numberOfBathroomsTotal": 3, "numberOfFullBathrooms": 2, "numberOfPartialBathrooms": 1, "floorSize": { "@type": "QuantitativeValue", "value": 1664, "unitCode": "FTK", "unitText": "square feet" }, "yearBuilt": 2008, "amenityFeature": [ { "@type": "LocationFeatureSpecification", "name": "Heating", "value": "Central, Heat Pump (Heating)" }, { "@type": "LocationFeatureSpecification", "name": "Cooling", "value": "Central Air, Heat Pump" }, { "@type": "LocationFeatureSpecification", "name": "Fireplace", "value": true }, { "@type": "LocationFeatureSpecification", "name": "Air Conditioning", "value": true } ], "additionalProperty": [ { "@type": "PropertyValue", "name": "Lot Size", "value": "0.01 acres" }, { "@type": "PropertyValue", "name": "Garage Spaces", "value": 2 }, { "@type": "PropertyValue", "name": "Property Subtype", "value": "Other" } ] }, "offers": { "@type": "Offer", "@id": "https://staging.propertysimple.ai/listing/174-preston-green-drive-columbia-sc-29209-5f8bcbe5873e42898d3278a27624756d#offer", "url": "https://staging.propertysimple.ai/listing/174-preston-green-drive-columbia-sc-29209-5f8bcbe5873e42898d3278a27624756d", "price": 248000, "priceCurrency": "USD", "businessFunction": "http://purl.org/goodrelations/v1#Sell", "availability": "https://schema.org/InStock", "seller": { "@id": "https://staging.propertysimple.ai/listing/174-preston-green-drive-columbia-sc-29209-5f8bcbe5873e42898d3278a27624756d#agent" } }, "provider": { "@type": "Person", "@id": "https://staging.propertysimple.ai/listing/174-preston-green-drive-columbia-sc-29209-5f8bcbe5873e42898d3278a27624756d#agent", "name": "Debra Carter", "worksFor": { "@type": "Organization", "@id": "https://staging.propertysimple.ai/listing/174-preston-green-drive-columbia-sc-29209-5f8bcbe5873e42898d3278a27624756d#brokerage", "name": "ERA Wilder Realty", "telephone": "(803) 728-8400", "logo": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/2871528106ca11dfb51400219b994c72k-c182180180r.png" } } } } ```