Pricing a Listing Against a Zestimate and a Neighbor's Wish
Carol is taking a listing outside Fairbanks: 2,150 sq ft, 3 bed / 2 bath, 1.1 acres, no shop, good condition. Local MLS data (adjustment rate used in the market is $100 per sq ft of gross living area; acreage differences are negligible at this size; condition adjusted at cost):
- Comp A: 2,050 sq ft, 1.0 acre, no shop, sold 4 months ago for $362,000. Normal exposure, retail buyer.
- Comp B: 2,300 sq ft, 0.8 acre, REO sold 2 months ago for $395,000, cash to an investor; needs a $25,000 roof today.
- Comp C: identical floor plan, 2,150 sq ft, 1.1 acre, sold 14 months ago for $340,000. Market has appreciated about 4% per year. Seller Dan says: 'My neighbor listed at $435,000, Zillow says $432,100, and I need to net $150,000 after paying off $210,000, your 6%, and about $4,000 in closing costs.'
1. Adjust the three comparables and build a defensible value range. Explain how much weight each deserves.
Read the worked answer
Adjustments (subject-first: add to the comp if the comp is inferior, subtract if superior)
| Comp | Sale price | GLA | Condition | Time | Adjusted |
|---|---|---|---|---|---|
| A | $362,000 | +$10,000 (+100 sf × $100) | $0 | $0 (4 months, stable) | $372,000 |
| B | $395,000 | −$15,000 (−150 sf × $100) | +$25,000 (roof) | $0 | $405,000 |
| C | $340,000 | $0 (identical) | $0 | +$15,947 ($340,000 × 1.04^1.167 ≈ ×1.0469) | $355,947, call it $356,000 |
Weighting
- Comp A gets the most weight (~45%) - recent, arm's-length, retail buyer, similar condition and site. It is the cleanest evidence.
- Comp B (~25–30%) - the roof adjustment is defensible, but the sale was cash to an investor out of an REO. REO/cash sales typically clear a few percent below retail. If the local discount is about 3%, deduct roughly $12,000 more, moving the indicator to about $393,000. Use it as an upper bracket, not a target.
- Comp C (~25%) - same plan and site, which is valuable, but 14 months stale. A straight 4%/year time adjustment assumes a smooth market; verify with a repeat-sale or paired sale before leaning on it. It supports the floor of the range, not the middle.
Reconciled range: about $372,000 to $393,000, with the market value most likely in the $380,000–$390,000 band. A broader defensible range is $356,000–$405,000 if someone asks.
2. Recommend a list price and expected sale price, then test Dan's $150,000 net requirement against your recommendation.
Read the worked answer
Pricing recommendation
- List at $394,900 to $399,900. Listing near the top of the adjusted range attracts the buyers who are shopping that bracket; listing at the top of the unadjusted range ($405,000) invites appraisal problems without adding traffic.
- Expected sale price: $385,000–$395,000, in roughly 45–90 days, assuming typical exposure time and a normal negotiation. Expect a buyer to ask for closing-cost help or repairs, which is a price concession in disguise.
Dan's net need - solve for the minimum price
Net = Price × 0.94 − $210,000 payoff − $4,000 closing costs Set net = $150,000: 0.94P = $150,000 + $210,000 + $4,000 = $364,000 P = $387,234
Sanity checks at nearby prices:
- At $392,000: $368,480 − $214,000 = $154,480 - meets the goal with about $4,500 of cushion.
- At $385,000: $361,900 − $214,000 = $147,900 - misses by $2,100.
The message for Dan: his net requirement is satisfied at a market price near $388,000 and up, which is inside the recommended range. That is exactly the argument against reaching for $429,000 - he does not need a high price to hit his number, but he does need a sale. A listing that sits and then gets cut twice typically lands below the price he would have gotten at $394,900 on day one, and the carrying costs (taxes, heat, insurance) eat the difference.
3. Dan insists on listing at $429,000. How do you handle it professionally, and what line should you not cross?
Read the worked answer
Take it or leave it - but paper the file.
What you may do
- List it at $429,000 if Dan directs it in writing. A licensee executes the client's lawful instructions; the client owns the pricing decision.
- Deliver the CMA in writing, with the adjustment grid, and have Dan acknowledge receipt. Document the conversation.
- Build in protection: a defined listing term, an automatic price-review meeting at 21–30 days with a defined reduction if showings and offers fall below a stated threshold, and a written understanding of the marketing budget.
- Disclose agency status in writing and confirm Dan understands that the CMA is not an appraisal.
What you may not do
- Do not call your CMA an appraisal or guarantee a value. Pricing analysis by a licensee is a broker price opinion/CMA, not a USPAP appraisal. Alaska requires state certification to perform appraisals.
- Do not tell Dan what he wants to hear. Advising that $429,000 is realistic when your own grid says $372,000–$393,000 is a misrepresentation, even if it wins the listing.
- Do not let the listing agreement become a promise. No guaranteed sale price, no guaranteed marketing time.
Risks to spell out for Dan
- Appraisal risk. Buyers finance against the lower of price or appraised value. A $429,000 contract on a $390,000 house is a renegotiation waiting to happen, and the renegotiation happens after the seller has already moved out and lost months.
- Stale inventory. Days on market accumulates; buyers and their agents read it as a defect signal. Price cuts after 60 days usually overshoot downward because the market smells blood.
- The neighbor and the Zestimate are not evidence. The neighbor's $435,000 is an asking price - it may sit or sell at $400,000. An automated valuation model is not a sale, has no inspection, and does not know about the roof, the shop, or the acreage. Say this plainly, with the three closed sales in front of him.
If Dan still insists and the file is thin, decline the listing. A listing you cannot defend at a price you know is wrong is a future complaint, and the file will be your only defense.