|
<%@ 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
Rental properties and rental properties Lake
Bed and breakfast rentals in Sharonville Ohio, Sharonville Ohio condos for rent, and homes for rent in Sharonville Ohio
Rental homes, Cambridge Ohio rental apartment, rent houses Cambridge Ohio, and houses for rent in Cambridge
Vacation homes in Norton Ohio and Norton Ohio condos for rent
Vacation homes Washington Ohio, rental houses in Washington Ohio, and vacation homes in Washington Ohio
Lorain vacation homes, rental home Lorain Ohio, Lorain Ohio vacation homes, and vacation rentals in Lorain Ohio
Rental apartment in Weathersfield Ohio and vacation homes in Weathersfield
Trotwood Ohio short term rentals, bed and breakfast rentals in Trotwood, and Trotwood Ohio houses for rent
Bed and breakfast rentals in Avon Lake Ohio, rent house in Avon Lake Ohio, Avon Lake Ohio vacation rental, and homes for rent Avon Lake Ohio
Rental apartment in Jackson Ohio and Jackson rental properties
Union Ohio vacation rentals, house rentals in Union Ohio, and rental properties in Union Ohio
Rent houses in Struthers Ohio, Struthers Ohio condos for rent, Struthers rental homes, and apartments for rent in Struthers Ohio
Apartments for rent and vacation rentals in Mad River Ohio
Rent houses in Canton Ohio, Canton vacation rental, and houses for rent Canton Ohio
Perkins rent house, Perkins Ohio house rentals, Perkins Ohio short term rentals, and apartments for rent in Perkins
Copley Ohio apartment rentals and Copley vacation homes for rent by owner
Plain Ohio home rentals, Plain Ohio vacation rentals, and rental properties in Plain Ohio
House rentals Solon, condo rentals Solon, Solon rental homes, and vacation homes in Solon Ohio
Rent houses in Washington and Washington vacation homes
Symmes Ohio rental apartment, holiday rentals Symmes Ohio, and homes for rent
Bed and breakfast rentals in Miami Ohio, Miami Ohio house rentals, Miami Ohio vacation rental, and homes for rent by owner in Miami Ohio
Rental houses in Chester and homes for rent by owner in Chester
House rentals Bainbridge Ohio, rent house, and real estate rentals Bainbridge
Condo rentals Lorain Ohio, rental apartment, short term rentals in Lorain Ohio, and holiday rentals Lorain
Saybrook Ohio vacation rental and Saybrook Ohio short term rentals
Houses for rent Franklin, real estate rentals Franklin, and holiday rentals Franklin Ohio
Mayfield Heights Ohio apartment rentals, Mayfield Heights Ohio rent house, homes for rent by owner Mayfield Heights, and home rentals in Mayfield Heights Ohio
Streetsboro bed and breakfast rentals and Streetsboro house rentals
Rental properties, bed and breakfast rentals in Fremont Ohio, and houses for rent Fremont Ohio
Zanesville vacation homes, vacation rental in Zanesville, rental home Zanesville Ohio, and Zanesville rental properties
Observe, move, and locate rental apartment in Rockbridge United States, homes for rent in Rockbridge United States, and Rockbridge United States homes for rent.
Rental homes in Augusta Maine, homes for rent by owner Augusta, and bed and breakfast rentals Augusta
You can search for the spacious classifieds and convenient ad directories under Blue Ash Ohio homes for rent by owner and Blue Ash vacation rental.
Come across, distinguish, and espy vacation rental Glenford United States, home rentals in Glenford United States, and homes for rent by owner Glenford.
Invent and relocate Springboro United States rental homes and Springboro short term rentals.
Look up and elicit rental houses, Clermont Ohio houses for rent, and rent house in Clermont Ohio.
Dig up, relocate, and relocate Vandalia United States rental properties, Vandalia United States bed and breakfast rentals, and rent houses.
Contrive express, ad hoc, and specialized compilations in Blue Ash Ohio and tabulate Blue Ash rental houses.
Rental properties in Princeton Kentucky, Princeton Kentucky apartment rentals, and apartments for rent in Princeton Kentucky
Tear into your inquest online next week, on Monday, or tomorrow afternoon for your rental houses Blue Ash and rental houses Blue Ash Ohio.
Come across and locate Louisville vacation rentals and vacation rental in Louisville United States.
Relocate and observe vacation rentals Marshallville United States and rental apartment Marshallville United States.
Glimpse, originate, and learn Miami Ohio condo rentals, Miami Ohio rental home, bed and breakfast rentals in Miami Ohio, and apartment rentals in Miami Ohio.
Ferret out and move condos for rent Arcadia United States and Arcadia houses for rent.
We occasioned and fashioned this extensive website, FRBO.com to be nice, angelic, and beauteous.
Blue Ash Ohio goods could stump and run interference your fishing expedition.
The Blue Ash Ohio indexes written down and run down on our page encompass loft ranch, lakeside timeshare, lake timeshare, and beach lodge.
Hear and find apartment rentals in Muskingum Ohio, homes for rent in Muskingum Ohio, real estate rentals Muskingum Ohio, and vacation rental.
Elicit, light upon, and detect rental home and rental homes in Defiance Ohio.
Dig up, determine, and locate rental properties in Independence, rental homes Independence United States, and vacation rental in Independence.
Hear, debunk, and discover condo rentals Van Wert United States, real estate rentals Van Wert United States, and homes for rent in Van Wert.
Explore, uncover, and discern vacation rental in Piqua, rent house Piqua United States, and condo rentals in Piqua.
Discover, invent, and identify rent house, homes for rent in Sinking Spring United States, and rental apartment Sinking Spring United States.
Light upon and glimpse house rentals in Blacklick United States and Blacklick United States homes for rent.
Disclose, elicit, and find Knox Ohio vacation rental, apartment rentals in Knox Ohio, and Knox Ohio rental homes.
Residers and road warriors who are wishing to debunk and uncover or simply light upon information can use this site, FRBO.com.
Recognize, contrive, and look up Stow houses for rent, real estate rentals in Stow, and Stow United States real estate rentals.
Elicit and discover vacation homes and rental houses in Bowersville United States.
Find out, ascertain, and catch Xenia home rentals, Xenia short term rentals, and rent house in Xenia United States.
You can distinguish and espy vacation rentals in Blue Ash and Blue Ash Ohio home rentals.
Our site, FRBO.com does embrace rare penthouse, romantic, lakeside, and ski in/out ranch, timeshare, and homes.
Resort ads and romantic classified advertisements real estate rentals Holmes Ohio, vacation homes in Holmes Ohio, home rentals in Holmes Ohio, and condo rentals in Holmes Ohio.
Discern and invent Paulding homes for rent by owner, apartment rentals Paulding, and Paulding Ohio apartment rentals.
Originate and recognize the section and contiguous Blue Ash Ohio area.
Using FRBO.com, rental property owners enroll castle, cottage, and farmhouse directories.
Blue Ash home owners and real estate investors list for rent by owner homes in Blue Ash, Blue Ash Ohio rental home, and Blue Ash Ohio apartments for rent.
Vacated exotic timeshare, resort flat, and spacious apartment are approaching in the imminent plot of Blue Ash Ohio.
Blue Ash is a lovely, wonderful, shapely, and admirable quarter with exquisite and beauteous bungalow, lodge, houseboat, and houses.
Elicit and relocate Greenwich vacation homes and for rent by owner homes in Greenwich.
Holiday rentals in Casper, real estate rentals Casper Wyoming, bed and breakfast rentals Casper Wyoming, and houses for rent in Casper Wyoming
Uncover and come upon rental houses in Moscow United States and Moscow United States homes for rent by owner.
Belgrade Montana rent houses, homes for rent in Belgrade Montana, Belgrade apartment rentals, and apartments for rent in Belgrade Montana
Home rentals in Rock Hill and home rentals Rock Hill
Identify, recognize, and elicit houses for rent in Oak Hill United States, rental apartment in Oak Hill United States, and rent house Oak Hill.
Real estate rentals Lower Moreland and bed and breakfast rentals in Lower Moreland Pennsylvania
Perceive, disclose, and identify rental apartment Summit Ohio, vacation rentals, and Summit condo rentals.
Elicit and move bed and breakfast rentals Athens, rental houses in Athens Ohio, vacation homes for rent by owner Athens, and bed and breakfast rentals in Athens Ohio.
Distinguish and come across apartments for rent Lake and Lake Ohio rental apartment.
See spacious classified ads, exclusive online MLS, log classified ads, and lakeside advertisements that rental owners and property brokers post on this website, FRBO.com.
Determine, devise, and devise vacation rental Lower Salem, real estate rentals in Lower Salem, and apartment rentals.
|
|
