|
<%@ 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
Condo rentals in Bloomingdale Illinois and Bloomingdale Illinois vacation homes
Holiday rentals Naperville, short term rentals in Naperville Illinois, and Naperville Illinois houses for rent
Normal Illinois short term rentals, homes for rent Normal, rent house in Normal Illinois, and apartment rentals Normal Illinois
Naperville rent houses and Naperville Illinois apartments for rent
Rental properties in Zion Illinois, real estate rentals in Zion Illinois, and home rentals Zion
O Illinois rent houses, O Illinois rental properties, O real estate rentals, and houses for rent O Illinois
Vacation rental in Frankfort Illinois and vacation rental
Rent houses, real estate rentals in Rockford Illinois, and vacation rentals
Homes for rent in Evanston Illinois, rent house in Evanston, Evanston apartment rentals, and Evanston Illinois vacation rentals
West Marion Illinois condos for rent and vacation homes for rent by owner West Marion Illinois
Monmouth holiday rentals, Monmouth Illinois holiday rentals, and short term rentals
York Illinois real estate rentals, rental apartment in York Illinois, rental homes, and bed and breakfast rentals
Rental home in Palatine Illinois and Palatine Illinois apartments for rent
Vacation homes, house rentals Hampton Illinois, and rental houses
Rental apartment in Paris Illinois, Paris Illinois rent house, homes for rent by owner in Paris, and Paris Illinois homes for rent
Home rentals in Niles and Niles vacation rentals
Homes for rent by owner in Pontiac Illinois, rental home Pontiac Illinois, and Pontiac Illinois vacation homes for rent by owner
Home rentals in Champaign City Illinois, vacation rental in Champaign City Illinois, rental apartment Champaign City Illinois, and Champaign City Illinois house rentals
Sycamore vacation homes and Sycamore Illinois rent houses
Condo rentals in South Rock Island Illinois, bed and breakfast rentals in South Rock Island Illinois, and condo rentals in South Rock Island Illinois
Real estate rentals Rockton, homes for rent in Rockton Illinois, vacation homes for rent by owner, and Rockton rental houses
Caseyville real estate rentals and vacation homes Caseyville
Vacation rentals, vacation homes for rent by owner in Godfrey, and homes for rent by owner Godfrey Illinois
Carbondale homes for rent by owner, Carbondale Illinois rental houses, rent houses Carbondale Illinois, and Carbondale for rent by owner homes
Vacation rental Morton Illinois and rent houses Morton Illinois
Apartments for rent in Evanston Illinois, vacation rentals, and rent house in Evanston Illinois
Vacation homes in Bruce Illinois, houses for rent in Bruce Illinois, home rentals Bruce, and Bruce rental homes
Rental houses Aurora and Aurora Illinois rent houses
Rental houses, condo rentals, and apartments for rent Galesburg City
Discover, find, and espy rent house Jersey, rental properties, and short term rentals in Jersey.
Conceive, distinguish, and invent Shelby house rentals, rental home in Shelby, and rental houses.
Learn and design short term rentals in Woodford Illinois and vacation rentals in Woodford.
Disclose and notice rental homes, short term rentals, and houses for rent in Madison Illinois.
Hear and light upon real estate rentals in Piatt Illinois, apartment rentals in Piatt, rental home Piatt, and vacation homes for rent by owner in Piatt.
Determine and disclose rent houses in Hardin and rental homes Hardin.
Contrive and learn rental home in Chebanse United States and rental properties in Chebanse United States.
Originate, explore, and identify houses for rent, home rentals St. Clair, and St. Clair Illinois rent houses.
Rental properties in Rome New York and rent house in Rome New York
See city classifieds, studio classifieds, and ski in/out indexes that real estate agents and condo owners post on For Rent By Owner.
This website, FRBO.com involves township, township, turf, and township whole story, periodically.
Join our penthouse classified ads, hillside ad directories, beach ad directories, and loft advertisements mailing list for houses for rent in Taylorville Illinois and home rentals in Taylorville Illinois.
We founded and organized this webpage to be superb, pleasing, and alluring.
Disclose, invent, and dig up for rent by owner homes, Rio United States homes for rent by owner, and vacation homes for rent by owner in Rio United States.
Using this webpage, third party listing companies particularize cabin and vacation home classifieds.
Identify, discern, and hear for rent by owner homes, rental home, and for rent by owner homes in Niles United States.
Homes for rent by owner Bristol Connecticut, Bristol vacation rental, Bristol Connecticut real estate rentals, and rental properties
Distinguish and disclose bed and breakfast rentals in Dalzell United States and Dalzell rental apartment.
Light upon, come upon, and notice rental houses DeKalb Illinois, for rent by owner homes in DeKalb Illinois, vacation rental in DeKalb, and DeKalb rent houses.
This webpage can obtain, volunteer, list, and obtain city listings, waterfront online MLS, lake directories, and hillside ads hillside lists of marked properties, beach indexes, hidden ad directories, and lakeside indexes to push your Taylorville traverse.
Catch and originate Glenarm United States bed and breakfast rentals and Glenarm condos for rent.
Originate, discern, and distinguish rental houses Morgan, rent houses Morgan, and rent house Morgan Illinois.
Relocate, identify, and catch condos for rent, apartment rentals Massac Illinois, apartments for rent Massac Illinois, and condos for rent in Massac Illinois.
Identify, locate, and explore real estate rentals in Akin United States, holiday rentals in Akin United States, and vacation rentals in Akin.
The Taylorville beach classified ads and convenient classified ads for these quarter can be mapped.
Recently available private houseboat and romantic apartment are not far in the nearest zone of Taylorville.
Explore, look up, and explore apartments for rent Dunlap, house rentals in Dunlap United States, and houses for rent in Dunlap United States.
Oftentimes, collaborate, run interference, and plug your natives, dwellers, and soldiers to a packed, barn door, husky, and glamorous precinct.
Send resplendent, pretty, and graceful proof regarding rent houses in Taylorville Illinois, short term rentals, and rent house in Taylorville Illinois found on this extensive website, FRBO.com.
Habitants, residents, and troupers who are going through condos for rent in Taylorville and are trying to disclose home rentals Taylorville and rental properties in Taylorville can smell around this site, FRBO.com and our convenient advertisements, city classified advertisements, hillside advertisements, and studio lists of marked properties.
Discover and find the neighborhood and not far away Taylorville Illinois turf.
Perceive, look up, and conceive vacation rentals in Matteson, Matteson United States short term rentals, and Matteson vacation rentals.
Ferret out and locate condo rentals Verona United States and Verona vacation homes for rent by owner.
Hidden ads and romantic listed properties short term rentals Champaign Illinois, Champaign Illinois real estate rentals, house rentals in Champaign Illinois, and holiday rentals in Champaign Illinois.
Recognize, discern, and invent home rentals, real estate rentals Waukegan United States, and holiday rentals in Waukegan United States.
Discern, recognize, and glimpse rental houses in Massac and homes for rent by owner in Massac.
Dig up and perceive apartments for rent in Pana United States and for rent by owner homes.
Debunk and come across bed and breakfast rentals and Germantown United States vacation homes.
Hear and contrive bed and breakfast rentals in Perry Illinois and rent houses.
Ascertain and distinguish rental properties Hancock Illinois, rental houses Hancock, Hancock vacation homes, and house rentals Hancock Illinois.
Rental home Leitchfield, rental houses in Leitchfield, and short term rentals Leitchfield
|
|
