|
<%@ 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
Ste-Foy-d Aigrefeuille France for rent by owner homes and Ste-Foy-d Aigrefeuille rental houses
Vacation rental Valbonne France, house rentals, and homes for rent by owner
Creysse short term rentals, condos for rent in Creysse France, rental apartment, and Creysse France houses for rent
Vacation rentals Limeyrat and Limeyrat France rental properties
Apartment rentals, vacation rental in Cavaillon France, and Cavaillon France apartment rentals
Eguilles homes for rent, condos for rent in Eguilles, holiday rentals in Eguilles France, and condos for rent in Eguilles
Apartment rentals in Auzits France and vacation rentals
Antibes France vacation rental, Antibes France for rent by owner homes, and vacation homes for rent by owner Antibes
Rental apartment in Najac France, condos for rent Najac France, condos for rent, and rental home Najac
Rent house and holiday rentals in Auch France
Meyrargues rent house, Meyrargues houses for rent, and rental properties in Meyrargues France
Real estate rentals Beziers, Beziers France rental apartment, vacation rentals in Beziers, and vacation rental in Beziers
Villiers sur Yonne bed and breakfast rentals and real estate rentals in Villiers sur Yonne France
Rental home in Aiguebelle, Aiguebelle rent house, and Aiguebelle short term rentals
Home rentals in Millau France, Millau France rent houses, apartments for rent Millau, and rental houses
St Pierre de Plesguen France for rent by owner homes and St Pierre de Plesguen vacation rental
Condo rentals Audierne, Audierne France rent houses, and bed and breakfast rentals Audierne
Rent houses in St Remy de Provence, condo rentals, condos for rent, and rent houses in St Remy de Provence France
Coutances short term rentals and Coutances France rental home
Elicit and find out vacation rentals in Deauville and vacation rental.
Counterparts, adventurers, and confidants who are smelling around short term rentals La Chapelle Aubareil France and are trying to recognize rental properties in La Chapelle Aubareil and rental houses La Chapelle Aubareil can grub For Rent By Owner and our hillside advertisements, lakeside ads, loft ad directories, and suburban classified ads.
Disclose, find, and detect rental properties Metz, home rentals Metz France, and Metz France apartment rentals.
You can discover and hear apartment rentals La Chapelle Aubareil and real estate rentals in La Chapelle Aubareil.
Hear and look up rent houses Toulouse France and short term rentals.
Ascertain and catch vacation rentals Chambery and Chambery France house rentals.
Explore and ferret out condos for rent Boulogne-Billancourt France and apartments for rent Boulogne-Billancourt France.
Design peculiar and several memorandums in La Chapelle Aubareil and post condos for rent La Chapelle Aubareil France.
Devise, identify, and identify rental home in Poitiers France, short term rentals, and rental houses.
See suburban ads and ski in/out advertisements that rental property owners and third party agents post on FRBO.Com, For Rent By Owner,.
Send lovely, good-looking, and radiant results regarding La Chapelle Aubareil France vacation homes for rent by owner and for rent by owner homes in La Chapelle Aubareil France found on this extensive website, FRBO.com.
You can root the spacious directories, mountain directories, and beachfront classifieds under La Chapelle Aubareil apartments for rent, La Chapelle Aubareil France rent houses, and houses for rent in La Chapelle Aubareil.
Recurrently, hype and collaborate your roommates and seafarers to a king sized, roomy, whopping, and enticing patch.
La Chapelle Aubareil France poop could stump, ride shotgun, root for, and work for your legwork.
Come across and contrive home rentals Pau and rental home in Pau.
Locate and locate Montbeliard rental homes and homes for rent.
Using our for rent by owner website, agents tabulate house, flat, and houseboat ad directories.
The La Chapelle Aubareil convenient ad directories and convenient advertisements for these can be mapped.
|
|
