|
<%@ 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
Houses for rent Les Arcs Sur Argens France and Les Arcs Sur Argens rental houses
Bed and breakfast rentals Avignon, apartment rentals Avignon, and Avignon France vacation rental
Les Arcs Sur Argens rental houses, Les Arcs Sur Argens rental houses, Les Arcs Sur Argens France rental houses, and Les Arcs Sur Argens holiday rentals
Auch France rental homes and homes for rent by owner
Puyloubier homes for rent by owner, Puyloubier France rent houses, and homes for rent by owner in Puyloubier
Le-Bar-Sur-Loup France rental homes, rent houses Le-Bar-Sur-Loup, house rentals in Le-Bar-Sur-Loup, and Le-Bar-Sur-Loup France apartment rentals
Ambert France for rent by owner homes and short term rentals in Ambert France
Houses for rent Ansouis, real estate rentals in Ansouis France, and Ansouis France vacation rental
Porto-Vecchio apartment rentals, rental homes in Porto-Vecchio France, Porto-Vecchio France rent houses, and bed and breakfast rentals Porto-Vecchio France
Vacation homes St Tropez France and short term rentals in St Tropez France
Apartment rentals Carrieres sur Seine France, vacation homes in Carrieres sur Seine France, and Carrieres sur Seine home rentals
Rental apartment in Loches, Loches France homes for rent by owner, Loches house rentals, and vacation rentals Loches
Condos for rent Le Bugue France and Le Bugue France rent house
Condos for rent in St Vincent de Gras France, rental apartment in St Vincent de Gras, and rental houses in St Vincent de Gras France
Apartment rentals, Lourmarin homes for rent, vacation rental Lourmarin France, and rental houses in Lourmarin
Biot France homes for rent by owner and rent houses in Biot France
St Roman de Malegarde France apartment rentals, rent houses in St Roman de Malegarde France, and St Roman de Malegarde France for rent by owner homes
Bormes-les-Mimosas France vacation rental, house rentals Bormes-les-Mimosas, real estate rentals in Bormes-les-Mimosas France, and Bormes-les-Mimosas France rent house
Vacation homes for rent by owner Primelin France and holiday rentals Primelin
St Saturnin les Apt homes for rent, St Saturnin les Apt France houses for rent, and vacation homes for rent by owner in St Saturnin les Apt France
Vacation rentals in Millau France, Millau rent house, rental apartment in Millau, and rental homes
Apartments for rent in Auzits France and rental homes in Auzits
Apartments for rent in Avranches France, apartment rentals in Avranches France, and rental apartment in Avranches France
Saint-Lo apartment rentals, house rentals, houses for rent in Saint-Lo France, and Saint-Lo France vacation homes
Vacation homes for rent by owner in Les Taillades France and rental houses in Les Taillades France
House rentals Anduze France, Anduze France homes for rent by owner, and houses for rent Anduze
Rent house in St Aygulf, St Aygulf France condos for rent, St Aygulf France rental homes, and St Aygulf France apartment rentals
Our webpage can interest, hitch, get, and muster oceanfront lists of marked properties, beachfront online MLS, and mountain lists of marked properties waterfront directories, log classifieds, and convenient classifieds to support your Cap D ail France traverse.
Using this extensive website, FRBO.com, rental property owners enter farmhouse and vacation home ad directories.
Notice, determine, and locate Clermont-Ferrand France vacation rentals, vacation rental, and Clermont-Ferrand short term rentals.
Join our beach directories and city directories mailing list for rental houses in Cap D ail France and Cap D ail France vacation homes.
Relocate, discover, and determine Dijon France vacation rental, Dijon France rent houses, and Dijon France vacation rentals.
Buddies, migrants, and sisters-in-law rake, explore, and scout this site, For Rent By Owner (FRBO.com) and uncover well appointed condominium, beach home, private apartment, and romantic home.
Occasionally, benefit, help, stump, and root for your traveling saleswomen and boarders to a luring, brimming, oversize, and stylish vicinity.
Recognize and ferret out apartment rentals Carcassonne France and home rentals in Carcassonne France.
Send magnificent and fine brass tacks regarding rental homes in Cap D ail, rental properties Cap D ail, and holiday rentals found on this site, FRBO.com.
Discover and dig up Coex rental home and vacation rentals.
Dwellers and traveling men who are running down rent house Cap D ail France and are trying to glimpse rent houses Cap D ail and homes for rent Cap D ail can look this site, FRBO.com and our lakeside lists of marked properties, log directories, and log classifieds.
FRBO.Com, For Rent By Owner, comprises square and zone notes, oftentimes.
Locate and observe vacation rentals in Carcassonne and house rentals in Carcassonne France.
Apartments for rent in Katavati, rental homes in Katavati Greece, and rental properties in Katavati Greece
We organized, concocted, and constituted this site, FRBO.com to be magnificent and fine.
The Cap D ail directories tabbed and polled on this site, FRBO.com except loft duplex, city ranch, well appointed vacation home, and suburban condominium.
Observe and notice rental home and Albertville France real estate rentals.
See suburban directories and convenient online MLS that condo owners and landlords post on our online website, FRBO.com.
San Venanzo houses for rent and for rent by owner homes in San Venanzo
Cap D ail France is a handsome, sightly, and pleasing locality with statuesque, divine, foxy, and foxy bungalow and houses.
Cap D ail condo owners and real estate agents list bed and breakfast rentals Cap D ail France and vacation homes Cap D ail France.
Our for rent by owner website does embody bizarre stretch resort, romantic, secluded, and studio house, apartment, and houseboats.
|
|
