CA2482331A1 - System and method of compiling real property information from a central database - Google Patents

System and method of compiling real property information from a central database Download PDF

Info

Publication number
CA2482331A1
CA2482331A1 CA002482331A CA2482331A CA2482331A1 CA 2482331 A1 CA2482331 A1 CA 2482331A1 CA 002482331 A CA002482331 A CA 002482331A CA 2482331 A CA2482331 A CA 2482331A CA 2482331 A1 CA2482331 A1 CA 2482331A1
Authority
CA
Canada
Prior art keywords
real
property
property information
properties
user
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CA002482331A
Other languages
French (fr)
Other versions
CA2482331C (en
Inventor
Manoj Modi
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
U Haul International Inc
Original Assignee
U Haul International Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by U Haul International Inc filed Critical U Haul International Inc
Publication of CA2482331A1 publication Critical patent/CA2482331A1/en
Application granted granted Critical
Publication of CA2482331C publication Critical patent/CA2482331C/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G06Q50/40
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/06Asset management; Financial planning or analysis
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/10Services
    • G06Q50/16Real estate
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/90Financial instruments for climate change mitigation, e.g. environmental taxes, subsidies or financing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99941Database schema or data structure
    • Y10S707/99944Object-oriented database structure
    • Y10S707/99945Object-oriented database structure processing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99941Database schema or data structure
    • Y10S707/99948Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

The present invention provides a method of compiling real property information from a central database, comprising: providing a computer system for executing a website, the computer system being configured to retrieve data from the central database via a computer network;
storing real property information from a portfolio of real properties on the central database, the real property information being organized into a plurality of information categories; determining a valuation of each of the real properties; providing a set of real properties as collateral in a loan package, such that a fair market valuation of the set of real properties is at least equal to a value of the loan package in the event of a foreclosure and default sale; and providing access to the real property information related to the set of real properties to a lender through the website.

Description

Modi 111855.00004 System and Method of Compiling Real Property Information From a Central Database Cross Reference to Related Patent Applications) [0001] The present patent application is related to copending U.S. Patent Application , Attorney Docket No. 111855.00005, entitled ~~System and Method of Managing Real Property Through a Central Database", and filed concurrently herewith by Manoj Modi.
Field of the Invention [0002] The present invention relates in general to property management and, more particularly, to system and method of COmp111ng real property information from a central database.
Background of the Invention [0003] Many companies and individuals own or control vast amounts of property and other real holdings. Real property holdings can include commercial buildings, office space, manufacturing facilities, repair garages, warehouses, stores, and undeveloped land. The real property holdings also include related infrastructures such as electric service, communication networks, plumbing, heating, ventilation and air conditioning (HVAC) units, cabinets, counters, shelving, flooring, rack space, cranes, lifts, mechanical devices, machinery, office equipment, decor, and other fixtures which are not readily moveable and constitute an integral part of the property.
[0004] A self-serve moving and storage company is one example of an entity that may own significant holdings in Modi 211855.00004 real property. As a necessary part of its normal operation, the self-serve moving and storage company has a variety of real assets such as retail stores to rent trucks and trailers, repair facilities to perform maintenance, office space to manage the company, rental units for storage of customer belongings, and manufacturing and retrofit facilities to build and make improvements to equipment. The real property owned by the self-serve moving and storage company generally includes the building, land, and related infrastructures as described above.
[0005] Ideally, the real property and related infrastructures should be identified, tracked, maintained, and properly managed for the benefit of the company and to meet requirements imposed by local, state, and federal laws, including tax, environment, and zoning requirements.
Unfortunately, for many companies holding large property portfolios, the reality is that 'the detailed property information has problems in terms of accuracy, completeness, timeliness, and consistency. The detailed property information is often found in a variety of locations and known to or tracked by many different people, often in a disjoint manner with little or no communication between resources. The property information may exist only with the local store or property manager. If the local manager should leave the company, retire, or be re-assigned to a new location, a significant amount of useful information is lost. There is no correlation, common knowledge, shared communication, or centralized management of the detailed and dynamically changing property information.
[0006] A regional or national property manager probably knows the location and general attributes, e.g. address,, square footage, and principal usage, of each property under his or her control and responsibility. However, it is ._ . . ",~"," w .. _ .....:.x,er..r N.,_...« . w,ar.~.HU...,. _ ., . "n.
."..,. >,..._.~...~.,."~.,...,..__ Modi 111855.00004 unlikely that the local manager in city A has any knowledge that a property in city B has for example a leaky roof, and likewise the local manager of the property in city B does not know or probably even care that the property in city A
needs a new air conditioner. The regional or national property manager may only find out about these specific problems and needs when each is brought to his or her attention in the form of purchase order or authorization.
request for repairs. When the repairs are complete and the immediate need has passed, the information as to what happened, when, why, who, and where is often discarded or filed away in some isolated and forgotten box or file cabinet. Any future value in each specific property management dato point is lost with the lack of any central record keeping procedure and the next crisis of the moment or other pressures of the business. The lack of complete, accurate, real-time information is a significant problem for most if dot all property managers.
[0007] In the prior art, efforts have been made to organize information related to real properties. Property management information is generally kept by many different people and different departments, each having their own interests and needs. The maintenance department may keep maintenance records; the purchasing department keeps purchasing records; the finance department keeps financial records; the legal department keeps legal records; and so on. Multiple sets of lists, files, records, receipts, permits, appraisals, advisories, and reports may exist for example on computer-based spreadsheets, each within the cognizant department, but often with overlapping and sometimes conflicting information between groups. Most departments have little knowledge of or concern for what other departments keep track of and how such information is used.

Modi 111855.00004 [0008] Aside from the physical repair and maintenance of real property holdings, an overall property management program may also involve managing the real property portfolio as a financial asset of the company. Each 5 property within a company's portfolio has a fair market value as determined by its location, land, square footage, useful features, convenient ingress and egress, curb appeal, condition of the structure and fixtures, past revenue generating performance and future potential, and the state of the local economy.. The value of each property and the company's percent equity in the property will hopefully increase, but possibly decrease, over time with nature of the business, success of the marketing strategy, maturing of the customer base and sales growth, occupancy 15 rate, and general direction of property values in the area.
[0009] When acquiring a new property, a common approach may involve a cash or cash-equivalent down-payment and a loan for the balance secured by the property being purchased. The downside of this approach is the need to 20 invest hard cash in the new property. Depending on the business plan of the company and philosophy of the management team, another approach is to leverage the equity in existing properties as the basis to secure 100a financing, or minimal cash investment, to purchase new 25 properties or otherwise borrow capital for the benefit of the company and its shareholders. Such a strategy allows a company to borrow without committing a significant amount of cash. The loan can be used to acquire new real properties, improve existing real property assets, upgrade 30 equipment, invest in research and development, improve customer service, and acquire new businesses.
[00010] Most if not all lenders want to know considerable information about real properties being offered as collateral for Loans to purchase other company assets and Modi 111855.00004 make capital improvements. Some lenders consider the use of existing real property as collateral to secure other real property to have same risk associated with the transaction. The lender must be protected in terms of fair 5 market value of the leveraged property in the event of a foreclosure and default sale.
[00011] When the company owns a large number of properties, such information is often difficult to come by or compile in short order because of inadequate record 10 keeping and constantly changing circumstances. The lender may have to send one or more teams to the borrower's place of business to conduct due diligence. If the borrower ~_s offering multiple properties as packaged collateral, the lender may have to travel to several locations. The 15 lender's due diligence and the borrower's compliance to the lender's demands becomes a laborious, time consuming, expensive, and error-prone process for both parties, especially when the relevant property information is scattered, dated, incomplete, lost, or otherwise hard to 20 come by.
[00012] Moreover, the company may not even know all the valuable and attractive gems in their property portfolio which could be leveraged to help finance and grow the company. Again, the de-centralization of record keeping 25 and many silos of information lead tc missed opportunities and less than optimal processes and results for lenders and borrowers alike.
Summary of the Invention [00013] In one embodiment, the present invention is a method of displaying real property information comprising the steps of storing real property information from a portfolio of real properties on a central database, Modi 111855.00004 providing a website, organizing the real property information from the central database as a plurality of categories, providing selections for each of the plurality of categories on the website, selecting a category of real property information, retrieving the category of real property information from the central database, and displaying the category of real property information on the website.
[00014] In another embodiment, the present invention is a method of using a central database to manage real property comprising the steps of retrieving real property information from the central database, displaying the real property information on a website for a first user. The first user edits the real property information. The edited real property information is saved back in the central database.
[00015] In yet another embodiment, the present invention is a method of managing real property comprising the steps of storing real property infE~rmation from a portfolio o:E
20 real properties on a central database, providing a website, retrieving the real property information from the central database, and displaying the real property information from the central database on the website.
Brief Description of the Drawings [00016] FIG. 1 is a block diagram of a computer network system used to host and access an Internet-based website;
FIG. 2 illustrates several real property assets of a truck rental company;
FIG. 3 illustrates a central database for storing property related information;
FIG..4 illustrates related records in the central database;

