AI Real Estate Social Media: A Month of Posts From Your Listings

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for AI Real Estate Social Media: A Month of Posts From Your Listings.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for AI Real Estate Social Media: A Month of Posts From Your Listings.

List your active homes, open houses and closed sales in one sheet, give the assistant only those facts, and ask it to fill a four-week grid with formats such as just listed, open house, just sold and market note. Then review every caption for fair-housing wording, your brokerage's disclosures and any claim you cannot prove.

A month of posts is a planning job, not a writing job. The grid decides what runs when, and the captions are the quick part. Most tools sold for this task generate generic content from a listing link; this tutorial builds the calendar from your own pipeline instead, so every post hangs on a fact and has an owner for the check. All listings, sales and prices below are invented.

Follow me on Instagram@sagnikteaches

Start with a source sheet of what you may actually post

The sheet is the control point. Each row is a home or a sale, with the facts you may use, whether the seller or buyer has agreed to a public post, and your role in the deal. If a row has no consent, it has no posts. Add columns for status, the date the status last changed, the open-house time, and whether a price may be shown. This is a filled-in sheet for the month.

Connect on LinkedInSagnik Bhattacharya
ItemStatusFacts you may useConsent and role
Listing AActive, goes live Monday of week 13 bed, 2 bath, 1,650 sq ft; eight-foot kitchen island; fenced garden; $398,000; open house Saturday 1 to 3 pmListing agreement signed; photos and price approved; listing agent
Listing BActive4 bed, 2.5 bath, 2,100 sq ft; $469,000, reducing to $459,000 in week 3Seller approved the price-change post; listing agent
Listing CGoes live Saturday of week 22 bed townhouse, 1,200 sq ft; $329,000; open house in week 4Listing agreement signed; photos pending; listing agent
Sale DClosed three weeks agoSold at $415,000 against a $419,000 list price after 19 daysSeller agreed to show the price; represented the sellers
Sale EClosed last week2 bed townhouse; price not to be shownBuyer agreed to a post; represented the buyers; listing brokerage named

The sheet takes about half an hour to fill the first time and five minutes a week afterwards. It does two jobs beyond feeding the assistant. It reminds you to ask for consent before a post is drafted, and it records the status of each home, which matters because a post that says "open this Saturday" about a house under contract is a wrong statement published under your name.

Subscribe on YouTube@sagnikteaches

The month grid: sixteen posts, one fact in each

Four posts a week, on Monday, Wednesday, Friday and Saturday, gives sixteen posts. Instagram's own scheduler accepts posts up to 30 days ahead, so a four-week grid fits inside it. The rule that keeps the grid honest is one verifiable fact per post, taken from the source sheet. This is the grid for the five items above.

WeekMondayWednesdayFridaySaturday
1Just listed: AMarket note: median days on marketFeature spotlight: A's kitchen islandOpen house today: A
2Feature spotlight: BEducation: five things to do before listingJust sold: D, as listing agentJust listed: C
3Price improvement: BEducation: what a home inspection report coversJust sold: E, as buyer's agentFeature spotlight: C
4Market note: number of sales in 12 monthsOpen house reminder: CEducation: a buyer tip from this month's dealsRoundup of active listings

The mix is eight posts about specific homes (two just listed, two open house, three feature spotlights and one price improvement) and eight about everything else (two just sold, two market notes, three education posts and one roundup). Four posts a week over four weeks is sixteen, and any format you add must displace another, or the calendar grows past what you can check. If a home goes under contract in week 2, its remaining posts are swapped for education posts, and the source sheet's status column is how you spot it.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Listing captions that carry a fact instead of a slogan

A listing caption has four jobs: say what the home is, give one detail that is hard to fake, say what happens next, and carry your disclosure line. Everything else is decoration. These three formats cover most of the listing posts in the grid, each shown with the sample sheet's facts. They are illustrations, so adapt the wording to your voice.

Just listed (A): "Just listed: 3 bed, 2 bath, 1,650 sq ft, with an eight-foot kitchen island and a fenced garden. $398,000. Open house this Saturday, 1 to 3 pm. [Agent name], [Brokerage]."

Price improvement (B): "Price improved: now $459,000 (was $469,000). 4 bed, 2.5 bath, 2,100 sq ft. Viewings by appointment. [Agent name], [Brokerage]."

