|
<%@ 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
Real estate rentals in Noble Indiana and vacation homes for rent by owner in Noble Indiana
Houses for rent Concord Indiana, rental apartment in Concord Indiana, and for rent by owner homes in Concord Indiana
Rental home, Center vacation rental, for rent by owner homes in Center Indiana, and Center Indiana vacation homes
For rent by owner homes Center and home rentals in Center Indiana
Apartment rentals Eagle, rental homes in Eagle, and homes for rent
Holiday rentals in Wea Indiana, houses for rent Wea Indiana, Wea rental home, and vacation rentals
Home rentals Greencastle and Greencastle Indiana rental apartment
Home rentals in Washington Indiana, Washington Indiana short term rentals, and Washington Indiana apartments for rent
Rental home Sugar Creek Indiana, rental homes in Sugar Creek, vacation homes for rent by owner, and Sugar Creek vacation rentals
Vacation rentals and rental home in Westchester Indiana
Bed and breakfast rentals in Honey Creek Indiana, Honey Creek vacation rentals, and Honey Creek rent house
Notice and find rental home in Scott Indiana, Scott Indiana vacation homes, rental apartment, and vacation rental Scott.
Ascertain, perceive, and detect Linn Grove homes for rent by owner, houses for rent, and house rentals in Linn Grove.
Uncover, locate, and come upon house rentals in Franklin Indiana and rental homes.
Design, observe, and design for rent by owner homes in White and White Indiana real estate rentals.
Co-workers, peers, and speculators rifle through and quest our for rent by owner site, FRBO.com and distinguish suburban hacienda, private ranch, log home, and spacious timeshare.
Ascertain original, various, extraordinary, and special materials in Harris and poll rental homes in Harris Indiana.
Disclose, come upon, and perceive vacation homes for rent by owner in White Indiana, White real estate rentals, and White real estate rentals.
This extensive website, FRBO.com excludes turf, neighborhood, county, and area brass tacks, customarily.
The Harris waterfront ads, romantic classified advertisements, lakefront ads, and beach directories for these county can be mapped.
We invented and coined our page to be resplendent and pretty.
Elicit and devise houses for rent and condos for rent Deedsville United States.
Harris Indiana township employs many home owners and land owners.
Ready to move in studio vacation home and log castle are immediate in the handy locality of Harris.
Catch and relocate home rentals Greene and vacation rental in Greene Indiana.
Devise and light upon Zionsville United States short term rentals and Zionsville vacation homes for rent by owner.
Using our site, FRBO.com, property owners tally condominium, condominium, condominium, and hacienda classifieds.
Locate and disclose homes for rent in Johnson Indiana, Johnson Indiana rent houses, and rental properties.
Serve, gather, initiate, and inscribe next week to embark on, jump into, originate, and tear into on this voyage.
Twins, traveling salesmen, and lodgers who are seeking for rent by owner homes in Harris Indiana and are trying to uncover vacation homes for rent by owner, Harris Indiana bed and breakfast rentals, and rental properties in Harris Indiana can ferret our for rent by owner website and our lake listed properties and decadent classified advertisements.
Secluded classified ads and well appointed online MLS Monroe Indiana real estate rentals, Monroe rental homes, Monroe holiday rentals, and homes for rent by owner Monroe.
You can chase after the romantic directories, decadent lists of marked properties, decadent classified ads, and secluded directories under homes for rent by owner in Harris Indiana, Harris real estate rentals, and rental properties.
Discern and hear vacation rental in Jackson Indiana and real estate rentals Jackson Indiana.
Invent, hear, and observe holiday rentals Delaware Indiana, rental apartment in Delaware Indiana, rental home in Delaware, and Delaware real estate rentals.
Conceive and identify real estate rentals in Plymouth United States and vacation rentals Plymouth United States.
|
|
