· 7 years ago · Jan 12, 2018, 11:44 PM
1<-------------- Model Function --------------->
2public function searchByZip($sSearchBy, $iMinPrice = 0, $iMaxPrice = 999999999, $iMinBathroom = 0, $iMinBedroom = 0)
3 {
4 $select = $this->select();
5 $select->where('zip_code = ?', $sSearchBy);
6 $select->where('sale_price > ?', $iMinPrice);
7 $select->where('sale_price < ?', $iMaxPrice);
8 $select->where('bedrooms > ?', $iMinBedroom);
9 $select->where('baths_total > ?', $iMinBathroom);
10 $select->order('priority');
11 $oPageAdapter = new Zend_Paginator_Adapter_DbTableSelect($select);
12 return $oPageAdapter;
13 }
14
15<-------------- Controller Function --------------->
16public function basicsearchAction()
17 {
18 if ($this->getRequest()->isPost())
19 {
20 $iMaxPrice = $_POST['max-price'];
21 $iMinPrice = $_POST['min-price'];
22 $iMinBedroom = $_POST['bedrooms'];
23 $iMinBathroom = $_POST['bathrooms'];
24 $oMlsModel = new Model_MlsMaster();
25 if($_POST['search-type'] == 'county')
26 $oSearchResults = $oMlsModel->searchByCounty($_POST['county-name'], $iMinPrice, $iMaxPrice, $iMinBathroom, $iMinBedroom);
27 elseif($_POST['search-type'] == 'city')
28 $oSearchResults = $oMlsModel->searchByCity($_POST['city-name'], $iMinPrice, $iMaxPrice, $iMinBathroom, $iMinBedroom);
29 elseif($_POST['search-type'] == 'zipcode')
30 $oSearchResults = $oMlsModel->searchByZip($_POST['zip'], $iMinPrice, $iMaxPrice, $iMinBathroom, $iMinBedroom);
31 elseif($_POST['search-type'] == 'subdivision')
32 $oSearchResults = $oMlsModel->searchBySubdivision($_POST['subdivision-name'], $iMinPrice, $iMaxPrice, $iMinBathroom, $iMinBedroom);
33 else
34 $oSearchResults = NULL;
35 }
36 else
37 $oSearchResults = NULL;
38 echo "<pre />";
39 print_r($oSearchResults);
40 die('here');
41 $oPageInator = new Zend_Paginator($oSearchResults);
42 //Show 10 per page
43 $oPageInator->setItemCountPerPage(10);
44 //Get Page number passed in the request if none then default to 1
45 $iCurrentPage = $this->_request->getParam('page', 1);
46 $oPageInator->setCurrentPageNumber($iCurrentPage);
47 $oPageInator->setCache(Zend_Registry::get('cache'));
48 //$this->view->oPageInator = $oPageInator;
49 $this->view->results = $$oPageInator;
50 $this->view->title = "MLS Search Results";
51 $this->view->description = "MLS Search Results";
52 }
53
54<------------Results is an Empty array----------------->
55Zend_Paginator_Adapter_DbTableSelect Object
56(
57 [_countSelect:protected] =>
58 [_select:protected] => Zend_Db_Table_Select Object
59 (
60 [_info:protected] => Array
61 (
62 [schema] =>
63 [name] => mls_master
64 [cols] => Array
65 (
66 [0] => id
67 [1] => mls_id
68 [2] => mls_state_id
69 [3] => mls_listing_id
70 [4] => tln_firm_id
71 [5] => mls_office_name
72 [6] => mls_office_phone
73 [7] => tln_realtor_id
74 [8] => mls_agent_name
75 [9] => mls_agent_phone
76 [10] => listing_date
77 [11] => listing_expiration_date
78 [12] => sold_date
79 [13] => available_date
80 [14] => property_type_code
81 [15] => prop_type_description
82 [16] => remarks
83 [17] => status_code
84 [18] => sale_price
85 [19] => sold_price
86 [20] => property_state_id
87 [21] => street_number
88 [22] => street_name
89 [23] => street_type
90 [24] => street_direction
91 [25] => unit_number
92 [26] => longitude
93 [27] => latitude
94 [28] => city
95 [29] => city_id
96 [30] => zip_code
97 [31] => zip_plus4
98 [32] => mls_area
99 [33] => county
100 [34] => fips_county_code
101 [35] => subdivision
102 [36] => community_name
103 [37] => year_built
104 [38] => acres
105 [39] => lot_dimensions
106 [40] => lot_square_footage
107 [41] => lot_square_footage_land
108 [42] => building_square_footage
109 [43] => bedrooms
110 [44] => baths_total
111 [45] => baths_full
112 [46] => baths_half
113 [47] => baths_three_quarter
114 [48] => fireplace_number
115 [49] => total_rooms
116 [50] => school_district
117 [51] => school_elementary
118 [52] => school_middle
119 [53] => school_junior_high
120 [54] => school_high
121 [55] => total_units
122 [56] => total_buildings
123 [57] => total_lots
124 [58] => hoa_fees
125 [59] => owners_name
126 [60] => legal
127 [61] => apn
128 [62] => taxes
129 [63] => tax_year
130 [64] => section
131 [65] => mls_range
132 [66] => township
133 [67] => rent_on
134 [68] => rent_off
135 [69] => photo_ind
136 [70] => last_mls_update_date
137 [71] => master_bed
138 [72] => bed2
139 [73] => bed3
140 [74] => bed4
141 [75] => bed5
142 [76] => kitchen
143 [77] => breakfast
144 [78] => laundry
145 [79] => den
146 [80] => dining
147 [81] => family
148 [82] => living
149 [83] => great
150 [84] => extra
151 [85] => feature_codes
152 [86] => mls_office_id
153 [87] => mls_agent_id
154 [88] => virtual_tour_url
155 [89] => photo_quantity
156 [90] => photo_url
157 [91] => photo_most_recent_date
158 [92] => avm
159 [93] => blogging
160 [94] => hoa_frequency
161 [95] => photo_valid
162 )
163
164 [primary] => Array
165 (
166 [1] => id
167 )
168
169 [metadata] => Array
170 (
171 [id] => Array
172 (
173 [SCHEMA_NAME] =>
174 [TABLE_NAME] => mls_master
175 [COLUMN_NAME] => id
176 [COLUMN_POSITION] => 1
177 [DATA_TYPE] => int
178 [DEFAULT] => 0
179 [NULLABLE] =>
180 [LENGTH] =>
181 [SCALE] =>
182 [PRECISION] =>
183 [UNSIGNED] =>
184 [PRIMARY] =>
185 [PRIMARY_POSITION] =>
186 [IDENTITY] =>
187 )
188
189 [mls_id] => Array
190 (
191 [SCHEMA_NAME] =>
192 [TABLE_NAME] => mls_master
193 [COLUMN_NAME] => mls_id
194 [COLUMN_POSITION] => 2
195 [DATA_TYPE] => varchar
196 [DEFAULT] =>
197 [NULLABLE] => 1
198 [LENGTH] => 11
199 [SCALE] =>
200 [PRECISION] =>
201 [UNSIGNED] =>
202 [PRIMARY] =>
203 [PRIMARY_POSITION] =>
204 [IDENTITY] =>
205 )
206
207 [mls_state_id] => Array
208 (
209 [SCHEMA_NAME] =>
210 [TABLE_NAME] => mls_master
211 [COLUMN_NAME] => mls_state_id
212 [COLUMN_POSITION] => 3
213 [DATA_TYPE] => varchar
214 [DEFAULT] =>
215 [NULLABLE] => 1
216 [LENGTH] => 3
217 [SCALE] =>
218 [PRECISION] =>
219 [UNSIGNED] =>
220 [PRIMARY] =>
221 [PRIMARY_POSITION] =>
222 [IDENTITY] =>
223 )
224
225 [mls_listing_id] => Array
226 (
227 [SCHEMA_NAME] =>
228 [TABLE_NAME] => mls_master
229 [COLUMN_NAME] => mls_listing_id
230 [COLUMN_POSITION] => 4
231 [DATA_TYPE] => varchar
232 [DEFAULT] =>
233 [NULLABLE] => 1
234 [LENGTH] => 15
235 [SCALE] =>
236 [PRECISION] =>
237 [UNSIGNED] =>
238 [PRIMARY] =>
239 [PRIMARY_POSITION] =>
240 [IDENTITY] =>
241 )
242
243 [tln_firm_id] => Array
244 (
245 [SCHEMA_NAME] =>
246 [TABLE_NAME] => mls_master
247 [COLUMN_NAME] => tln_firm_id
248 [COLUMN_POSITION] => 5
249 [DATA_TYPE] => int
250 [DEFAULT] =>
251 [NULLABLE] => 1
252 [LENGTH] =>
253 [SCALE] =>
254 [PRECISION] =>
255 [UNSIGNED] =>
256 [PRIMARY] =>
257 [PRIMARY_POSITION] =>
258 [IDENTITY] =>
259 )
260
261 [mls_office_name] => Array
262 (
263 [SCHEMA_NAME] =>
264 [TABLE_NAME] => mls_master
265 [COLUMN_NAME] => mls_office_name
266 [COLUMN_POSITION] => 6
267 [DATA_TYPE] => varchar
268 [DEFAULT] =>
269 [NULLABLE] => 1
270 [LENGTH] => 120
271 [SCALE] =>
272 [PRECISION] =>
273 [UNSIGNED] =>
274 [PRIMARY] =>
275 [PRIMARY_POSITION] =>
276 [IDENTITY] =>
277 )
278
279 [mls_office_phone] => Array
280 (
281 [SCHEMA_NAME] =>
282 [TABLE_NAME] => mls_master
283 [COLUMN_NAME] => mls_office_phone
284 [COLUMN_POSITION] => 7
285 [DATA_TYPE] => varchar
286 [DEFAULT] =>
287 [NULLABLE] => 1
288 [LENGTH] => 15
289 [SCALE] =>
290 [PRECISION] =>
291 [UNSIGNED] =>
292 [PRIMARY] =>
293 [PRIMARY_POSITION] =>
294 [IDENTITY] =>
295 )
296
297 [tln_realtor_id] => Array
298 (
299 [SCHEMA_NAME] =>
300 [TABLE_NAME] => mls_master
301 [COLUMN_NAME] => tln_realtor_id
302 [COLUMN_POSITION] => 8
303 [DATA_TYPE] => int
304 [DEFAULT] =>
305 [NULLABLE] => 1
306 [LENGTH] =>
307 [SCALE] =>
308 [PRECISION] =>
309 [UNSIGNED] =>
310 [PRIMARY] =>
311 [PRIMARY_POSITION] =>
312 [IDENTITY] =>
313 )
314
315 [mls_agent_name] => Array
316 (
317 [SCHEMA_NAME] =>
318 [TABLE_NAME] => mls_master
319 [COLUMN_NAME] => mls_agent_name
320 [COLUMN_POSITION] => 9
321 [DATA_TYPE] => varchar
322 [DEFAULT] =>
323 [NULLABLE] => 1
324 [LENGTH] => 50
325 [SCALE] =>
326 [PRECISION] =>
327 [UNSIGNED] =>
328 [PRIMARY] =>
329 [PRIMARY_POSITION] =>
330 [IDENTITY] =>
331 )
332
333 [mls_agent_phone] => Array
334 (
335 [SCHEMA_NAME] =>
336 [TABLE_NAME] => mls_master
337 [COLUMN_NAME] => mls_agent_phone
338 [COLUMN_POSITION] => 10
339 [DATA_TYPE] => varchar
340 [DEFAULT] =>
341 [NULLABLE] => 1
342 [LENGTH] => 15
343 [SCALE] =>
344 [PRECISION] =>
345 [UNSIGNED] =>
346 [PRIMARY] =>
347 [PRIMARY_POSITION] =>
348 [IDENTITY] =>
349 )
350
351 [listing_date] => Array
352 (
353 [SCHEMA_NAME] =>
354 [TABLE_NAME] => mls_master
355 [COLUMN_NAME] => listing_date
356 [COLUMN_POSITION] => 11
357 [DATA_TYPE] => int
358 [DEFAULT] =>
359 [NULLABLE] => 1
360 [LENGTH] =>
361 [SCALE] =>
362 [PRECISION] =>
363 [UNSIGNED] =>
364 [PRIMARY] =>
365 [PRIMARY_POSITION] =>
366 [IDENTITY] =>
367 )
368
369 [listing_expiration_date] => Array
370 (
371 [SCHEMA_NAME] =>
372 [TABLE_NAME] => mls_master
373 [COLUMN_NAME] => listing_expiration_date
374 [COLUMN_POSITION] => 12
375 [DATA_TYPE] => int
376 [DEFAULT] =>
377 [NULLABLE] => 1
378 [LENGTH] =>
379 [SCALE] =>
380 [PRECISION] =>
381 [UNSIGNED] =>
382 [PRIMARY] =>
383 [PRIMARY_POSITION] =>
384 [IDENTITY] =>
385 )
386
387 [sold_date] => Array
388 (
389 [SCHEMA_NAME] =>
390 [TABLE_NAME] => mls_master
391 [COLUMN_NAME] => sold_date
392 [COLUMN_POSITION] => 13
393 [DATA_TYPE] => int
394 [DEFAULT] =>
395 [NULLABLE] => 1
396 [LENGTH] =>
397 [SCALE] =>
398 [PRECISION] =>
399 [UNSIGNED] =>
400 [PRIMARY] =>
401 [PRIMARY_POSITION] =>
402 [IDENTITY] =>
403 )
404
405 [available_date] => Array
406 (
407 [SCHEMA_NAME] =>
408 [TABLE_NAME] => mls_master
409 [COLUMN_NAME] => available_date
410 [COLUMN_POSITION] => 14
411 [DATA_TYPE] => int
412 [DEFAULT] =>
413 [NULLABLE] => 1
414 [LENGTH] =>
415 [SCALE] =>
416 [PRECISION] =>
417 [UNSIGNED] =>
418 [PRIMARY] =>
419 [PRIMARY_POSITION] =>
420 [IDENTITY] =>
421 )
422
423 [property_type_code] => Array
424 (
425 [SCHEMA_NAME] =>
426 [TABLE_NAME] => mls_master
427 [COLUMN_NAME] => property_type_code
428 [COLUMN_POSITION] => 15
429 [DATA_TYPE] => varchar
430 [DEFAULT] =>
431 [NULLABLE] => 1
432 [LENGTH] => 10
433 [SCALE] =>
434 [PRECISION] =>
435 [UNSIGNED] =>
436 [PRIMARY] =>
437 [PRIMARY_POSITION] =>
438 [IDENTITY] =>
439 )
440
441 [prop_type_description] => Array
442 (
443 [SCHEMA_NAME] =>
444 [TABLE_NAME] => mls_master
445 [COLUMN_NAME] => prop_type_description
446 [COLUMN_POSITION] => 16
447 [DATA_TYPE] => varchar
448 [DEFAULT] =>
449 [NULLABLE] => 1
450 [LENGTH] => 50
451 [SCALE] =>
452 [PRECISION] =>
453 [UNSIGNED] =>
454 [PRIMARY] =>
455 [PRIMARY_POSITION] =>
456 [IDENTITY] =>
457 )
458
459 [remarks] => Array
460 (
461 [SCHEMA_NAME] =>
462 [TABLE_NAME] => mls_master
463 [COLUMN_NAME] => remarks
464 [COLUMN_POSITION] => 17
465 [DATA_TYPE] => text
466 [DEFAULT] =>
467 [NULLABLE] => 1
468 [LENGTH] =>
469 [SCALE] =>
470 [PRECISION] =>
471 [UNSIGNED] =>
472 [PRIMARY] =>
473 [PRIMARY_POSITION] =>
474 [IDENTITY] =>
475 )
476
477 [status_code] => Array
478 (
479 [SCHEMA_NAME] =>
480 [TABLE_NAME] => mls_master
481 [COLUMN_NAME] => status_code
482 [COLUMN_POSITION] => 18
483 [DATA_TYPE] => varchar
484 [DEFAULT] =>
485 [NULLABLE] => 1
486 [LENGTH] => 10
487 [SCALE] =>
488 [PRECISION] =>
489 [UNSIGNED] =>
490 [PRIMARY] =>
491 [PRIMARY_POSITION] =>
492 [IDENTITY] =>
493 )
494
495 [sale_price] => Array
496 (
497 [SCHEMA_NAME] =>
498 [TABLE_NAME] => mls_master
499 [COLUMN_NAME] => sale_price
500 [COLUMN_POSITION] => 19
501 [DATA_TYPE] => int
502 [DEFAULT] =>
503 [NULLABLE] => 1
504 [LENGTH] =>
505 [SCALE] =>
506 [PRECISION] =>
507 [UNSIGNED] =>
508 [PRIMARY] =>
509 [PRIMARY_POSITION] =>
510 [IDENTITY] =>
511 )
512
513 [sold_price] => Array
514 (
515 [SCHEMA_NAME] =>
516 [TABLE_NAME] => mls_master
517 [COLUMN_NAME] => sold_price
518 [COLUMN_POSITION] => 20
519 [DATA_TYPE] => int
520 [DEFAULT] =>
521 [NULLABLE] => 1
522 [LENGTH] =>
523 [SCALE] =>
524 [PRECISION] =>
525 [UNSIGNED] =>
526 [PRIMARY] =>
527 [PRIMARY_POSITION] =>
528 [IDENTITY] =>
529 )
530
531 [property_state_id] => Array
532 (
533 [SCHEMA_NAME] =>
534 [TABLE_NAME] => mls_master
535 [COLUMN_NAME] => property_state_id
536 [COLUMN_POSITION] => 21
537 [DATA_TYPE] => varchar
538 [DEFAULT] =>
539 [NULLABLE] => 1
540 [LENGTH] => 3
541 [SCALE] =>
542 [PRECISION] =>
543 [UNSIGNED] =>
544 [PRIMARY] =>
545 [PRIMARY_POSITION] =>
546 [IDENTITY] =>
547 )
548
549 [street_number] => Array
550 (
551 [SCHEMA_NAME] =>
552 [TABLE_NAME] => mls_master
553 [COLUMN_NAME] => street_number
554 [COLUMN_POSITION] => 22
555 [DATA_TYPE] => int
556 [DEFAULT] =>
557 [NULLABLE] => 1
558 [LENGTH] =>
559 [SCALE] =>
560 [PRECISION] =>
561 [UNSIGNED] =>
562 [PRIMARY] =>
563 [PRIMARY_POSITION] =>
564 [IDENTITY] =>
565 )
566
567 [street_name] => Array
568 (
569 [SCHEMA_NAME] =>
570 [TABLE_NAME] => mls_master
571 [COLUMN_NAME] => street_name
572 [COLUMN_POSITION] => 23
573 [DATA_TYPE] => varchar
574 [DEFAULT] =>
575 [NULLABLE] => 1
576 [LENGTH] => 30
577 [SCALE] =>
578 [PRECISION] =>
579 [UNSIGNED] =>
580 [PRIMARY] =>
581 [PRIMARY_POSITION] =>
582 [IDENTITY] =>
583 )
584
585 [street_type] => Array
586 (
587 [SCHEMA_NAME] =>
588 [TABLE_NAME] => mls_master
589 [COLUMN_NAME] => street_type
590 [COLUMN_POSITION] => 24
591 [DATA_TYPE] => varchar
592 [DEFAULT] =>
593 [NULLABLE] => 1
594 [LENGTH] => 10
595 [SCALE] =>
596 [PRECISION] =>
597 [UNSIGNED] =>
598 [PRIMARY] =>
599 [PRIMARY_POSITION] =>
600 [IDENTITY] =>
601 )
602
603 [street_direction] => Array
604 (
605 [SCHEMA_NAME] =>
606 [TABLE_NAME] => mls_master
607 [COLUMN_NAME] => street_direction
608 [COLUMN_POSITION] => 25
609 [DATA_TYPE] => varchar
610 [DEFAULT] =>
611 [NULLABLE] => 1
612 [LENGTH] => 2
613 [SCALE] =>
614 [PRECISION] =>
615 [UNSIGNED] =>
616 [PRIMARY] =>
617 [PRIMARY_POSITION] =>
618 [IDENTITY] =>
619 )
620
621 [unit_number] => Array
622 (
623 [SCHEMA_NAME] =>
624 [TABLE_NAME] => mls_master
625 [COLUMN_NAME] => unit_number
626 [COLUMN_POSITION] => 26
627 [DATA_TYPE] => varchar
628 [DEFAULT] =>
629 [NULLABLE] => 1
630 [LENGTH] => 10
631 [SCALE] =>
632 [PRECISION] =>
633 [UNSIGNED] =>
634 [PRIMARY] =>
635 [PRIMARY_POSITION] =>
636 [IDENTITY] =>
637 )
638
639 [longitude] => Array
640 (
641 [SCHEMA_NAME] =>
642 [TABLE_NAME] => mls_master
643 [COLUMN_NAME] => longitude
644 [COLUMN_POSITION] => 27
645 [DATA_TYPE] => float
646 [DEFAULT] =>
647 [NULLABLE] => 1
648 [LENGTH] =>
649 [SCALE] =>
650 [PRECISION] =>
651 [UNSIGNED] =>
652 [PRIMARY] =>
653 [PRIMARY_POSITION] =>
654 [IDENTITY] =>
655 )
656
657 [latitude] => Array
658 (
659 [SCHEMA_NAME] =>
660 [TABLE_NAME] => mls_master
661 [COLUMN_NAME] => latitude
662 [COLUMN_POSITION] => 28
663 [DATA_TYPE] => float
664 [DEFAULT] =>
665 [NULLABLE] => 1
666 [LENGTH] =>
667 [SCALE] =>
668 [PRECISION] =>
669 [UNSIGNED] =>
670 [PRIMARY] =>
671 [PRIMARY_POSITION] =>
672 [IDENTITY] =>
673 )
674
675 [city] => Array
676 (
677 [SCHEMA_NAME] =>
678 [TABLE_NAME] => mls_master
679 [COLUMN_NAME] => city
680 [COLUMN_POSITION] => 29
681 [DATA_TYPE] => varchar
682 [DEFAULT] =>
683 [NULLABLE] => 1
684 [LENGTH] => 25
685 [SCALE] =>
686 [PRECISION] =>
687 [UNSIGNED] =>
688 [PRIMARY] =>
689 [PRIMARY_POSITION] =>
690 [IDENTITY] =>
691 )
692
693 [city_id] => Array
694 (
695 [SCHEMA_NAME] =>
696 [TABLE_NAME] => mls_master
697 [COLUMN_NAME] => city_id
698 [COLUMN_POSITION] => 30
699 [DATA_TYPE] => varchar
700 [DEFAULT] =>
701 [NULLABLE] => 1
702 [LENGTH] => 10
703 [SCALE] =>
704 [PRECISION] =>
705 [UNSIGNED] =>
706 [PRIMARY] =>
707 [PRIMARY_POSITION] =>
708 [IDENTITY] =>
709 )
710
711 [zip_code] => Array
712 (
713 [SCHEMA_NAME] =>
714 [TABLE_NAME] => mls_master
715 [COLUMN_NAME] => zip_code
716 [COLUMN_POSITION] => 31
717 [DATA_TYPE] => int
718 [DEFAULT] =>
719 [NULLABLE] => 1
720 [LENGTH] =>
721 [SCALE] =>
722 [PRECISION] =>
723 [UNSIGNED] =>
724 [PRIMARY] =>
725 [PRIMARY_POSITION] =>
726 [IDENTITY] =>
727 )
728
729 [zip_plus4] => Array
730 (
731 [SCHEMA_NAME] =>
732 [TABLE_NAME] => mls_master
733 [COLUMN_NAME] => zip_plus4
734 [COLUMN_POSITION] => 32
735 [DATA_TYPE] => int
736 [DEFAULT] =>
737 [NULLABLE] => 1
738 [LENGTH] =>
739 [SCALE] =>
740 [PRECISION] =>
741 [UNSIGNED] =>
742 [PRIMARY] =>
743 [PRIMARY_POSITION] =>
744 [IDENTITY] =>
745 )
746
747 [mls_area] => Array
748 (
749 [SCHEMA_NAME] =>
750 [TABLE_NAME] => mls_master
751 [COLUMN_NAME] => mls_area
752 [COLUMN_POSITION] => 33
753 [DATA_TYPE] => varchar
754 [DEFAULT] =>
755 [NULLABLE] => 1
756 [LENGTH] => 25
757 [SCALE] =>
758 [PRECISION] =>
759 [UNSIGNED] =>
760 [PRIMARY] =>
761 [PRIMARY_POSITION] =>
762 [IDENTITY] =>
763 )
764
765 [county] => Array
766 (
767 [SCHEMA_NAME] =>
768 [TABLE_NAME] => mls_master
769 [COLUMN_NAME] => county
770 [COLUMN_POSITION] => 34
771 [DATA_TYPE] => varchar
772 [DEFAULT] =>
773 [NULLABLE] => 1
774 [LENGTH] => 25
775 [SCALE] =>
776 [PRECISION] =>
777 [UNSIGNED] =>
778 [PRIMARY] =>
779 [PRIMARY_POSITION] =>
780 [IDENTITY] =>
781 )
782
783 [fips_county_code] => Array
784 (
785 [SCHEMA_NAME] =>
786 [TABLE_NAME] => mls_master
787 [COLUMN_NAME] => fips_county_code
788 [COLUMN_POSITION] => 35
789 [DATA_TYPE] => int
790 [DEFAULT] =>
791 [NULLABLE] => 1
792 [LENGTH] =>
793 [SCALE] =>
794 [PRECISION] =>
795 [UNSIGNED] =>
796 [PRIMARY] =>
797 [PRIMARY_POSITION] =>
798 [IDENTITY] =>
799 )
800
801 [subdivision] => Array
802 (
803 [SCHEMA_NAME] =>
804 [TABLE_NAME] => mls_master
805 [COLUMN_NAME] => subdivision
806 [COLUMN_POSITION] => 36
807 [DATA_TYPE] => varchar
808 [DEFAULT] =>
809 [NULLABLE] => 1
810 [LENGTH] => 30
811 [SCALE] =>
812 [PRECISION] =>
813 [UNSIGNED] =>
814 [PRIMARY] =>
815 [PRIMARY_POSITION] =>
816 [IDENTITY] =>
817 )
818
819 [community_name] => Array
820 (
821 [SCHEMA_NAME] =>
822 [TABLE_NAME] => mls_master
823 [COLUMN_NAME] => community_name
824 [COLUMN_POSITION] => 37
825 [DATA_TYPE] => varchar
826 [DEFAULT] =>
827 [NULLABLE] => 1
828 [LENGTH] => 30
829 [SCALE] =>
830 [PRECISION] =>
831 [UNSIGNED] =>
832 [PRIMARY] =>
833 [PRIMARY_POSITION] =>
834 [IDENTITY] =>
835 )
836
837 [year_built] => Array
838 (
839 [SCHEMA_NAME] =>
840 [TABLE_NAME] => mls_master
841 [COLUMN_NAME] => year_built
842 [COLUMN_POSITION] => 38
843 [DATA_TYPE] => int
844 [DEFAULT] =>
845 [NULLABLE] => 1
846 [LENGTH] =>
847 [SCALE] =>
848 [PRECISION] =>
849 [UNSIGNED] =>
850 [PRIMARY] =>
851 [PRIMARY_POSITION] =>
852 [IDENTITY] =>
853 )
854
855 [acres] => Array
856 (
857 [SCHEMA_NAME] =>
858 [TABLE_NAME] => mls_master
859 [COLUMN_NAME] => acres
860 [COLUMN_POSITION] => 39
861 [DATA_TYPE] => decimal
862 [DEFAULT] =>
863 [NULLABLE] => 1
864 [LENGTH] =>
865 [SCALE] => 2
866 [PRECISION] => 8
867 [UNSIGNED] =>
868 [PRIMARY] =>
869 [PRIMARY_POSITION] =>
870 [IDENTITY] =>
871 )
872
873 [lot_dimensions] => Array
874 (
875 [SCHEMA_NAME] =>
876 [TABLE_NAME] => mls_master
877 [COLUMN_NAME] => lot_dimensions
878 [COLUMN_POSITION] => 40
879 [DATA_TYPE] => varchar
880 [DEFAULT] =>
881 [NULLABLE] => 1
882 [LENGTH] => 30
883 [SCALE] =>
884 [PRECISION] =>
885 [UNSIGNED] =>
886 [PRIMARY] =>
887 [PRIMARY_POSITION] =>
888 [IDENTITY] =>
889 )
890
891 [lot_square_footage] => Array
892 (
893 [SCHEMA_NAME] =>
894 [TABLE_NAME] => mls_master
895 [COLUMN_NAME] => lot_square_footage
896 [COLUMN_POSITION] => 41
897 [DATA_TYPE] => int
898 [DEFAULT] =>
899 [NULLABLE] => 1
900 [LENGTH] =>
901 [SCALE] =>
902 [PRECISION] =>
903 [UNSIGNED] =>
904 [PRIMARY] =>
905 [PRIMARY_POSITION] =>
906 [IDENTITY] =>
907 )
908
909 [lot_square_footage_land] => Array
910 (
911 [SCHEMA_NAME] =>
912 [TABLE_NAME] => mls_master
913 [COLUMN_NAME] => lot_square_footage_land
914 [COLUMN_POSITION] => 42
915 [DATA_TYPE] => int
916 [DEFAULT] =>
917 [NULLABLE] => 1
918 [LENGTH] =>
919 [SCALE] =>
920 [PRECISION] =>
921 [UNSIGNED] =>
922 [PRIMARY] =>
923 [PRIMARY_POSITION] =>
924 [IDENTITY] =>
925 )
926
927 [building_square_footage] => Array
928 (
929 [SCHEMA_NAME] =>
930 [TABLE_NAME] => mls_master
931 [COLUMN_NAME] => building_square_footage
932 [COLUMN_POSITION] => 43
933 [DATA_TYPE] => int
934 [DEFAULT] =>
935 [NULLABLE] => 1
936 [LENGTH] =>
937 [SCALE] =>
938 [PRECISION] =>
939 [UNSIGNED] =>
940 [PRIMARY] =>
941 [PRIMARY_POSITION] =>
942 [IDENTITY] =>
943 )
944
945 [bedrooms] => Array
946 (
947 [SCHEMA_NAME] =>
948 [TABLE_NAME] => mls_master
949 [COLUMN_NAME] => bedrooms
950 [COLUMN_POSITION] => 44
951 [DATA_TYPE] => int
952 [DEFAULT] =>
953 [NULLABLE] => 1
954 [LENGTH] =>
955 [SCALE] =>
956 [PRECISION] =>
957 [UNSIGNED] =>
958 [PRIMARY] =>
959 [PRIMARY_POSITION] =>
960 [IDENTITY] =>
961 )
962
963 [baths_total] => Array
964 (
965 [SCHEMA_NAME] =>
966 [TABLE_NAME] => mls_master
967 [COLUMN_NAME] => baths_total
968 [COLUMN_POSITION] => 45
969 [DATA_TYPE] => decimal
970 [DEFAULT] =>
971 [NULLABLE] => 1
972 [LENGTH] =>
973 [SCALE] => 2
974 [PRECISION] => 5
975 [UNSIGNED] =>
976 [PRIMARY] =>
977 [PRIMARY_POSITION] =>
978 [IDENTITY] =>
979 )
980
981 [baths_full] => Array
982 (
983 [SCHEMA_NAME] =>
984 [TABLE_NAME] => mls_master
985 [COLUMN_NAME] => baths_full
986 [COLUMN_POSITION] => 46
987 [DATA_TYPE] => int
988 [DEFAULT] =>
989 [NULLABLE] => 1
990 [LENGTH] =>
991 [SCALE] =>
992 [PRECISION] =>
993 [UNSIGNED] =>
994 [PRIMARY] =>
995 [PRIMARY_POSITION] =>
996 [IDENTITY] =>
997 )
998
999 [baths_half] => Array
1000 (
1001 [SCHEMA_NAME] =>
1002 [TABLE_NAME] => mls_master
1003 [COLUMN_NAME] => baths_half
1004 [COLUMN_POSITION] => 47
1005 [DATA_TYPE] => int
1006 [DEFAULT] =>
1007 [NULLABLE] => 1
1008 [LENGTH] =>
1009 [SCALE] =>
1010 [PRECISION] =>
1011 [UNSIGNED] =>
1012 [PRIMARY] =>
1013 [PRIMARY_POSITION] =>
1014 [IDENTITY] =>
1015 )
1016
1017 [baths_three_quarter] => Array
1018 (
1019 [SCHEMA_NAME] =>
1020 [TABLE_NAME] => mls_master
1021 [COLUMN_NAME] => baths_three_quarter
1022 [COLUMN_POSITION] => 48
1023 [DATA_TYPE] => int
1024 [DEFAULT] =>
1025 [NULLABLE] => 1
1026 [LENGTH] =>
1027 [SCALE] =>
1028 [PRECISION] =>
1029 [UNSIGNED] =>
1030 [PRIMARY] =>
1031 [PRIMARY_POSITION] =>
1032 [IDENTITY] =>
1033 )
1034
1035 [fireplace_number] => Array
1036 (
1037 [SCHEMA_NAME] =>
1038 [TABLE_NAME] => mls_master
1039 [COLUMN_NAME] => fireplace_number
1040 [COLUMN_POSITION] => 49
1041 [DATA_TYPE] => int
1042 [DEFAULT] =>
1043 [NULLABLE] => 1
1044 [LENGTH] =>
1045 [SCALE] =>
1046 [PRECISION] =>
1047 [UNSIGNED] =>
1048 [PRIMARY] =>
1049 [PRIMARY_POSITION] =>
1050 [IDENTITY] =>
1051 )
1052
1053 [total_rooms] => Array
1054 (
1055 [SCHEMA_NAME] =>
1056 [TABLE_NAME] => mls_master
1057 [COLUMN_NAME] => total_rooms
1058 [COLUMN_POSITION] => 50
1059 [DATA_TYPE] => int
1060 [DEFAULT] =>
1061 [NULLABLE] => 1
1062 [LENGTH] =>
1063 [SCALE] =>
1064 [PRECISION] =>
1065 [UNSIGNED] =>
1066 [PRIMARY] =>
1067 [PRIMARY_POSITION] =>
1068 [IDENTITY] =>
1069 )
1070
1071 [school_district] => Array
1072 (
1073 [SCHEMA_NAME] =>
1074 [TABLE_NAME] => mls_master
1075 [COLUMN_NAME] => school_district
1076 [COLUMN_POSITION] => 51
1077 [DATA_TYPE] => varchar
1078 [DEFAULT] =>
1079 [NULLABLE] => 1
1080 [LENGTH] => 30
1081 [SCALE] =>
1082 [PRECISION] =>
1083 [UNSIGNED] =>
1084 [PRIMARY] =>
1085 [PRIMARY_POSITION] =>
1086 [IDENTITY] =>
1087 )
1088
1089 [school_elementary] => Array
1090 (
1091 [SCHEMA_NAME] =>
1092 [TABLE_NAME] => mls_master
1093 [COLUMN_NAME] => school_elementary
1094 [COLUMN_POSITION] => 52
1095 [DATA_TYPE] => varchar
1096 [DEFAULT] =>
1097 [NULLABLE] => 1
1098 [LENGTH] => 30
1099 [SCALE] =>
1100 [PRECISION] =>
1101 [UNSIGNED] =>
1102 [PRIMARY] =>
1103 [PRIMARY_POSITION] =>
1104 [IDENTITY] =>
1105 )
1106
1107 [school_middle] => Array
1108 (
1109 [SCHEMA_NAME] =>
1110 [TABLE_NAME] => mls_master
1111 [COLUMN_NAME] => school_middle
1112 [COLUMN_POSITION] => 53
1113 [DATA_TYPE] => varchar
1114 [DEFAULT] =>
1115 [NULLABLE] => 1
1116 [LENGTH] => 30
1117 [SCALE] =>
1118 [PRECISION] =>
1119 [UNSIGNED] =>
1120 [PRIMARY] =>
1121 [PRIMARY_POSITION] =>
1122 [IDENTITY] =>
1123 )
1124
1125 [school_junior_high] => Array
1126 (
1127 [SCHEMA_NAME] =>
1128 [TABLE_NAME] => mls_master
1129 [COLUMN_NAME] => school_junior_high
1130 [COLUMN_POSITION] => 54
1131 [DATA_TYPE] => varchar
1132 [DEFAULT] =>
1133 [NULLABLE] => 1
1134 [LENGTH] => 30
1135 [SCALE] =>
1136 [PRECISION] =>
1137 [UNSIGNED] =>
1138 [PRIMARY] =>
1139 [PRIMARY_POSITION] =>
1140 [IDENTITY] =>
1141 )
1142
1143 [school_high] => Array
1144 (
1145 [SCHEMA_NAME] =>
1146 [TABLE_NAME] => mls_master
1147 [COLUMN_NAME] => school_high
1148 [COLUMN_POSITION] => 55
1149 [DATA_TYPE] => varchar
1150 [DEFAULT] =>
1151 [NULLABLE] => 1
1152 [LENGTH] => 30
1153 [SCALE] =>
1154 [PRECISION] =>
1155 [UNSIGNED] =>
1156 [PRIMARY] =>
1157 [PRIMARY_POSITION] =>
1158 [IDENTITY] =>
1159 )
1160
1161 [total_units] => Array
1162 (
1163 [SCHEMA_NAME] =>
1164 [TABLE_NAME] => mls_master
1165 [COLUMN_NAME] => total_units
1166 [COLUMN_POSITION] => 56
1167 [DATA_TYPE] => int
1168 [DEFAULT] =>
1169 [NULLABLE] => 1
1170 [LENGTH] =>
1171 [SCALE] =>
1172 [PRECISION] =>
1173 [UNSIGNED] =>
1174 [PRIMARY] =>
1175 [PRIMARY_POSITION] =>
1176 [IDENTITY] =>
1177 )
1178
1179 [total_buildings] => Array
1180 (
1181 [SCHEMA_NAME] =>
1182 [TABLE_NAME] => mls_master
1183 [COLUMN_NAME] => total_buildings
1184 [COLUMN_POSITION] => 57
1185 [DATA_TYPE] => int
1186 [DEFAULT] =>
1187 [NULLABLE] => 1
1188 [LENGTH] =>
1189 [SCALE] =>
1190 [PRECISION] =>
1191 [UNSIGNED] =>
1192 [PRIMARY] =>
1193 [PRIMARY_POSITION] =>
1194 [IDENTITY] =>
1195 )
1196
1197 [total_lots] => Array
1198 (
1199 [SCHEMA_NAME] =>
1200 [TABLE_NAME] => mls_master
1201 [COLUMN_NAME] => total_lots
1202 [COLUMN_POSITION] => 58
1203 [DATA_TYPE] => int
1204 [DEFAULT] =>
1205 [NULLABLE] => 1
1206 [LENGTH] =>
1207 [SCALE] =>
1208 [PRECISION] =>
1209 [UNSIGNED] =>
1210 [PRIMARY] =>
1211 [PRIMARY_POSITION] =>
1212 [IDENTITY] =>
1213 )
1214
1215 [hoa_fees] => Array
1216 (
1217 [SCHEMA_NAME] =>
1218 [TABLE_NAME] => mls_master
1219 [COLUMN_NAME] => hoa_fees
1220 [COLUMN_POSITION] => 59
1221 [DATA_TYPE] => int
1222 [DEFAULT] =>
1223 [NULLABLE] => 1
1224 [LENGTH] =>
1225 [SCALE] =>
1226 [PRECISION] =>
1227 [UNSIGNED] =>
1228 [PRIMARY] =>
1229 [PRIMARY_POSITION] =>
1230 [IDENTITY] =>
1231 )
1232
1233 [owners_name] => Array
1234 (
1235 [SCHEMA_NAME] =>
1236 [TABLE_NAME] => mls_master
1237 [COLUMN_NAME] => owners_name
1238 [COLUMN_POSITION] => 60
1239 [DATA_TYPE] => varchar
1240 [DEFAULT] =>
1241 [NULLABLE] => 1
1242 [LENGTH] => 50
1243 [SCALE] =>
1244 [PRECISION] =>
1245 [UNSIGNED] =>
1246 [PRIMARY] =>
1247 [PRIMARY_POSITION] =>
1248 [IDENTITY] =>
1249 )
1250
1251 [legal] => Array
1252 (
1253 [SCHEMA_NAME] =>
1254 [TABLE_NAME] => mls_master
1255 [COLUMN_NAME] => legal
1256 [COLUMN_POSITION] => 61
1257 [DATA_TYPE] => text
1258 [DEFAULT] =>
1259 [NULLABLE] => 1
1260 [LENGTH] =>
1261 [SCALE] =>
1262 [PRECISION] =>
1263 [UNSIGNED] =>
1264 [PRIMARY] =>
1265 [PRIMARY_POSITION] =>
1266 [IDENTITY] =>
1267 )
1268
1269 [apn] => Array
1270 (
1271 [SCHEMA_NAME] =>
1272 [TABLE_NAME] => mls_master
1273 [COLUMN_NAME] => apn
1274 [COLUMN_POSITION] => 62
1275 [DATA_TYPE] => varchar
1276 [DEFAULT] =>
1277 [NULLABLE] => 1
1278 [LENGTH] => 45
1279 [SCALE] =>
1280 [PRECISION] =>
1281 [UNSIGNED] =>
1282 [PRIMARY] =>
1283 [PRIMARY_POSITION] =>
1284 [IDENTITY] =>
1285 )
1286
1287 [taxes] => Array
1288 (
1289 [SCHEMA_NAME] =>
1290 [TABLE_NAME] => mls_master
1291 [COLUMN_NAME] => taxes
1292 [COLUMN_POSITION] => 63
1293 [DATA_TYPE] => int
1294 [DEFAULT] =>
1295 [NULLABLE] => 1
1296 [LENGTH] =>
1297 [SCALE] =>
1298 [PRECISION] =>
1299 [UNSIGNED] =>
1300 [PRIMARY] =>
1301 [PRIMARY_POSITION] =>
1302 [IDENTITY] =>
1303 )
1304
1305 [tax_year] => Array
1306 (
1307 [SCHEMA_NAME] =>
1308 [TABLE_NAME] => mls_master
1309 [COLUMN_NAME] => tax_year
1310 [COLUMN_POSITION] => 64
1311 [DATA_TYPE] => int
1312 [DEFAULT] =>
1313 [NULLABLE] => 1
1314 [LENGTH] =>
1315 [SCALE] =>
1316 [PRECISION] =>
1317 [UNSIGNED] =>
1318 [PRIMARY] =>
1319 [PRIMARY_POSITION] =>
1320 [IDENTITY] =>
1321 )
1322
1323 [section] => Array
1324 (
1325 [SCHEMA_NAME] =>
1326 [TABLE_NAME] => mls_master
1327 [COLUMN_NAME] => section
1328 [COLUMN_POSITION] => 65
1329 [DATA_TYPE] => varchar
1330 [DEFAULT] =>
1331 [NULLABLE] => 1
1332 [LENGTH] => 10
1333 [SCALE] =>
1334 [PRECISION] =>
1335 [UNSIGNED] =>
1336 [PRIMARY] =>
1337 [PRIMARY_POSITION] =>
1338 [IDENTITY] =>
1339 )
1340
1341 [mls_range] => Array
1342 (
1343 [SCHEMA_NAME] =>
1344 [TABLE_NAME] => mls_master
1345 [COLUMN_NAME] => mls_range
1346 [COLUMN_POSITION] => 66
1347 [DATA_TYPE] => varchar
1348 [DEFAULT] =>
1349 [NULLABLE] => 1
1350 [LENGTH] => 10
1351 [SCALE] =>
1352 [PRECISION] =>
1353 [UNSIGNED] =>
1354 [PRIMARY] =>
1355 [PRIMARY_POSITION] =>
1356 [IDENTITY] =>
1357 )
1358
1359 [township] => Array
1360 (
1361 [SCHEMA_NAME] =>
1362 [TABLE_NAME] => mls_master
1363 [COLUMN_NAME] => township
1364 [COLUMN_POSITION] => 67
1365 [DATA_TYPE] => varchar
1366 [DEFAULT] =>
1367 [NULLABLE] => 1
1368 [LENGTH] => 10
1369 [SCALE] =>
1370 [PRECISION] =>
1371 [UNSIGNED] =>
1372 [PRIMARY] =>
1373 [PRIMARY_POSITION] =>
1374 [IDENTITY] =>
1375 )
1376
1377 [rent_on] => Array
1378 (
1379 [SCHEMA_NAME] =>
1380 [TABLE_NAME] => mls_master
1381 [COLUMN_NAME] => rent_on
1382 [COLUMN_POSITION] => 68
1383 [DATA_TYPE] => int
1384 [DEFAULT] =>
1385 [NULLABLE] => 1
1386 [LENGTH] =>
1387 [SCALE] =>
1388 [PRECISION] =>
1389 [UNSIGNED] =>
1390 [PRIMARY] =>
1391 [PRIMARY_POSITION] =>
1392 [IDENTITY] =>
1393 )
1394
1395 [rent_off] => Array
1396 (
1397 [SCHEMA_NAME] =>
1398 [TABLE_NAME] => mls_master
1399 [COLUMN_NAME] => rent_off
1400 [COLUMN_POSITION] => 69
1401 [DATA_TYPE] => int
1402 [DEFAULT] =>
1403 [NULLABLE] => 1
1404 [LENGTH] =>
1405 [SCALE] =>
1406 [PRECISION] =>
1407 [UNSIGNED] =>
1408 [PRIMARY] =>
1409 [PRIMARY_POSITION] =>
1410 [IDENTITY] =>
1411 )
1412
1413 [photo_ind] => Array
1414 (
1415 [SCHEMA_NAME] =>
1416 [TABLE_NAME] => mls_master
1417 [COLUMN_NAME] => photo_ind
1418 [COLUMN_POSITION] => 70
1419 [DATA_TYPE] => varchar
1420 [DEFAULT] =>
1421 [NULLABLE] => 1
1422 [LENGTH] => 2
1423 [SCALE] =>
1424 [PRECISION] =>
1425 [UNSIGNED] =>
1426 [PRIMARY] =>
1427 [PRIMARY_POSITION] =>
1428 [IDENTITY] =>
1429 )
1430
1431 [last_mls_update_date] => Array
1432 (
1433 [SCHEMA_NAME] =>
1434 [TABLE_NAME] => mls_master
1435 [COLUMN_NAME] => last_mls_update_date
1436 [COLUMN_POSITION] => 71
1437 [DATA_TYPE] => int
1438 [DEFAULT] =>
1439 [NULLABLE] => 1
1440 [LENGTH] =>
1441 [SCALE] =>
1442 [PRECISION] =>
1443 [UNSIGNED] =>
1444 [PRIMARY] =>
1445 [PRIMARY_POSITION] =>
1446 [IDENTITY] =>
1447 )
1448
1449 [master_bed] => Array
1450 (
1451 [SCHEMA_NAME] =>
1452 [TABLE_NAME] => mls_master
1453 [COLUMN_NAME] => master_bed
1454 [COLUMN_POSITION] => 72
1455 [DATA_TYPE] => varchar
1456 [DEFAULT] =>
1457 [NULLABLE] => 1
1458 [LENGTH] => 15
1459 [SCALE] =>
1460 [PRECISION] =>
1461 [UNSIGNED] =>
1462 [PRIMARY] =>
1463 [PRIMARY_POSITION] =>
1464 [IDENTITY] =>
1465 )
1466
1467 [bed2] => Array
1468 (
1469 [SCHEMA_NAME] =>
1470 [TABLE_NAME] => mls_master
1471 [COLUMN_NAME] => bed2
1472 [COLUMN_POSITION] => 73
1473 [DATA_TYPE] => varchar
1474 [DEFAULT] =>
1475 [NULLABLE] => 1
1476 [LENGTH] => 15
1477 [SCALE] =>
1478 [PRECISION] =>
1479 [UNSIGNED] =>
1480 [PRIMARY] =>
1481 [PRIMARY_POSITION] =>
1482 [IDENTITY] =>
1483 )
1484
1485 [bed3] => Array
1486 (
1487 [SCHEMA_NAME] =>
1488 [TABLE_NAME] => mls_master
1489 [COLUMN_NAME] => bed3
1490 [COLUMN_POSITION] => 74
1491 [DATA_TYPE] => varchar
1492 [DEFAULT] =>
1493 [NULLABLE] => 1
1494 [LENGTH] => 15
1495 [SCALE] =>
1496 [PRECISION] =>
1497 [UNSIGNED] =>
1498 [PRIMARY] =>
1499 [PRIMARY_POSITION] =>
1500 [IDENTITY] =>
1501 )
1502
1503 [bed4] => Array
1504 (
1505 [SCHEMA_NAME] =>
1506 [TABLE_NAME] => mls_master
1507 [COLUMN_NAME] => bed4
1508 [COLUMN_POSITION] => 75
1509 [DATA_TYPE] => varchar
1510 [DEFAULT] =>
1511 [NULLABLE] => 1
1512 [LENGTH] => 15
1513 [SCALE] =>
1514 [PRECISION] =>
1515 [UNSIGNED] =>
1516 [PRIMARY] =>
1517 [PRIMARY_POSITION] =>
1518 [IDENTITY] =>
1519 )
1520
1521 [bed5] => Array
1522 (
1523 [SCHEMA_NAME] =>
1524 [TABLE_NAME] => mls_master
1525 [COLUMN_NAME] => bed5
1526 [COLUMN_POSITION] => 76
1527 [DATA_TYPE] => varchar
1528 [DEFAULT] =>
1529 [NULLABLE] => 1
1530 [LENGTH] => 15
1531 [SCALE] =>
1532 [PRECISION] =>
1533 [UNSIGNED] =>
1534 [PRIMARY] =>
1535 [PRIMARY_POSITION] =>
1536 [IDENTITY] =>
1537 )
1538
1539 [kitchen] => Array
1540 (
1541 [SCHEMA_NAME] =>
1542 [TABLE_NAME] => mls_master
1543 [COLUMN_NAME] => kitchen
1544 [COLUMN_POSITION] => 77
1545 [DATA_TYPE] => varchar
1546 [DEFAULT] =>
1547 [NULLABLE] => 1
1548 [LENGTH] => 15
1549 [SCALE] =>
1550 [PRECISION] =>
1551 [UNSIGNED] =>
1552 [PRIMARY] =>
1553 [PRIMARY_POSITION] =>
1554 [IDENTITY] =>
1555 )
1556
1557 [breakfast] => Array
1558 (
1559 [SCHEMA_NAME] =>
1560 [TABLE_NAME] => mls_master
1561 [COLUMN_NAME] => breakfast
1562 [COLUMN_POSITION] => 78
1563 [DATA_TYPE] => varchar
1564 [DEFAULT] =>
1565 [NULLABLE] => 1
1566 [LENGTH] => 15
1567 [SCALE] =>
1568 [PRECISION] =>
1569 [UNSIGNED] =>
1570 [PRIMARY] =>
1571 [PRIMARY_POSITION] =>
1572 [IDENTITY] =>
1573 )
1574
1575 [laundry] => Array
1576 (
1577 [SCHEMA_NAME] =>
1578 [TABLE_NAME] => mls_master
1579 [COLUMN_NAME] => laundry
1580 [COLUMN_POSITION] => 79
1581 [DATA_TYPE] => varchar
1582 [DEFAULT] =>
1583 [NULLABLE] => 1
1584 [LENGTH] => 15
1585 [SCALE] =>
1586 [PRECISION] =>
1587 [UNSIGNED] =>
1588 [PRIMARY] =>
1589 [PRIMARY_POSITION] =>
1590 [IDENTITY] =>
1591 )
1592
1593 [den] => Array
1594 (
1595 [SCHEMA_NAME] =>
1596 [TABLE_NAME] => mls_master
1597 [COLUMN_NAME] => den
1598 [COLUMN_POSITION] => 80
1599 [DATA_TYPE] => varchar
1600 [DEFAULT] =>
1601 [NULLABLE] => 1
1602 [LENGTH] => 15
1603 [SCALE] =>
1604 [PRECISION] =>
1605 [UNSIGNED] =>
1606 [PRIMARY] =>
1607 [PRIMARY_POSITION] =>
1608 [IDENTITY] =>
1609 )
1610
1611 [dining] => Array
1612 (
1613 [SCHEMA_NAME] =>
1614 [TABLE_NAME] => mls_master
1615 [COLUMN_NAME] => dining
1616 [COLUMN_POSITION] => 81
1617 [DATA_TYPE] => varchar
1618 [DEFAULT] =>
1619 [NULLABLE] => 1
1620 [LENGTH] => 15
1621 [SCALE] =>
1622 [PRECISION] =>
1623 [UNSIGNED] =>
1624 [PRIMARY] =>
1625 [PRIMARY_POSITION] =>
1626 [IDENTITY] =>
1627 )
1628
1629 [family] => Array
1630 (
1631 [SCHEMA_NAME] =>
1632 [TABLE_NAME] => mls_master
1633 [COLUMN_NAME] => family
1634 [COLUMN_POSITION] => 82
1635 [DATA_TYPE] => varchar
1636 [DEFAULT] =>
1637 [NULLABLE] => 1
1638 [LENGTH] => 15
1639 [SCALE] =>
1640 [PRECISION] =>
1641 [UNSIGNED] =>
1642 [PRIMARY] =>
1643 [PRIMARY_POSITION] =>
1644 [IDENTITY] =>
1645 )
1646
1647 [living] => Array
1648 (
1649 [SCHEMA_NAME] =>
1650 [TABLE_NAME] => mls_master
1651 [COLUMN_NAME] => living
1652 [COLUMN_POSITION] => 83
1653 [DATA_TYPE] => varchar
1654 [DEFAULT] =>
1655 [NULLABLE] => 1
1656 [LENGTH] => 15
1657 [SCALE] =>
1658 [PRECISION] =>
1659 [UNSIGNED] =>
1660 [PRIMARY] =>
1661 [PRIMARY_POSITION] =>
1662 [IDENTITY] =>
1663 )
1664
1665 [great] => Array
1666 (
1667 [SCHEMA_NAME] =>
1668 [TABLE_NAME] => mls_master
1669 [COLUMN_NAME] => great
1670 [COLUMN_POSITION] => 84
1671 [DATA_TYPE] => varchar
1672 [DEFAULT] =>
1673 [NULLABLE] => 1
1674 [LENGTH] => 15
1675 [SCALE] =>
1676 [PRECISION] =>
1677 [UNSIGNED] =>
1678 [PRIMARY] =>
1679 [PRIMARY_POSITION] =>
1680 [IDENTITY] =>
1681 )
1682
1683 [extra] => Array
1684 (
1685 [SCHEMA_NAME] =>
1686 [TABLE_NAME] => mls_master
1687 [COLUMN_NAME] => extra
1688 [COLUMN_POSITION] => 85
1689 [DATA_TYPE] => varchar
1690 [DEFAULT] =>
1691 [NULLABLE] => 1
1692 [LENGTH] => 15
1693 [SCALE] =>
1694 [PRECISION] =>
1695 [UNSIGNED] =>
1696 [PRIMARY] =>
1697 [PRIMARY_POSITION] =>
1698 [IDENTITY] =>
1699 )
1700
1701 [feature_codes] => Array
1702 (
1703 [SCHEMA_NAME] =>
1704 [TABLE_NAME] => mls_master
1705 [COLUMN_NAME] => feature_codes
1706 [COLUMN_POSITION] => 86
1707 [DATA_TYPE] => text
1708 [DEFAULT] =>
1709 [NULLABLE] => 1
1710 [LENGTH] =>
1711 [SCALE] =>
1712 [PRECISION] =>
1713 [UNSIGNED] =>
1714 [PRIMARY] =>
1715 [PRIMARY_POSITION] =>
1716 [IDENTITY] =>
1717 )
1718
1719 [mls_office_id] => Array
1720 (
1721 [SCHEMA_NAME] =>
1722 [TABLE_NAME] => mls_master
1723 [COLUMN_NAME] => mls_office_id
1724 [COLUMN_POSITION] => 87
1725 [DATA_TYPE] => varchar
1726 [DEFAULT] =>
1727 [NULLABLE] => 1
1728 [LENGTH] => 15
1729 [SCALE] =>
1730 [PRECISION] =>
1731 [UNSIGNED] =>
1732 [PRIMARY] =>
1733 [PRIMARY_POSITION] =>
1734 [IDENTITY] =>
1735 )
1736
1737 [mls_agent_id] => Array
1738 (
1739 [SCHEMA_NAME] =>
1740 [TABLE_NAME] => mls_master
1741 [COLUMN_NAME] => mls_agent_id
1742 [COLUMN_POSITION] => 88
1743 [DATA_TYPE] => varchar
1744 [DEFAULT] =>
1745 [NULLABLE] => 1
1746 [LENGTH] => 15
1747 [SCALE] =>
1748 [PRECISION] =>
1749 [UNSIGNED] =>
1750 [PRIMARY] =>
1751 [PRIMARY_POSITION] =>
1752 [IDENTITY] =>
1753 )
1754
1755 [virtual_tour_url] => Array
1756 (
1757 [SCHEMA_NAME] =>
1758 [TABLE_NAME] => mls_master
1759 [COLUMN_NAME] => virtual_tour_url
1760 [COLUMN_POSITION] => 89
1761 [DATA_TYPE] => varchar
1762 [DEFAULT] =>
1763 [NULLABLE] => 1
1764 [LENGTH] => 200
1765 [SCALE] =>
1766 [PRECISION] =>
1767 [UNSIGNED] =>
1768 [PRIMARY] =>
1769 [PRIMARY_POSITION] =>
1770 [IDENTITY] =>
1771 )
1772
1773 [photo_quantity] => Array
1774 (
1775 [SCHEMA_NAME] =>
1776 [TABLE_NAME] => mls_master
1777 [COLUMN_NAME] => photo_quantity
1778 [COLUMN_POSITION] => 90
1779 [DATA_TYPE] => int
1780 [DEFAULT] =>
1781 [NULLABLE] => 1
1782 [LENGTH] =>
1783 [SCALE] =>
1784 [PRECISION] =>
1785 [UNSIGNED] =>
1786 [PRIMARY] =>
1787 [PRIMARY_POSITION] =>
1788 [IDENTITY] =>
1789 )
1790
1791 [photo_url] => Array
1792 (
1793 [SCHEMA_NAME] =>
1794 [TABLE_NAME] => mls_master
1795 [COLUMN_NAME] => photo_url
1796 [COLUMN_POSITION] => 91
1797 [DATA_TYPE] => varchar
1798 [DEFAULT] =>
1799 [NULLABLE] => 1
1800 [LENGTH] => 100
1801 [SCALE] =>
1802 [PRECISION] =>
1803 [UNSIGNED] =>
1804 [PRIMARY] =>
1805 [PRIMARY_POSITION] =>
1806 [IDENTITY] =>
1807 )
1808
1809 [photo_most_recent_date] => Array
1810 (
1811 [SCHEMA_NAME] =>
1812 [TABLE_NAME] => mls_master
1813 [COLUMN_NAME] => photo_most_recent_date
1814 [COLUMN_POSITION] => 92
1815 [DATA_TYPE] => int
1816 [DEFAULT] =>
1817 [NULLABLE] => 1
1818 [LENGTH] =>
1819 [SCALE] =>
1820 [PRECISION] =>
1821 [UNSIGNED] =>
1822 [PRIMARY] =>
1823 [PRIMARY_POSITION] =>
1824 [IDENTITY] =>
1825 )
1826
1827 [avm] => Array
1828 (
1829 [SCHEMA_NAME] =>
1830 [TABLE_NAME] => mls_master
1831 [COLUMN_NAME] => avm
1832 [COLUMN_POSITION] => 93
1833 [DATA_TYPE] => varchar
1834 [DEFAULT] =>
1835 [NULLABLE] => 1
1836 [LENGTH] => 3
1837 [SCALE] =>
1838 [PRECISION] =>
1839 [UNSIGNED] =>
1840 [PRIMARY] =>
1841 [PRIMARY_POSITION] =>
1842 [IDENTITY] =>
1843 )
1844
1845 [blogging] => Array
1846 (
1847 [SCHEMA_NAME] =>
1848 [TABLE_NAME] => mls_master
1849 [COLUMN_NAME] => blogging
1850 [COLUMN_POSITION] => 94
1851 [DATA_TYPE] => varchar
1852 [DEFAULT] =>
1853 [NULLABLE] => 1
1854 [LENGTH] => 3
1855 [SCALE] =>
1856 [PRECISION] =>
1857 [UNSIGNED] =>
1858 [PRIMARY] =>
1859 [PRIMARY_POSITION] =>
1860 [IDENTITY] =>
1861 )
1862
1863 [hoa_frequency] => Array
1864 (
1865 [SCHEMA_NAME] =>
1866 [TABLE_NAME] => mls_master
1867 [COLUMN_NAME] => hoa_frequency
1868 [COLUMN_POSITION] => 95
1869 [DATA_TYPE] => varchar
1870 [DEFAULT] =>
1871 [NULLABLE] => 1
1872 [LENGTH] => 20
1873 [SCALE] =>
1874 [PRECISION] =>
1875 [UNSIGNED] =>
1876 [PRIMARY] =>
1877 [PRIMARY_POSITION] =>
1878 [IDENTITY] =>
1879 )
1880
1881 [photo_valid] => Array
1882 (
1883 [SCHEMA_NAME] =>
1884 [TABLE_NAME] => mls_master
1885 [COLUMN_NAME] => photo_valid
1886 [COLUMN_POSITION] => 96
1887 [DATA_TYPE] => int
1888 [DEFAULT] =>
1889 [NULLABLE] => 1
1890 [LENGTH] =>
1891 [SCALE] =>
1892 [PRECISION] =>
1893 [UNSIGNED] =>
1894 [PRIMARY] =>
1895 [PRIMARY_POSITION] =>
1896 [IDENTITY] =>
1897 )
1898
1899 )
1900
1901 [rowClass] => Zend_Db_Table_Row
1902 [rowsetClass] => Zend_Db_Table_Rowset
1903 [referenceMap] => Array
1904 (
1905 )
1906
1907 [dependentTables] => Array
1908 (
1909 )
1910
1911 [sequence] => 1
1912 )
1913
1914 [_integrityCheck:protected] => 1
1915 [_table:protected] => Model_MlsMaster Object
1916 (
1917 [_name:protected] => mls_master
1918 [_primary:protected] => Array
1919 (
1920 [1] => id
1921 )
1922
1923 [_definition:protected] =>
1924 [_definitionConfigName:protected] =>
1925 [_db:protected] => Zend_Db_Adapter_Pdo_Mysql Object
1926 (
1927 [_pdoType:protected] => mysql
1928 [_numericDataTypes:protected] => Array
1929 (
1930 [0] => 0
1931 [1] => 1
1932 [2] => 2
1933 [INT] => 0
1934 [INTEGER] => 0
1935 [MEDIUMINT] => 0
1936 [SMALLINT] => 0
1937 [TINYINT] => 0
1938 [BIGINT] => 1
1939 [SERIAL] => 1
1940 [DEC] => 2
1941 [DECIMAL] => 2
1942 [DOUBLE] => 2
1943 [DOUBLE PRECISION] => 2
1944 [FIXED] => 2
1945 [FLOAT] => 2
1946 )
1947
1948 [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
1949 [_config:protected] => Array
1950 (
1951 [host] => 192.168.1.12
1952 [username] => root
1953 [password] => 19Thud64
1954 [dbname] => central_florida_mls
1955 [charset] =>
1956 [persistent] =>
1957 [options] => Array
1958 (
1959 [caseFolding] => 0
1960 [autoQuoteIdentifiers] => 1
1961 [fetchMode] => 2
1962 )
1963
1964 [driver_options] => Array
1965 (
1966 )
1967
1968 )
1969
1970 [_fetchMode:protected] => 2
1971 [_profiler:protected] => Zend_Db_Profiler Object
1972 (
1973 [_queryProfiles:protected] => Array
1974 (
1975 )
1976
1977 [_enabled:protected] =>
1978 [_filterElapsedSecs:protected] =>
1979 [_filterTypes:protected] =>
1980 )
1981
1982 [_defaultProfilerClass:protected] => Zend_Db_Profiler
1983 [_connection:protected] => PDO Object
1984 (
1985 )
1986
1987 [_caseFolding:protected] => 0
1988 [_autoQuoteIdentifiers:protected] => 1
1989 [_allowSerialization:protected] => 1
1990 [_autoReconnectOnUnserialize:protected] =>
1991 )
1992
1993 [_schema:protected] =>
1994 [_cols:protected] => Array
1995 (
1996 [0] => id
1997 [1] => mls_id
1998 [2] => mls_state_id
1999 [3] => mls_listing_id
2000 [4] => tln_firm_id
2001 [5] => mls_office_name
2002 [6] => mls_office_phone
2003 [7] => tln_realtor_id
2004 [8] => mls_agent_name
2005 [9] => mls_agent_phone
2006 [10] => listing_date
2007 [11] => listing_expiration_date
2008 [12] => sold_date
2009 [13] => available_date
2010 [14] => property_type_code
2011 [15] => prop_type_description
2012 [16] => remarks
2013 [17] => status_code
2014 [18] => sale_price
2015 [19] => sold_price
2016 [20] => property_state_id
2017 [21] => street_number
2018 [22] => street_name
2019 [23] => street_type
2020 [24] => street_direction
2021 [25] => unit_number
2022 [26] => longitude
2023 [27] => latitude
2024 [28] => city
2025 [29] => city_id
2026 [30] => zip_code
2027 [31] => zip_plus4
2028 [32] => mls_area
2029 [33] => county
2030 [34] => fips_county_code
2031 [35] => subdivision
2032 [36] => community_name
2033 [37] => year_built
2034 [38] => acres
2035 [39] => lot_dimensions
2036 [40] => lot_square_footage
2037 [41] => lot_square_footage_land
2038 [42] => building_square_footage
2039 [43] => bedrooms
2040 [44] => baths_total
2041 [45] => baths_full
2042 [46] => baths_half
2043 [47] => baths_three_quarter
2044 [48] => fireplace_number
2045 [49] => total_rooms
2046 [50] => school_district
2047 [51] => school_elementary
2048 [52] => school_middle
2049 [53] => school_junior_high
2050 [54] => school_high
2051 [55] => total_units
2052 [56] => total_buildings
2053 [57] => total_lots
2054 [58] => hoa_fees
2055 [59] => owners_name
2056 [60] => legal
2057 [61] => apn
2058 [62] => taxes
2059 [63] => tax_year
2060 [64] => section
2061 [65] => mls_range
2062 [66] => township
2063 [67] => rent_on
2064 [68] => rent_off
2065 [69] => photo_ind
2066 [70] => last_mls_update_date
2067 [71] => master_bed
2068 [72] => bed2
2069 [73] => bed3
2070 [74] => bed4
2071 [75] => bed5
2072 [76] => kitchen
2073 [77] => breakfast
2074 [78] => laundry
2075 [79] => den
2076 [80] => dining
2077 [81] => family
2078 [82] => living
2079 [83] => great
2080 [84] => extra
2081 [85] => feature_codes
2082 [86] => mls_office_id
2083 [87] => mls_agent_id
2084 [88] => virtual_tour_url
2085 [89] => photo_quantity
2086 [90] => photo_url
2087 [91] => photo_most_recent_date
2088 [92] => avm
2089 [93] => blogging
2090 [94] => hoa_frequency
2091 [95] => photo_valid
2092 )
2093
2094 [_identity:protected] => 1
2095 [_sequence:protected] => 1
2096 [_metadata:protected] => Array
2097 (
2098 [id] => Array
2099 (
2100 [SCHEMA_NAME] =>
2101 [TABLE_NAME] => mls_master
2102 [COLUMN_NAME] => id
2103 [COLUMN_POSITION] => 1
2104 [DATA_TYPE] => int
2105 [DEFAULT] => 0
2106 [NULLABLE] =>
2107 [LENGTH] =>
2108 [SCALE] =>
2109 [PRECISION] =>
2110 [UNSIGNED] =>
2111 [PRIMARY] =>
2112 [PRIMARY_POSITION] =>
2113 [IDENTITY] =>
2114 )
2115
2116 [mls_id] => Array
2117 (
2118 [SCHEMA_NAME] =>
2119 [TABLE_NAME] => mls_master
2120 [COLUMN_NAME] => mls_id
2121 [COLUMN_POSITION] => 2
2122 [DATA_TYPE] => varchar
2123 [DEFAULT] =>
2124 [NULLABLE] => 1
2125 [LENGTH] => 11
2126 [SCALE] =>
2127 [PRECISION] =>
2128 [UNSIGNED] =>
2129 [PRIMARY] =>
2130 [PRIMARY_POSITION] =>
2131 [IDENTITY] =>
2132 )
2133
2134 [mls_state_id] => Array
2135 (
2136 [SCHEMA_NAME] =>
2137 [TABLE_NAME] => mls_master
2138 [COLUMN_NAME] => mls_state_id
2139 [COLUMN_POSITION] => 3
2140 [DATA_TYPE] => varchar
2141 [DEFAULT] =>
2142 [NULLABLE] => 1
2143 [LENGTH] => 3
2144 [SCALE] =>
2145 [PRECISION] =>
2146 [UNSIGNED] =>
2147 [PRIMARY] =>
2148 [PRIMARY_POSITION] =>
2149 [IDENTITY] =>
2150 )
2151
2152 [mls_listing_id] => Array
2153 (
2154 [SCHEMA_NAME] =>
2155 [TABLE_NAME] => mls_master
2156 [COLUMN_NAME] => mls_listing_id
2157 [COLUMN_POSITION] => 4
2158 [DATA_TYPE] => varchar
2159 [DEFAULT] =>
2160 [NULLABLE] => 1
2161 [LENGTH] => 15
2162 [SCALE] =>
2163 [PRECISION] =>
2164 [UNSIGNED] =>
2165 [PRIMARY] =>
2166 [PRIMARY_POSITION] =>
2167 [IDENTITY] =>
2168 )
2169
2170 [tln_firm_id] => Array
2171 (
2172 [SCHEMA_NAME] =>
2173 [TABLE_NAME] => mls_master
2174 [COLUMN_NAME] => tln_firm_id
2175 [COLUMN_POSITION] => 5
2176 [DATA_TYPE] => int
2177 [DEFAULT] =>
2178 [NULLABLE] => 1
2179 [LENGTH] =>
2180 [SCALE] =>
2181 [PRECISION] =>
2182 [UNSIGNED] =>
2183 [PRIMARY] =>
2184 [PRIMARY_POSITION] =>
2185 [IDENTITY] =>
2186 )
2187
2188 [mls_office_name] => Array
2189 (
2190 [SCHEMA_NAME] =>
2191 [TABLE_NAME] => mls_master
2192 [COLUMN_NAME] => mls_office_name
2193 [COLUMN_POSITION] => 6
2194 [DATA_TYPE] => varchar
2195 [DEFAULT] =>
2196 [NULLABLE] => 1
2197 [LENGTH] => 120
2198 [SCALE] =>
2199 [PRECISION] =>
2200 [UNSIGNED] =>
2201 [PRIMARY] =>
2202 [PRIMARY_POSITION] =>
2203 [IDENTITY] =>
2204 )
2205
2206 [mls_office_phone] => Array
2207 (
2208 [SCHEMA_NAME] =>
2209 [TABLE_NAME] => mls_master
2210 [COLUMN_NAME] => mls_office_phone
2211 [COLUMN_POSITION] => 7
2212 [DATA_TYPE] => varchar
2213 [DEFAULT] =>
2214 [NULLABLE] => 1
2215 [LENGTH] => 15
2216 [SCALE] =>
2217 [PRECISION] =>
2218 [UNSIGNED] =>
2219 [PRIMARY] =>
2220 [PRIMARY_POSITION] =>
2221 [IDENTITY] =>
2222 )
2223
2224 [tln_realtor_id] => Array
2225 (
2226 [SCHEMA_NAME] =>
2227 [TABLE_NAME] => mls_master
2228 [COLUMN_NAME] => tln_realtor_id
2229 [COLUMN_POSITION] => 8
2230 [DATA_TYPE] => int
2231 [DEFAULT] =>
2232 [NULLABLE] => 1
2233 [LENGTH] =>
2234 [SCALE] =>
2235 [PRECISION] =>
2236 [UNSIGNED] =>
2237 [PRIMARY] =>
2238 [PRIMARY_POSITION] =>
2239 [IDENTITY] =>
2240 )
2241
2242 [mls_agent_name] => Array
2243 (
2244 [SCHEMA_NAME] =>
2245 [TABLE_NAME] => mls_master
2246 [COLUMN_NAME] => mls_agent_name
2247 [COLUMN_POSITION] => 9
2248 [DATA_TYPE] => varchar
2249 [DEFAULT] =>
2250 [NULLABLE] => 1
2251 [LENGTH] => 50
2252 [SCALE] =>
2253 [PRECISION] =>
2254 [UNSIGNED] =>
2255 [PRIMARY] =>
2256 [PRIMARY_POSITION] =>
2257 [IDENTITY] =>
2258 )
2259
2260 [mls_agent_phone] => Array
2261 (
2262 [SCHEMA_NAME] =>
2263 [TABLE_NAME] => mls_master
2264 [COLUMN_NAME] => mls_agent_phone
2265 [COLUMN_POSITION] => 10
2266 [DATA_TYPE] => varchar
2267 [DEFAULT] =>
2268 [NULLABLE] => 1
2269 [LENGTH] => 15
2270 [SCALE] =>
2271 [PRECISION] =>
2272 [UNSIGNED] =>
2273 [PRIMARY] =>
2274 [PRIMARY_POSITION] =>
2275 [IDENTITY] =>
2276 )
2277
2278 [listing_date] => Array
2279 (
2280 [SCHEMA_NAME] =>
2281 [TABLE_NAME] => mls_master
2282 [COLUMN_NAME] => listing_date
2283 [COLUMN_POSITION] => 11
2284 [DATA_TYPE] => int
2285 [DEFAULT] =>
2286 [NULLABLE] => 1
2287 [LENGTH] =>
2288 [SCALE] =>
2289 [PRECISION] =>
2290 [UNSIGNED] =>
2291 [PRIMARY] =>
2292 [PRIMARY_POSITION] =>
2293 [IDENTITY] =>
2294 )
2295
2296 [listing_expiration_date] => Array
2297 (
2298 [SCHEMA_NAME] =>
2299 [TABLE_NAME] => mls_master
2300 [COLUMN_NAME] => listing_expiration_date
2301 [COLUMN_POSITION] => 12
2302 [DATA_TYPE] => int
2303 [DEFAULT] =>
2304 [NULLABLE] => 1
2305 [LENGTH] =>
2306 [SCALE] =>
2307 [PRECISION] =>
2308 [UNSIGNED] =>
2309 [PRIMARY] =>
2310 [PRIMARY_POSITION] =>
2311 [IDENTITY] =>
2312 )
2313
2314 [sold_date] => Array
2315 (
2316 [SCHEMA_NAME] =>
2317 [TABLE_NAME] => mls_master
2318 [COLUMN_NAME] => sold_date
2319 [COLUMN_POSITION] => 13
2320 [DATA_TYPE] => int
2321 [DEFAULT] =>
2322 [NULLABLE] => 1
2323 [LENGTH] =>
2324 [SCALE] =>
2325 [PRECISION] =>
2326 [UNSIGNED] =>
2327 [PRIMARY] =>
2328 [PRIMARY_POSITION] =>
2329 [IDENTITY] =>
2330 )
2331
2332 [available_date] => Array
2333 (
2334 [SCHEMA_NAME] =>
2335 [TABLE_NAME] => mls_master
2336 [COLUMN_NAME] => available_date
2337 [COLUMN_POSITION] => 14
2338 [DATA_TYPE] => int
2339 [DEFAULT] =>
2340 [NULLABLE] => 1
2341 [LENGTH] =>
2342 [SCALE] =>
2343 [PRECISION] =>
2344 [UNSIGNED] =>
2345 [PRIMARY] =>
2346 [PRIMARY_POSITION] =>
2347 [IDENTITY] =>
2348 )
2349
2350 [property_type_code] => Array
2351 (
2352 [SCHEMA_NAME] =>
2353 [TABLE_NAME] => mls_master
2354 [COLUMN_NAME] => property_type_code
2355 [COLUMN_POSITION] => 15
2356 [DATA_TYPE] => varchar
2357 [DEFAULT] =>
2358 [NULLABLE] => 1
2359 [LENGTH] => 10
2360 [SCALE] =>
2361 [PRECISION] =>
2362 [UNSIGNED] =>
2363 [PRIMARY] =>
2364 [PRIMARY_POSITION] =>
2365 [IDENTITY] =>
2366 )
2367
2368 [prop_type_description] => Array
2369 (
2370 [SCHEMA_NAME] =>
2371 [TABLE_NAME] => mls_master
2372 [COLUMN_NAME] => prop_type_description
2373 [COLUMN_POSITION] => 16
2374 [DATA_TYPE] => varchar
2375 [DEFAULT] =>
2376 [NULLABLE] => 1
2377 [LENGTH] => 50
2378 [SCALE] =>
2379 [PRECISION] =>
2380 [UNSIGNED] =>
2381 [PRIMARY] =>
2382 [PRIMARY_POSITION] =>
2383 [IDENTITY] =>
2384 )
2385
2386 [remarks] => Array
2387 (
2388 [SCHEMA_NAME] =>
2389 [TABLE_NAME] => mls_master
2390 [COLUMN_NAME] => remarks
2391 [COLUMN_POSITION] => 17
2392 [DATA_TYPE] => text
2393 [DEFAULT] =>
2394 [NULLABLE] => 1
2395 [LENGTH] =>
2396 [SCALE] =>
2397 [PRECISION] =>
2398 [UNSIGNED] =>
2399 [PRIMARY] =>
2400 [PRIMARY_POSITION] =>
2401 [IDENTITY] =>
2402 )
2403
2404 [status_code] => Array
2405 (
2406 [SCHEMA_NAME] =>
2407 [TABLE_NAME] => mls_master
2408 [COLUMN_NAME] => status_code
2409 [COLUMN_POSITION] => 18
2410 [DATA_TYPE] => varchar
2411 [DEFAULT] =>
2412 [NULLABLE] => 1
2413 [LENGTH] => 10
2414 [SCALE] =>
2415 [PRECISION] =>
2416 [UNSIGNED] =>
2417 [PRIMARY] =>
2418 [PRIMARY_POSITION] =>
2419 [IDENTITY] =>
2420 )
2421
2422 [sale_price] => Array
2423 (
2424 [SCHEMA_NAME] =>
2425 [TABLE_NAME] => mls_master
2426 [COLUMN_NAME] => sale_price
2427 [COLUMN_POSITION] => 19
2428 [DATA_TYPE] => int
2429 [DEFAULT] =>
2430 [NULLABLE] => 1
2431 [LENGTH] =>
2432 [SCALE] =>
2433 [PRECISION] =>
2434 [UNSIGNED] =>
2435 [PRIMARY] =>
2436 [PRIMARY_POSITION] =>
2437 [IDENTITY] =>
2438 )
2439
2440 [sold_price] => Array
2441 (
2442 [SCHEMA_NAME] =>
2443 [TABLE_NAME] => mls_master
2444 [COLUMN_NAME] => sold_price
2445 [COLUMN_POSITION] => 20
2446 [DATA_TYPE] => int
2447 [DEFAULT] =>
2448 [NULLABLE] => 1
2449 [LENGTH] =>
2450 [SCALE] =>
2451 [PRECISION] =>
2452 [UNSIGNED] =>
2453 [PRIMARY] =>
2454 [PRIMARY_POSITION] =>
2455 [IDENTITY] =>
2456 )
2457
2458 [property_state_id] => Array
2459 (
2460 [SCHEMA_NAME] =>
2461 [TABLE_NAME] => mls_master
2462 [COLUMN_NAME] => property_state_id
2463 [COLUMN_POSITION] => 21
2464 [DATA_TYPE] => varchar
2465 [DEFAULT] =>
2466 [NULLABLE] => 1
2467 [LENGTH] => 3
2468 [SCALE] =>
2469 [PRECISION] =>
2470 [UNSIGNED] =>
2471 [PRIMARY] =>
2472 [PRIMARY_POSITION] =>
2473 [IDENTITY] =>
2474 )
2475
2476 [street_number] => Array
2477 (
2478 [SCHEMA_NAME] =>
2479 [TABLE_NAME] => mls_master
2480 [COLUMN_NAME] => street_number
2481 [COLUMN_POSITION] => 22
2482 [DATA_TYPE] => int
2483 [DEFAULT] =>
2484 [NULLABLE] => 1
2485 [LENGTH] =>
2486 [SCALE] =>
2487 [PRECISION] =>
2488 [UNSIGNED] =>
2489 [PRIMARY] =>
2490 [PRIMARY_POSITION] =>
2491 [IDENTITY] =>
2492 )
2493
2494 [street_name] => Array
2495 (
2496 [SCHEMA_NAME] =>
2497 [TABLE_NAME] => mls_master
2498 [COLUMN_NAME] => street_name
2499 [COLUMN_POSITION] => 23
2500 [DATA_TYPE] => varchar
2501 [DEFAULT] =>
2502 [NULLABLE] => 1
2503 [LENGTH] => 30
2504 [SCALE] =>
2505 [PRECISION] =>
2506 [UNSIGNED] =>
2507 [PRIMARY] =>
2508 [PRIMARY_POSITION] =>
2509 [IDENTITY] =>
2510 )
2511
2512 [street_type] => Array
2513 (
2514 [SCHEMA_NAME] =>
2515 [TABLE_NAME] => mls_master
2516 [COLUMN_NAME] => street_type
2517 [COLUMN_POSITION] => 24
2518 [DATA_TYPE] => varchar
2519 [DEFAULT] =>
2520 [NULLABLE] => 1
2521 [LENGTH] => 10
2522 [SCALE] =>
2523 [PRECISION] =>
2524 [UNSIGNED] =>
2525 [PRIMARY] =>
2526 [PRIMARY_POSITION] =>
2527 [IDENTITY] =>
2528 )
2529
2530 [street_direction] => Array
2531 (
2532 [SCHEMA_NAME] =>
2533 [TABLE_NAME] => mls_master
2534 [COLUMN_NAME] => street_direction
2535 [COLUMN_POSITION] => 25
2536 [DATA_TYPE] => varchar
2537 [DEFAULT] =>
2538 [NULLABLE] => 1
2539 [LENGTH] => 2
2540 [SCALE] =>
2541 [PRECISION] =>
2542 [UNSIGNED] =>
2543 [PRIMARY] =>
2544 [PRIMARY_POSITION] =>
2545 [IDENTITY] =>
2546 )
2547
2548 [unit_number] => Array
2549 (
2550 [SCHEMA_NAME] =>
2551 [TABLE_NAME] => mls_master
2552 [COLUMN_NAME] => unit_number
2553 [COLUMN_POSITION] => 26
2554 [DATA_TYPE] => varchar
2555 [DEFAULT] =>
2556 [NULLABLE] => 1
2557 [LENGTH] => 10
2558 [SCALE] =>
2559 [PRECISION] =>
2560 [UNSIGNED] =>
2561 [PRIMARY] =>
2562 [PRIMARY_POSITION] =>
2563 [IDENTITY] =>
2564 )
2565
2566 [longitude] => Array
2567 (
2568 [SCHEMA_NAME] =>
2569 [TABLE_NAME] => mls_master
2570 [COLUMN_NAME] => longitude
2571 [COLUMN_POSITION] => 27
2572 [DATA_TYPE] => float
2573 [DEFAULT] =>
2574 [NULLABLE] => 1
2575 [LENGTH] =>
2576 [SCALE] =>
2577 [PRECISION] =>
2578 [UNSIGNED] =>
2579 [PRIMARY] =>
2580 [PRIMARY_POSITION] =>
2581 [IDENTITY] =>
2582 )
2583
2584 [latitude] => Array
2585 (
2586 [SCHEMA_NAME] =>
2587 [TABLE_NAME] => mls_master
2588 [COLUMN_NAME] => latitude
2589 [COLUMN_POSITION] => 28
2590 [DATA_TYPE] => float
2591 [DEFAULT] =>
2592 [NULLABLE] => 1
2593 [LENGTH] =>
2594 [SCALE] =>
2595 [PRECISION] =>
2596 [UNSIGNED] =>
2597 [PRIMARY] =>
2598 [PRIMARY_POSITION] =>
2599 [IDENTITY] =>
2600 )
2601
2602 [city] => Array
2603 (
2604 [SCHEMA_NAME] =>
2605 [TABLE_NAME] => mls_master
2606 [COLUMN_NAME] => city
2607 [COLUMN_POSITION] => 29
2608 [DATA_TYPE] => varchar
2609 [DEFAULT] =>
2610 [NULLABLE] => 1
2611 [LENGTH] => 25
2612 [SCALE] =>
2613 [PRECISION] =>
2614 [UNSIGNED] =>
2615 [PRIMARY] =>
2616 [PRIMARY_POSITION] =>
2617 [IDENTITY] =>
2618 )
2619
2620 [city_id] => Array
2621 (
2622 [SCHEMA_NAME] =>
2623 [TABLE_NAME] => mls_master
2624 [COLUMN_NAME] => city_id
2625 [COLUMN_POSITION] => 30
2626 [DATA_TYPE] => varchar
2627 [DEFAULT] =>
2628 [NULLABLE] => 1
2629 [LENGTH] => 10
2630 [SCALE] =>
2631 [PRECISION] =>
2632 [UNSIGNED] =>
2633 [PRIMARY] =>
2634 [PRIMARY_POSITION] =>
2635 [IDENTITY] =>
2636 )
2637
2638 [zip_code] => Array
2639 (
2640 [SCHEMA_NAME] =>
2641 [TABLE_NAME] => mls_master
2642 [COLUMN_NAME] => zip_code
2643 [COLUMN_POSITION] => 31
2644 [DATA_TYPE] => int
2645 [DEFAULT] =>
2646 [NULLABLE] => 1
2647 [LENGTH] =>
2648 [SCALE] =>
2649 [PRECISION] =>
2650 [UNSIGNED] =>
2651 [PRIMARY] =>
2652 [PRIMARY_POSITION] =>
2653 [IDENTITY] =>
2654 )
2655
2656 [zip_plus4] => Array
2657 (
2658 [SCHEMA_NAME] =>
2659 [TABLE_NAME] => mls_master
2660 [COLUMN_NAME] => zip_plus4
2661 [COLUMN_POSITION] => 32
2662 [DATA_TYPE] => int
2663 [DEFAULT] =>
2664 [NULLABLE] => 1
2665 [LENGTH] =>
2666 [SCALE] =>
2667 [PRECISION] =>
2668 [UNSIGNED] =>
2669 [PRIMARY] =>
2670 [PRIMARY_POSITION] =>
2671 [IDENTITY] =>
2672 )
2673
2674 [mls_area] => Array
2675 (
2676 [SCHEMA_NAME] =>
2677 [TABLE_NAME] => mls_master
2678 [COLUMN_NAME] => mls_area
2679 [COLUMN_POSITION] => 33
2680 [DATA_TYPE] => varchar
2681 [DEFAULT] =>
2682 [NULLABLE] => 1
2683 [LENGTH] => 25
2684 [SCALE] =>
2685 [PRECISION] =>
2686 [UNSIGNED] =>
2687 [PRIMARY] =>
2688 [PRIMARY_POSITION] =>
2689 [IDENTITY] =>
2690 )
2691
2692 [county] => Array
2693 (
2694 [SCHEMA_NAME] =>
2695 [TABLE_NAME] => mls_master
2696 [COLUMN_NAME] => county
2697 [COLUMN_POSITION] => 34
2698 [DATA_TYPE] => varchar
2699 [DEFAULT] =>
2700 [NULLABLE] => 1
2701 [LENGTH] => 25
2702 [SCALE] =>
2703 [PRECISION] =>
2704 [UNSIGNED] =>
2705 [PRIMARY] =>
2706 [PRIMARY_POSITION] =>
2707 [IDENTITY] =>
2708 )
2709
2710 [fips_county_code] => Array
2711 (
2712 [SCHEMA_NAME] =>
2713 [TABLE_NAME] => mls_master
2714 [COLUMN_NAME] => fips_county_code
2715 [COLUMN_POSITION] => 35
2716 [DATA_TYPE] => int
2717 [DEFAULT] =>
2718 [NULLABLE] => 1
2719 [LENGTH] =>
2720 [SCALE] =>
2721 [PRECISION] =>
2722 [UNSIGNED] =>
2723 [PRIMARY] =>
2724 [PRIMARY_POSITION] =>
2725 [IDENTITY] =>
2726 )
2727
2728 [subdivision] => Array
2729 (
2730 [SCHEMA_NAME] =>
2731 [TABLE_NAME] => mls_master
2732 [COLUMN_NAME] => subdivision
2733 [COLUMN_POSITION] => 36
2734 [DATA_TYPE] => varchar
2735 [DEFAULT] =>
2736 [NULLABLE] => 1
2737 [LENGTH] => 30
2738 [SCALE] =>
2739 [PRECISION] =>
2740 [UNSIGNED] =>
2741 [PRIMARY] =>
2742 [PRIMARY_POSITION] =>
2743 [IDENTITY] =>
2744 )
2745
2746 [community_name] => Array
2747 (
2748 [SCHEMA_NAME] =>
2749 [TABLE_NAME] => mls_master
2750 [COLUMN_NAME] => community_name
2751 [COLUMN_POSITION] => 37
2752 [DATA_TYPE] => varchar
2753 [DEFAULT] =>
2754 [NULLABLE] => 1
2755 [LENGTH] => 30
2756 [SCALE] =>
2757 [PRECISION] =>
2758 [UNSIGNED] =>
2759 [PRIMARY] =>
2760 [PRIMARY_POSITION] =>
2761 [IDENTITY] =>
2762 )
2763
2764 [year_built] => Array
2765 (
2766 [SCHEMA_NAME] =>
2767 [TABLE_NAME] => mls_master
2768 [COLUMN_NAME] => year_built
2769 [COLUMN_POSITION] => 38
2770 [DATA_TYPE] => int
2771 [DEFAULT] =>
2772 [NULLABLE] => 1
2773 [LENGTH] =>
2774 [SCALE] =>
2775 [PRECISION] =>
2776 [UNSIGNED] =>
2777 [PRIMARY] =>
2778 [PRIMARY_POSITION] =>
2779 [IDENTITY] =>
2780 )
2781
2782 [acres] => Array
2783 (
2784 [SCHEMA_NAME] =>
2785 [TABLE_NAME] => mls_master
2786 [COLUMN_NAME] => acres
2787 [COLUMN_POSITION] => 39
2788 [DATA_TYPE] => decimal
2789 [DEFAULT] =>
2790 [NULLABLE] => 1
2791 [LENGTH] =>
2792 [SCALE] => 2
2793 [PRECISION] => 8
2794 [UNSIGNED] =>
2795 [PRIMARY] =>
2796 [PRIMARY_POSITION] =>
2797 [IDENTITY] =>
2798 )
2799
2800 [lot_dimensions] => Array
2801 (
2802 [SCHEMA_NAME] =>
2803 [TABLE_NAME] => mls_master
2804 [COLUMN_NAME] => lot_dimensions
2805 [COLUMN_POSITION] => 40
2806 [DATA_TYPE] => varchar
2807 [DEFAULT] =>
2808 [NULLABLE] => 1
2809 [LENGTH] => 30
2810 [SCALE] =>
2811 [PRECISION] =>
2812 [UNSIGNED] =>
2813 [PRIMARY] =>
2814 [PRIMARY_POSITION] =>
2815 [IDENTITY] =>
2816 )
2817
2818 [lot_square_footage] => Array
2819 (
2820 [SCHEMA_NAME] =>
2821 [TABLE_NAME] => mls_master
2822 [COLUMN_NAME] => lot_square_footage
2823 [COLUMN_POSITION] => 41
2824 [DATA_TYPE] => int
2825 [DEFAULT] =>
2826 [NULLABLE] => 1
2827 [LENGTH] =>
2828 [SCALE] =>
2829 [PRECISION] =>
2830 [UNSIGNED] =>
2831 [PRIMARY] =>
2832 [PRIMARY_POSITION] =>
2833 [IDENTITY] =>
2834 )
2835
2836 [lot_square_footage_land] => Array
2837 (
2838 [SCHEMA_NAME] =>
2839 [TABLE_NAME] => mls_master
2840 [COLUMN_NAME] => lot_square_footage_land
2841 [COLUMN_POSITION] => 42
2842 [DATA_TYPE] => int
2843 [DEFAULT] =>
2844 [NULLABLE] => 1
2845 [LENGTH] =>
2846 [SCALE] =>
2847 [PRECISION] =>
2848 [UNSIGNED] =>
2849 [PRIMARY] =>
2850 [PRIMARY_POSITION] =>
2851 [IDENTITY] =>
2852 )
2853
2854 [building_square_footage] => Array
2855 (
2856 [SCHEMA_NAME] =>
2857 [TABLE_NAME] => mls_master
2858 [COLUMN_NAME] => building_square_footage
2859 [COLUMN_POSITION] => 43
2860 [DATA_TYPE] => int
2861 [DEFAULT] =>
2862 [NULLABLE] => 1
2863 [LENGTH] =>
2864 [SCALE] =>
2865 [PRECISION] =>
2866 [UNSIGNED] =>
2867 [PRIMARY] =>
2868 [PRIMARY_POSITION] =>
2869 [IDENTITY] =>
2870 )
2871
2872 [bedrooms] => Array
2873 (
2874 [SCHEMA_NAME] =>
2875 [TABLE_NAME] => mls_master
2876 [COLUMN_NAME] => bedrooms
2877 [COLUMN_POSITION] => 44
2878 [DATA_TYPE] => int
2879 [DEFAULT] =>
2880 [NULLABLE] => 1
2881 [LENGTH] =>
2882 [SCALE] =>
2883 [PRECISION] =>
2884 [UNSIGNED] =>
2885 [PRIMARY] =>
2886 [PRIMARY_POSITION] =>
2887 [IDENTITY] =>
2888 )
2889
2890 [baths_total] => Array
2891 (
2892 [SCHEMA_NAME] =>
2893 [TABLE_NAME] => mls_master
2894 [COLUMN_NAME] => baths_total
2895 [COLUMN_POSITION] => 45
2896 [DATA_TYPE] => decimal
2897 [DEFAULT] =>
2898 [NULLABLE] => 1
2899 [LENGTH] =>
2900 [SCALE] => 2
2901 [PRECISION] => 5
2902 [UNSIGNED] =>
2903 [PRIMARY] =>
2904 [PRIMARY_POSITION] =>
2905 [IDENTITY] =>
2906 )
2907
2908 [baths_full] => Array
2909 (
2910 [SCHEMA_NAME] =>
2911 [TABLE_NAME] => mls_master
2912 [COLUMN_NAME] => baths_full
2913 [COLUMN_POSITION] => 46
2914 [DATA_TYPE] => int
2915 [DEFAULT] =>
2916 [NULLABLE] => 1
2917 [LENGTH] =>
2918 [SCALE] =>
2919 [PRECISION] =>
2920 [UNSIGNED] =>
2921 [PRIMARY] =>
2922 [PRIMARY_POSITION] =>
2923 [IDENTITY] =>
2924 )
2925
2926 [baths_half] => Array
2927 (
2928 [SCHEMA_NAME] =>
2929 [TABLE_NAME] => mls_master
2930 [COLUMN_NAME] => baths_half
2931 [COLUMN_POSITION] => 47
2932 [DATA_TYPE] => int
2933 [DEFAULT] =>
2934 [NULLABLE] => 1
2935 [LENGTH] =>
2936 [SCALE] =>
2937 [PRECISION] =>
2938 [UNSIGNED] =>
2939 [PRIMARY] =>
2940 [PRIMARY_POSITION] =>
2941 [IDENTITY] =>
2942 )
2943
2944 [baths_three_quarter] => Array
2945 (
2946 [SCHEMA_NAME] =>
2947 [TABLE_NAME] => mls_master
2948 [COLUMN_NAME] => baths_three_quarter
2949 [COLUMN_POSITION] => 48
2950 [DATA_TYPE] => int
2951 [DEFAULT] =>
2952 [NULLABLE] => 1
2953 [LENGTH] =>
2954 [SCALE] =>
2955 [PRECISION] =>
2956 [UNSIGNED] =>
2957 [PRIMARY] =>
2958 [PRIMARY_POSITION] =>
2959 [IDENTITY] =>
2960 )
2961
2962 [fireplace_number] => Array
2963 (
2964 [SCHEMA_NAME] =>
2965 [TABLE_NAME] => mls_master
2966 [COLUMN_NAME] => fireplace_number
2967 [COLUMN_POSITION] => 49
2968 [DATA_TYPE] => int
2969 [DEFAULT] =>
2970 [NULLABLE] => 1
2971 [LENGTH] =>
2972 [SCALE] =>
2973 [PRECISION] =>
2974 [UNSIGNED] =>
2975 [PRIMARY] =>
2976 [PRIMARY_POSITION] =>
2977 [IDENTITY] =>
2978 )
2979
2980 [total_rooms] => Array
2981 (
2982 [SCHEMA_NAME] =>
2983 [TABLE_NAME] => mls_master
2984 [COLUMN_NAME] => total_rooms
2985 [COLUMN_POSITION] => 50
2986 [DATA_TYPE] => int
2987 [DEFAULT] =>
2988 [NULLABLE] => 1
2989 [LENGTH] =>
2990 [SCALE] =>
2991 [PRECISION] =>
2992 [UNSIGNED] =>
2993 [PRIMARY] =>
2994 [PRIMARY_POSITION] =>
2995 [IDENTITY] =>
2996 )
2997
2998 [school_district] => Array
2999 (
3000 [SCHEMA_NAME] =>
3001 [TABLE_NAME] => mls_master
3002 [COLUMN_NAME] => school_district
3003 [COLUMN_POSITION] => 51
3004 [DATA_TYPE] => varchar
3005 [DEFAULT] =>
3006 [NULLABLE] => 1
3007 [LENGTH] => 30
3008 [SCALE] =>
3009 [PRECISION] =>
3010 [UNSIGNED] =>
3011 [PRIMARY] =>
3012 [PRIMARY_POSITION] =>
3013 [IDENTITY] =>
3014 )
3015
3016 [school_elementary] => Array
3017 (
3018 [SCHEMA_NAME] =>
3019 [TABLE_NAME] => mls_master
3020 [COLUMN_NAME] => school_elementary
3021 [COLUMN_POSITION] => 52
3022 [DATA_TYPE] => varchar
3023 [DEFAULT] =>
3024 [NULLABLE] => 1
3025 [LENGTH] => 30
3026 [SCALE] =>
3027 [PRECISION] =>
3028 [UNSIGNED] =>
3029 [PRIMARY] =>
3030 [PRIMARY_POSITION] =>
3031 [IDENTITY] =>
3032 )
3033
3034 [school_middle] => Array
3035 (
3036 [SCHEMA_NAME] =>
3037 [TABLE_NAME] => mls_master
3038 [COLUMN_NAME] => school_middle
3039 [COLUMN_POSITION] => 53
3040 [DATA_TYPE] => varchar
3041 [DEFAULT] =>
3042 [NULLABLE] => 1
3043 [LENGTH] => 30
3044 [SCALE] =>
3045 [PRECISION] =>
3046 [UNSIGNED] =>
3047 [PRIMARY] =>
3048 [PRIMARY_POSITION] =>
3049 [IDENTITY] =>
3050 )
3051
3052 [school_junior_high] => Array
3053 (
3054 [SCHEMA_NAME] =>
3055 [TABLE_NAME] => mls_master
3056 [COLUMN_NAME] => school_junior_high
3057 [COLUMN_POSITION] => 54
3058 [DATA_TYPE] => varchar
3059 [DEFAULT] =>
3060 [NULLABLE] => 1
3061 [LENGTH] => 30
3062 [SCALE] =>
3063 [PRECISION] =>
3064 [UNSIGNED] =>
3065 [PRIMARY] =>
3066 [PRIMARY_POSITION] =>
3067 [IDENTITY] =>
3068 )
3069
3070 [school_high] => Array
3071 (
3072 [SCHEMA_NAME] =>
3073 [TABLE_NAME] => mls_master
3074 [COLUMN_NAME] => school_high
3075 [COLUMN_POSITION] => 55
3076 [DATA_TYPE] => varchar
3077 [DEFAULT] =>
3078 [NULLABLE] => 1
3079 [LENGTH] => 30
3080 [SCALE] =>
3081 [PRECISION] =>
3082 [UNSIGNED] =>
3083 [PRIMARY] =>
3084 [PRIMARY_POSITION] =>
3085 [IDENTITY] =>
3086 )
3087
3088 [total_units] => Array
3089 (
3090 [SCHEMA_NAME] =>
3091 [TABLE_NAME] => mls_master
3092 [COLUMN_NAME] => total_units
3093 [COLUMN_POSITION] => 56
3094 [DATA_TYPE] => int
3095 [DEFAULT] =>
3096 [NULLABLE] => 1
3097 [LENGTH] =>
3098 [SCALE] =>
3099 [PRECISION] =>
3100 [UNSIGNED] =>
3101 [PRIMARY] =>
3102 [PRIMARY_POSITION] =>
3103 [IDENTITY] =>
3104 )
3105
3106 [total_buildings] => Array
3107 (
3108 [SCHEMA_NAME] =>
3109 [TABLE_NAME] => mls_master
3110 [COLUMN_NAME] => total_buildings
3111 [COLUMN_POSITION] => 57
3112 [DATA_TYPE] => int
3113 [DEFAULT] =>
3114 [NULLABLE] => 1
3115 [LENGTH] =>
3116 [SCALE] =>
3117 [PRECISION] =>
3118 [UNSIGNED] =>
3119 [PRIMARY] =>
3120 [PRIMARY_POSITION] =>
3121 [IDENTITY] =>
3122 )
3123
3124 [total_lots] => Array
3125 (
3126 [SCHEMA_NAME] =>
3127 [TABLE_NAME] => mls_master
3128 [COLUMN_NAME] => total_lots
3129 [COLUMN_POSITION] => 58
3130 [DATA_TYPE] => int
3131 [DEFAULT] =>
3132 [NULLABLE] => 1
3133 [LENGTH] =>
3134 [SCALE] =>
3135 [PRECISION] =>
3136 [UNSIGNED] =>
3137 [PRIMARY] =>
3138 [PRIMARY_POSITION] =>
3139 [IDENTITY] =>
3140 )
3141
3142 [hoa_fees] => Array
3143 (
3144 [SCHEMA_NAME] =>
3145 [TABLE_NAME] => mls_master
3146 [COLUMN_NAME] => hoa_fees
3147 [COLUMN_POSITION] => 59
3148 [DATA_TYPE] => int
3149 [DEFAULT] =>
3150 [NULLABLE] => 1
3151 [LENGTH] =>
3152 [SCALE] =>
3153 [PRECISION] =>
3154 [UNSIGNED] =>
3155 [PRIMARY] =>
3156 [PRIMARY_POSITION] =>
3157 [IDENTITY] =>
3158 )
3159
3160 [owners_name] => Array
3161 (
3162 [SCHEMA_NAME] =>
3163 [TABLE_NAME] => mls_master
3164 [COLUMN_NAME] => owners_name
3165 [COLUMN_POSITION] => 60
3166 [DATA_TYPE] => varchar
3167 [DEFAULT] =>
3168 [NULLABLE] => 1
3169 [LENGTH] => 50
3170 [SCALE] =>
3171 [PRECISION] =>
3172 [UNSIGNED] =>
3173 [PRIMARY] =>
3174 [PRIMARY_POSITION] =>
3175 [IDENTITY] =>
3176 )
3177
3178 [legal] => Array
3179 (
3180 [SCHEMA_NAME] =>
3181 [TABLE_NAME] => mls_master
3182 [COLUMN_NAME] => legal
3183 [COLUMN_POSITION] => 61
3184 [DATA_TYPE] => text
3185 [DEFAULT] =>
3186 [NULLABLE] => 1
3187 [LENGTH] =>
3188 [SCALE] =>
3189 [PRECISION] =>
3190 [UNSIGNED] =>
3191 [PRIMARY] =>
3192 [PRIMARY_POSITION] =>
3193 [IDENTITY] =>
3194 )
3195
3196 [apn] => Array
3197 (
3198 [SCHEMA_NAME] =>
3199 [TABLE_NAME] => mls_master
3200 [COLUMN_NAME] => apn
3201 [COLUMN_POSITION] => 62
3202 [DATA_TYPE] => varchar
3203 [DEFAULT] =>
3204 [NULLABLE] => 1
3205 [LENGTH] => 45
3206 [SCALE] =>
3207 [PRECISION] =>
3208 [UNSIGNED] =>
3209 [PRIMARY] =>
3210 [PRIMARY_POSITION] =>
3211 [IDENTITY] =>
3212 )
3213
3214 [taxes] => Array
3215 (
3216 [SCHEMA_NAME] =>
3217 [TABLE_NAME] => mls_master
3218 [COLUMN_NAME] => taxes
3219 [COLUMN_POSITION] => 63
3220 [DATA_TYPE] => int
3221 [DEFAULT] =>
3222 [NULLABLE] => 1
3223 [LENGTH] =>
3224 [SCALE] =>
3225 [PRECISION] =>
3226 [UNSIGNED] =>
3227 [PRIMARY] =>
3228 [PRIMARY_POSITION] =>
3229 [IDENTITY] =>
3230 )
3231
3232 [tax_year] => Array
3233 (
3234 [SCHEMA_NAME] =>
3235 [TABLE_NAME] => mls_master
3236 [COLUMN_NAME] => tax_year
3237 [COLUMN_POSITION] => 64
3238 [DATA_TYPE] => int
3239 [DEFAULT] =>
3240 [NULLABLE] => 1
3241 [LENGTH] =>
3242 [SCALE] =>
3243 [PRECISION] =>
3244 [UNSIGNED] =>
3245 [PRIMARY] =>
3246 [PRIMARY_POSITION] =>
3247 [IDENTITY] =>
3248 )
3249
3250 [section] => Array
3251 (
3252 [SCHEMA_NAME] =>
3253 [TABLE_NAME] => mls_master
3254 [COLUMN_NAME] => section
3255 [COLUMN_POSITION] => 65
3256 [DATA_TYPE] => varchar
3257 [DEFAULT] =>
3258 [NULLABLE] => 1
3259 [LENGTH] => 10
3260 [SCALE] =>
3261 [PRECISION] =>
3262 [UNSIGNED] =>
3263 [PRIMARY] =>
3264 [PRIMARY_POSITION] =>
3265 [IDENTITY] =>
3266 )
3267
3268 [mls_range] => Array
3269 (
3270 [SCHEMA_NAME] =>
3271 [TABLE_NAME] => mls_master
3272 [COLUMN_NAME] => mls_range
3273 [COLUMN_POSITION] => 66
3274 [DATA_TYPE] => varchar
3275 [DEFAULT] =>
3276 [NULLABLE] => 1
3277 [LENGTH] => 10
3278 [SCALE] =>
3279 [PRECISION] =>
3280 [UNSIGNED] =>
3281 [PRIMARY] =>
3282 [PRIMARY_POSITION] =>
3283 [IDENTITY] =>
3284 )
3285
3286 [township] => Array
3287 (
3288 [SCHEMA_NAME] =>
3289 [TABLE_NAME] => mls_master
3290 [COLUMN_NAME] => township
3291 [COLUMN_POSITION] => 67
3292 [DATA_TYPE] => varchar
3293 [DEFAULT] =>
3294 [NULLABLE] => 1
3295 [LENGTH] => 10
3296 [SCALE] =>
3297 [PRECISION] =>
3298 [UNSIGNED] =>
3299 [PRIMARY] =>
3300 [PRIMARY_POSITION] =>
3301 [IDENTITY] =>
3302 )
3303
3304 [rent_on] => Array
3305 (
3306 [SCHEMA_NAME] =>
3307 [TABLE_NAME] => mls_master
3308 [COLUMN_NAME] => rent_on
3309 [COLUMN_POSITION] => 68
3310 [DATA_TYPE] => int
3311 [DEFAULT] =>
3312 [NULLABLE] => 1
3313 [LENGTH] =>
3314 [SCALE] =>
3315 [PRECISION] =>
3316 [UNSIGNED] =>
3317 [PRIMARY] =>
3318 [PRIMARY_POSITION] =>
3319 [IDENTITY] =>
3320 )
3321
3322 [rent_off] => Array
3323 (
3324 [SCHEMA_NAME] =>
3325 [TABLE_NAME] => mls_master
3326 [COLUMN_NAME] => rent_off
3327 [COLUMN_POSITION] => 69
3328 [DATA_TYPE] => int
3329 [DEFAULT] =>
3330 [NULLABLE] => 1
3331 [LENGTH] =>
3332 [SCALE] =>
3333 [PRECISION] =>
3334 [UNSIGNED] =>
3335 [PRIMARY] =>
3336 [PRIMARY_POSITION] =>
3337 [IDENTITY] =>
3338 )
3339
3340 [photo_ind] => Array
3341 (
3342 [SCHEMA_NAME] =>
3343 [TABLE_NAME] => mls_master
3344 [COLUMN_NAME] => photo_ind
3345 [COLUMN_POSITION] => 70
3346 [DATA_TYPE] => varchar
3347 [DEFAULT] =>
3348 [NULLABLE] => 1
3349 [LENGTH] => 2
3350 [SCALE] =>
3351 [PRECISION] =>
3352 [UNSIGNED] =>
3353 [PRIMARY] =>
3354 [PRIMARY_POSITION] =>
3355 [IDENTITY] =>
3356 )
3357
3358 [last_mls_update_date] => Array
3359 (
3360 [SCHEMA_NAME] =>
3361 [TABLE_NAME] => mls_master
3362 [COLUMN_NAME] => last_mls_update_date
3363 [COLUMN_POSITION] => 71
3364 [DATA_TYPE] => int
3365 [DEFAULT] =>
3366 [NULLABLE] => 1
3367 [LENGTH] =>
3368 [SCALE] =>
3369 [PRECISION] =>
3370 [UNSIGNED] =>
3371 [PRIMARY] =>
3372 [PRIMARY_POSITION] =>
3373 [IDENTITY] =>
3374 )
3375
3376 [master_bed] => Array
3377 (
3378 [SCHEMA_NAME] =>
3379 [TABLE_NAME] => mls_master
3380 [COLUMN_NAME] => master_bed
3381 [COLUMN_POSITION] => 72
3382 [DATA_TYPE] => varchar
3383 [DEFAULT] =>
3384 [NULLABLE] => 1
3385 [LENGTH] => 15
3386 [SCALE] =>
3387 [PRECISION] =>
3388 [UNSIGNED] =>
3389 [PRIMARY] =>
3390 [PRIMARY_POSITION] =>
3391 [IDENTITY] =>
3392 )
3393
3394 [bed2] => Array
3395 (
3396 [SCHEMA_NAME] =>
3397 [TABLE_NAME] => mls_master
3398 [COLUMN_NAME] => bed2
3399 [COLUMN_POSITION] => 73
3400 [DATA_TYPE] => varchar
3401 [DEFAULT] =>
3402 [NULLABLE] => 1
3403 [LENGTH] => 15
3404 [SCALE] =>
3405 [PRECISION] =>
3406 [UNSIGNED] =>
3407 [PRIMARY] =>
3408 [PRIMARY_POSITION] =>
3409 [IDENTITY] =>
3410 )
3411
3412 [bed3] => Array
3413 (
3414 [SCHEMA_NAME] =>
3415 [TABLE_NAME] => mls_master
3416 [COLUMN_NAME] => bed3
3417 [COLUMN_POSITION] => 74
3418 [DATA_TYPE] => varchar
3419 [DEFAULT] =>
3420 [NULLABLE] => 1
3421 [LENGTH] => 15
3422 [SCALE] =>
3423 [PRECISION] =>
3424 [UNSIGNED] =>
3425 [PRIMARY] =>
3426 [PRIMARY_POSITION] =>
3427 [IDENTITY] =>
3428 )
3429
3430 [bed4] => Array
3431 (
3432 [SCHEMA_NAME] =>
3433 [TABLE_NAME] => mls_master
3434 [COLUMN_NAME] => bed4
3435 [COLUMN_POSITION] => 75
3436 [DATA_TYPE] => varchar
3437 [DEFAULT] =>
3438 [NULLABLE] => 1
3439 [LENGTH] => 15
3440 [SCALE] =>
3441 [PRECISION] =>
3442 [UNSIGNED] =>
3443 [PRIMARY] =>
3444 [PRIMARY_POSITION] =>
3445 [IDENTITY] =>
3446 )
3447
3448 [bed5] => Array
3449 (
3450 [SCHEMA_NAME] =>
3451 [TABLE_NAME] => mls_master
3452 [COLUMN_NAME] => bed5
3453 [COLUMN_POSITION] => 76
3454 [DATA_TYPE] => varchar
3455 [DEFAULT] =>
3456 [NULLABLE] => 1
3457 [LENGTH] => 15
3458 [SCALE] =>
3459 [PRECISION] =>
3460 [UNSIGNED] =>
3461 [PRIMARY] =>
3462 [PRIMARY_POSITION] =>
3463 [IDENTITY] =>
3464 )
3465
3466 [kitchen] => Array
3467 (
3468 [SCHEMA_NAME] =>
3469 [TABLE_NAME] => mls_master
3470 [COLUMN_NAME] => kitchen
3471 [COLUMN_POSITION] => 77
3472 [DATA_TYPE] => varchar
3473 [DEFAULT] =>
3474 [NULLABLE] => 1
3475 [LENGTH] => 15
3476 [SCALE] =>
3477 [PRECISION] =>
3478 [UNSIGNED] =>
3479 [PRIMARY] =>
3480 [PRIMARY_POSITION] =>
3481 [IDENTITY] =>
3482 )
3483
3484 [breakfast] => Array
3485 (
3486 [SCHEMA_NAME] =>
3487 [TABLE_NAME] => mls_master
3488 [COLUMN_NAME] => breakfast
3489 [COLUMN_POSITION] => 78
3490 [DATA_TYPE] => varchar
3491 [DEFAULT] =>
3492 [NULLABLE] => 1
3493 [LENGTH] => 15
3494 [SCALE] =>
3495 [PRECISION] =>
3496 [UNSIGNED] =>
3497 [PRIMARY] =>
3498 [PRIMARY_POSITION] =>
3499 [IDENTITY] =>
3500 )
3501
3502 [laundry] => Array
3503 (
3504 [SCHEMA_NAME] =>
3505 [TABLE_NAME] => mls_master
3506 [COLUMN_NAME] => laundry
3507 [COLUMN_POSITION] => 79
3508 [DATA_TYPE] => varchar
3509 [DEFAULT] =>
3510 [NULLABLE] => 1
3511 [LENGTH] => 15
3512 [SCALE] =>
3513 [PRECISION] =>
3514 [UNSIGNED] =>
3515 [PRIMARY] =>
3516 [PRIMARY_POSITION] =>
3517 [IDENTITY] =>
3518 )
3519
3520 [den] => Array
3521 (
3522 [SCHEMA_NAME] =>
3523 [TABLE_NAME] => mls_master
3524 [COLUMN_NAME] => den
3525 [COLUMN_POSITION] => 80
3526 [DATA_TYPE] => varchar
3527 [DEFAULT] =>
3528 [NULLABLE] => 1
3529 [LENGTH] => 15
3530 [SCALE] =>
3531 [PRECISION] =>
3532 [UNSIGNED] =>
3533 [PRIMARY] =>
3534 [PRIMARY_POSITION] =>
3535 [IDENTITY] =>
3536 )
3537
3538 [dining] => Array
3539 (
3540 [SCHEMA_NAME] =>
3541 [TABLE_NAME] => mls_master
3542 [COLUMN_NAME] => dining
3543 [COLUMN_POSITION] => 81
3544 [DATA_TYPE] => varchar
3545 [DEFAULT] =>
3546 [NULLABLE] => 1
3547 [LENGTH] => 15
3548 [SCALE] =>
3549 [PRECISION] =>
3550 [UNSIGNED] =>
3551 [PRIMARY] =>
3552 [PRIMARY_POSITION] =>
3553 [IDENTITY] =>
3554 )
3555
3556 [family] => Array
3557 (
3558 [SCHEMA_NAME] =>
3559 [TABLE_NAME] => mls_master
3560 [COLUMN_NAME] => family
3561 [COLUMN_POSITION] => 82
3562 [DATA_TYPE] => varchar
3563 [DEFAULT] =>
3564 [NULLABLE] => 1
3565 [LENGTH] => 15
3566 [SCALE] =>
3567 [PRECISION] =>
3568 [UNSIGNED] =>
3569 [PRIMARY] =>
3570 [PRIMARY_POSITION] =>
3571 [IDENTITY] =>
3572 )
3573
3574 [living] => Array
3575 (
3576 [SCHEMA_NAME] =>
3577 [TABLE_NAME] => mls_master
3578 [COLUMN_NAME] => living
3579 [COLUMN_POSITION] => 83
3580 [DATA_TYPE] => varchar
3581 [DEFAULT] =>
3582 [NULLABLE] => 1
3583 [LENGTH] => 15
3584 [SCALE] =>
3585 [PRECISION] =>
3586 [UNSIGNED] =>
3587 [PRIMARY] =>
3588 [PRIMARY_POSITION] =>
3589 [IDENTITY] =>
3590 )
3591
3592 [great] => Array
3593 (
3594 [SCHEMA_NAME] =>
3595 [TABLE_NAME] => mls_master
3596 [COLUMN_NAME] => great
3597 [COLUMN_POSITION] => 84
3598 [DATA_TYPE] => varchar
3599 [DEFAULT] =>
3600 [NULLABLE] => 1
3601 [LENGTH] => 15
3602 [SCALE] =>
3603 [PRECISION] =>
3604 [UNSIGNED] =>
3605 [PRIMARY] =>
3606 [PRIMARY_POSITION] =>
3607 [IDENTITY] =>
3608 )
3609
3610 [extra] => Array
3611 (
3612 [SCHEMA_NAME] =>
3613 [TABLE_NAME] => mls_master
3614 [COLUMN_NAME] => extra
3615 [COLUMN_POSITION] => 85
3616 [DATA_TYPE] => varchar
3617 [DEFAULT] =>
3618 [NULLABLE] => 1
3619 [LENGTH] => 15
3620 [SCALE] =>
3621 [PRECISION] =>
3622 [UNSIGNED] =>
3623 [PRIMARY] =>
3624 [PRIMARY_POSITION] =>
3625 [IDENTITY] =>
3626 )
3627
3628 [feature_codes] => Array
3629 (
3630 [SCHEMA_NAME] =>
3631 [TABLE_NAME] => mls_master
3632 [COLUMN_NAME] => feature_codes
3633 [COLUMN_POSITION] => 86
3634 [DATA_TYPE] => text
3635 [DEFAULT] =>
3636 [NULLABLE] => 1
3637 [LENGTH] =>
3638 [SCALE] =>
3639 [PRECISION] =>
3640 [UNSIGNED] =>
3641 [PRIMARY] =>
3642 [PRIMARY_POSITION] =>
3643 [IDENTITY] =>
3644 )
3645
3646 [mls_office_id] => Array
3647 (
3648 [SCHEMA_NAME] =>
3649 [TABLE_NAME] => mls_master
3650 [COLUMN_NAME] => mls_office_id
3651 [COLUMN_POSITION] => 87
3652 [DATA_TYPE] => varchar
3653 [DEFAULT] =>
3654 [NULLABLE] => 1
3655 [LENGTH] => 15
3656 [SCALE] =>
3657 [PRECISION] =>
3658 [UNSIGNED] =>
3659 [PRIMARY] =>
3660 [PRIMARY_POSITION] =>
3661 [IDENTITY] =>
3662 )
3663
3664 [mls_agent_id] => Array
3665 (
3666 [SCHEMA_NAME] =>
3667 [TABLE_NAME] => mls_master
3668 [COLUMN_NAME] => mls_agent_id
3669 [COLUMN_POSITION] => 88
3670 [DATA_TYPE] => varchar
3671 [DEFAULT] =>
3672 [NULLABLE] => 1
3673 [LENGTH] => 15
3674 [SCALE] =>
3675 [PRECISION] =>
3676 [UNSIGNED] =>
3677 [PRIMARY] =>
3678 [PRIMARY_POSITION] =>
3679 [IDENTITY] =>
3680 )
3681
3682 [virtual_tour_url] => Array
3683 (
3684 [SCHEMA_NAME] =>
3685 [TABLE_NAME] => mls_master
3686 [COLUMN_NAME] => virtual_tour_url
3687 [COLUMN_POSITION] => 89
3688 [DATA_TYPE] => varchar
3689 [DEFAULT] =>
3690 [NULLABLE] => 1
3691 [LENGTH] => 200
3692 [SCALE] =>
3693 [PRECISION] =>
3694 [UNSIGNED] =>
3695 [PRIMARY] =>
3696 [PRIMARY_POSITION] =>
3697 [IDENTITY] =>
3698 )
3699
3700 [photo_quantity] => Array
3701 (
3702 [SCHEMA_NAME] =>
3703 [TABLE_NAME] => mls_master
3704 [COLUMN_NAME] => photo_quantity
3705 [COLUMN_POSITION] => 90
3706 [DATA_TYPE] => int
3707 [DEFAULT] =>
3708 [NULLABLE] => 1
3709 [LENGTH] =>
3710 [SCALE] =>
3711 [PRECISION] =>
3712 [UNSIGNED] =>
3713 [PRIMARY] =>
3714 [PRIMARY_POSITION] =>
3715 [IDENTITY] =>
3716 )
3717
3718 [photo_url] => Array
3719 (
3720 [SCHEMA_NAME] =>
3721 [TABLE_NAME] => mls_master
3722 [COLUMN_NAME] => photo_url
3723 [COLUMN_POSITION] => 91
3724 [DATA_TYPE] => varchar
3725 [DEFAULT] =>
3726 [NULLABLE] => 1
3727 [LENGTH] => 100
3728 [SCALE] =>
3729 [PRECISION] =>
3730 [UNSIGNED] =>
3731 [PRIMARY] =>
3732 [PRIMARY_POSITION] =>
3733 [IDENTITY] =>
3734 )
3735
3736 [photo_most_recent_date] => Array
3737 (
3738 [SCHEMA_NAME] =>
3739 [TABLE_NAME] => mls_master
3740 [COLUMN_NAME] => photo_most_recent_date
3741 [COLUMN_POSITION] => 92
3742 [DATA_TYPE] => int
3743 [DEFAULT] =>
3744 [NULLABLE] => 1
3745 [LENGTH] =>
3746 [SCALE] =>
3747 [PRECISION] =>
3748 [UNSIGNED] =>
3749 [PRIMARY] =>
3750 [PRIMARY_POSITION] =>
3751 [IDENTITY] =>
3752 )
3753
3754 [avm] => Array
3755 (
3756 [SCHEMA_NAME] =>
3757 [TABLE_NAME] => mls_master
3758 [COLUMN_NAME] => avm
3759 [COLUMN_POSITION] => 93
3760 [DATA_TYPE] => varchar
3761 [DEFAULT] =>
3762 [NULLABLE] => 1
3763 [LENGTH] => 3
3764 [SCALE] =>
3765 [PRECISION] =>
3766 [UNSIGNED] =>
3767 [PRIMARY] =>
3768 [PRIMARY_POSITION] =>
3769 [IDENTITY] =>
3770 )
3771
3772 [blogging] => Array
3773 (
3774 [SCHEMA_NAME] =>
3775 [TABLE_NAME] => mls_master
3776 [COLUMN_NAME] => blogging
3777 [COLUMN_POSITION] => 94
3778 [DATA_TYPE] => varchar
3779 [DEFAULT] =>
3780 [NULLABLE] => 1
3781 [LENGTH] => 3
3782 [SCALE] =>
3783 [PRECISION] =>
3784 [UNSIGNED] =>
3785 [PRIMARY] =>
3786 [PRIMARY_POSITION] =>
3787 [IDENTITY] =>
3788 )
3789
3790 [hoa_frequency] => Array
3791 (
3792 [SCHEMA_NAME] =>
3793 [TABLE_NAME] => mls_master
3794 [COLUMN_NAME] => hoa_frequency
3795 [COLUMN_POSITION] => 95
3796 [DATA_TYPE] => varchar
3797 [DEFAULT] =>
3798 [NULLABLE] => 1
3799 [LENGTH] => 20
3800 [SCALE] =>
3801 [PRECISION] =>
3802 [UNSIGNED] =>
3803 [PRIMARY] =>
3804 [PRIMARY_POSITION] =>
3805 [IDENTITY] =>
3806 )
3807
3808 [photo_valid] => Array
3809 (
3810 [SCHEMA_NAME] =>
3811 [TABLE_NAME] => mls_master
3812 [COLUMN_NAME] => photo_valid
3813 [COLUMN_POSITION] => 96
3814 [DATA_TYPE] => int
3815 [DEFAULT] =>
3816 [NULLABLE] => 1
3817 [LENGTH] =>
3818 [SCALE] =>
3819 [PRECISION] =>
3820 [UNSIGNED] =>
3821 [PRIMARY] =>
3822 [PRIMARY_POSITION] =>
3823 [IDENTITY] =>
3824 )
3825
3826 )
3827
3828 [_metadataCache:protected] =>
3829 [_metadataCacheInClass:protected] => 1
3830 [_rowClass:protected] => Zend_Db_Table_Row
3831 [_rowsetClass:protected] => Zend_Db_Table_Rowset
3832 [_referenceMap:protected] => Array
3833 (
3834 )
3835
3836 [_dependentTables:protected] => Array
3837 (
3838 )
3839
3840 [_defaultSource:protected] => defaultNone
3841 [_defaultValues:protected] => Array
3842 (
3843 )
3844
3845 )
3846
3847 [_bind:protected] => Array
3848 (
3849 )
3850
3851 [_adapter:protected] => Zend_Db_Adapter_Pdo_Mysql Object
3852 (
3853 [_pdoType:protected] => mysql
3854 [_numericDataTypes:protected] => Array
3855 (
3856 [0] => 0
3857 [1] => 1
3858 [2] => 2
3859 [INT] => 0
3860 [INTEGER] => 0
3861 [MEDIUMINT] => 0
3862 [SMALLINT] => 0
3863 [TINYINT] => 0
3864 [BIGINT] => 1
3865 [SERIAL] => 1
3866 [DEC] => 2
3867 [DECIMAL] => 2
3868 [DOUBLE] => 2
3869 [DOUBLE PRECISION] => 2
3870 [FIXED] => 2
3871 [FLOAT] => 2
3872 )
3873
3874 [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
3875 [_config:protected] => Array
3876 (
3877 [host] => 192.168.1.12
3878 [username] => root
3879 [password] => 19Thud64
3880 [dbname] => central_florida_mls
3881 [charset] =>
3882 [persistent] =>
3883 [options] => Array
3884 (
3885 [caseFolding] => 0
3886 [autoQuoteIdentifiers] => 1
3887 [fetchMode] => 2
3888 )
3889
3890 [driver_options] => Array
3891 (
3892 )
3893
3894 )
3895
3896 [_fetchMode:protected] => 2
3897 [_profiler:protected] => Zend_Db_Profiler Object
3898 (
3899 [_queryProfiles:protected] => Array
3900 (
3901 )
3902
3903 [_enabled:protected] =>
3904 [_filterElapsedSecs:protected] =>
3905 [_filterTypes:protected] =>
3906 )
3907
3908 [_defaultProfilerClass:protected] => Zend_Db_Profiler
3909 [_connection:protected] => PDO Object
3910 (
3911 )
3912
3913 [_caseFolding:protected] => 0
3914 [_autoQuoteIdentifiers:protected] => 1
3915 [_allowSerialization:protected] => 1
3916 [_autoReconnectOnUnserialize:protected] =>
3917 )
3918
3919 [_parts:protected] => Array
3920 (
3921 [distinct] =>
3922 [columns] => Array
3923 (
3924 )
3925
3926 [union] => Array
3927 (
3928 )
3929
3930 [from] => Array
3931 (
3932 )
3933
3934 [where] => Array
3935 (
3936 [0] => (zip_code = '34293')
3937 [1] => AND (sale_price > '0')
3938 [2] => AND (sale_price < '9999999999')
3939 [3] => AND (bedrooms > '0')
3940 [4] => AND (baths_total > '0')
3941 )
3942
3943 [group] => Array
3944 (
3945 )
3946
3947 [having] => Array
3948 (
3949 )
3950
3951 [order] => Array
3952 (
3953 [0] => Array
3954 (
3955 [0] => priority
3956 [1] => ASC
3957 )
3958
3959 )
3960
3961 [limitcount] =>
3962 [limitoffset] =>
3963 [forupdate] =>
3964 )
3965
3966 [_tableCols:protected] => Array
3967 (
3968 )
3969
3970 )
3971
3972 [_rowCount:protected] =>
3973)
3974here