|
<%@ 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" %>
|
Illinois Rental Links
Homes for rent by owner in Wayne Illinois and Wayne condo rentals
Condo rentals Limestone, apartments for rent Limestone, and holiday rentals
Bloomingdale rental houses, homes for rent Bloomingdale, Bloomingdale Illinois vacation homes for rent by owner, and Bloomingdale Illinois rent house
Real estate rentals in Thornton and rental properties in Thornton
Vacation rental, homes for rent by owner Campton, and rental home
Condo rentals Oak Park Illinois, homes for rent by owner in Oak Park Illinois, Oak Park Illinois for rent by owner homes, and holiday rentals in Oak Park
Apartment rentals and Coloma vacation homes for rent by owner
Apartments for rent Mahomet, real estate rentals, and houses for rent in Mahomet
Rent house in Du Page Illinois, rent house in Du Page Illinois, condos for rent Du Page Illinois, and vacation homes for rent by owner in Du Page Illinois
Homes for rent in Crete and Crete Illinois rent house
Crete Illinois rent houses, rental properties in Crete, and Crete Illinois vacation rentals
Joliet Illinois rental home, rental properties, condo rentals in Joliet Illinois, and Joliet Illinois home rentals
Hampton Illinois holiday rentals and vacation rental in Hampton Illinois
Rental houses Nameoki, rental houses in Nameoki, and rental home in Nameoki Illinois
Real estate rentals in Orland, rental apartment Orland Illinois, Orland Illinois real estate rentals, and rent house Orland
Home rentals in East St Louis Illinois and home rentals East St Louis
Vacation rentals in Galesburg City, Galesburg City holiday rentals, and apartments for rent
Algonquin Illinois holiday rentals, homes for rent in Algonquin Illinois, real estate rentals in Algonquin Illinois, and vacation homes for rent by owner Algonquin
Vacation rentals in Northfield Illinois and bed and breakfast rentals Northfield
Vacation rentals Bloomingdale Illinois, rental apartment, and Bloomingdale Illinois rent house
Rental apartment, vacation rentals, Wheeling homes for rent, and rental homes in Wheeling Illinois
Barrington Illinois details could work for and serve your perquisition.
Discern and invent rent house Montgomery and Montgomery Illinois short term rentals.
Espy and determine Vandalia United States houses for rent and Vandalia United States rental houses.
Discover and light upon for rent by owner homes in Edgar Illinois, Edgar Illinois homes for rent by owner, and rental home.
Identify and come upon holiday rentals, short term rentals in Fulton Illinois, homes for rent Fulton, and Fulton Illinois apartments for rent.
Light upon, learn, and identify rental apartment McHenry, rental home McHenry, and house rentals McHenry Illinois.
Hear special, rare, and several circumstances in Barrington Illinois and enumerate houses for rent in Barrington Illinois.
Barrington rental owners, real estate investors, property agents, and real estate agents list condos for rent in Barrington Illinois and apartment rentals in Barrington Illinois.
Move, find out, and light upon house rentals in Harvard United States, rental apartment Harvard, and vacation rental Harvard United States.
You can poke into the exotic directories, mountain ads, and romantic ads under Barrington Illinois holiday rentals and vacation rentals Barrington Illinois.
Dig up and elicit rent houses in Crossville and homes for rent.
Send enticing, classy, resplendent, and foxy poop regarding rental apartment in Barrington Illinois and Barrington Illinois house rentals found on this site, FRBO.com.
Perceive, identify, and invent Metamora United States vacation homes for rent by owner, rental homes Metamora, and homes for rent by owner in Metamora.
Identify, find, and devise Champaign Illinois apartment rentals, for rent by owner homes, and vacation homes for rent by owner Champaign.
See exclusive listings and oceanfront ads that landlords and property owners post on our website, FRBO.com.
Look up, discover, and move Vermilion Illinois rent houses, homes for rent by owner in Vermilion Illinois, Vermilion for rent by owner homes, and Vermilion Illinois home rentals.
We contrived and imagined this site, FRBO.com to be admirable, admirable, and fair.
Discover, learn, and debunk Bonfield for rent by owner homes, bed and breakfast rentals in Bonfield United States, and rental houses in Bonfield United States.
Debunk and perceive vacation homes in Champaign Illinois, short term rentals, and short term rentals in Champaign Illinois.
Find out and distinguish Armstrong United States homes for rent and rental properties in Armstrong United States.
Relocate, invent, and detect vacation rental Forest City United States, real estate rentals, and vacation rentals in Forest City United States.
Explore and ferret out Buffalo Grove United States vacation homes and apartment rentals in Buffalo Grove United States.
Dig up, relocate, and ascertain rental houses Noble United States, rent houses Noble, and Noble United States rental houses.
Occupiers, adventurers, and tenants who are examining Barrington Illinois holiday rentals and are trying to find out homes for rent in Barrington, Barrington Illinois homes for rent by owner, and Barrington Illinois rental apartment can rake FRBO.Com, For Rent By Owner, and our secluded classifieds, hidden ads, hidden listings, and beachfront online MLS.
Learn and dig up rental properties Ogle Illinois, for rent by owner homes in Ogle Illinois, Ogle vacation rental, and condos for rent in Ogle Illinois.
Detect and distinguish Henry Illinois vacation rental, Henry Illinois rent houses, and vacation rental in Henry.
Locate, distinguish, and originate rental homes New Windsor United States, short term rentals, and apartments for rent New Windsor.
Determine, conceive, and come across apartments for rent Kendall Illinois, for rent by owner homes, vacation homes Kendall Illinois, and holiday rentals.
The Barrington Illinois classified ads set down and calendar on FRBO.com comprise convenient chalet and beachfront farmhouse.
FRBO.com can hire, enter into, and join exclusive advertisements and secluded directories romantic online MLS, convenient directories, and decadent classifieds to cooperate your Barrington Illinois outing.
Learn, notice, and conceive the neighborhood and approaching Barrington domain.
Explore, perceive, and conceive vacation rentals in Edgar Illinois and bed and breakfast rentals.
Distinguish, move, and identify Alexander apartment rentals, short term rentals in Alexander, rent houses, and vacation rentals in Alexander.
Discern and uncover holiday rentals and home rentals in Edgar Illinois.
Invent and devise for rent by owner homes and rental home Mounds United States.
Find and ferret out rental homes Berwyn and Berwyn vacation rental.
|
|
