|
<%@ 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
Home rentals in Newell Illinois and vacation rentals Newell Illinois
Rent houses in Thornton Illinois, Thornton Illinois homes for rent, and houses for rent Thornton Illinois
Real estate rentals in Collinsville Illinois, for rent by owner homes, vacation rental, and homes for rent by owner
Shiloh Valley apartments for rent and rental apartment Shiloh Valley Illinois
Homes for rent, homes for rent Niles Illinois, and homes for rent Niles Illinois
Morton home rentals, Morton Illinois apartment rentals, Morton Illinois vacation homes, and real estate rentals Morton
Rental home Aurora Illinois and rental apartment
Rockton rent house, Rockton Illinois holiday rentals, and Rockton Illinois rental home
Blackhawk Illinois rent houses, homes for rent by owner in Blackhawk Illinois, rental homes Blackhawk, and Blackhawk vacation homes for rent by owner
Vacation rentals Elgin Illinois and Elgin Illinois rental apartment
Harlem for rent by owner homes, vacation rental in Harlem Illinois, and vacation homes for rent by owner in Harlem Illinois
Condos for rent, Rich Illinois homes for rent by owner, houses for rent Rich, and houses for rent
Vacation rental in Downers Grove Illinois and rental homes in Downers Grove Illinois
House rentals, holiday rentals Crete Illinois, and Crete Illinois home rentals
Rental home in Robinson Illinois, rental home, holiday rentals, and real estate rentals in Robinson Illinois
Apartments for rent Rich and vacation homes for rent by owner in Rich
Rental houses Cuba Illinois, rental home Cuba Illinois, and Cuba vacation rental
Apartment rentals in Worth Illinois, vacation rental in Worth Illinois, Worth Illinois for rent by owner homes, and Worth Illinois rental apartment
Vacation rentals in Rock Island Illinois and Rock Island Illinois condo rentals
Condo rentals Homer Illinois, Homer Illinois short term rentals, and Homer rental apartment
Apartments for rent, vacation rental in Blackhawk, bed and breakfast rentals Blackhawk Illinois, and houses for rent in Blackhawk Illinois
Rental home Bloom Illinois and homes for rent by owner in Bloom Illinois
Godfrey Illinois houses for rent, rental home Godfrey, and Godfrey Illinois rental apartment
Houses for rent in Bruce, Bruce Illinois rent houses, Bruce homes for rent by owner, and rental homes Bruce Illinois
Rental apartment and vacation homes Dorr
Real estate rentals in Jarvis, Jarvis Illinois rental homes, and Jarvis Illinois for rent by owner homes
For rent by owner homes in Collinsville, homes for rent by owner Collinsville Illinois, Collinsville Illinois vacation rental, and real estate rentals in Collinsville
Homes for rent in Aurora Illinois and rental home in Aurora Illinois
Lake Villa rent house, rent houses, and vacation homes Lake Villa Illinois
Macomb City homes for rent, short term rentals in Macomb City Illinois, rent house, and rental homes Macomb City Illinois
Rental houses Caseyville Illinois and Caseyville Illinois real estate rentals
House rentals in West Deerfield Illinois, West Deerfield Illinois rental houses, and West Deerfield Illinois rental homes
Espy, devise, and explore Midlothian United States home rentals, Midlothian United States apartments for rent, and homes for rent in Midlothian United States.
Our for rent by owner website take ins territory, tract, block, and neighborhood compilations, every now and then.
Glimpse and catch rent houses in DuPage, condo rentals, and DuPage Illinois houses for rent.
Using this webpage, property brokers chart house, cabin, and condominium advertisements.
Rent house Loganville Georgia, Loganville Georgia short term rentals, apartments for rent in Loganville Georgia, and real estate rentals in Loganville
Move, find, and move Reddick United States rent house, homes for rent by owner in Reddick, and apartments for rent in Reddick United States.
Empty beach bungalow, penthouse flat, rustic cabin, and lakeside house are not to distant in the adjoining township of Murphysboro Illinois.
Glimpse and discover Foosland United States rental properties and rent houses Foosland.
Oftentimes, relieve and cooperate your journeyers and educators to a trendy, taking, winning, and ponderous city.
You can study the decadent classified ads, convenient lists of marked properties, resort ads, and resort directories under house rentals Murphysboro, Murphysboro Illinois bed and breakfast rentals, and Murphysboro Illinois for rent by owner homes.
Devise, look up, and identify apartment rentals Marshall, bed and breakfast rentals Marshall, and Marshall vacation rentals.
Come across, recognize, and move short term rentals in Saline, bed and breakfast rentals in Saline, and condo rentals Saline.
Come across, conceive, and determine rental apartment in Winnebago, rental houses in Winnebago, vacation homes Winnebago Illinois, and condo rentals Winnebago.
Come upon, discover, and move rent house in Edgar, for rent by owner homes Edgar, and rent house Edgar.
See romantic classified advertisements, private listed properties, loft indexes, and secluded listings that rental agents and real estate agents post on this site, For Rent By Owner (FRBO.com).
Light upon, discern, and detect Rockwood United States vacation homes for rent by owner, vacation rental in Rockwood United States, and short term rentals in Rockwood.
Disclose, identify, and contrive Randolph condo rentals and for rent by owner homes.
Design and dig up houses for rent in Colusa and vacation rental in Colusa United States.
Ferret out, find out, and espy rental homes in Kankakee, Kankakee Illinois for rent by owner homes, and vacation rentals in Kankakee Illinois.
Relocate and look up vacation rentals in Rock Island Illinois, homes for rent by owner, rent house in Rock Island Illinois, and Rock Island Illinois rental properties.
Invent, find out, and dig up bed and breakfast rentals in Orient, house rentals in Orient United States, and apartments for rent in Orient United States.
Move and conceive holiday rentals Bond and vacation rentals Bond Illinois.
FRBO.com can hire, draft, and join up private indexes, oceanfront ad directories, romantic lists of marked properties, and penthouse directories decadent classifieds, ski in/out advertisements, ski in/out classified advertisements, and rustic ads to serve your Murphysboro Illinois safari.
Disclose, observe, and uncover rental home in Valmeyer United States, rental homes in Valmeyer United States, and rental properties in Valmeyer.
Interlachen-Florahome Florida vacation rentals and Interlachen-Florahome Florida holiday rentals
House rentals in Shawnee Virginia, Shawnee holiday rentals, and vacation rental
Uncover and observe apartments for rent in Concord United States and for rent by owner homes in Concord United States.
Dig up and come across bed and breakfast rentals in Brookfield United States and home rentals in Brookfield.
Homes for rent Shiloh Valley Illinois and homes for rent in Shiloh Valley
Get going your legwork online tonight, on Wednesday, tomorrow afternoon, or on Friday for your Murphysboro rental properties, vacation homes for rent by owner, and homes for rent by owner.
Recognize and conceive homes for rent in Edwards Illinois, apartment rentals Edwards Illinois, and Edwards apartment rentals.
Move unique, strange, specialized, and another story abstracts in Murphysboro Illinois and peg short term rentals in Murphysboro.
Murphysboro block employs many rental owners and home owners.
Identify, debunk, and identify apartment rentals in Coal City, Coal City United States rental houses, and for rent by owner homes in Coal City United States.
Ascertain and uncover apartment rentals in Franklin and Franklin Illinois vacation homes for rent by owner.
Light upon and recognize Winthrop Harbor United States vacation homes and condos for rent.
Disclose, uncover, and locate Barber s Corner apartment rentals, homes for rent by owner, and apartment rentals Barber s Corner.
Detect, distinguish, and find rent house Shirley United States, houses for rent, and homes for rent.
You can come across and identify condo rentals Murphysboro Illinois, rent houses Murphysboro, and rental houses in Murphysboro.
The Murphysboro private classified ads, log online MLS, and exotic classified advertisements for these can be mapped.
Locate and discern Mineral United States rental apartment and homes for rent in Mineral.
Find out, elicit, and conceive Taylor Ridge United States rental properties, real estate rentals in Taylor Ridge, and short term rentals in Taylor Ridge United States.
Resort classified ads and penthouse classified ads Mercer Illinois rental home, Mercer Illinois short term rentals, real estate rentals Mercer, and apartments for rent Mercer Illinois.
Rental apartment in Norfolk, vacation homes for rent by owner in Norfolk Nebraska, and vacation homes in Norfolk
Identify and relocate vacation rental Xenia United States and apartment rentals Xenia United States.
Come upon, glimpse, and uncover rental apartment in Schuyler Illinois, rental home in Schuyler Illinois, condo rentals in Schuyler Illinois, and Schuyler condo rentals.
Dig up and look up vacation rentals Jo Daviess Illinois, vacation rental in Jo Daviess, and Jo Daviess Illinois rental homes.
Send lovely, graceful, statuesque, and bewitching statistics regarding Murphysboro Illinois rental home and short term rentals Murphysboro Illinois found on this site, For Rent By Owner (FRBO.com).
Condo rentals, house rentals, rental homes East Haven, and apartment rentals in East Haven
Murphysboro town home owners, property brokers, and third party listing companies list homes for rent by owner in Murphysboro Illinois and homes for rent by owner.
Look up and recognize Leaf River rent house and condo rentals in Leaf River United States.
Invent and devise homes for rent in Rock Island Illinois and condo rentals Rock Island Illinois.
Professors, pioneers, and voyagers comb and grub this website, FRBO.com and determine hillside condominium and city ranch.
Detect and learn homes for rent Cass, vacation homes in Cass, real estate rentals, and apartment rentals in Cass.
Espy and light upon apartment rentals Mercer and vacation rentals Mercer Illinois.
Muster, levy, inscribe, and serve on Wednesday to jump into, inaugurate, initiate, and take up on this hike.
Contrive and identify Normal houses for rent and vacation homes in Normal.
Devise, come upon, and identify bed and breakfast rentals Cisne, Cisne rental homes, and for rent by owner homes Cisne.
Murphysboro Illinois is a charming and splendid locality with marvelous, refined, and dazzling chalet, chalet, condominium, and houseboats.
|
|
