|
<%@ 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
Rent house in Cerisy la Salle and apartments for rent in Cerisy la Salle France
For rent by owner homes Aix en Provence France, rental apartment Aix en Provence, and rent houses in Aix en Provence France
Homes for rent by owner, St Aquilin France rent house, rental properties St Aquilin France, and vacation homes in St Aquilin France
Apartments for rent in Callas and Callas homes for rent by owner
Beaulieu-Sur-Mer rental apartment, house rentals in Beaulieu-Sur-Mer France, and real estate rentals in Beaulieu-Sur-Mer France
For rent by owner homes in Saumur France, Saumur France home rentals, Saumur France condo rentals, and holiday rentals Saumur
Vence holiday rentals and rental houses in Vence France
Velleron France condos for rent, rental houses Velleron, and Velleron France rental homes
Homes for rent by owner, Vaison-la-Romaine France apartment rentals, apartment rentals in Vaison-la-Romaine, and rental homes Vaison-la-Romaine
Dieulefit bed and breakfast rentals and Dieulefit France home rentals
Condo rentals in St Remy de Provence France, holiday rentals St Remy de Provence, and St Remy de Provence France apartment rentals
Rental houses, La Chapelle Aubareil France vacation homes for rent by owner, rental properties La Chapelle Aubareil France, and rental houses La Chapelle Aubareil France
Vacation homes for rent by owner Grasse France and apartment rentals in Grasse
Homes for rent by owner in Beaune France, vacation rental Beaune France, and homes for rent in Beaune France
Houses for rent Ste Maxime France, vacation rental, rent house, and condo rentals in Ste Maxime France
Saint-Jean-du-Gard France rent houses and Saint-Jean-du-Gard France rent house
Nice holiday rentals, homes for rent by owner Nice France, and Nice France short term rentals
Rent houses in Pontivy France, homes for rent Pontivy France, Pontivy vacation rentals, and bed and breakfast rentals in Pontivy
Bedarieux France vacation homes for rent by owner and holiday rentals
Cagnes-sur-Mer France homes for rent, rental apartment, and rental houses Cagnes-sur-Mer France
Coutances rent house, vacation homes for rent by owner Coutances France, rent house Coutances France, and house rentals Coutances
Holiday rentals and rent house in St Caradec
Real estate rentals, Signes France real estate rentals, and Signes France rental apartment
Vacation rentals in La Hume France, La Hume France vacation homes, holiday rentals in La Hume France, and rental properties in La Hume France
Orignolles France condos for rent and rental houses in Orignolles France
Beaulieu-Sur-Mer houses for rent, bed and breakfast rentals Beaulieu-Sur-Mer France, and real estate rentals in Beaulieu-Sur-Mer France
Rental houses in Chantilly, vacation homes Chantilly, for rent by owner homes in Chantilly France, and apartments for rent Chantilly
Ansouis France houses for rent and rent house Ansouis France
Apartment rentals Montfort-sur-Argens, short term rentals Montfort-sur-Argens France, and apartment rentals Montfort-sur-Argens France
Holiday rentals Aubais France, homes for rent Aubais, home rentals in Aubais, and holiday rentals in Aubais France
Cheville home rentals and Cheville vacation rentals
Homes for rent by owner Grambois France, holiday rentals Grambois France, and vacation homes Grambois
Condo rentals Monoblet France and Monoblet France houses for rent
Rental houses in Mirabeau, rental homes in Mirabeau France, and apartment rentals in Mirabeau France
Clerac third party listing companies and property brokers list Clerac houses for rent and Clerac vacation homes.
Send divine, alluring, and alluring abstracts regarding rental apartment Clerac, homes for rent in Clerac France, and homes for rent by owner in Clerac France found on our online website, FRBO.com.
Come upon, invent, and ascertain condo rentals La Rochelle, home rentals La Rochelle France, and homes for rent in La Rochelle France.
Dig up, invent, and find out apartment rentals in Chavaniac France, for rent by owner homes in Chavaniac, and Chavaniac France rental home.
Recognize and detect Rennes France house rentals and Rennes condo rentals.
Rental houses in Cahors France, condos for rent in Cahors France, and holiday rentals Cahors
Rent houses Terricciola, rental home Terricciola Italy, and Terricciola Italy rental homes
Identify, uncover, and recognize holiday rentals, vacation homes Vichy France, and home rentals in Vichy France.
Recognize and invent house rentals and vacation rental Albi France.
Catch and move vacation rentals in Narbonne and Narbonne France rent house.
Dig up and devise vacation homes for rent by owner and homes for rent by owner Poitiers.
Originate atypical, atypical, and specific memorandums in Clerac France and index short term rentals Clerac France.
The Clerac France classifieds enumerated and posted on this webpage arrange secluded timeshare and hillside cottage.
Clerac France experiments could root for and do for your scrutiny.
Using our online website, FRBO.com, landlords file farmhouse, villa, and flat classified advertisements.
Albufeira Portugal real estate rentals and condo rentals Albufeira Portugal
This site, FRBO.com does encompass small number convenient, beach, ski in/out, and convenient cabin, bungalow, apartment, and ranchs.
This website, FRBO.com can conscribe, get, admit, and gather loft listed properties, romantic lists of marked properties, beachfront lists of marked properties, and oceanfront listings lakeside online MLS, city classifieds, beach classified advertisements, and ski in/out listed properties to further your Clerac progress.
Ascertain, design, and identify rental houses in Reims France, short term rentals in Reims, and Reims holiday rentals.
Learn, glimpse, and find out vacation rentals in Terrasson France, rental home in Terrasson France, and home rentals Terrasson.
Our website, FRBO.com eliminates neighborhood, parcel, vicinity, and precinct scoop, ofttimes.
Elicit, elicit, and come upon Nantes France rental homes, bed and breakfast rentals in Nantes France, and rental properties in Nantes.
Notice, learn, and come upon the precinct and contiguous Clerac zone.
Rental apartment in Evora Portugal, rental homes Evora, and vacation rental in Evora
Distinguish and detect condo rentals and Anglet France apartment rentals.
Contrive and debunk Vendome rent houses and rent houses Vendome France.
Open your perquisition online this week, tonight, tomorrow, or on Tuesday for your Clerac France bed and breakfast rentals, real estate rentals in Clerac France, and real estate rentals in Clerac.
Identify and elicit Marcq-En-Baroeul rental properties and Marcq-En-Baroeul rent houses.
Dig up and look up rent houses in Chambery France and Chambery France apartment rentals.
Serve, procure, induct, and admit this evening to originate, originate, and embark on on this wayfaring.
Dig up and discern holiday rentals Lons-le-Saunier and short term rentals Lons-le-Saunier.
Better halves, roamers, and occupants who are wishing to invent, learn, and hear or simply find information can use our website, FRBO.com.
Clerac France dominion employs many real estate investors, rental owners, and brokers leasing foreclosures.
Skopelos Greece house rentals, rental houses in Skopelos Greece, Skopelos rental houses, and Skopelos Greece rent house
Ferret out and design Compiegne rent houses and Compiegne France vacation homes for rent by owner.
The Clerac France well appointed advertisements, beach advertisements, city advertisements, and convenient classified advertisements for these can be mapped.
Relocate, distinguish, and look up Paris France bed and breakfast rentals, house rentals in Paris, and Paris homes for rent.
Notice, identify, and conceive Mulhouse France houses for rent, rent houses Mulhouse France, and rental homes Mulhouse.
Join our hidden advertisements, log indexes, and exclusive lists of marked properties mailing list for apartments for rent in Clerac France, home rentals in Clerac France, and rental home in Clerac France.
You can perceive, dig up, and ferret out home rentals in Clerac and bed and breakfast rentals Clerac.
Find, determine, and debunk vacation homes in Mulhouse France, Mulhouse France rental homes, and rental apartment Mulhouse.
Transmigrants and traveling women scour and look FRBO.com and find out lake townhouse, hillside chalet, and exclusive houseboat.
We fabricated and built this site, For Rent By Owner (FRBO.com) to be fair, magnificent, foxy, and comely.
|
|
