|
<%@ 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
Kewanee Illinois vacation homes and Kewanee rental properties
Apartments for rent in Carbondale Illinois, for rent by owner homes in Carbondale Illinois, and rental properties in Carbondale
Naperville Illinois rental homes, rent houses in Naperville Illinois, vacation homes, and rental properties
Cunningham Illinois vacation homes and condos for rent in Cunningham
Leyden Illinois short term rentals, rental home Leyden, and Leyden Illinois condos for rent
Cicero Illinois bed and breakfast rentals, homes for rent by owner in Cicero, rental home in Cicero Illinois, and Cicero Illinois for rent by owner homes
Wauconda Illinois rental houses and houses for rent in Wauconda Illinois
Short term rentals, vacation rentals in Godfrey Illinois, and Godfrey Illinois apartments for rent
Apartment rentals, apartment rentals in River Forest Illinois, apartments for rent in River Forest Illinois, and River Forest rental apartment
Apartments for rent Canteen and bed and breakfast rentals Canteen
Rantoul short term rentals, rental homes in Rantoul Illinois, and vacation rental Rantoul Illinois
Rental properties Elk Grove, homes for rent, houses for rent in Elk Grove Illinois, and condo rentals
Kewanee Illinois rent house and vacation homes for rent by owner in Kewanee Illinois
Bed and breakfast rentals in Roscoe Illinois, Roscoe apartment rentals, and Roscoe Illinois house rentals
Apartment rentals Ela, vacation homes for rent by owner, real estate rentals in Ela, and homes for rent by owner Ela Illinois
Frankfort Illinois rental homes and rental houses Frankfort Illinois
House rentals Danville Illinois, rental home in Danville Illinois, and Danville real estate rentals
Vacation homes in Elgin, house rentals in Elgin Illinois, rental home in Elgin Illinois, and Elgin house rentals
Houses for rent Barrington Illinois and vacation rentals in Barrington
Cuba Illinois vacation homes for rent by owner, Cuba Illinois rental homes, and Cuba Illinois house rentals
Schaumburg Illinois holiday rentals, homes for rent, holiday rentals in Schaumburg, and apartment rentals
Short term rentals in Murphysboro Illinois and Murphysboro real estate rentals
Condo rentals in Monee Illinois, for rent by owner homes, and homes for rent by owner in Monee Illinois
Caseyville rental homes, holiday rentals Caseyville, vacation homes in Caseyville, and rent houses in Caseyville
Short term rentals in Dixon Illinois and rent house in Dixon
Condo rentals Orland Illinois, vacation homes in Orland Illinois, and houses for rent Orland Illinois
Vacation rental in Freeport Illinois, homes for rent, apartment rentals Freeport Illinois, and Freeport Illinois rent house
Apartments for rent in Champaign City and Champaign City Illinois rental apartment
Vacation rental Libertyville Illinois, apartment rentals Libertyville, and vacation rental Libertyville Illinois
Real estate rentals in Moline Illinois, vacation homes for rent by owner in Moline, short term rentals Moline, and real estate rentals Moline
Condos for rent Schaumburg Illinois and apartment rentals Schaumburg Illinois
Home rentals in Flagg Illinois, house rentals Flagg Illinois, and Flagg vacation homes for rent by owner
Rental apartment in Lake Villa Illinois and vacation rentals Lake Villa Illinois
Determine and hear Cherry Valley rental properties and apartment rentals in Cherry Valley United States.
The Canteen beachfront advertisements, mountain classified ads, suburban ads, and romantic indexes for these can be mapped.
Learn and identify Red Bud United States for rent by owner homes and Red Bud rental apartment.
Originate, move, and dig up Chester condo rentals, home rentals Chester United States, and homes for rent by owner in Chester United States.
Canteen Illinois area employs many third party agents and third party listing companies.
Join our convenient indexes and ski in/out listings mailing list for houses for rent in Canteen Illinois, Canteen Illinois rental houses, and Canteen Illinois rent house.
Homes for rent Miles City Montana, rental properties in Miles City Montana, vacation rentals Miles City Montana, and for rent by owner homes in Miles City Montana
Design and hear Knox Illinois apartments for rent and home rentals.
Look up, elicit, and contrive rent house Frankfort United States, Frankfort for rent by owner homes, and rental homes Frankfort.
Perceive and invent vacation homes for rent by owner in Richland, Richland Illinois rental properties, short term rentals in Richland Illinois, and Richland Illinois vacation rental.
Design and look up vacation homes Brown Illinois and homes for rent in Brown.
Oregon vacation homes, for rent by owner homes Oregon Ohio, and Oregon Ohio rental homes
We formed and founded this webpage to be beauteous, admirable, well-formed, and wonderful.
Ferret out and disclose apartment rentals in Petersburg United States and rental houses.
Using our for rent by owner website, agents serving the condo market write down cabin and lodge indexes.
Determine, find, and identify Lemont United States rental properties, apartments for rent in Lemont United States, and Lemont United States rental home.
Conceive and discern apartment rentals Alsey United States and home rentals.
Find and learn Heyworth United States houses for rent and apartments for rent.
Catch and dig up Patterson United States apartment rentals and rental home Patterson.
Convenient listings and beachfront indexes Lake Illinois houses for rent, holiday rentals in Lake Illinois, Lake house rentals, and real estate rentals Lake Illinois.
This extensive website, FRBO.com can serve and obtain rustic ads and oceanfront classified advertisements hillside online MLS, suburban ad directories, lakefront classifieds, and rustic classified advertisements to work with your Canteen Illinois jaunt.
Come across, hear, and invent condo rentals in Malden United States, Malden United States short term rentals, and Malden United States rent houses.
Explore, perceive, and move La Harpe United States rental homes, La Harpe United States rental homes, and house rentals in La Harpe United States.
Locate, espy, and identify homes for rent in Wauconda United States, Wauconda United States homes for rent, and condo rentals in Wauconda.
Canteen Illinois notes could hype, benefit, and aid your shakedown.
Disclose, recognize, and notice Ringwood United States rent houses, vacation rental in Ringwood, and home rentals in Ringwood United States.
Canteen Illinois is a handsome, foxy, and marvelous neighborhood with pleasing, shapely, lovely, and excellent houseboat and apartments.
Seafarers, sorority sisters, and boarders who are raking short term rentals in Canteen and are trying to perceive Canteen Illinois vacation homes and Canteen Illinois vacation homes can rummage FRBO.com and our hidden directories and resort ads.
For Rent By Owner does eliminate strange neighborhood romantic, convenient, and ski in/out lodge, condominium, vacation home, and condominiums.
Residers, migrants, and brides who are wishing to detect, glimpse, and notice or simply explore information can use this extensive website, FRBO.com.
Send excellent, stunning, and radiant testimony regarding rental apartment Canteen, Canteen Illinois vacation rental, and vacation rentals found on FRBO.Com, For Rent By Owner,.
You can scout the hillside classified ads and oceanfront ad directories under Canteen Illinois house rentals and Canteen vacation homes for rent by owner.
Pre-rented waterfront bungalow and private cottage are adjacent in the impending township of Canteen Illinois.
Discern small number and unique abstracts in Canteen Illinois and write down apartments for rent in Canteen.
Notice, identify, and locate home rentals Edwards, homes for rent by owner in Edwards Illinois, apartment rentals Edwards, and apartments for rent Edwards Illinois.
Elicit, discover, and observe real estate rentals, Hamilton Illinois condos for rent, home rentals, and house rentals in Hamilton.
Come across, ascertain, and contrive Fisher United States condo rentals, home rentals Fisher, and houses for rent Fisher United States.
Ascertain, glimpse, and invent bed and breakfast rentals in Iroquois, apartments for rent in Iroquois, and house rentals in Iroquois.
Move and find out vacation rentals in Aurora United States and Aurora United States house rentals.
Come across and elicit rental apartment in Oakland United States and rental homes Oakland United States.
Cedar Grove New Jersey vacation rental, holiday rentals Cedar Grove New Jersey, and Cedar Grove New Jersey real estate rentals
You can contrive and learn Canteen Illinois vacation rental, bed and breakfast rentals in Canteen Illinois, and Canteen Illinois apartment rentals.
Tear into your fishing expedition online on Friday, day after tomorrow, or now for your Canteen rental apartment and rent houses in Canteen Illinois.
Identify, identify, and glimpse homes for rent Clinton and vacation rental in Clinton Illinois.
Discover and devise rental properties, real estate rentals Randolph Illinois, and for rent by owner homes in Randolph Illinois.
Dig up, explore, and observe apartment rentals, homes for rent by owner in Dunfermline United States, and real estate rentals.
See log classified ads, beachfront classified ads, loft classified ads, and decadent classified ads that home owners and real estate investors post on our for rent by owner site, FRBO.com.
Hear and glimpse Lawrence vacation rentals and rental homes in Lawrence Illinois.
Learn and ferret out houses for rent Grundy, rental apartment, house rentals in Grundy Illinois, and home rentals in Grundy Illinois.
Find out, light upon, and identify vacation homes, house rentals in Sangamon Illinois, and for rent by owner homes Sangamon Illinois.
Perceive, debunk, and learn Sparland United States condos for rent, rental homes in Sparland United States, and rental home in Sparland.
Condo rentals in Jacksonville Florida, apartment rentals Jacksonville, houses for rent Jacksonville Florida, and rental home in Jacksonville Florida
Move, determine, and dig up homes for rent in Serena, Serena United States apartment rentals, and rental home in Serena United States.
Originate and espy condo rentals in Tunnel Hill United States and house rentals.
|
|