i Modi 111855.00004 FIG. 5 illustrates a home webpage of the property management website;
FIG. 6 illustrates a design webpage in the property management website;
FIG. 7 illustrates a construction webpage in the property management website;
FIG. 8 illustrates a maintenance webpage in the property management website;
FIG. 9 illustrates a property records webpage in the property management website;
FIG. 10 illustrates the general purpose record from the central database;
FIG. 1i illustrates the infrastructure record from the central database;
FIG. 12 illustrates the steps of managing rea:1 property assets through a central database;
FIG. 13 illustrates creation of loan request packages for lenders;
FIG. 14 illustrates a home webpage of an institutional lender website;
FIG. 15 illustrates a search summary webpage of the institutional lender website;
FIG. 16 illustrates a detailed property related information webpage of the institutional lender website;
and FIG. 17 illustrates the steps of compiling real property information for institutional lenders from a central database.
Detailed Description of the Drawings [00017] A computer system and network 10 is shown in FIG.
1 used to host and access an Internet-based website.
Computer system 12 is a general purpose computer including Modi 111855.00004 a central processing unit or microprocessor 14, mass storage device or hard disk l6, electronic memory 18, and communication port 20. Communication port 20 may be a high speed Ethernet connection to communication network 22.
5 Communication network 22 is an open architecture system such as the world wide web, commonly known as the Internet.
Computer system 26 and computer system 28 are configured as shown for computer 12 and are also connected to communication network 22, which allows communication between computers 12, 26, and 28.
[00018] Computers 12, 26, and 28 can be physically located in any location with access to a modem or communicat10T1 link to network 22. For example, computer 12 can be a central server at a company°s home office.
15 Computers 25 and 28 can be located in any company office, retail space in any state, new construction site connected by cell phone, or a hotel room, just to name a few.
[00019] Computer 12 runs application software which can be used to host one or more websites. Each website 20 includes one or more webpages for viewing information and for receiving information from the user. The information displayed on each website is generally stored on hard disk 16, or other mass storage device accessible to computer 12.
Users operating from computers 26 and 28 from any location 25 can, via communication network 22, log into the website hosted by computer 12 to view information and enter information via the website.
[00020] As will be described further, a database or flat file is provided on hard disk 16. The database contains 30 information related to real properties held by a company.
Users from computers 26 and 28 can open the property management website on computer 12 and make requests to see the property related information. Computer 12 retrieves the property information from the database and displays the _g_ Modi 111855.00004 information on the webpages for the remote users. The users can gain understanding and make decisions about repairs, maintenance, and management of the property in question. With proper authorization, the users can add, 5 delete, and update the information displayed on the webpages. The new and updated information is saved back to the database for future reference by the same user or other users.
[00021] Turning to FIG. 2, an individual, Company, or 10 other property holder owns, operates, and manages a large number of real property holdings in its portfolio. As an example, the property holder may be self-serve moving and storage company (truck rental company) 30 with significant property and other real holdings such as commercial 15 buildings, office space, manufacturing facilities, repair garages, warehouses, .stores, and undeveloped land. Truck rental company 30 owns and operates retail store 32 to rent trucks and trailers, repair facility 34 to perform maintenance, office space 36 to manage its operations, 20 rental units 38 for storage of customer belongings, and manufacturing and retrofit facility 40 to build and makE:
improvements to equipment. The real property holdings also include related infrastructures such as electric service, communication networks, plumbing,. HVAC units, cabinets, 25 counters, shelving, flooring, rack space, cranes, lifts, mechanical devices, machinery, office equipment, decor, and other fixtures which are not readily moveable and constitute an integral part of the property.
[00022] The real property and related infrastructures 30 owned and operated by truck rental company 30 must be identified, tracked, maintained, and properly managed for the benefit of the company and to meet requirements imposed by local, state, and federal laws, including tax, environment, and zoning requirements. Each property may Modi 111855,00004 have a local manager and employees tasked to run the day-to-day business operations associated with the property. A
regional or national property manager is responsible foz-overseeing multiple properties.
[00023] To aid its employees, managers, contractors, and vendors, truck rental company 30 maintains a central database 48 on computer 12, as shown in FIG. 3, to store and organize information related to its real property holdings. For each principal property, truck rental company 30 identifies and records relevant information associated with that property. Database 48 is accessed and controlled with application software or computer programs) running on computer 12 with the associated microprocessor, memory, hard disk storage, and communication links such as shown in FIG. 1. Database 48 physically resides on hard disk 16. Database 48 may be organized as a relational database, flat file, or other organized structure of related records.
[00024 A property is considered the land, building(s), and fixtures found at one specific physical address. For example, retail store 32 located at a first physical address is a first property and constitutes one or more related property records in database 48. Repair facility 34 located at a second address is a second property and constitutes another set of related property records in database 48. Office space 36 located at a third address is a third property and constitutes another set of related property records in database 48~ Rental units 38 located at a fourth address is a fourth property and constitutes another set of related property records in database 48.
Manufacturing and retrofit facility 40 located at a fifth address is a fifth property and constitutes yet another set of related property records in database 48. The real property holdings are often located nationwide, in I.~IOdl 111855.00004 different cities and states, and may be in foreign countries.
[00025] Each property is assigned a unique property identification number and will have at least one record, and possibly a set of related records, depending on the organization of database 48. Retail store 32 is assigned property identification number 1; repair facility 34 is assigned property identification number 2; office space 36 is assigned property identification number 3; rental units 38 is assigned property identification number 4; and manufacturing and retrofit facility 40 is assigned property identification number 5. Assume database 48 stores information related to n number of individual real properties. In FIG. 3, property information related to retail store 32 is logically stored in database 48 under "record(s) for property identification number 1." Property information related to repair facility 34 is logically stored in database 48 under "record(s) for property identification number 2." Property information related to office space 36 is logically stored in database 48 under_ "record(s) for property identification number 3.°' Property information related to rental units 38 is logically stored in database 48 under "record(s) for property identification number 4." Property information related to manufacturing and retrofit facility 40 is logically stored in database 48 under "record(s) for property identification number 5."
[00026] In one embodiment, database 48 is organized into a plurality of categories of property related information by functional attributes of the property. Each property has a set of related records which deal with specific attributes associated with the property under a given category of information. The per property record format of property identification number m, where m is any assigned identification number, is shown in FIG. 4. There is one ' Modi 111855.00004 general purpose record 50 which contains fixed or relatively constant information about a particular property such as company assigned property identification number, address, phone number(s), fax number, email address;
emergency and safety numbers, local manager, principal business purpose, tax identification number, certificate of occupancy, permits, area demographics, general photographs, maps, executive summary, etc. Infrastructure record 52,, or group of records, is another category of information associated with the same property identification number m and provides specific infrastructure information related to square footage, acreage, detailed photographs of the property, rooms, layout, type of roof, electric service,, communication networks, plumbing, HVAC units, cabinets, counters, shelving, flooring, rack space, cranes, lifts, storage units, bays in garage, mechanical devices, machinery, office equipment, decor, and other fixtures which are not readily moveable and constitute an integral part of the property. Business record 54, or group of records, is another category of information associated with the same property identification number m and provides business information such as services and products offered, prices, costs, sales history, percent. occupancy, vendor lists, supplier lists, customer lists, inventory, number and specialties of local employees, and competitor information. Accounting record 56, or group of records, is another category of information associated with the same property identification number m and provides accounting information such as appraisals, book values, profit and loss statements, property tax records, depreciation schedules, liens, environment statement, title report, surveys, legal descriptions, title insurance, property insurance, certificate of occupancy, zoning compliance, site plans, and geo-technical analysis. Maintenance record Modi 111855.00004 58, or group of records, is another category of information associated with the same property identification number m and provides maintenance information and related photographs such as present state of property, repair 5 history, known repair action items, scheduled maintenance, service advisories, preventative maintenance schedules, records for underground storage tanks, environmental reports, contact information for local repair service, and needed or planned improvements.
10 [00027] Database 48 has the ability to attach documents to records. The documents may be provided in industry standard applications and formats. The photographs may be stored as joint photographic group (jpg) or tag image file (tif), the maintenance records stored as portable document 15 files (pdf), executive summary as a word processing document, and financial statements as spreadsheets.
Database 48 becomes a digital library of all documents associated and needed to support the real property holdings of truck rental company 30.
20 [00028] The above list is merely exemplary of the categories and organization of property related information that can be stored in database 48. Depending on the nature of the business, additional (or less) property related information can be organized and stored in database 48.
25 For example, in a highly competitive market, there may be a separate record or group of records for competitive intelligence of property holdings by competitors. In an environmentally sensitive business, there may be a separate record or group of records for environmental impact data.
30 In a heavily regulated market, there may be a separate record or group of records for government compliance with property holdings. Moreover, there may be a separate record or group of records for legal matters and litigation associated with the property holdings. In general, o CA 02482331 2004-09-24 Modi 111855.00004 whatever property related information is important and useful to the company can be organized in database 48 for easy access and review. .
[00029] To provide a useful property management tool, the property related information in centralized database 48 should be complete, accurate, and real-time. The property related information for each real property holding in the company portfolio must be entered into database 48. This step can occur when setting up the system or when acquiring a new property. The property related information typically exists on one or more documents which are analyzed, formatted, and entered into database 48. The conversion between the prior paper-based documentation and the computer-based organization of the records, files, and fields in database 48, as discussed above, is the first step in realizing a useful property management tool. The dynamics of real property management require continuous, real-time updates to the property related information records in database 48. Local managers change, improvements and repairs are made to the property, new photographs.are taken of the property, customer lists grow, occupancy rates increase, more beneficial appraisals are done, updated property tax statements are received, up-to-date competitor information is acquired, and new litigation is initiated.
(00030] In a large company with a significant real property portfolio, no single person is cognizant or knowledgeable about all property related information and changes thereto. Each person or department has its expertise and area of interest. The property management tool provides for easy, convenient, and real-time access and updates to database 48 by those with the relevant knowledge. Each cognizant person or department enters and maintains their relevant category of property related Modi 111855.00004 information. With a central database 48, the property related information is maintained in a central location. or from a distributed system operating as a single source.
Those persons with the most knowledge about a particular piece of information are assigned the responsibility of maintaining that information. Yet, the same centralized information is accessible to all authorized users.
Moreover, any change to the property related information made by one user becomes available to all authorized users.
[00031] The application software running on computer 12 and controlling database 48 provides an Internet-based property management website portal 60 as shown in FIG. 5, which is accessible to authorized personnel to access, review, enter, and update property related information in database 48. The property management website portal 60 is implemented on computer 12 with access to database 48.
Company employees, managers, contractors, vendors, and third parties with proper authorization can access property management website 60 from computers 26 and 28. Computers 26 and 28 can be located anywhere with a modem connection or other access to communication network 22. To access property management website 60, the company employee, manager, contractor, vendor, or other authorized user enters the uniform resource locator (URL) address for the website into the URL address line of his or her Internet browser application. The user is launched to property management website 60 on computer 12.
[00032] A log-in box or log-in webpage appears for the user to enter his or her user name and password. The password provides a level of security and protection from unauthorized access. The log-in identifies the person and establishes the user's rights and privileges while browsing property management website 60 and the ability to enter new data, delete data, and change existing property related Modi 111855.00004 information in database 48. A general property manager or website administrator can be set up to view any property related information and make any desired changes at any time. Other managers may have defined records for viewing and limited authority to change information. Each users access is set by the system administrator and established by their log-in code. For example, the maintenance manager can be given access to view general purpose record 50,.
infrastructure record 52, and maintenance record 58, but may be blocked from viewing business record 54 and accounting record 56. The maintenance manager is limited to changing only maintenance record 58. ~Che finance manager can be given access to view all records, but is limited to changing only accounting record 56. The log-in procedure can also be used to track user time and webpage access.
[00033] The first webpage of property management website 60, labeled as the Home Page, identifies truck rental company 30 and provides principal hyperlinks to other webpages and basic user information. Design 62 is a hyperlink to the design webpage. Construction 64 is a hyperlink to the construction webpage. Maintenance 66 is a hyperlink to the maintenance webpage. Real estate information 68 is a hyperlink to the real estate information webpage. Property records 70 is a hyperlink to the property records webpage. The basic user information includes topics such as commonly used hyperlinks, special interests, website notices, instructions, user surveys, special promotions, website contact information, help, legal notices, and banner ads.
[00034] Selecting design 62 launches the user to design webpage 76 which is shown in FIG. 6. Design webpage 76 includes several featured properties. Featured property 78 is a picture, descriptive text, and hyperlink to a first Modi 111855.00004 featured prcperty. Featured property 80 is a picture, descriptive text, and hyperlink to a second featured property. Featured property 82 is a picture, descriptive text, and hyperlink to a third featured property. Featured 5 property 84 is a picture, descriptive text, and hyperlink to a fourth featured property. Any one of the properties in truck rental company 30 portfolio ma y be selected as a featured property on website 60 for a number of reasons. A
property may be featured because it is newly acquired, newly renovated, achieved some level of success or notoriety, or simply randomly selected. The hyperlink for the selected featured property launches the user to another webpage which displays several pictures of the selected featured property and interesting and useful property 15 related information concerning the selected featured property as retrieved from database 48.
[00035] The property related information retrieved from database 48 for display on design webpage 76 and other linked webpages crosses information category boundaries.
20 That is, some information may come from general purpose record 50 and some information may come from infrastructure record 52 to display the relevant information on design webpage 76. Likewise some information may come from business record 54, accounting record 56, and maintenance 25 record 58 for display on design webpage 76. A feature of property management website 60 is that the property related information is retrieved from a central source, possibly from multiple categories, and integrated to provide a comprehensive presentation of the information for the user.
30 Database 48 as the central source of information eliminates the overlapping, duplicative, and conflicting property information found in prior art systems. The property related information is accurate because each piece of information within an information category is kept in one Modi 111855.00004 place and maintained by persons) cognizant of the information. There is little or no overlap between information categories, e.g. accounting record 56 does not contain maintenance information and maintenance record 58 does not contain accounting information. The integration of information from multiple categories to provide a comprehensive composite of the desired property related information is a useful property management tool.
[00036] If the user has sufficient rights and privileges, he or she can add, delete, and edit the property related information displayed on design webpage 76. The next user accessing the same property related information concerning.
the selected featured property will see the edits made by the first user.
[00037] In FIG. 5, selecting construction 64 launches the user to construction webpage 88. Construction webpage 88, as shown in FIG. 7, includes a mission or purpose statement and general information related to construction projects planned, scheduled, or underway by truck rental company 30.
A list of contacts for construction related matters, with hyperlinks to email addresses or contact information, is also provided on webpage 88: A list of contacts may includes construction managers, foremen, supervisors, specialists, consultants, builders, tradesman, craftsman, suppliers, inspectors, and government agencies.
Construction project 90 is a picture, descriptive text, and hyperlink to a first construction project. Construction project 92 is a picture, descriptive text, and hyperlink to a second construction project. The hyperlink for the selected construction property launches the user to another webpage which displays several pictures of the selected construction project and interesting and useful property related information concerning the selected construction project as retrieved from database 48.

