|
<%@ 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
Rental homes in Lima and Lima house rentals
Bed and breakfast rentals in Oxford, Oxford apartments for rent, and condos for rent in Oxford Ohio
Austintown Ohio holiday rentals, rental apartment in Austintown, vacation homes for rent by owner Austintown, and holiday rentals Austintown Ohio
Anderson homes for rent and rent house
Vacation rental in Ashtabula Ohio, Ashtabula apartments for rent, and Ashtabula vacation homes for rent by owner
Vacation homes in Chester Ohio, holiday rentals Chester, vacation homes for rent by owner in Chester, and Chester Ohio apartments for rent
Bed and breakfast rentals Springfield and Springfield Ohio vacation homes for rent by owner
Rent house Batavia Ohio, Batavia Ohio vacation rental, and house rentals in Batavia Ohio
Homes for rent by owner Canton Ohio, Canton Ohio apartments for rent, bed and breakfast rentals Canton, and for rent by owner homes in Canton
Condos for rent in Athens Ohio and Athens Ohio bed and breakfast rentals
House rentals in Conneaut, houses for rent Conneaut Ohio, and home rentals Conneaut Ohio
Pease house rentals, homes for rent by owner in Pease Ohio, apartments for rent in Pease, and condos for rent Pease Ohio
Real estate rentals Harrison Ohio and Harrison Ohio vacation homes
You can examine the penthouse ads, beach online MLS, secluded directories, and suburban ad directories under University Heights Ohio rental apartment and University Heights Ohio rental homes.
Drifters, householders, and navigators who are wishing to locate and find out or simply invent information can use this site, For Rent By Owner (FRBO.com).
Dig up, find out, and contrive the vicinity and not faraway University Heights section.
Espy and come across Ashtabula Ohio rental properties, houses for rent Ashtabula Ohio, and house rentals.
Mobilize and enter this week to tear into and enter upon on this course.
Inaugurate your inquiry online on Friday, this evening, or this week for your homes for rent in University Heights Ohio and rental houses in University Heights Ohio.
Find out, observe, and perceive Sarahsville rental houses, rental home Sarahsville, and Sarahsville United States rental houses.
Identify and conceive rental apartment in Harrison and homes for rent in Harrison.
Our website, FRBO.com does hold sundry block waterfront and well appointed cabin, cabin, farmhouse, and townhouses.
Almost ready to be occupied mountain hacienda, beach cabin, resort townhouse, and beachfront villa are next in the abutting turf of University Heights.
Lakeside online MLS and well appointed listings Knox Ohio condos for rent, rental home in Knox, Knox vacation homes, and Knox Ohio rental homes.
University Heights property managers and rental property owners list bed and breakfast rentals in University Heights, real estate rentals in University Heights Ohio, and real estate rentals in University Heights.
Espy and come across home rentals in Darke Ohio, Darke homes for rent, and houses for rent Darke Ohio.
Originate, design, and originate rent houses Muskingum, Muskingum rent houses, rental houses in Muskingum Ohio, and Muskingum rental home.
Debunk, relocate, and perceive vacation rentals in Mentor United States, rent house in Mentor United States, and homes for rent Mentor.
Catch, come across, and invent Clinton short term rentals, for rent by owner homes Clinton Ohio, and vacation homes in Clinton.
Disclose and identify homes for rent in Circleville United States and Circleville United States rental properties.
Move and perceive Ashland Ohio short term rentals and condo rentals Ashland Ohio.
Notice and learn Clinton Ohio rental houses, rental home in Clinton Ohio, rental houses Clinton Ohio, and rental houses.
Using For Rent By Owner, third party listing companies specialize cottage, house, castle, and houseboat ads.
Detect, dig up, and conceive Carbon Hill United States rental homes, vacation homes Carbon Hill United States, and real estate rentals.
|
|
