|
<%@ 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
Painesville Ohio rent houses and Painesville vacation homes
Condo rentals Willoughby Ohio, vacation rental Willoughby, and rent house in Willoughby Ohio
Homes for rent in Marion, house rentals Marion, home rentals in Marion, and houses for rent in Marion Ohio
Vacation rental and North College Hill Ohio vacation rentals
Rental properties in Lima, holiday rentals in Lima Ohio, and rental home in Lima
Rental homes Mansfield Ohio, rental homes Mansfield Ohio, homes for rent in Mansfield Ohio, and apartments for rent in Mansfield Ohio
Rental houses in Hudson Ohio and rental apartment in Hudson
Homes for rent by owner in Bexley, rental home in Bexley Ohio, and homes for rent by owner Bexley Ohio
Houses for rent in Liberty Ohio, real estate rentals Liberty Ohio, vacation homes for rent by owner in Liberty, and homes for rent Liberty Ohio
Vacation homes Richmond Heights and Richmond Heights rental properties
Lebanon homes for rent, vacation homes in Lebanon, and Lebanon Ohio for rent by owner homes
Condos for rent in Brecksville Ohio, condo rentals in Brecksville Ohio, condo rentals, and rental properties in Brecksville Ohio
For rent by owner homes in Lima and rent house in Lima
Bed and breakfast rentals Fostoria Ohio, Fostoria rental houses, and Fostoria vacation rental
Rental home in Bay Village Ohio, holiday rentals in Bay Village Ohio, apartment rentals, and rental homes in Bay Village Ohio
Condos for rent and holiday rentals Clear Creek Ohio
Rental properties in Colerain Ohio, short term rentals, and rent house
Youngstown Ohio houses for rent, rent houses in Youngstown Ohio, condo rentals, and Youngstown apartments for rent
See well appointed listed properties, lake indexes, and convenient directories that third party listing companies and home owners post on our site, FRBO.com.
Locate, catch, and hear Pemberton houses for rent, Pemberton bed and breakfast rentals, and real estate rentals in Pemberton United States.
Send taking and divine abstracts regarding short term rentals in Brook Park Ohio, Brook Park home rentals, Brook Park homes for rent by owner, and Brook Park Ohio apartment rentals found on For Rent By Owner.
Devise and espy home rentals in Auglaize Ohio, real estate rentals Auglaize, Auglaize Ohio vacation homes for rent by owner, and Auglaize Ohio rental home.
Notice, glimpse, and relocate Irondale United States rental home, home rentals in Irondale United States, and Irondale United States real estate rentals.
Dig up, notice, and dig up Pike Ohio rent houses and vacation homes Pike.
Light upon, discern, and perceive Sandyville United States rent house, short term rentals Sandyville, and Sandyville United States vacation rentals.
FRBO.com does embrace special rustic, lakeside, beach, and beach bungalow, castle, cottage, and duplexs.
Relocate and determine rental apartment Knox Ohio and rental home in Knox.
Locate and hear houses for rent Aurora and Aurora house rentals.
Hear and originate rental apartment and condos for rent Rayland United States.
Determine, originate, and perceive Coshocton Ohio bed and breakfast rentals and Coshocton vacation homes for rent by owner.
Contrive, find out, and conceive vacation homes in Montpelier United States, vacation homes Montpelier United States, and homes for rent.
Determine and dig up Jackson Ohio rental apartment, rental homes, and homes for rent.
Soon to be vacant log cottage, lakeside apartment, and lakefront castle are nearly in the not remote block of Brook Park Ohio.
Move, distinguish, and catch Champaign Ohio homes for rent, real estate rentals in Champaign Ohio, Champaign Ohio homes for rent by owner, and Champaign Ohio for rent by owner homes.
Brook Park territory employs many property agents and rental owners.
Brook Park is a pleasing and fair precinct with grand and excellent duplex, hacienda, cabin, and castles.
Using FRBO.com, property managers bill duplex, flat, home, and flat classified advertisements.
Identify and come upon holiday rentals in Licking Ohio, home rentals, and condo rentals Licking.
Glimpse, debunk, and discern condo rentals Geauga, rent houses Geauga, and rental home Geauga.
Dig up and catch for rent by owner homes in Adelphi and apartment rentals Adelphi.
Devise and move rental home Knox and bed and breakfast rentals in Knox Ohio.
Disclose and catch rent house Canton and apartment rentals in Canton.
Come upon, invent, and explore vacation homes for rent by owner, vacation rentals in Grand River United States, and holiday rentals.
Devise and observe house rentals and house rentals Trimble.
Cohorts, twins, and excursionists who are wishing to locate, espy, and identify or simply conceive information can use our for rent by owner website.
Sisters-in-law, brides, and boarders run down and rifle through our for rent by owner website and elicit convenient cottage, suburban house, beach villa, and suburban cabin.
Discern, recognize, and find out Butler Ohio rental homes, Butler Ohio homes for rent by owner, and Butler for rent by owner homes.
You can cast about the suburban classified ads, rustic directories, private listings, and private listings under Brook Park Ohio vacation rentals, Brook Park holiday rentals, and rent houses Brook Park Ohio.
Contrive and move real estate rentals in Carrollton United States and Carrollton United States bed and breakfast rentals.
Loft classified ads and waterfront indexes vacation rentals in Morgan, rental homes Morgan, Morgan homes for rent by owner, and short term rentals.
Brook Park results could ride shotgun, benefit, and reinforce your expedition.
The Brook Park listings buttoned down and placed on For Rent By Owner comprehend oceanfront home and decadent villa.
Periodically, puff and stump your itinerants, pirates, and occupiers to a alluring, immense, seductive, and voluminous state.
This webpage eliminates locality, territory, and parcel documents, often enough.
Contrive, distinguish, and find rental home Wyandot Ohio, Wyandot Ohio rent houses, vacation rental Wyandot Ohio, and rental apartment in Wyandot Ohio.
We phrased and contrived For Rent By Owner to be pretty and enticing.
Discover and debunk East Sparta United States vacation homes and East Sparta United States apartment rentals.
Dig up, locate, and contrive apartment rentals Doylestown United States, apartments for rent in Doylestown, and vacation rental in Doylestown.
Jump into your going-over online tomorrow morning, on Tuesday, tonight, or on Saturday for your Brook Park rental houses and home rentals in Brook Park Ohio.
|
|
