Process for automated real estate valuation

• US 20010039506A1
• Filed: 04/04/2001
• Published: 11/08/2001
• Est. Priority Date: 04/04/2000
• Status: Abandoned Application

• Current Assignee: Taurean Group LLC
• Original Assignee: Taurean Group LLC
• Inventors: Robbins, Michael L.
• Application Number:
  US09/825,642
• Publication Number:
  US 20010039506A1
• Time in Patent Office: Days
• US Class Current: 705/10
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/06395 Quality analysis or management
• CPC Class Codes: G06Q 30/0204 Market segmentation
• CPC Class Codes: G06Q 30/0205 Location or geographical consideration
• CPC Class Codes: G06Q 30/0206 Price or cost determination based on market factors
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03

Abstract

A real estate appraisal method wherein a database of enhanced records of properties in a the same territory as the subject property is used to derive market-driven value adjustment rates for property attributes and time differentials. The adjustment rates are applied to the properties in the database, the most similar comparable properties are selected on the basis of similarity in property attributes and the market value is then estimated from the selected most similar comparable properties. The resulting valuation is supportable by market conditions and can be printed on specified forms.

Claims

1. A method of determining an estimated value of a subject parcel of real estate, the method comprising the steps of:

A. constructing a valuation model based on the attributes by means of statistical analysis of a database comprising records for individual parcels of real estate, wherein the records comprise attributes of the individual parcels and wherein the parcels are not owner-occupied residential real estate;

B. determining a sale condition score for the individual parcels, wherein the sale condition score is based on the statistical fit of an actual recorded sales price for the individual parcel to a sales price predicted by the valuation model based on the individual parcel attributes; and

,

C. adding the sale condition to the attributes recorded for the respective individual parcels.

2. The method of

claim 1

wherein the individual parcels of real estate comprise the subject parcel.

3. The method of

claim 1

wherein the database comprises records for the majority of individual parcels of real estate located within a selected territory comprising the subject parcel.

4. The method of

claim 3

wherein the selected territory is the county or municipality comprising the subject parcel.

5. The method of

claim 1

wherein a default value is assigned as the sale condition score for an individual parcel if no sales price information is available for the parcel.

6. The method of

claim 1

, wherein the database comprises enhanced records.

7. The method of

claim 6

wherein the database of enhanced records is compiled by a process comprising the steps of:

(i) obtaining records of the individual real estate parcels, wherein the records comprise attributes of the individual real estate parcels;

(ii) checking the records for errors and/or missing information;

(iii) correcting the records by replacing missing or incorrect values with statistically estimated replacement values;

(iv) enriching the corrected records by adding additional attributes; and

(v) creating derived attributes for the individual real estate parcels by modeling the enriched records.

8. The method of

claim 7

, wherein the compiling process further comprises the steps of:

(vi) identifying the individual real estate parcels by respective geocode reference; and

(vii) correlating the individual real estate parcels to the Census Tract and Block Group which contains the respective individual real estate parcel by means of the geocoding reference.

9. The method of

claim 8

wherein the replacement values are statistically estimated based on the attributes of individual parcels located in the same region as the parcel having missing and/or incorrect information.

10. The method of

claim 9

wherein the region is selected from the group consisting of census geography, block, block group, borough, tract, traffic analysis zone, consolidated metropolitan statistical area, metropolitan statistical area, census metropolitan area, census agglomeration, statistical division, statistical subdivision and detailed statistical region.

11. The method of

claim 1

, further comprising the steps of:

D. selecting potentially similar comparable transactions by means of searching the database on the basis of the subject parcel attributes;

E. determining an attribute score for each of the potentially similar comparable transactions;

F. selecting the most similar comparable transactions based on the attribute scores;

G. adjusting the sales price of each of the most similar comparable transactions by applying attribute value adjustments and/or time value adjustments; and

H. determining the estimated value of the subject parcel on the basis of the adjusted sales price of the most similar comparable transactions.

12. The method of

claim 11

, wherein selecting potentially similar comparable transactions further comprises applying attribute filters.

13. The method of

claim 11

, wherein any of the most similar comparable transactions may be replaced by alternative comparable transactions.

14. The method of

claim 11

, wherein the attribute value adjustments are determined from statistical modeling of the database.

15. The method of

claim 11

, wherein the time value adjustments are determined from statistical modeling of the database.

16. The method of

claim 11

, wherein the attribute adjustment rates are calibrated.

17. The method of

claim 11

further comprising the step of determining a quality score based on the similarity of the attributes of the most similar comparative transactions which were used to estimate the value of the subject parcel to the attributes of the subject parcel.

18. The method of

claim 17

further comprising the step of creating a report.

19. The method of

claim 18

further comprising the step of creating a map showing the locations of the subject property and the most similar comparative transactions which were used to estimate the value of the subject parcel.

20. The method of

claim 19

further comprising the step of exporting the report and the map.

21. The method of

claim 1

wherein the attributes include at least one of location relative to major thoroughfares, distance to the nearest stores, distance to schools, social/economic status of the neighborhood, fireplaces, garage, square footage, square footage per room, condition, number of bathrooms, view, location relative to flood plains or soil conditions.

