Request More Information

select latitude, longitude, subdivision, county, mlsno, addrnum, nsew, addrname, street_suffix, streetdirsuffix, unit, city, state, zip, url from ntreis_homes_similar left join latitude_longitude on (mlsno=mls_number_lat) left join ntreis_images on (ntreis_homes_similar.matrix_unique_id=ntreis_images.mls_no and ntreis_images.photonum='1') where mlsno='14650910'