Open house reminder (C): "Open this Wednesday, 5 to 7 pm: a 2 bed townhouse of 1,200 sq ft at $329,000. Floor plan in the comments. [Agent name], [Brokerage]."

The disclosure line deserves a check against your own rules. The trade association's code of ethics, in the 2026 edition, asks that advertising carry the firm name in a reasonable and readily apparent manner, and for electronic advertising allows that to be done through a link to a display holding all required disclosures. Licensing rules and your brokerage may ask for more, such as a licence number or the equal housing logo or statement, so confirm with your broker what must sit in the caption itself and what may sit behind your bio link. The same code says advertising property without authority is not allowed, which is why the source sheet records the signed listing agreement for each home.

Accuracy does not stop at posting. The code also asks you to correct a website promptly when information is no longer current, and a social post that says "open Saturday" once the house is under contract is the same problem in a different place. The weekly check below is the answer.

Just-sold posts: who may say "sold", and how to state your role

Just-sold posts are the ones most worth getting right, because they borrow credit. The code's Standard of Practice 12-7 says only those who took part in the transaction as the listing broker or the cooperating broker may claim to have sold the property. Its published case interpretations add useful detail. A "Recently Sold" newsletter of ten homes, none of which the agent had listed and only one of which he had worked on as cooperating broker, was found to breach Article 12, because its cumulative effect was to suggest he had listed or sold them. A mailing of twenty homes that carried a footnote saying various MLS participants had listed and sold them was not a breach, because the footnote stopped it implying he had handled each one. A website that showed sales made at a previous firm under the new firm's name was a breach; a site that added a disclaimer about the earlier affiliation was not.

Turn that into a working rule: every just-sold post states your role, and never shows a sale you did not take part in. These are sample captions for the two sales on the sheet.

Sale D, listing side: "Just sold: I represented the sellers. Closed at $415,000, which was 99.0% of the $419,000 list price, after 19 days on the market. [Agent name], [Brokerage]."

Sale E, buyer side: "Just closed: I represented the buyers of this two-bedroom townhouse. Listing brokerage: [name]. [Agent name], [Brokerage]."

A common AI slip shows why the sheet matters. Given only "Sale E, townhouse, closed", an assistant wrote "Sold $20k over asking in just 3 days!", a line with no source. It was filling the gap with the pattern of posts it had seen. The edit removed the claim, and because the buyer had asked for no price to be shown, the finished caption has no number at all. Also keep the 99.0% figure honest: it is $415,000 divided by $419,000, a ratio you can check, and "over asking" appears nowhere because nothing supports it. For the wider rules on photos and AI-edited images in posts like these, the tutorial on AI disclosure for listing photos and copy goes further.

The posts between listings: education, market notes and the roundup

Half the grid has no single home in it, and that is deliberate. These posts build credibility between listings, but they are also where an assistant is most tempted to invent, so tie each one to something you can show. Three examples from the sample month follow, each with its check.

Education (week 2): "Five things to do before you list: gather your mortgage payoff figure and any warranties; fix the small repairs now; book photography for a day with good light; ask for a written price opinion based on recent sales; decide whether price, speed or both matters most. Questions? Message me. [Agent name], [Brokerage]."

The check is that nothing in the list is a legal claim or a statistic. Assistants like to add a line such as "sellers who skip this lose thousands", which has no source and goes out under your name. Strip it.

Market note (week 1): "Median days on market for homes sold in [area] in the 12 months to 31 October 2026: 19 (MLS data). A median means half the homes sold faster and half slower. [Agent name], [Brokerage]."

Here the check is the MLS report itself: confirm the area boundary, the period and whether the figure is a median or an average before the number leaves your desk. The market update tutorial describes the process in full. The assistant should never supply this number from memory, because a plausible figure from another area or an earlier year reads exactly like a real one.

Roundup (week 4): "This week's active homes: A at $398,000, open Saturday 1 to 3 pm; B at $459,000, price improved; C at $329,000, open Wednesday 5 to 7 pm. [Agent name], [Brokerage]."

The roundup is the post most likely to go stale, because it repeats prices and times from several rows at once. Build it last, on the morning it runs, from the current sheet. A related rule covers testimonials: if you add a client-story post, use only words the client has given you in writing, and never ask an assistant to write one in a client's voice.

