📊 Every Friday at 6 AM

The Friday Rate Sheet

The rates + the scripts + the playbook. Every Friday.

#21 · JULY 17, 2026

$440,600. That's the new median home sale price. Every past client, every homeowner in your sphere, every neighbor of your last listing just had their equity go up. Pick up the phone.

This Week's Numbers

30-Year Mortgage Rate (Freddie Mac PMMS)

6.55% ↑ 6 bps, highest since August 2025

Daily rate (MND)

6.65% 10-month highs on Iran tension

What that means on a $400K loan (P&I)

~$2,541/mo ↓ ~$53/mo vs. a year ago ($635/yr)

June median home sale price (NAR)

$440,600 all-time record, +1.8% YoY

June pending home sales (NAR)

↓ 5.4% MoM fell in all 4 regions

🚨 Next big rate mover: FOMC decision — Wednesday July 29

Two-day meeting July 28-29. Market pricing 76% chance of hold. Warsh testified before Congress this week and stayed hawkish. Between now and then: PCE Inflation reading Friday July 25 (the other one Warsh watches). Middle East tension pushed oil up 10% in 5 days, which offset the cool CPI print. Rates will move on Iran headlines and PCE.

Source: Freddie Mac Primary Mortgage Market Survey® (PMMS®), week ending 7/16/2026. Daily rate from Mortgage News Daily. Median price and pending sales data from the National Association of REALTORS® June 2026 Existing-Home Sales Report (released 7/9/2026) and Pending Home Sales Report (released 7/16/2026). Rates shown are national averages for a conforming 30-year fixed-rate mortgage and do not represent a personal rate quote or offer to lend. Payment example assumes a $400,000 loan amount, 30-year fixed term, 20% down payment, and does not include taxes, insurance, or PMI. Your actual rate, payment, and costs may vary based on your financial profile. Rate ≠ APR. Not all applicants will qualify.

👀 What The Data Actually Says

Fewer buyers are shopping. Every homeowner in your database just gained equity. The math tells you where to spend your weekend.

Two data points came out this week that should shape every call you make between now and August.

The median U.S. home sale price hit an all-time record of $440,600 in June. Up 1.8% from a year ago. Which is a fine number in isolation, but the useful thing is what it means at the individual homeowner level. A client who bought at $350K in 2020 is likely sitting on $150K to $200K of equity right now. A client who bought at $475K in 2022 has built serious cushion. Almost none of them know exactly where they stand today, because nobody has told them.

Pending home sales dropped 5.4% month over month in June and fell in every region of the country. Yun described the market as "tepid," and he's right. Purchase applications for the first time in three months dipped below last year's pace. Which means fewer new buyers are actively shopping right now than in the spring.

Here is the math nobody's putting together for you. Fewer new buyers shopping AND record-high home prices does not mean less business. It means the business has moved. Your paused pipeline is where the deals are hiding this quarter. Every homeowner who ever said "someday" is standing on more equity than they realize. Every past client from 2020 to 2023 has more room to move than they did in April. Every neighbor of your last listing just watched the comp print at a new number and asked their spouse what their own home is worth.

You do not need more leads this weekend. You need to work the ones already in your phone. The Playbook is a three-circle sequence that turns record-price data into three specific calls.

Your Scripts & Texts for This Week

Fresh audiences. Real coaching. Turn record equity into listing conversations.

🗣️ For Calls & Meetings

Call: Pre-approved buyer 3+ months in, hasn't found the right home (acknowledge-reframe)

"Hey [name], I want to be honest with you. It has been about three months since we got you pre-approved, and I know we have looked at a lot of homes and none of them have clicked. That is not a failure. That is data. What it usually tells me is that either your must-haves list has grown since we started, or the market shifted in a way that changed what your budget actually gets you. Both are worth 20 minutes of real conversation. I want to sit down with you this weekend, not to look at new listings, but to rewrite the must-haves list from scratch based on what you have actually reacted to over the last three months. Saturday morning or Sunday afternoon?"

Call: Sphere contact who mentioned "someday" 6-12 months ago (story-connect)

