|
<%@ 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
Real estate rentals Hanover Illinois and Hanover homes for rent by owner
Vacation homes in Worth Illinois, houses for rent in Worth Illinois, and house rentals in Worth
Bed and breakfast rentals in Frankfort Illinois, Frankfort rent house, house rentals in Frankfort Illinois, and Frankfort vacation homes
Homes for rent by owner in Warren Illinois and homes for rent by owner in Warren
Troy rental home, condo rentals in Troy Illinois, and Troy home rentals
Taylorville Illinois apartment rentals, Taylorville condos for rent, homes for rent in Taylorville, and bed and breakfast rentals
Frankfort holiday rentals and short term rentals Frankfort
Home rentals in Frankfort Illinois, Frankfort Illinois vacation rental, and rental apartment in Frankfort Illinois
Wood River Illinois rental home, Wood River Illinois vacation rentals, Wood River Illinois short term rentals, and Wood River vacation homes for rent by owner
Stookey houses for rent and homes for rent by owner in Stookey Illinois
Rockford vacation homes, Rockford Illinois rent houses, and Rockford Illinois rental home
Normal condo rentals, short term rentals Normal, Normal Illinois rent houses, and Normal Illinois rent houses
Vacation rental and short term rentals
Home rentals Benton, short term rentals Benton Illinois, and vacation homes
Condos for rent New Lenox Illinois, New Lenox Illinois bed and breakfast rentals, vacation homes for rent by owner, and apartments for rent New Lenox
Naperville real estate rentals and houses for rent
House rentals in Washington Illinois, rental properties in Washington, and Washington Illinois houses for rent
Tenants, traveling women, and globetrotters explore, comb, and cast about our for rent by owner site, FRBO.com and glimpse penthouse home, secluded cottage, waterfront timeshare, and rustic cabin.
Elicit, elicit, and find Winnebago Illinois home rentals and vacation homes in Winnebago Illinois.
You can inspect the decadent ads, log indexes, lake ad directories, and well appointed classifieds under rental houses Mahomet and Mahomet house rentals.
Explore, discover, and learn rent house in Fox Lake United States, rental houses in Fox Lake United States, and Fox Lake United States rental homes.
Mahomet area employs many property managers, third party listing companies, real estate agents, and town home owners.
Contrive, identify, and glimpse vacation homes, rental home in Henderson Illinois, and rental apartment in Henderson Illinois.
Determine and devise condos for rent Sailor Springs United States and rental houses in Sailor Springs United States.
Recognize, perceive, and ferret out holiday rentals Eldred United States, home rentals in Eldred, and Eldred United States short term rentals.
Mahomet property managers, land owners, real estate brokers, and rental agents list Mahomet rental homes, short term rentals, Mahomet for rent by owner homes, and rental properties in Mahomet Illinois.
Explore and light upon rental homes in Arthur United States and Arthur United States rental home.
Dig up and identify vacation homes for rent by owner St. Clair, St. Clair Illinois homes for rent, and St. Clair Illinois condo rentals.
You can design and invent Mahomet Illinois rental properties and vacation rentals in Mahomet Illinois.
Observe and catch vacation rental in Vermilion Illinois and apartment rentals in Vermilion Illinois.
Find out and explore rental home Saint Anne and Saint Anne United States rent houses.
Using our for rent by owner website, property agents inventory cottage, duplex, and castle online MLS.
See exotic lists of marked properties, beachfront classified ads, loft listings, and hillside ads that real estate investors and home owners post on our site, FRBO.com.
Discover and come across homes for rent by owner Kirkland United States and home rentals in Kirkland United States.
Ferret out and recognize homes for rent by owner in Sigel United States and homes for rent Sigel.
Originate and elicit condos for rent and Wabash Illinois vacation rental.
Notice, invent, and disclose rental homes Wabash, vacation rentals Wabash, real estate rentals in Wabash Illinois, and rental homes.
Elicit and find out vacation homes for rent by owner Hardin Illinois, rent house Hardin Illinois, and Hardin rental homes.
Uncover, disclose, and design house rentals in Huntsville, Huntsville United States for rent by owner homes, and Huntsville United States bed and breakfast rentals.
The Mahomet rustic directories and studio classified ads for these vicinity can be mapped.
Detect, dig up, and notice homes for rent by owner in Tazewell Illinois and homes for rent Tazewell.
This website, FRBO.com can call up, get, and induct resort advertisements, mountain indexes, lake classified advertisements, and well appointed lists of marked properties ski in/out classifieds and hillside ads to puff your Mahomet Illinois stroll.
Originate and conceive rental home in Massac, short term rentals Massac Illinois, short term rentals, and homes for rent by owner in Massac Illinois.
Find out, discern, and elicit rental properties Glenview, vacation rental Glenview, and homes for rent by owner in Glenview United States.
Discover and identify Williamson Illinois vacation rental, houses for rent, real estate rentals in Williamson Illinois, and apartments for rent.
Invent, come upon, and contrive vacation homes in Union, Union condo rentals, and houses for rent in Union Illinois.
Observe and relocate Marshall United States condos for rent and Marshall United States rental home.
|
|
