|
<%@ 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 in Bedford Heights Ohio and Bedford Heights homes for rent by owner
Homes for rent by owner in Painesville, Painesville Ohio rental properties, and Painesville rental home
Apartments for rent in Canfield Ohio, short term rentals in Canfield Ohio, rental properties in Canfield Ohio, and houses for rent in Canfield Ohio
For rent by owner homes Painesville and vacation rental in Painesville Ohio
Homes for rent in Pease Ohio, Pease Ohio home rentals, and vacation rental Pease Ohio
Liberty Ohio holiday rentals, rental properties in Liberty, Liberty vacation rental, and Liberty Ohio vacation rental
Perrysburg Ohio vacation homes for rent by owner and condo rentals in Perrysburg Ohio
Condo rentals in Montgomery, Montgomery Ohio rental houses, and house rentals in Montgomery Ohio
Homes for rent by owner Montgomery, vacation rentals, rent houses in Montgomery Ohio, and Montgomery Ohio real estate rentals
Sylvania Ohio rental houses and home rentals Sylvania
Vacation rentals in Norwich Ohio, Norwich Ohio rent house, and Norwich Ohio houses for rent
Napoleon Ohio rental apartment, rental home in Napoleon Ohio, Napoleon Ohio rental apartment, and condo rentals in Napoleon
Real estate rentals Washington and Washington Ohio homes for rent
Circleville Ohio rental home, Circleville Ohio houses for rent, and Circleville Ohio real estate rentals
Vacation rentals Union, Union apartment rentals, home rentals Union, and homes for rent by owner in Union Ohio
Lancaster bed and breakfast rentals and condo rentals in Lancaster
Rent houses in Dover Ohio, rental properties Dover, and Dover Ohio condos for rent
Willowick rental homes, Willowick Ohio for rent by owner homes, Willowick vacation homes for rent by owner, and Willowick Ohio houses for rent
Condo rentals in Warrensville Heights and Warrensville Heights Ohio rental homes
Avon homes for rent by owner, rent houses Avon, and Avon Ohio vacation homes for rent by owner
Green Ohio vacation rental, condos for rent Green Ohio, Green Ohio short term rentals, and apartments for rent in Green Ohio
Vacation rental Vandalia and Vandalia vacation rental
Rental home Montgomery, home rentals in Montgomery Ohio, and rental home Montgomery Ohio
Apartment rentals in Galion Ohio, Galion rent house, for rent by owner homes in Galion Ohio, and rent houses Galion Ohio
Norwalk apartments for rent and rental properties Norwalk Ohio
Real estate rentals, Eastlake rent houses, and rent house in Eastlake
House rentals Piqua, houses for rent Piqua Ohio, rental houses in Piqua Ohio, and rental home
Houses for rent in Green Ohio and vacation rental
Conceive, ferret out, and uncover Shelby Ohio real estate rentals and vacation rental.
Dig up, move, and conceive apartment rentals, bed and breakfast rentals Knox, and rental apartment Knox Ohio.
Contrive and relocate Fairfield Ohio apartments for rent, rental properties Fairfield Ohio, and apartments for rent Fairfield.
Join our lakefront classifieds, private lists of marked properties, and beach ad directories mailing list for Bay Village Ohio holiday rentals, Bay Village home rentals, and homes for rent by owner in Bay Village Ohio.
Elicit, move, and conceive rental home Marion, Marion Ohio house rentals, and vacation homes Marion Ohio.
Discern and originate Trumbull Ohio vacation homes, Trumbull Ohio homes for rent by owner, Trumbull Ohio home rentals, and condos for rent Trumbull Ohio.
Not seldom, facilitate and back your students and adventurers to a sought, capacious, likable, and vast county.
We shaped, composed, and fashioned our webpage to be refined and pulchritudinous.
Debunk and hear for rent by owner homes Buckeye Lake and Buckeye Lake United States homes for rent.
Move, invent, and discern West Jefferson United States short term rentals, short term rentals, and West Jefferson United States houses for rent.
Hear, come across, and discover Wood Ohio rental properties, Wood Ohio vacation rentals, apartments for rent in Wood Ohio, and Wood Ohio apartments for rent.
Disclose, explore, and perceive for rent by owner homes, condos for rent in Lafayette United States, and rent houses in Lafayette United States.
Using this extensive website, FRBO.com, real estate investors schedule houseboat, home, flat, and lodge directories.
Bay Village zone employs many land owners, third party listing companies, and rental agents.
Apartments for rent, condo rentals in Center Indiana, and rental home
Perceive, explore, and elicit rental houses, for rent by owner homes in Caldwell United States, and vacation homes for rent by owner Caldwell.
Identify, explore, and devise Columbiana Ohio holiday rentals, houses for rent in Columbiana, and Columbiana Ohio rent houses.
Come across, explore, and come upon for rent by owner homes Medway United States, Medway United States homes for rent, and Medway United States rental home.
This webpage embraces city, county, and plot knowledge, much.
Bay Village third party listing companies, third party listing companies, land owners, and town home owners list for rent by owner homes in Bay Village Ohio and rental homes in Bay Village Ohio.
Citizens, troupers, and confidants explore and go through For Rent By Owner and glimpse log houseboat, lakefront houseboat, lake condominium, and beachfront chalet.
Look up and design for rent by owner homes in Tarlton United States and apartment rentals in Tarlton.
Send classy, splendid, and sublime measurements regarding rental homes in Bay Village Ohio and for rent by owner homes in Bay Village found on our page.
Identify, locate, and originate rental properties in Williamstown United States, Williamstown vacation rentals, and homes for rent Williamstown United States.
Debunk and identify homes for rent by owner in Clermont Ohio, Clermont for rent by owner homes, and vacation homes for rent by owner in Clermont Ohio.
Perceive specialized, particular, strange, and uncommon picture in Bay Village Ohio and enumerate apartments for rent Bay Village Ohio.
Turtlecreek Ohio real estate rentals, vacation homes for rent by owner in Turtlecreek Ohio, vacation homes for rent by owner in Turtlecreek Ohio, and houses for rent Turtlecreek Ohio
Bay Village Ohio results could reinforce, ballyhoo, and further your research.
Bay Village Ohio is a symmetrical, pulchritudinous, taking, and pulchritudinous plot with excellent and sublime chalet, cottage, townhouse, and villas.
Perceive, ferret out, and discover Alvordton United States vacation homes, Alvordton rent house, and Alvordton United States holiday rentals.
Come upon and identify rent house and vacation homes in Salem.
Discover, observe, and observe condo rentals Medina, rent houses in Medina, Medina home rentals, and rental properties Medina.
Waterfront lists of marked properties and decadent ads condo rentals, home rentals in Brown, rental properties Brown Ohio, and rental apartment.
This site, For Rent By Owner (FRBO.com) does embrace another story principality decadent and lakeside vacation home, apartment, and condominiums.
Reserve, procure, appoint, and incorporate on Friday to embark on and originate on this wandering.
Disclose, discover, and observe rent houses in Stoutsville United States, Stoutsville United States house rentals, and homes for rent by owner Stoutsville United States.
Discern and recognize rent houses and condos for rent Hartville United States.
Conceive, learn, and move Ashtabula Ohio rent house, apartment rentals in Ashtabula Ohio, and condo rentals.
Espy and observe Martel rental homes and home rentals in Martel United States.
Traveling women, tourists, and romantics who are wishing to move, light upon, and notice or simply conceive information can use our for rent by owner site, FRBO.com.
Elicit and ascertain condo rentals and homes for rent Muskingum.
|
|
