|
<%@ 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
Rental home in Bedford Heights and Bedford Heights Ohio house rentals
Homes for rent by owner Blue Ash Ohio, Blue Ash home rentals, and Blue Ash Ohio homes for rent by owner
Newark condos for rent, condo rentals, rental apartment in Newark Ohio, and Newark Ohio apartment rentals
Condo rentals in Pease Ohio and Pease rental homes
Green Ohio condo rentals, home rentals in Green Ohio, and houses for rent in Green Ohio
Franklin condo rentals, homes for rent by owner in Franklin, rental home Franklin, and Franklin home rentals
Vacation homes in Clear Creek and real estate rentals in Clear Creek Ohio
Vacation homes in Tiffin Ohio, vacation homes for rent by owner in Tiffin, and short term rentals Tiffin
Rental properties in Bedford Heights Ohio, rental apartment Bedford Heights, rental properties Bedford Heights Ohio, and real estate rentals in Bedford Heights Ohio
Painesville rental apartment and Painesville Ohio home rentals
Genoa Ohio rental houses, condos for rent, and rental home in Genoa Ohio
Vacation rental Canfield Ohio, houses for rent Canfield, homes for rent by owner, and real estate rentals Canfield
Short term rentals in Whitehall and rental houses in Whitehall Ohio
Homes for rent by owner, rental homes in Middletown, and rental apartment Middletown Ohio
Warren Ohio condos for rent, Warren Ohio rental houses, Warren Ohio bed and breakfast rentals, and Warren rental homes
Condos for rent in Oxford and rental properties
House rentals Miami Ohio, rental homes Miami Ohio, and rental properties in Miami
Poland Ohio rent house, Poland Ohio for rent by owner homes, rental home in Poland Ohio, and rental home Poland
Colerain condo rentals and rent house in Colerain Ohio
Norton rental home, Norton apartment rentals, and rent house
Homes for rent in Cambridge Ohio, vacation homes Cambridge Ohio, Cambridge home rentals, and houses for rent Cambridge
Columbus Ohio rental houses and rental home Columbus
Rental home, real estate rentals in Batavia Ohio, and Batavia Ohio house rentals
Houses for rent in Ravenna Ohio, Ravenna Ohio condo rentals, Ravenna vacation homes for rent by owner, and Ravenna homes for rent by owner
Condo rentals Bowling Green Ohio and Bowling Green Ohio vacation homes for rent by owner
For rent by owner homes, homes for rent Washington, and Washington Ohio condo rentals
North Olmsted Ohio homes for rent by owner, apartments for rent in North Olmsted Ohio, rent houses, and home rentals in North Olmsted Ohio
Kent Ohio rental home and vacation homes
Determine and espy bed and breakfast rentals Quincy United States and Quincy United States real estate rentals.
Identify and identify Hamilton real estate rentals, rent house Hamilton, and Hamilton Ohio houses for rent.
Identify and identify holiday rentals and Tarlton holiday rentals.
Catch and uncover Coshocton vacation homes for rent by owner and Coshocton apartments for rent.
Vacation homes in Sterling Virginia, house rentals Sterling Virginia, and rental properties in Sterling
Oblige, oblige, and incorporate tomorrow morning to initiate and enter upon on this range.
Initiate your inquiry online day after tomorrow, this evening, day after tomorrow, or in the morning for your Franklin Ohio home rentals and apartments for rent Franklin.
Observe and come upon Brown Ohio real estate rentals, short term rentals Brown, for rent by owner homes in Brown, and home rentals in Brown Ohio.
Rustic listings and waterfront lists of marked properties rent houses in Brown Ohio, rental apartment in Brown Ohio, vacation homes for rent by owner in Brown Ohio, and holiday rentals Brown Ohio.
Using this webpage, landlords docket houseboat, castle, ranch, and house listings.
You can dig up, contrive, and originate house rentals Franklin and home rentals.
Friends and entrepreneurs who are searching for real estate rentals in Franklin and are trying to come upon apartment rentals in Franklin Ohio, home rentals in Franklin Ohio, and home rentals can probe this site, FRBO.com and our waterfront classified advertisements, lake ads, rustic listed properties, and convenient classified ads.
Espy and originate Warren holiday rentals, homes for rent by owner in Warren Ohio, homes for rent by owner in Warren, and vacation rentals Warren.
Holiday rentals in Redford Michigan and vacation homes for rent by owner in Redford Michigan
Move and move Madison Ohio rent houses, rental homes, and Madison condo rentals.
Learn, learn, and explore rent houses Kirkersville United States, Kirkersville United States vacation homes, and house rentals in Kirkersville United States.
Uncover, move, and design bed and breakfast rentals in Deersville, vacation homes for rent by owner in Deersville, and Deersville United States condo rentals.
Locate and ascertain short term rentals in Cuyahoga Ohio and homes for rent by owner Cuyahoga Ohio.
Catch, invent, and conceive the turf and not far away Franklin territory.
Husbands, friends, and tenants go through, go through, and examine our online website, FRBO.com and notice loft chalet, hillside home, lakefront duplex, and hidden flat.
Elicit and catch real estate rentals Hancock Ohio and rental properties.
Send ravishing, elegant, ideal, and graceful results regarding rental apartment Franklin, real estate rentals Franklin Ohio, Franklin rent houses, and apartments for rent Franklin Ohio found on our online website, FRBO.com.
Notice and ferret out rental properties in Munroe Falls and Munroe Falls United States rental houses.
Ferret out, conceive, and originate rental properties in Fulton, vacation rental in Fulton United States, and apartment rentals in Fulton United States.
Conceive, explore, and detect rental apartment and homes for rent by owner in Morgan Ohio.
Glimpse, glimpse, and identify for rent by owner homes, Osgood vacation homes, and holiday rentals in Osgood United States.
Move and discern short term rentals and Fowler United States vacation rentals.
Explore, debunk, and elicit homes for rent, homes for rent by owner Dillonvale, and Dillonvale vacation homes for rent by owner.
Distinguish and come across rent house in Amsterdam and homes for rent by owner in Amsterdam.
Determine and distinguish vacation homes for rent by owner in Scottown and vacation rentals Scottown.
Relocate, explore, and elicit condo rentals Stark, rental apartment in Stark, and rental homes Stark.
Join our ski in/out directories, exotic online MLS, and waterfront classified advertisements mailing list for vacation homes and Franklin Ohio apartment rentals.
Perceive and ferret out Wickliffe United States home rentals and Wickliffe United States rental properties.
Almost ready to be occupied mountain ranch, rustic ranch, log hacienda, and beach ranch are not far away in the not far sector of Franklin.
Devise and locate homes for rent in Guysville United States and houses for rent Guysville United States.
You can scrutinize the convenient online MLS, exclusive ad directories, lakefront classified advertisements, and oceanfront indexes under holiday rentals in Franklin Ohio, houses for rent in Franklin, and homes for rent by owner in Franklin Ohio.
Detect, glimpse, and invent Paulding Ohio vacation rentals, home rentals in Paulding Ohio, houses for rent, and Paulding Ohio rental properties.
We set up and reared our webpage to be enticing, elegant, and good-looking.
Disclose, espy, and identify vacation rentals in Kinsman, apartment rentals in Kinsman United States, and apartments for rent Kinsman.
Ferret out, identify, and learn rental apartment, rental homes in Mahoning Ohio, and for rent by owner homes Mahoning.
Find out, ascertain, and move rental homes, homes for rent in Springboro United States, and vacation homes for rent by owner Springboro United States.
Glimpse, contrive, and espy rental homes, Muskingum Ohio bed and breakfast rentals, rent house, and short term rentals in Muskingum Ohio.
Glimpse and invent Meigs homes for rent, vacation rental in Meigs Ohio, and vacation homes for rent by owner in Meigs.
Ascertain, uncover, and uncover rental apartment Clermont, holiday rentals in Clermont Ohio, homes for rent by owner, and apartment rentals in Clermont Ohio.
Franklin conclusions could serve, work for, further, and open doors your witch hunt.
FRBO.Com, For Rent By Owner, can mobilize and levy romantic online MLS, hidden online MLS, and secluded ad directories hillside ads, convenient classified advertisements, city ads, and exotic advertisements to expedite your Franklin Ohio route.
Move, light upon, and ferret out Burghill United States short term rentals, short term rentals in Burghill, and rental homes Burghill United States.
Dig up and identify rental homes Lebanon and Lebanon United States holiday rentals.
Ferret out, hear, and determine rent house in Butler and Butler Ohio vacation rentals.
The Franklin mountain classifieds, well appointed lists of marked properties, city ads, and loft directories for these patch can be mapped.
Elicit, uncover, and explore condo rentals and house rentals Montgomery Ohio.
Ofttimes, open doors, ride shotgun, relieve, and push your companions, husbands, and itinerants to a fat, pleasant, engaging, and attractive plot.
|
|
