The Brennaman Group

242 Agrarian Avenue : The Brennaman Group
The Brennaman Group > Summerville > Limehouse Farms > 242 Agrarian Avenue

242 Agrarian Avenue, Summerville, SC 29485 $256,000

At just $256,000, 242 Agrarian Avenue is the least expensive home for sale in the Limehouse Farms neighborhood of Summerville.
Bedrooms 3
Full Bathrooms 2
SqFt 1,906
Updated 10/28/2026
Half Bathrooms 1
Price/SqFt $134
Photo 1 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 2 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 3 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 4 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 5 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 6 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 7 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 8 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 9 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 10 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 11 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 12 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 13 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 14 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 15 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 16 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 17 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 18 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 19 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 20 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 21 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 22 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 23 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 24 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
Photo 25 of 25 : 242 Agrarian Avenue

Free Registration

Registration is required to view full size photos, it's fast, free, and I will not share your information with 3rd parties. If you have previously registered, just enter your email address to log in.

Name*
Email Address*
General Features
Category Residential
Special Features 10 Yr Warranty
Stories 2
Lot Description Level,0 - .5 Acre
County Dorchester
City Summerville
Subdivision Limehouse Farms
MLS number 26020546 (Active)
Address 242 Agrarian Avenue, Summerville, SC 29485 US
Listing Provided by Navigate Realty
Sale Type Not an Auction
MLS Area 63 - Summerville/Ridgeville
Description : Back on market through no fault of sellers! Buyers financing fell through.
Back on market through no fault of sellers! Buyers financing fell through. FULLY FURNISHED with acceptable offer!! What's better than new construction? A barely lived-in townhome, complete with all appliances, fixtures, blinds, a wired garage door/opener and a professionally screened-in back patio for year-round enjoyment. This impeccably maintained 3-bedroom, 2 1/2-bathroom townhome has been thoughtfully updated to anticipate any new homeowner's needs by providing all the post-construction add-ons without the cost. This townhome lives large, with 10-foot ceilings, excellently sized bedrooms, plenty of storage and a primary bedroom closet anyone would envy. Enjoy the newly finished neighborhood park, pool and clubhouse while residing in a neighborhood with a true community feel.Centrally located near all major highways and conveniences in the DD2 school district
Exterior Features
Exterior Vinyl Siding
Foundation Slab
Roof Architectural
Water / Sewer Public Sewer
Misc. Exterior Rain Gutters,Lawn Irrigation
Interior Features
Flooring Vinyl,Carpet
Master Bedroom Walk-In Closet(s)
Cooling Central Air
Heating Central
Amenities
• Clubhouse
• Lawn Maint Incl
• Pool
• Other
• Park
• Trash
Schools
Elementary School
Beech Hill
Middle School
East Edisto
High School
Ashley Ridge
Ask About 242 Agrarian Avenue
242 Agrarian Avenue is listed for sale at $256,000 and is in the 29485 zip code, in the Limehouse Farms neighborhood of Summerville. Nearby schools include Beech Hill, East Edisto and Ashley Ridge, and amenities include Clubhouse, Lawn Maint Incl, Pool, Other, Park and Trash. The best way to learn about this home for sale is to come and view it in person, all you have to do is call and ask me, to set up your complimentary showing of 242 Agrarian Avenue.
Limehouse Farms Photo of 246 Harvest Grove Lane246 Harvest Grove Lane
3 Bedrooms, 1,906 Sq Ft
$258,177
Summerville Photo of 1005 Razor Clam Way1005 Razor Clam Way
3 Bedrooms, 1,435 Sq Ft
$299,000 Photo of 1007 Razor Clam Way1007 Razor Clam Way
2 Bedrooms, 1,507 Sq Ft
$298,500
This is a 3 bedroom single family attached property at 242 Agrarian Avenue in Limehouse Farms in Summerville that is listed for sale for $256,000. The total heated square footage is about 1,906 sq ft, and this translates to $134 per sq ft. This home was built in 2025 and has 2 full and 1 half bathrooms. Exterior features include Rain Gutters,Lawn Irrigation.
Broker ReciprocityProperties marked with the Broker Reciprocity logo are provided courtesy of Charleston Trident Multiple Listing Service, Inc. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the Charleston Trident Multiple Listing Service. Real estate listings held by brokerage firms other than the website owner are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers. The broker providing this data believes it to be correct, but advises interested parties to confirm them before relying on them in a purchase decision. Information is provided exclusively for consumers' personal, non-commerical use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Close

Log In

Enter the Email Address you used to register

Email Address*
Close

TELL A FRIEND

Your friend will be sent a link to this property, These names and email addresses are not stored by us. We only store your IP Address to prevent abuse. You may send a maximum of 10 a day system wide.

Your Name*
Your Email Address*
Recipient Name*
Recipient Email Address*
Close

Request a Showing

Please include a phone number to help to arrange this showing, we will contact you to confirm a suitable available showing time. Please enter your preferred showing time below; it is not important if your date and time are exact - if you are not yet sure when you will be available, just enter a guess - it is only tentative and subject to us following up with you to confirm everyones' schedule. Submitting this form does not confirm the showing.

Your Name*
Your Email Address*
Your Telephone
© 2011-2026 Bob Brennaman Jr., Real Estate Agent License #42900
Database synchronized on Fri Oct 30 at 2:55 pm EDT | Page time 0.022s
Mobile Website down for Maintainence

Featured Cities

All Cities

Search

Advanced Options