SQL Editor
SITE:
Host-ed
DB's:
biketra1_bike
biketra1_cal
biketra1_food
biketra1_misc
biketra1_music
biketra1_qpb
biketra1_tour
Export SQL DB
Import SQL
Read SQL
LOGOFF |
Tables:
account
accttype
blpr
costbasis
dirlist
fininst
gluc
master
mort
notes
plot
pmt
smsSched
smssetup
sqlmaster
Export SQL Table
Export Table to CVS
Import Table from CSV
|
8 records
| . | Id | name | phone | phone2 | email | password | principal | addlLoan | interest | downpmt | term | balloon | balloonPmt | monpmt | start | noPmt | totPaid | balance | lastPmtAmt | lastPmtDate | ytdInt | priorInt | totInt | comment | master |
|---|
| 1 | Andrew and Diann - rental (CLOSED OUT) | | | | inca115 | 181984.00 | | 2.50 | 0.00 | 360 | 60 | 162157.22 | 767.25 | 2014-08-22 | 9 | 6905.25 | 179119.65 | 767.25 | 2015-05-20 | 2190.84 | 1835.33 | 4026.17 | Denver Houses | 0 | | 2 | Douglas C Raney - contract for deed paid off 6/29/18 | (217) 779-0495 | | | vermontClosed | 126100.00 | | 2.50 | 1100.00 | 360 | 0 | | 596.77 | 2014-12-01 | 41 | 142343.12 | -348.24 | 117701.12 | 2018-06-02 | 2167.04 | 4768.14 | 16996.52 | | 0 | | 3 | Idaho Springs Cabin (Paid In Full) | (720) 339-0584 | | | sodaCrk | 92500.00 | | 3.50 | 0.00 | 0 | 0 | | | 2010-04-05 | 54 | 111493.66 | -4355.05 | 67000.00 | 2015-09-22 | 1500.00 | 3377.95 | 14638.61 | | 0 | | 4 | Diann & Andrew - rental+home | | | | lincoln | 329119.65 | 0.00 | 3.50 | 0.00 | 360 | 51 | 297377.66 | 1443.04 | 2015-05-22 | 100 | 135054.73 | 264282.38 | 1443.04 | 2023-05-18 | 3341.29 | 7168.63 | 70141.46 | Rate 2.5% as of June 29. 2020: 3.5 July 1, 2022 | 0 | | 5 | lender | | | | Jack$5225 | | | 2.50 | 0.00 | 0 | 0 | | | 2015-06-22 | 0 | 0.00 | 0.00 | 0.00 | 2015-06-22 | 0.00 | 0.00 | 0.00 | | 1 | | 8 | Georgetown Construction - Main St. Paid Off Nov 15, 2022 | (720) 339-0584 | | bigfishllc@live.com | bearlo | 190000.00 | 0.00 | 3.50 | 0.00 | 180 | 0 | 0.00 | 1189.90 | 2021-06-30 | 19 | 196771.93 | 169.83 | 175234.63 | 2022-11-15 | 2676.47 | 1999.21 | 6940.63 | | 0 | | 32 | Diann & Andrew - Mount Sherman short term loan | | | | short | 60000.00 | 0.00 | 3.00 | 0.00 | 0 | | | | 2021-08-23 | 0 | 0.00 | 61352.71 | 0.00 | 2022-07-01 | 0.00 | 0.00 | 1352.71 | | 0 | | 33 | Kevin Fillmore | | | | airbnb | 250000.00 | 0.00 | 3.50 | 0.00 | 360 | 0 | 0.00 | 1122.61 | 2023-01-21 | 4 | 4490.44 | 248451.10 | 1122.61 | 2023-05-24 | | | 2941.54 | Buy out Shelly | 0 |
|