Property Search

SELECT "idx_listings"."id", "idx_listings"."proptype", "idx_listings"."subtype", "idx_listings"."idx_id", "idx_listings"."mls_id", "idx_listings"."status", "idx_listings"."created", "idx_listings"."updated", "idx_listings"."price", "idx_listings"."price_reduced", "idx_listings"."listing_agent", "idx_listings"."listing_office", "idx_listings"."listing_agent_id", "idx_listings"."co_listing_agent", "idx_listings"."co_listing_office", "idx_listings"."co_listing_agent_id", "idx_listings"."buyer_agent", "idx_listings"."buyer_office", "idx_listings"."buyer_agent_id", "idx_listings"."address", "idx_listings"."last_geocoded_address", "idx_listings"."last_certified_address", "idx_listings"."lat", "idx_listings"."lon", "idx_listings"."lock_geocode", "idx_listings"."geocode_source", "idx_listings"."geocode_accuracy", "idx_listings"."google_geocode_timestamp", "idx_listings"."geocode_converted", "idx_listings"."city", "idx_listings"."state", "idx_listings"."zipcode", "idx_listings"."county", "idx_listings"."subdivision", "idx_listings"."description", "idx_listings"."original_price", "idx_listings"."beds", "idx_listings"."baths", "idx_listings"."halfbaths", "idx_listings"."foreclosure", "idx_listings"."shortsale", "idx_listings"."sqft", "idx_listings"."lotsize", "idx_listings"."virtualtour", "idx_listings"."openhouse", "idx_listings"."geolocation", "idx_listings"."geometry", "idx_listings"."elementary_school", "idx_listings"."middle_school", "idx_listings"."high_school", "idx_listings"."acres", "idx_listings"."date_listed", "idx_listings"."date_sold", "idx_listings"."sold_price", "idx_listings"."date_pending", "idx_listings"."new_construction", "idx_listings"."listing_agent_email", "idx_listings"."buyer_agent_email", "idx_listings"."listing_agent_phone", "idx_listings"."buyer_agent_phone", "idx_listings"."year_built", "idx_listings"."area", "idx_listings"."style", "idx_listings"."owner_financing", "idx_listings"."display_address", "idx_listings"."handicap_accessible", "idx_listings"."green_home", "idx_listings"."mls_system_id", "idx_listings"."waterfront", "idx_listings"."lake", "idx_listings"."heating", "idx_listings"."cooling", "idx_listings"."schooldistrictname", "idx_listings"."lotsizefrontagefeet", "idx_listings"."lotsizedepthfeet", "idx_listings"."lotsizeacres", "idx_listings"."lotsizesqft", "idx_listings"."assdtotalvalue", "idx_listings"."assdlandvalue", "idx_listings"."assdimprovementvalue", "idx_listings"."markettotalvalue", "idx_listings"."marketvalueland", "idx_listings"."marketvalueimprovement", "idx_listings"."taxamt", "idx_listings"."taxyear", "idx_listings"."taxdeliquentyear", "idx_listings"."marketyear", "idx_listings"."assdyear", "idx_listings"."taxratecodearea", "idx_listings"."sumbuildingsqft", "idx_listings"."sumlivingareasqft", "idx_listings"."sumgroundfloorsqft", "idx_listings"."sumgrossareasqft", "idx_listings"."sumadjareasqft", "idx_listings"."atticsqft", "idx_listings"."atticunfinishedsqft", "idx_listings"."atticfinishedsqft", "idx_listings"."sumbasementsqft", "idx_listings"."basementunfinishedsqft", "idx_listings"."basementfinishedsqft", "idx_listings"."sumgaragesqft", "idx_listings"."garageunfinishedsqft", "idx_listings"."garagefinishedsqft", "idx_listings"."totalrooms", "idx_listings"."amenities", "idx_listings"."airconditioning", "idx_listings"."basement", "idx_listings"."buildingclass", "idx_listings"."buildingcondition", "idx_listings"."constructiontype", "idx_listings"."deck", "idx_listings"."exteriorwalls", "idx_listings"."interiorwalls", "idx_listings"."fireplace", "idx_listings"."floorcover", "idx_listings"."garage", "idx_listings"."heatingfueltype", "idx_listings"."siteinfluence", "idx_listings"."garageparkingnbr", "idx_listings"."driveway", "idx_listings"."otherrooms", "idx_listings"."patio", "idx_listings"."pool", "idx_listings"."porch", "idx_listings"."buildingquality", "idx_listings"."roofcover", "idx_listings"."rooftype", "idx_listings"."sewer", "idx_listings"."storiesnbr", "idx_listings"."sumresidentialunits", "idx_listings"."sumbuildingsnbr", "idx_listings"."sumcommercialunits", "idx_listings"."topography", "idx_listings"."water", "idx_listings"."lot", "idx_listings"."lotnbr", "idx_listings"."landlot", "idx_listings"."block", "idx_listings"."section", "idx_listings"."district", "idx_listings"."legalunit", "idx_listings"."municipality", "idx_listings"."bulk_imported", "idx_listings"."bulk_import_time", "idx_listings"."bulk_update_time", "idx_listings"."easy_status_change_time", "idx_listings"."certified_address", "idx_listings"."certified_address_line_two", "idx_listings"."certified_city", "idx_listings"."certified_state", "idx_listings"."certified_zipcode", "idx_listings"."delivery_point", "idx_listings"."certified_check", "idx_listings"."previous_listed_id", "idx_listings"."next_listed_id", "idx_listings"."raw_data" FROM "idx_listings" WHERE ("idx_listings"."idx_id" IN (SELECT DISTINCT U0."idx_id" FROM "idxs_idx" U0 INNER JOIN "idxs_idxaccount" U1 ON (U0."idx_id" = U1."idx_id") WHERE U1."user_id" = 173423) AND (UPPER("idx_listings"."proptype"::text) LIKE UPPER(r%) OR UPPER("idx_listings"."proptype"::text) LIKE UPPER(e%) OR UPPER("idx_listings"."proptype"::text) LIKE UPPER(s%) OR UPPER("idx_listings"."proptype"::text) LIKE UPPER(i%)) AND (UPPER("idx_listings"."address"::text) LIKE UPPER(%north main%) OR UPPER("idx_listings"."city"::text) LIKE UPPER(%north main%) OR "idx_listings"."city" IN (north, main) OR UPPER("idx_listings"."zipcode"::text) LIKE UPPER(%north main%) OR UPPER("idx_listings"."subdivision"::text) LIKE UPPER(%north main%) OR UPPER("idx_listings"."elementary_school"::text) LIKE UPPER(%north main%) OR UPPER("idx_listings"."middle_school"::text) LIKE UPPER(%north main%) OR UPPER("idx_listings"."high_school"::text) LIKE UPPER(%north main%) OR UPPER("idx_listings"."county"::text) LIKE UPPER(%north main%)) AND "idx_listings"."updated" > 2024-04-17 23:35:12.858896) ORDER BY "idx_listings"."price" DESC LIMIT 500