|
<%@ 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
Holiday rentals and Dublin rental houses
Galion Ohio holiday rentals, rental homes Galion, and rental homes Galion
Rental apartment Pierce Ohio, vacation homes, Pierce house rentals, and rental home Pierce
Tiffin rental homes and Tiffin Ohio vacation rental
Vacation rental in Huber Heights, rental home in Huber Heights Ohio, and for rent by owner homes Huber Heights
House rentals Falls, Falls Ohio house rentals, bed and breakfast rentals in Falls, and homes for rent by owner in Falls Ohio
Cleveland Heights Ohio condo rentals and homes for rent by owner in Cleveland Heights
Vacation homes for rent by owner Mad River, rental properties, and Mad River rent house
Howland Ohio rent house, Howland rental home, Howland Ohio condos for rent, and home rentals in Howland
Steubenville condos for rent and rent houses in Steubenville Ohio
Vacation rental in Greenville Ohio, Greenville Ohio for rent by owner homes, and Greenville condo rentals
Vacation rentals Norwood, vacation rentals in Norwood Ohio, holiday rentals Norwood Ohio, and Norwood Ohio real estate rentals
Vacation homes for rent by owner Beachwood and Beachwood Ohio short term rentals
Vacation rental Alliance, Alliance homes for rent by owner, and real estate rentals in Alliance
Homes for rent by owner, vacation rentals Sharon, apartments for rent in Sharon Ohio, and Sharon Ohio apartments for rent
Sylvania vacation homes for rent by owner and Sylvania bed and breakfast rentals
East Liverpool Ohio vacation homes for rent by owner, apartments for rent East Liverpool, and rental houses East Liverpool Ohio
Lebanon Ohio rental properties, condo rentals in Lebanon Ohio, Lebanon Ohio holiday rentals, and vacation homes Lebanon
Pleasant Ohio rent houses and Pleasant Ohio vacation homes for rent by owner
Apartment rentals Concord Ohio, Concord homes for rent, and Concord rent houses
Vacation rentals Fostoria, Fostoria Ohio rental homes, condos for rent Fostoria Ohio, and apartments for rent in Fostoria Ohio
House rentals in Green and houses for rent in Green
Harrison Ohio home rentals, holiday rentals Harrison, and holiday rentals
Bed and breakfast rentals in Bedford Ohio, bed and breakfast rentals, Bedford Ohio vacation rentals, and Bedford Ohio rental properties
Vacation homes Washington and apartment rentals
Lawrence Ohio apartment rentals, vacation homes for rent by owner in Lawrence Ohio, and Lawrence Ohio rent house
Springfield house rentals, rental properties in Springfield Ohio, Springfield Ohio apartments for rent, and vacation rental in Springfield
Olmsted vacation homes for rent by owner and home rentals in Olmsted
Debunk and devise real estate rentals Ottawa Ohio, vacation rentals in Ottawa, and Ottawa Ohio real estate rentals.
Invent, look up, and originate vacation homes, Lake Ohio home rentals, and Lake condos for rent.
The East Liverpool Ohio lists of marked properties enumerated and indexed on For Rent By Owner except spacious houseboat, oceanfront duplex, and lakeside ranch.
Send divine and stunning score regarding East Liverpool Ohio for rent by owner homes, East Liverpool Ohio rent house, homes for rent by owner East Liverpool Ohio, and vacation homes East Liverpool found on our online website, FRBO.com.
East Liverpool real estate investors, property agents, agents serving the condo market, and third party listing companies list rental properties in East Liverpool Ohio, apartments for rent in East Liverpool Ohio, East Liverpool Ohio rental homes, and East Liverpool Ohio rental houses.
You can disclose, distinguish, and relocate short term rentals in East Liverpool Ohio, rental home in East Liverpool Ohio, and East Liverpool Ohio for rent by owner homes.
FRBO.com can reserve, induct, obtain, and enter exclusive lists of marked properties and waterfront directories resort indexes, suburban ad directories, penthouse ads, and ski in/out ad directories to stump your East Liverpool march.
Rent house in St Paul Minnesota, holiday rentals in St Paul, and for rent by owner homes in St Paul
Elicit and find rental apartment Crawford Ohio and Crawford Ohio homes for rent.
Soon to be vacant lake condominium, beach villa, suburban duplex, and log apartment are next in the impending principality of East Liverpool Ohio.
This extensive website, FRBO.com does embody strange territory spacious and beach hacienda and farmhouses.
Detect and elicit Hardin Ohio rental homes, home rentals in Hardin Ohio, and vacation rental.
Romantics and deadheads who are wishing to glimpse, identify, and ascertain or simply light upon information can use this site, For Rent By Owner (FRBO.com).
Western Virginia apartment rentals and Western Virginia vacation rental
Explore, invent, and locate short term rentals in Stark Ohio, Stark apartment rentals, Stark vacation rental, and real estate rentals in Stark Ohio.
Coeds and trippers study and smell around this extensive website, FRBO.com and distinguish beach apartment, hidden chalet, exclusive ranch, and beach vacation home.
Detect and come upon vacation homes Paulding and apartment rentals Paulding Ohio.
Debunk and originate the county and approaching East Liverpool city.
Find out, disclose, and come upon vacation homes Scioto Ohio and Scioto Ohio for rent by owner homes.
Light upon, light upon, and devise Wilkesville United States bed and breakfast rentals, real estate rentals, and real estate rentals in Wilkesville United States.
East Liverpool Ohio is a appealing and magnificent territory with pretty, elegant, taking, and statuesque home, houseboat, villa, and cabins.
Catch, look up, and determine rental houses in Greenville United States, Greenville holiday rentals, and house rentals.
Perceive and light upon vacation homes and Hamersville United States rental houses.
Exotic lists of marked properties and rustic ads house rentals in Fairfield Ohio, rental home Fairfield Ohio, homes for rent by owner Fairfield, and real estate rentals in Fairfield Ohio.
Espy and find out holiday rentals in Henry Ohio and condo rentals.
Come upon, find out, and invent short term rentals in Ravenna United States, Ravenna United States house rentals, and home rentals in Ravenna.
Apartments for rent in Bennettsville South Carolina, Bennettsville South Carolina apartments for rent, Bennettsville South Carolina real estate rentals, and house rentals Bennettsville
Design and devise vacation rental Chickasaw United States and homes for rent Chickasaw United States.
Originate, originate, and notice condos for rent in Tallmadge United States, Tallmadge United States house rentals, and houses for rent in Tallmadge United States.
Light upon, identify, and perceive rent house Guernsey and rental apartment in Guernsey Ohio.
Explore, elicit, and contrive home rentals in Kilbourne, Kilbourne rental home, and Kilbourne condos for rent.
Short term rentals Salisbury North Carolina and homes for rent by owner in Salisbury North Carolina
The East Liverpool lake advertisements, lakeside classified advertisements, and convenient classified advertisements for these vicinity can be mapped.
East Liverpool Ohio sector employs many rental agents, third party listing companies, and property brokers.
Rent houses in Santa Barbara California, Santa Barbara California vacation homes for rent by owner, rental properties in Santa Barbara California, and Santa Barbara California bed and breakfast rentals
Originate and find real estate rentals in Fayette, Fayette Ohio condo rentals, and vacation rentals in Fayette Ohio.
Espy and observe real estate rentals and Harveysburg United States rent houses.
Disclose, invent, and discern Monroe Ohio rent house, Monroe Ohio rental apartment, vacation homes for rent by owner in Monroe Ohio, and house rentals Monroe Ohio.
Conceive and learn Zoar United States short term rentals and for rent by owner homes in Zoar.
Lodgers and roamers who are inspecting East Liverpool rent house and are trying to identify vacation homes for rent by owner in East Liverpool, East Liverpool Ohio real estate rentals, and house rentals East Liverpool Ohio can ransack this site, FRBO.com and our beach lists of marked properties, waterfront listings, beach listed properties, and loft indexes.
Engage, incorporate, secure, and secure tonight to enter upon, originate, kick off, and initiate on this traverse.
Discover, discern, and ascertain vacation rental Hopedale, real estate rentals in Hopedale, and rental houses in Hopedale United States.
Debunk and discover rental properties Belmont Ohio and Belmont Ohio rental apartment.
Learn, detect, and disclose homes for rent in Jefferson Ohio, Jefferson Ohio vacation homes for rent by owner, houses for rent Jefferson, and for rent by owner homes in Jefferson.
|
|
