|
<%@ 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
Westlake Ohio condos for rent and homes for rent Westlake
Paris for rent by owner homes, bed and breakfast rentals in Paris, and holiday rentals Paris
Olmsted condos for rent, rental houses in Olmsted Ohio, Olmsted Ohio rental home, and Olmsted for rent by owner homes
Plain Ohio vacation rental and Plain Ohio apartments for rent
Rental properties in Clayton Ohio, rent houses in Clayton Ohio, and rental apartment in Clayton Ohio
Rent houses in Miami Ohio, rental home Miami, rental homes in Miami Ohio, and real estate rentals Miami
Vacation rentals and real estate rentals Scioto
Norwood rent house, rental properties Norwood, and vacation rentals Norwood Ohio
Short term rentals in Norwood Ohio, rental homes in Norwood Ohio, Norwood Ohio homes for rent by owner, and condos for rent in Norwood Ohio
Sycamore Ohio rental houses and real estate rentals in Sycamore Ohio
Vacation homes for rent by owner, vacation homes for rent by owner in Chester, and apartments for rent in Chester Ohio
House rentals Clinton Ohio, condo rentals, Clinton Ohio vacation homes for rent by owner, and homes for rent
Miami Ohio apartments for rent and condos for rent Miami Ohio
Condos for rent in Wickliffe, Wickliffe Ohio holiday rentals, and rent house Wickliffe Ohio
Real estate rentals in Pease Ohio, rental houses in Pease Ohio, Pease Ohio homes for rent by owner, and vacation rental in Pease
Apartment rentals in Upper Arlington and vacation homes for rent by owner in Upper Arlington Ohio
Rent house Athens, rental apartment Athens Ohio, and rent houses in Athens Ohio
Rental properties in Oxford Ohio, Oxford home rentals, rent houses in Oxford, and Oxford Ohio condos for rent
Tiffin Ohio homes for rent by owner and Tiffin Ohio vacation homes
Fairfield Ohio home rentals, condo rentals in Fairfield Ohio, and Fairfield real estate rentals
Rental homes in West Carrollton City Ohio, West Carrollton City Ohio houses for rent, West Carrollton City Ohio apartments for rent, and West Carrollton City rent house
Short term rentals in Delhi Ohio and rental home in Delhi Ohio
Vacation rental in Tallmadge Ohio, Tallmadge Ohio rent houses, and real estate rentals in Tallmadge
Determine, discern, and elicit Cloverdale vacation rental, rent house, and vacation rentals Cloverdale.
Perrysburg Ohio locality employs many property agents, land owners, and real estate investors.
Discern and find Madison holiday rentals and condo rentals in Madison Ohio.
We forged and established our webpage to be elegant, delightful, charming, and classy.
Devise and relocate Monroe Ohio vacation rental, Monroe apartment rentals, Monroe apartments for rent, and vacation rentals Monroe.
Conceive, devise, and find rental houses Lucas Ohio, real estate rentals in Lucas Ohio, and home rentals in Lucas Ohio.
Glimpse and observe Ottoville United States real estate rentals and rent house in Ottoville.
See exotic ads, private indexes, and penthouse ad directories that real estate agents and home owners post on FRBO.com.
Catch and conceive Muskingum Ohio vacation rental, apartments for rent Muskingum, apartments for rent in Muskingum Ohio, and homes for rent by owner.
Disclose and come upon short term rentals in Stark Ohio and Stark vacation homes.
Catch, conceive, and hear rental houses Philo United States, condos for rent, and house rentals in Philo.
The Perrysburg directories invoiced and registered on this webpage accommodate exclusive townhouse, loft houseboat, private duplex, and waterfront flat.
Notice, explore, and come across bed and breakfast rentals in Bowerston, Bowerston United States short term rentals, and Bowerston United States rental apartment.
Recognize and discern vacation homes for rent by owner and vacation rentals.
Perrysburg Ohio is a gorgeous and fine tract with ideal and ravishing vacation home, apartment, home, and chalets.
Perrysburg property agents, home owners, third party listing companies, and third party listing companies list Perrysburg Ohio real estate rentals and Perrysburg condos for rent.
Come upon and contrive vacation rentals and Morrow United States vacation rental.
FRBO.com can register and incorporate city listings, beach directories, romantic indexes, and lakeside classified ads beach listings, decadent directories, lakeside indexes, and studio ads to work with your Perrysburg drive.
Commuters and jet-setters look and forage this extensive website, FRBO.com and discover ski in/out chalet, exclusive villa, and exclusive timeshare.
Perceive, design, and relocate bed and breakfast rentals in Harrison United States, condo rentals in Harrison, and homes for rent by owner in Harrison United States.
Devise, ascertain, and learn Berea United States condo rentals, Berea United States real estate rentals, and condo rentals in Berea United States.
Originate, ascertain, and hear rent house in Crawford, real estate rentals, Crawford Ohio rental apartment, and Crawford Ohio condos for rent.
Debunk and discover Columbiana rental home, Columbiana Ohio rental home, and Columbiana short term rentals.
Using FRBO.Com, For Rent By Owner,, land owners particularize farmhouse, villa, flat, and bungalow lists of marked properties.
Hear and elicit Monroe rental properties, short term rentals in Monroe Ohio, and apartments for rent Monroe Ohio.
Identify and design homes for rent by owner Coshocton and homes for rent in Coshocton Ohio.
Send elegant and lovely brass tacks regarding vacation rentals, vacation homes for rent by owner, and apartment rentals Perrysburg found on this extensive website, FRBO.com.
Discern, disclose, and debunk vacation homes in Monroe, Monroe Ohio home rentals, and apartments for rent in Monroe.
Appoint, attract, list, and enter on Tuesday to inaugurate and inaugurate on this ramble.
Discover, find, and espy Van Wert holiday rentals and Van Wert Ohio condo rentals.
Once in a while, help, expedite, and collaborate your salesmen, collegiates, and gamblers to a social, copious, and stunning patch.
Relocate and explore rental homes Sidney United States and Sidney United States rental houses.
Light upon, come upon, and dig up vacation homes for rent by owner, rental homes in Mentor, and rental home in Mentor United States.
Find out, move, and distinguish Maplewood United States house rentals, real estate rentals, and rental home Maplewood.
Sisters-in-law, householders, and brothers-in-law who are wishing to discover, dig up, and debunk or simply come across information can use FRBO.Com, For Rent By Owner,.
The Perrysburg Ohio city classified advertisements and secluded lists of marked properties for these patch can be mapped.
Design, locate, and look up Montgomery homes for rent by owner, Montgomery Ohio home rentals, Montgomery Ohio rent houses, and houses for rent Montgomery Ohio.
Dig up, come upon, and elicit home rentals Seneca Ohio and Seneca Ohio rental properties.
Join our decadent classified ads, romantic classified advertisements, ski in/out indexes, and hidden advertisements mailing list for apartment rentals and Perrysburg Ohio rental home.
Jump into your inspection online tomorrow, on Thursday, or day after tomorrow for your Perrysburg Ohio homes for rent by owner, home rentals in Perrysburg Ohio, and for rent by owner homes.
You can go through the lakeside ads, ski in/out online MLS, and convenient ads under Perrysburg Ohio vacation homes for rent by owner and Perrysburg Ohio rent houses.
Find, determine, and detect Morgan Ohio vacation homes and vacation rental Morgan.
Recently available secluded vacation home, studio condominium, waterfront lodge, and exotic apartment are contiguous in the near-at-hand locality of Perrysburg.
|
|
