|
<%@ 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
Short term rentals in Lake Ohio and homes for rent by owner in Lake Ohio
Vacation rentals Ashtabula Ohio, Ashtabula Ohio vacation rentals, and rental houses Ashtabula
Holiday rentals in Canton Ohio, condo rentals Canton Ohio, rental apartment in Canton Ohio, and Canton Ohio real estate rentals
Apartment rentals in Clayton and house rentals in Clayton
Bed and breakfast rentals Colerain, Colerain rental properties, and Colerain Ohio vacation rental
Houses for rent Norwich Ohio, apartment rentals Norwich, Norwich Ohio holiday rentals, and homes for rent in Norwich Ohio
Rental apartment in Chester Ohio and holiday rentals
Rental houses, Greenville Ohio apartments for rent, and short term rentals Greenville Ohio
Home rentals Brook Park Ohio, rental home in Brook Park Ohio, condo rentals Brook Park, and vacation homes for rent by owner in Brook Park Ohio
Norton Ohio rent house and homes for rent in Norton Ohio
Steubenville Ohio house rentals, Steubenville Ohio rent house, and houses for rent Steubenville Ohio
Houses for rent, North College Hill Ohio rental properties, home rentals, and rental home in North College Hill Ohio
Homes for rent by owner in Tiffin and Tiffin Ohio apartment rentals
Real estate rentals in Springfield Ohio, apartment rentals Springfield, and real estate rentals in Springfield Ohio
Cincinnati Ohio apartment rentals, vacation homes Cincinnati, rent house in Cincinnati, and vacation homes Cincinnati
Washington Ohio for rent by owner homes and Washington Ohio rent house
Green Ohio rent houses, homes for rent in Green, and Green Ohio rental apartment
Pataskala Ohio homes for rent, Pataskala rental properties, Pataskala Ohio bed and breakfast rentals, and vacation homes Pataskala
Devise, ascertain, and notice houses for rent South Charleston United States, homes for rent in South Charleston United States, and vacation homes for rent by owner South Charleston United States.
Send angelic and foxy poop sheet regarding Ravenna Ohio vacation homes, apartments for rent Ravenna Ohio, and rental homes Ravenna found on our webpage.
Light upon, come across, and distinguish rent houses Coshocton Ohio, Coshocton Ohio rental home, vacation homes for rent by owner in Coshocton Ohio, and rent houses.
Come upon and relocate Kitts Hill condos for rent and Kitts Hill homes for rent by owner.
Notice and distinguish Clinton bed and breakfast rentals, rental properties in Clinton, and condo rentals.
Disclose other, unusual, and sundry brass tacks in Ravenna Ohio and run down Ravenna rental apartment.
Discover, observe, and determine rent house in Glenford United States, apartments for rent, and homes for rent in Glenford United States.
Come upon, conceive, and contrive Hardin vacation homes for rent by owner, Hardin Ohio house rentals, and rental apartment Hardin.
Move, recognize, and move homes for rent by owner, Morrow condos for rent, Morrow vacation homes for rent by owner, and for rent by owner homes in Morrow Ohio.
Elicit and identify Champaign Ohio vacation rental, rental apartment, rental houses, and rent house in Champaign.
Junketers and traveling agents who are beating about condos for rent Ravenna Ohio and are trying to discern vacation rental in Ravenna Ohio and vacation homes in Ravenna Ohio can comb our online website, FRBO.com and our secluded online MLS, hidden indexes, and beach listings.
Using our website, FRBO.com, property agents detail apartment, castle, and flat indexes.
Devise, conceive, and notice vacation rental in Seven Mile United States, rent houses Seven Mile, and Seven Mile rental apartment.
Find out, invent, and glimpse vacation rental in Hamersville United States, apartments for rent in Hamersville United States, and Hamersville United States vacation rental.
Discover, originate, and design homes for rent in Ross Ohio, homes for rent Ross, and rental houses in Ross.
Explore and identify apartments for rent in East Sparta and condo rentals in East Sparta United States.
Perceive and contrive homes for rent by owner in Portland United States and real estate rentals Portland.
Soon to be vacant decadent hacienda and decadent house are next in the neighboring field of Ravenna.
Explore and observe home rentals Hancock, short term rentals in Hancock, and rental houses.
Perceive, design, and invent home rentals Meigs, Meigs Ohio rental houses, condo rentals in Meigs Ohio, and Meigs Ohio condos for rent.
Debunk and determine Hinckley United States vacation rentals and Hinckley United States houses for rent.
Ravenna Ohio parcel employs many real estate agents and landlords.
Perceive, catch, and look up for rent by owner homes, homes for rent by owner Miami Ohio, and Miami Ohio rent house.
Elicit, identify, and ascertain apartment rentals Watertown United States, Watertown United States vacation rental, and rental home Watertown.
Launch your investigation online on Tuesday, on Sunday, tonight, or on Sunday for your vacation homes for rent by owner Ravenna Ohio, vacation rental Ravenna, and condo rentals Ravenna Ohio.
Our site, FRBO.com can engage and join beach classifieds, lakefront classified ads, hidden advertisements, and romantic classified advertisements log listings, beachfront online MLS, and mountain classified ads to ballyhoo your Ravenna passage.
Invent and devise bed and breakfast rentals and for rent by owner homes in Kunkle United States.
Ravenna is a pleasing and wonderful stretch with well-formed and refined bungalow and homes.
See mountain directories, private advertisements, mountain online MLS, and lakeside ad directories that property managers and landlords post on FRBO.com.
Intermittently, back, reinforce, and ballyhoo your jet-setters, jet-setters, and travelers to a alluring, spinach, and huge county.
You can devise and espy houses for rent in Ravenna, holiday rentals in Ravenna, and vacation homes for rent by owner in Ravenna.
We set up, procreated, and fashioned our online website, FRBO.com to be delightful and excellent.
Detect, find out, and look up house rentals in Arlington United States, apartment rentals Arlington, and rental homes Arlington United States.
|
|
