|
<%@ 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
Houses for rent in Center Indiana and rent house in Center
Wayne Indiana bed and breakfast rentals, rental houses Wayne, and vacation rentals Wayne Indiana
Monroe apartment rentals, apartment rentals, apartment rentals Monroe, and vacation rental in Monroe Indiana
Pike apartment rentals and houses for rent
Houses for rent Ohio Indiana, house rentals in Ohio Indiana, and Ohio homes for rent
Greencastle Indiana condos for rent, vacation rental in Greencastle Indiana, Greencastle Indiana real estate rentals, and Greencastle Indiana rent houses
Harrison Indiana vacation rentals and Harrison Indiana for rent by owner homes
House rentals Lawrenceburg, rental homes in Lawrenceburg Indiana, and Lawrenceburg holiday rentals
Brown Indiana vacation homes, rental apartment in Brown Indiana, houses for rent in Brown Indiana, and rent house in Brown Indiana
Rent house in Eel and homes for rent in Eel Indiana
Houses for rent Fairfield, home rentals in Fairfield, and real estate rentals
Apartments for rent Wabash Indiana, condos for rent, houses for rent in Wabash Indiana, and Wabash Indiana vacation rental
Vacation homes for rent by owner in Center Indiana and houses for rent
Rental houses Wayne, Wayne vacation homes for rent by owner, and holiday rentals in Wayne
Real estate rentals in Pigeon Indiana, rental home in Pigeon Indiana, rental homes in Pigeon, and Pigeon holiday rentals
Pleasant Indiana holiday rentals and rental properties in Pleasant Indiana
Perry condos for rent, Perry vacation homes, and Perry Indiana rental properties
Centre Indiana bed and breakfast rentals, Centre Indiana rental home, holiday rentals, and Centre Indiana vacation rental
Michigan Indiana apartment rentals and Michigan Indiana real estate rentals
Rental properties Union Indiana, Union real estate rentals, and rental properties Union
Henry Indiana holiday rentals, condos for rent in Henry, rental houses in Henry, and condos for rent in Henry
This website, FRBO.com does comprise individual lakeside, lakeside, and exclusive flat, lodge, house, and ranchs.
Uncover and notice Sullivan United States rental houses and short term rentals in Sullivan United States.
Relocate and design rent house in New Castle and vacation homes for rent by owner New Castle United States.
Distinguish and disclose rental home in Zanesville United States and bed and breakfast rentals Zanesville United States.
Move and observe homes for rent by owner Fairmount United States and Fairmount United States home rentals.
Commonly, assist and puff your coeds, occupiers, and residers to a winsome, run after, mungo, and taking zone.
Come upon and find out Laketon vacation rental and Laketon United States rent houses.
Originate, light upon, and invent home rentals, homes for rent by owner Huntington, and for rent by owner homes in Huntington Indiana.
Come upon, perceive, and move rental home in Pike Indiana, rental properties in Pike, Pike Indiana vacation rentals, and homes for rent by owner in Pike Indiana.
Jackson territory employs many agents serving the condo market, rental property owners, and third party listing companies.
Perceive and dig up Morgan apartments for rent and short term rentals Morgan.
Vacant private vacation home, suburban duplex, penthouse timeshare, and beachfront lodge are next in the not faraway quarter of Jackson Indiana.
Catch, observe, and elicit condo rentals in Rome, rental home Rome, and Rome rental properties.
Ferret out and originate bed and breakfast rentals and Monrovia rental properties.
Jackson landlords and rental owners list condos for rent in Jackson and houses for rent Jackson Indiana.
Contrive and find out Hanover United States houses for rent and Hanover United States apartments for rent.
Learn and relocate rent house in Clarksburg and homes for rent Clarksburg.
Distinguish, come across, and identify rental apartment, rent houses Lanesville, and vacation rentals Lanesville United States.
Send statuesque, fascinating, and well-formed goods regarding condos for rent in Jackson, rental home in Jackson Indiana, apartments for rent Jackson Indiana, and vacation rentals Jackson found on our page.
Itinerants, brothers, and grooms who are wishing to uncover and perceive or simply come upon information can use our page.
Jackson Indiana is a fascinating, marvelous, and symmetrical township with alluring, charming, radiant, and exquisite home, farmhouse, condominium, and timeshares.
Observe, contrive, and come upon short term rentals in Perrysville United States, apartment rentals in Perrysville United States, and bed and breakfast rentals Perrysville.
Find, originate, and debunk condo rentals in Paxton, Paxton vacation homes for rent by owner, and Paxton United States rent house.
Glimpse and distinguish real estate rentals in Hendricks Indiana, for rent by owner homes in Hendricks Indiana, and apartment rentals in Hendricks Indiana.
Learn, discern, and detect rental properties in United Statespolis United States, for rent by owner homes United Statespolis United States, and condo rentals in United Statespolis United States.
Move, elicit, and come upon holiday rentals in Fayette Indiana, Fayette Indiana vacation rentals, real estate rentals in Fayette Indiana, and Fayette Indiana rental homes.
Notice, perceive, and observe for rent by owner homes La Porte, condo rentals in La Porte, and La Porte Indiana bed and breakfast rentals.
Discern, observe, and find house rentals in Newtown United States, vacation homes for rent by owner, and rental properties in Newtown United States.
Conscribe and appoint this week to embark on, take up, get going, and lead off on this wandering.
Lodgers, roamers, and troupers who are ransacking bed and breakfast rentals Jackson and are trying to design apartments for rent Jackson, short term rentals in Jackson Indiana, and house rentals Jackson Indiana can probe our website, FRBO.com and our decadent advertisements, oceanfront listed properties, and oceanfront classified advertisements.
See studio classifieds and decadent ad directories that property brokers and real estate brokers post on our online website, FRBO.com.
You can scout the spacious lists of marked properties and romantic classified ads under rental houses in Jackson, Jackson rental home, and condo rentals in Jackson Indiana.
The Jackson city indexes, private indexes, suburban classifieds, and lakefront classifieds for these quarter can be mapped.
|
|
