Lesson 22 · 7:23

Sales Comparables

Import the manufactured home comps from an MLS export, map its MLS number column, review their source data, and complete the grid, manufactured home rows included.

Watch this lesson in DataMasterSign in to your DataMaster account to watchSales Comparables — UAD 3.6 Manufactured Home Report

Transcript

Sales Comparables

Now the comparable sales. We'll import the five comps selected for this assignment from an MLS export, review what came in, and complete each one in the grid. Open the Sales Comparison Grid from the section list, under Sales Comparison Approach.

Import the comps

Select Add or Import Comps, and open the MLS Upload tab. It takes an export file from your MLS, with up to fifteen properties. Choose the MLS the file came from: Northwest MLS. From the eleven double-wides in our comparables export, we picked five, and exported just those as a CSV file. Drop it here, or click to browse. Select Upload. DataMaster reads the file, looking for each listing's MLS number.

Which column is the MLS number?

This is a raw Northwest MLS export, with the MLS's own column names, so DataMaster asks which column holds the MLS number. Here, it's ListingNumber. Continue. Now DataMaster can look each listing up in your MLS.

What matched

The review shows what matched. All five MLS numbers were found, and none were skipped as duplicates of comps already in the report. Select Import. DataMaster pulls each listing from the MLS and matches it to public records: the photo, the sale, the site, and the home. With five listings, each matched to its county record, it takes a few moments.

What came in

Each sale fills its own column beside the subject, in the order of the file. The header shows the comp's number and address. Take comp 2. Data Source names the assessor record and the MLS listing. Proximity to Subject is measured from the subject: 0.51 miles southeast, the closest of the five. Then the sale: the list and sale prices, the contract and sale dates, and days on market. Further down are the site size, 4.9 acres for comp 2, the year built, the construction method, Manufactured for every comp, and the rooms and finished area.

The source data

To review what an import brought in, open Property Data in the right rail, and choose a property. Here, comp 2. Records lists the data from each source: the public record, and the MLS listing. Photos has every listing photo, and History the property's earlier sales and listings. Close the panel to give the grid its room back.

Addresses

Now check every column. Shaded cells are required answers that are still empty, or values to look at. Start at the top. The export put the city, state and ZIP code into each comp's street line, so they'd print twice. Open each address, and keep just the street: the house number, the street name and its direction. The city, state and ZIP code have their own fields, which the report prints after the street. Do the same for all five comps.

Concessions

Sales Concessions is required. Comp 1's listing reports $35,000 in seller concessions. Open the cell: Concession in Contract, Yes. Amount Known, Yes, and enter the amount. Comp 3's listing reports a $10,000 credit, entered the same way. Comp 5's listing says there was a concession, but not how much: Yes, with the amount not known.

Copy from the subject

Hazard Zone is required for every comp. Like the subject, none of these sales is in a hazard zone, so open the subject's cell and copy it to all comps. A message confirms the copy. Site Influence and View are required too. All five sit on wooded rural acreage like the subject, so copy its Residential site influence to every comp, and then its partial wooded view. Each copy fills five cells at once, and a message confirms it. Then the rows a manufactured home adds. Manufactured Home Width: all five comps are double-wides, multi-section homes like the subject, so copy Multi to every comp. And none of them has a basement, so copy the subject's zero for Unfinished Area Below Grade to every comp as well.

A stray entry

Comps 1 and 4 list wood as a second heating fuel, with no heating system. Comp 4's wood stove is in its stable, not the home, and comp 1's listing names none. So delete that entry from each.

Garages

Vehicle Storage needs a count and an attachment type for every entry. The subject has only a gravel driveway; every comp has a garage, so these rows matter. Comp 1 has a detached carport and a detached garage, two spaces each: set each entry's count and attachment. Comp 2 has a two-car detached garage. Its driveway entry has no count, and adds nothing over the subject's own driveway, so delete it. Comp 3's three-car garage is attached to the home. Comp 4's three-car garage and comp 5's one-car garage are detached. Now every entry has its count and its attachment type.

Our ratings

Quality and condition aren't in the MLS data; they're our ratings, for the exterior, the interior, and overall. Start from the subject: copy its Q3 and C3 to every comp, one row at a time. Q3 is a step above standard: some customization, with a mix of premium and standard finishes. C3 is well maintained, with minimal wear and tear, or with most components updated. Then the overall ratings, which sum up the exterior and the interior: copy the subject's Q3 and C3 across those two rows as well. Comps 2 and 5 have lower quality kitchens and flooring than the subject: standard plans and materials, with a mix of standard and economy finishes. That's Q4, on the exterior, the interior and overall. Comps 2, 3 and 5 show worn roofs, siding, floor coverings and fixtures. In UAD 3.6, C4 means adequately maintained, with moderate wear and tear, and deferred maintenance that's generally minor or cosmetic, like worn floor finishes, or a kitchen that's dated but works. Rate them C4, in all three rows. Rate from the listing photos and remarks, and from what you saw when you drove by. The rating is your opinion, not the listing agent's, and every comp is rated on the same scale as the subject.

The comps' history

With the comps in place, finish their history in Prior Sale and Transfer History. Their public-record transfers came in with the import: comp 1 sold in August 2025, seven months before its sale, and comp 4 had a deed recorded in February 2025. Explain them in the Analysis of Prior Sale and Transfer History of Comparable Sales: comp 1's earlier sale, before its renovation, and comp 4's deed.

Adjustments

The comps are in and checked. Next, we'll adjust them for their differences from the subject.