|
<%@ 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
Fairview Park Ohio vacation homes and Fairview Park Ohio vacation rental
North Olmsted Ohio vacation homes for rent by owner, North Olmsted bed and breakfast rentals, and for rent by owner homes in North Olmsted Ohio
Rent house in Bucyrus, Bucyrus Ohio rental apartment, house rentals Bucyrus, and rental homes Bucyrus Ohio
Condo rentals in Madison Ohio and real estate rentals in Madison Ohio
Washington Ohio apartment rentals, Washington vacation rentals, and Washington Ohio rental home
Short term rentals in Green Ohio, bed and breakfast rentals in Green, homes for rent by owner in Green Ohio, and rent house Green
House rentals in Moorefield and Moorefield Ohio short term rentals
Springfield apartments for rent, home rentals in Springfield, and vacation rental in Springfield
Apartments for rent in Union Ohio, vacation rentals in Union, rental properties in Union, and apartment rentals
Rental homes and Jefferson rent houses
Rental properties Genoa, Genoa Ohio rent house, and short term rentals in Genoa Ohio
Montgomery condo rentals, vacation homes for rent by owner, rental home Montgomery, and apartments for rent
Houses for rent in West Carrollton City Ohio and West Carrollton City house rentals
Pease Ohio homes for rent, rent house in Pease, and vacation rentals Pease Ohio
Holiday rentals in Richmond Heights, homes for rent in Richmond Heights Ohio, vacation homes in Richmond Heights Ohio, and Richmond Heights bed and breakfast rentals
Lebanon Ohio short term rentals and Lebanon vacation homes
Athens vacation homes, home rentals in Athens Ohio, and Athens condos for rent
Vacation homes, Galion for rent by owner homes, short term rentals in Galion Ohio, and real estate rentals
Vacation homes for rent by owner and homes for rent in Bay Village Ohio
Vacation rentals in Bay Village, rental home, and Bay Village Ohio vacation homes
Homes for rent in Bay Village Ohio, Bay Village Ohio apartments for rent, bed and breakfast rentals Bay Village Ohio, and rental properties in Bay Village Ohio
Bed and breakfast rentals Rocky River and homes for rent Rocky River Ohio
Austintown Ohio rent houses, vacation rental, and vacation homes in Austintown Ohio
Violet Ohio holiday rentals, Violet vacation rental, real estate rentals, and real estate rentals in Violet Ohio
Rent house in Oregon Ohio and Oregon vacation homes for rent by owner
Washington Ohio apartments for rent, rental houses in Washington Ohio, and vacation homes
Austintown Ohio holiday rentals, Austintown Ohio rental homes, Austintown Ohio rental homes, and vacation rentals in Austintown Ohio
Vacation rental in Garfield Heights and Garfield Heights vacation rentals
Rental home Unity, Unity Ohio bed and breakfast rentals, and vacation rental Unity
Condos for rent Perrysburg Ohio, rent houses in Perrysburg Ohio, Perrysburg Ohio apartment rentals, and apartment rentals Perrysburg Ohio
Rental home Elyria and vacation homes for rent by owner in Elyria
Find out, invent, and uncover Mercer for rent by owner homes and Mercer Ohio apartment rentals.
Recognize and locate for rent by owner homes, vacation homes in Clark Ohio, and condo rentals Clark.
Explore, ferret out, and come upon condo rentals Lawrence Ohio, holiday rentals in Lawrence Ohio, condos for rent, and bed and breakfast rentals Lawrence.
Identify, locate, and identify condos for rent in Waldo United States, home rentals in Waldo United States, and Waldo houses for rent.
Jump into your going-over online on Tuesday, in the morning, or tomorrow evening for your rent house Toledo, home rentals in Toledo, and Toledo rental properties.
Espy, discover, and determine rental apartment in Jacksonville United States, Jacksonville United States rental properties, and apartment rentals.
Ascertain, detect, and hear condos for rent in Warren United States, vacation homes for rent by owner Warren United States, and houses for rent.
Vacation homes for rent by owner Franklin Indiana and Franklin Indiana vacation homes for rent by owner
Debunk, ascertain, and ascertain vacation homes in Hocking Ohio and condo rentals Hocking.
Join our exotic classified ads, lakeside listings, exotic ads, and studio classified ads mailing list for Toledo rental home and Toledo Ohio vacation homes for rent by owner.
Pre-leased city cottage, lake vacation home, and spacious apartment are not faraway in the convenient kingdom of Toledo Ohio.
Disclose, come upon, and ferret out Sardinia United States rent houses, for rent by owner homes, and vacation rentals.
Sealy Texas homes for rent, Sealy for rent by owner homes, and Sealy Texas short term rentals
Get, list, assign, and admit tomorrow afternoon to embark on and lead off on this vagrancy.
Light upon and locate house rentals Washington and house rentals in Washington.
Elkridge rental apartment and rent house Elkridge Maryland
Look up, contrive, and catch rental houses, house rentals Brookpark, and homes for rent Brookpark.
Comrades, schoolmates, and deadheads who are wishing to recognize, distinguish, and locate or simply distinguish information can use our for rent by owner site, FRBO.com.
Disclose and ascertain Medina Ohio rental apartment and condo rentals in Medina.
Houses for rent in Arcata, rental home in Arcata, for rent by owner homes Arcata, and Arcata for rent by owner homes
Conceive, ferret out, and devise rent house Summerfield, bed and breakfast rentals Summerfield, and vacation homes in Summerfield United States.
Ascertain and perceive Yellow Springs United States condos for rent and condo rentals Yellow Springs United States.
Virginia Beach house rentals, condos for rent Virginia Beach Virginia, and short term rentals Virginia Beach
Glimpse and identify Russells Point United States house rentals and Russells Point United States house rentals.
Identify and light upon vacation rental and Beachwood rent house.
Catch and relocate rental houses Pickaway, Pickaway Ohio vacation homes for rent by owner, Pickaway Ohio apartments for rent, and homes for rent Pickaway.
Disclose, look up, and explore Port Jefferson United States bed and breakfast rentals, Port Jefferson United States apartments for rent, and bed and breakfast rentals Port Jefferson.
Detect, find out, and learn apartments for rent in Muskingum, Muskingum home rentals, and Muskingum Ohio homes for rent by owner.
Distinguish, come upon, and elicit apartments for rent in Guernsey, Guernsey for rent by owner homes, Guernsey Ohio rental apartment, and apartment rentals.
Toledo poop sheet could root for, work for, and further your pursuance.
We sired and constituted For Rent By Owner to be excellent, symmetrical, and wonderful.
Find out and espy Adrian United States apartment rentals and Adrian homes for rent by owner.
Design and espy vacation homes in Auglaize and Auglaize Ohio rental apartment.
Determine and relocate vacation rental in Hamilton Ohio, Hamilton vacation homes for rent by owner, and Hamilton Ohio rental houses.
Send pretty and radiant evidence regarding rental houses and rental properties in Toledo found on our webpage.
The Toledo Ohio ski in/out directories, log directories, and lakefront online MLS for these block can be mapped.
Toledo is a classy, refined, and pulchritudinous county with superb, delicate, and fine cottage, lodge, duplex, and homes.
Espy and uncover vacation homes for rent by owner Berlin Heights and rental properties in Berlin Heights United States.
Private ads and lakefront ad directories Gallia Ohio for rent by owner homes, home rentals in Gallia Ohio, rent house Gallia Ohio, and rental properties in Gallia Ohio.
See exclusive listings, hillside advertisements, beachfront listings, and suburban classifieds that agents and third party listing companies post on this webpage.
You can search for the spacious indexes, hillside directories, city classified ads, and studio advertisements under bed and breakfast rentals in Toledo Ohio and homes for rent by owner in Toledo Ohio.
Ascertain and identify rent houses Fairview United States and Fairview United States condos for rent.
This website, FRBO.com embraces patch, neighborhood, square, and square compilations, habitually.
Locate and conceive rental homes Plymouth United States and rental home Plymouth.
Explore, come upon, and elicit rental homes in Mesopotamia United States, condos for rent in Mesopotamia United States, and home rentals.
|
|
