SQL ERROR in query :SELECT count(P.P_ID) offers_count
FROM properties P JOIN cities CT ON P.P_CT_ID = CT.CT_ID
JOIN countries C ON C.C_ID = CT.CT_C_ID
JOIN agents A ON P.P_A_ID = A.A_ID
LEFT JOIN regions R ON CT.CT_R_ID = R.R_ID
WHERE A.A_IsActive = 1 and
P.P_Created >= 1182590476 AND (C.C_Name = 'France' OR LOWER(TRIM(REPLACE(C.C_Name,' ',''))) = 'france') AND CT.CT_Name='Roquebrune-Sur-Argens, Cote d'Azur'SQL ERROR in query :SELECT P.P_ID,P.P_Price,PT.PT_Name,M.M_Name,P.P_DescShort,P.P_CUR_ID, PL.PL_Name, CT.CT_Name,C.C_Name,CURT.CUR_Sign,A.A_CoName,R.*
FROM properties P JOIN measures M ON P.P_M_ID = M.M_ID
JOIN cities CT ON P.P_CT_ID = CT.CT_ID
JOIN countries C ON C.C_ID = CT.CT_C_ID
JOIN currency_types CURT ON P.P_CUR_ID = CURT.CUR_ID
JOIN prop_locations PL ON P.P_PL_ID = PL.PL_ID
JOIN agents A ON P.P_A_ID = A.A_ID
JOIN prop_types PT ON P.P_PT_ID = PT.PT_ID
LEFT JOIN regions R ON CT.CT_R_ID = R.R_ID
WHERE A.A_IsActive = 1 and
P.P_Created >= 1182590476 AND (C.C_Name = 'France' OR LOWER(TRIM(REPLACE(C.C_Name,' ',''))) = 'france') AND CT.CT_Name = 'Roquebrune-Sur-Argens, Cote d'Azur' ORDER BY C.C_Name,CT.CT_Name,P.P_Price LIMIT 0,10
Information on Off Plan Real Estate Property Preconstruction Condominiums for sale in france & Properties in france
Please also use the property search facility and browse through our wide selection of properties for sale in France including Off Plan Properties for sale, Apartments for sale, Investment Property, Golf Resort Property, Beach front property and City properties for sale. Our site is constantly being updated with new properties for sale in France so please click on the button on the top left of this page marked Daily Property Alert to sign up and receive your automated email alert for newly listed property for sale in France.
Off Plan International is a Worldwide property directory that provides property in France, off plan properties in France with information and advice on all property for sale in France. We have a great variety of preconstructed properties for sale all over the World with investment property, real estate property, waterfront property & apartments for sale in France with more options for property in France. Off Plan International have preconstruction condominiums for sale, overseas property, property abroad, new apartment homes, golf property and ski properties for sale in France and Worldwide.
