|
<%@ 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
Rental homes Millau and vacation homes Millau France
Les Arcs Sur Argens France condos for rent, Les Arcs Sur Argens vacation rentals, and rental homes Les Arcs Sur Argens France
Vacation homes Quimper, Quimper France apartment rentals, Quimper France vacation rental, and real estate rentals in Quimper France
Vacation homes for rent by owner St-Jean-D Aulps and St-Jean-D Aulps France vacation homes for rent by owner
Houses for rent in Chateauneuf-Grasse, Chateauneuf-Grasse France rental apartment, and rental properties
Cabrieres-d Avignon France rental properties, Cabrieres-d Avignon France rent houses, rental homes in Cabrieres-d Avignon France, and houses for rent Cabrieres-d Avignon France
Home rentals and home rentals
Vacation rental in Lauzerte France, home rentals in Lauzerte, and Lauzerte France condos for rent
Rent house, for rent by owner homes, rental homes in Cotignac, and Cotignac France for rent by owner homes
Condo rentals Annecy France and holiday rentals Annecy
Maussane-Les-Alpilles France rent houses, Maussane-Les-Alpilles France houses for rent, and Maussane-Les-Alpilles rent houses
Vacation rental in Pontivy France, Pontivy France house rentals, Pontivy France for rent by owner homes, and Pontivy rental apartment
Apartments for rent in Caunes Minervois France and real estate rentals in Caunes Minervois France
Lauzerte France homes for rent, rental apartment in Lauzerte France, and apartments for rent in Lauzerte France
La Ciotat house rentals, real estate rentals La Ciotat, La Ciotat vacation homes, and La Ciotat rental home
Ferret out, light upon, and find out homes for rent by owner in Cavaliere Sur Mer France, Cavaliere Sur Mer France bed and breakfast rentals, and rental properties in Cavaliere Sur Mer France.
Observe, contrive, and perceive homes for rent Marseille, vacation homes for rent by owner, and houses for rent Marseille France.
Assign, hitch, enter into, and register tomorrow morning to lead off, enter upon, kick off, and begin on this sally.
Roomers, grooms, and colleagues who are questing rental home Entrecasteaux and are trying to discover apartments for rent Entrecasteaux, Entrecasteaux France holiday rentals, and Entrecasteaux France vacation homes for rent by owner can scour our online website, FRBO.com and our log listings, ski in/out online MLS, penthouse advertisements, and well appointed ads.
Get cracking your wild-goose chase online next week or in the next few days for your bed and breakfast rentals in Entrecasteaux and rental houses.
Come across and recognize house rentals in Saint Avold and homes for rent by owner in Saint Avold.
Fraternity members and peers study, shake down, and search for our for rent by owner site, FRBO.com and relocate rustic lodge, hidden house, and hillside cabin.
Move unconventional, specific, and bizarre compilations in Entrecasteaux France and place Entrecasteaux vacation homes for rent by owner.
Entrecasteaux France is a splendid, enticing, and classy state with wonderful, resplendent, radiant, and pulchritudinous flat, condominium, cottage, and flats.
This site, For Rent By Owner (FRBO.com) can place and inscribe oceanfront online MLS, city listed properties, mountain classified advertisements, and hidden ad directories spacious classified ads, suburban classified advertisements, hidden ads, and log listed properties to expedite your Entrecasteaux France safari.
Join our hidden ads, penthouse listings, lakeside classifieds, and beach classified ads mailing list for Entrecasteaux France for rent by owner homes and Entrecasteaux France vacation homes.
Find, conceive, and ferret out Chamonix France houses for rent, Chamonix France condo rentals, and houses for rent.
Using our for rent by owner website, third party listing companies spell out castle and home indexes.
The Entrecasteaux France classified advertisements docketed and docketed on our page embrace spacious castle, hidden home, beach home, and ski in/out house.
Discover and come upon vacation homes Pau and Pau France rental houses.
Design and invent apartments for rent and rental properties in Saint Avold France.
Discover and find out homes for rent in Les Ormes-sur-Voulzie and homes for rent by owner in Les Ormes-sur-Voulzie.
|
|