The calendar prompt, and what the first draft gets wrong

Put the rules in the prompt and paste the source sheet beneath it. Keep the prompt in a Project or a Gemini skill (Google's replacement for Gems, rolling out since October 2026) so each month starts from the same rules and only the sheet changes.

Plan a four-week social media calendar for a real estate agent, with posts on
Monday, Wednesday, Friday and Saturday, using ONLY the source sheet below.
Formats allowed: just listed, open house, feature spotlight, price improvement,
just sold, market note, education.
Rules:
1. One verifiable fact per post, taken from the sheet.
2. State each home's status exactly as the sheet gives it.
3. For sold posts, state my role (represented the sellers or the buyers) and show
   a price only where the sheet says a price may be shown.
4. Never write "over asking", days on market or any figure the sheet does not give.
5. Describe the home, never the buyer. No claims about schools, safety or the
   character of the neighbourhood.
6. End every caption with [Agent name], [Brokerage]. At most five hashtags, all
   factual about the home.
Output a table: Week | Day | Format | Item | Fact used | Caption (60 words max).
Then list every post that needs a check before it goes live.
[source sheet]

Rows like these, invented for this tutorial, are typical of what comes back, and the last column shows the fixes.

SlotAssistant's caption (shortened)What to fix
Week 2, Saturday, just listed C"Ideal for first-time buyers or downsizers: a 2 bed townhouse at $329,000."Both groups are buyers described by life stage; replace with "2 bed townhouse, 1,200 sq ft, $329,000"
Week 3, Friday, just sold E"Sold in days, well over asking!"No figures on the sheet; the buyer asked for no price; state the role and the listing brokerage only
Week 4, Monday, market note"Homes here now sell in 14 days on average."The sheet holds no market data; leave a placeholder and pull the median from the MLS with its period
Week 1, Saturday, open house A"Open today 1 to 3 pm."Correct, but add a status check: if A goes under contract on Friday the post must not go out

Most of the edits repeat the same three moves: remove a described buyer, remove a figure with no source, and add a check for status. That repetition is useful. It tells you what to add to the prompt for next month. When the "list every post that needs a check" step at the end of the output flags posts you had not noticed, as it does for the market note, keep it in the prompt permanently.

Fair-housing check: captions, hashtags and pictures

Social posts about homes for sale are advertising, and the Fair Housing Act's advertising provision applies to notices, statements and advertisements that indicate a preference or limitation based on race, colour, religion, sex, handicap, familial status or national origin. The trade association's magazine gave the practical rule: describe the property, not the buyer. "Ideal for empty nesters" and "perfect for students" may imply a preference, whereas "easy walk to train" describes a feature. Captions and hashtags are where the first draft goes wrong, as the table shows.

Typical first draftThe problemFix
"The perfect starter home for young families"Describes the buyer, including familial status"3 bed, 2 bath, 1,450 sq ft with a fenced garden"
"Walk to the best schools!"A quality opinion that can point towards or away from areas"A 6-minute walk to the rail station", if measured
"A quiet, safe street""Safe" cannot be verified and is often read as a comment on residentsDrop "safe"; if the street is quiet for a reason, give it: "on a cul-de-sac"
"Ideal for someone with limited mobility"Describes the buyer by disability"Step-free entrance, 36-inch doorways and a roll-in shower"
#familyhome #safeneighbourhood #exclusivelivingTags that describe people or exclusivity#3bedhome #fencedgarden #opensaturday #townhouse #justlisted
A photo of the sellers' family on the front stepsShows identifiable residentsProperty pictures only, with no identifiable people

The disability row shows the principle working in a helpful direction. Describing accessible features helps people who are looking for them and describes the property. Saying the home is "ideal for" a group of people describes a buyer. If the assistant has a talent here, it is converting a vague adjective into a specific feature once you give it the fact. The tutorial on listing descriptions that pass fair-housing checks goes deeper on the listing text itself.

Images need the same care. If a picture has been edited, virtually staged or generated, label it clearly and keep the original available. The code's Article 12 asks for a true picture in advertising and marketing, and a staged room with furniture that is not there, shown unlabelled, does not give one. The tutorial on AI video from listing photos covers disclosure when a Reel is built from stills.

Boosting a post changes the rules

A post you pay to promote is advertising in the ordinary sense, and on Meta's platforms it comes with extra rules. Meta's developer documentation says advertisers running housing ads must declare the Housing special ad category, a requirement it enforces for housing ads reaching several large markets and lets others opt into. Once declared, age is generally fixed at 18 to 65+, you cannot choose a gender, postal-code targeting is not supported, any location you pick must cover a radius of at least 15 miles (25 kilometres) in the markets where the rule began, or 15 kilometres in others, and lookalike audiences are unavailable. An ad with the wrong category risks being paused.

The practical effect is that you cannot aim a boosted listing post at one neighbourhood, and you should not try to recreate that targeting through other settings. Let the content do the selecting: a clear address, a price and a photo of the home. Check the current documentation before you boost, because the rules vary by market and change. The same fair-housing logic applies to advertising on other platforms, as the tutorial on ChatGPT ads for realtors and fair-housing rules explains.

Scheduling two weeks at a time, and a twenty-minute Monday check

Schedule the first two weeks and leave weeks 3 and 4 as drafts until the Friday of week 2. Statuses change: a home goes under contract, a price drops, an open house is cancelled for rain. Instagram's scheduler accepts posts up to 30 days ahead, so it could hold the whole grid, but you should not fill it. If you use Buffer, its free plan covers 3 channels with 10 scheduled posts each, so one channel cannot hold sixteen posts anyway; a two-week rolling schedule fits that limit with room to spare. Judge any scheduling tool by whether it lets you pull a post quickly, not by how many it can queue.

Then run the same check every Monday, which takes about twenty minutes.

  1. Update the status and date columns of the source sheet.
  2. Compare the next seven days of posts with the sheet, and pause or swap any post about a home whose status has changed.
  3. Confirm open-house times and price changes with the sellers.
  4. Reply to last week's comments and messages, since a same-day answer is the cheapest lead you will get; the open-house follow-up tutorial covers the first hour after an event.
  5. Read last week's three numbers (below) and note which format earned them.
  6. Correct any live post that turns out to be wrong, the same day.

What to measure after the first month

Pick three numbers and write them down before the month starts: enquiries that mention a post, saves or shares, and clicks on your link. Compare them by format at the end, with two warnings. A small account's numbers are noisy, so treat a difference between formats as a hint rather than proof. And no tutorial can tell you what your numbers should be, so don't borrow anyone's benchmarks. If just-sold posts bring more enquiries than feature spotlights, make more of them, as long as each one is true and carries your role.

Questions agents ask about AI-planned social posts

Can I post a just-sold photo if I represented the buyer?

Yes, if you say that is your role. The code of ethics many agents follow lets only those who took part as the listing or cooperating broker claim a sale, and it expects a true picture, so write "I represented the buyers" and name the listing brokerage. Get the client's consent to post, and ask before showing any price.

Do I need the seller's permission to post a listing?

You need authority to advertise a property, normally through the signed listing agreement, and a licence to use each photograph from whoever took it. Confirm both before scheduling. If a seller has not agreed to price changes or open-house posts being public, hold those posts until they have.

How many hashtags should I use?

Instagram now caps hashtags at five per post, so choose five that describe the home itself, such as bedroom count or home type. Skip tags that describe people or lifestyles. Hashtags add little to a post that is already specific, and an AI will happily suggest twenty vague ones if you let it.

Should I tell followers a post was written with AI?

Rules differ by platform, brokerage and place, so check your brokerage policy. Label AI-generated or edited property images clearly, and never use them to show features a home lacks. The accuracy of every caption is yours whoever drafted it, which is why each post in the calendar traces back to a line on your source sheet.

Further reads

Sources: the NAR Code of Ethics 2026 edition (Article 12 and Standards of Practice 12-4, 12-5, 12-7, 12-8 and 12-10) and its published case interpretations, Meta's Special Ad Categories developer documentation, Instagram's help pages on hashtags and scheduling, Buffer's pricing page (all checked November 2026), and the Fair Housing Act's advertising provision. All listings, sales and prices in the examples are invented.

Want a posting routine that stays accurate week to week?

On a 1:1 call we'll look at how your listings and sales reach your social accounts, where AI can safely draft the calendar, and which checks stay with you.

Book a 1:1 call with me