Search Results
DEBUG: SQL is:
select distinct address_text, list_price_amt, bedrooms_qty,
bathrooms_qty, advertiser_name, image_file_name, smart_code,
open_days_desc, vendor_list_id, adv_company_name
from t_real_estate_ad
where (smart_code is not null or vendor_list_id is not null) and property_type_code = 1 and zipcode_nbr in (select zipcode_nbr from t_zip_city_area_assc where city_id in (1349)) order by list_price_amt desc
DEBUG: SQL is:
select ad_nbr, ad_text, image_file_name, convert(char(10),
print_pub_date, 101), class_nbr
from t_real_estate_ad
where ol_expire_date > GETDATE() and class_nbr in (707, 723, 730, 731, 732, 733, 734, 735,
736, 737, 738, 739, 740, 741, 742, 743, 744,
746, 747, 748, 749, 750, 751, 752, 753, 754, 755,
756, 757, 758, 759, 760, 761, 762, 763, 764, 765,
766, 767, 768, 769, 770, 771, 772, 773, 774, 775,
776, 777, 778, 779, 780, 781, 782, 783, 784, 785,
786, 787, 788, 789, 790, 791, 792, 793, 794,
796, 797, 798, 799, 800, 801, 802, 803, 804, 805,
806, 807, 808, 809, 810, 811, 812, 813, 814, 815,
816, 817, 818, 819, 820, 821, 822, 823, 824,
826, 827, 828, 829, 830, 831, 832, 833, 834, 835,
836, 837, 838, 839, 840, 841, 842, 843, 844, 845,
846, 847, 848, 849, 850, 851, 852, 853, 854, 855,
856, 857, 858, 859, 860, 861, 862, 863, 864,
866, 867, 868, 869, 870, 871, 872, 873, 874, 875,
876, 877, 878, 879, 880, 881, 882,
883, 884, 885, 886, 887, 888, 899) and zipcode_nbr in (select zipcode_nbr from t_zip_city_area_assc where city_id in (1349)) order by list_price_amt desc
(0 ads found)
Search AgainSearch Again