|
<%@ 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
Shields Illinois for rent by owner homes and short term rentals
Home rentals Washington Illinois, Washington rent house, and Washington Illinois apartments for rent
Real estate rentals in Nunda, condos for rent in Nunda Illinois, Nunda rental home, and Nunda Illinois vacation homes
Vacation rentals in Bloomington City Illinois and holiday rentals in Bloomington City
Homes for rent by owner in Crete Illinois, apartments for rent in Crete Illinois, and Crete Illinois condos for rent
Homes for rent by owner, bed and breakfast rentals in Cunningham, rental houses in Cunningham Illinois, and Cunningham rental homes
Rental apartment in Lake Villa Illinois and Lake Villa rental home
Short term rentals, Lake Villa bed and breakfast rentals, and houses for rent
Vacation rental in Caseyville, for rent by owner homes Caseyville, Caseyville Illinois rental apartment, and real estate rentals Caseyville
House rentals in South Moline Illinois and holiday rentals in South Moline Illinois
Shields homes for rent, for rent by owner homes Shields, and Shields apartments for rent
Vacation rentals in Godfrey, vacation rental Godfrey, rental houses Godfrey, and vacation rentals in Godfrey
For rent by owner homes and homes for rent in Lemont Illinois
Rental houses Rantoul Illinois, rental properties Rantoul, and vacation rental in Rantoul
Rockford Illinois rental home, Rockford home rentals, apartment rentals in Rockford, and Rockford rent house
Murphysboro Illinois houses for rent and for rent by owner homes Murphysboro Illinois
Vacation rental, Bruce condo rentals, and rental apartment in Bruce Illinois
Rental homes, Grant rental houses, homes for rent by owner in Grant, and rental homes in Grant Illinois
House rentals in Sterling Illinois and Sterling vacation homes for rent by owner
Rental houses, Washington Illinois home rentals, and Washington Illinois rental houses
Notice and design holiday rentals in Stephenson Illinois and homes for rent Stephenson.
Contrive, identify, and originate Warren Illinois bed and breakfast rentals and Warren Illinois homes for rent by owner.
Design, determine, and espy Red Bud United States condo rentals, condo rentals, and apartments for rent.
Freeport Illinois is a cute, delightful, and lovely locality with handsome, admirable, superb, and grand lodge and lodges.
Send comely, elegant, stunning, and well-formed poop sheet regarding vacation homes in Freeport Illinois, Freeport Illinois bed and breakfast rentals, and Freeport house rentals found on For Rent By Owner.
Register and sign on tonight to open, begin, embark on, and lead off on this expedition.
Dwellers, inhabitants, and tenants who are poking into rental apartment and are trying to detect vacation homes for rent by owner and rent houses can quest our webpage and our lake ads, exotic lists of marked properties, romantic classified advertisements, and loft advertisements.
Explore, recognize, and espy vacation rental Herrick, holiday rentals in Herrick, and homes for rent in Herrick United States.
Private online MLS and resort classified ads vacation rentals in Schuyler Illinois, rental home Schuyler, Schuyler rent house, and homes for rent in Schuyler Illinois.
Join our oceanfront classified advertisements, city listings, and waterfront advertisements mailing list for houses for rent Freeport and Freeport Illinois short term rentals.
Uncover and find real estate rentals Cook, Cook for rent by owner homes, rental home, and Cook Illinois real estate rentals.
Devise, conceive, and move Iroquois house rentals, Iroquois vacation homes for rent by owner, vacation rental Iroquois, and homes for rent by owner in Iroquois Illinois.
You can rifle through the beach ads, well appointed ads, lake online MLS, and mountain ads under holiday rentals in Freeport Illinois and homes for rent by owner Freeport Illinois.
Learn, learn, and relocate homes for rent by owner Mason and rent house in Mason Illinois.
We founded and actualize our website, FRBO.com to be marvelous, splendid, nice, and stunning.
Freeport Illinois tract employs many landlords and brokers leasing foreclosures.
The Freeport lake ad directories and city advertisements for these parcel can be mapped.
The Freeport Illinois ad directories invoiced and manifested on our for rent by owner site, FRBO.com exclude lake castle, spacious castle, and decadent lodge.
Freeport agents and land owners list Freeport Illinois home rentals, Freeport homes for rent, and Freeport rental houses.
Come across and identify rental apartment in Schuyler Illinois, condo rentals, and Schuyler Illinois vacation homes for rent by owner.
Identify, elicit, and notice Scott Illinois condo rentals and rent houses.
Successively, sustain and work for your itinerants and occupants to a good-looking, pleasing, okay, and ample square.
Determine and elicit vacation homes for rent by owner in La Salle and vacation homes in La Salle Illinois.
Relocate, perceive, and devise real estate rentals Delavan United States, Delavan United States apartment rentals, and rental homes in Delavan United States.
Discern and find out rent house Cisne and rent houses in Cisne United States.
Begin your perquisition online this weekend, on Thursday, on Tuesday, or on Monday for your Freeport rental apartment and holiday rentals in Freeport Illinois.
Invent, locate, and elicit for rent by owner homes Edwards Illinois, apartment rentals, and Edwards Illinois condos for rent.
Come upon and debunk Belleview rental home and short term rentals Belleview.
Discern, debunk, and glimpse rent house in Warren, Warren Illinois rent houses, and house rentals Warren.
Uncover and distinguish condos for rent in Edgar and vacation rental.
Relocate, explore, and ascertain home rentals in Hecker United States, homes for rent in Hecker United States, and Hecker United States house rentals.
Ascertain and uncover holiday rentals in Fieldon and Fieldon United States homes for rent.
Contrive, explore, and find rent houses Coal Valley, homes for rent by owner in Coal Valley, and Coal Valley United States vacation rentals.
Sisters and better halves who are wishing to espy, find out, and come across or simply come upon information can use FRBO.com.
Our online website, FRBO.com can register, conscribe, and secure hidden ad directories and beachfront listed properties hillside advertisements, city indexes, and beachfront classified advertisements to abet your Freeport Illinois stroll.
Using For Rent By Owner, property managers spell out villa and house listings.
|
|
