Choice Valuation, PLLC

Your choice for residential appraisals and appraiser products

Performing single- and multi-family residential appraisals and creating simple, useful software for appraisers.

Below are the instructions you need for the one-time setup of your export file in Triangle MLS.

When the one-time file setup below is complete, you can click here to get started.  If, for any reason, you have trouble with the file setup in your MLS contact us here for assistance.

Please contact us immediately if you ever experience a problem with the listing information not being entered correctly into your report.

Creating a Custom Export for use with the Triangle MLS Paragon System

MLS export files that are uploaded to Spark must be in a specific format in order to provide both accurate data and all possible fields.

Follow the instructions below to complete the one-time setup for Spark in the Triangle MLS Paragon system. Contact us here if you have problems with the file setup and we will be glad to help.

These are the instructions for the Residential/Rental setup. To see the instructions for the setup specific to multi-family properties click here.

  • Once in the results of a Residential search, click the green 'Reports' button. (**NOTE: You will need to repeat this for Rentals)

  • Under the Spreadsheets folder choose any spreadsheet that you don't normally use because you're going to be modifying it.

  • Click 'Customize' and then 'fields'.

  • Name it 'Spark' (when doing this process for Rentals name it 'Spark Rental').

  • Add the following categories from the left to the right window until you have all fields listed below in the right column. Some of the fields will already be on the right and that's okay. The order does not matter. You also need to make sure and uncheck every box on the right under the heading 'Short Lbl' and 'Short Val'.  If you have extra fields that's okay but you must have AT LEAST the following fields. As noted above you must repeat this process for Rentals. Some items are different for Residential & Rentals and those will be noted.

    • # Baths Above Grade

    • # Baths Below Grade - NOT IN RENTAL LIST

    • # of Rooms

    • Address

    • Agent Remarks - NOT IN RENTAL LIST

    • Approx Ft of Wtr Frontage

    • Approx Lot SqFt - NOT IN RENTAL LIST

    • Approximate Acres - *RENTAL LIST ONLY

    • Basement

    • Bedroom 2 Floor

    • Bedroom 3 Floor

    • Bedroom 4 Floor

    • Bedroom 5 Floor

    • Bedrooms

    • Bonus Room Floor

    • Breakfast Room Floor

    • Carport Dimensions - NOT IN RENTAL LIST

    • City

    • Class

    • Closing Date - NOT IN RENTAL LIST

    • Construction Type - NOT IN RENTAL LIST

    • Contract Date

    • County

    • Cumulative DOM

    • Days on Market

    • Deck Floor - NOT IN RENTAL LIST

    • Detached Living Area SqFt - NOT IN RENTAL LIST

    • Dining Room Floor

    • Family Room Floor

    • Financial Concessions

    • Fireplace

    • Full Baths

    • Garage

    • Garage Dimensions - NOT IN RENTAL LIST

    • Half Baths

    • High School 1

    • HOA 1 Fee Payment - NOT IN RENTAL LIST

    • HOA 1 Fees $ - NOT IN RENTAL LIST

    • HOA 2 Fee Payment - NOT IN RENTAL LIST

    • HOA 2 Fees $ - NOT IN RENTAL LIST

    • Kitchen Floor

    • Legal Description - NOT IN RENTAL LIST

    • List Date

    • List Price

    • Living Area Above Grade

    • Living Area Below Grade

    • Living Room Floor

    • Lot Dimensions

    • Lvng Area/Other Rm 1 Desc

    • Lvng Area/Other Rm 1 Lvl

    • Lvng Area/Other Rm 3 Desc

    • Lvng Area/Other Rm 3 Lvl

    • Master Bedroom Floor

    • MLS #

    • Neighborhood

    • Office/Study Floor

    • Original Price

    • Other Area Below Grade

    • Other Area/Room 2 Desc

    • Other Area/Room 2 Lvl

    • Other Area/Room 4 Desc

    • Other Area/Room 4 Lvl

    • Other Concessions

    • Ownership Type

    • Patio Floor - NOT IN RENTAL LIST

    • PIN #

    • Porch Floor - NOT IN RENTAL LIST

    • Price Date

    • Property  Description

    • Property Type

    • Rental Date - *RENTAL LIST ONLY

    • Rented Price - *RENTAL LIST ONLY

    • Remarks

    • School District Link

    • Screened Porch Floor - NOT IN RENTAL LIST

    • Sold Price - NOT IN RENTAL LIST

    • State

    • Status

    • Status Date

    • Storage Floor

    • Subdivision

    • Tax ID

    • Tax Map/Blk/Prcl/Lot

    • Terms of Sale

    • Unit #

    • Utility Room Floor

    • Waterfront Access

    • Waterfront Type

    • Year Built

    • Zip

    • Zoning

  • At the top of the window click on the Group drop-down and change it from 'Listing' to 'Feature Categories'.

  • In the new list of fields on the left select each one (all of them) and move them over to the right side.

  • The list is now complete.

  • As noted above, it is important that you verify the boxes on the right to make sure that none of them for either 'Short Lbl' or 'Short Val' are checked. They should all be unchecked.

  • Click 'Save'. I have had issues with Paragon not saving the information on occasion so you should verify that your changes were saved by clicking on 'Customize' then 'Fields' again and make sure the list on the right looks like the one you just made.

  • If you have any problems with this MLS setup or with Paragon not saving your list please call or email and I will be glad to help. Click here to contact us.

These were the instructions for the Residential/Rental setup. To see the instructions for the setup specific to multi-family properties click here.

How to Export your Data

  • Verify that the search you are exporting includes the sales/listings/rentals you want to put into the grid(s) of your appraisal report.

  • Click 'Export' then 'Export to CSV'.

  • Select the appropriate box for whether you want to export all in your results or just the selected.

  • Choose Spark as your selected export (or whatever you named the custom export you created) from the drop-down and click 'Export'.

  • Save the file by whichever file name and into whichever folder you prefer (depending on browser settings you may not be given the option to choose the file name/location).

  • Now load Spark by going to app.sparkforappraisers.com and follow the steps.

Note: Spark can input a maximum of 30 properties for each grid (sales grid/listing grid/rental grid) and a maximum of 10,000 for your 1004MC files (Competing and/or Neighborhood File).