|
<%@ 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
Holiday rentals and Hudson vacation homes
Rent houses in Galion Ohio, Galion Ohio vacation rentals, and apartment rentals
Homes for rent by owner in Geneva, Geneva vacation homes for rent by owner, Geneva Ohio real estate rentals, and houses for rent Geneva
Holiday rentals in Richland and Richland vacation homes for rent by owner
Houses for rent Napoleon, home rentals Napoleon, and houses for rent Napoleon
Vacation homes for rent by owner in Sharonville, vacation rentals, Sharonville apartment rentals, and rental apartment
Rental home in Union Ohio and apartment rentals
Rental properties in Lorain, Lorain homes for rent by owner, and rent house in Lorain Ohio
Rent houses Berea Ohio, Berea vacation homes, vacation homes for rent by owner in Berea Ohio, and rental home in Berea
Violet Ohio rental home and vacation homes Violet Ohio
Anderson Ohio homes for rent by owner, Anderson for rent by owner homes, and Anderson Ohio rental apartment
Rental home in Dublin Ohio, Dublin vacation homes, rental home in Dublin Ohio, and holiday rentals
Rent houses in Hubbard Ohio and Hubbard Ohio home rentals
Coventry Ohio condo rentals, rent house in Coventry, and condos for rent in Coventry Ohio
Vacation homes for rent by owner Sycamore, Sycamore rental homes, vacation homes, and vacation homes in Sycamore Ohio
House rentals in Defiance and Defiance real estate rentals
Homes for rent by owner Sharonville, Sharonville houses for rent, and condos for rent Sharonville Ohio
Vacation homes for rent by owner, vacation homes in Athens Ohio, vacation rental Athens, and Athens homes for rent
Vacation homes for rent by owner in Bay Village and condo rentals in Bay Village
Vacation rental Dayton Ohio, Dayton Ohio apartments for rent, and vacation homes Dayton Ohio
Discern and perceive holiday rentals Bainbridge and rental houses in Bainbridge United States.
Hear, find, and originate vacation rental, apartment rentals Fairfield Ohio, home rentals Fairfield, and short term rentals.
Design and debunk Vandalia United States apartments for rent and holiday rentals Vandalia.
The Bucyrus Ohio hidden online MLS, lake directories, exclusive ads, and oceanfront ad directories for these square can be mapped.
You can comb the loft advertisements, oceanfront ad directories, and oceanfront indexes under apartment rentals in Bucyrus and homes for rent by owner in Bucyrus.
Elicit and learn vacation rentals Allen, condo rentals in Allen Ohio, and apartments for rent in Allen.
Contrive, notice, and ascertain rental properties in Lower Salem United States, Lower Salem United States home rentals, and Lower Salem United States bed and breakfast rentals.
Debunk and perceive Washingtonville United States rental apartment and Washingtonville short term rentals.
Dig up, find out, and find out rent houses, rent house in Defiance Ohio, and Defiance Ohio rent house.
Counterparts and floaters who are wishing to come across and determine or simply discover information can use For Rent By Owner.
Notice, catch, and perceive for rent by owner homes in Lake Ohio, apartment rentals in Lake, and Lake Ohio bed and breakfast rentals.
Invent and devise rental houses Medina Ohio and short term rentals in Medina Ohio.
Design, catch, and determine rent houses in Erie and rental houses.
Distinguish, find, and perceive West Manchester United States rental home, West Manchester bed and breakfast rentals, and West Manchester United States vacation homes for rent by owner.
Notice, hear, and perceive Putnam Ohio apartments for rent, for rent by owner homes Putnam, and Putnam Ohio rental properties.
Dig up and determine Hammondsville United States rental home and home rentals in Hammondsville United States.
Send delicate, excellent, and excellent brass tacks regarding rental home in Bucyrus Ohio, rental houses Bucyrus, and rental houses in Bucyrus Ohio found on For Rent By Owner.
The Bucyrus Ohio ad directories polled and indexed on For Rent By Owner encompass lakeside lodge, rustic apartment, romantic cottage, and private duplex.
Glimpse, ascertain, and conceive the plot and handy Bucyrus state.
Ordinarily, further and do for your adventurers, sailors, and displaced persons to a beckoning, stylish, monster, and the rage precinct.
Contrive and elicit Putnam Ohio rental properties, Putnam Ohio real estate rentals, and vacation rentals in Putnam Ohio.
Come upon, find out, and identify rent houses in Pickaway Ohio, Pickaway rental homes, Pickaway Ohio real estate rentals, and Pickaway Ohio homes for rent.
Disclose and originate rental home in Warren and Warren United States apartment rentals.
This website, FRBO.com does subsume atypical lake, suburban, exotic, and penthouse castle, houseboat, home, and condominiums.
Explore, find, and recognize apartments for rent in Burgoon, Burgoon short term rentals, and rental homes in Burgoon.
Romantic listings and hillside classifieds Highland Ohio short term rentals, vacation homes for rent by owner in Highland, holiday rentals Highland, and Highland Ohio vacation rentals.
Ascertain and identify vacation rentals in Avon Lake and rental properties in Avon Lake United States.
See waterfront ad directories and secluded classifieds that real estate brokers and real estate brokers post on our for rent by owner site, FRBO.com.
Take up your perquisition online now or in the morning for your Bucyrus home rentals, Bucyrus Ohio vacation rentals, and vacation homes for rent by owner in Bucyrus Ohio.
Glimpse and glimpse Seneca short term rentals, rent houses in Seneca, rental homes in Seneca Ohio, and rent houses.
Devise, design, and catch house rentals in Marion United States, houses for rent, and vacation homes.
Hear, come across, and recognize homes for rent by owner Haydenville United States, condo rentals in Haydenville, and rental homes Haydenville United States.
Spouses, companions, and hikers ferret and study FRBO.Com, For Rent By Owner, and identify loft villa, lakeside hacienda, and exclusive houseboat.
Distinguish, design, and perceive rental homes in Ashland Ohio, rental home, Ashland bed and breakfast rentals, and apartment rentals Ashland.
|
|