"Hey [name], I had a client this week that made me think of you. They bought their house in 2019, told me back in October they were thinking about selling 'someday,' and we kind of left it there. This week I pulled comps for their zip code and their equity had grown by almost $180K since they bought. They had no idea. That conversation is happening in a lot of houses right now, and I did not want you to hear it first from Zillow or a Facebook ad. Can I pull the same numbers for your place and walk you through what you are actually sitting on? No listing conversation. Just the math. Coffee this week?"

📱 Copy-Paste Texts — Tap, Copy, Send

Text: Past client from 2020-2023 · The Equity Update

[name], quick one. The median U.S. home sale price hit an all-time record this week. Which means your equity has grown a lot since we closed. I can pull real comps for your street and send you an updated estimate this weekend. Zero pressure. Just so you have the number.

Text: Neighbor of your last listing · The Just-Sold Opener

[name], hey. Sold [address] a few blocks from you and wanted to give you the real number, not the Zillow number. If you have ever been curious what your place would go for in today's market, I can pull it for you this weekend. No pressure, no drop-by. Just the honest comp.

Text: Homeowner with 3% locked-in mortgage · The Equity Access Play

[name], I know you love your rate on your current place. Real question though. If you knew exactly how much equity you have right now and exactly what your options are to keep the low rate AND get more space, would that be a 20-min conversation worth having? Not saying you have to move. Just want you to know the math.

Text: Homeowner who received a property tax reassessment · The Reassessment Reframe

[name], if you got your property tax reassessment in the mail this month and the number felt high, that is the county telling you what your equity looks like. Median home sale prices just hit an all-time record. I can pull an accurate market comp for you this week so you know the real number, not just the county's guess. Want it?

🔨 The Playbook

The Equity Call Playbook. Three circles, one weekend, listing conversations that pay you in fall.

Here is what I see from the lender side that most agents miss. When median prices hit a record and pending sales soften at the same time, the deals are not in new buyer generation. They are in listing conversations with the homeowners already in your phone. Every one of them just gained equity they do not know about. The play this weekend is a three-circle sequence that turns record-price data into three specific calls.

Circle 1: Past clients from 2020 to 2023

Pull your CRM. Every buyer you closed between 2020 and 2023. That is the sweet spot for equity gain right now. Pull real comps for their street, not a Zestimate. Send each of them the number with one line: "The median just hit a record. Wanted you to know where you actually stand." Do not ask for a listing. Do not pitch a refi. Just give them the number. Half of them will reply within 48 hours asking a follow-up question. Those follow-up questions are your listing appointments in September and October.

Circle 2: Sphere contacts who said "someday"

Every friend, family member, or contact in the last 12 months who said some version of "we are thinking about selling someday" and left it there. They are not cold leads. They are warm conversations that stalled because nothing in the market gave them a reason to move. The record price IS the reason. Same process as Circle 1: real comp, one line, no pitch.

⭐ Pro tip from the lender side

A lot of these owners are sitting on a 3 to 4% mortgage from 2020 to 2021 and they think that rate is a reason NOT to move. That is a story you can rewrite for them. There are ways to sell, move up, and keep a blended cost of financing that still works. Send me the ones with sub-4% mortgages. I will pull the real numbers and give you a specific angle for each one before you make the call.

Circle 3: Neighbors of your last three listings

Look at your last three sold or under-contract listings. Pull the 15 closest houses to each. That is 45 doors. Every one of those homeowners just watched a comp print in their neighborhood and asked their spouse "what would ours go for." Send them a short text or postcard with the just-sold number, your name, and an offer to pull the honest number for their address. Not a mass marketing card. A specific number for a specific house.

Starting move this weekend: Pick ten total names across the three circles. Send ten personalized messages. Not a mass campaign, not a template. Ten real numbers to ten real people. Do it Sunday afternoon. By Monday morning you will have three to five replies. By Friday next week you will have at least one listing appointment on the calendar. That is the whole play.

📱 Social Media Post of the Week

Angle: addressed to homeowners who do not know their current equity. Pair with a photo of a recent sold sign or a keys-in-hand shot.

The median U.S. home sale price just hit an all-time record.

Which is a fine number in isolation but here is why it matters for you specifically. If you bought your home anywhere between 2020 and 2023, your equity has grown a lot more than you realize. Most homeowners have not looked at their actual number in over a year. They rely on Zillow, which is off by a mile in either direction, or a random tax assessment number, which is not a market number.

