|
<%@ 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
Oswego Illinois rent houses and apartments for rent Oswego Illinois
Short term rentals Winfield, rental properties in Winfield Illinois, and Winfield Illinois bed and breakfast rentals
For rent by owner homes in Geneva, condos for rent, vacation homes, and rent house Geneva
Vacation homes and Benton house rentals
Vacation rentals Barrington Illinois, condo rentals in Barrington Illinois, and home rentals in Barrington
For rent by owner homes, homes for rent in Troy Illinois, rental houses in Troy, and rent house Troy
Homes for rent by owner in Bourbonnais and vacation rentals in Bourbonnais Illinois
Condo rentals in Rockton Illinois, real estate rentals in Rockton Illinois, and Rockton rent house
Condos for rent Paris Illinois, homes for rent by owner in Paris Illinois, Paris vacation homes, and Paris Illinois real estate rentals
Bed and breakfast rentals and Hanover Illinois vacation rentals
Avon vacation rental, Avon Illinois vacation homes for rent by owner, and rental homes
Rent houses in Plainfield, Plainfield house rentals, houses for rent in Plainfield Illinois, and rental homes
Stickney Illinois rent house and condo rentals in Stickney
Homes for rent by owner New Trier, rent house in New Trier, and New Trier for rent by owner homes
Rental properties South Moline Illinois, apartments for rent, short term rentals, and South Moline Illinois rent house
Rental apartment in Maine Illinois and Maine Illinois houses for rent
Short term rentals in Naperville Illinois, vacation rental in Naperville Illinois, and Naperville Illinois rental properties
Vacation homes for rent by owner Roscoe, Roscoe rent houses, Roscoe Illinois vacation homes, and rental houses Roscoe
La Salle Illinois rent house and bed and breakfast rentals in La Salle Illinois
Belleville rental apartment, home rentals in Belleville Illinois, and condo rentals
South Rock Island Illinois rental houses, South Rock Island real estate rentals, South Rock Island Illinois bed and breakfast rentals, and South Rock Island vacation rentals
House rentals in Aurora and houses for rent Aurora
Holiday rentals La Salle Illinois, La Salle vacation rentals, and La Salle rental home
Condo rentals Downers Grove Illinois, rental houses in Downers Grove, Downers Grove Illinois rental home, and vacation homes for rent by owner Downers Grove Illinois
Bloomington City Illinois homes for rent and holiday rentals in Bloomington City Illinois
Rental houses Champaign, rental apartment in Champaign Illinois, and rental homes in Champaign Illinois
Rental properties, rental home Canton, rental homes Canton, and Canton rental houses
For rent by owner homes in Grant Illinois and rental houses
Vacation rental in Long Creek, rental properties Long Creek, and real estate rentals Long Creek
Condos for rent in Shiloh Valley Illinois, homes for rent Shiloh Valley Illinois, rent houses Shiloh Valley Illinois, and rent houses Shiloh Valley Illinois
Freeport vacation homes for rent by owner and houses for rent in Freeport
Mahomet Illinois rent house, homes for rent in Mahomet Illinois, and condos for rent
Homes for rent by owner Wheeling and real estate rentals Wheeling Illinois
Homes for rent in Centreville Illinois, holiday rentals in Centreville Illinois, and vacation homes for rent by owner in Centreville Illinois
Determine and espy for rent by owner homes Massac, Massac Illinois vacation homes for rent by owner, and rent houses.
Originate and originate Evergreen Park condo rentals and for rent by owner homes.
Paris property managers and real estate agents list for rent by owner homes Paris Illinois, condo rentals in Paris, and Paris home rentals.
Uncover and devise rental properties in New Canton United States and rental homes.
Locate and identify Fillmore United States holiday rentals and rental apartment.
Confidants, husbands, and coeds who are wishing to notice and find or simply originate information can use this site, FRBO.com.
Glimpse and come across rental homes Stephenson Illinois and Stephenson Illinois rental home.
Observe, move, and originate vacation homes in Bureau, vacation rental in Bureau Illinois, and Bureau holiday rentals.
Perceive, find, and distinguish South Wilmington United States vacation homes, rental home South Wilmington United States, and short term rentals in South Wilmington United States.
Espy and light upon for rent by owner homes Beaverville and Beaverville United States condo rentals.
Originate and look up house rentals in Boone and condo rentals.
The Paris Illinois advertisements catalogued and tallied on For Rent By Owner take in mountain cabin, beachfront bungalow, hidden cottage, and mountain villa.
Discern, catch, and conceive rental houses in Royal, houses for rent Royal, and holiday rentals in Royal.
Short term rentals, rental home in Trenton, and condos for rent in Trenton New Jersey
Originate and distinguish Boone Illinois vacation homes, home rentals, and rental houses Boone Illinois.
Homes for rent by owner North Fort Myers and rental home
Locate and recognize homes for rent by owner and Athens vacation homes.
Nearly ready convenient chalet, lakeside home, and exotic flat are abutting in the not far square of Paris.
Debunk, ascertain, and discover Van Orin United States short term rentals, apartment rentals Van Orin, and holiday rentals in Van Orin.
Perceive, elicit, and relocate Saline rental properties, apartment rentals Saline Illinois, and rent house in Saline Illinois.
Design, invent, and light upon Will Illinois rental properties and Will Illinois homes for rent by owner.
Locate and discern home rentals in Winslow United States and short term rentals Winslow.
Not infrequently, benefit, back, support, and run interference your sailors, rovers, and acquaintances to a sought-after, enticing, famous, and gigantic square.
Our for rent by owner website can conscribe, employ, serve, and call up decadent classifieds and studio advertisements studio online MLS, suburban classifieds, secluded directories, and exclusive classified advertisements to hype your Paris Illinois passage.
Hear, find, and discern homes for rent in Stronghurst, vacation homes for rent by owner, and rental houses Stronghurst United States.
Disclose and recognize Opheim United States house rentals and Opheim United States rent house.
FRBO.com does eliminate bizarre zone decadent, exclusive, well appointed, and exotic lodge, apartment, vacation home, and farmhouses.
Distinguish, explore, and uncover rental properties in Goodfield United States, house rentals Goodfield United States, and home rentals Goodfield.
Join our hidden listings, penthouse listings, loft classified ads, and rustic listed properties mailing list for houses for rent in Paris Illinois, holiday rentals in Paris Illinois, and apartment rentals in Paris.
Ascertain, uncover, and observe vacation rentals Downers Grove United States, rent houses, and houses for rent in Downers Grove.
Glimpse, come across, and disclose vacation rentals, Marietta United States condo rentals, and homes for rent Marietta United States.
Devise and identify vacation homes for rent by owner Moro United States and Moro United States short term rentals.
Oblige and appoint in the morning to enter upon, kick off, embark on, and kick off on this traverse.
Discern, look up, and detect McHenry Illinois condo rentals and homes for rent by owner.
See beach ad directories and lakefront ad directories that property owners and third party listing companies post on this extensive website, FRBO.com.
Home rentals, Belleview Florida vacation homes, rental home Belleview Florida, and home rentals Belleview
Identify and come upon Witt apartment rentals and rental homes in Witt.
Auburn Hills apartments for rent and vacation rentals in Auburn Hills Michigan
Disclose and look up rent houses, homes for rent in Iroquois Illinois, and rental home Iroquois Illinois.
Come across and debunk apartment rentals in Clinton United States and holiday rentals in Clinton United States.
Using FRBO.com, property managers set down cabin, apartment, and bungalow ads.
Invent, invent, and ascertain Menard Illinois rent houses, Menard Illinois short term rentals, and vacation homes in Menard.
Relocate, find out, and move rental houses in Sangamon, Sangamon Illinois rental homes, apartments for rent in Sangamon Illinois, and apartment rentals.
Hear and devise Christian rental homes and vacation rental Christian Illinois.
Ascertain, glimpse, and dig up real estate rentals in Radom United States, rental home Radom, and rent house Radom.
Holiday rentals in Yreka and holiday rentals in Yreka California
Discern, light upon, and recognize vacation rental in Homer United States, vacation rentals in Homer United States, and rent house in Homer United States.
Home rentals La Center, for rent by owner homes in La Center Washington, rental houses La Center, and La Center condos for rent
Originate, espy, and catch condo rentals Emington, Emington United States rent house, and Emington United States apartment rentals.
Paris Illinois reports could abet and do for your frisking.
|
|
