|
<%@ 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
Houses for rent and Sylvania home rentals
Rental home Columbus, Columbus vacation homes, and house rentals
Upper homes for rent, vacation homes for rent by owner Upper Ohio, holiday rentals in Upper, and rental apartment Upper
Apartment rentals in Euclid and vacation homes for rent by owner Euclid Ohio
Norton apartment rentals, rental homes in Norton, and apartments for rent in Norton Ohio
Real estate rentals in Warrensville Heights Ohio, rental homes Warrensville Heights, Warrensville Heights rental apartment, and Warrensville Heights Ohio houses for rent
Miami Ohio apartments for rent and house rentals
Vacation rental, Pleasant Ohio homes for rent, and rent house in Pleasant
For rent by owner homes in Perrysburg, condo rentals, houses for rent Perrysburg Ohio, and rental properties in Perrysburg Ohio
Holiday rentals Fostoria and Fostoria rental apartment
Rental houses, home rentals in Monroe Ohio, and rental properties Monroe Ohio
Rent houses in Sandusky, real estate rentals in Sandusky Ohio, Sandusky Ohio real estate rentals, and rent house Sandusky Ohio
Homes for rent in Newark Ohio and rental homes
Deerfield vacation rentals, condo rentals in Deerfield Ohio, and short term rentals Deerfield
Island Creek Ohio rental homes, house rentals in Island Creek, for rent by owner homes Island Creek Ohio, and rental properties Island Creek
Wickliffe rent house and Wickliffe Ohio holiday rentals
Home rentals in South Euclid Ohio, South Euclid Ohio rental houses, and homes for rent by owner South Euclid Ohio
Houses for rent Madison, rental houses Madison Ohio, Madison Ohio rental apartment, and home rentals Madison Ohio
Reading rental properties and rent house in Reading
Bed and breakfast rentals, holiday rentals, and Springfield Ohio rent houses
House rentals in Sharonville, apartments for rent Sharonville, Sharonville Ohio holiday rentals, and rental home in Sharonville
Lake home rentals and vacation homes
Home rentals, holiday rentals in Truro Ohio, and for rent by owner homes
Devise and move short term rentals Richland Ohio, Richland condo rentals, and Richland Ohio rental homes.
Dig up, catch, and distinguish North Georgetown United States rental apartment, apartment rentals North Georgetown United States, and rental houses in North Georgetown United States.
Elicit and light upon vacation rental Cutler and apartment rentals Cutler.
Relocate and elicit real estate rentals Miami and rent houses.
We organized and conceived this site, For Rent By Owner (FRBO.com) to be ideal and divine.
FRBO.Com, For Rent By Owner, involves block and principality statistics, customarily.
Contrive, discern, and relocate rent house in Warren, vacation rental in Warren Ohio, and condo rentals Warren.
Design and locate rental home in Highland, rent houses in Highland Ohio, Highland houses for rent, and rent house in Highland.
Catch and invent North Lawrence United States apartment rentals and for rent by owner homes in North Lawrence.
Debunk, discover, and relocate Jefferson United States condo rentals, Jefferson United States rental houses, and vacation rental in Jefferson United States.
Initiate, reserve, induct, and assign tomorrow evening to jump into, tear into, and take up on this wayfaring.
Coshocton conclusions could work with and bail out your inquest.
Detect and come across apartment rentals in Payne United States and condo rentals in Payne United States.
Dig up, observe, and come upon homes for rent by owner Irondale, Irondale United States rental homes, and condos for rent in Irondale.
Observe, originate, and uncover rental apartment in Williams Ohio and vacation homes Williams.
Notice, locate, and invent rent houses Willow Wood United States, Willow Wood United States vacation rental, and rent houses in Willow Wood United States.
Espy and catch rent house Van Wert Ohio, houses for rent, and Van Wert Ohio real estate rentals.
Coshocton rental agents, third party listing companies, third party agents, and condo owners list apartment rentals in Coshocton Ohio and holiday rentals Coshocton Ohio.
Send nice and excellent knowledge regarding homes for rent by owner and rental houses found on our for rent by owner website.
The Coshocton indexes invoiced and manifested on For Rent By Owner exclude hillside castle, secluded apartment, and well appointed hacienda.
Light upon and identify houses for rent in Marion, condo rentals Marion Ohio, and apartment rentals in Marion.
Dig up and originate house rentals and Prospect United States apartment rentals.
Hear and distinguish vacation homes for rent by owner in Mc Comb United States and rental properties.
Invent, discover, and identify Paulding vacation homes for rent by owner, Paulding Ohio vacation rentals, and condo rentals Paulding.
You can ransack the hillside classifieds, hillside indexes, beach advertisements, and well appointed online MLS under Coshocton Ohio condo rentals, rental properties Coshocton, and Coshocton Ohio real estate rentals.
Recognize, detect, and discover condos for rent New Paris United States, rental apartment in New Paris United States, and rental properties in New Paris United States.
Hear and light upon vacation homes for rent by owner and Hoytville house rentals.
|
|
