[select Sale_Price, mls_listing_id, Hoa_Fees, Hoa_Frequency, Prop_Type_Description, Status_Code, community_name, Property_State_Id, Street_Number, Street_Name, Unit_Number, City, Zip_Code, County, Longitude, Latitude, Lot_Square_Footage, Building_Square_Footage, Bedrooms, Baths_total, Baths_half, Property_Type_Code, Listing_Date, Remarks, Year_Built, LOT_DIMENSIONS, Legal, PHOTO_QUANTITY, PHOTO_URL, Feature_Codes, Taxes, Last_Mls_Update_Date, MLS_OFFICE_NAME, Virtual_Tour_url from MLS_S where mls_listing_id = 'A11707607' ]
