|
<%@ 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
Lima Ohio apartment rentals and vacation rental in Lima Ohio
Clinton Ohio apartments for rent, houses for rent in Clinton, and Clinton rent house
Brooklyn Ohio houses for rent, Brooklyn Ohio vacation rental, Brooklyn Ohio home rentals, and rental houses Brooklyn
Homes for rent by owner in Bedford Heights Ohio and rental home in Bedford Heights
Rental apartment, Sharonville Ohio apartments for rent, and vacation homes in Sharonville Ohio
Rental properties in Lebanon Ohio, Lebanon Ohio homes for rent, rental homes, and Lebanon Ohio rental apartment
Apartments for rent in Chippewa and vacation rentals Chippewa Ohio
Vacation rental, for rent by owner homes in Twinsburg, and short term rentals Twinsburg
Apartment rentals in Mansfield Ohio, rental apartment in Mansfield Ohio, Mansfield Ohio vacation rentals, and Mansfield rental apartment
Real estate rentals in Mill and real estate rentals
Houses for rent in Lawrence, homes for rent in Lawrence Ohio, and vacation homes
Tiffin Ohio rent house, house rentals in Tiffin, apartment rentals in Tiffin, and Tiffin Ohio for rent by owner homes
Greenville Ohio vacation rentals and vacation rentals in Greenville Ohio
Condo rentals, Lima homes for rent, and houses for rent Lima
Condos for rent, homes for rent Franklin, homes for rent by owner in Franklin Ohio, and rent houses Franklin Ohio
Apartment rentals in Sharon Ohio and Sharon homes for rent by owner
Moorefield Ohio rental apartment, short term rentals in Moorefield Ohio, and vacation homes for rent by owner in Moorefield Ohio
Home rentals in Cambridge Ohio, vacation rental in Cambridge Ohio, bed and breakfast rentals in Cambridge Ohio, and bed and breakfast rentals in Cambridge Ohio
Rent houses in Lake Ohio and house rentals Lake Ohio
Plain Ohio rental houses, vacation rental in Plain Ohio, and rental home Plain
Norwalk Ohio rent houses, home rentals Norwalk, rental houses Norwalk, and homes for rent Norwalk Ohio
Rental apartment Anderson and condo rentals
Union bed and breakfast rentals, rental properties Union, and homes for rent by owner
Houses for rent Conneaut, homes for rent by owner in Conneaut, Conneaut Ohio rental home, and rental houses in Conneaut
Apartment rentals and condo rentals Springfield Ohio
Rental houses North Royalton, North Royalton Ohio homes for rent by owner, and North Royalton vacation rental
Garfield Heights Ohio rental home, Garfield Heights holiday rentals, vacation rentals in Garfield Heights Ohio, and holiday rentals in Garfield Heights
Youngstown Ohio condos for rent and vacation rentals in Youngstown Ohio
Devise, come across, and detect vacation rental Dillonvale, Dillonvale United States houses for rent, and Dillonvale United States rent house.
Beach ad directories and city lists of marked properties rental homes Knox, Knox Ohio vacation homes for rent by owner, vacation rentals Knox, and house rentals Knox Ohio.
Apartments for rent in Waukesha Wisconsin and bed and breakfast rentals Waukesha Wisconsin
Come across and come across Bellefontaine vacation homes for rent by owner and house rentals Bellefontaine United States.
Our website, FRBO.com omits block, territory, and county figures, not infrequently.
Contrive and perceive house rentals Jackson Ohio, Jackson Ohio condos for rent, and condo rentals in Jackson Ohio.
Almost ready to be occupied secluded home, private hacienda, well appointed lodge, and ski in/out hacienda are adjoining in the not to distant sector of Duchouquet Ohio.
See convenient indexes, exotic indexes, penthouse lists of marked properties, and private classified advertisements that agents and property brokers post on our online website, FRBO.com.
Devise, uncover, and discover rental properties, Trimble United States home rentals, and real estate rentals in Trimble United States.
Uncover and design Hammondsville United States condo rentals and apartment rentals in Hammondsville United States.
Glimpse and dig up condos for rent in Belle Valley United States and Belle Valley condos for rent.
Our for rent by owner website can place, initiate, engage, and enroll city advertisements and hidden listed properties beach advertisements, beachfront directories, exotic lists of marked properties, and exotic lists of marked properties to thump your Duchouquet Ohio route.
Come upon, dig up, and discern condo rentals in Jackson Ohio, rental apartment in Jackson, and vacation homes for rent by owner in Jackson.
Ferret out, notice, and light upon house rentals in Clermont Ohio, rental houses in Clermont Ohio, rental properties Clermont, and short term rentals in Clermont.
Recurrently, aid, open doors, puff, and ballyhoo your acquaintances and counterparts to a caught on, attractive, alluring, and well-liked sector.
Kent Maryland condo rentals, apartment rentals in Kent Maryland, vacation rentals Kent, and holiday rentals in Kent Maryland
Rental home Deep River North Carolina, Deep River North Carolina rental apartment, and Deep River North Carolina condos for rent
Glimpse, identify, and learn Trumbull Ohio rental homes, homes for rent in Trumbull, and Trumbull Ohio rental apartment.
Explore and detect holiday rentals in West Union United States and West Union United States vacation rentals.
Fortune-hunters, peers, and pioneers who are looking for houses for rent Duchouquet and are trying to notice house rentals Duchouquet Ohio, rental properties in Duchouquet, and bed and breakfast rentals Duchouquet can study FRBO.com and our beach advertisements, loft ad directories, ski in/out listings, and resort classified ads.
Hear, recognize, and catch Buchtel United States vacation homes, short term rentals in Buchtel United States, and rental homes Buchtel.
Send comely, delightful, and statuesque poop sheet regarding home rentals, real estate rentals in Duchouquet Ohio, home rentals Duchouquet, and rent house in Duchouquet Ohio found on our page.
The Duchouquet lakeside lists of marked properties, decadent lists of marked properties, and ski in/out listed properties for these vicinity can be mapped.
Take up your rummage online on Thursday, on Friday, or on Tuesday for your Duchouquet Ohio houses for rent, rent house Duchouquet, and rental homes Duchouquet.
Identify and discover Mc Donald United States condo rentals and Mc Donald homes for rent by owner.
Observe and move vacation rentals in Savannah United States and houses for rent in Savannah.
Using our webpage, third party listing companies insert castle, timeshare, house, and timeshare listings.
You can invent and explore Duchouquet Ohio houses for rent, Duchouquet vacation rentals, and Duchouquet Ohio vacation homes.
Find, uncover, and come upon vacation homes in Grand River United States, condos for rent in Grand River United States, and Grand River homes for rent.
You can go through the exotic classifieds, convenient classified ads, log advertisements, and studio ad directories under Duchouquet Ohio apartment rentals and Duchouquet Ohio vacation homes.
We composed and started our website, FRBO.com to be foxy, well-formed, symmetrical, and taking.
Explore and conceive Powell United States bed and breakfast rentals and Powell rental home.
Distinguish, elicit, and hear short term rentals Knox Ohio, vacation homes, and Knox Ohio homes for rent by owner.
|
|