If you want to know exactly what your home would go for right now with real comps on your street, message me. Takes me 20 minutes to pull. No pressure to list, no sales call after. Just the honest number so you know what you are sitting on.

📧 Client Forward Block

Copy everything below and forward to a homeowner in your sphere this weekend.

Homeowner Update — July 17, 2026

Quick note on where the housing market is right now if you own a home.

The median U.S. home sale price hit an all-time record of $440,600 in June, up 1.8% from a year ago. The practical result is that if you bought your home in the last five or six years, your equity has grown a lot. Most people never actually look at their real number and rely on Zillow or a tax assessment, both of which are usually off by tens of thousands of dollars in either direction.

If you have ever been curious what your home is really worth today, or how much equity you actually have, my team can pull real comps for your specific address in about 20 minutes. That number is useful whether you are thinking about selling, thinking about a move up, considering a home equity option to renovate, or just want to know where you stand. It is not a sales conversation. It is just the honest number.

Hit reply if you want it.

This is a general market overview based on national averages from the National Association of REALTORS® June 2026 Existing-Home Sales Report. Not an offer to lend and not a personal home valuation. Cole Brantley, NMLS# 1905939. Mpire Financial, NMLS# 2108504. Equal Housing Lender.

🤖 AI Tip of the Week

The Equity Message Generator. Turn any past client's info into a personalized equity update in 60 seconds.

The Playbook this week asks you to send ten personalized messages, not a mass template. Ten real numbers to ten real people. That sounds like it will take you all afternoon. It does not have to. This prompt writes each one for you.

Open Claude or ChatGPT. Paste this and fill in the brackets for each client:

"I am a real estate agent reaching out to a past client. Here is what I know about them: [FIRST NAME, WHAT YEAR THEY BOUGHT, WHAT THEY PAID, WHAT ZIP CODE OR NEIGHBORHOOD, AND ONE PERSONAL DETAIL FROM WHEN WE WORKED TOGETHER]. Their estimated current home value is [PULL FROM COMPS OR ESTIMATE]. Write me one short text under 55 words that: (1) shares their approximate equity gain in dollar terms as a positive update, (2) offers to send them a real comp for their specific street, (3) sounds like a friend, not a marketer. Do NOT use the phrases 'just wanted to reach out,' 'hope you're doing well,' or 'checking in.' Make it feel personal to what I mentioned about them."

Read the output, adjust one or two phrases so it sounds like you, send it. Ten of these takes 30 minutes instead of an afternoon. Every one of them lands as a real, personal message. That is how you turn record-price data into ten listing conversations this weekend.

🍽 Next Lunch & Leads

Claude Advanced

Thursday, July 23 at 12 PM ET. Learn how to use Claude to scrape expired listings and FSBOs so you can turn them into your next listing appointments. Bring lunch. Free to join.

Grab Your Seat →

🏆 The Friday Question

First 5 to text the right answer get coffee on me.

Read the issue. Find the answer. Be fast. That's the whole game.

This week's question

"What was the all-time record median U.S. home sale price reported by NAR for June 2026?"

Text the answer to

(813) 579-8812

First 5 correct answers before 12:00 PM ET today win. One entry per agent.

📈 What Moved Rates This Week

The week of contradictions. Inflation cooled harder than anyone predicted. Rates went up anyway.

Tuesday. CPI dropped the biggest one-month decline since April 2020. Headline inflation printed at 3.5% year over year, down from 4.2% in May and well below the 3.8% consensus. Core CPI came in at 2.6%, also below the 2.9% forecast. Energy fell 5.7%, gasoline dropped 10%, and even the "supercore" measure that the Fed watches came in negative for the month. In a normal week, this reading pushes bond yields down and mortgage rates with them.

The week was not normal. On the same day, the U.S. resumed its blockade of Iranian ports. Oil prices had already climbed 10% over the previous five days on renewed Middle East tension. Every dollar of oil pressure feeds directly into future inflation expectations, and the bond market read the situation as "the June CPI print was collected before the latest tension. It is going to look different in July." Bond yields drifted up. Mortgage rates followed.

