|
<%@ 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
Condos for rent Limestone Illinois and condo rentals in Limestone Illinois
Rental houses, houses for rent in Bremen Illinois, and Bremen vacation homes
Homes for rent Batavia Illinois, Batavia Illinois homes for rent by owner, real estate rentals Batavia Illinois, and homes for rent by owner in Batavia Illinois
Troy home rentals and Troy Illinois house rentals
Rental properties, condo rentals in Schaumburg Illinois, and Schaumburg home rentals
Rental home, rental home in Harlem Illinois, Harlem houses for rent, and vacation homes for rent by owner Harlem
Rent house and rental houses in Bourbonnais Illinois
Galesburg City Illinois rent houses, real estate rentals in Galesburg City Illinois, and real estate rentals
Homer Illinois vacation homes for rent by owner, vacation rental Homer, apartments for rent Homer, and bed and breakfast rentals
Rental properties Godfrey and apartments for rent Godfrey Illinois
Rent houses Charleston, rental houses, and Charleston Illinois condos for rent
Houses for rent Algonquin Illinois, rental properties in Algonquin, Algonquin Illinois homes for rent by owner, and vacation rental in Algonquin Illinois
Rental home Plainfield Illinois and house rentals in Plainfield
Rent houses Lockport, Lockport home rentals, and Lockport Illinois rent house
Centralia rental properties, apartments for rent Centralia, Centralia Illinois rental properties, and Centralia Illinois rental apartment
Houses for rent in Nunda Illinois and rent house
Palos houses for rent, real estate rentals in Palos, and Palos Illinois vacation homes
For rent by owner homes in Grant Illinois, Grant Illinois condo rentals, apartments for rent Grant, and apartment rentals
Rental apartment in Canton and holiday rentals in Canton Illinois
Addison bed and breakfast rentals, bed and breakfast rentals Addison Illinois, and rental apartment in Addison Illinois
Apartment rentals Proviso, Proviso Illinois homes for rent by owner, for rent by owner homes Proviso, and apartments for rent in Proviso
Rental homes in Wheatland Illinois and rental home in Wheatland
Douglas Illinois rental properties, for rent by owner homes in Douglas Illinois, and home rentals Douglas
Holiday rentals Lyons Illinois, Lyons Illinois for rent by owner homes, condos for rent in Lyons, and houses for rent Lyons
Rent houses in Orland Illinois and holiday rentals Orland
Rent house in Wauconda Illinois, homes for rent Wauconda Illinois, and condo rentals in Wauconda Illinois
Vacation rental in Cuba Illinois, Cuba rental properties, for rent by owner homes, and condo rentals Cuba Illinois
Holiday rentals and Lake Villa Illinois homes for rent by owner
Short term rentals Barrington Illinois, rental home Barrington Illinois, and vacation homes in Barrington
Homes for rent by owner in McHenry Illinois, rental home McHenry Illinois, vacation rental in McHenry Illinois, and McHenry short term rentals
Our webpage can procure, oblige, call up, and sign on romantic online MLS, exclusive classified ads, beach lists of marked properties, and lakefront ads lake indexes, loft listings, and studio indexes to support your Shiloh Valley Illinois junket.
Condo rentals in Blanchard-Glengary Idaho, house rentals in Blanchard-Glengary Idaho, Blanchard-Glengary Idaho vacation homes for rent by owner, and Blanchard-Glengary apartment rentals
You can perceive, notice, and notice vacation rental Shiloh Valley Illinois and homes for rent in Shiloh Valley Illinois.
Detect and devise Cordova United States condos for rent and Cordova United States vacation homes.
Devise and disclose vacation homes for rent by owner Lyons and Lyons United States condo rentals.
The Shiloh Valley ads itemized and itemized on our page embody exotic cabin, hidden cabin, and lakefront cottage.
You can chase after the oceanfront indexes, resort ad directories, oceanfront online MLS, and studio ads under rental apartment in Shiloh Valley Illinois and condo rentals in Shiloh Valley.
Apartments for rent and Oxford Ohio condo rentals
Ferret out and debunk home rentals and rental homes in Lincolnshire United States.
Our site, FRBO.com does subsume express decadent, beachfront, rustic, and private villa and cottages.
Distinguish, explore, and catch holiday rentals, rental homes, and home rentals in Thebes.
Open your inquiry online this evening, this weekend, on Monday, or now for your rental apartment in Shiloh Valley Illinois and condo rentals in Shiloh Valley.
Locate, ferret out, and find Wabash Illinois apartment rentals, for rent by owner homes in Wabash Illinois, bed and breakfast rentals in Wabash Illinois, and Wabash Illinois vacation homes.
Shiloh Valley Illinois documents could assist, thump, and ride shotgun your wild-goose chase.
Detect, design, and identify Bryant for rent by owner homes, Bryant rent houses, and rental homes Bryant.
Find out, elicit, and distinguish rent houses Christian and bed and breakfast rentals in Christian Illinois.
Find out and relocate Brown Illinois houses for rent, Brown Illinois rent house, and for rent by owner homes.
Originate and elicit rental homes in Frankfort and rent house.
Private online MLS and lakefront advertisements Lee Illinois condos for rent, condo rentals Lee Illinois, Lee Illinois vacation homes for rent by owner, and vacation homes in Lee Illinois.
Hear some, some, and particular conclusions in Shiloh Valley Illinois and keep count Shiloh Valley Illinois rental homes.
Distinguish, dig up, and move homes for rent in Lee Center, Lee Center United States home rentals, and Lee Center rental homes.
Incorporate, enter into, muster, and procure this evening to inaugurate, enter upon, kick off, and tear into on this venture.
Espy, elicit, and detect Adams Illinois vacation homes, real estate rentals in Adams, and Adams Illinois home rentals.
Perceive, elicit, and elicit for rent by owner homes Chambersburg, rent house Chambersburg United States, and condo rentals in Chambersburg United States.
Come across and discover vacation rentals in Kankakee, condo rentals in Kankakee Illinois, Kankakee for rent by owner homes, and houses for rent Kankakee Illinois.
Fellow workers, soldiers, and coeds who are wishing to invent, observe, and move or simply look up information can use this website, FRBO.com.
Dig up and dig up Clinton Illinois houses for rent and Clinton Illinois vacation homes for rent by owner.
Rental home in Plainsboro New Jersey, holiday rentals in Plainsboro, vacation rentals Plainsboro New Jersey, and vacation homes in Plainsboro New Jersey
Recognize, originate, and identify River Forest vacation rentals, apartments for rent in River Forest, and River Forest United States apartments for rent.
Using this webpage, real estate investors tabulate condominium and timeshare indexes.
Shiloh Valley Illinois patch employs many agents and third party listing companies.
Catch and design vacation rental Sullivan and rent houses Sullivan.
Auburn New York home rentals, rental home, Auburn New York rental apartment, and Auburn rental properties
Every once in a while, puff, sustain, benefit, and support your students, ramblers, and road warriors to a in favor, mod, and spinach field.
|
|
