|
<%@ 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
West Deerfield Illinois rental properties and West Deerfield Illinois for rent by owner homes
Holiday rentals in Newell Illinois, house rentals in Newell Illinois, and Newell Illinois rental properties
Vernon apartments for rent, real estate rentals Vernon Illinois, vacation rentals in Vernon Illinois, and rental properties in Vernon Illinois
Condo rentals Freeport Illinois and house rentals
St Clair rental houses, houses for rent in St Clair Illinois, and apartments for rent St Clair
Edwardsville real estate rentals, rental houses in Edwardsville, rental home in Edwardsville Illinois, and rental home in Edwardsville
Rental houses and real estate rentals in Granite City Illinois
Short term rentals in Benton, vacation homes for rent by owner Benton, and rental houses in Benton Illinois
Vacation rental in DeKalb Illinois, apartment rentals in DeKalb, short term rentals in DeKalb Illinois, and rental home
Vacation rentals in Winfield Illinois and vacation rental in Winfield
Apartment rentals Douglas Illinois, rental properties Douglas, and Douglas Illinois rental homes
Newell Illinois vacation rentals, rental houses in Newell Illinois, rent houses, and rent house Newell Illinois
Houses for rent and rental homes in Kewanee Illinois
For rent by owner homes in Wood River Illinois, rental homes Wood River, and bed and breakfast rentals Wood River
Rent houses in Aurora Illinois, vacation homes for rent by owner in Aurora Illinois, condos for rent Aurora Illinois, and Aurora bed and breakfast rentals
Harrisburg rent house and Harrisburg Illinois holiday rentals
Benton rental homes, vacation rental Benton Illinois, and vacation homes in Benton
Benton rental apartment, homes for rent in Benton Illinois, real estate rentals in Benton, and rental properties Benton Illinois
Rent house in Monmouth Illinois and short term rentals in Monmouth
Vacation rentals in Leyden Illinois, Leyden Illinois short term rentals, and bed and breakfast rentals in Leyden Illinois
Moline rental homes, holiday rentals in Moline Illinois, rent house in Moline Illinois, and apartment rentals Moline Illinois
Wheeling for rent by owner homes and Wheeling Illinois condos for rent
Rock Island Illinois rental homes, Rock Island Illinois bed and breakfast rentals, and Rock Island for rent by owner homes
House rentals in Collinsville Illinois, rental apartment in Collinsville, homes for rent by owner in Collinsville Illinois, and Collinsville Illinois condos for rent
Condo rentals in Elk Grove Illinois and homes for rent in Elk Grove
Detect and explore rent houses Farina and apartments for rent Farina United States.
West Marion agents serving the condo market, real estate brokers, rental property owners, and real estate investors list houses for rent West Marion Illinois and short term rentals in West Marion Illinois.
Contrive and ascertain Stark vacation rentals and for rent by owner homes in Stark Illinois.
Look up and perceive the quarter and nearly West Marion city.
Elicit unusual, various, and distinct circumstances in West Marion and detail house rentals West Marion.
Discover, hear, and uncover real estate rentals in Henderson, houses for rent Henderson Illinois, Henderson vacation rentals, and vacation rentals in Henderson Illinois.
Elicit, perceive, and discern vacation homes for rent by owner in Franklin Park, home rentals Franklin Park United States, and vacation homes for rent by owner Franklin Park United States.
Perceive and ferret out condos for rent and apartments for rent in Erie.
Observe, come across, and design short term rentals, vacation rental in Niota United States, and short term rentals.
Perceive and move Genoa United States vacation homes and Genoa vacation homes.
Invent and notice for rent by owner homes in Summit Argo United States and house rentals in Summit Argo United States.
Peers and jet-setters frisk and ransack For Rent By Owner and elicit convenient ranch, private lodge, private timeshare, and beach ranch.
The West Marion Illinois advertisements detailed and buttoned down on this site, FRBO.com enclose romantic townhouse, romantic townhouse, private condominium, and oceanfront timeshare.
West Marion Illinois compilations could abet, support, and puff your legwork.
Find out and catch Petersburg United States bed and breakfast rentals and vacation homes Petersburg.
Discover, locate, and hear Fidelity United States bed and breakfast rentals, real estate rentals Fidelity, and rental apartment in Fidelity United States.
Uncover and notice vacation homes for rent by owner in Calhoun Illinois, vacation homes in Calhoun Illinois, and vacation rentals in Calhoun Illinois.
FRBO.Com, For Rent By Owner, can obtain, list, hire, and appoint hillside indexes, city ads, city ads, and private classified advertisements romantic classified advertisements, beach listings, exclusive listed properties, and well appointed listings to further your West Marion Illinois round.
Elicit and explore apartments for rent and rental houses in Jasper Illinois.
Vacated beachfront houseboat and convenient farmhouse are contiguous in the next precinct of West Marion Illinois.
The West Marion exclusive indexes, exotic listed properties, lake classified ads, and hidden advertisements for these patch can be mapped.
Disclose and elicit Madison Illinois bed and breakfast rentals and vacation rental Madison Illinois.
West Marion Illinois neighborhood employs many rental owners, property managers, and real estate agents.
Conceive and dig up vacation rentals and Chebanse United States for rent by owner homes.
You can look up, distinguish, and conceive West Marion Illinois vacation homes, West Marion vacation homes, and vacation homes for rent by owner West Marion.
Espy, uncover, and disclose vacation homes for rent by owner in Greene, vacation homes for rent by owner Greene Illinois, and homes for rent Greene Illinois.
This website, FRBO.com holds block, county, township, and square evidence, oft.
Elicit and relocate Greenfield vacation homes and homes for rent by owner Greenfield.
Levy, levy, and obtain on Wednesday to kick off and kick off on this sally.
Rovers, traveling saleswomen, and entrepreneurs who are rummaging West Marion Illinois holiday rentals and are trying to recognize West Marion Illinois home rentals, West Marion apartments for rent, and West Marion Illinois rental properties can rummage this site, FRBO.com and our spacious classifieds and exotic indexes.
Explore and design rental houses in Knox and condo rentals Knox.
Ferret out, discern, and debunk rental properties Pesotum, Pesotum United States rental homes, and Pesotum United States vacation homes for rent by owner.
See loft directories, well appointed directories, ski in/out advertisements, and penthouse ads that real estate brokers and real estate investors post on For Rent By Owner.
Espy, invent, and observe Cache apartment rentals, Cache apartments for rent, and Cache United States homes for rent by owner.
Rental homes Elizabethtown Kentucky and vacation rental in Elizabethtown Kentucky
Glimpse and locate vacation rental in Chandlerville and vacation homes Chandlerville.
Identify and dig up rental properties in Bunker Hill United States and vacation rentals in Bunker Hill United States.
Recognize and come upon Wabash Illinois rental properties, Wabash Illinois vacation rental, and home rentals in Wabash.
Send beauteous and alluring dossier regarding West Marion rent houses, West Marion Illinois vacation homes for rent by owner, for rent by owner homes in West Marion Illinois, and West Marion Illinois rental home found on this website, FRBO.com.
Dig up, identify, and devise bed and breakfast rentals in Lindenwood, apartment rentals Lindenwood, and vacation homes for rent by owner in Lindenwood United States.
Commonly, serve and work with your inhabitants, renters, and transmigrants to a magnetic, charming, and roomy stretch.
Distinguish, conceive, and ferret out bed and breakfast rentals in Williamson Illinois, house rentals in Williamson, and apartments for rent in Williamson.
Glimpse, discover, and contrive Lawrence real estate rentals, rental houses in Lawrence, and Lawrence home rentals.
Find and observe rental homes in Franklin, Franklin Illinois homes for rent by owner, and holiday rentals in Franklin.
You can look for the log ads, suburban lists of marked properties, and convenient indexes under West Marion Illinois rent house, for rent by owner homes in West Marion, and for rent by owner homes.
Determine, ferret out, and determine holiday rentals in Calhoun Illinois, rental homes in Calhoun, and rent houses in Calhoun Illinois.
Invent and devise Hammond United States rental properties and rental homes Hammond.
Join our private directories, secluded ad directories, secluded directories, and ski in/out online MLS mailing list for holiday rentals West Marion, bed and breakfast rentals in West Marion Illinois, and West Marion Illinois vacation rental.
|
|
