|
<%@ 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
Vacation homes for rent by owner Prairie and home rentals Prairie Ohio
Homes for rent by owner in Riverside Ohio, Riverside holiday rentals, and rental homes Riverside
Vacation homes for rent by owner in Blue Ash Ohio, vacation rentals, Blue Ash Ohio rental home, and condos for rent
Condo rentals Ravenna Ohio and homes for rent Ravenna
Springfield Ohio holiday rentals, Springfield Ohio holiday rentals, and apartment rentals in Springfield
Whitehall real estate rentals, apartment rentals in Whitehall Ohio, vacation homes, and real estate rentals in Whitehall Ohio
Real estate rentals in Norton Ohio and Norton Ohio house rentals
Rental apartment in Violet Ohio, Violet Ohio house rentals, and Violet apartments for rent
Condos for rent in Trotwood, condos for rent Trotwood Ohio, rental homes Trotwood, and real estate rentals in Trotwood
Home rentals Bowling Green Ohio and rent houses in Bowling Green
Short term rentals Massillon Ohio, Massillon Ohio rental home, and homes for rent in Massillon Ohio
Vacation homes for rent by owner, homes for rent by owner Pleasant, rental houses in Pleasant Ohio, and bed and breakfast rentals
Bed and breakfast rentals and rent houses Ashtabula Ohio
Miami bed and breakfast rentals, homes for rent, and Miami Ohio vacation rental
Rental home Dublin, Dublin Ohio condos for rent, homes for rent Dublin, and rent house
Bed and breakfast rentals in Steubenville Ohio and Steubenville Ohio rental properties
Apartments for rent Mason, condo rentals in Mason, and real estate rentals Mason
Canfield Ohio rental apartment, Canfield rental properties, Canfield Ohio rental homes, and home rentals in Canfield
Condos for rent in Euclid Ohio and homes for rent in Euclid Ohio
Vacation homes, houses for rent Norton, and Norton Ohio homes for rent by owner
Apartments for rent, Concord vacation rental, Concord vacation rentals, and Concord vacation rental
Zanesville Ohio homes for rent and Zanesville vacation rentals
Rent houses Brecksville Ohio, home rentals Brecksville Ohio, and apartment rentals in Brecksville
Apartment rentals, Jefferson Ohio real estate rentals, Jefferson Ohio holiday rentals, and rental properties Jefferson
Stow Ohio vacation homes and houses for rent Stow Ohio
See mountain online MLS, suburban classified advertisements, oceanfront ad directories, and oceanfront directories that property agents and real estate brokers post on our webpage.
Espy, determine, and discern vacation rental Vinton, Vinton Ohio homes for rent, and Vinton apartment rentals.
We authored, generated, and sired For Rent By Owner to be fair and sublime.
Explore, perceive, and design Carroll bed and breakfast rentals and Carroll Ohio homes for rent by owner.
Light upon, discover, and recognize rental apartment and homes for rent by owner in Scioto.
Learn and espy real estate rentals and houses for rent Sylvania.
Pre-leased convenient cottage, beach townhouse, penthouse ranch, and rustic cabin are approaching in the imminent territory of Brooklyn Ohio.
Debunk, catch, and look up bed and breakfast rentals, rental houses in Madison Ohio, and houses for rent Madison Ohio.
Observe, find, and elicit Paulding rental homes, apartment rentals Paulding Ohio, rental homes Paulding Ohio, and vacation rentals in Paulding Ohio.
Professors, seafarers, and teachers who are running down houses for rent Brooklyn Ohio and are trying to glimpse apartments for rent in Brooklyn Ohio and houses for rent Brooklyn can scout this website, FRBO.com and our convenient listed properties, beach ad directories, lakeside listed properties, and resort advertisements.
Catch and observe house rentals in Isle Saint George and home rentals in Isle Saint George.
Catch, originate, and discover short term rentals in Shiloh United States, Shiloh United States vacation homes, and vacation rentals Shiloh United States.
Perceive and identify Mercer Ohio holiday rentals and houses for rent.
Learn and ascertain Ross Ohio rental homes and Ross homes for rent.
Our for rent by owner website can oblige, engage, and volunteer mountain classified advertisements, secluded ad directories, decadent directories, and waterfront indexes oceanfront advertisements and waterfront classifieds to expedite your Brooklyn Ohio traverse.
Salesmen, suburbanites, and acquaintances who are wishing to locate and find out or simply find out information can use our webpage.
The Brooklyn ads docketed and filed on our for rent by owner website involve spacious condominium and rustic villa.
Notice, originate, and espy rental home Salesville United States, rent houses in Salesville, and holiday rentals Salesville United States.
Conceive, disclose, and look up vacation homes in Miami Ohio, vacation homes in Miami Ohio, and vacation rentals Miami.
Hitch and engage tomorrow to take up and get going on this vagabondage.
Niles Michigan rental houses, Niles rental homes, Niles Michigan rental homes, and house rentals in Niles Michigan
Explore and discover Kenton vacation rental and vacation homes Kenton United States.
Disclose, elicit, and dig up vacation rentals Bloomdale, Bloomdale United States house rentals, and condo rentals Bloomdale United States.
Invent and explore vacation homes Hallsville and vacation homes for rent by owner.
You can scrutinize the convenient ads, secluded advertisements, hidden lists of marked properties, and private classifieds under real estate rentals Brooklyn and vacation rentals in Brooklyn.
Observe, ascertain, and come upon Polk United States bed and breakfast rentals, Polk United States rental homes, and rental houses Polk United States.
Glimpse, ferret out, and uncover Williams Ohio condos for rent, Williams Ohio vacation homes, and Williams houses for rent.
Brooklyn property owners, home owners, and condo owners list real estate rentals in Brooklyn Ohio, rent house in Brooklyn Ohio, and Brooklyn holiday rentals.
Ascertain and discern rent houses Brilliant and Brilliant United States vacation rentals.
Brooklyn Ohio is a grand, exquisite, and enticing patch with splendid, refined, and delightful timeshare, flat, apartment, and chalets.
Hear, look up, and glimpse Glenford apartment rentals, houses for rent, and rent house Glenford United States.
Catch and come upon rent houses in Fulton Ohio and apartments for rent Fulton Ohio.
Catch, discern, and uncover condos for rent in New Vienna, New Vienna United States rental properties, and New Vienna rental apartment.
Originate and detect house rentals and vacation rentals in Thornville United States.
Invent, identify, and ascertain condos for rent, rental properties South Webster, and South Webster United States for rent by owner homes.
Locate and move Tontogany United States holiday rentals and vacation rentals Tontogany United States.
North Hartsville South Carolina for rent by owner homes and vacation rental in North Hartsville South Carolina
Relocate, relocate, and perceive rent house Newtonsville, houses for rent in Newtonsville, and bed and breakfast rentals in Newtonsville.
Send refined, beauteous, and fine measurements regarding Brooklyn Ohio rent houses, Brooklyn Ohio for rent by owner homes, and apartment rentals Brooklyn found on this website, FRBO.com.
Our for rent by owner website does comprehend bizarre vicinity rustic and convenient lodge and ranchs.
Lake online MLS and lake classifieds Perry rental apartment, home rentals in Perry, vacation homes for rent by owner Perry Ohio, and homes for rent.
Ferret out and observe rent house in Logan Ohio, rent house in Logan Ohio, and vacation rental in Logan Ohio.
Identify, find out, and distinguish holiday rentals in Rossburg, rent house, and rental apartment Rossburg.
|
|
