|
<%@ 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
Apartment rentals in Bloomington and vacation rentals
Apartment rentals Huntington Indiana, vacation homes for rent by owner in Huntington Indiana, and Huntington Indiana vacation homes
Rental houses in Cedar Creek, Cedar Creek rental homes, rental houses Cedar Creek Indiana, and Cedar Creek Indiana rental houses
Mount Pleasant Indiana vacation rental and home rentals in Mount Pleasant Indiana
House rentals St Joseph Indiana, homes for rent by owner in St Joseph Indiana, and rental properties St Joseph
Peru house rentals, vacation homes Peru Indiana, vacation rentals Peru Indiana, and Peru rent house
Rental properties in Wayne Indiana and rental home
Rental properties, Portage home rentals, and rental apartment Portage Indiana
Vacation homes, vacation homes for rent by owner, rent house in Center Indiana, and Center rent house
St Joseph Indiana vacation rentals and rent house
Center Indiana for rent by owner homes, Center Indiana home rentals, and Center Indiana rental home
Homes for rent in Washington Indiana, home rentals in Washington, rental properties, and bed and breakfast rentals in Washington
Shawswick rental home and real estate rentals Shawswick
Portage Indiana holiday rentals, homes for rent in Portage Indiana, and Portage Indiana bed and breakfast rentals
Rental houses in Anderson Indiana, rental houses in Anderson Indiana, condo rentals in Anderson Indiana, and rental apartment
Home rentals Clay Indiana and Clay Indiana rental homes
New Albany real estate rentals, New Albany condo rentals, and New Albany Indiana vacation homes
Vacation rentals in Union, vacation rental in Union Indiana, Union Indiana rental houses, and Union vacation homes
Rental homes Center Indiana and rent house in Center
Homes for rent by owner in Elkhart Indiana, apartments for rent Elkhart, and rental houses in Elkhart
Lawrence Indiana rent houses, Lawrence Indiana house rentals, vacation homes in Lawrence Indiana, and apartments for rent Lawrence
Bed and breakfast rentals in Wayne and for rent by owner homes in Wayne Indiana
Ross Indiana rental properties, for rent by owner homes Ross Indiana, and rental properties in Ross Indiana
Houses for rent in Van Buren, condos for rent Van Buren Indiana, rental home Van Buren Indiana, and Van Buren rent house
Washington rental houses and for rent by owner homes in Washington Indiana
Rental properties Connersville, rental apartment in Connersville Indiana, and Connersville Indiana vacation homes for rent by owner
Brown Indiana for rent by owner homes, bed and breakfast rentals in Brown Indiana, vacation rental Brown, and real estate rentals Brown Indiana
Rental properties in Mill and Mill condo rentals
Identify and find out the turf and adjoining Columbus Indiana parcel.
See loft directories, ski in/out listed properties, penthouse ad directories, and secluded indexes that agents serving the condo market and condo owners post on our website, FRBO.com.
Distinguish and uncover homes for rent by owner in Lewis United States and apartments for rent Lewis United States.
Using this site, For Rent By Owner (FRBO.com), property brokers catalogue cottage, cottage, and apartment lists of marked properties.
The Columbus Indiana waterfront listed properties and penthouse ads for these precinct can be mapped.
Columbus Indiana area employs many property owners, land owners, real estate agents, and real estate agents.
Glimpse and come across rent houses Pierceton United States and rental home.
You can move, devise, and originate apartments for rent Columbus and Columbus Indiana apartments for rent.
Identify, ascertain, and move apartments for rent in Monon United States, holiday rentals, and vacation rental in Monon United States.
Design, find out, and locate vacation homes for rent by owner in Martin Indiana, Martin Indiana rental apartment, for rent by owner homes in Martin Indiana, and Martin rental home.
Vacation homes, rent house Charlestown Indiana, and rent house in Charlestown
We produced, built, and imagined this extensive website, FRBO.com to be classy and fair.
Come across, notice, and discern Wolflake United States vacation rental, vacation homes for rent by owner Wolflake United States, and bed and breakfast rentals in Wolflake United States.
Condos for rent in Pompton Lakes New Jersey and Pompton Lakes New Jersey rental properties
You can scout the lakefront listings, lakeside listed properties, and loft online MLS under rental home in Columbus, apartment rentals in Columbus Indiana, and Columbus vacation homes for rent by owner.
Uncover, find, and design Vanderburgh Indiana short term rentals, home rentals Vanderburgh Indiana, Vanderburgh Indiana rental home, and homes for rent by owner in Vanderburgh.
Move and come upon real estate rentals in Edinburgh United States and Edinburgh United States real estate rentals.
Ascertain, originate, and learn vacation rental Perry Indiana, rental properties in Perry, and house rentals in Perry.
Notice, come across, and explore vacation rental Spurgeon, house rentals in Spurgeon, and rental homes in Spurgeon United States.
Conscribe and register this weekend to embark on and kick off on this quest.
Identify, locate, and detect home rentals in Putnam, Putnam condos for rent, and Putnam Indiana vacation homes for rent by owner.
Devise and hear real estate rentals, for rent by owner homes in Dearborn Indiana, rental homes Dearborn Indiana, and rent house Dearborn.
FRBO.Com, For Rent By Owner, can levy, enter into, and mobilize log lists of marked properties and secluded listed properties decadent ad directories and suburban listings to do for your Columbus hike.
Columbus Indiana is a sightly, well-formed, charming, and superb stretch with dazzling, classy, and enticing cabin and townhouses.
Observe and identify Rush rent houses and rent house Rush.
Send charming, magnificent, handsome, and classy score regarding Columbus condo rentals, Columbus Indiana condo rentals, and Columbus Indiana rent house found on this site, For Rent By Owner (FRBO.com).
Brides, colleagues, and citizens who are wishing to detect, originate, and move or simply find information can use FRBO.com.
Observe and contrive Bargersville houses for rent and Bargersville rental homes.
Bed and breakfast rentals, homes for rent by owner, rent houses in St Helena South Carolina, and St Helena South Carolina home rentals
|
|
