Lesson 18 · 4:21
Market
Import an MLS export of manufactured homes on acreage into Market Trends, fill the Market section from it, and use the price trend for the commentary.
Transcript
Market
The Market section describes the subject's market: how many competing homes are listed, pending and sold, which way prices are moving, and how long homes take to sell. Open it from the section list. It's still empty, because it's built from a market pool of MLS data we haven't imported yet.
Import the MLS export
The pool comes from your MLS, and it has to be the subject's segment: double-wide and triple-wide manufactured homes on 1 to 15 acres. Homes like that trade infrequently, so we searched 10 miles around the subject: every sale that closed in the last 12 months, plus the listings on the market in that window. Open Market Trends on the right. There's no pool yet, so choose Import. Choose the MLS the export came from, Northwest MLS, then drop in the file. Upload. DataMaster looks up each MLS number in the file and pulls in the full listing. It keeps every property the file lists, so narrow the search in your MLS before you export. Here, that left out the site-built houses, and the manufactured homes in parks, on rented spaces. Once the listings are in, DataMaster computes the market statistics and fills in the Market section. You can leave the page meanwhile: the import keeps going in the background.
What the pool shows
When it's done, the drawer shows the pool. Summary Statistics gives the median of each measure: sale price, living area, site size, year built, days on market, and more. Open one to see how the pool spreads around that median. Current Inventory counts the active, pending and sold listings, gives their price ranges, and reads the market: demand and supply, and marketing time.
Filled from the pool
The import already wrote these figures into the Market section. Fill Report writes them again whenever the pool changes, say after you import more listings. Search Criteria Description came in as a generic range of living area, site size and year built. Ours was narrower, so describe the search we actually ran.
Listings, pendings and sales
Search Result Metrics come straight from the pool: 10 active listings with their days on market and list prices, 3 pending sales, and 28 sales in the 12-month lookback period, with their prices. Distressed Market Competition came in as No, from the sale conditions in the pool. Price Trend Source is MLS.
Graphs for the report
Under Graphs are the five charts UAD 3.6 names, drawn from the pool: price trend, absorption rate, percent of distressed sales, year built of sales, and median days on market. Check the ones the report includes: Price Trend, Absorption Rate, and Median Days on Market. Each checked graph goes into the report with this section.
Price trend
Now open Adjustments on the right. It works from the same pool's closed sales. Time Adjustments tracks a like-for-like price index built from those sales. Prices have barely moved: up 0.78 percent over the last six months, and flat since July. Below the month-by-month table, the supporting statement says how the trend was measured, and over what period. Feature Adjustments lists the rates the same sales support, like this one for above-grade living area. Each opens into its range and its own statement. With only 28 sales, treat them with care. We'll come back to them once the comps are on the grid.
Boundary and price trend
Market Area Boundary is ours to describe. Our market is the area we searched: 10 miles around the subject, across three counties. Price Trend Analysis Commentary has to say what the trend is and what we did with it. The index is essentially flat, so we call the market stable, and make no time adjustment.
Supply and marketing time
Housing Trends came from the pool as well. It reads Shortage, but 10 listings against 28 sales a year is about four months of supply, typical for rural homes like this one. We call it In Balance. Homes sell in under 3 months. In Market Commentary, we note why the search reached this far: homes like this trade infrequently.
Subject Listing Information
That's the Market section. Next, Subject Listing Information.