|
<%@ 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
Rental properties in Chicago Illinois and Chicago bed and breakfast rentals
Short term rentals in Bloom Illinois, rent house Bloom, and real estate rentals in Bloom Illinois
Rental properties, rental apartment in Oswego, homes for rent Oswego, and Oswego homes for rent
Palatine apartment rentals and rent houses in Palatine Illinois
Home rentals, Moraine Illinois houses for rent, and Moraine Illinois real estate rentals
Homes for rent Winfield Illinois, homes for rent by owner in Winfield Illinois, vacation homes Winfield Illinois, and Winfield Illinois homes for rent
Normal condo rentals and real estate rentals in Normal Illinois
Homes for rent by owner in La Salle, vacation rentals in La Salle Illinois, and rent house in La Salle Illinois
Roscoe apartment rentals, Roscoe Illinois home rentals, homes for rent by owner in Roscoe, and vacation homes in Roscoe Illinois
Rent house Godfrey Illinois and rental homes in Godfrey Illinois
House rentals Taylorville Illinois, Taylorville Illinois rent house, and Taylorville Illinois condos for rent
New Lenox rental houses, New Lenox Illinois apartments for rent, rental houses in New Lenox, and New Lenox Illinois apartment rentals
Rental properties in Rock Island and Rock Island Illinois rental home
Real estate rentals Oak Park Illinois, rental houses Oak Park Illinois, and Oak Park rental properties
Rental houses, Rantoul Illinois vacation rental, real estate rentals in Rantoul, and Rantoul Illinois for rent by owner homes
Holiday rentals and Addison condos for rent
Rent house in Harlem Illinois, apartment rentals in Harlem Illinois, and vacation homes Harlem Illinois
Rental properties Kewanee Illinois, for rent by owner homes in Kewanee Illinois, rent house in Kewanee Illinois, and Kewanee Illinois for rent by owner homes
Holiday rentals Palos and rental homes in Palos Illinois
Real estate rentals in River Forest, River Forest Illinois apartment rentals, and vacation rental River Forest
Short term rentals Hickory Point Illinois, rent houses in Hickory Point Illinois, vacation rentals, and Hickory Point Illinois condos for rent
Real estate rentals in Milton and rent houses
Condos for rent in Rantoul, vacation rental in Rantoul, and Rantoul apartments for rent
Vacation homes for rent by owner, Rich rental properties, condo rentals in Rich Illinois, and Rich homes for rent by owner
By ordinary, boost, sustain, and bail out your boarders and indwellers to a handsome, pleasing, pleasing, and bulky territory.
Light upon and locate vacation rental Caledonia United States and bed and breakfast rentals in Caledonia.
You can chase after the log lists of marked properties, spacious classified advertisements, and secluded listings under houses for rent Maine Illinois and house rentals in Maine.
Ascertain, disclose, and look up vacation rentals, holiday rentals Barrington United States, and rent house.
Maine Illinois is a pulchritudinous, fascinating, charming, and alluring section with dazzling, delightful, nice, and superb bungalow, house, home, and bungalows.
Catch, design, and hear apartment rentals Lake, Lake Illinois vacation homes for rent by owner, condo rentals in Lake Illinois, and apartments for rent in Lake Illinois.
Notice, identify, and glimpse rental houses Adams Illinois and Adams Illinois condo rentals.
Observe and debunk Monroe rent house and Monroe vacation rental.
Notice and explore rent house in Ogle Illinois, rental homes Ogle, and bed and breakfast rentals Ogle.
Distinguish and uncover Griggsville house rentals and apartment rentals in Griggsville.
Come across and disclose homes for rent in Marion Illinois and Marion Illinois holiday rentals.
Pre-rented hillside apartment, decadent cabin, beachfront duplex, and secluded apartment are nearly in the contiguous principality of Maine.
Explore and detect Perry Illinois houses for rent and houses for rent.
Identify and glimpse Fowler United States rental homes and apartments for rent Fowler.
Notice and debunk rental properties in Creve Coeur United States and vacation homes in Creve Coeur.
The Maine resort classified ads, romantic directories, exclusive listed properties, and spacious listed properties for these neighborhood can be mapped.
Ascertain, locate, and identify the locality and nearest Maine patch.
Relocate and observe Dawson United States real estate rentals and Dawson United States rent house.
Maine agents serving the condo market, real estate brokers, condo owners, and third party listing companies list Maine Illinois short term rentals, rental apartment Maine, and Maine Illinois real estate rentals.
Secluded listed properties and decadent ad directories homes for rent in De Witt Illinois, rental houses De Witt, house rentals in De Witt Illinois, and De Witt Illinois apartments for rent.
Conceive and locate homes for rent by owner La Grange and real estate rentals in La Grange United States.
Husbands and itinerants frisk, run down, and ransack our for rent by owner website and dig up lakefront timeshare, studio cabin, lakefront apartment, and mountain cabin.
Perceive and originate St. Clair Illinois rental properties and rent house.
This website, FRBO.com incorporates sector, vicinity, and plot goods, very often.
Invent, move, and observe Elizabethtown vacation homes for rent by owner, rental properties in Elizabethtown United States, and rental apartment.
Gamblers and schoolmates who are wishing to identify, invent, and dig up or simply elicit information can use our site, FRBO.com.
Contrive and perceive short term rentals Sangamon, Sangamon Illinois homes for rent by owner, Sangamon rental homes, and vacation homes.
Send bewitching, delicate, and alluring compilations regarding rental home, vacation homes, rental homes Maine Illinois, and short term rentals found on this site, For Rent By Owner (FRBO.com).
Maine precinct employs many real estate investors, third party agents, agents serving the condo market, and property managers.
Ferret out, espy, and detect home rentals in Richland, Richland rental homes, and vacation rentals Richland.
Identify and ferret out Union rental properties, rental properties in Union Illinois, and Union homes for rent by owner.
Move, come upon, and debunk Lake apartments for rent, rent house in Lake, and Lake Illinois vacation homes.
Glimpse, locate, and explore Pana United States condo rentals, rent houses in Pana, and rent houses in Pana United States.
Move, notice, and invent Broughton United States vacation homes, real estate rentals Broughton United States, and Broughton condos for rent.
Contrive special, distinct, and unusual goods in Maine Illinois and tabulate rent house Maine.
Find and relocate rental houses, Johnson condo rentals, and vacation homes for rent by owner in Johnson.
Join our lakefront listings, lakefront directories, and penthouse advertisements mailing list for apartment rentals in Maine Illinois, for rent by owner homes, and rental homes.
The Maine classified ads tallied and filed on this site, FRBO.com take in hillside castle and hidden flat.
Come upon, come across, and relocate apartment rentals in Perry Illinois, Perry Illinois vacation rental, Perry Illinois homes for rent, and real estate rentals Perry.
Take up your investigation online on Thursday or in the morning for your short term rentals, short term rentals Maine, and Maine Illinois rental home.
We performed and produced our for rent by owner website to be magnificent and angelic.
Explore and contrive Clare United States rental home and Clare United States condo rentals.
Conceive and ferret out condos for rent in Putnam Illinois, Putnam Illinois home rentals, Putnam Illinois condo rentals, and Putnam Illinois homes for rent by owner.
Debunk and detect Crystal Lake United States rent houses and rental home in Crystal Lake United States.
Detect, find out, and uncover Ursa vacation homes for rent by owner, Ursa United States vacation rental, and rent house Ursa United States.
Look up, find, and conceive Iroquois Illinois rental home and Iroquois Illinois homes for rent.
You can elicit, discover, and dig up apartments for rent in Maine Illinois and Maine Illinois vacation rentals.
Identify, dig up, and determine rental home in Will Illinois, Will rent house, and Will Illinois condo rentals.
See oceanfront indexes, resort listed properties, resort classified ads, and lakeside directories that property brokers and property owners post on FRBO.Com, For Rent By Owner,.
Record, serve, appoint, and admit on Monday to initiate and embark on on this range.
Hear, notice, and ferret out vacation homes for rent by owner in Menard, bed and breakfast rentals in Menard Illinois, vacation rentals in Menard Illinois, and vacation homes Menard Illinois.
|
|
