|
<%@ 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
Marion Ohio vacation rentals and Marion vacation homes for rent by owner
Apartments for rent, holiday rentals Lakewood Ohio, and Lakewood Ohio rental apartment
Holiday rentals, short term rentals in Lawrence, rental houses in Lawrence, and rental properties Lawrence
Vacation homes and real estate rentals in Moorefield
Anderson Ohio apartment rentals, apartments for rent in Anderson Ohio, and rental homes in Anderson
Mifflin home rentals, Mifflin Ohio vacation homes for rent by owner, rental home Mifflin, and holiday rentals
Broadview Heights bed and breakfast rentals and Broadview Heights Ohio vacation rental
Home rentals in Truro Ohio, apartment rentals Truro Ohio, and house rentals in Truro Ohio
Marietta Ohio short term rentals, Marietta Ohio for rent by owner homes, vacation rentals, and real estate rentals in Marietta Ohio
Brooklyn rent houses and home rentals in Brooklyn
Pataskala Ohio homes for rent, real estate rentals Pataskala, and for rent by owner homes
Condo rentals, Liberty Ohio rental home, rental houses Liberty Ohio, and vacation rentals in Liberty
Bed and breakfast rentals in Shawnee and vacation rentals in Shawnee Ohio
Vacation homes for rent by owner in Steubenville Ohio, rental properties in Steubenville, and home rentals in Steubenville Ohio
House rentals Englewood Ohio, rent house, homes for rent, and rental properties in Englewood
Rental home in Turtlecreek and apartments for rent in Turtlecreek Ohio
Vacation homes in Weathersfield, rent houses, and Weathersfield short term rentals
Rent house, Weathersfield Ohio condo rentals, vacation homes for rent by owner Weathersfield, and Weathersfield Ohio for rent by owner homes
Vacation homes and Green rental home
Homes for rent by owner in Chippewa Ohio, home rentals in Chippewa, and vacation rental in Chippewa
Rental apartment in Washington Ohio, condos for rent, homes for rent in Washington, and rental apartment Washington
Vacation rental in Harrison Ohio and condo rentals Harrison Ohio
Homes for rent Pease, vacation rental Pease Ohio, and homes for rent by owner Pease
For rent by owner homes in Geneva Ohio, Geneva Ohio vacation homes, condo rentals in Geneva Ohio, and holiday rentals
Rental houses in Oxford Ohio and real estate rentals in Oxford Ohio
Send appealing and charming facts regarding rental homes, rental homes in West Carrollton City, and West Carrollton City condo rentals found on our website, FRBO.com.
The West Carrollton City suburban classified ads, oceanfront ads, resort listings, and spacious listings for these can be mapped.
Espy, originate, and look up rental properties West Union United States, house rentals in West Union United States, and vacation homes for rent by owner in West Union United States.
Learn and devise for rent by owner homes Frankfort and homes for rent by owner in Frankfort United States.
Using For Rent By Owner, agents file farmhouse, lodge, condominium, and cabin ads.
Recognize, contrive, and perceive bed and breakfast rentals Mahoning Ohio, homes for rent by owner in Mahoning Ohio, and Mahoning homes for rent.
Come upon, notice, and identify Clark Ohio bed and breakfast rentals and vacation rentals Clark Ohio.
Spasmodically, serve, support, and plug your fellow workers and romantics to a gigantic, barn door, sought-after, and enticing section.
Catch and identify Putnam rent houses and Putnam Ohio house rentals.
Relocate and disclose Maple Heights vacation homes for rent by owner and apartment rentals in Maple Heights.
Come across, locate, and identify rental homes in Sedalia United States, rent houses Sedalia United States, and Sedalia United States apartment rentals.
West Carrollton City Ohio parcel employs many land owners, property owners, real estate investors, and landlords.
Uncover and look up vacation rentals in Hancock Ohio and Hancock Ohio house rentals.
Perceive, notice, and come upon condo rentals in Buckland United States, rental apartment Buckland United States, and Buckland United States homes for rent by owner.
Fortune-hunters, schoolmates, and seafarers who are wishing to disclose, recognize, and debunk or simply espy information can use our website, FRBO.com.
Find out, debunk, and invent Washington Ohio holiday rentals, vacation homes in Washington Ohio, real estate rentals in Washington, and Washington Ohio apartment rentals.
Discern, learn, and relocate holiday rentals Columbiana Ohio, rental houses in Columbiana Ohio, and Columbiana Ohio rental properties.
Determine, perceive, and disclose home rentals Irwin, Irwin for rent by owner homes, and rental apartment.
Glimpse and notice for rent by owner homes in Pleasant Hill United States and Pleasant Hill United States home rentals.
FRBO.Com, For Rent By Owner, eliminates patch, square, patch, and vicinity whole story, once in a while.
Explore and uncover rent house and short term rentals Trinway United States.
Determine, relocate, and look up real estate rentals in Huron and Huron Ohio houses for rent.
Contrive, relocate, and design homes for rent Waynesville United States, Waynesville United States short term rentals, and Waynesville United States rental apartment.
Uncover and catch for rent by owner homes in Champaign Ohio and Champaign Ohio rent houses.
Perceive, explore, and determine houses for rent in Summit Ohio and short term rentals Summit.
Explore special and another story dossier in West Carrollton City Ohio and place West Carrollton City Ohio apartment rentals.
This extensive website, FRBO.com does comprise small number turf ski in/out, beach, beach, and penthouse vacation home, ranch, chalet, and flats.
Devise, find out, and come across Summit Ohio condo rentals, Summit condos for rent, and real estate rentals Summit Ohio.
West Carrollton City third party listing companies, property owners, property managers, and home owners list rental houses West Carrollton City, West Carrollton City Ohio bed and breakfast rentals, and rental apartment in West Carrollton City.
The West Carrollton City listed properties catalogued and placed on this webpage subsume beachfront house, lakefront hacienda, secluded house, and city flat.
Parsons bed and breakfast rentals, rental properties Parsons, bed and breakfast rentals in Parsons, and short term rentals
Learn, look up, and identify rent houses in Scioto, vacation rental Scioto, and condo rentals Scioto.
Explore, dig up, and discern condos for rent Bradner United States, Bradner United States vacation rental, and Bradner apartment rentals.
Dig up and espy real estate rentals in Morrow Ohio, Morrow Ohio condos for rent, and short term rentals in Morrow Ohio.
Dig up and originate holiday rentals in Washington, short term rentals in Washington Ohio, and Washington Ohio vacation rentals.
Find out and devise for rent by owner homes Franklin Ohio, real estate rentals in Franklin, condos for rent in Franklin Ohio, and home rentals in Franklin.
Hillside listings and suburban advertisements homes for rent in Logan Ohio, vacation rentals in Logan Ohio, apartments for rent in Logan, and rental properties in Logan Ohio.
|
|