22. The method of

claim 11

wherein a prechosen value can be substituted for a determined value and/or a different comparable transaction can be substituted for at least one comparable transaction used to estimate the value of the subject parcel.

24. The method of

claim 11

wherein a special condition attribute is attached to the subject parcel record.

25. The method of

claim 13

wherein a similarity index is determined for each comparable.

23. The method of 22 wherein different levels of access are provided to the substitutions of 22.

26. A method of determining an estimated value of a subject parcel of real estate, the method comprising the steps of:

A. determining market derived attribute adjustment values by means of statistical analysis of a database comprising records for individual parcels of real estate, including the subject parcel, within a territory comprising the subject parcel, wherein the records comprise attributes of the individual parcels and wherein the parcels are not owner-occupied residential real estate; and

B. adjusting recorded actual sales prices for individual parcels by applying selected attribute adjustment values to the sales price, wherein the applied attribute adjustment values are selected based on a comparison of the attributes of the subject parcel and the attributes of the respective individual parcels.

27. The method of

claim 26

wherein the database comprises enhanced records.

28. The method of

claim 27

wherein the database of enhanced records is compiled by a process comprising the steps of:

(i) obtaining records of the individual real estate parcels, wherein the records comprise attributes of the individual real estate parcels;

(ii) checking the records for errors and/or missing information;

(iii) correcting the records by replacing missing or incorrect values with statistically estimated replacement values;

(iv) enriching the corrected records by adding additional attributes;

(v) creating derived attributes for the individual real estate parcels by modeling the enriched records; and

(vi) adding the derived attributes to the enriched records.

29. The method of

claim 28

wherein the derived attributes comprise a geocode reference.

30. The method of

claim 28

wherein the replacement values are statistically estimated based on the attributes of individual parcels located in a region comprising the parcel having missing and/or incorrect information.

31. The method of

claim 30

wherein the region is selected from the group consisting of census geography, block, block group, borough, tract, traffic analysis zone, consolidated metropolitan statistical area, metropolitan statistical area, census metropolitan area, census agglomeration, statistical division, statistical subdivision and detailed statistical region.

32. The method of

claim 26

, further comprising the steps of:

D. selecting potentially similar comparable transactions by means of searching the database on the basis of the subject parcel attributes;

E. determining an attribute score for each of the potentially similar comparable transactions;

F. selecting the most similar comparable transactions based on the attribute scores; and

G. determining the estimated value of the subject parcel on the basis of the adjusted sales price of the most similar comparable transactions.

33. The method of

claim 32

, wherein selecting potentially similar comparable transactions further comprises applying attribute filters.

34. The method of

claim 32

, wherein any of the most similar comparable transactions may be replaced by alternative comparable transactions.

35. The method of

claim 26

, wherein the attribute adjustment rates are calibrated.

36. The method of

claim 32

further comprising the step of determining a quality score based on the similarity of the attributes of the most similar comparative transactions which were used to estimate the value of the subject parcel to the attributes of the subject parcel.

37. The method of

claim 36

further comprising the step of creating a report.

38. The method of

claim 37

further comprising the step of creating a map showing the locations of the subject property and the most similar comparative transactions which were used to estimate the value of the subject parcel.

39. The method of

claim 38

further comprising the step of exporting the report and the map.

40. The method of

claim 26

wherein the attributes include at least one of location relative to major thoroughfares, distance to the nearest stores, distance to schools, social/economic status of the neighborhood, fireplaces, garage, square footage, square footage per room, condition, number of bathrooms, view, location relative to flood plains or soil conditions.

41. The method of

claim 32

wherein at least one attribute adjustment value is preset as a constant prior to determining the remaining attribute adjustment rates by means of statistical analysis.

42. The method of

claim 32

wherein a prechosen value can be substituted for a determined value and/or a different comparable transaction can be substituted for at least one comparable transaction used to estimate the value of the subject parcel.

44. The method of

claim 32

wherein a special condition attribute is attached to the subject parcel record.

45. The method of

claim 32

wherein a similarity index is determined for each comparable.

43. The method of 42 wherein different levels of access are provided to the substitutions of 42.

46. A method of determining an estimated value of a subject parcel of real estate, the method comprising the step of compiling a database comprising enhanced records for substantially all of individual parcels of real estate in a territory which comprises the subject parcel, wherein the enhanced records comprise recorded attributes and derived attributes of the individual parcels and wherein the parcels are not owner-occupied residential real estate.

47. The method of

claim 46

wherein the individual parcels comprise the subject parcel.

48. The method of

claim 46

wherein the database of enhanced records is compiled by a process comprising the steps of:

(i) obtaining records of the individual real estate parcels, wherein the records comprise attributes of the individual real estate parcels;

(ii) checking the records for errors and/or missing information;

(iii) correcting the records by replacing missing or incorrect values with statistically estimated replacement values;

(iv) enriching the corrected records by adding additional attributes;

(v) creating derived attributes for the individual real estate parcels by modeling the enriched records; and

