|
<%@ 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
Short term rentals in Boardman Ohio and Boardman Ohio rental apartment
Condos for rent in Alliance, Alliance Ohio rental apartment, and Alliance vacation homes for rent by owner
For rent by owner homes University Heights, University Heights Ohio house rentals, rental apartment in University Heights Ohio, and rental houses
Condo rentals in Urbana and rent house Urbana Ohio
Rental properties, real estate rentals Upper Arlington Ohio, and Upper Arlington Ohio apartments for rent
Avon Lake Ohio houses for rent, Avon Lake Ohio apartments for rent, homes for rent in Avon Lake Ohio, and condos for rent Avon Lake Ohio
American Ohio for rent by owner homes and rent houses in American Ohio
Warrensville Heights bed and breakfast rentals, Warrensville Heights Ohio vacation homes, and Warrensville Heights Ohio homes for rent by owner
Rental homes Tiffin Ohio, condo rentals in Tiffin Ohio, Tiffin Ohio rental houses, and Tiffin Ohio homes for rent by owner
Homes for rent by owner in Medina Ohio and condo rentals Medina Ohio
Vacation homes in Stow Ohio, real estate rentals in Stow, and Stow Ohio vacation rental
Vacation rentals Lawrence Ohio, Lawrence house rentals, rent house Lawrence Ohio, and Lawrence apartments for rent
Apartments for rent in Mad River Ohio and rent houses Mad River Ohio
Condo rentals Saybrook Ohio, Saybrook Ohio holiday rentals, and Saybrook Ohio apartment rentals
Rent house in Brunswick Ohio, Brunswick bed and breakfast rentals, vacation rental in Brunswick Ohio, and homes for rent in Brunswick
Miami Ohio house rentals and Miami Ohio rental properties
Wooster Ohio rental apartment, Wooster Ohio real estate rentals, and rental home Wooster
Homes for rent by owner in Trotwood, rental apartment in Trotwood Ohio, short term rentals, and vacation rentals Trotwood
Vacation homes for rent by owner and homes for rent
Real estate rentals, Miami Ohio apartment rentals, and houses for rent Miami Ohio
Green Ohio houses for rent, Green homes for rent, homes for rent in Green, and rental homes Green
We devised, started, and contrived this site, For Rent By Owner (FRBO.com) to be refined, beauteous, and radiant.
Find out, conceive, and move Port Clinton United States homes for rent by owner, holiday rentals in Port Clinton United States, and Port Clinton United States rent house.
Conceive and uncover vacation homes Union, holiday rentals in Union Ohio, and Union homes for rent.
Inaugurate your expedition online on Thursday or on Friday for your for rent by owner homes in Beavercreek Ohio and homes for rent in Beavercreek.
Our page can place, get, attract, and take on romantic lists of marked properties, oceanfront advertisements, and ski in/out listed properties decadent advertisements and private ad directories to support your Beavercreek Ohio run.
Glimpse, find out, and espy vacation homes Athens Ohio, rental houses Athens Ohio, and houses for rent in Athens Ohio.
Invent, light upon, and identify rent house, condo rentals in Portage Ohio, and real estate rentals in Portage.
Notice, come across, and design condo rentals in South Solon United States, South Solon United States vacation homes for rent by owner, and South Solon United States vacation homes for rent by owner.
Romantics and traveling saleswomen who are smelling around rental homes and are trying to dig up Beavercreek Ohio home rentals, real estate rentals in Beavercreek Ohio, and apartments for rent Beavercreek can explore For Rent By Owner and our lakeside directories, penthouse listed properties, spacious ad directories, and private lists of marked properties.
Come across, discern, and design holiday rentals Van Wert Ohio, short term rentals in Van Wert Ohio, apartment rentals in Van Wert Ohio, and house rentals Van Wert.
Recognize, identify, and explore vacation homes for rent by owner Manchester, homes for rent by owner in Manchester, and Manchester rental apartment.
Our for rent by owner site, FRBO.com comprises principality, zone, township, and stretch info, customarily.
Beavercreek Ohio sector employs many agents, real estate agents, property agents, and property agents.
Relocate, determine, and contrive rental home in Madison and rental properties.
Beavercreek condo owners and property managers list rental homes, rent house, rental apartment Beavercreek, and house rentals in Beavercreek.
Originate and devise Scioto Ohio condo rentals, real estate rentals in Scioto Ohio, and Scioto Ohio rental houses.
Distinguish special and various notes in Beavercreek and set down Beavercreek Ohio rental houses.
Observe, move, and ferret out Jackson houses for rent, short term rentals, bed and breakfast rentals in Jackson, and apartments for rent in Jackson Ohio.
Beavercreek is a classy and statuesque territory with superb, statuesque, and shapely condominium, house, and haciendas.
Ascertain and relocate apartment rentals Hardin Ohio and house rentals in Hardin Ohio.
Hitch, inscribe, enter into, and enter on Friday to inaugurate and launch on this voyage.
Identify and design bed and breakfast rentals Diamond and rent house Diamond United States.
Beavercreek figures could assist, work with, and ride shotgun your fishing expedition.
Learn, detect, and debunk apartments for rent in Summit Ohio, vacation homes Summit Ohio, Summit Ohio rent houses, and rental properties Summit.
Invent and notice Van Wert Ohio apartments for rent and Van Wert Ohio rental apartment.
Hear, learn, and find houses for rent Felicity United States, house rentals Felicity United States, and vacation homes Felicity.
Find out, disclose, and elicit Warren Ohio vacation rental, bed and breakfast rentals, and homes for rent by owner.
Design and recognize Clark rental home, Clark Ohio home rentals, rent house Clark, and apartments for rent Clark.
Discern and espy apartments for rent Charm and Charm vacation rental.
You can look over the well appointed lists of marked properties, lake directories, and well appointed online MLS under rental properties Beavercreek, Beavercreek home rentals, and vacation homes for rent by owner Beavercreek Ohio.
|
|
