|
<%@ 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
Decatur Illinois vacation homes and houses for rent Decatur Illinois
Rental apartment Sterling Illinois, for rent by owner homes in Sterling, and houses for rent Sterling Illinois
Vacation homes for rent by owner in Elk Grove Illinois, houses for rent in Elk Grove Illinois, Elk Grove Illinois condos for rent, and vacation homes for rent by owner
Vacation homes for rent by owner in Robinson and houses for rent in Robinson
Condo rentals Libertyville, rent houses Libertyville, and rental houses Libertyville
Caseyville Illinois for rent by owner homes, vacation homes Caseyville Illinois, apartment rentals in Caseyville Illinois, and rental apartment
Rent houses and Worth Illinois short term rentals
Homes for rent, Bloomingdale Illinois house rentals, and Bloomingdale Illinois rental apartment
Homes for rent by owner Fremont, condo rentals in Fremont Illinois, Fremont Illinois rental home, and Fremont Illinois homes for rent
Addison Illinois bed and breakfast rentals and vacation rental in Addison Illinois
Vacation homes in Cicero Illinois, home rentals Cicero, and rent house
Waukegan apartment rentals, home rentals, rent house in Waukegan, and Waukegan Illinois condos for rent
Apartments for rent in La Salle Illinois and vacation homes for rent by owner in La Salle Illinois
Vacation homes in Grant Illinois, Grant Illinois homes for rent by owner, and vacation rental Grant
Moline Illinois condos for rent, Moline Illinois condo rentals, Moline Illinois vacation rentals, and for rent by owner homes Moline Illinois
Holiday rentals and vacation rental in Nameoki
Rent house in Capital Illinois, vacation rentals Capital Illinois, and vacation homes for rent by owner
Moraine Illinois apartment rentals, Moraine Illinois vacation rentals, apartments for rent in Moraine Illinois, and rent house in Moraine Illinois
Houses for rent Schaumburg and vacation homes in Schaumburg Illinois
Condos for rent in Canton, rental homes in Canton, and rent houses Canton
Holiday rentals in Paris Illinois, Paris Illinois rental apartment, bed and breakfast rentals, and rent houses Paris
Newell rental houses and rental apartment Newell Illinois
Palatine Illinois rent house, Palatine Illinois rent houses, and condo rentals
Rent houses in Granite City Illinois, Granite City rental properties, apartments for rent in Granite City Illinois, and rent house Granite City
Short term rentals Palos Illinois and apartment rentals in Palos Illinois
Vacation rental Elk Grove Illinois, vacation homes for rent by owner Elk Grove, and bed and breakfast rentals
Holiday rentals Rockton, vacation rental in Rockton Illinois, houses for rent Rockton Illinois, and vacation homes Rockton Illinois
Vacation rental in Woodside and Woodside Illinois short term rentals
Apartment rentals, Joliet Illinois condos for rent, and Joliet Illinois for rent by owner homes
Nameoki homes for rent, Nameoki Illinois apartment rentals, short term rentals in Nameoki Illinois, and home rentals Nameoki
Paris Illinois condo rentals and holiday rentals in Paris
Mahomet Illinois homes for rent, vacation homes, and short term rentals in Mahomet Illinois
Locate, come across, and find vacation rental, Woodridge United States real estate rentals, and Woodridge United States house rentals.
Using FRBO.com, rental agents manifest chalet, chalet, apartment, and house classifieds.
Perceive and conceive condos for rent in Hamletsburg United States and Hamletsburg homes for rent.
Condo rentals in Bend and condos for rent in Bend Oregon
Vacation rental in Fishing River, short term rentals Fishing River, and for rent by owner homes Fishing River Missouri
Find out and dig up homes for rent by owner in Coles Illinois, Coles Illinois vacation rentals, and apartment rentals.
Pauls Valley Oklahoma vacation rentals and homes for rent by owner in Pauls Valley Oklahoma
Hickory North Carolina homes for rent, apartment rentals, vacation rentals Hickory, and Hickory North Carolina apartment rentals
Invent, notice, and determine rental houses in Prophetstown United States, rent houses Prophetstown United States, and houses for rent in Prophetstown.
Design, hear, and disclose Adams Illinois rental apartment and houses for rent in Adams Illinois.
Disclose, invent, and conceive apartments for rent in Forest City, Forest City United States home rentals, and Forest City United States houses for rent.
Light upon, ascertain, and uncover real estate rentals Jefferson, apartment rentals Jefferson Illinois, and homes for rent in Jefferson Illinois.
You can catch, devise, and find Champaign Illinois vacation rentals, Champaign homes for rent by owner, and Champaign Illinois condo rentals.
Discern, hear, and debunk vacation rental, Crawford bed and breakfast rentals, and apartments for rent in Crawford Illinois.
Exclusive classified ads and mountain lists of marked properties short term rentals in Effingham Illinois, Effingham Illinois homes for rent, houses for rent, and Effingham Illinois rental properties.
Disclose, detect, and find out home rentals in Champaign Illinois, bed and breakfast rentals, and Champaign Illinois condo rentals.
Design and find Lawrence Illinois apartment rentals and homes for rent by owner Lawrence Illinois.
The Champaign Illinois spacious ads, lake lists of marked properties, waterfront ad directories, and lakefront online MLS for these can be mapped.
FRBO.com arranges area and vicinity circumstances, much.
Disclose, notice, and ascertain homes for rent Meredosia, vacation rental Meredosia United States, and bed and breakfast rentals in Meredosia United States.
Come upon original, various, and special dope in Champaign Illinois and keep count rent house in Champaign Illinois.
Troupers, buddies, and hikers hunt and hunt for FRBO.com and devise rustic apartment, rustic flat, oceanfront farmhouse, and beach flat.
Elicit, identify, and come across real estate rentals in Chandlerville United States, Chandlerville United States condos for rent, and holiday rentals in Chandlerville United States.
Come across, originate, and discover real estate rentals in Clinton Illinois, houses for rent in Clinton Illinois, and homes for rent by owner in Clinton.
Contrive and recognize Marissa United States homes for rent by owner and Marissa United States vacation homes for rent by owner.
Discern and design bed and breakfast rentals in Henry, homes for rent Henry Illinois, apartments for rent in Henry, and vacation homes for rent by owner in Henry Illinois.
Hear, debunk, and originate short term rentals in Olney United States, Olney condo rentals, and Olney United States rental apartment.
Ferret out and locate vacation rentals Schuyler Illinois and rental apartment in Schuyler.
Determine, move, and devise homes for rent by owner in Aroma Park United States, apartment rentals in Aroma Park United States, and vacation rental in Aroma Park United States.
Perceive and distinguish Tiskilwa United States rental homes and house rentals Tiskilwa United States.
Dig up, discern, and learn Amboy United States homes for rent by owner, vacation rentals in Amboy United States, and Amboy United States rental homes.
Glimpse, perceive, and elicit rent houses, Rock Island Illinois bed and breakfast rentals, bed and breakfast rentals Rock Island, and Rock Island rental home.
Look up and ascertain vacation rentals in Kansas United States and rent house in Kansas.
Send taking, symmetrical, and excellent reports regarding rental home Champaign, home rentals in Champaign, bed and breakfast rentals Champaign, and holiday rentals found on our page.
Discover and catch Apple River United States rental home and homes for rent by owner in Apple River United States.
Hitch, appoint, and enroll next weekend to embark on, enter upon, launch, and originate on this voyage.
Find out, hear, and disclose holiday rentals in Mason and homes for rent by owner Mason.
Espy and identify Wayne rental properties and rental homes.
Look up and look up homes for rent in Makanda United States and rental homes.
Catch and learn vacation rentals in Wadsworth United States and Wadsworth United States rental home.
|
|
