SELECT *,l.status as l_status, l.mls, l.city, l.state, l.zip, l.agent_name, l.agent_phone, l.`address`, l.bedrooms, l.bath_total, l.price, l.neighborhood as l_neighborhood , m.location AS `media` FROM `mlsi__listing` l LEFT JOIN mlsi__listing_media m ON l.mls = m.mls LEFT JOIN wp_urban_listing u ON l.mls = u.mls WHERE m.`object_id` =1 AND ( ( l.county LIKE "San Diego" ) AND ( l.city LIKE "San Diego" ) ) AND ( l.status LIKE "Active" ) AND ( l._class_code LIKE "RT_4" ) GROUP BY m.mls ORDER BY l.price ASC LIMIT 0, 10
92101 Urban Living is the industry leader in the dynamic Downtown San Diego Real Estate market.
We are experts in the Downtown San Diego Real Estate Market, and just specialize in the 92101 Zip Code. 92101 Urban Living is a boutique, neighborhood, family owned, and team based office. The core mission of the company is to provide consultation based real estate service to our clients. 92101 Urban Living is committed to operating our business and services a little bit different than a tradition real estate company: 92101 specializes in just one market, 92101 is 100% web based, 92101 provides a team oriented service to clients. These points of difference allow 92101 Urban Living to bring true innovation to the Downtown San Diego Real Estate Market, and separate themselves from the ordinary competition. Find out more by visitng our San Diego Condos dedicated page, and view all the Downtown San Diego Lofts currently on the 92101