Residential Properties Found
Showing 0 Properties
Address/Price
Overview
Description
PREV
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (p.LO1_ShortName='SPBD01' OR p.LO1_ShortName='SPBD02' OR p.LO1_ShortName='' at line 2]
SELECT COUNT(L_ListingID) AS count
FROM property_sfd p WHERE p.L_AskingPrice <= 10000000 ) AND (p.LO1_ShortName='SPBD01' OR p.LO1_ShortName='SPBD02' OR p.LO1_ShortName='39' OR p.LO2_ShortName='SPBD01' OR p.LO2_ShortName='SPBD02' OR p.LO2_ShortName='39')
UNION
SELECT COUNT(L_ListingID) AS count
FROM property_sfa p WHERE p.L_AskingPrice <= 10000000 ) AND (p.LO1_ShortName='SPBD01' OR p.LO1_ShortName='SPBD02' OR p.LO1_ShortName='39' OR p.LO2_ShortName='SPBD01' OR p.LO2_ShortName='SPBD02' OR p.LO2_ShortName='39')
UNION
SELECT COUNT(L_ListingID) AS count
FROM property_sfd p WHERE p.L_AskingPrice <= 10000000 ) AND (p.LO1_ShortName<>'SPBD01' AND p.LO1_ShortName<>'SPBD02' AND p.LO2_ShortName<>'SPBD01' AND p.LO2_ShortName<>'SPBD02')
UNION
SELECT COUNT(L_ListingID) AS count
FROM property_sfa p WHERE p.L_AskingPrice <= 10000000 ) AND (p.LO1_ShortName<>'SPBD01' AND p.LO1_ShortName<>'SPBD02' AND p.LO2_ShortName<>'SPBD01' AND p.LO2_ShortName<>'SPBD02')
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (p.LO1_ShortName='SPBD01' OR p.LO1_ShortName='SPBD02' OR p.LO1_ShortName='' at line 9]
SELECT p.L_ListingID as id, p.L_AddressNumber AS l_street_number, p.L_AddressStreet AS l_street_name, p.L_AskingPrice AS l_price, p.LO1_ShortName AS l_broker, p.LM_Char10_19 AS l_elem_school, p.LM_Char10_21 AS l_middle_school, p.LM_Char10_20 AS l_high_school, p.LFD_Construction_5 AS l_construction,
p.L_Type_ AS l_type, p.LR_remarks55 AS public_remarks, p.LM_Int4_7 AS l_bedrooms, p.LM_Int1_8 AS l_bedrooms_lower, p.LM_Int1_9 AS l_bedrooms_main, p.LM_Char50_5 AS l_subdivision, p.LM_Int4_4 AS l_assoc_fee, p.LFD_FeesInclude_12 AS l_assoc_fee_includes,
p.LM_Int1_10 AS l_bedrooms_upper, p.LM_Int4_5 AS l_baths_full, p.LM_Int4_6 AS l_baths_half, p.L_City AS l_city, p.L_State AS l_state,
p.L_PictureCount AS l_photo_count, p.VT_VTourURL AS l_virtual_tour_url_unbranded, p.VT_ExtVTourURL1 AS l_virtual_tour_url_branded, p.L_PictureCount AS l_photo_count, p.LM_Int2_1 AS l_year_built,
p.LM_Int4_9 AS l_sqft, p.L_NumAcres AS l_num_acres, p.L_ListAgent1 AS l_list_agent1, p.L_ListAgent2 AS l_list_agent2, 'sfd' AS tablename,
a.U_UserFirstName AS first_name, a.U_UserLastName AS last_name, a.U_UserCode AS agent_usercode
FROM property_sfd p
LEFT JOIN agents a ON (a.U_UserCode = p.LA1_AgentID)
WHERE p.L_AskingPrice <= 10000000 ) AND (p.LO1_ShortName='SPBD01' OR p.LO1_ShortName='SPBD02' OR p.LO1_ShortName='39' OR p.LO2_ShortName='SPBD01' OR p.LO2_ShortName='SPBD02' OR p.LO2_ShortName='39')
UNION
SELECT p.L_ListingID as id, p.L_AddressNumber AS l_street_number, p.L_AddressStreet AS l_street_name, p.L_AskingPrice AS l_price, p.LO1_ShortName AS l_broker, p.LM_Char10_19 AS l_elem_school, p.LM_Char10_21 AS l_middle_school, p.LM_Char10_20 AS l_high_school, p.LFD_Construction_40 AS l_construction,
p.L_Type_ AS l_type, p.LR_remarks55 AS public_remarks, p.LM_Int4_7 AS l_bedrooms, p.LM_Int1_8 AS l_bedrooms_lower, p.LM_Int1_9 AS l_bedrooms_main, p.LM_Char50_5 AS l_subdivision , p.LM_Int4_4 AS l_assoc_fee, p.LFD_FeesInclude_47 AS l_assoc_fee_includes,
p.LM_Int1_10 AS l_bedrooms_upper, p.LM_Int4_5 AS l_baths_full, p.LM_Int4_6 AS l_baths_half, p.L_City AS l_city, p.L_State AS l_state,
p.L_PictureCount AS l_photo_count, p.VT_VTourURL AS l_virtual_tour_url_unbranded, p.VT_ExtVTourURL1 AS l_virtual_tour_url_branded, p.L_PictureCount AS l_photo_count, p.LM_Int2_1 AS l_year_built,
p.LM_Int4_9 AS l_sqft, p.L_NumAcres AS l_num_acres, p.L_ListAgent1 AS l_list_agent1, p.L_ListAgent2 AS l_list_agent2,'sfa' AS tablename,
a.U_UserFirstName AS first_name, a.U_UserLastName AS last_name, a.U_UserCode AS agent_usercode
FROM property_sfa p
LEFT JOIN agents a ON (a.U_UserCode = p.LA1_AgentID)
WHERE p.L_AskingPrice <= 10000000 ) AND (p.LO1_ShortName='SPBD01' OR p.LO1_ShortName='SPBD02' OR p.LO1_ShortName='39' OR p.LO2_ShortName='SPBD01' OR p.LO2_ShortName='SPBD02' OR p.LO2_ShortName='39')
UNION
SELECT p.L_ListingID as id, p.L_AddressNumber AS l_street_number, p.L_AddressStreet AS l_street_name, p.L_AskingPrice AS l_price, p.LO1_ShortName AS l_broker, p.LM_Char10_19 AS l_elem_school, p.LM_Char10_21 AS l_middle_school, p.LM_Char10_20 AS l_high_school, p.LFD_Construction_5 AS l_construction,
p.L_Type_ AS l_type, p.LR_remarks55 AS public_remarks, p.LM_Int4_7 AS l_bedrooms, p.LM_Int1_8 AS l_bedrooms_lower, p.LM_Int1_9 AS l_bedrooms_main, p.LM_Char50_5 AS l_subdivision , p.LM_Int4_4 AS l_assoc_fee, p.LFD_FeesInclude_12 AS l_assoc_fee_includes,
p.LM_Int1_10 AS l_bedrooms_upper, p.LM_Int4_5 AS l_baths_full, p.LM_Int4_6 AS l_baths_half, p.L_City AS l_city, p.L_State AS l_state,
p.L_PictureCount AS l_photo_count, p.VT_VTourURL AS l_virtual_tour_url_unbranded, p.VT_ExtVTourURL1 AS l_virtual_tour_url_branded, p.L_PictureCount AS l_photo_count, p.LM_Int2_1 AS l_year_built,
p.LM_Int4_9 AS l_sqft, p.L_NumAcres AS l_num_acres, p.L_ListAgent1 AS l_list_agent1, p.L_ListAgent2 AS l_list_agent2, 'sfd' AS tablename,
a.U_UserFirstName AS first_name, a.U_UserLastName AS last_name, a.U_UserCode AS agent_usercode
FROM property_sfd p
LEFT JOIN agents a ON (a.U_UserCode = p.LA1_AgentID)
WHERE p.L_AskingPrice <= 10000000 ) AND (p.LO1_ShortName<>'SPBD01' AND p.LO1_ShortName<>'SPBD02' AND p.LO2_ShortName<>'SPBD01' AND p.LO2_ShortName<>'SPBD02')
UNION
SELECT p.L_ListingID as id, p.L_AddressNumber AS l_street_number, p.L_AddressStreet AS l_street_name, p.L_AskingPrice AS l_price, p.LO1_ShortName AS l_broker, p.LM_Char10_19 AS l_elem_school, p.LM_Char10_21 AS l_middle_school, p.LM_Char10_20 AS l_high_school, p.LFD_Construction_40 AS l_construction,
p.L_Type_ AS l_type, p.LR_remarks55 AS public_remarks, p.LM_Int4_7 AS l_bedrooms, p.LM_Int1_8 AS l_bedrooms_lower, p.LM_Int1_9 AS l_bedrooms_main, p.LM_Char50_5 AS l_subdivision , p.LM_Int4_4 AS l_assoc_fee, p.LFD_FeesInclude_47 AS l_assoc_fee_includes,
p.LM_Int1_10 AS l_bedrooms_upper, p.LM_Int4_5 AS l_baths_full, p.LM_Int4_6 AS l_baths_half, p.L_City AS l_city, p.L_State AS l_state,
p.L_PictureCount AS l_photo_count, p.VT_VTourURL AS l_virtual_tour_url_unbranded, p.VT_ExtVTourURL1 AS l_virtual_tour_url_branded, p.L_PictureCount AS l_photo_count, p.LM_Int2_1 AS l_year_built,
p.LM_Int4_9 AS l_sqft, p.L_NumAcres AS l_num_acres, p.L_ListAgent1 AS l_list_agent1, p.L_ListAgent2 AS l_list_agent2, 'sfa' AS tablename,
a.U_UserFirstName AS first_name, a.U_UserLastName AS last_name, a.U_UserCode AS agent_usercode
FROM property_sfa p
LEFT JOIN agents a ON (a.U_UserCode = p.LA1_AgentID)
WHERE p.L_AskingPrice <= 10000000 ) AND (p.LO1_ShortName<>'SPBD01' AND p.LO1_ShortName<>'SPBD02' AND p.LO2_ShortName<>'SPBD01' AND p.LO2_ShortName<>'SPBD02')
LIMIT 0, 10