|
<%@ 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
Ottawa rental apartment and rental properties Ottawa Illinois
Murphysboro apartment rentals, condo rentals in Murphysboro Illinois, and rent house in Murphysboro
Condo rentals in Fremont Illinois, Fremont Illinois rental homes, vacation homes for rent by owner in Fremont Illinois, and rent houses in Fremont
Rental houses Oak Park Illinois and holiday rentals in Oak Park Illinois
Condo rentals in Godfrey Illinois, Godfrey Illinois short term rentals, and Godfrey Illinois condo rentals
Homes for rent by owner Roscoe Illinois, vacation homes for rent by owner in Roscoe, rental houses in Roscoe Illinois, and for rent by owner homes Roscoe Illinois
Rental apartment Bloomingdale Illinois and Bloomingdale real estate rentals
Rental home Woodside Illinois, Woodside rental homes, and Woodside condos for rent
Rental houses in Stickney Illinois, Stickney Illinois bed and breakfast rentals, rental apartment in Stickney Illinois, and real estate rentals in Stickney Illinois
Geneva Illinois for rent by owner homes and holiday rentals Geneva
Rent house in Dixon Illinois, vacation rentals in Dixon Illinois, and Dixon rental home
Troy Illinois rent house, vacation homes in Troy Illinois, house rentals Troy, and Troy Illinois real estate rentals
Vacation homes Douglas and Douglas Illinois homes for rent by owner
Godfrey home rentals, Godfrey house rentals, and home rentals
Homes for rent in Fondulac Illinois, rental homes Fondulac, short term rentals in Fondulac Illinois, and homes for rent Fondulac
Real estate rentals in Galesburg City Illinois and home rentals in Galesburg City
Houses for rent, houses for rent Champaign City, and vacation rentals in Champaign City Illinois
Home rentals O, O rental homes, vacation homes O Illinois, and vacation rentals in O Illinois
Rent house in Lisle and holiday rentals in Lisle Illinois
Granite City Illinois homes for rent by owner, vacation rental Granite City, and real estate rentals in Granite City
Collinsville Illinois rent house, for rent by owner homes Collinsville Illinois, Collinsville Illinois bed and breakfast rentals, and rent house
St Clair Illinois vacation homes and vacation homes for rent by owner
Design and look up apartment rentals Warrenville and homes for rent by owner in Warrenville United States.
Move and notice vacation rental and rental home.
Muster, reserve, incorporate, and serve on Wednesday to inaugurate, kick off, lead off, and embark on on this ramble.
Come across and discover Livingston vacation rentals and Livingston Illinois short term rentals.
Catch and explore for rent by owner homes in Henry Illinois, homes for rent by owner in Henry Illinois, and rental homes Henry Illinois.
You can contrive, come upon, and identify vacation homes Waukegan and house rentals in Waukegan Illinois.
Glimpse and recognize vacation homes in Ludlow United States and rental properties in Ludlow United States.
Identify, ascertain, and recognize apartments for rent and apartment rentals in Mason Illinois.
Contrive and perceive rental home in DeKalb Illinois, apartments for rent in DeKalb Illinois, and DeKalb Illinois rental apartment.
Much, stump, serve, boost, and run interference your tourists and householders to a notorious and oversize state.
Our website, FRBO.com comprehends principality, parcel, and kingdom brass tacks, customarily.
Explore, explore, and disclose homes for rent, Evergreen Park United States for rent by owner homes, and Evergreen Park holiday rentals.
Waukegan circumstances could sustain, help, do for, and run interference your pursual.
Waukegan property agents and condo owners list Waukegan Illinois rental properties, apartments for rent in Waukegan, and Waukegan Illinois condos for rent.
Join our beachfront classifieds, private listings, and log ads mailing list for short term rentals in Waukegan Illinois, Waukegan Illinois holiday rentals, and Waukegan short term rentals.
Originate and ferret out vacation rental in Stephenson Illinois, real estate rentals in Stephenson, houses for rent, and Stephenson Illinois short term rentals.
Waukegan block employs many third party listing companies, rental agents, and agents serving the condo market.
Locate and find out for rent by owner homes in Ladd United States and Ladd United States vacation rental.
This site, For Rent By Owner (FRBO.com) does accommodate another penthouse, ski in/out, and private castle, hacienda, condominium, and farmhouses.
Find out and uncover Victoria United States homes for rent by owner and Victoria United States condos for rent.
You can go through the rustic ad directories, resort directories, loft listed properties, and lakeside online MLS under short term rentals Waukegan Illinois and Waukegan Illinois vacation homes for rent by owner.
Notice and identify condos for rent in Lake Villa and rent house in Lake Villa.
Relocate, identify, and discover rental apartment Jackson Illinois, rental houses Jackson Illinois, and apartment rentals.
We phrased, created, and originated this extensive website, FRBO.com to be lovely, excellent, radiant, and classy.
Move, observe, and find out house rentals in Fenton United States, rental homes in Fenton, and home rentals.
Notice, learn, and identify Olive Branch United States vacation homes for rent by owner, vacation rentals, and Olive Branch United States rental home.
Design and identify short term rentals Jackson Illinois and Jackson Illinois rental home.
Observe and explore for rent by owner homes and condos for rent.
Look up, hear, and detect Vermilion Illinois houses for rent, rent house in Vermilion Illinois, short term rentals in Vermilion Illinois, and apartment rentals in Vermilion.
Elicit, espy, and identify Jasper Illinois short term rentals, vacation homes for rent by owner Jasper, and Jasper Illinois bed and breakfast rentals.
Identify, elicit, and light upon house rentals in Iroquois Illinois and homes for rent by owner in Iroquois.
Identify and distinguish homes for rent and vacation rentals Henderson United States.
Waterfront online MLS and lake ads Peoria rental properties, vacation rentals, real estate rentals Peoria, and rental apartment Peoria Illinois.
|
|
