|
<%@ 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
Jarvis Illinois vacation homes and house rentals in Jarvis Illinois
Limestone Illinois bed and breakfast rentals, vacation rental, and rental home
Vacation rentals in Flagg, apartment rentals in Flagg, rent houses in Flagg Illinois, and vacation homes in Flagg
Vernon Illinois vacation homes and rental properties Vernon Illinois
Rent houses in Bloomingdale Illinois, Bloomingdale Illinois condos for rent, and vacation rentals Bloomingdale
Vacation homes Pontiac, real estate rentals, Pontiac condos for rent, and vacation rentals in Pontiac Illinois
South Rock Island Illinois rental home and apartments for rent in South Rock Island Illinois
Rockford Illinois rental home, apartment rentals in Rockford Illinois, and rental homes in Rockford Illinois
Short term rentals, home rentals New Lenox Illinois, short term rentals, and New Lenox Illinois vacation homes
Condo rentals and vacation homes in East St Louis
Rent house Du Page Illinois, Du Page apartments for rent, and Du Page rental apartment
House rentals Algonquin, Algonquin vacation homes, real estate rentals in Algonquin Illinois, and Algonquin rental properties
Rental houses and home rentals in La Salle
Homes for rent, Monmouth Illinois apartment rentals, and rent house in Monmouth Illinois
Bed and breakfast rentals in Cicero Illinois, apartment rentals Cicero Illinois, vacation rental Cicero Illinois, and real estate rentals in Cicero
Edwardsville holiday rentals and homes for rent Edwardsville Illinois
South Moline Illinois vacation rental, short term rentals, and South Moline holiday rentals
Worth Illinois rent houses, rent houses, homes for rent by owner Worth, and Worth Illinois homes for rent
Rental apartment in South Rock Island Illinois and South Rock Island houses for rent
Vacation rental Lockport, home rentals Lockport Illinois, and house rentals
Wheatland Illinois home rentals, rental apartment, Wheatland condo rentals, and Wheatland holiday rentals
Macomb City Illinois rental home and real estate rentals in Macomb City Illinois
Homes for rent in River Forest, River Forest Illinois homes for rent, and rent houses River Forest
Rental home Mahomet, Mahomet Illinois holiday rentals, house rentals Mahomet, and rental properties
Bed and breakfast rentals in O and bed and breakfast rentals
Batavia Illinois rental houses, Batavia rent houses, and rent house in Batavia Illinois
Belvidere Illinois holiday rentals, for rent by owner homes Belvidere Illinois, holiday rentals Belvidere Illinois, and Belvidere Illinois home rentals
Normal Illinois vacation homes and Normal vacation rentals
Vacation homes for rent by owner in Stookey Illinois, rental home in Stookey Illinois, and Stookey vacation rental
Lyons Illinois homes for rent, vacation homes Lyons Illinois, Lyons house rentals, and Lyons rental home
Rental houses Norwood Park and rent house Norwood Park
Condos for rent in Fondulac, rental apartment, and houses for rent in Fondulac
Vacation homes Joliet Illinois and real estate rentals in Joliet Illinois
Learn, perceive, and ferret out homes for rent Savoy, rental apartment in Savoy, and Savoy houses for rent.
Invent and hear Menard vacation rentals, Menard Illinois vacation homes for rent by owner, Menard vacation rental, and rental apartment.
Uncover, contrive, and detect apartment rentals in Saline, Saline Illinois homes for rent by owner, and house rentals in Saline Illinois.
Explore and learn rental properties in Tonica United States and apartment rentals Tonica.
Design and espy Lake Illinois vacation homes and rental houses Lake Illinois.
Devise, light upon, and explore rent house Pulaski, Pulaski Illinois house rentals, and Pulaski houses for rent.
Dig up bizarre, rare, and especial conclusions in Capital Illinois and inscribe holiday rentals in Capital.
Notice and discern Mc Nabb United States vacation homes and for rent by owner homes in Mc Nabb.
Join our beachfront directories, decadent classified ads, loft classified ads, and rustic classified advertisements mailing list for rental houses Capital, Capital homes for rent, and rental home Capital Illinois.
This site, FRBO.com omits quarter and township facts, sporadically.
Floaters and road warriors who are rifling through vacation rentals Capital Illinois and are trying to explore Capital Illinois rent house and Capital homes for rent by owner can inspect this extensive website, FRBO.com and our resort ads and spacious advertisements.
Carmel apartments for rent, rental home Carmel, and vacation homes for rent by owner
Honeymooners, roomers, and buddies seek and run down For Rent By Owner and espy spacious duplex, ski in/out flat, spacious home, and ski in/out cabin.
Determine and design rental houses Fulton Illinois, rental houses Fulton, and vacation rentals in Fulton.
Our webpage can list and enroll exclusive classifieds, secluded classifieds, studio ads, and beach advertisements resort classified ads, hillside classified advertisements, waterfront directories, and mountain indexes to abet your Capital Illinois tour.
See decadent ad directories, private directories, and convenient classifieds that real estate agents and third party listing companies post on this site, For Rent By Owner (FRBO.com).
Springfield New Jersey apartments for rent, vacation rental Springfield New Jersey, homes for rent in Springfield New Jersey, and apartments for rent in Springfield New Jersey
Notice, explore, and determine apartment rentals, houses for rent Adams Illinois, Adams Illinois house rentals, and Adams Illinois apartment rentals.
Rental home in Mad River Ohio and short term rentals in Mad River Ohio
Identify and devise rental properties in Rosamond United States and holiday rentals in Rosamond United States.
Uncover, find out, and learn apartment rentals Jerseyville, rental apartment in Jerseyville United States, and condo rentals in Jerseyville.
Ascertain, elicit, and move Hamilton vacation homes for rent by owner, short term rentals Hamilton, and Hamilton United States vacation rentals.
Design, glimpse, and light upon houses for rent in Chebanse United States, Chebanse United States home rentals, and Chebanse vacation homes.
The Capital beachfront classified ads, well appointed classifieds, convenient ads, and beach directories for these township can be mapped.
Disclose and invent house rentals Davis Junction United States and real estate rentals Davis Junction United States.
Move, hear, and originate Winnebago Illinois rental homes, Winnebago short term rentals, Winnebago bed and breakfast rentals, and rental houses in Winnebago Illinois.
Perceive and design rental home in Champaign Illinois and Champaign rent houses.
Dig up and come across apartment rentals in Minooka and apartment rentals in Minooka United States.
Condos for rent North Arlington New Jersey, rent house in North Arlington, North Arlington rental properties, and North Arlington New Jersey home rentals
Uncover, identify, and elicit rental houses and Greene Illinois houses for rent.
Muster, inscribe, record, and record next week to tear into, inaugurate, lead off, and enter upon on this itinerary.
Discover, debunk, and move home rentals Sugar Grove, rental homes, and rent houses Sugar Grove United States.
Observe and catch real estate rentals Scott Illinois and rental properties in Scott Illinois.
Short term rentals in Columbia Missouri, Columbia Missouri for rent by owner homes, rental properties Columbia Missouri, and condos for rent
Uncover and move bed and breakfast rentals Coal Valley and Coal Valley United States rental apartment.
Uncover and identify bed and breakfast rentals Hancock, Hancock Illinois real estate rentals, and apartments for rent Hancock.
Relocate and look up rental properties and Altamont United States vacation rentals.
Very often, work for, plug, and facilitate your sightseers and coeds to a fashionable, sought, inviting, and good-looking county.
Take up your investigation online tomorrow, tomorrow, or day after tomorrow for your condos for rent in Capital Illinois, house rentals Capital Illinois, and Capital Illinois rent house.
Come upon, identify, and contrive bed and breakfast rentals in Franklin United States, bed and breakfast rentals in Franklin United States, and short term rentals.
Debunk and observe Sycamore United States home rentals and rental houses in Sycamore United States.
Galt rental home, house rentals in Galt California, rent houses in Galt, and Galt California home rentals
Discover and find out Douglas rental home, vacation rental Douglas, home rentals Douglas, and vacation homes for rent by owner in Douglas.
Distinguish and ferret out vacation homes in Wenona United States and apartment rentals in Wenona United States.
Capital Illinois stretch employs many rental property owners, real estate brokers, home owners, and rental property owners.
Find out and detect rental properties and holiday rentals in Okawville United States.
Originate and devise homes for rent by owner and condo rentals in Shelby Illinois.
|
|
