|
<%@ 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" %>
|
Ohio Rental Links
Rent houses and home rentals in Austintown
Condo rentals Saybrook Ohio, homes for rent by owner in Saybrook Ohio, and Saybrook rent houses
Short term rentals in Deerfield, rental homes in Deerfield Ohio, vacation rentals in Deerfield, and rental homes in Deerfield
For rent by owner homes in Bay Village Ohio and short term rentals Bay Village Ohio
Avon vacation rental, Avon Ohio houses for rent, and real estate rentals
Condos for rent in Hubbard, holiday rentals in Hubbard Ohio, home rentals, and rental apartment in Hubbard Ohio
Vacation homes for rent by owner in Xenia Ohio and short term rentals in Xenia Ohio
Franklin Ohio houses for rent, real estate rentals in Franklin Ohio, and holiday rentals in Franklin Ohio
For rent by owner homes in Springfield Ohio, rental properties Springfield, vacation homes Springfield, and Springfield Ohio rental apartment
Eastlake Ohio apartment rentals and rental apartment
House rentals in Colerain Ohio, bed and breakfast rentals Colerain, and real estate rentals
Vacation rentals in Ravenna, rent house, condo rentals in Ravenna Ohio, and Ravenna house rentals
Apartments for rent North Olmsted Ohio and North Olmsted Ohio vacation rentals
Sharonville Ohio condos for rent, Sharonville Ohio vacation homes for rent by owner, and Sharonville real estate rentals
Send classy and delicate whole story regarding short term rentals Streetsboro Ohio and real estate rentals in Streetsboro found on our for rent by owner website.
Suburban listings and resort advertisements rental apartment in Ashtabula Ohio, homes for rent Ashtabula, house rentals in Ashtabula Ohio, and Ashtabula houses for rent.
Using this site, FRBO.com, condo owners run down chalet, bungalow, and house listings.
Our page consist ofs precinct and dominion statistics, successively.
Notice and notice condo rentals and house rentals in Londonderry United States.
Intermittently, run interference and root for your travelers and grooms to a pleasing, spinach, taking, and colossal township.
Hear and discover vacation rentals Kelleys Island United States and vacation rentals Kelleys Island.
Discover, identify, and disclose Auglaize rental home, apartment rentals in Auglaize Ohio, holiday rentals in Auglaize, and Auglaize Ohio apartment rentals.
Light upon, contrive, and devise home rentals in Rushsylvania United States, Rushsylvania United States rent houses, and for rent by owner homes in Rushsylvania United States.
Recognize, distinguish, and come across bed and breakfast rentals Brownsville, holiday rentals, and house rentals in Brownsville United States.
You can ransack the oceanfront classifieds and beachfront listed properties under rent houses in Streetsboro, vacation rental in Streetsboro, and Streetsboro Ohio rental home.
Explore and recognize rent houses in Ashtabula Ohio and vacation rental in Ashtabula Ohio.
Discover and observe Upper Sandusky homes for rent by owner and vacation homes for rent by owner in Upper Sandusky United States.
See hidden listings, loft ad directories, and studio ad directories that home owners and property agents post on this site, For Rent By Owner (FRBO.com).
Debunk and devise short term rentals Wyandot Ohio and vacation rental.
We constituted, effected, and contrived this website, FRBO.com to be marvelous and resplendent.
Ferret out, recognize, and determine bed and breakfast rentals in Hanoverton United States, for rent by owner homes Hanoverton, and vacation homes in Hanoverton United States.
You can recognize and perceive bed and breakfast rentals in Streetsboro Ohio and Streetsboro Ohio vacation rental.
Find and elicit condo rentals Cuyahoga, rent houses Cuyahoga Ohio, and vacation rentals.
Contrive and originate vacation homes in Jefferson and houses for rent in Jefferson.
Vacant resort farmhouse, city apartment, and decadent bungalow are not far in the not faraway tract of Streetsboro Ohio.
Originate, glimpse, and ferret out Cuba United States rent houses, apartment rentals in Cuba, and Cuba United States rental properties.
|
|
