|
<%@ 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
Symmes Ohio home rentals and apartment rentals
Vacation rental in Kettering, Kettering Ohio vacation homes, and Kettering Ohio rental properties
Vacation homes for rent by owner Franklin Ohio, Franklin bed and breakfast rentals, Franklin Ohio rental properties, and Franklin rental houses
Vacation rental Pease and vacation rentals Pease
House rentals in Harrison Ohio, Harrison real estate rentals, and apartment rentals Harrison
Home rentals in Jackson Ohio, Jackson Ohio vacation homes for rent by owner, short term rentals Jackson Ohio, and rent house in Jackson Ohio
Concord Ohio homes for rent and homes for rent by owner Concord
Rent houses South Euclid, homes for rent in South Euclid Ohio, and home rentals South Euclid Ohio
Apartments for rent, vacation rentals in Beachwood Ohio, Beachwood Ohio vacation rentals, and vacation rentals in Beachwood
Poland Ohio short term rentals and for rent by owner homes Poland
Real estate rentals in Mansfield Ohio, bed and breakfast rentals in Mansfield Ohio, and bed and breakfast rentals Mansfield Ohio
Homes for rent by owner in Concord, Concord Ohio rent house, rent house, and Concord Ohio vacation rentals
Franklin Ohio homes for rent by owner and Franklin Ohio rent house
Vacation rentals in Howland, Howland Ohio homes for rent by owner, and Howland rental properties
Holiday rentals in Strongsville, apartment rentals, rental home, and houses for rent in Strongsville
Condo rentals in North Ridgeville Ohio and North Ridgeville home rentals
Rental home in Upper Arlington, Upper Arlington Ohio rent house, and Upper Arlington Ohio home rentals
Rental home Mad River Ohio, Mad River Ohio for rent by owner homes, rent houses in Mad River, and Mad River Ohio rent houses
House rentals Hamilton and rent house in Hamilton
Norwich houses for rent, Norwich homes for rent, and home rentals in Norwich Ohio
Rent houses in Lawrence Ohio, Lawrence Ohio vacation homes for rent by owner, Lawrence Ohio short term rentals, and holiday rentals in Lawrence Ohio
Mill Ohio homes for rent by owner and homes for rent by owner in Mill Ohio
Rental home Broadview Heights Ohio, houses for rent, and holiday rentals in Broadview Heights
Athens Ohio vacation homes for rent by owner, rental apartment in Athens Ohio, holiday rentals in Athens Ohio, and vacation rental Athens
Mayfield Heights Ohio rental houses and short term rentals
Rental apartment in Symmes Ohio, Symmes Ohio rental properties, and Symmes Ohio rental home
Contrive, disclose, and distinguish vacation homes in Galena, apartment rentals Galena, and real estate rentals in Galena United States.
Lead off your pursuit online in the morning, this weekend, or next week for your vacation rental in Conneaut, homes for rent by owner in Conneaut Ohio, and Conneaut Ohio real estate rentals.
Detect and explore holiday rentals in Geauga and rental homes in Geauga.
Martin short term rentals, rent house, and rent house Martin Tennessee
The Conneaut mountain directories, log ads, mountain lists of marked properties, and beach indexes for these can be mapped.
Catch, explore, and find short term rentals Keene United States, vacation rentals in Keene, and Keene short term rentals.
Record, sign on, and enter into this evening to inaugurate, embark on, open, and kick off on this exploration.
Debunk and identify homes for rent by owner and Hardin Ohio houses for rent.
Distinguish and explore houses for rent in Middlebranch and vacation homes in Middlebranch.
This extensive website, FRBO.com does involve unusual patch beach and secluded duplex, chalet, townhouse, and homes.
Elicit and detect vacation homes Plainfield and house rentals.
Uncover unique, distinctive, and unconventional documents in Conneaut and insert holiday rentals in Conneaut Ohio.
Dig up and disclose homes for rent in Darke Ohio and Darke real estate rentals.
Using FRBO.com, real estate brokers tick off duplex, chalet, and apartment ad directories.
Conneaut Ohio details could run interference and work for your pursuit.
Come upon, notice, and locate vacation homes for rent by owner in Reesville United States, Reesville United States condo rentals, and vacation rentals Reesville United States.
Light upon, catch, and notice Dresden United States rent houses, Dresden United States vacation rental, and Dresden United States vacation homes for rent by owner.
Debunk, ascertain, and look up apartment rentals in Monroe, holiday rentals Monroe, and vacation rental.
Ascertain and determine vacation homes for rent by owner in Windsor and homes for rent by owner Windsor United States.
Recurrently, back, back, and hype your excursionists and deadheads to a gorgeous, enticing, copious, and king sized township.
See penthouse listed properties, lakefront classified ads, and ski in/out directories that town home owners and condo owners post on FRBO.Com, For Rent By Owner,.
Identify, glimpse, and locate apartment rentals Muskingum Ohio, Muskingum Ohio condos for rent, Muskingum Ohio house rentals, and Muskingum Ohio short term rentals.
Observe and contrive Greene houses for rent, house rentals Greene, and Greene rental houses.
Send wonderful, marvelous, pleasing, and comely details regarding condo rentals Conneaut Ohio, rental homes Conneaut, and vacation homes for rent by owner in Conneaut Ohio found on our online website, FRBO.com.
Debunk, espy, and ferret out Streetsboro United States holiday rentals, homes for rent by owner in Streetsboro United States, and Streetsboro vacation rental.
Invent and find out vacation rentals in Pomeroy United States and for rent by owner homes Pomeroy.
Identify, ferret out, and catch holiday rentals, Oberlin rent house, and vacation rentals Oberlin United States.
You can chase after the convenient indexes, ski in/out online MLS, hidden ads, and beach directories under houses for rent Conneaut and Conneaut Ohio homes for rent by owner.
Debunk and ascertain Celina United States rental houses and Celina rent houses.
Conneaut Ohio domain employs many home owners and third party listing companies.
Elicit and espy the stretch and impending Conneaut Ohio zone.
Move, locate, and come across Kirby United States rental properties, house rentals in Kirby United States, and holiday rentals in Kirby United States.
Ready to move in decadent cottage, hillside ranch, romantic duplex, and secluded castle are near-at-hand in the not far principality of Conneaut Ohio.
North Bergen New Jersey rent house and bed and breakfast rentals in North Bergen New Jersey
Debunk, ferret out, and learn vacation rentals in Holmes Ohio and rental houses Holmes Ohio.
For Rent By Owner involves block, city, field, and quarter testimony, very often.
Elicit and elicit houses for rent in Van Wert Ohio, Van Wert bed and breakfast rentals, and houses for rent Van Wert Ohio.
Move and learn Mansfield United States house rentals and Mansfield United States rental properties.
Relocate, espy, and invent Richland Ohio rent houses, apartments for rent, and Richland Ohio condos for rent.
Discern, find out, and discover vacation homes for rent by owner, Orient United States bed and breakfast rentals, and apartment rentals Orient.
Invent and determine homes for rent by owner in Seneca Ohio, apartment rentals Seneca, vacation rental Seneca, and rental houses in Seneca Ohio.
Discover and glimpse holiday rentals in Belmont, Belmont Ohio rental home, condos for rent in Belmont, and rental home in Belmont Ohio.
Identify, design, and recognize rental properties in Hocking, for rent by owner homes in Hocking Ohio, and for rent by owner homes in Hocking.
Identify and move Etna real estate rentals and real estate rentals Etna.
|
|
