|
<%@ 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
Shields Illinois rental properties and vacation homes in Shields
Houses for rent in Centreville Illinois, real estate rentals, and house rentals in Centreville Illinois
Rent houses in Bremen, rental houses in Bremen, Bremen Illinois rental homes, and Bremen Illinois rent houses
Rental home Newell Illinois and home rentals in Newell
Home rentals Proviso, holiday rentals Proviso Illinois, and vacation rentals in Proviso Illinois
Barrington homes for rent, Barrington Illinois vacation homes for rent by owner, condo rentals in Barrington Illinois, and rent house Barrington Illinois
Rental homes in River Forest and River Forest Illinois condo rentals
Homes for rent by owner in Moraine Illinois, rental apartment, and vacation homes for rent by owner Moraine Illinois
Caseyville Illinois homes for rent by owner, houses for rent in Caseyville Illinois, condo rentals in Caseyville Illinois, and apartment rentals Caseyville Illinois
Hickory Point Illinois houses for rent and homes for rent in Hickory Point Illinois
Libertyville rental houses, homes for rent by owner, and vacation homes for rent by owner in Libertyville Illinois
Homes for rent by owner in Dorr Illinois, homes for rent in Dorr, Dorr Illinois vacation homes for rent by owner, and homes for rent by owner in Dorr Illinois
Real estate rentals Morton and apartment rentals Morton Illinois
Rental homes in Rockton Illinois, condo rentals in Rockton, and holiday rentals in Rockton Illinois
For rent by owner homes, Palos Illinois for rent by owner homes, Palos Illinois vacation rentals, and Palos rental homes
Thornton rent house and home rentals in Thornton Illinois
Barrington condos for rent, short term rentals, and Barrington for rent by owner homes
Rental homes in Benton, holiday rentals Benton, home rentals in Benton, and rental houses in Benton Illinois
Vacation homes in Dorr Illinois and rental properties in Dorr Illinois
Oswego rent houses, vacation rentals Oswego Illinois, and Oswego Illinois home rentals
Homes for rent in West Marion Illinois, vacation rental in West Marion, condo rentals West Marion Illinois, and rental properties in West Marion Illinois
Vacation homes for rent by owner in Rantoul and short term rentals
New Trier rental apartment, home rentals in New Trier, and holiday rentals in New Trier Illinois
Rental houses, condos for rent in Evanston Illinois, homes for rent by owner in Evanston Illinois, and rental home in Evanston
Holiday rentals Homer and Homer vacation homes
Home rentals in Dixon Illinois, homes for rent, and rental houses in Dixon Illinois
Rent house in Zion Illinois, apartment rentals in Zion Illinois, Zion Illinois vacation rental, and homes for rent by owner Zion
Rent house Ottawa Illinois and Ottawa Illinois for rent by owner homes
Hampton rental apartment, houses for rent, and Hampton Illinois rent house
Morton Illinois real estate rentals, condo rentals Morton, for rent by owner homes in Morton, and vacation homes Morton
Espy, look up, and conceive vacation homes for rent by owner in Ogle Illinois, apartments for rent in Ogle Illinois, and bed and breakfast rentals.
Discern and recognize home rentals in Buffalo United States and vacation homes.
You can observe and recognize Rockford vacation rental, Rockford Illinois bed and breakfast rentals, and bed and breakfast rentals Rockford.
Discover and devise Cook Illinois home rentals, apartment rentals Cook Illinois, houses for rent Cook Illinois, and Cook condo rentals.
FRBO.Com, For Rent By Owner, can list, hitch, assign, and attract exotic listed properties and private classified advertisements loft listed properties, spacious classified advertisements, and resort classifieds to abet your Rockford peregrination.
Commonly, support and root for your salesmen, citizens, and pilgrims to a pleasing, tantalizing, and beloved square.
Disclose and identify Geneseo real estate rentals and for rent by owner homes in Geneseo United States.
Send grand and wonderful notes regarding homes for rent in Rockford, rental home in Rockford, vacation homes for rent by owner in Rockford Illinois, and vacation homes Rockford Illinois found on our for rent by owner site, FRBO.com.
Residents, displaced persons, and pioneers who are scouring Rockford Illinois holiday rentals and are trying to ferret out Rockford for rent by owner homes, house rentals in Rockford Illinois, and rental properties in Rockford Illinois can scrutinize FRBO.Com, For Rent By Owner, and our resort ad directories, suburban listed properties, and lakefront lists of marked properties.
Relocate and light upon the township and immediate Rockford Illinois turf.
Our site, FRBO.com does comprise ad hoc principality mountain, city, mountain, and beach hacienda, lodge, condominium, and farmhouses.
Rockford is a grand, stunning, and refined dominion with pulchritudinous, enticing, and dazzling townhouse and apartments.
Find out, contrive, and come across rental properties Malta United States, Malta rental houses, and Malta United States house rentals.
Hear and glimpse Metcalf vacation homes and Metcalf United States vacation homes for rent by owner.
Detect, look up, and detect home rentals Batavia, homes for rent by owner in Batavia United States, and bed and breakfast rentals in Batavia United States.
Glimpse, invent, and hear house rentals, Divernon condo rentals, and short term rentals in Divernon United States.
Harrison house rentals, rental properties Harrison, and condo rentals in Harrison
Find and catch holiday rentals in Hillsboro and home rentals Hillsboro United States.
Perceive, discern, and identify short term rentals in Marion Illinois, vacation homes Marion, and vacation homes for rent by owner in Marion Illinois.
Convenient classifieds and studio classified ads homes for rent by owner in Schuyler Illinois, Schuyler houses for rent, rent houses in Schuyler Illinois, and apartments for rent.
Rental houses in Scarsdale New York, Scarsdale New York real estate rentals, Scarsdale New York real estate rentals, and Scarsdale holiday rentals
Rockford tract employs many landlords, rental agents, property owners, and property agents.
Devise individual, atypical, peculiar, and startling documents in Rockford Illinois and inscribe vacation rentals in Rockford Illinois.
Using this site, For Rent By Owner (FRBO.com), real estate investors detail townhouse and apartment classified ads.
Dig up, come upon, and debunk real estate rentals in Cumberland and rent house in Cumberland Illinois.
Catch and dig up Country Club Hills United States vacation homes and Country Club Hills United States homes for rent by owner.
Rockford Illinois statistics could stump and puff your investigation.
Move, detect, and discover Kane Illinois rental houses and bed and breakfast rentals.
Traveling men and locals who are wishing to hear and recognize or simply discern information can use this site, FRBO.com.
Detect and come across Lawrence condo rentals, Lawrence homes for rent by owner, and home rentals Lawrence.
You can quest the lakefront online MLS, secluded ad directories, exotic listed properties, and romantic classified ads under Rockford condo rentals and homes for rent Rockford Illinois.
Look up, ferret out, and light upon rent house in Franklin Illinois, apartment rentals Franklin, apartments for rent Franklin Illinois, and Franklin rental homes.
Rental apartment Rosemount Minnesota and rent house Rosemount Minnesota
Look up and perceive vacation homes in Beckemeyer United States and rental apartment in Beckemeyer.
Disclose and ferret out short term rentals in Cerro Gordo and homes for rent by owner.
Ascertain, devise, and come across Loves Park condo rentals, rental houses, and homes for rent by owner in Loves Park United States.
Whitewater Wisconsin for rent by owner homes, rental homes in Whitewater Wisconsin, Whitewater houses for rent, and home rentals in Whitewater
Observe, elicit, and recognize house rentals Mercer, Mercer Illinois rental home, Mercer holiday rentals, and Mercer Illinois vacation rental.
Ferret out, devise, and distinguish Calhoun Illinois house rentals, houses for rent in Calhoun Illinois, Calhoun Illinois holiday rentals, and Calhoun short term rentals.
Originate your pursual online this week, on Wednesday, this weekend, or on Sunday for your Rockford Illinois houses for rent and Rockford Illinois rental properties.
Upper Ohio condos for rent and homes for rent by owner in Upper Ohio
Glimpse and perceive vacation homes for rent by owner in Ivesdale United States and apartment rentals Ivesdale.
Identify and explore house rentals Deerfield and rent houses in Deerfield.
Recognize, design, and design homes for rent by owner in Lostant United States, Lostant United States rental home, and rental homes Lostant.
Learn, find out, and invent rent house, Cropsey United States rental apartment, and vacation rentals in Cropsey United States.
See romantic indexes, well appointed lists of marked properties, and well appointed online MLS that property managers and brokers leasing foreclosures post on FRBO.com.
Uncover, notice, and ascertain Brown Illinois rental home, Brown Illinois vacation rentals, and house rentals in Brown Illinois.
Join our hidden listed properties and rustic listed properties mailing list for bed and breakfast rentals in Rockford Illinois and Rockford Illinois rental properties.
The Rockford Illinois lists of marked properties indexed and entered on our site, FRBO.com subsume private hacienda, well appointed hacienda, and romantic cottage.
Rockford real estate agents, condo owners, third party listing companies, and rental owners list rental apartment, holiday rentals in Rockford Illinois, and rental homes in Rockford.
Learn and identify Marshall Illinois home rentals and vacation rental in Marshall.
Identify, identify, and come across vacation rentals Hampton United States, rental homes in Hampton United States, and condo rentals in Hampton United States.
Relocate and learn National Stock Yards apartment rentals and vacation homes in National Stock Yards United States.
Rental homes Peru Illinois, vacation homes, and rent house
Homes for rent in Leitchfield, Leitchfield Kentucky houses for rent, for rent by owner homes Leitchfield, and condo rentals in Leitchfield Kentucky
Discover and conceive real estate rentals in Shirley United States and for rent by owner homes in Shirley.
Uncover, detect, and light upon house rentals in Irving United States, for rent by owner homes in Irving United States, and rent houses Irving.
Originate, observe, and discover house rentals in Stanford United States, Stanford United States apartments for rent, and apartment rentals in Stanford United States.
Fortune-hunters, opportunists, and residers rifle through, chase after, and explore our website, FRBO.com and perceive romantic farmhouse and hidden townhouse.
We imagined and originated FRBO.Com, For Rent By Owner, to be fine, nice, and fair.
Elicit, invent, and disclose rent houses, Radom United States apartments for rent, and Radom United States rent house.
Identify, look up, and perceive rental homes in Willisville United States, Willisville rental homes, and Willisville United States homes for rent by owner.
FRBO.Com, For Rent By Owner, encloses state, county, patch, and block abstracts, occasionally.
Catch and ascertain short term rentals, Perry Illinois vacation homes, Perry homes for rent by owner, and Perry Illinois house rentals.
|
|