(vi) adding the derived attributes to the enriched records.

49. The method of

claim 48

, wherein the compiling process further comprises the steps of:

(vii) identifying the individual real estate parcels by respective geocode reference; and

(viii) correlating the individual real estate parcels to the Census Tract and Block Group which contains the respective individual real estate parcel by means of the geocoding reference.

50. The method of

claim 48

wherein the replacement values are statistically estimated based on the attributes of individual parcels located in the same region as the parcel having missing and/or incorrect information.

51. The method of

claim 50

wherein the region is selected from the group consisting of Census Geography, Block, Block group, borough, tract, traffic analysis zone, consolidated metropolitan statistical area, metropolitan statistical area, census metropolitan area, census agglomeration, statistical division, statistical subdivision and detailed statistical region.

62. A method of determining value trends of real estate, the method comprising the steps of:

determining the market-driven time adjustment by means of the method of

claim 51

for at least one real estate market area at a first time;

determining the market-driven time adjustment by means of the method of

claim 51

for the at least one real estate market area at least one time subsequent to the first time; and

comparing the market-driven time adjustments for the at least one real estate market area as a function of time.

63. The method of

claim 62

wherein the comparison is performed by mapping the market-driven time adjustments as a function of time.

52. A method for preparing a database of enhanced records for individual parcels of real estate, wherein the parcels are not owner-occupied residential real estate, the method comprising the steps:

A. identifying the individual parcels by the corresponding geocoding references;

B. correlating the individual parcels to their respective Census Tracts and Block Groups by means of the geocoding reference;

C. obtaining records for the individual parcels;

D. checking the records for errors and/or missing information;

E. correcting the records by replacing missing or incorrect values with statistically estimated values for the geographic area in which the respective individual parcels are located;

F. adding additional attributes to the records to create an enriched record file;

G. modeling the enriched record file to develop derived attributes for the individual parcels; and

H. adding the derived attributes to the records of the respective individual parcels.

53. The method of

claim 52

wherein the individual parcels comprise substantially all of individual parcels of real estate in a territory.

54. The method of

claim 53

wherein the territory is a county or municipality.

55. The method of

claim 54

wherein the territory is expanded if the number of individual parcels is less than a preselected number.

58. A method of determining the market-driven time adjustment to apply to a sales price of a previous real estate transaction, wherein the parcels are not owner-occupied residential real estate, the method comprising the steps:

compiling the enriched database of

claim 52

; and

analyzing the database by means of statistical models to determine a market-driven time adjustment for use in adjusting sales prices of comparable transactions.

59. A method of determining spatial distribute of at least one attribute of real estate, wherein the parcels are not owner-occupied residential real estate, the method comprising the steps of:

compiling the enriched database of

claim 52

;

analyzing the database by statistical methods to determine average or medium value of the attribute within at least designated geographic area; and

reporting the average or median attribute value for all analyzed geographic areas.

60. The method of

claim 59

wherein the report is a spreadsheet or a map.

61. The method of

claim 59

wherein the attribute is selected from the group consisting of sale price, sale price per square foot, sales frequency and time adjustment.

56. A method of determining the estimated value of a subject parcel of real estate, wherein the parcels are not owner-occupied residential real estate, the method comprising the steps of:

A. providing a computer, wherein the computer is connected to at least one input device and at least one output device and is capable of accessing, reading and executing real estate valuation software;

B. inputing data comprising a unique location corresponding to the parcel into the computer;

C. executing the real estate valuation software program to obtain at least one result based on the input data, the result being in the form of an estimated value for the parcel; and

D. communicating the value of the parcel obtained in Step C by means of the output device, wherein the real estate valuation software comprises computer readable and executable instructions for performing at least the following functions;

(i) compiling a database of records of individual parcels comprising the subject parcel, wherein the records comprise attributes of the individual parcels;

(ii) assigning appropriate geocodes to the individual parcels;

(iii) correlating the subject parcel and the comparable properties to respective Census Tracts and Census Blocks by means of the respective geocodes;

(iv) modeling the database to determine market-driven attribute adjustment values;

(v) selecting the most similar comparable properties, wherein the comparable properties are individual parcels having attributes similar to the subject parcel; and

,

(vi) calculating an estimated value of the parcel on the basis of the selected comparable properties.

57. A real estate valuation apparatus comprising:

A. A computer operatively connected to at least one input device and at least one output device, and

B. at least one real estate valuation software program which executes at least the following functions;

(i) compiling a database of records of individual parcels of real estate comprising the subject parcel, wherein the records comprise attributes of the individual parcels and wherein the parcels are not owner-occupied residential real estate;

(ii) assigning appropriate geocodes to the individual parcels;

(iii) correlating the subject parcel and the comparable properties to respective Census Tracts and Census Blocks by means of the respective geocodes;

(iv) modeling the database to determine market-driven attribute adjustment values;

(v) selecting the most similar comparable properties, wherein the comparable properties are individual parcels having attributes similar to the subject parcel; and

,

(vi) calculating an estimated value of the parcel on the basis of the selected comparable properties.

wherein the computer has access to and can execute the software program.