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.

 

Click here for more information about Spark or to get started. Below are the instructions you need for the one-time setup of your export file in Sandicor.

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 Multi-Family Custom Export for use with Sandicor in San Diego, CA - 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.

You can either watch the above video or follow the instructions below to complete the one-time setup for Spark in the Sandicor Paragon system. Contact us here if you have problems with the file setup and we will be glad to help.

The following is for Multi-Family export setup. If you want instructions for SFR/Manufactured Homes/Condos/Rentals click here.

  • Once in the results of a search, click the green 'Reports' button.

  • 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'.

  • Verify that the class is '2-4 UNITS' and Group is 'Listing'.

  • Name it 'Spark-Multi'.

  • Click the 'Remove All' button. All fields on the right side should be removed.

  • Add the following categories from the left to the right window until you have all fields listed below in the right column. The order does not matter. If you have too many fields that's okay but you must have AT LEAST the following fields. IMPORTANT: If there are duplicates (e.g. Update Date is listed twice) only choose the first one.

    • # of Units

    • # of Units w/Fireplaces

    • # of Units w/Garage

    • # of Units w/Patios

    • Address

    • Assessor's Parcel #

    • City

    • Close of Escrow Date

    • Complex/Park

    • Concessions

    • Concessions (Y/N)

    • County

    • Days on Market

    • Financing

    • High School

    • Home Owner Association

    • Home Owner Fees

    • Home Owners Payment Freq.

    • Levels

    • List Price (H)

    • Listing Date

    • Listing Type

    • Lot SqFt Approx

    • Max Search Price

    • MLS #

    • Neighborhood

    • Original Price

    • Parking Spaces Tot-Unit 1

    • Parking Spaces Tot-Unit 2

    • Parking Spaces Tot-Unit 3

    • Parking Spaces Tot-Unit 4

    • Pending Date

    • Price Date

    • Prkng Non-Garage Spac-U1

    • Prkng Non-Garage Spac-U2

    • Prkng Non-Garage Spac-U3

    • Prkng Non-Garage Spac-U4

    • Remarks

    • Short Sale

    • Sold Price

    • State

    • Status

    • Status Date

    • Type

    • Unit 1 # Bedrooms

    • Unit 1 # of Full Baths

    • Unit 1 # of Half Baths

    • Unit 1 Estimated SqFt

    • Unit 1 Prkng Garage Space

    • Unit 1 Rent Actual

    • Unit 2 # Bedrooms

    • Unit 2 # of Full Baths

    • Unit 2 # of Half Baths

    • Unit 2 Estimated SqFt

    • Unit 2 Prkng Garage Space

    • Unit 2 Rent Actual

    • Unit 3 # Bedrooms

    • Unit 3 # of Full Baths

    • Unit 3 # of Half Baths

    • Unit 3 Estimated SqFt

    • Unit 3 Prkng Garage Space

    • Unit 3 Rent Actual

    • Unit 4 # Bedrooms

    • Unit 4 # of Full Baths

    • Unit 4 # of Half Baths

    • Unit 4 Estimated SqFt

    • Unit 4 Prkng Garage Space

    • Unit 4 Rent Actual

    • Update Date

    • Year Built

    • Zip

  • 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 should be complete now but make sure that there are no duplicates on the right side (such as Update Date). If there are two of the same thing, delete the last one and keep the first one.

  • It is important that you check 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' and you are done.

Click here to switch to the SFR/Manufactured Home/Condo/Rental instructions.

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-Multi 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).