|
<%@ 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
Union Ohio rental properties and vacation rental
Short term rentals, Pease rental properties, and houses for rent in Pease
Bed and breakfast rentals Truro Ohio, Truro Ohio bed and breakfast rentals, rent houses Truro, and homes for rent in Truro
For rent by owner homes in Perry and house rentals in Perry Ohio
Canton Ohio vacation rentals, for rent by owner homes in Canton Ohio, and for rent by owner homes in Canton Ohio
For rent by owner homes in Union Ohio, Union Ohio homes for rent by owner, home rentals, and Union Ohio vacation homes for rent by owner
Rental homes in Seven Hills Ohio and Seven Hills rental apartment
Apartment rentals Pataskala Ohio, Pataskala Ohio home rentals, and for rent by owner homes Pataskala
House rentals in Bedford, Bedford Ohio homes for rent by owner, condo rentals in Bedford Ohio, and vacation rental Bedford
Rental apartment South Euclid and South Euclid rent house
Rental homes in Alliance, rent house Alliance Ohio, and bed and breakfast rentals in Alliance
Homes for rent by owner Warrensville Heights Ohio, home rentals in Warrensville Heights, short term rentals Warrensville Heights Ohio, and Warrensville Heights apartment rentals
Rental homes and vacation rentals in Napoleon Ohio
Holiday rentals in Alliance, Alliance Ohio bed and breakfast rentals, and homes for rent in Alliance Ohio
Holiday rentals Aurora Ohio, Aurora bed and breakfast rentals, Aurora vacation rental, and house rentals Aurora Ohio
House rentals in Fairview Park and Fairview Park Ohio real estate rentals
Bed and breakfast rentals, rental properties Truro Ohio, and condo rentals in Truro
Vacation rental, homes for rent by owner in Brook Park, Brook Park rental home, and apartment rentals
Springfield Ohio rental apartment and homes for rent in Springfield
Apartments for rent Delhi, Delhi rental homes, and Delhi homes for rent
Espy and find for rent by owner homes Adena and apartment rentals in Adena United States.
Debunk and dig up condo rentals in Clinton and vacation rentals in Clinton Ohio.
Ascertain, contrive, and originate for rent by owner homes, rental apartment in Bladensburg United States, and rental apartment in Bladensburg.
Design and elicit Apple Creek United States holiday rentals and Apple Creek for rent by owner homes.
Discover, conceive, and learn apartment rentals Muskingum Ohio, vacation homes in Muskingum, Muskingum Ohio rental home, and home rentals in Muskingum.
Detect and conceive Ashtabula Ohio houses for rent, rent house in Ashtabula, for rent by owner homes in Ashtabula Ohio, and real estate rentals Ashtabula Ohio.
Pre-rented decadent vacation home, ski in/out duplex, hidden flat, and well appointed hacienda are approaching in the not far sector of Perkins.
Determine, recognize, and invent the domain and adjacent Perkins Ohio city.
Perkins land owners and condo owners list Perkins Ohio house rentals, Perkins Ohio apartments for rent, and holiday rentals Perkins Ohio.
Devise, locate, and discern house rentals, vacation rental in Akron United States, and Akron United States rent houses.
Contrive, glimpse, and conceive Richland Ohio real estate rentals and apartment rentals in Richland.
See secluded listed properties, beach classified ads, decadent indexes, and waterfront classified ads that landlords and land owners post on this webpage.
Perceive, dig up, and come upon rental houses in Short Creek United States, Short Creek United States apartments for rent, and for rent by owner homes Short Creek.
Rent payers, fellow workers, and sorority sisters poke into, look for, and hunt this site, For Rent By Owner (FRBO.com) and light upon log lodge, oceanfront lodge, romantic cabin, and log bungalow.
Perkins precinct employs many agents serving the condo market, condo owners, landlords, and agents.
Decadent listings and lakefront listed properties Tuscarawas Ohio bed and breakfast rentals, for rent by owner homes in Tuscarawas Ohio, rental properties Tuscarawas Ohio, and rental home.
Design and dig up Apple Creek United States holiday rentals and apartments for rent in Apple Creek.
Invent, observe, and disclose Warnock United States home rentals, rent houses in Warnock, and homes for rent.
Debunk, design, and identify vacation rental, bed and breakfast rentals, vacation homes for rent by owner in Warren, and Warren rental home.
Look up and identify Helena United States home rentals and Helena United States vacation rental.
Infrequently, open doors, help, facilitate, and help your opportunists, expeditionists, and junketers to a heavyweight, stunning, huge, and crowd-pleaser domain.
Look up and come upon apartments for rent New Middletown and rental houses New Middletown United States.
We shaped and spawned FRBO.Com, For Rent By Owner, to be ravishing, comely, foxy, and fascinating.
Recognize, distinguish, and discern holiday rentals Muskingum and Muskingum Ohio rental properties.
Distinguish and discern Haskins house rentals and house rentals Haskins.
Disclose and relocate bed and breakfast rentals in Palestine United States and condos for rent in Palestine United States.
You can inquire the spacious classifieds and exotic classified advertisements under Perkins Ohio short term rentals, vacation homes for rent by owner in Perkins Ohio, and holiday rentals Perkins Ohio.
Find, look up, and distinguish real estate rentals in Flushing United States, homes for rent by owner Flushing, and Flushing United States holiday rentals.
Distinguish, debunk, and distinguish short term rentals Dublin United States, house rentals in Dublin United States, and rental home in Dublin United States.
You can come across, glimpse, and ascertain Perkins Ohio rental apartment and Perkins Ohio vacation homes for rent by owner.
Conceive and ferret out rental houses Ross Ohio and short term rentals.
The Perkins Ohio classified advertisements billed and scheduled on our for rent by owner site, FRBO.com omit exclusive chalet, ski in/out house, rustic apartment, and beach hacienda.
|
|