Wednesday. PPI also came in cool. Wholesale prices dropped 0.3% for the month, biggest decline since April 2025, with the annual reading falling to 5.5% from 6.0%, well below the 6.2% forecast. Fed Chair Warsh testified before Congress for his semi-annual hearing and stayed hawkish, repeating "price stability" language. Traders raised September rate hike odds back above 50% despite the cool inflation readings.

Thursday. Pending home sales for June came in at -5.4% month over month, with sales falling in every region. Yun described the market as "tepid," particularly for first-time buyers dealing with the record-high median price and elevated rates. Freddie PMMS came in at 6.55%, up 6 basis points and the highest reading since August 2025.

The setup for next week. PCE inflation drops Friday July 25. It is the OTHER inflation reading Warsh watches, and it will be the last major data print before the FOMC meets on July 28-29. If PCE comes in as cool as CPI did, rates could ease. If Iran tension continues to push oil higher, they will not.

🤝 How to Refer a Client to Me

Four steps. Real process. Your client gets answered same-day, every time.

1. Reach out to me first

Text, email, or call me with the client's info and any notes about their situation. More context up front means better first conversation.

2. Introduce us in a 3-way text

Example: "Hey [name], this is Cole Brantley, the mortgage broker I told you about. He's going to reach out to set up a time to talk through your options."

3. I take it from there

I reach out 7 times over 4 days with calls and texts to set a consultation. After every conversation, you get a recap of where things stand and what's next.

4. Long-term follow-up (no one gets forgotten)

If the client doesn't respond after the first week, they move to biweekly follow-up from my call center team. No lead dropped. Lower-intent client? Just note it up front and we match whatever cadence you want.

Cole Brantley · (813) 579-8812 · [email protected] · NMLS# 1905939

That's the Sheet

Ten names, three circles, one weekend. Past clients from 2020 to 2023, sphere contacts who said "someday," and neighbors of your last three listings. Send ten real numbers to ten real people. Do it Sunday afternoon. By Monday morning you will have three to five replies, and by next Friday you will have at least one listing appointment on the calendar. That is the play. The record price is the ammunition. Your database is the pipeline.

🧠 Weird Stat of the Week

Pending home sales in June fell in every single region of the country. Every one. That has not happened since April 2020, when nobody was allowed to leave their house. The interesting part for you is not that sales softened. The interesting part is that a lot of homeowners just paused a decision they were about to make. Every one of those paused decisions is a listing conversation you can restart with a phone call.

If The Friday Rate Sheet helps you have better client conversations, send it to one agent who needs better Fridays.

Forward this to an agent →

Compliance & Disclosures

Cole Brantley, Loan Officer, NMLS# 1905939. Mpire Financial, NMLS# 2108504. 189 S Orange Ave #2020, Orlando, FL 32801. Equal Housing Lender.

Mortgage rate data sourced from the Freddie Mac Primary Mortgage Market Survey® (PMMS®) for the week ending July 16, 2026, and from Mortgage News Daily. Housing data from the National Association of REALTORS® June 2026 Existing-Home Sales Report (released 7/9/2026) and Pending Home Sales Report (released 7/16/2026). Inflation data from the U.S. Bureau of Labor Statistics Consumer Price Index Summary (June 2026, released 7/14/2026) and Producer Price Index Summary (June 2026, released 7/15/2026). Mortgage application data from the Mortgage Bankers Association Weekly Applications Survey for the week ending 7/10/2026. Rates shown are national averages and do not represent a personal rate quote, commitment to lend, or offer to extend credit.

Payment example assumes a $400,000 loan amount, 30-year fixed-rate term, 20% down payment, conforming conventional loan, borrower with excellent credit, and does not include taxes, insurance, HOA dues, or mortgage insurance. APR will differ from the note rate based on points, fees, and other loan costs. Your actual rate, APR, monthly payment, and total loan costs will depend on your specific financial profile, credit, loan amount, property type, and other factors. Not all applicants will qualify.

This newsletter is intended for real estate professionals for educational and informational purposes only. It is not financial advice and is not an offer to lend. The Client Forward Block is a general market overview suitable for sharing with clients but does not constitute a personal rate quote or personal home valuation. The Friday Question is a casual engagement feature for active subscribers and is not a solicitation for mortgage business. Participation is not contingent on any business relationship.

Verify NMLS licensing at nmlsconsumeraccess.org.

Keep reading