' Modi 111855.00004 [00038] Similar to design webpage 76, the property related information retrieved from database 48 for display on construction webpage 88 crosses information category boundaries. Some information may come from general purpose record 50 and some information may come from infrastructure record 52, business record 54, accounting record 56, and maintenance record 58 for display on construction webpage 88. The integration of information from multiple categories provides a comprehensive composite of the desired property related information.
[00039] If the user has sufficient rights and privileges, he or she can add, delete, and edit the property related information concerning the selected construction project in database 48. The next user accessing the same property related information concerning the selected construction project will see the edits made by the first user.
[00040] In FIG. 5, selecting maintenance 66 launches the user to maintenance webpage 98. Maintenance webpage 98, as shown in FIG. 8, includes a mission or purpose statement and general information related to repair, facilities, and maintenance projects planned, scheduled, or underway by truck rental company 30. A list of contacts for maintenance related matters, with hyperlinks to email addresses or contact information, is also provided on webpage 98. District splits allows truck rental company 30 to divide its territory, regionally or nationwide, into districts and assign individuals responsibility for one or more districts. The district splits identifies the districts and provides contact information for the responsible people.
[00041] Program objectives is a major grouping of property related information within the maintenanc a function available on webpage 98. The program objectives are displayed as a list of hyperlinks to the area of ' Modi 111855.00004 interest. The news and calendar hyperlink launches the user to a webpage which displays property related news and information in a calendar format. The property related news and information may include notices for special problems found, upcoming events, supplier issues, scheduled building maintenance, inspections, and cleaning tasks. The calendar can be presented on a monthly basis or day format within the month of interest.
[00042] The products and tips hyperlink launches the user to a webpage which displays property related information on such topics as new products, improvements, new tools, maintenance tips, pests, equipment tune-ups, energy savings, and solutions to common problems.
[00043] The education hyperlink launches the user to a webpage which provides property related information on such topics as vocabulary of terms, frequency asked questions (FAQs), early warning signs of pending problems, minimizing liability, what to do in the case of criminal mischief, and emergency plans, e.g, what to do if waterline bursts, loss of power, and adverse weather.
[00044] The project maintenance hyperlink launches the user to a webpage which displays property related information and helpful suggestions on such topics as roof and elevator maintenance, proactive and reactive maintenance, types of service contracts, certified specialists, maintenance schedule, seasonal inspections, preventative programs, and city codes.
[00045] The vendor and bids hyperlink launches the user to a webpage which displays property related information regarding qualified and approved vendors and suppliers which can provide repairs and service. The bidding information gives vendors and suppliers information on categories of bids accepted and how to submit bids to become an approved service provider.

