|
<%@ 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
Rental apartment in Stickney Illinois and rental properties in Stickney Illinois
Macomb City rent house, rent house Macomb City Illinois, and Macomb City apartment rentals
Rent houses Peru, Peru vacation rentals, home rentals Peru, and Peru Illinois bed and breakfast rentals
St Charles Illinois homes for rent by owner and rental home St Charles
Houses for rent in Grant Illinois, vacation rentals in Grant Illinois, and apartments for rent Grant
Rental properties in Rockton Illinois, short term rentals in Rockton Illinois, rental properties Rockton, and vacation homes for rent by owner in Rockton Illinois
Bed and breakfast rentals and rental properties
Vacation rentals in Frankfort Illinois, homes for rent Frankfort Illinois, and Frankfort condos for rent
Holiday rentals New Trier Illinois, apartment rentals in New Trier Illinois, house rentals New Trier Illinois, and New Trier Illinois vacation rental
Normal Illinois rental home and condo rentals in Normal
Rent house Wood River Illinois, vacation homes in Wood River Illinois, and home rentals in Wood River Illinois
Rental properties in Quincy Illinois, Quincy Illinois rental homes, bed and breakfast rentals in Quincy Illinois, and apartments for rent Quincy Illinois
Rental home in Washington and Washington Illinois home rentals
Homer holiday rentals, rental properties Homer Illinois, and condo rentals in Homer
For rent by owner homes Northfield Illinois, rental houses Northfield Illinois, rent houses in Northfield, and Northfield house rentals
Rent house Dixon and Dixon Illinois rental apartment
Lemont for rent by owner homes, home rentals in Lemont Illinois, and Lemont homes for rent by owner
Apartments for rent Benton Illinois, Benton holiday rentals, holiday rentals Benton Illinois, and Benton Illinois home rentals
Edwardsville apartments for rent and apartment rentals
Vacation rental in Algonquin, Algonquin Illinois condos for rent, and Algonquin rental properties
Notice, design, and invent home rentals in Pierron United States, condo rentals, and Pierron United States vacation homes.
See exclusive advertisements and well appointed classifieds that brokers leasing foreclosures and condo owners post on our for rent by owner site, FRBO.com.
Inscribe, place, and levy in the morning to launch, launch, inaugurate, and begin on this tramp.
Light upon and ferret out vacation homes and Brimfield United States condo rentals.
Determine and determine Nelson house rentals and house rentals in Nelson United States.
Greenwood memorandums could push, further, plug, and thump your going-over.
Our webpage does except startling neighborhood romantic, studio, city, and hidden farmhouse, bungalow, houseboat, and bungalows.
Householders, husbands, and roommates who are rooting rental home Greenwood Illinois and are trying to glimpse condo rentals, Greenwood Illinois rental houses, and home rentals Greenwood Illinois can look our webpage and our studio listings and suburban listings.
Our website, FRBO.com can mobilize, assign, and appoint convenient lists of marked properties, penthouse advertisements, and studio advertisements penthouse advertisements, secluded advertisements, rustic online MLS, and lake classified advertisements to hype your Greenwood range.
Relocate, observe, and notice vacation rental in Calhoun Illinois, rent houses in Calhoun, homes for rent by owner in Calhoun Illinois, and vacation homes for rent by owner in Calhoun Illinois.
Greenwood Illinois is a nice and excellent tract with bewitching, beauteous, stunning, and ravishing chalet and homes.
Discern, ferret out, and learn vacation homes in Claremont United States, rent house in Claremont United States, and Claremont for rent by owner homes.
Learn, devise, and discover apartments for rent Lake Fork, apartment rentals in Lake Fork, and Lake Fork real estate rentals.
Determine and devise apartments for rent La Salle, for rent by owner homes in La Salle Illinois, and rent house in La Salle.
Send alluring, delightful, pleasing, and pleasing input regarding vacation rentals in Greenwood Illinois and Greenwood Illinois homes for rent found on our site, FRBO.com.
Espy and ascertain house rentals Pike Illinois, real estate rentals Pike, and condos for rent in Pike Illinois.
Observe and find vacation rental and condos for rent in Bartelso.
Identify and perceive apartments for rent Bridgeview and Bridgeview houses for rent.
You can originate and come upon homes for rent by owner in Greenwood Illinois, homes for rent by owner in Greenwood, and Greenwood short term rentals.
Debunk, discover, and disclose Riverside United States home rentals, Riverside United States apartments for rent, and rental houses in Riverside United States.
Conceive, learn, and discern rental houses, rental apartment in Cave in Rock United States, and Cave in Rock home rentals.
The Greenwood Illinois convenient listed properties and hidden listings for these section can be mapped.
You can study the exclusive indexes and mountain advertisements under houses for rent Greenwood Illinois and homes for rent by owner in Greenwood Illinois.
Conceive and espy Johnson Illinois houses for rent and for rent by owner homes.
Discern and identify vacation rental in Savanna and apartments for rent in Savanna United States.
Greenwood landlords, land owners, real estate investors, and real estate brokers list Greenwood Illinois rent house, vacation homes for rent by owner Greenwood Illinois, rental homes Greenwood Illinois, and rental home Greenwood Illinois.
Distinguish and uncover short term rentals in Streamwood United States and home rentals in Streamwood United States.
|
|
