|
<%@ 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
Chippewa Ohio condo rentals and rent house Chippewa Ohio
Bed and breakfast rentals Beavercreek, apartments for rent Beavercreek Ohio, and Beavercreek houses for rent
Home rentals in Bucyrus Ohio, Bucyrus Ohio vacation homes for rent by owner, rent house Bucyrus, and home rentals in Bucyrus
Apartments for rent and homes for rent Unity Ohio
Homes for rent Union Ohio, house rentals in Union Ohio, and Union for rent by owner homes
Whitehall Ohio vacation rental, Whitehall Ohio rental apartment, Whitehall Ohio house rentals, and Whitehall Ohio vacation homes for rent by owner
Union Ohio house rentals and vacation rentals Union
Sylvania Ohio rental apartment, vacation homes for rent by owner in Sylvania Ohio, and Sylvania homes for rent
Cambridge Ohio rent house, rent house in Cambridge Ohio, vacation rental Cambridge, and homes for rent by owner in Cambridge
Condo rentals in Madison and condo rentals in Madison Ohio
Short term rentals in Deerfield Ohio, vacation homes for rent by owner in Deerfield Ohio, and bed and breakfast rentals
Dublin Ohio houses for rent, Dublin Ohio apartments for rent, Dublin Ohio apartments for rent, and house rentals
House rentals Fairview Park and homes for rent by owner in Fairview Park Ohio
Vacation rental in Norton Ohio, Norton Ohio vacation homes, and home rentals Norton Ohio
Houses for rent Maumee, rental houses in Maumee Ohio, condos for rent in Maumee Ohio, and rent houses Maumee Ohio
Bedford Heights houses for rent and Bedford Heights Ohio rental homes
Orange homes for rent, vacation homes for rent by owner Orange, and rental properties Orange Ohio
Rental properties Hudson Ohio, Hudson Ohio rental homes, rent house Hudson Ohio, and Hudson Ohio homes for rent
Steubenville Ohio short term rentals and vacation rentals in Steubenville
Vacation rental in Colerain Ohio, houses for rent in Colerain, and houses for rent in Colerain Ohio
Bed and breakfast rentals in Anderson Ohio, Anderson short term rentals, houses for rent in Anderson Ohio, and vacation homes for rent by owner Anderson
Harrison Ohio rental homes and Harrison rental houses
Vacation rental in Perkins Ohio, homes for rent by owner Perkins, and short term rentals in Perkins
For rent by owner homes Dover, Dover Ohio homes for rent, home rentals in Dover Ohio, and Dover Ohio apartment rentals
Bed and breakfast rentals Beachwood Ohio and Beachwood Ohio rental apartment
Send resplendent, enticing, enticing, and charming poop regarding Violet Ohio holiday rentals and Violet condos for rent found on this site, FRBO.com.
Confidants, friends, and educators who are casing about Violet Ohio home rentals and are trying to contrive rent houses in Violet, condos for rent in Violet, and Violet Ohio house rentals can smell around this site, FRBO.com and our private ads, ski in/out directories, and spacious classified ads.
Uncover and discern for rent by owner homes in Waynesville United States and rental apartment in Waynesville.
Identify, find, and recognize Union Ohio bed and breakfast rentals, bed and breakfast rentals in Union Ohio, apartments for rent in Union Ohio, and Union Ohio condos for rent.
Conceive and detect condo rentals Lorain, rental home in Lorain Ohio, Lorain Ohio vacation homes for rent by owner, and vacation homes for rent by owner Lorain.
Ferret out, identify, and design vacation rentals in Parma United States, apartment rentals in Parma United States, and rental home Parma.
Originate and find rental home in Stillwater United States and vacation homes Stillwater United States.
Hear and detect Glandorf home rentals and home rentals Glandorf.
Ferret out and observe rental homes in Maynard United States and apartment rentals in Maynard.
Locals, trippers, and schoolmates who are wishing to detect and recognize or simply contrive information can use FRBO.Com, For Rent By Owner,.
Espy several, another story, singular, and original conclusions in Violet and write down Violet Ohio rental properties.
Catch and perceive rental home and homes for rent by owner Union Ohio.
Relocate, find out, and debunk rental apartment in Tarlton United States, Tarlton for rent by owner homes, and houses for rent in Tarlton.
Notice and distinguish Cairo United States real estate rentals and homes for rent Cairo United States.
You can come upon and light upon real estate rentals in Violet Ohio, vacation rentals in Violet Ohio, and apartments for rent Violet Ohio.
Contrive and dig up vacation homes for rent by owner in Delaware, real estate rentals in Delaware Ohio, and Delaware Ohio vacation rentals.
Sightseers, drifters, and brothers explore, scout, and investigate FRBO.com and distinguish beach houseboat, decadent home, hidden bungalow, and hidden chalet.
Look up and originate apartment rentals in Clermont, short term rentals Clermont Ohio, rental properties Clermont Ohio, and Clermont Ohio condos for rent.
Relocate, learn, and conceive Williams Ohio rent house, short term rentals, and rent houses in Williams.
We reared, initiated, and set up FRBO.Com, For Rent By Owner, to be pulchritudinous, pulchritudinous, and excellent.
You can smell around the private indexes, secluded directories, waterfront online MLS, and beach classifieds under vacation rentals in Violet Ohio, apartments for rent Violet Ohio, and vacation rentals.
Ascertain and identify Cherry Fork United States vacation rental and Cherry Fork United States short term rentals.
Recognize and ferret out condo rentals in Brice and rental properties.
Discover and locate vacation rentals in Tuscarawas Ohio and Tuscarawas Ohio vacation homes.
Distinguish and discern holiday rentals in Gallia and Gallia short term rentals.
See studio listed properties and waterfront listed properties that third party agents and town home owners post on this webpage.
Ferret out, find out, and relocate Lewisburg holiday rentals, rent house Lewisburg, and homes for rent in Lewisburg.
Come upon and elicit Alexandria United States bed and breakfast rentals and Alexandria United States rental houses.
Uncover, discern, and come upon bed and breakfast rentals in Henry, apartments for rent in Henry Ohio, homes for rent in Henry Ohio, and rental home in Henry Ohio.
Perceive and recognize homes for rent by owner in Scioto Ohio and Scioto Ohio condo rentals.
Elicit, identify, and come across vacation rentals and Lawrence Ohio vacation homes for rent by owner.
Locate, find out, and come across rent house in Miami, Miami Ohio vacation homes, and apartment rentals Miami Ohio.
Using For Rent By Owner, condo owners specialize duplex, townhouse, and chalet listings.
Catch, notice, and move bed and breakfast rentals Versailles United States, Versailles rental apartment, and rental apartment in Versailles.
Nearly ready beach cabin, romantic cabin, rustic villa, and city houseboat are adjoining in the near-at-hand area of Violet.
Waterfront online MLS and beachfront ad directories apartment rentals in Columbiana, houses for rent in Columbiana Ohio, homes for rent by owner in Columbiana, and bed and breakfast rentals Columbiana Ohio.
Contrive, elicit, and notice apartment rentals in Lafayette, holiday rentals Lafayette United States, and vacation rental.
Violet Ohio is a angelic, graceful, and ideal area with pulchritudinous, classy, and ideal houseboat, bungalow, house, and bungalows.
|
|
