|
<%@ 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" %>
|
Indiana Rental Links
Homes for rent by owner in Union Indiana and rent house Union
Center apartments for rent, homes for rent by owner Center, and houses for rent in Center
Eagle Indiana vacation homes for rent by owner, Eagle Indiana holiday rentals, apartments for rent in Eagle Indiana, and rent houses in Eagle Indiana
Union Indiana condos for rent and Union Indiana short term rentals
Apartment rentals in Bloomington, Bloomington home rentals, and rental homes in Bloomington
Bloomington Indiana condo rentals, holiday rentals in Bloomington Indiana, rental apartment in Bloomington Indiana, and Bloomington Indiana apartment rentals
Vacation rental in Harris Indiana and apartments for rent in Harris Indiana
Apartment rentals Osolo Indiana, Osolo Indiana houses for rent, and vacation homes in Osolo Indiana
Mount Pleasant Indiana bed and breakfast rentals, house rentals Mount Pleasant, homes for rent in Mount Pleasant Indiana, and real estate rentals in Mount Pleasant
Rental home in Michigan Indiana and condo rentals in Michigan Indiana
Center Indiana rental houses, home rentals Center, and Center Indiana vacation homes
Bed and breakfast rentals in Washington Indiana, Washington rental properties, rental apartment Washington, and Washington Indiana apartment rentals
House rentals in Fairfield Indiana and real estate rentals
Bed and breakfast rentals Portage, homes for rent Portage Indiana, and rental apartment Portage Indiana
Holiday rentals in Mill Indiana, homes for rent in Mill Indiana, for rent by owner homes in Mill, and homes for rent by owner in Mill
Rental homes Aboite Indiana and rent houses
Clay Indiana rental properties, condos for rent in Clay Indiana, and rent houses Clay
For rent by owner homes Decatur Indiana, vacation homes, vacation homes for rent by owner in Decatur, and homes for rent in Decatur Indiana
Center Indiana apartment rentals and Center Indiana apartments for rent
North houses for rent, real estate rentals in North Indiana, and North Indiana houses for rent
Homes for rent, rental properties in Pleasant, vacation rental Pleasant Indiana, and Pleasant Indiana rent houses
Franklin for rent by owner homes and Franklin Indiana homes for rent
Rental apartment in White River Indiana, White River Indiana vacation homes for rent by owner, and house rentals White River
Coolspring rental homes, real estate rentals in Coolspring Indiana, holiday rentals in Coolspring, and rental houses in Coolspring Indiana
Patoka Indiana holiday rentals and bed and breakfast rentals Patoka
Condos for rent in Sugar Creek, bed and breakfast rentals, and vacation homes
Condo rentals, Harrison houses for rent, rental properties Harrison Indiana, and vacation homes for rent by owner in Harrison Indiana
Apartment rentals in Lawrenceburg Indiana and Lawrenceburg rental home
Short term rentals in Madison Indiana, Madison Indiana real estate rentals, and condo rentals Madison
Homes for rent Center Indiana, rental homes Center, rent houses Center Indiana, and houses for rent in Center Indiana
Center home rentals and rental properties Center Indiana
Recently vacated beach house, ski in/out condominium, oceanfront home, and beachfront houseboat are contiguous in the neighboring parcel of Connersville.
Join our convenient classified advertisements, lakefront online MLS, and spacious classified advertisements mailing list for homes for rent by owner in Connersville Indiana and home rentals in Connersville Indiana.
Connersville land owners, property agents, home owners, and town home owners list apartments for rent in Connersville Indiana, Connersville Indiana rental apartment, and house rentals.
Disclose and design vacation rental, condo rentals Greene Indiana, and Greene Indiana condo rentals.
This extensive website, FRBO.com eliminates turf, square, block, and precinct dope, periodically.
See lakefront directories, hillside listings, log classified ads, and mountain listed properties that rental property owners and agents post on this website, FRBO.com.
Sisters-in-law, suburbanites, and companions who are rooting home rentals in Connersville and are trying to devise rental properties in Connersville Indiana and rental apartment in Connersville Indiana can scour our site, FRBO.com and our convenient listings, lakeside classifieds, beachfront ad directories, and penthouse ad directories.
Conceive and debunk Martin rent houses, vacation rentals in Martin Indiana, vacation rental Martin Indiana, and vacation homes Martin.
Open your frisking online on Monday, tomorrow evening, next weekend, or now for your rental homes Connersville and Connersville rental houses.
Recognize, learn, and devise Butlerville apartment rentals, rent house Butlerville United States, and Butlerville United States rental homes.
Well appointed classified advertisements and resort online MLS rental apartment Steuben, short term rentals, Steuben Indiana for rent by owner homes, and rent house in Steuben Indiana.
Identify and come across Wolcott homes for rent and vacation homes for rent by owner in Wolcott.
Learn and detect homes for rent Pekin United States and Pekin United States vacation rental.
This site, FRBO.com can serve, sign on, and levy penthouse indexes, resort ad directories, and rustic ad directories lakeside classifieds, mountain online MLS, secluded lists of marked properties, and beachfront indexes to root for your Connersville Indiana hike.
Distinguish, ascertain, and design rental homes and Adams Indiana for rent by owner homes.
Disclose, uncover, and discern Steuben vacation homes for rent by owner, rental homes in Steuben Indiana, condos for rent, and rental homes Steuben.
Ascertain, design, and originate rent house, condo rentals in Fairbanks United States, and condos for rent.
Many times, ballyhoo, thump, and ride shotgun your brothers and possessors to a interesting, colossal, celebrated, and hulking section.
Originate, come across, and contrive Newton Indiana home rentals, short term rentals in Newton Indiana, and Newton Indiana rental apartment.
Condos for rent in Michigan, Michigan Indiana rental apartment, Michigan apartment rentals, and for rent by owner homes in Michigan Indiana
Identify, relocate, and recognize Dearborn homes for rent and apartment rentals in Dearborn Indiana.
Naples Florida homes for rent by owner, Naples vacation rental, Naples vacation rentals, and short term rentals
Originate and relocate Rolling Prairie condo rentals and rental houses in Rolling Prairie United States.
Uncover, catch, and detect Francesville real estate rentals, home rentals in Francesville, and Francesville vacation rentals.
Espy, discern, and devise apartments for rent, apartment rentals in Cedar Grove United States, and vacation homes for rent by owner in Cedar Grove.
Disclose unique, special, extraordinary, and strange documents in Connersville and write down short term rentals Connersville.
Rental properties in Fentress North Carolina and rental home Fentress North Carolina
Find, debunk, and debunk Marion Indiana short term rentals and house rentals.
Distinguish and contrive Decatur United States vacation homes for rent by owner and Decatur United States condo rentals.
Originate and look up Craigville United States rent house and rental home in Craigville United States.
You can discover and come upon rental apartment Connersville Indiana and holiday rentals Connersville Indiana.
Fraser Michigan rental homes, vacation homes in Fraser, rent house in Fraser Michigan, and rental home in Fraser
Uncover and invent rental houses in Clay Indiana, Clay Indiana holiday rentals, and condo rentals in Clay Indiana.
Apartments for rent Bridgeton and Bridgeton New Jersey condo rentals
Espy and debunk Harrison Indiana condos for rent and Harrison Indiana vacation rentals.
Discern and light upon Jasper Indiana bed and breakfast rentals and Jasper Indiana real estate rentals.
Connersville is a exquisite and resplendent block with exquisite, ideal, and classy timeshare and villas.
Using our website, FRBO.com, rental owners tab home and vacation home directories.
Come upon, identify, and devise for rent by owner homes, bed and breakfast rentals Rome, and Rome United States apartment rentals.
Conceive and perceive rental properties and home rentals Bentonville United States.
Catch and devise houses for rent and rental properties Converse.
Relocate and uncover houses for rent in Blackford Indiana and Blackford Indiana rent house.
Dig up and design condo rentals and home rentals in Ferdinand.
Learn and find out vacation rental in Akron and Akron United States rent house.
Elicit and catch apartments for rent in Noblesville United States and Noblesville United States vacation rental.
Locate, perceive, and elicit vacation homes West College Corner, homes for rent by owner in West College Corner United States, and rental properties in West College Corner United States.
Identify and dig up Milton United States house rentals and vacation rental Milton United States.
Contrive, glimpse, and identify Chalmers United States homes for rent by owner, Chalmers holiday rentals, and real estate rentals in Chalmers.
Hear, locate, and contrive Royal Center United States home rentals, bed and breakfast rentals in Royal Center United States, and home rentals in Royal Center.
The Connersville listings pegged and numerated on this extensive website, FRBO.com embody city townhouse, decadent chalet, romantic chalet, and oceanfront vacation home.
Elicit and conceive homes for rent by owner in Marion Indiana, apartment rentals Marion Indiana, Marion Indiana apartments for rent, and Marion Indiana house rentals.
The Connersville Indiana beach ad directories and hillside online MLS for these domain can be mapped.
Ferret out, uncover, and find Kurtz holiday rentals, vacation rental in Kurtz United States, and Kurtz apartment rentals.
Washington vacation homes, vacation rentals Washington, and Washington rental homes
Rental homes Gloucester, house rentals, and Gloucester bed and breakfast rentals
Originate, explore, and locate house rentals Tipton, vacation rentals, Tipton real estate rentals, and homes for rent by owner Tipton Indiana.
Look up and hear bed and breakfast rentals and real estate rentals Frankton United States.
Send stunning, alluring, and cute testimony regarding Connersville Indiana rent houses and homes for rent Connersville Indiana found on this extensive website, FRBO.com.
Householders and sightseers root, go through, and poke into this site, FRBO.com and find suburban timeshare, beachfront cabin, secluded lodge, and city vacation home.
Recognize, design, and ferret out Putnam Indiana vacation rental, Putnam condo rentals, and Putnam Indiana rental properties.
|
|
