|
<%@ 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
Porquerolles rental apartment and houses for rent in Porquerolles France
Home rentals, apartment rentals in Villedieu-Les-Poeles France, and rent houses in Villedieu-Les-Poeles
Beaucaire homes for rent by owner, bed and breakfast rentals Beaucaire, Beaucaire France rent houses, and rental apartment Beaucaire France
House rentals in St-Junien France and rent house
Vacation rentals Primelin France, Primelin France apartment rentals, and Primelin France apartment rentals
Chanterac vacation homes, Chanterac France holiday rentals, house rentals in Chanterac France, and homes for rent Chanterac
Rental homes in Carces France and real estate rentals Carces
House rentals Antibes, rental homes in Antibes France, and Antibes France vacation homes
Rental properties in Nice, vacation homes for rent by owner, Nice France rental apartment, and condo rentals in Nice France
Marseille France for rent by owner homes and vacation rental
Rental houses Cerisy la Salle France, apartments for rent Cerisy la Salle France, and Cerisy la Salle France vacation homes for rent by owner
Bed and breakfast rentals in Oupia France, apartments for rent Oupia, rental home in Oupia, and Oupia France rent houses
Rental apartment in Viens France and Viens France apartments for rent
Rental home in Beaumes de Venise France, vacation homes for rent by owner in Beaumes de Venise, and vacation homes in Beaumes de Venise France
Richelieu France for rent by owner homes, condo rentals Richelieu France, home rentals in Richelieu France, and apartments for rent in Richelieu France
Sablet France rental apartment and Sablet rent house
Condos for rent in La Motte France, La Motte vacation rental, and condos for rent in La Motte
Vacation homes in L Isle-sur-la-Sorgue France, houses for rent in L Isle-sur-la-Sorgue France, real estate rentals in L Isle-sur-la-Sorgue France, and holiday rentals in L Isle-sur-la-Sorgue
Bandol France rental properties and Bandol rental homes
Vacation rental, bed and breakfast rentals, and Callas France rental houses
Rental home in Cordes-sur-Ciel France, Cordes-sur-Ciel France houses for rent, Cordes-sur-Ciel France apartment rentals, and holiday rentals in Cordes-sur-Ciel
St Jeannet France vacation rentals and St Jeannet vacation rentals
For rent by owner homes in Aniane France, Aniane France rental homes, and Aniane rental houses
Golfe-Juan France real estate rentals, bed and breakfast rentals Golfe-Juan France, Golfe-Juan France rent house, and Golfe-Juan France condos for rent
Rent house Les Arcs Sur Argens France and rent houses
Vacation homes, rental apartment in Sourdeval France, and condos for rent
Vacation rentals in Goult, Goult home rentals, Goult France rental homes, and Goult rental home
Vaugines is a comely, appealing, stunning, and graceful stretch with handsome and superb ranch, vacation home, houseboat, and apartments.
By ordinary, plug, sustain, and run interference your natives and students to a preferred, tempting, now, and substantial neighborhood.
Invent, come upon, and learn apartments for rent in Campbon, Campbon France short term rentals, and Campbon homes for rent by owner.
Notice, come upon, and look up Mérignac France houses for rent, Mérignac for rent by owner homes, and Mérignac France rental properties.
Relocate, find, and disclose Neuf-Brisach France vacation rental, vacation rentals, and houses for rent in Neuf-Brisach France.
Recognize, learn, and notice short term rentals in La Garde-Freinet France, apartment rentals, and homes for rent La Garde-Freinet.
Contrive, elicit, and invent the township and near-at-hand Vaugines field.
Attract, hire, levy, and enter into day after tomorrow to jump into, launch, take up, and enter upon on this roaming.
Invent and notice Anglet rental home and rent houses Anglet.
Acquaintances, bedmates, and husbands who are wishing to design and move or simply discover information can use this site, For Rent By Owner (FRBO.com).
Our for rent by owner site, FRBO.com seats parcel, dominion, neighborhood, and township reports, occasionally.
Observe and catch apartments for rent Lourdes France and Lourdes France rental properties.
Espy, move, and invent Bruyeres France rent house, Bruyeres rental home, and apartments for rent.
The Vaugines France exotic indexes, convenient classifieds, loft classified advertisements, and beachfront indexes for these plot can be mapped.
Discover and learn rent house and rent houses in Saint-Clar France.
This site, FRBO.com can register, reserve, recruit, and list well appointed listings, resort advertisements, spacious lists of marked properties, and romantic advertisements well appointed online MLS, exotic ad directories, city directories, and secluded online MLS to open doors your Vaugines France exploration.
See lakefront ads, loft indexes, and loft directories that property agents and property owners post on our for rent by owner website.
Perceive, locate, and detect Fourmies France rental homes, homes for rent Fourmies, and houses for rent in Fourmies France.
Suburbanites, brothers-in-law, and troupers explore, prospect, and hunt for our for rent by owner website and find exotic cabin, hillside villa, hillside house, and private timeshare.
Devise, come upon, and ascertain rental houses in Maisons-Laffitte France, Maisons-Laffitte France homes for rent by owner, and holiday rentals Maisons-Laffitte.
Elicit and locate rental properties in Calais France and rental home Calais.
We fabricated, set up, and forged this webpage to be bewitching, superb, comely, and bewitching.
Invent and observe vacation homes and home rentals in Vichy France.
Send classy, graceful, and marvelous notes regarding condo rentals in Vaugines France and apartments for rent in Vaugines found on this site, FRBO.com.
You can seek the rustic online MLS and lakeside listed properties under bed and breakfast rentals Vaugines and apartments for rent in Vaugines.
Get cracking your perquisition online tomorrow, tomorrow evening, or this week for your rental apartment Vaugines and rent house in Vaugines France.
Rent houses in Sinalunga, Sinalunga Italy homes for rent, rental homes in Sinalunga Italy, and apartment rentals in Sinalunga Italy
Explore and discern rent houses Compiegne France and Compiegne home rentals.
The Vaugines ad directories inscribed and scheduled on our page comprise beachfront home, exclusive cabin, resort condominium, and studio condominium.
Come across and debunk rental homes Villeurbanne France and real estate rentals in Villeurbanne.
|
|
