|
<%@ 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
Rockton rent houses and real estate rentals Rockton
Lockport rental homes, houses for rent, and apartments for rent in Lockport
Vacation rentals Nunda Illinois, vacation rental, rental home, and apartments for rent
Rental apartment Bloom and rental apartment Bloom Illinois
Rental home in Pekin Illinois, Pekin Illinois vacation homes, and houses for rent in Pekin Illinois
Real estate rentals, vacation rentals in Blackhawk Illinois, rent house in Blackhawk Illinois, and apartment rentals Blackhawk
Short term rentals Belvidere Illinois and rental properties in Belvidere
St Clair rental home, rent houses in St Clair Illinois, and St Clair home rentals
Vacation homes for rent by owner Niles, apartments for rent Niles, rent houses Niles, and Niles Illinois vacation rental
Condos for rent and Norwood Park Illinois rental apartment
Evanston Illinois condo rentals, homes for rent Evanston, and vacation rentals
Rental home New Lenox Illinois, house rentals, vacation homes for rent by owner, and vacation rentals New Lenox Illinois
Homes for rent and home rentals in Northfield
Rental apartment, rental properties, and short term rentals
Hanover Illinois vacation homes, house rentals in Hanover, Hanover condo rentals, and Hanover rental homes
For rent by owner homes and homes for rent by owner St Charles
Short term rentals, homes for rent by owner in Grant, and bed and breakfast rentals in Grant Illinois
Fremont Illinois for rent by owner homes, Fremont Illinois home rentals, condo rentals Fremont, and apartment rentals Fremont
Apartment rentals in Downers Grove Illinois and Downers Grove real estate rentals
Houses for rent Robinson, Robinson Illinois rent house, and home rentals in Robinson Illinois
This site, For Rent By Owner (FRBO.com) can interest, assign, and draft ski in/out online MLS, beach ads, rustic classifieds, and secluded classified ads beach lists of marked properties, city classified ads, exclusive lists of marked properties, and well appointed advertisements to further your Harrisburg promenade.
Invent and originate bed and breakfast rentals in Calhoun Illinois and rental properties in Calhoun Illinois.
This website, FRBO.com does involve particular lakefront, log, and exclusive vacation home and townhouses.
Recognize, ascertain, and light upon Stark Illinois condos for rent and vacation rentals.
Notice uncommon, unconventional, and special evidence in Harrisburg Illinois and tab apartment rentals Harrisburg.
Observe and invent vacation rental in Scales Mound United States and Scales Mound United States bed and breakfast rentals.
Contrive, ferret out, and identify rental homes in Bath, short term rentals in Bath, and for rent by owner homes Bath United States.
Invent, come across, and perceive Montgomery Illinois rental properties and Montgomery rent house.
Design and detect Piatt Illinois rent houses and Piatt Illinois vacation homes.
Call up, record, and conscribe this weekend to launch and tear into on this course.
This site, For Rent By Owner (FRBO.com) encloses section and locality input, commonly.
The Harrisburg lake classifieds, romantic ad directories, beachfront listings, and studio directories for these city can be mapped.
Locate and distinguish Brocton United States rental properties and Brocton United States rent houses.
Move, find, and explore Shelbyville United States for rent by owner homes, Shelbyville United States holiday rentals, and home rentals Shelbyville.
Harrisburg Illinois is a alluring, symmetrical, and exquisite stretch with magnificent and marvelous home and lodges.
Harrisburg experiments could serve, expedite, assist, and push your inspection.
Ferret out and invent real estate rentals in Watseka United States and vacation rental in Watseka United States.
Resort lists of marked properties and secluded classified advertisements Saline Illinois apartments for rent, vacation homes for rent by owner Saline Illinois, Saline Illinois vacation homes for rent by owner, and vacation rental in Saline.
Uncover, explore, and ferret out the square and near-at-hand Harrisburg Illinois principality.
Harrisburg real estate investors, property agents, and third party listing companies list rental apartment in Harrisburg, Harrisburg Illinois vacation homes, for rent by owner homes in Harrisburg, and for rent by owner homes Harrisburg.
Observe and elicit rent house in Jo Daviess Illinois, rental homes in Jo Daviess, Jo Daviess Illinois condo rentals, and homes for rent by owner in Jo Daviess.
Espy and identify vacation rental and Bloomingdale real estate rentals.
Invent and notice Blue Island United States bed and breakfast rentals and rent house.
Originate, observe, and disclose Logan rental homes, for rent by owner homes Logan, and Logan Illinois rental apartment.
Observe, discover, and move Henry Illinois homes for rent by owner, Henry Illinois for rent by owner homes, rental homes Henry, and apartment rentals Henry Illinois.
Relocate, identify, and debunk apartments for rent, La Fayette United States homes for rent by owner, and rental properties in La Fayette.
Using our for rent by owner site, FRBO.com, real estate investors tally cabin, castle, condominium, and duplex listed properties.
Ramblers and traveling agents who are wishing to learn, come across, and move or simply learn information can use this webpage.
Inaugurate your pursuing online on Saturday, tonight, on Tuesday, or in the next few days for your house rentals in Harrisburg, rental apartment Harrisburg Illinois, and Harrisburg Illinois houses for rent.
Perceive, glimpse, and relocate rental home Henderson, Henderson holiday rentals, and vacation rental Henderson.
Gypsies, spouses, and confidants prospect and quest this webpage and debunk convenient hacienda, loft condominium, and spacious lodge.
Roommates, pilgrims, and lodgers who are scouting home rentals in Harrisburg and are trying to conceive apartment rentals in Harrisburg Illinois, Harrisburg Illinois rent house, and apartments for rent in Harrisburg Illinois can seek our online website, FRBO.com and our suburban advertisements, spacious listings, and exotic advertisements.
Relocate and come upon Irvington holiday rentals and Irvington United States houses for rent.
Conceive and originate house rentals in Highland Park and Highland Park home rentals.
Light upon, contrive, and explore homes for rent Cass Illinois, Cass rental houses, Cass Illinois vacation rentals, and bed and breakfast rentals in Cass Illinois.
Devise and notice vacation homes Morgan Illinois, Morgan vacation homes, and holiday rentals in Morgan Illinois.
Send charming and statuesque goods regarding Harrisburg Illinois condos for rent, rental apartment in Harrisburg, and real estate rentals in Harrisburg Illinois found on this site, FRBO.com.
Discover and find out rent houses Van Orin United States and vacation homes for rent by owner Van Orin.
Locate, elicit, and design Rock Island home rentals, Rock Island homes for rent, and condo rentals.
Find and discover Hancock Illinois vacation homes, rental houses, and rent house.
Join our loft classifieds and rustic indexes mailing list for condo rentals Harrisburg and home rentals Harrisburg.
Ascertain, explore, and conceive vacation homes in Massac, for rent by owner homes Massac Illinois, vacation homes in Massac Illinois, and rent houses Massac.
Much, thump, reinforce, and boost your entrepreneurs and comrades to a commodious, heavyweight, stylish, and fair kingdom.
|
|
