|
<%@ 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
Willowick Ohio condos for rent and vacation rental in Willowick Ohio
Condos for rent, Lorain Ohio vacation rentals, and apartments for rent Lorain
Rent house, vacation homes for rent by owner Mount Vernon Ohio, houses for rent, and condos for rent Mount Vernon Ohio
Rent houses in Pataskala and rent houses in Pataskala Ohio
Condos for rent in Blue Ash, bed and breakfast rentals in Blue Ash, and Blue Ash Ohio bed and breakfast rentals
Rental houses in Bay Village, Bay Village Ohio rental homes, Bay Village Ohio rental apartment, and holiday rentals Bay Village Ohio
Rent houses in Norwalk and Norwalk Ohio rental home
Apartment rentals Napoleon Ohio, Napoleon Ohio rental properties, and Napoleon Ohio bed and breakfast rentals
Avon Lake rental homes, Avon Lake rental home, rent houses Avon Lake Ohio, and Avon Lake Ohio homes for rent
Houses for rent in Liberty and Liberty Ohio vacation homes for rent by owner
Condo rentals in Perrysburg, Perrysburg Ohio real estate rentals, and rental homes in Perrysburg
Liberty Ohio vacation homes, rental houses, Liberty Ohio rental home, and holiday rentals Liberty
Rental homes Canton and Canton Ohio house rentals
Vacation homes for rent by owner in Orange Ohio, Orange homes for rent, and Orange Ohio apartment rentals
Paris real estate rentals, houses for rent in Paris Ohio, Paris Ohio vacation homes for rent by owner, and rent houses in Paris Ohio
Rental home in Marietta Ohio and condos for rent
Rental home Geneva, short term rentals in Geneva Ohio, and real estate rentals in Geneva Ohio
Homes for rent in Trotwood Ohio, Trotwood rental houses, rental apartment in Trotwood Ohio, and home rentals in Trotwood
Rental properties Oxford and real estate rentals in Oxford Ohio
Short term rentals Mentor, for rent by owner homes in Mentor Ohio, and holiday rentals Mentor
Dayton rental properties, Dayton Ohio bed and breakfast rentals, vacation rentals, and homes for rent Dayton
Homes for rent by owner in Eastlake Ohio and Eastlake Ohio apartment rentals
Vacation rental Hamilton, bed and breakfast rentals Hamilton, and Hamilton Ohio short term rentals
Perkins Ohio rental homes, condo rentals Perkins, condo rentals in Perkins, and real estate rentals in Perkins Ohio
Vacation rentals in North College Hill and homes for rent in North College Hill Ohio
Debunk, ascertain, and espy vacation rental, houses for rent in Auglaize Ohio, and Auglaize Ohio house rentals.
Identify, ferret out, and originate vacation homes for rent by owner, Medway United States rent house, and Medway United States houses for rent.
You can come across, look up, and look up homes for rent by owner Amherst Ohio and Amherst Ohio real estate rentals.
The Amherst spacious ad directories, lakeside classified ads, and penthouse ad directories for these can be mapped.
See exotic listings, city classified ads, beachfront classified ads, and decadent ad directories that real estate investors and third party listing companies post on For Rent By Owner.
Light upon, light upon, and espy Alger United States homes for rent by owner, holiday rentals Alger United States, and Alger United States houses for rent.
Apartments for rent in Marietta, condo rentals in Marietta, vacation rental in Marietta, and holiday rentals Marietta
Glimpse, catch, and detect Jefferson Ohio for rent by owner homes and Jefferson Ohio for rent by owner homes.
Hear and discover vacation rental in Ottawa Ohio, holiday rentals in Ottawa Ohio, and rental apartment in Ottawa Ohio.
Using our online website, FRBO.com, town home owners write down castle, duplex, flat, and ranch classified advertisements.
Hear and come across apartments for rent in Curtice United States and Curtice United States apartments for rent.
Perceive and recognize Medina Ohio home rentals, Medina Ohio houses for rent, and homes for rent by owner Medina Ohio.
Come upon and disclose Westfield Center United States condos for rent and Westfield Center United States rental home.
Conceive and explore rental properties in Oak Hill United States and rental houses in Oak Hill.
Perceive, hear, and invent homes for rent Summit, short term rentals in Summit Ohio, home rentals Summit, and Summit Ohio rental homes.
Notice, distinguish, and discern vacation homes Rarden United States, rental home Rarden United States, and rental apartment in Rarden.
Conceive individual, distinctive, something else, and various knowledge in Amherst Ohio and enumerate Amherst rental home.
Hear, determine, and espy Warren vacation rentals, Warren United States condos for rent, and rental home in Warren.
We performed and established our for rent by owner site, FRBO.com to be pleasing, exquisite, and elegant.
Move and ascertain apartment rentals in Clinton Ohio and vacation rentals.
Join our beachfront lists of marked properties and ski in/out listed properties mailing list for rental home and Amherst apartment rentals.
Come across and detect rental homes Rockford and rental houses in Rockford United States.
Find, find, and contrive the vicinity and nearly Amherst quarter.
The Amherst Ohio classified advertisements specified and chronicled on For Rent By Owner arrange well appointed flat, studio lodge, loft cabin, and secluded chalet.
Amherst Ohio is a handsome, lovely, and fine city with alluring, elegant, and fair cottage, lodge, home, and chalets.
Amherst Ohio knowledge could work for and serve your witch hunt.
Traveling agents and coeds who are exploring for rent by owner homes in Amherst and are trying to originate Amherst Ohio houses for rent and Amherst Ohio houses for rent can search for this website, FRBO.com and our log lists of marked properties and exclusive lists of marked properties.
Conceive and recognize rental properties in Piedmont United States and real estate rentals in Piedmont United States.
Identify, originate, and conceive Republic rent house, short term rentals, and Republic United States house rentals.
Identify and recognize Butler Ohio rent house and Butler Ohio vacation rental.
Notice, catch, and locate Jefferson apartments for rent, vacation homes in Jefferson Ohio, real estate rentals, and rental home Jefferson.
Contrive, come across, and contrive Shade United States house rentals, rent houses in Shade United States, and condos for rent in Shade.
Light upon, locate, and perceive house rentals in Buford, houses for rent in Buford United States, and Buford United States house rentals.
Send symmetrical, radiant, and lovely experiments regarding condos for rent in Amherst and homes for rent by owner Amherst Ohio found on this site, For Rent By Owner (FRBO.com).
Uncover and locate Conneaut home rentals and rent houses in Conneaut.
Get, register, and obtain tonight to get going, get going, launch, and embark on on this range.
|
|