Modi 111855.00004 [00046] The message board hyperlink launches the user to a webpage which provides a forum for users to post messages to the website generally. The users have an opportunity to share experiences and communicate with one another.
[00047] The digital library hyperlink launches the user to a webpage which provides access to files and documents related to the real property portfolio. The files and documents are stored on hard disk 16 and linked to database 48. The files and documents can be downloaded for display on website 60. The documents may include reports, appraisals, news bulletins, maps, certificates, manuals, warranties, assessments, leases, audits, maintenance records, inspections, invoices, legal documents, tax records, title reports, insurance, engineering reports, liens, easements, zoning information, compliances, security systems, computer aided design (CAD) files, drawings, budgets, bids, authorized vendors, contacts, forms, checklists, and any other written information related to the real property. The digital library webpage includes rules on document type, format, and submission, and instructions on how to upload and download documents.
[00048] The photo album hyperlink launches the user to a webpage which provides a forum for users to post photographs and related text on the website. The photographs include aerial shots, maps, site plans, drive-by views, exterior views, bays, lifts, hoists, elevators, offices, showrooms, retail space, parking lots, signage, storage units, roofs, building features, competitor images, and any other photograph related to or of interest for a particular property. The photo album webpage includes rules on file type, format, and submission, and instructions on how to upload and download pictures and text.
[00049] The digital notebook hyperlink launches the user Modi 111855.00004 to a webpage which displays property related information concerning maintenance actions taken and products installed at any property held by truck rental company 30. In practice, manager, employees, contractors, suppliers, and vendors acting on behalf of truck rental company 30 have the ability to access and add to the digital notebook. The digital notebook includes entries such as major expenditures, action logs, products installed, services performed, general comments, facility maintenance technician (FMT) entries, and any other notes and comments related to the real property portfolio. The ability to, change the contents of the digital notebook may be reserved for certain authorized users. The digital notebook webpage includes rules on use of the digital notebook and instructions on how to enter and save information.
[00050] All the above described information displayed on maintenance webpage 98 comes from multiple categories of property related information. Again, some information may come from general purpose record 50 and some information may come from infrastructure record 52, business record 54, accounting record 56, and maintenance record 58 for display on maintenance webpage 98. For example, the scheduled building maintenance under the news and calendar hyperlink comes from maintenance record 58, the photographs exterior views and offices under the photo album hyperlink come from the infrastructure record 52, the bidding process under the vendor and bids hyperlink comes from the business record 54, and the appraisals and tax records under the digital library hyperlink comes from accounting record 56. The property management tool integrates information from multiple categories to provides a comprehensive composite of the desired property related information. The property related information is efficiently and accurately maintained because each piece of information is kept in one Modi 111855.00004 location, with little or no overlap between categories of information.
[00051] If the user has sufficient rights and privileges, he or she can add, delete, and edit maintenance webpage 98, and the hyperlinked program objectives, and then save the edited property related information back in database 48.
The next user accessing the same property related information concerning maintenance webpage 98 or the hyperlinked program objectives will see the edits made by the first user.
[00052] In FIG. S, selecting real estate information 68 launches the user to a real estate information webpage.
The real estate webpage displays text related to legal property descriptions, title reports, title insurance, surveys, appraisals, insurance, certificate of occupancy, zoning compliance, contacts, environmental reports, underground storage tanks, and engineering reports. The presentation of information on the real estate information webpage comes from multiple categories of property related information. If the user has sufficient rights and privileges, he or she can add, delete, and edit the real estate information and then save the edited property related information back in database 48. The next user accessing the same real estate information will see the edits made by the first user.
[00053] In FIG. 5, selecting property records 70 launches the user to property record webpage 100. Property record webpage 100, as shown in FIG. 9, displays a search screen for finding specific properties or groups of properties.
The user can access a particular property by entering the property identification number in box 102 and clicking selection button 104. If the user is interested in retail store 32 located at the first address, then user simply enters property identification number 1 in box 102 and Modi 111855.00004 clicks selection button 104 and general purpose record 50 for retail store 32 is displayed on the screen.
[00054] If the property identification number is unknown or unavailable, then the user can enter the address or 5 other known fields. The user can enter marketing company office (MCO) number in box 106 and click selection button 108. MCO is a regional office number. The user can enter the district identifier in box 110 and click selection button 112. The user can enter state or providence in box 20 1I4 and click selection button 116. The user can enter the property street location in box 118 and click selection button 120. The user can enter the city in box 122 and click selection button 124. One or more of the boxes, e.g.
boxes 110, 114, 118, and 122, can be direct data entry and 15 pull-down screens of known values.
[00055] Property record webpage 100 searches database 48 to find, retrieve, and present general purpose record 50, including text and photographs, as well as other property records if needed, for the property that matches the search 20 criteria. FIG. 10 illustrates a property record webpage 130 displaying the general purpose record 50 for the selected property, including the company assigned property identification number, address, phone number(s), fax number, email address, local manager, area demographics, 25 principal business purpose, and executive summary. FIG. 10 may also illustrate some information from infrastructure record 52. The property record webpage 130 shows one or more general photographs 132 and maps 134.
[00056] If more than one property matches the search 30 terms, then a summary of matching properties is provided.
The summary of matching properties shows a portion of general purpose record 50 for each property to help the user select the desired property. The user can scroll down the list of matching properties and select the property of Modi 111855:00004 interest. The general purpose record 50 for the selected property is then displayed as described above.
[00057] In addition to displaying the contents of general purpose record 50 for the selected property, property record webpage 100 also shows other the areas or categories of property related information. Property record webpage 100 displays,- and links to other webpages that display, infrastructure record 52, business record 54, accounting record 56, and maintenance record 58. If authorized, the user can gather data from multiple records in database 48 for a complete, accurate, and real-time view of all available property related information.
(00058] From property record webpage 100, or from any property related information webpage, the user can launch to infrastructure record 52 and display the complete infrastructure: information for the selected property stored in database 48 as discussed above. FIG. 11 illustrates a property infrastructure webpage 138 displaying the infrastructure information for the selected property, including square footage, acreage, rooms, layout, roof, electric service, communications, plumbing, HVAC-units, cabinets, counters, shelving, flooring, rack space, cranes, lifts, storage units, bays, machinery, office equipment, and fixtures. In addition, the property record webpage 138 shows photographs 140 and 142 for the selected property.
[00059] Consider a situation where the property manager is evaluating some new equipment to a particular property and wants to know the electrical and plumping capacity and configuration to determine the extent of the utility re-work that will be needed. The new equipment may use a 220 volt, 3-phase motor. Knowing the existing electrical configuration of the installation site would be useful in planning the deployment of the new equipment. The property manager logs into property management website 60, selects Modi 111855.00004 the desired property on,property record webpage 100, and goes to the infrastructure information webpage 138. The property manager notes that the property has a 110 volt, single phase electrical wiring configuration, which is incompatible with the electrical wiring requirements of the new equipment. The property manager has displayed and accessed information from maintenance record 58 and infrastructure record 52. with the composite property information from database 48, the property manager can plan accordingly or reconsider the installation altogether.
(00060] From property record webpage 100, or from any property related information webpage, the user can display business record 54 far the selected property as stored in database 48. The business informaticn from business record 54 can be useful in a situation where the business manager wants to know which properties are under-performing in terms of revenue generation and which properties are exceeding projections for an upcoming meeting with the management team. The report may include financial information from accounting record 56. The business manager logs into property management website 60, selects the desired property on property record webpage 100, goes to the business information webpage, and collects the data from multiple information categories needed for the meeting.
(00061] From property record webpage 100, or from any property related information webpage, the user can display accounting record 56 for the selected property as stored in database 48. The accounting information from accounting record 56 can be useful for the accounting department or business manager.
[00062] From property record webpage 100, or from any property related information webpage, the user can display maintenance record 58 for the selected property as stored Modi 111855.00004 in database 48. Consider a situation where the local manager of retail store 30 calls the maintenance department for truck rental company 30 to report a non-functional air conditioner. The maintenance technician logs-in into property management website 60 and views the make, model, installation date, and service history of the air conditioner for retail store 30. Such information would have been stored in central database 48 when the property was acquired or when new equipment was installed and is now available for review by other users. The technician may learn that the air conditioner is under warranty or will find the local manufacturer-authorized air conditioner repair service. The technician is able to make such a quick and accurate determination because central database 25 48 contains all installation and service records for each piece of equipment installed at each property held by truck rental company 30. Database 48 includes documents attached to the maintenance records with warranty cards, receipts of prior work, and previous service reports made by other technicians. The technician may review service reports for similar air conditioners installed at other locations, or the technician may learn from prior service reports that the air conditioner is simply temperamental and needs to have the circuit breaker reset. Resetting the circuit breaker may not provide the optimal fix if the air conditioner unit goes down frequently, but at least the unit can be made operational for now and truck rental company 30 can plan and budget a permanent solution for a future date. The technician enters the disposition of the present service repair report into database 48 using property management website 60 and may notice an action item for replacement or overhaul of the air conditioner at some future date. The process of the technician entering the present service disposition into database 48 provides Modi 111855.00004 useful information for the next service request for the same or similar equipment. The lessons learned in the present job will not be lost but rather will be saved for the next job.
[00063] In another scenario, the maintenance technician may inspect a roof on office space 36 and determine that repairs will be needed within the next several months. The technician's report is entered into database 48 and lists the roof repair as a maintenance action item. The maintenance manager can then access property management website 60 and get a report of maintenance action items that need to be done and schedule the work accordingly.
Moreover, come budget submission time, the maintenance manager can run a report of upcoming maintenance action.
items, e.g. air conditioner overhaul for retail store 32 and the roof repairs for office space 36, and submit an accurate and justified budget with minimal speculative line items.
[00064] In all of the above scenarios, if the user has sufficient rights and privileges, he or she can add, delete, and edit the property record information and then save the edited property record information back in database 48. The next user accessing the same property record information will see the edits made by the first user.
[00065] The user's log-in account establishes access to the other records of property related information. Each record in database 48, and possibly each field within each record, has an associated authorization code. The code identifies the level of access needed to view the contents and the level of access needed to change the contents.
Each user can be assigned the appropriate level of authorization in order to perform his or her job function without creating unnecessary data security risks or Modi 111855.00004 otherwise compromising the integrity of database 48. If the user has sufficient rights and privileges, he or she can add, delete, and edit the property related information in database 48. The next user accessing the same property related information will see the edits made by the first user. Whether the user can view some or alI of the records in database 48 is determined by the administrator. Read access to the most if not all records is limited to a need to know basis. Update authority is limited to a need to change basis. If the user is authorized to make edits to maintenance records only, then update access to infrastructure record 52, business record 54, and accounting record 56, and maintenance record 58 is blocked, or the user will need to get override authorization from the person or department cognizant and responsible for the desired property related informatior_.
(00066] For each property related information webpage, the property related information associated with that webpage is retrieved from database 48. As discussed above, the property related information is initially entered into database 48. The task of maintaining and updating the records in database with the most recent, accurate, and complete information rests with those in the company that have the most knowledge and access to the information.
Each record or field within database 48 is assigned a responsible party to maintain the information. For example, the business managers will keep up business records 54 because it is their responsibility and further because it is in their interest to do so. The accounting department will keep up accounting records 56 because it is their responsibility and it is in their interest to do so.
The maintenance department will keep up the maintenance records 58 because it is in their responsibility and interest to do so. With each department or individual Modi 111855.00004 maintaining the property related information for which they are knowledgeable and cognizant, then as a whole, the property related information in central database 48 will contain and represent the most up-to-date information available about the real property holdings of truck rental company 30. The property related information for the real property holdings of truck rental company 30 is available to all authorized users through property management website 60 and centralized database 48.
IO [00067] Once people begin to rely on a centralized database 48, the desire to maintain it directly follows and becomes automatic. The synergy develops from contributions of property related information to a central resource, i.e.
database 48. One set of information exists for all to use.
Critical information moves across departmental boundaries.
Each user will be able to access any and all property related information authorized for their log-in account.
Database 48 is a real-time reflection of the dynamically changing state of affairs for the company's property portfolio.
[00068] In addition to reviewing specific properties, the user can run general reports across many properties with broad search terms. For example, the property manager may want to know all property in a given geographical region, or the business analyst may want to know which properties are profitable in the last quarter, or the maintenance manager may want to know which properties are known to need or likely to need repair in the next fiscal year.
[00069] The steps of managing real property through a central database is described in FIG. 12. In step 144, real property information from a portfolio of real properties is stored on a central database organized under a plurality of information categories. In step 146, the real property information from the central database is Modi 111855_00004 selected for display. In step 148, the selected real property information is retrieved from multiple information categories on central database and displayed an website.
In step 150, the selected real property information is accessed from the central database through a communication network. In step 152, the selected real property information is displayed for a first user operating a first computer system remote from the central database. In step 154, the first user edits the selected real property information from the first computer system and saves edited real property information to the central database. In step 156, the edited real property information is accessed from the central database through the communication network. In step 158, the edited real property information is displayed for a second user operating a second computer system remote from the central database.
[00070] As discussed above, an overall property management program may also involve managing the real property portfolio as a financial asset of the company.
Each property within a company's portfolio has a fair market value as determined by its location, land, square footage, useful features, convenient ingress and egress, curb appeal, condition of the structure and fixtures, past revenue generating performance and future potential, and the state of the local economy. The value of each property and the company's percent equity in the property hopefully increases, but possibly decreases, over time with nature of the business, success of the marketing strategy, maturing of the customer base and sales growth, occupancy rate, and general direction of property values in the area.
[00071] When taking out a loan from a bank or other financial institution, the management team may elect to leverage the equity in existing properties as the basis to secure 1000 financing, or minimal cash investment. The ' Modi 111855.00004 S
approach of leveraging existing properties to purchase new properties or otherwise borrow capital for the benefit of the company has advantages over more conventional financing arrangements. Namely, using the equity in existing properties avoids the commitment of substantial quantities of hard cash for down-payments. The equity in existing properties arises from higher appraisal values which is related to the business success of the property. The loan can be used to acquire new real properties, improve existing real property assets, upgrade equipment, invest in research and development, improve customer service, and acquire new businesses.
(00072] To implement the strategy of leveraging equity in existing properties to finance new acquisitions, the company's management team must first organize their portfolio of properties and determine which property, or combination of properties, would be attractive to a lender in securing the desired financing. Based on prior experience of what has worked in the past, and from direct feedback from the lenders, truck rental company 30 selects one or more properties from its portfolio and forms a loan request package. The loan request package includes a loan application, proposed term of the loan, explanation of the purpose for the borrowed funds, and description of the collateral being offered. The loan request package is sent to one or more lenders.
[00073] Most if not all lenders want to know considerable information about real properties being offered as collateral for loans to purchase other company assets and make capital improvements. Some lenders consider the use of existing real property as collateral to secure other real property to have some risk associated with the transaction. The lender must be protected in terms of fair market value of the leveraged property in the event of a Modi 111855.00004 foreclosure and default sale.
[00074] Lenders, being in the business of loaning money, will consider the loan request package from truck rental company 30. The lender will naturally have many questions and requests for information, all part of the due diligence process, to confirm the value of the collateral and assess the risk associated with the transaction.
[00075] Consider a loan request package where truck rental company 30 wants to buy a. new property and further wants to leverage the equity it holds in existing property in financing the new property. Truck rental company 30 has a valuable tool in that the property related information for all of its real properties is maintained on central database 48. The management team begins by reviewing the financial records for its property portfolio, including the most recent appraisal(s), which are stored in business record 54 and/or accounting record 56. The review of the financial records provides a wealth of information and can help truck rental company 30 find some real gems, in terms of value as financing collateral, that it otherwise might not be aware. The management team decides that, based on independent appraisals and other fair market value factors, the equity in retail store 32 and repair facility 34 should be sufficient collateral to entice the lender to approve the loan for the new property. The loan request package is finalized with retail store 32 and repair facility 34 being offered as collateral. In actual practice, the number of properties being offered as collateral in a loan request package may be ten, twenty, fifty, hundred properties or more depending on the loan amount, value of each property;
and general market conditions.
[00076] The process of mixing and matching properties in a particular loan request package is as much as art as science. In general, a property valuation is made using a Modi 111855.00004 number of criteria, including cost of the property, book value (as carried on the balance sheet), and appraisal values. Sometimes, it is the appraised value that makes a property the most 'attractive at face value. Other times the book value is useful when the appraisal is unavailable or considered out-of-date. Another useful measurement of valuation is ratio of appraisal to book value. For example, a ratio of appraisal to book value in excess of 2000 may be a good indicator for a property to be included within a certain loan request package. There is no set formula for determining property valuation and when a loan request package has sufficient equity value to qualify for the requested financing. In general, depending on the loan amount, term of the loan, purpose of the loan, and past performance of the borrower, each lender has their own threshold of risk tolerance to determine whether the quality and quantity of properties being offered as collateral in the loan request package are sufficient to approve the loan as requested. The due diligence process is intended to help confirm the disclosure and quality of the properties.
(00077] In FIG. 13, truck rental company 30 creates loan request package 164 with retail store 32 and repair facility 34 being offered as collateral. Loan request package 164 is sent to lenders 166, 168, and 170. FIG. 13 further illustrates truck rental company 30 creating a second loan request package I72 and forwarding it to lenders 170 and 174. Loan request package 172 may involve the proposal to purchase another new property this time using the equity in office space 36, rental units 38, and manufacturing and retrofit facility 40 as collateral. The second loan request package 172 illustrates that truck rental company 30 may have multiple deals and associated loan requests going on simultaneously. Truck rental Modi 111855.00004 company 30 uses multiple lenders 166, 168, 170, and 174.
Some lenders may receive one loan request package, while other lenders, e.g. lender 170, may receive multiple loan request packages.
[00078] Once the loan request package has been submitted to one or more lenders, truck rental company 30 understands that each lender will have a multitude of questions and requests for information, all part of the due diligence process. Each lender may be interested in different information depending on their own internal loan processing rules. Again, the fact that truck rental company 30 maintains its property related information on central database 48 can be a valuable tool and greatly simplify the due diligence process.
[00079] Truck rental company 30 provides institutional lender website 176 shown in FIG. 14 residing on computer 12 for disclosing financial information to prospective lenders. Website 176 interacts with central database 48 and includes one or more webpages far providing information and receiving information. Computer 12 runs application software to host website 176. The information provided on each webpage is stored on hard disk 16, or other mass storage device accessible to computer 12.
[00080] As part of the loan request package and to assist with the due diligence process, truck rental company 30 provides each lender a dRL website address and log-in code.
Website 176 and associated lower webpages provides a portal into central database 48 to review information related to the properties being offered as collateral for the subject loan. Based on the log-in code provided to the lender, each lender has certain predefined rights and access to the property related information in database 48. In general, each lender is restricted to those properties that are being offered as collateral for the loan request package Modi . 111855.00004 being considered by the lender. Lenders 166 and 168 are limited to viewing property related information concerning retail store 32 and repair facility 34 from loan request package 164. Lender 174 is limited to viewing property related information concerning office space 36, rental units 38, and manufacturing and retrofit facility 40 from loan request package 172. Lender 170 has access the properties associated with loan request packages 164 and 172, although lender 170 may be restricted to one loan request package at a time. In all of the above cases, not all property related information for a particular property being offered as collateral is made available to the lender. In general, only property related information that is material and relevant to the loan review due diligence process is made available to the lender.
[00081 The lenders receive the benefit of reviewing the property related information from the convenience and efficiency of their own offices. For much of the due diligence process, there is no need to physically travel to the properties or offices of truck rental company 30. In the present case, computer 26 and 28 may be located in the offices of the lenders and connected by communication network 22 to computer 12. The lenders using computers 26 and 28 from theix own offices open website 176 on computer 12 and request to see property information. Computer 12 retrieves the property information from the database and displays the information on the webpages of website 176 for the remote lenders.
[00082] The first webpage on website 176 includes a welcome message customized for the lender as well as a general use statement, instructions, updates, and notices of use to the lender. Additional or special searching instructions are provided to aid in the searching process.
Webpage 176 further provides a selection of search boxes to Modi 111855.00004 allow the lender to search for properties within the present loan request package. For example, lender 166 can enter a state or providence in box 178 and click state/providence selection button 180. Box 178 accepts direct data entry and can be used as a pull-down screen of known values. If lender 146 enters "Arizona" in box 178 and clicks selection button 180, then webpage 176 searches database 48 to find all properties within loan package 164 that are located in Arizona and displays a summary of the properties on webpage 182, as shown in FIG. 15.
[00083] Assume for the purpose of illustration that retail store 32 and repair facility 34 are located in Arizona. FIG. l5 illustrates webpage 182 with picture 184 of retail store 32. Webpage 182 further displays the property identification number, address, executive summary, and other lender notes related to retail store 32 that are particularly relevant to the lender. Database 48 may include such a special lender note field to make suie the latest information is brought to their attention on webpage 182. A "more information" hyperlink 186 is provided to launch the lender to a webpage that displays all property related information concerning retail store 32 that is material and relevant to the subject loan request package and due diligence being conducted by the lender. Webpage 182 further displays picture 188 of repair facility 34 and the property identification number; address, executive summary, and other lender notes related to repair facility 34 that are particularly relevant to the lender. A "more information" hyperlink 190 is provided to launch the lender to a webpage that displays all property related information concerning office space 36 that is material and relevant to the subject loan request package and due diligence being conducted by the lender.
(00084] In FIG. 16, webpage 192 illustrates a complete Modi 111855.00004 listing of property related information concerning retail store 32 that is material and relevant to the subject loan request package and due diligence being conducted by the lender. The property related information is stored in 5 central database 48 and retrieved on command by the software operating on computer 12. Pictures 194, 196, 198, and 200 show various views and aspects of retail store 32.
Webpage 192 displays property identification number, address, executive summary, lender notes, demographics, 10 owner, liens, building square footage, land acres, map, occupancy, and environmental reports. Webpage 192 also displays property cost, book value, and appraisals with hyperlinks to associated reports, spreadsheets, and accounting records in support of the valuations. Webpage 15 192 further displays and/or provides hyperlinks to property tax records, title reports, income/expense statements;
competition information, budgets, rent roll, unit mix, furniture, fixtures and equipment (FFE), and contacts.
[00085] Each record or field of data in database 48 is 20 selectable to be included for viewing on webpages 182 and 192. A representative from truck rental company 30 selects which pictures and which property related information is to be displayed for the lender. If new pictures and information become available, the pictures and information 25 are stored on database 48 and selected by the representative to be shown on the lender webpages. To change which pictures and information are to be shown to the lenders, the representative simply de-selects the pictures and information which are no longer to be shown to 30 the lenders and selects the pictures and information which are to be shown to the lenders. When computer 12 queries database 48 for property related information for the selected property, it filters out that information which has not been approved for lender viewing. Only the Modi 111855.00004 property related information that has been approved for lender viewing is displayed on webpages 182 and 192.
[00086] Returning to FIG. 14, lenders can also search on specific property identification number by entering the desired number in box 202 and clicking selection box 204.
The lender is taken to webpage 192 as shown in FIG. 16 with the property related information for the specified property identification number. Clicking full list selection box 206 displays all properties for lender's loan request package in the summary format of webpage 182 in FIG. 15.
The lender can request more information from webpage 182 as described above if needed.
[00087] The lender can browse and review the most recent and up-to-date property related information at their convenience. If a particular item of information is missing or incomplete, then the .representative from truck rental company 30 can change the settings in database 48 such that the requested. information is displayed for the lender. If certain property related information is updated or becomes available, e.g. new appraisal or latest income/expense statement or news of a flood on the property, then truck rental company 30 need only update central database 48 and the information is immediately available for all lenders. Truck rental company 30 does not need to regenerate large volumes of paper for the lender for the original loan request package or each time the property related information changes. All that is needed is to update database 48 and include a note to the lender in the special lender note field that certain information has been changed.
[00088] Using an Internet-based access of central database 48 to compile property related information for financial institutions offers a number of advantages. When a company owns a large number of properties, having the _3g_ Modi 111855.00004 property related information is a common or central storage location simplifies the access for many users. The property related information can be compiled in short order from a central source. The property related information is accessible for any computer system with an Internet connection. Lenders do not have to incur the time and expense of sending due diligence teams to multiple locations to gather all the property related information to process the loan documents. The relevant information is available from central database 48 and displayed the webpages as described above.
[00089 The steps of compiling real property information from a central database is described in FIG. 17. In step 210, the real property information from portfolio of real properties is stored on a central database. In step 212, the set of real properties from the portfolio of real properties is offered as collateral in a loan package. In step 214, the real property information related to the set of real properties is made accessible to a lender through a website. The lender makes selections to view the real property information which is retrieved from the central database. In step 216, the real property information as selected by the lender is displayed on the website. In step 218, the real property information from the central database is accessed through a communication network. In step 220, the log-in code limits the lender to viewing the real property information related to the set of real properties property information. In step 222, the lender searches based on attributes of the set of real properties property information. In step 224, a summary of search results is displayed when search selections match more than one real property. In step 226, the website displays only real property information related to set of real properties which is approved for lender viewing.

f Modi 111855.00004 (00090] A person skilled in the art will recognize that changes can be made in form and detail and equivalents may be substituted for elements of the invention without departing from the scope and spirit of the invention. The present description is therefore considered in all respects to be illustrative and not restrictive, the scope of the invention being determined by the following claims and their equivalents as supported by the above disclosure and drawings.

Claims (26)

1. A method of compiling real property information from a central database, comprising:
providing a website;
storing real property information from a portfolio of real properties on the central database;
providing a set of real properties from the portfolio of real properties to be offered as collateral in a loan package;
providing access to the real property information related to the set of real properties to a lender through the website, wherein the lender makes selections to view the real property information which is retrieved from the central database; and displaying the real property information as selected by the lender on the website.
2. The method of claim 1 further including:
accessing the real property information from the central database through a communication network; and displaying the real property information for the lender operating a computer system remote from the central database.
3. The method of claim 1 wherein the step of providing a set of real properties includes the steps of:
determining a valuation of each of the portfolio of real properties; and selecting ones of the portfolio of real properties to form the set of real properties such that a total valuation of the set of real properties is sufficient for the loan package.
4. The method of.claim 1 further including the step of providing a log-in code to the lender, wherein the log-in code limits the lender to viewing the real property information related to the set of real properties.
5. The method of claim 4 further including the step of providing search selections for the lender to search based on attributes of the set of real properties.
6. The method of claim 5 further including the step of providing a summary of search results for a plurality of real properties when search selections match more than one real property.
7. The method of claim 1 further including the step of displaying only a first portion of the real property information related to the set of real properties which is approved for lender viewing.
8. The method of claim 7 further including the step of adding a second portion of real property information to that approved for lender viewing upon receiving a request from the lender for the second portion of real property information.
9. A method of using a central database to compile real property information, comprising:
providing a first set of real properties selected from a portfolio of real properties;
providing access to real property information related to the first set of real properties for a first user through a website, wherein the first user makes selections to view the real property information which is retrieved from the central database; and displaying the real property information as selected by the first user on the website.
10. The method of claim 9 further including:
providing a second set of real properties from a portfolio of real properties;
providing access to real property information related to the second set of real properties for a second user through the website, wherein the second user makes selections to view the real property information which is retrieved from the central database; and displaying the real property information as selected by the second user on the website.
11. The method of claim 10 further including providing access to the real property information related to the second set of real properties for the first user through the website.
12. The method of claim 9 further including:
accessing the real property information from the central database through a communication network; and displaying the real property information for the first user operating a first computer system remote from the central database.
13. The method of claim 9 wherein the step of providing a first set of real properties includes the steps of:
determining a valuation of each of the portfolio of real properties; and selecting ones of the portfolio of real properties to form the first set of real properties having a total valuation at least to a predetermined threshold.
14. The method of claim 9 further including the step of providing a log-in code to the first user, wherein the log-in code limits the first user to viewing real property information related to the first set of real properties.
15. The method of claim 14 further including the step of providing search selections for the first user to search based on attributes of the first set of real properties.
16. The method of claim 15 further including the step of providing a summary of search results for a plurality of real properties when search selections match more than one real property.
17. The method of claim 9 further including the step of displaying only a first portion of the real property information related to the first set of real properties which is approved for user viewing.
18. The method of claim 17 further including the step of adding a second portion of real property information related to the set of real properties to that approved for user viewing upon receiving a request from the first user for the second portion of real property information.
19. A method of compiling real property information from a central database, comprising:
providing a set of real properties selected from a portfolio of real properties;
providing access to a website for a user;
retrieving real property information related to the set of real properties from the central database in response to selections made by the user; and displaying the real property information retrieved from the central database on the website.
20. The method of claim 19 further including:
accessing the real property information from the central database through a communication network; and displaying the real property information for the user operating a computer system remote from the central database.
21. The method of claim 19 further including the step of providing a log-in code to the user, wherein the log-in code limits the user to viewing real property information related to t:he set of real properties.
22. The method of claim 21 further including the step of providing search selections for the user to search based on attributes of the set of real properties.
23. The method of claim 22 further including the step of providing a summary of search results for a plurality of real properties when search selections match more than one real property.
24. The method of claim 23 further including the step of displaying only a portion of the real property information related to the set of real properties which is approved for user viewing.
25. A computer system for managing real property, comprising:
means for providing a set of real properties selected from a portfolio of real properties;

means for providing access to a website for a user;
means for retrieving real property information related to the set of real properties from the central database in response to selections made by the user; and means for displaying the real property information retrieved from the central database on the website.
26. The computer system of claim 25 further including:
means for accessing the real property information from the central database through a communication network; and means for displaying the real property information for the user operating a computer system remote from the central database.
CA2482331A 2003-09-30 2004-09-24 System and method of compiling real property information from a central database Active CA2482331C (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/676,621 US7464109B2 (en) 2003-09-30 2003-09-30 System and method of compiling real property information from a central database
US10/676,621 2003-09-30

Publications (2)

Publication Number Publication Date
CA2482331A1 true CA2482331A1 (en) 2005-03-30
CA2482331C CA2482331C (en) 2014-06-10

Family

ID=34422113

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2482331A Active CA2482331C (en) 2003-09-30 2004-09-24 System and method of compiling real property information from a central database

Country Status (2)

Country Link
US (1) US7464109B2 (en)
CA (1) CA2482331C (en)

Families Citing this family (77)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2583401C (en) * 2004-10-08 2019-05-07 Approva Corporation Systems and methods for monitoring business processes of enterprise applications
US7693765B2 (en) 2004-11-30 2010-04-06 Michael Dell Orfano System and method for creating electronic real estate registration
US9076185B2 (en) 2004-11-30 2015-07-07 Michael Dell Orfano System and method for managing electronic real estate registry information
US7680707B2 (en) * 2004-12-06 2010-03-16 Harry Mottram Municipal personal property tax compliance method, system, and computer program product
US7693766B2 (en) * 2004-12-21 2010-04-06 Weather Risk Solutions Llc Financial activity based on natural events
US7584133B2 (en) * 2004-12-21 2009-09-01 Weather Risk Solutions Llc Financial activity based on tropical weather events
US8266042B2 (en) * 2004-12-21 2012-09-11 Weather Risk Solutions, Llc Financial activity based on natural peril events
US7783542B2 (en) * 2004-12-21 2010-08-24 Weather Risk Solutions, Llc Financial activity with graphical user interface based on natural peril events
US7783544B2 (en) * 2004-12-21 2010-08-24 Weather Risk Solutions, Llc Financial activity concerning tropical weather events
US7584134B2 (en) * 2004-12-21 2009-09-01 Weather Risk Solutions, Llc Graphical user interface for financial activity concerning tropical weather events
US7783543B2 (en) * 2004-12-21 2010-08-24 Weather Risk Solutions, Llc Financial activity based on natural peril events
US20090259581A1 (en) * 2004-12-21 2009-10-15 Horowitz Kenneth A Financial activity relating to natural peril events
US10068026B1 (en) * 2005-03-08 2018-09-04 Unearthed Land Technologies, Llc System for retrieving and serving the regulatory history of a property including mobile wireless communications device based searching and retrieval and related methods
US7831628B1 (en) * 2005-06-01 2010-11-09 Osiris Quintana System and method for management of building department services
US7904366B2 (en) * 2005-09-02 2011-03-08 General Electric Capital Corporation Method and system to determine resident qualifications
US20070106523A1 (en) * 2005-11-07 2007-05-10 Eaton James M Information system and method for generating appraisal reports for real properties
US8676680B2 (en) 2006-02-03 2014-03-18 Zillow, Inc. Automatically determining a current value for a home
US8515839B2 (en) 2006-02-03 2013-08-20 Zillow, Inc. Automatically determining a current value for a real estate property, such as a home, that is tailored to input from a human user, such as its owner
US20070214120A1 (en) * 2006-03-08 2007-09-13 Barrett Burke Wilson Castle Daffin & Frappier Llp System and Method for Electronic Processing of Title Records
EP2013719A4 (en) * 2006-05-01 2009-06-03 Approva Corp Managing controls within a heterogeneous enterprise environment
US20080077458A1 (en) 2006-09-19 2008-03-27 Andersen Timothy J Collecting and representing home attributes
US20080221936A1 (en) * 2007-03-07 2008-09-11 Andrew Patterson Automated property insurance quote system
JP5239367B2 (en) * 2007-03-19 2013-07-17 富士通株式会社 Information providing system, information providing program, and information providing method
US7899741B2 (en) * 2007-03-28 2011-03-01 Bank Of America Corporation Loss impact tracking system and method
US20080306982A1 (en) * 2007-06-08 2008-12-11 Kirk Moudy System and method for generating reports on real property and surroundings
US8825530B2 (en) * 2007-06-11 2014-09-02 Chevine Arthur Miller Tax liability and deductions verification system
US8078698B2 (en) * 2007-06-26 2011-12-13 At&T Intellectual Property I, L.P. Methods, systems, and products for producing persona-based hosts
US20130218628A1 (en) * 2007-12-07 2013-08-22 Raymond Dufresne System And Method For Capital Budgeting And Cost Estimation
US20090150201A1 (en) * 2007-12-07 2009-06-11 Raymond Dufresne System and method for capital budgeting
US7899875B1 (en) * 2008-01-08 2011-03-01 FlipKey, Inc. Digital data processing methods and systems for cultivating and providing guest feedback on rental accommodations
US8140421B1 (en) 2008-01-09 2012-03-20 Zillow, Inc. Automatically determining a current value for a home
US20100145828A1 (en) * 2008-09-03 2010-06-10 Move, Inc. Mortgage and real estate data integration and presentation system
US7991703B1 (en) * 2008-09-09 2011-08-02 United Services Automobile Association (Usaa) Systems and methods for providing a real estate and rental marketplace
US20110087577A1 (en) * 2009-10-08 2011-04-14 Milton Chace Slavin Computer-implemented system and method for real estate collateralized private party loan transactions
US8510031B2 (en) * 2009-11-24 2013-08-13 Joseph Williams Systems and methods for information transformation and exchange
US8346624B2 (en) * 2009-12-09 2013-01-01 Allconnect, Inc. Systems and methods for recommending third party products and services
US20110167007A1 (en) * 2010-01-07 2011-07-07 Chris Saitta System and method for task management
WO2012024453A1 (en) * 2010-08-17 2012-02-23 Homezada, Inc. On-line property asset system and method
US10380653B1 (en) 2010-09-16 2019-08-13 Trulia, Llc Valuation system
AU2011329043B2 (en) 2010-11-16 2016-10-13 Gazit Group Usa, Inc. Mobile digital property portfolio management system
US10460406B1 (en) 2011-03-09 2019-10-29 Zillow, Inc. Automatically determining market rental rates for properties
US10198735B1 (en) 2011-03-09 2019-02-05 Zillow, Inc. Automatically determining market rental rate index for properties
US8683008B1 (en) 2011-08-04 2014-03-25 Google Inc. Management of pre-fetched mapping data incorporating user-specified locations
US8204966B1 (en) 2011-09-26 2012-06-19 Google Inc. Map tile data pre-fetching based on user activity analysis
US8280414B1 (en) 2011-09-26 2012-10-02 Google Inc. Map tile data pre-fetching based on mobile device generated event analysis
US9275374B1 (en) 2011-11-15 2016-03-01 Google Inc. Method and apparatus for pre-fetching place page data based upon analysis of user activities
US8711181B1 (en) 2011-11-16 2014-04-29 Google Inc. Pre-fetching map data using variable map tile radius
US9063951B1 (en) 2011-11-16 2015-06-23 Google Inc. Pre-fetching map data based on a tile budget
US8886715B1 (en) 2011-11-16 2014-11-11 Google Inc. Dynamically determining a tile budget when pre-fetching data in a client device
US9305107B2 (en) 2011-12-08 2016-04-05 Google Inc. Method and apparatus for pre-fetching place page data for subsequent display on a mobile computing device
US9197713B2 (en) 2011-12-09 2015-11-24 Google Inc. Method and apparatus for pre-fetching remote resources for subsequent display on a mobile computing device
US8803920B2 (en) 2011-12-12 2014-08-12 Google Inc. Pre-fetching map tile data along a route
US9389088B2 (en) 2011-12-12 2016-07-12 Google Inc. Method of pre-fetching map data for rendering and offline routing
US9332387B2 (en) 2012-05-02 2016-05-03 Google Inc. Prefetching and caching map data based on mobile network coverage
CA2822147A1 (en) * 2012-07-26 2014-01-26 Symbility Solutions Inc. Claims-underwriting integration system and method
US8849942B1 (en) 2012-07-31 2014-09-30 Google Inc. Application programming interface for prefetching map data
US9430133B2 (en) * 2012-12-17 2016-08-30 Sap Se Career history exercise with stage card visualization
US10437889B2 (en) 2013-01-31 2019-10-08 Lf Technology Development Corporation Limited Systems and methods of providing outcomes based on collective intelligence experience
US10185917B2 (en) 2013-01-31 2019-01-22 Lf Technology Development Corporation Limited Computer-aided decision systems
US9767498B2 (en) 2013-01-31 2017-09-19 Lf Technology Development Corporation Ltd. Virtual purchasing assistant
US8873736B1 (en) * 2013-06-19 2014-10-28 Catalyst Services USA LLC Process for capturing site maintenance and repair information and creating a closeout package in near real time
US10754884B1 (en) * 2013-11-12 2020-08-25 Zillow, Inc. Flexible real estate search
US20150178795A1 (en) * 2013-12-23 2015-06-25 Fannie Mae Performing automated appraisals with automatic detection and remediation of situations involving faulty characteristics
US10984489B1 (en) 2014-02-13 2021-04-20 Zillow, Inc. Estimating the value of a property in a manner sensitive to nearby value-affecting geographic features
US20150254241A1 (en) * 2014-03-04 2015-09-10 Bank Of America Corporation Help desk search engine
US11093982B1 (en) 2014-10-02 2021-08-17 Zillow, Inc. Determine regional rate of return on home improvements
US10643232B1 (en) 2015-03-18 2020-05-05 Zillow, Inc. Allocating electronic advertising opportunities
US10599676B2 (en) 2015-12-15 2020-03-24 Microsoft Technology Licensing, Llc Replication control among redundant data centers
US10235406B2 (en) 2015-12-15 2019-03-19 Microsoft Technology Licensing, Llc Reminder processing of structured data records among partitioned data storage spaces
US11226985B2 (en) 2015-12-15 2022-01-18 Microsoft Technology Licensing, Llc Replication of structured data records among partitioned data storage spaces
US10248709B2 (en) * 2015-12-15 2019-04-02 Microsoft Technology Licensing, Llc Promoted properties in relational structured data
US10789549B1 (en) 2016-02-25 2020-09-29 Zillow, Inc. Enforcing, with respect to changes in one or more distinguished independent variable values, monotonicity in the predictions produced by a statistical model
US11158004B2 (en) 2018-11-05 2021-10-26 EIG Technology, Inc. Property assessment using a virtual assistant
US11816747B1 (en) * 2018-12-12 2023-11-14 United Services Automobile Association (Usaa) Systems and methods for mining data for property usage
US20200219186A1 (en) * 2019-01-09 2020-07-09 Amin Zameni Equity Lease/Swap
US20220237640A1 (en) * 2021-01-26 2022-07-28 Arrivalist Co. System and Method for Using Observational Datasets to Improve Hotel Revenue Estimates and Associated Economic Impact in Real-Time
US20240064926A1 (en) * 2022-08-22 2024-02-22 International Business Machines Corporation Damper for an electronic equipment rack

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4722055A (en) * 1984-03-08 1988-01-26 College Savings Bank Methods and apparatus for funding future liability of uncertain cost
US6327574B1 (en) * 1998-07-07 2001-12-04 Encirq Corporation Hierarchical models of consumer attributes for targeting content in a privacy-preserving manner
WO2001004791A1 (en) * 1999-07-09 2001-01-18 Streamline Systems Pty Ltd Methods of organising information
US20030036963A1 (en) * 2000-11-20 2003-02-20 Jeffrey Jacobson Method and system for aggregating real estate information content in an on-line computing environment
US20020147625A1 (en) * 2001-02-15 2002-10-10 Kolke Daniel Arthur Method and system for managing business referrals
US7818219B2 (en) * 2001-12-27 2010-10-19 American Hungarian Technologies Inc. Electronic realty and transaction system and method therein
AU2003285136A1 (en) * 2002-11-04 2004-06-07 Timothy K. Ford Method and system for comprehensive real estate transaction management

Also Published As

Publication number Publication date
US7464109B2 (en) 2008-12-09
CA2482331C (en) 2014-06-10
US20050080702A1 (en) 2005-04-14

Similar Documents

Publication Publication Date Title
US7464109B2 (en) System and method of compiling real property information from a central database
US20050071376A1 (en) System and method of managing real property through a central database
US6067525A (en) Integrated computerized sales force automation system
US6826539B2 (en) Virtual structure data repository and directory
US7010530B2 (en) Event management system
Kummerow et al. Information and communication technology in the real estate industry: productivity, industry structure and market efficiency
Rocheleau Public management information systems
US20100325204A1 (en) Method and system for interfacing clients with relationship management (rm) accounts and for permissioning marketing
US20030023610A1 (en) Online real and personal property management system and method
US20010047282A1 (en) System and method for managing real estate transactions
CA2394483A1 (en) Global asset information registry
US20060004612A1 (en) Systems and methods for configuring and processing insurance information
US20040220823A1 (en) System and method for procuring real estate agreements
US20040220820A1 (en) System and method for creating and managing real estate agreements
KR100325503B1 (en) ERP Hosting Service System Using Internet and Method thereof
Subramanian et al. An exploratory case study of enterprise resource planning implementation
US20060074705A1 (en) Method and system for residential property data capture, process, and distribute on-line for sale or lease purpose
Buck-Emden et al. mySAP CRM
US20230237587A1 (en) Dynamic automated insurance application architecture
JP2003534584A (en) Project cost evaluation system and evaluation method
US20090307122A1 (en) System and Method of Online Auction of Real Estate Options
Redlein et al. IT Support
WO2001052153A2 (en) System and method for managing real estate transactions
Chawla St. Gabriel's Library, Au
Chawla Database application for a small business enterprise

Legal Events

Date Code Title Description
EEER Examination request