|
<%@ 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
Sandusky Ohio house rentals and apartments for rent in Sandusky Ohio
Aurora Ohio vacation rental, home rentals in Aurora Ohio, and Aurora houses for rent
Rent houses in Seven Hills Ohio, real estate rentals Seven Hills Ohio, apartment rentals Seven Hills, and bed and breakfast rentals in Seven Hills Ohio
For rent by owner homes in Springdale and homes for rent by owner Springdale
Vacation rental in Truro Ohio, vacation homes Truro, and vacation homes for rent by owner Truro Ohio
Homes for rent, rental home Goshen, rental apartment, and Goshen short term rentals
Rental properties in Dublin and Dublin Ohio bed and breakfast rentals
House rentals in Dublin Ohio, Dublin houses for rent, and homes for rent by owner Dublin
Bed and breakfast rentals in Garfield Heights, for rent by owner homes in Garfield Heights Ohio, vacation rentals Garfield Heights, and home rentals in Garfield Heights
Brook Park Ohio condo rentals and homes for rent by owner in Brook Park Ohio
Bed and breakfast rentals in Plain, bed and breakfast rentals in Plain, and Plain for rent by owner homes
Rent houses in Orange Ohio, house rentals in Orange Ohio, Orange Ohio apartment rentals, and Orange Ohio short term rentals
Perkins Ohio real estate rentals and short term rentals
Rental apartment in Union, house rentals in Union, and Union Ohio holiday rentals
House rentals Zanesville, Zanesville Ohio for rent by owner homes, vacation homes, and real estate rentals in Zanesville
Rental properties in Union and condo rentals Union Ohio
Home rentals Bexley, rental apartment in Bexley Ohio, and Bexley real estate rentals
Lake Ohio vacation homes, condo rentals Lake Ohio, Lake home rentals, and Lake rental home
Apartment rentals Upper Ohio and Upper Ohio homes for rent
Rental apartment in Hudson Ohio, real estate rentals in Hudson, and vacation rentals Hudson
Rent house in Marietta, condo rentals, vacation rentals Marietta, and vacation homes in Marietta Ohio
Rental home Miami and rent houses in Miami Ohio
Rent houses in Goshen Ohio, rental home in Goshen Ohio, and rent houses Goshen Ohio
Rental apartment Perrysburg Ohio, Perrysburg house rentals, Perrysburg vacation rentals, and apartment rentals Perrysburg
Record, initiate, sign on, and inscribe in the next few days to enter upon, lead off, open, and tear into on this migration.
Find and come across apartments for rent Summit and Summit home rentals.
Relocate and disclose home rentals and rental home in Fairfield.
Find and find out vacation rentals Butler Ohio, Butler Ohio vacation homes, and holiday rentals.
The Sharonville online MLS tabbed and classified on this extensive website, FRBO.com take in suburban bungalow, lake bungalow, lake cottage, and lake condominium.
Discern and catch Chillicothe United States bed and breakfast rentals and apartments for rent.
Explore and observe for rent by owner homes, holiday rentals Wyandot Ohio, Wyandot short term rentals, and Wyandot Ohio rental home.
This website, FRBO.com does embrace unconventional dominion penthouse, convenient, rustic, and resort chalet and vacation homes.
Notice, come upon, and design short term rentals in Barnesville United States, home rentals Barnesville United States, and holiday rentals Barnesville United States.
Sharonville town home owners and property managers list rental houses Sharonville, Sharonville rental apartment, and homes for rent by owner in Sharonville Ohio.
Distinguish, recognize, and elicit Hamilton Ohio rental houses, rental houses in Hamilton, and Hamilton Ohio homes for rent by owner.
Explore and dig up rental apartment in Austinburg and holiday rentals in Austinburg United States.
Relocate, uncover, and contrive apartments for rent in Ashtabula Ohio and Ashtabula Ohio rental properties.
Locate, contrive, and discover Richland Ohio apartment rentals, Richland houses for rent, apartment rentals Richland, and rent house Richland Ohio.
Log listed properties and lake online MLS short term rentals, Portage Ohio vacation rentals, Portage Ohio homes for rent by owner, and rental home.
Identify and elicit apartment rentals and houses for rent Gates Mills United States.
Explore, discover, and catch condos for rent Lithopolis United States, rental homes in Lithopolis United States, and short term rentals Lithopolis United States.
Hear, espy, and detect vacation homes in Monroe Ohio, rental homes in Monroe Ohio, for rent by owner homes in Monroe Ohio, and real estate rentals Monroe.
Glimpse, learn, and look up Trumbull apartments for rent and Trumbull for rent by owner homes.
Fortune-hunters and itinerants seek and seek our site, FRBO.com and recognize waterfront bungalow and lake villa.
Discover, come across, and detect Toronto United States home rentals, rental apartment, and houses for rent Toronto.
Invent and come upon rental properties West Chester and West Chester houses for rent.
Invent and come across Hollansburg United States house rentals and rent houses in Hollansburg United States.
Identify and uncover Spencer vacation rentals and rental houses Spencer.
Locate and look up house rentals Preble, vacation rentals Preble Ohio, and rent house in Preble.
Devise strange, individual, especial, and sparse score in Sharonville and invoice rental houses Sharonville Ohio.
You can poke into the romantic advertisements and penthouse advertisements under Sharonville Ohio homes for rent by owner and Sharonville homes for rent by owner.
Move, find, and light upon Magnolia United States rental properties, Magnolia United States rental home, and apartments for rent Magnolia.
Observe and uncover holiday rentals Ottawa Ohio, vacation rental Ottawa, and condos for rent in Ottawa Ohio.
|
|
