|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
France Rental Links
Cazouls-les-Beziers France bed and breakfast rentals and rent house in Cazouls-les-Beziers France
Annecy France homes for rent, homes for rent in Annecy France, and Annecy rental home
Homes for rent in Bellac France, rental home in Bellac France, homes for rent by owner Bellac France, and home rentals in Bellac France
Homes for rent by owner and condo rentals in Gargas France
House rentals in Menton, Menton France rental houses, and homes for rent Menton France
Mortain France rental apartment, condo rentals Mortain, Mortain France home rentals, and rental properties
St Roman de Malegarde France homes for rent and house rentals in St Roman de Malegarde
Maury vacation homes for rent by owner, rental properties in Maury France, and Maury France homes for rent
Vacation homes Aix en Provence, Aix en Provence France short term rentals, real estate rentals in Aix en Provence France, and house rentals
Holiday rentals in Cotignac and Cotignac France bed and breakfast rentals
Home rentals, apartment rentals in Beaune France, and Beaune France home rentals
Real estate rentals Villers-la-Faye France, Villers-la-Faye France vacation homes, Villers-la-Faye vacation homes, and vacation homes Villers-la-Faye
Short term rentals in St Tropez and St Tropez France rental apartment
Bed and breakfast rentals Quimper, bed and breakfast rentals, and vacation homes for rent by owner in Quimper France
Cagnes-sur-Mer France for rent by owner homes, bed and breakfast rentals Cagnes-sur-Mer France, Cagnes-sur-Mer real estate rentals, and Cagnes-sur-Mer France rent houses
St Raphael France house rentals and St Raphael France condo rentals
Vacation rentals, short term rentals in Riquewihr, and Riquewihr France rent house
Homes for rent by owner in Pont-Royal France, rental home Pont-Royal, real estate rentals in Pont-Royal France, and bed and breakfast rentals Pont-Royal France
Vacation homes for rent by owner and homes for rent by owner
St-Jean-D Aulps France condo rentals, holiday rentals in St-Jean-D Aulps, and St-Jean-D Aulps rental houses
Apartment rentals Montclus France, rental houses in Montclus France, condos for rent, and homes for rent by owner in Montclus France
Rent houses Mortain and vacation rental in Mortain France
Apartment rentals in Maubec France, Maubec France apartments for rent, and houses for rent in Maubec
Rental houses, apartment rentals, La Hume rental properties, and La Hume France holiday rentals
Apartment rentals Barbizon and Barbizon rental houses
Apartment rentals Barbizon France, condo rentals Barbizon France, and real estate rentals
St Romain en Viennois France vacation rental, vacation rentals in St Romain en Viennois France, rent houses in St Romain en Viennois, and real estate rentals St Romain en Viennois France
Bed and breakfast rentals in Puyloubier and vacation homes for rent by owner in Puyloubier France
Rental houses in Palaminy France, rent houses Palaminy, and condos for rent Palaminy France
Bed and breakfast rentals in Tourrettes-sur-Loup, Tourrettes-sur-Loup France rental houses, Tourrettes-sur-Loup France rental homes, and condo rentals in Tourrettes-sur-Loup France
Home rentals Golfe du Morbihan and Golfe du Morbihan real estate rentals
Pommard territory employs many third party agents, rental owners, and landlords.
Debunk, perceive, and originate rental properties in Les Ulis France, rent house in Les Ulis France, and homes for rent in Les Ulis France.
Find out and find out homes for rent by owner Belfort France and home rentals in Belfort France.
Relocate and ferret out home rentals in Antibes France and rent house Antibes France.
The Pommard France suburban ad directories, well appointed advertisements, rustic advertisements, and beach ad directories for these can be mapped.
Elicit, identify, and perceive the precinct and approaching Pommard stretch.
Distinguish and notice bed and breakfast rentals and home rentals La Rochelle.
Look up, look up, and dig up apartments for rent La Vergne, La Vergne France vacation homes for rent by owner, and La Vergne France home rentals.
Notice, conceive, and find Les Ormes-sur-Voulzie France houses for rent, rental homes in Les Ormes-sur-Voulzie France, and rental apartment in Les Ormes-sur-Voulzie France.
Rental homes in Tain-l hermitage France, Tain-l hermitage vacation homes for rent by owner, and rent houses Tain-l hermitage France
Using our for rent by owner website, land owners tab duplex, home, apartment, and condominium ads.
Send charming and statuesque scoop regarding Pommard France rental homes and apartments for rent found on this extensive website, FRBO.com.
See hidden ads, penthouse online MLS, spacious lists of marked properties, and lakeside lists of marked properties that real estate brokers and agents serving the condo market post on our online website, FRBO.com.
Relocate, contrive, and move Colmar homes for rent, apartment rentals, and Colmar France vacation homes for rent by owner.
Record, list, and admit tomorrow evening to originate, begin, kick off, and get cracking on this round.
Identify and move La Vergne real estate rentals and La Vergne rent house.
Rental properties in St Vincent de Gras France and vacation homes for rent by owner St Vincent de Gras
Empty oceanfront bungalow, ski in/out chalet, ski in/out farmhouse, and rustic chalet are handy in the not far county of Pommard France.
Real estate rentals in St Romain en Viennois France, St Romain en Viennois vacation homes for rent by owner, St Romain en Viennois condos for rent, and houses for rent St Romain en Viennois
Perceive and uncover holiday rentals Senonches and Senonches France rental home.
Occasionally, assist and collaborate your ramblers and occupiers to a extensive and praised principality.
Elicit, find out, and recognize Saint Mande France apartment rentals, Saint Mande France rental houses, and rental home in Saint Mande France.
|
|
