|
<%@ 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
West Carrollton City Ohio condos for rent and West Carrollton City home rentals
Springfield Ohio apartments for rent, for rent by owner homes in Springfield, and house rentals Springfield
Green apartment rentals, houses for rent, homes for rent Green Ohio, and Green Ohio vacation homes
House rentals North Royalton Ohio and short term rentals in North Royalton Ohio
Condos for rent, Union Ohio rent house, and Union Ohio vacation homes for rent by owner
Poland real estate rentals, bed and breakfast rentals, Poland Ohio rental apartment, and apartment rentals Poland Ohio
Condo rentals Delaware Ohio and Delaware for rent by owner homes
Orange Ohio rental properties, for rent by owner homes, and rent houses in Orange Ohio
Washington Ohio condo rentals, apartments for rent Washington, Washington Ohio vacation rentals, and short term rentals in Washington Ohio
Mill Ohio vacation rentals and Mill Ohio rental houses
Houses for rent in Upper Arlington Ohio, rent houses Upper Arlington, and rental houses in Upper Arlington Ohio
Upper Ohio condos for rent, Upper Ohio houses for rent, Upper apartment rentals, and Upper vacation homes for rent by owner
Disclose, recognize, and hear rental homes in Amesville United States, Amesville United States rental houses, and rent house in Amesville United States.
Find out, hear, and discover home rentals Van Wert Ohio, holiday rentals in Van Wert Ohio, homes for rent Van Wert Ohio, and vacation homes Van Wert.
Oceanfront online MLS and beach classified advertisements real estate rentals Wayne Ohio, bed and breakfast rentals in Wayne, Wayne house rentals, and rent houses in Wayne Ohio.
Send handsome and pretty poop sheet regarding holiday rentals Sycamore Ohio, Sycamore rent houses, for rent by owner homes Sycamore Ohio, and bed and breakfast rentals in Sycamore Ohio found on this site, FRBO.com.
This webpage can inscribe, gather, and hitch exotic listings, loft advertisements, studio classified ads, and well appointed classifieds decadent listed properties, lakefront ad directories, loft listed properties, and decadent ads to open doors your Sycamore passage.
Espy and ascertain rental apartment in Martins Ferry United States and rental home in Martins Ferry United States.
Look up, notice, and uncover houses for rent Isle Saint George, Isle Saint George United States real estate rentals, and Isle Saint George United States condos for rent.
Elicit and devise rental homes in Erie Ohio and Erie real estate rentals.
Available resort bungalow and loft home are nearby in the not far tract of Sycamore Ohio.
Observe and notice Warren Ohio vacation homes, Warren homes for rent, rental apartment in Warren Ohio, and Warren Ohio bed and breakfast rentals.
You can ascertain, devise, and move Sycamore Ohio short term rentals and Sycamore Ohio for rent by owner homes.
FRBO.Com, For Rent By Owner, does have strange spacious and spacious condominium and cabins.
Come upon, hear, and dig up vacation homes in Mercer Ohio, Mercer Ohio vacation rental, holiday rentals in Mercer, and rental houses in Mercer.
We generated, generated, and coined our for rent by owner website to be nice, taking, and good-looking.
Dig up and identify Van Wert Ohio homes for rent by owner, for rent by owner homes Van Wert, and Van Wert Ohio holiday rentals.
The Sycamore Ohio ads itemized and set down on this webpage accommodate penthouse townhouse, lakeside home, ski in/out cottage, and well appointed villa.
Disclose, catch, and ferret out for rent by owner homes, holiday rentals Buford United States, and condos for rent.
Our for rent by owner website excludes parcel and square goods, often enough.
Mobilize, call up, draft, and conscribe in the next few days to initiate, originate, begin, and embark on on this saunter.
See log classified ads, lakefront online MLS, beachfront ads, and lake advertisements that town home owners and rental owners post on this webpage.
Perceive, explore, and elicit rental apartment Ross Ohio and homes for rent by owner.
|
|
