Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/acmeweb/acme/webwerks/mods/master-rmls-new-type.php on line 102

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/acmeweb/acme/webwerks/mods/master-rmls-new-type.php on line 171
New Listings



qs1 select * from ( select 1 as proptype,City,Class,InputDate,ModificationTimestamp,listAgent1_MUI,listAgent2_MUI,listOffice_MUI,LISTPRICE,MLNumber,OFFICE_OFFICENAME,postalcity,PublicRemarks,Status,UID,WaterFrontName from RRES WHERE (Status='Active' OR Status='Pending') AND transactionType='For Sale' AND ((69.1 * (latitude - 46.920255)) * (69.1 * (latitude - 46.920255))) + ((69.1 * (longitude - -95.059204) * COS(46.920255 / 57.3)) * (69.1 * (longitude - -95.059204) * COS(46.920255 / 57.3))) < pow(45, 2) union all select 2 as proptype,City,Class,InputDate,ModificationTimestamp,listAgent1_MUI,listAgent2_MUI,listOffice_MUI,LISTPRICE,MLNumber,OFFICE_OFFICENAME,postalcity,PublicRemarks,Status,UID,WaterFrontName from RLND WHERE (Status='Active' OR Status='Pending') AND ((69.1 * (latitude - 46.920255)) * (69.1 * (latitude - 46.920255))) + ((69.1 * (longitude - -95.059204) * COS(46.920255 / 57.3)) * (69.1 * (longitude - -95.059204) * COS(46.920255 / 57.3))) < pow(45, 2) union all select 3 as proptype,City,Class,InputDate,ModificationTimestamp,listAgent1_MUI,listAgent2_MUI,listOffice_MUI,LISTPRICE,MLNumber,OFFICE_OFFICENAME,postalcity,PublicRemarks,Status,UID,WaterFrontName from RCOM WHERE (Status='Active' OR Status='Pending') AND ((69.1 * (latitude - 46.920255)) * (69.1 * (latitude - 46.920255))) + ((69.1 * (longitude - -95.059204) * COS(46.920255 / 57.3)) * (69.1 * (longitude - -95.059204) * COS(46.920255 / 57.3))) < pow(45, 2) ) a ORDER BY InputDate DESC LIMIT 20
qa1
qa2
picdir
=
=
qc1
qf1