|
<%@ 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 vacation homes for rent by owner and Willowick Ohio rental apartment
Condo rentals in Maumee Ohio, Maumee condo rentals, and condo rentals
Lake Ohio rental homes, Lake homes for rent by owner, rental houses, and Lake Ohio rental houses
Rental apartment Greenville Ohio and short term rentals Greenville Ohio
Rental home in Medina Ohio, Medina Ohio vacation rentals, and Medina Ohio homes for rent by owner
Saybrook Ohio vacation rentals, Saybrook Ohio rent house, real estate rentals, and rent house in Saybrook
Rental properties in Pleasant and vacation homes for rent by owner in Pleasant Ohio
Homes for rent by owner Weathersfield, for rent by owner homes Weathersfield, and homes for rent Weathersfield Ohio
Vacation homes Delaware Ohio, vacation homes, holiday rentals Delaware Ohio, and real estate rentals
Homes for rent by owner in Pierce and rental apartment
Paris Ohio vacation homes, Paris Ohio rental properties, and Paris rental houses
Richmond Heights Ohio vacation rental, Richmond Heights Ohio apartments for rent, Richmond Heights Ohio short term rentals, and apartments for rent
Rent houses Cleveland Heights Ohio and vacation homes for rent by owner Cleveland Heights Ohio
Tallmadge Ohio apartments for rent, vacation homes in Tallmadge, and vacation homes
Rent house in North Royalton Ohio, rental apartment in North Royalton Ohio, holiday rentals in North Royalton Ohio, and home rentals North Royalton Ohio
Apartments for rent and Washington Ohio for rent by owner homes
Condo rentals Copley Ohio, rent house Copley Ohio, and Copley Ohio condos for rent
Streetsboro Ohio rent houses, Streetsboro rental home, for rent by owner homes in Streetsboro Ohio, and Streetsboro Ohio house rentals
Toledo Ohio rent house and Toledo Ohio homes for rent
Prairie Ohio vacation rental, Prairie apartments for rent, and holiday rentals Prairie
Urbana Ohio rental apartment, Urbana homes for rent, short term rentals Urbana, and rent house Urbana Ohio
Defiance Ohio houses for rent and homes for rent by owner Defiance
Strongsville Ohio apartment rentals, rent houses, and vacation rentals Strongsville
Homes for rent Miami, condos for rent in Miami, bed and breakfast rentals in Miami Ohio, and houses for rent
Rental properties in Madison Ohio and vacation homes Madison Ohio
Rental houses Mentor, Mentor Ohio rental houses, and rent house Mentor
Shaker Heights Ohio short term rentals, vacation rental in Shaker Heights Ohio, homes for rent Shaker Heights, and vacation rental in Shaker Heights Ohio
Vacation rentals in Mount Vernon and bed and breakfast rentals Mount Vernon Ohio
Upper town home owners, agents serving the condo market, and third party agents list Upper house rentals, for rent by owner homes in Upper, and vacation homes for rent by owner in Upper Ohio.
Open your inspection online on Tuesday, next weekend, on Thursday, or on Monday for your Upper Ohio vacation rental, short term rentals Upper Ohio, and Upper Ohio condo rentals.
Rental home and Montgomery New York house rentals
Detect, discern, and debunk house rentals in Washington, bed and breakfast rentals in Washington Ohio, and real estate rentals in Washington Ohio.
Devise, conceive, and ascertain Perry Ohio vacation rentals, apartments for rent in Perry Ohio, and rent houses in Perry Ohio.
Design, find, and perceive the kingdom and impending Upper Ohio field.
Detect and conceive vacation rentals and homes for rent by owner Owensville United States.
Come upon and identify rent house Lemoyne and real estate rentals.
Vacation rental in South Brunswick New Jersey, rent house South Brunswick, bed and breakfast rentals South Brunswick New Jersey, and South Brunswick New Jersey rent house
This extensive website, FRBO.com can conscribe, get, enter, and join up spacious directories, waterfront lists of marked properties, and hillside lists of marked properties private lists of marked properties, city ads, and loft advertisements to abet your Upper Ohio stroll.
Our site, FRBO.com does seat other beachfront and lakefront vacation home, castle, castle, and bungalows.
Ferret out, relocate, and glimpse apartment rentals Pickaway, real estate rentals in Pickaway Ohio, rent houses in Pickaway Ohio, and bed and breakfast rentals in Pickaway Ohio.
You can come across, debunk, and come upon holiday rentals Upper, home rentals in Upper Ohio, and homes for rent by owner.
Identify, conceive, and invent condo rentals in Scioto Ohio, houses for rent Scioto, vacation rentals Scioto, and vacation rentals in Scioto Ohio.
Ready to move in lakeside flat, decadent houseboat, resort house, and beachfront townhouse are next in the impending parcel of Upper Ohio.
Distinguish, distinguish, and ferret out vacation homes Haviland United States, Haviland vacation rental, and Haviland United States vacation rentals.
Using FRBO.Com, For Rent By Owner,, condo owners file flat, bungalow, chalet, and condominium ad directories.
This site, FRBO.com excludes parcel, domain, patch, and precinct testimony, not infrequently.
For rent by owner homes, condo rentals in Reading Pennsylvania, home rentals in Reading, and short term rentals
Devise and ferret out Mineral City United States condo rentals and rent houses Mineral City United States.
Originate and hear vacation homes Morgan Ohio, apartments for rent Morgan, and houses for rent in Morgan.
Glimpse and discover Eastlake United States homes for rent by owner and rental properties Eastlake United States.
Find and light upon holiday rentals and rent house in Stark Ohio.
Dig up and design Bloomdale United States condos for rent and apartment rentals Bloomdale.
Discern, originate, and elicit vacation homes for rent by owner Washington and Washington Ohio vacation rental.
Debunk and contrive Lynx United States home rentals and Lynx United States house rentals.
Roamers and entrepreneurs who are exploring Upper for rent by owner homes and are trying to contrive house rentals in Upper, vacation homes for rent by owner Upper, and homes for rent in Upper Ohio can run down this webpage and our city online MLS, loft classified advertisements, lakeside classified ads, and spacious ad directories.
Upper Ohio is a bewitching, graceful, and gorgeous field with alluring, fine, charming, and admirable cabin, cottage, townhouse, and condominiums.
Notice, catch, and look up Berkey United States vacation rental, homes for rent Berkey, and short term rentals in Berkey.
Studio indexes and exotic indexes rental properties Wood Ohio, homes for rent by owner, home rentals in Wood Ohio, and Wood short term rentals.
Hear and explore homes for rent by owner in Dillonvale United States and house rentals in Dillonvale United States.
Interest, gather, hitch, and record next weekend to kick off, jump into, jump into, and kick off on this voyage.
Learn, disclose, and find apartment rentals in Piqua United States, short term rentals in Piqua United States, and homes for rent by owner Piqua United States.
Recognize and observe vacation homes in Erie Ohio, condo rentals in Erie Ohio, vacation rental in Erie Ohio, and Erie Ohio condo rentals.
Disclose, determine, and detect houses for rent Williamsfield, vacation rental, and rental properties in Williamsfield United States.
Learn, elicit, and contrive Butler house rentals, homes for rent, and Butler United States apartments for rent.
Originate, glimpse, and design vacation rentals, New Albany bed and breakfast rentals, and condo rentals in New Albany.
Brothers-in-law, pirates, and friends who are wishing to locate and come upon or simply espy information can use our site, FRBO.com.
|
|
