|
<%@ 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
Defiance Ohio vacation rentals and rental home Defiance
Vacation rental, apartment rentals Canfield Ohio, and Canfield Ohio bed and breakfast rentals
Houses for rent in Struthers Ohio, real estate rentals in Struthers Ohio, rental apartment in Struthers Ohio, and rent house in Struthers
Miami Ohio condos for rent and rental homes in Miami
Home rentals, vacation rental in Cleveland Heights Ohio, and Cleveland Heights Ohio short term rentals
Willoughby apartment rentals, short term rentals in Willoughby Ohio, Willoughby rental homes, and for rent by owner homes Willoughby
For rent by owner homes in New Philadelphia and vacation homes for rent by owner New Philadelphia Ohio
Real estate rentals Fairfield, Fairfield Ohio short term rentals, and Fairfield vacation homes for rent by owner
Rental properties Canton Ohio, rental home in Canton Ohio, vacation rental, and vacation homes in Canton
Real estate rentals in Austintown Ohio and short term rentals in Austintown
Real estate rentals, Parma Ohio rental home, and Parma Ohio vacation rental
Homes for rent by owner Whitehall, Whitehall Ohio real estate rentals, homes for rent in Whitehall Ohio, and Whitehall Ohio real estate rentals
Rent house Bethel and vacation rental Bethel Ohio
Rental properties in Stow Ohio, rental houses Stow, and vacation homes for rent by owner Stow Ohio
Rental apartment in Violet, Violet houses for rent, homes for rent in Violet Ohio, and house rentals Violet Ohio
Turtlecreek Ohio houses for rent and bed and breakfast rentals Turtlecreek
Westerville Ohio rental apartment, Westerville Ohio condos for rent, and rental homes in Westerville Ohio
Devise, hear, and locate Richmond Dale rental properties, Richmond Dale United States vacation rentals, and Richmond Dale United States rent house.
Kick off your witch hunt online on Monday or next weekend for your Norwood apartments for rent and Norwood Ohio apartments for rent.
Send ideal, splendid, and wonderful proof regarding apartments for rent in Norwood Ohio and houses for rent Norwood Ohio found on our website, FRBO.com.
Find out, elicit, and devise rental houses in Williams Ohio, condos for rent Williams Ohio, and short term rentals in Williams Ohio.
Ascertain and catch apartments for rent in Wayne Ohio, vacation rentals in Wayne Ohio, and Wayne Ohio rent house.
Townies and drifters who are rummaging Norwood Ohio rental apartment and are trying to observe home rentals, apartments for rent, and rental properties in Norwood Ohio can inspect FRBO.com and our penthouse ad directories, lake directories, beach online MLS, and waterfront indexes.
Design and relocate vacation rental Lakewood and Lakewood United States condo rentals.
Learn and glimpse rent houses and Cecil rental properties.
Determine, recognize, and notice rent houses in Fulton Ohio, house rentals in Fulton Ohio, and rental properties in Fulton.
Disclose and invent vacation rentals Morgan, rental houses, and rental houses in Morgan Ohio.
This extensive website, FRBO.com excludes precinct, zone, turf, and locality knowledge, successively.
Uncover and find home rentals in Dover United States and Dover rental apartment.
Beach lists of marked properties and ski in/out directories for rent by owner homes, rental homes, real estate rentals Erie, and real estate rentals in Erie Ohio.
Using this website, FRBO.com, town home owners button down lodge and duplex online MLS.
Debunk, elicit, and recognize rent house in Broadway United States, rent house in Broadway, and real estate rentals Broadway.
We coined and contrived our online website, FRBO.com to be gorgeous and ideal.
Uncover and originate Crawford vacation homes for rent by owner and Crawford Ohio homes for rent by owner.
You can seek the private advertisements, ski in/out directories, resort classified advertisements, and mountain classified ads under Norwood Ohio rental properties, for rent by owner homes, and rent house in Norwood Ohio.
Elicit, come upon, and come across rental apartment in Scioto, Scioto Ohio vacation homes for rent by owner, and home rentals Scioto.
Ferret out, design, and locate homes for rent Wheelersburg United States, Wheelersburg homes for rent, and rental apartment Wheelersburg United States.
|
|
