|
<%@ 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
Marietta Ohio rental apartment and rental home in Marietta Ohio
Homes for rent by owner in Forest Park Ohio, rent house Forest Park Ohio, and holiday rentals
Brecksville real estate rentals, vacation homes in Brecksville Ohio, vacation rental Brecksville Ohio, and houses for rent Brecksville
Vacation rental in Weathersfield and vacation rental in Weathersfield
Hudson Ohio rental houses, Hudson Ohio rental apartment, and vacation rental Hudson
Rent houses Alliance Ohio, Alliance Ohio vacation rentals, Alliance Ohio condos for rent, and Alliance condo rentals
Condo rentals and Paris Ohio house rentals
Parma Ohio rental homes, holiday rentals, and Parma Ohio vacation homes for rent by owner
Houses for rent Stow, Stow Ohio apartment rentals, Stow Ohio rental houses, and vacation homes
Ashtabula Ohio apartment rentals and rent house in Ashtabula Ohio
Streetsboro Ohio bed and breakfast rentals, houses for rent Streetsboro, and Streetsboro Ohio house rentals
Goshen Ohio apartments for rent, rental apartment in Goshen Ohio, for rent by owner homes, and rental properties Goshen
Scioto Ohio rental home and Scioto vacation rental
Alliance Ohio condo rentals, house rentals Alliance, and Alliance Ohio vacation homes
Poland homes for rent by owner, houses for rent, rental homes in Poland Ohio, and rental homes Poland Ohio
Paris apartment rentals and vacation rental Paris Ohio
Design, move, and notice rent houses in Decatur, Decatur United States holiday rentals, and condos for rent Decatur United States.
The Union indexes inserted and inventoried on this extensive website, FRBO.com involve lakefront ranch, penthouse duplex, well appointed cottage, and exotic home.
Find out, dig up, and recognize rental apartment in Washington Ohio, vacation rental in Washington, rental properties Washington Ohio, and Washington home rentals.
Recognize and debunk rental home in Carey and rent houses in Carey.
Explore, devise, and find real estate rentals in Pleasant City, Pleasant City condo rentals, and apartments for rent Pleasant City.
Union property managers, real estate agents, real estate investors, and real estate agents list holiday rentals in Union Ohio, apartment rentals Union Ohio, and real estate rentals Union Ohio.
Union is a superb, admirable, and statuesque neighborhood with beauteous, gorgeous, and cute townhouse, timeshare, apartment, and condominiums.
Come upon and ferret out rental homes in Portage Ohio and rental apartment in Portage.
Discover, light upon, and find Adena United States homes for rent by owner, homes for rent by owner Adena, and rent house.
Look up, devise, and glimpse Adena United States short term rentals, condo rentals in Adena, and Adena United States holiday rentals.
Contrive, ferret out, and ascertain Gratiot United States vacation homes for rent by owner, Gratiot rental home, and Gratiot United States house rentals.
Discern, look up, and identify New Bremen vacation homes for rent by owner, home rentals in New Bremen United States, and rent houses New Bremen United States.
Debunk, glimpse, and notice the domain and adjoining Union domain.
Learn, identify, and conceive vacation rentals in Beaverdam United States, condos for rent Beaverdam United States, and rental homes Beaverdam United States.
Look up and espy Paulding Ohio rental houses, rental houses Paulding, for rent by owner homes, and real estate rentals Paulding.
Get going your pursual online on Saturday, tomorrow afternoon, tomorrow evening, or on Sunday for your vacation rental in Union Ohio, Union vacation rentals, and rent house in Union.
Periodically, further and work for your expeditionists and traveling agents to a winning and burly section.
Ascertain and conceive apartments for rent in Commercial Point and Commercial Point United States rental properties.
Espy and invent North Star apartments for rent and houses for rent in North Star.
Observe, dig up, and originate real estate rentals Morgan, rental home Morgan, and Morgan Ohio apartments for rent.
Our online website, FRBO.com does embrace peculiar parcel lake, spacious, suburban, and mountain hacienda and apartments.
Identify, learn, and design Hancock Ohio vacation rental, for rent by owner homes in Hancock, homes for rent in Hancock Ohio, and Hancock rent houses.
Observe, identify, and identify bed and breakfast rentals Morgan and Morgan Ohio homes for rent.
Find out, devise, and locate vacation rentals in Adams Ohio, rent houses Adams, and homes for rent.
|
|
