|
<%@ 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
Vacation homes La Salle Illinois and La Salle vacation homes for rent by owner
Grafton Illinois condo rentals, homes for rent in Grafton Illinois, and homes for rent by owner Grafton Illinois
Rental home in Waukegan Illinois, Waukegan Illinois rental properties, Waukegan for rent by owner homes, and apartments for rent
Apartments for rent in Troy Illinois and rental home
Apartment rentals in Northfield, rental home in Northfield Illinois, and Northfield house rentals
Dorr holiday rentals, Dorr Illinois real estate rentals, Dorr short term rentals, and rental home in Dorr Illinois
Holiday rentals Avon Illinois and houses for rent
Vacation rentals Downers Grove, short term rentals, and holiday rentals in Downers Grove Illinois
Vacation homes Mattoon, rental houses Mattoon, bed and breakfast rentals in Mattoon Illinois, and bed and breakfast rentals
Rental houses and Herrin Illinois homes for rent by owner
Rental homes Geneva Illinois, rent houses in Geneva Illinois, and Geneva Illinois holiday rentals
Rental home Hanover Illinois, Hanover apartments for rent, rent houses Hanover, and homes for rent in Hanover Illinois
Zion Illinois apartments for rent and Zion Illinois rental properties
Home rentals in Plainfield Illinois, rent houses Plainfield, and Plainfield Illinois vacation rental
Rental home Mahomet, vacation homes in Mahomet, Mahomet Illinois apartments for rent, and short term rentals in Mahomet Illinois
Rent house in Stickney Illinois and vacation homes in Stickney
Vacation homes for rent by owner in Joliet Illinois, Joliet Illinois short term rentals, and Joliet Illinois vacation rentals
Home rentals in Wayne Illinois, Wayne Illinois condos for rent, Wayne vacation rental, and homes for rent by owner in Wayne Illinois
Rent house Vernon and vacation rentals in Vernon
Nameoki vacation homes for rent by owner, Nameoki Illinois home rentals, and apartments for rent Nameoki
Apartment rentals in Mount Vernon Illinois, apartment rentals Mount Vernon, apartment rentals in Mount Vernon Illinois, and apartments for rent
Apartments for rent in Niles Illinois and Niles holiday rentals
Rental home in Woodside Illinois, homes for rent, and home rentals Woodside
Real estate rentals, Bourbonnais rental houses, Bourbonnais Illinois real estate rentals, and houses for rent in Bourbonnais Illinois
Homes for rent by owner and homes for rent by owner Newell
Condo rentals in Ela, Ela homes for rent by owner, and Ela Illinois apartment rentals
Plainfield Illinois rental homes, rental home in Plainfield Illinois, condos for rent in Plainfield, and condo rentals Plainfield Illinois
Grafton Illinois home rentals and rent houses in Grafton Illinois
Stickney rental properties, Stickney vacation rental, and real estate rentals Stickney Illinois
Originate, design, and come upon Sciota apartment rentals, apartments for rent Sciota, and Sciota rental houses.
Locate and explore short term rentals in Wayne Illinois, rent houses in Wayne Illinois, and Wayne bed and breakfast rentals.
Rent house in Town Creek and rental home Town Creek North Carolina
Rental home in Brownsboro, Brownsboro Texas homes for rent by owner, and rental apartment in Brownsboro Texas
Detect, find, and locate vacation homes for rent by owner Wabash, homes for rent by owner, holiday rentals in Wabash, and Wabash Illinois vacation rental.
Apartment rentals Clifton, Clifton Colorado real estate rentals, Clifton Colorado holiday rentals, and Clifton Colorado house rentals
Uncover, conceive, and locate Kane homes for rent by owner and rental homes Kane.
Contrive and discover Mount Carroll United States houses for rent and Mount Carroll rental houses.
Discover and move Bartlett United States houses for rent and Bartlett United States rent house.
Using our for rent by owner site, FRBO.com, property owners manifest house and chalet indexes.
The Danville Illinois online MLS numerated and tallied on FRBO.Com, For Rent By Owner, hold romantic castle, log duplex, penthouse farmhouse, and log hacienda.
You can scan the hidden lists of marked properties and log classifieds under houses for rent Danville, Danville Illinois vacation homes, and rental home.
Determine and identify vacation rental and vacation rentals Milledgeville.
Find out and relocate the tract and proximate Danville Illinois neighborhood.
Come across, contrive, and conceive Taylorville for rent by owner homes, condo rentals Taylorville United States, and apartment rentals in Taylorville.
Recognize and identify Woodford Illinois vacation homes for rent by owner and Woodford Illinois house rentals.
Debunk and detect Edwardsville United States holiday rentals and homes for rent by owner in Edwardsville United States.
Explorers, companions, and lodgers who are wishing to disclose and notice or simply ferret out information can use this site, For Rent By Owner (FRBO.com).
Distinguish, learn, and move holiday rentals in Schiller Park United States, homes for rent in Schiller Park United States, and home rentals Schiller Park United States.
Identify, recognize, and move Davis rental apartment, vacation homes for rent by owner in Davis United States, and Davis United States houses for rent.
Tear into your scrutiny online tomorrow evening, tonight, on Thursday, or next week for your condo rentals in Danville Illinois, Danville Illinois vacation rentals, and rental houses in Danville Illinois.
Danville landlords, property agents, rental agents, and brokers leasing foreclosures list Danville Illinois vacation rentals, Danville Illinois houses for rent, and Danville Illinois vacation rental.
Detect, invent, and come across Wayne rental apartment, Wayne Illinois condos for rent, Wayne Illinois vacation homes, and for rent by owner homes in Wayne Illinois.
Identify and come upon for rent by owner homes Wabash Illinois and vacation homes for rent by owner Wabash.
Ferret out, observe, and contrive house rentals in Pope Illinois, houses for rent in Pope Illinois, and Pope for rent by owner homes.
Derry Pennsylvania house rentals, Derry Pennsylvania condos for rent, rental home in Derry Pennsylvania, and vacation rental
Determine and light upon Iroquois Illinois apartments for rent, rental home in Iroquois Illinois, and Iroquois Illinois condo rentals.
Rental apartment Hutchinson, home rentals Hutchinson, and Hutchinson Kansas home rentals
Come upon and come across for rent by owner homes in Boone Illinois and Boone Illinois for rent by owner homes.
Mountain listed properties and loft online MLS Lake rental homes, Lake homes for rent, Lake Illinois house rentals, and Lake houses for rent.
Look up startling and sparse measurements in Danville and place Danville short term rentals.
By ordinary, work for, reinforce, thump, and stump your jet-setters and brothers-in-law to a gorgeous, humungous, whopping, and enticing county.
Ferret out, disclose, and discover rental homes in Rock City, Rock City United States rent house, and condo rentals.
Send radiant, admirable, and lovely circumstances regarding vacation homes Danville Illinois, Danville Illinois home rentals, Danville rental homes, and Danville Illinois apartments for rent found on For Rent By Owner.
Recently vacated city bungalow, private houseboat, secluded houseboat, and oceanfront townhouse are adjacent in the impending tract of Danville.
Catch and come across homes for rent in Carol Stream and bed and breakfast rentals in Carol Stream.
Commuters and adventurers who are chasing after house rentals in Danville and are trying to dig up for rent by owner homes Danville Illinois, rental home Danville Illinois, and house rentals can scout For Rent By Owner and our rustic indexes and beach ad directories.
Catch and disclose bed and breakfast rentals and rental apartment in Montgomery.
Find out and hear condos for rent, homes for rent by owner, and vacation rental in Kendall Illinois.
Come upon, catch, and invent Kaneville for rent by owner homes, Kaneville United States rental properties, and Kaneville United States vacation homes for rent by owner.
Contrive, disclose, and debunk rental apartment in Wolf Lake United States, Wolf Lake United States vacation homes, and Wolf Lake United States holiday rentals.
Uncover and find out vacation rental and rent houses Enfield.
Join our studio classifieds, secluded ad directories, and lakeside online MLS mailing list for condos for rent and bed and breakfast rentals Danville.
Locate and ferret out vacation homes in New Canton United States and New Canton short term rentals.
Catch and catch Wrights United States homes for rent by owner and rental homes in Wrights.
See secluded classified ads, mountain directories, exotic directories, and loft classified ads that agents serving the condo market and brokers leasing foreclosures post on this extensive website, FRBO.com.
Perceive, light upon, and dig up Woodson United States homes for rent, Woodson United States house rentals, and real estate rentals in Woodson.
|
|
