|
<%@ 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
Hanover Illinois homes for rent by owner and vacation rental in Hanover Illinois
Rent houses in Moline Illinois, homes for rent by owner in Moline, and Moline Illinois rental homes
Winfield Illinois rental properties, Winfield Illinois short term rentals, rental homes Winfield Illinois, and for rent by owner homes
Algonquin real estate rentals and short term rentals in Algonquin Illinois
Peru rental houses, holiday rentals, and Peru condos for rent
Short term rentals in East St Louis Illinois, East St Louis condo rentals, vacation rentals East St Louis, and rental houses East St Louis
Edwardsville Illinois house rentals and rent house in Edwardsville Illinois
For rent by owner homes, short term rentals in Freeport Illinois, and rent houses in Freeport Illinois
Rental apartment in Mattoon Illinois, rental houses in Mattoon Illinois, rent houses Mattoon Illinois, and Mattoon rental houses
Rental houses in Flagg Illinois and rental houses
Du Page Illinois real estate rentals, rental houses Du Page, and holiday rentals Du Page Illinois
Roamers, occupiers, and wanderers investigate, look for, and look FRBO.Com, For Rent By Owner, and discern log villa, beachfront hacienda, mountain ranch, and mountain duplex.
Perceive, uncover, and discover homes for rent by owner, Palos Heights apartments for rent, and Palos Heights United States vacation homes for rent by owner.
Open your pursuing online next weekend or next weekend for your rental home in Wood River Illinois and house rentals in Wood River Illinois.
Our online website, FRBO.com haves quarter and zone knowledge, every now and then.
This site, For Rent By Owner (FRBO.com) does have ad hoc principality beach, rustic, beach, and mountain townhouse, villa, and chalets.
The Wood River online MLS ticked off and polled on our for rent by owner website involve suburban farmhouse, beach cottage, beach timeshare, and beach apartment.
Light upon and invent condos for rent in McLean, McLean Illinois houses for rent, McLean Illinois rental homes, and McLean Illinois vacation homes.
Perceive, uncover, and come across Greene Illinois bed and breakfast rentals, Greene bed and breakfast rentals, and Greene houses for rent.
Move and dig up real estate rentals Fairmount United States and homes for rent by owner Fairmount United States.
Explore, elicit, and determine Adams condos for rent, Adams condos for rent, homes for rent, and homes for rent by owner.
Identify, originate, and observe vacation homes for rent by owner Macoupin and condo rentals in Macoupin Illinois.
Come upon and catch short term rentals Greene Illinois and rent house Greene Illinois.
Peers and romantics who are wishing to notice, find out, and uncover or simply distinguish information can use our website, FRBO.com.
Wood River property brokers, land owners, rental property owners, and agents list Wood River vacation homes, Wood River Illinois rental home, rental home in Wood River Illinois, and Wood River Illinois rental apartment.
Detect, distinguish, and detect apartment rentals in Hancock and vacation homes for rent by owner in Hancock Illinois.
You can devise and disclose rental home in Wood River Illinois, vacation rentals in Wood River Illinois, and Wood River Illinois condo rentals.
|
|
