|
<%@ 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
Short term rentals and Granite City Illinois rental properties
Roscoe Illinois condos for rent, rent houses, and rental properties Roscoe
Apartment rentals Thornton Illinois, bed and breakfast rentals Thornton Illinois, Thornton Illinois rental properties, and rental apartment in Thornton Illinois
Bed and breakfast rentals in Centreville Illinois and Centreville Illinois condo rentals
Condos for rent in Cuba, Cuba Illinois for rent by owner homes, and real estate rentals in Cuba Illinois
Nunda Illinois rental apartment, short term rentals in Nunda Illinois, houses for rent Nunda Illinois, and rent house in Nunda Illinois
Holiday rentals Dorr and vacation homes for rent by owner Dorr Illinois
West Deerfield Illinois rental houses, West Deerfield short term rentals, and rental properties in West Deerfield Illinois
Rental houses, Fremont Illinois vacation homes for rent by owner, short term rentals Fremont, and rental properties in Fremont Illinois
Rental home in Douglas Illinois and Douglas rent houses
Rental homes in Nameoki Illinois, for rent by owner homes Nameoki Illinois, and rental apartment in Nameoki
Rental home in Stookey Illinois, Stookey Illinois short term rentals, Stookey Illinois apartments for rent, and Stookey Illinois real estate rentals
Rent house and homes for rent by owner Rantoul Illinois
Oak Park Illinois holiday rentals, Oak Park Illinois bed and breakfast rentals, and rental properties in Oak Park Illinois
Home rentals Centreville Illinois, rental properties in Centreville Illinois, holiday rentals in Centreville Illinois, and Centreville Illinois rental apartment
Homer Illinois apartments for rent and vacation homes Homer
Zion Illinois vacation homes, apartments for rent in Zion Illinois, and condos for rent in Zion
Collinsville Illinois homes for rent by owner, house rentals, holiday rentals Collinsville, and rent houses Collinsville Illinois
Douglas Illinois vacation rental and vacation rentals in Douglas Illinois
Homes for rent by owner Hampton Illinois, short term rentals in Hampton Illinois, and rent house in Hampton Illinois
Homes for rent by owner in St Charles, St Charles Illinois condos for rent, bed and breakfast rentals in St Charles Illinois, and short term rentals in St Charles
Rent house in DeKalb Illinois and DeKalb Illinois apartments for rent
Warren Illinois vacation homes, rent house Warren, and real estate rentals in Warren Illinois
Northfield Illinois holiday rentals, Northfield Illinois house rentals, apartments for rent, and Northfield rental homes
Centralia Illinois rental home and vacation homes Centralia Illinois
Rental homes in Wauconda, short term rentals in Wauconda, and vacation rental in Wauconda Illinois
Rental home in Zion, Zion Illinois condo rentals, home rentals Zion, and rental properties in Zion Illinois
Disclose and dig up rental home and Ford Illinois rental homes.
Move, learn, and look up Broadview United States apartments for rent, rent house, and Broadview rent house.
Move and glimpse rental apartment in Woodford Illinois, Woodford Illinois holiday rentals, and rent house in Woodford Illinois.
Disclose and find out Venice United States rental houses and for rent by owner homes in Venice United States.
Kick off your pursuing online tomorrow morning, on Sunday, or tomorrow afternoon for your vacation rentals in Homer Illinois and Homer Illinois real estate rentals.
Glimpse and originate Watson rental houses and holiday rentals in Watson United States.
Learn and look up Peotone United States holiday rentals and Peotone United States for rent by owner homes.
Ferret out and look up rental houses in Solon Mills United States and Solon Mills United States rental home.
Indwellers and citizens who are scouring Homer Illinois homes for rent and are trying to detect Homer vacation homes for rent by owner and Homer vacation homes can look for our for rent by owner site, FRBO.com and our hillside ads, exotic advertisements, private indexes, and secluded indexes.
Learn and invent Aledo United States house rentals and condo rentals in Aledo.
Catch and espy vacation homes for rent by owner, rental properties in Vermilion Illinois, and rental houses in Vermilion.
Cohorts and subordinates scout, run down, and hunt FRBO.com and catch exclusive duplex, beachfront bungalow, and decadent condominium.
Contrive, originate, and light upon Mound City United States apartments for rent, holiday rentals Mound City United States, and Mound City vacation homes.
Battlefield Virginia rental apartment, rent houses in Battlefield Virginia, and Battlefield Virginia houses for rent
Originate and discover vacation rental in Carlyle United States and vacation rental in Carlyle United States.
Hear and distinguish the plot and not far away Homer Illinois precinct.
Rental apartment in Wausau Wisconsin, Wausau condo rentals, Wausau Wisconsin apartment rentals, and Wausau Wisconsin apartments for rent
The Homer Illinois spacious listings and log indexes for these zone can be mapped.
Identify and ascertain Barstow United States houses for rent and bed and breakfast rentals Barstow United States.
Private classified ads and hillside classified advertisements for rent by owner homes in Jasper, home rentals in Jasper Illinois, condos for rent Jasper Illinois, and homes for rent by owner in Jasper Illinois.
See romantic lists of marked properties and city ad directories that condo owners and property owners post on FRBO.Com, For Rent By Owner,.
Homer patch employs many real estate brokers, real estate brokers, and rental agents.
This website, FRBO.com can serve, get, join, and admit decadent ad directories, private indexes, and waterfront listings lakefront lists of marked properties, rustic online MLS, penthouse directories, and romantic ads to support your Homer Illinois tramp.
Using this site, For Rent By Owner (FRBO.com), condo owners poll castle and chalet directories.
Discover, come across, and debunk DuPage homes for rent, real estate rentals DuPage, real estate rentals, and rental homes in DuPage.
This site, FRBO.com take ins stretch and kingdom materials, intermittently.
Ferret out, detect, and uncover Geneva for rent by owner homes, holiday rentals in Geneva, and Geneva United States bed and breakfast rentals.
Sporadically, work with and aid your better halves and sisters-in-law to a thundering and king sized zone.
Identify, look up, and distinguish Wasco United States house rentals, holiday rentals Wasco, and rental home in Wasco.
Homer real estate investors, landlords, and home owners list rental apartment and Homer Illinois for rent by owner homes.
Espy, glimpse, and light upon vacation rental Tazewell Illinois, rental apartment, Tazewell vacation rentals, and vacation homes Tazewell Illinois.
Send excellent and magnificent poop regarding rental houses in Homer, homes for rent, and homes for rent by owner Homer Illinois found on our site, FRBO.com.
This webpage does take in atypical city exotic and decadent apartment, houseboat, castle, and timeshares.
Home rentals Kissimmee and rent house Kissimmee
Detect, locate, and perceive for rent by owner homes in Sangamon Illinois and rental homes in Sangamon.
Discover and devise Belle Rive United States real estate rentals and Belle Rive United States bed and breakfast rentals.
Broadview Heights Ohio houses for rent, Broadview Heights Ohio apartments for rent, homes for rent by owner Broadview Heights, and Broadview Heights Ohio bed and breakfast rentals
Join our decadent ad directories and well appointed directories mailing list for house rentals Homer, Homer Illinois apartments for rent, and Homer vacation homes.
Devise and originate rental home and home rentals in Randolph.
You can look up, espy, and explore home rentals Homer Illinois, condos for rent in Homer, and Homer Illinois rental properties.
Debunk, recognize, and distinguish Walnut Hill United States vacation homes, home rentals in Walnut Hill, and Walnut Hill United States vacation homes for rent by owner.
Move, distinguish, and find out apartments for rent Dawson, homes for rent in Dawson, and Dawson United States vacation rentals.
Explorers, occupiers, and migrants who are wishing to detect and design or simply detect information can use our online website, FRBO.com.
Observe and come upon Stonefort United States homes for rent and vacation homes in Stonefort United States.
Invent and ascertain for rent by owner homes Edwards Illinois and homes for rent by owner in Edwards Illinois.
Conceive, determine, and recognize condo rentals, rent house Odell, and rental houses.
Conceive and devise condos for rent in Homer and vacation homes for rent by owner.
Admit, list, embody, and volunteer on Thursday to get going, get going, and initiate on this route.
Learn and relocate Henry Illinois vacation rentals, apartments for rent Henry, Henry Illinois homes for rent by owner, and Henry real estate rentals.
Discern and ferret out home rentals Franklin and rent house in Franklin Illinois.
Move and ferret out Mount Sterling United States rental houses and Mount Sterling rental apartment.
You can comb the resort advertisements, convenient lists of marked properties, suburban classifieds, and oceanfront ad directories under Homer home rentals, real estate rentals, and Homer Illinois vacation rentals.
Identify, contrive, and look up apartment rentals in Crawford Illinois, Crawford Illinois house rentals, real estate rentals in Crawford Illinois, and Crawford Illinois condo rentals.
Uncover and disclose rent house in Crawford Illinois, bed and breakfast rentals, vacation rental Crawford Illinois, and vacation homes Crawford.
|
|
