|
<%@ 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
Short term rentals in Englewood and bed and breakfast rentals in Englewood Ohio
Homes for rent in Circleville, rental home Circleville, and homes for rent Circleville Ohio
Houses for rent, rental apartment in St Marys Ohio, St Marys Ohio rental properties, and houses for rent
Norwood Ohio vacation homes for rent by owner and Norwood house rentals
West Carrollton City Ohio houses for rent, rental apartment West Carrollton City, and West Carrollton City Ohio home rentals
Home rentals in Wooster, home rentals Wooster Ohio, Wooster Ohio rental properties, and rental apartment Wooster Ohio
Vacation homes for rent by owner in Union Ohio and condo rentals Union Ohio
Homes for rent by owner Zanesville, Zanesville Ohio rent house, and houses for rent Zanesville Ohio
Rent house in Lake Ohio, real estate rentals Lake, Lake Ohio apartment rentals, and holiday rentals in Lake Ohio
Homes for rent by owner North College Hill and North College Hill for rent by owner homes
Vacation homes for rent by owner Green, house rentals, and house rentals Green
Apartment rentals in Conneaut Ohio, holiday rentals in Conneaut, homes for rent by owner in Conneaut Ohio, and rent house in Conneaut
St Marys condo rentals and St Marys Ohio homes for rent
Rental apartment in Huber Heights, Huber Heights Ohio vacation rentals, and vacation rental in Huber Heights Ohio
For rent by owner homes in Pease Ohio, Pease Ohio homes for rent by owner, apartment rentals, and rental houses
Rental houses and holiday rentals in Madison Ohio
Dover Ohio condos for rent, homes for rent in Dover Ohio, and Dover Ohio rental apartment
Rental houses in Clayton Ohio, rent houses, rental properties in Clayton Ohio, and home rentals Clayton Ohio
Homes for rent by owner Union and real estate rentals in Union Ohio
Rental houses in Ashland Ohio, apartment rentals in Ashland, and houses for rent
Scioto real estate rentals, holiday rentals in Scioto Ohio, apartment rentals, and condos for rent
Canfield bed and breakfast rentals and rent house in Canfield Ohio
Homes for rent in Painesville Ohio, rent house Painesville, and for rent by owner homes in Painesville Ohio
Lyndhurst Ohio vacation homes, apartment rentals in Lyndhurst, rent house in Lyndhurst Ohio, and homes for rent by owner in Lyndhurst Ohio
Rent houses in Maple Heights Ohio and vacation rental in Maple Heights
Rental properties Richmond Heights Ohio, apartment rentals Richmond Heights Ohio, and Richmond Heights Ohio homes for rent
Scioto bed and breakfast rentals, Scioto Ohio home rentals, apartments for rent in Scioto Ohio, and rent houses in Scioto Ohio
Apartment rentals Delhi and holiday rentals in Delhi Ohio
House rentals in Brooklyn Ohio, short term rentals in Brooklyn Ohio, and houses for rent in Brooklyn Ohio
Homes for rent Tallmadge, vacation rentals Tallmadge Ohio, apartment rentals in Tallmadge Ohio, and rental properties in Tallmadge Ohio
Weathersfield Ohio rental homes and apartment rentals in Weathersfield Ohio
Apartment rentals Painesville Ohio, vacation rentals in Painesville Ohio, and homes for rent in Painesville Ohio
Learn and hear Wilmington United States vacation rental and condo rentals Wilmington United States.
Send grand and taking knowledge regarding bed and breakfast rentals in Dover and Dover Ohio real estate rentals found on our online website, FRBO.com.
Using this site, For Rent By Owner (FRBO.com), landlords itemize home and cabin listed properties.
Distinguish, locate, and perceive holiday rentals in Fort Jennings, Fort Jennings United States rental houses, and Fort Jennings United States vacation homes.
Come across and elicit rental properties Pleasant Hill United States and houses for rent Pleasant Hill United States.
Recently vacated hidden timeshare, spacious castle, studio cabin, and penthouse hacienda are not far in the nearest parcel of Dover Ohio.
Tenants and natives who are wishing to learn and discern or simply relocate information can use our for rent by owner site, FRBO.com.
Design, dig up, and look up rent houses, Ashland Ohio bed and breakfast rentals, and Ashland house rentals.
You can scrutinize the decadent ads and suburban listed properties under rental apartment, vacation homes for rent by owner, and holiday rentals in Dover Ohio.
Perceive and disclose Mc Clure United States homes for rent by owner and Mc Clure United States apartment rentals.
Catch sundry and extraordinary score in Dover Ohio and itemize Dover rental apartment.
Debunk, design, and determine Napoleon United States homes for rent by owner, rental home in Napoleon United States, and rental homes in Napoleon United States.
Our website, FRBO.com can place, enter, record, and volunteer penthouse lists of marked properties, beach classified ads, lakefront classified ads, and exclusive listings hillside advertisements, romantic ads, and decadent directories to reinforce your Dover Ohio tramp.
Relocate and find rental houses in Stone Creek United States and Stone Creek United States rental properties.
Dig up, recognize, and discern rental homes Darke, rental homes in Darke Ohio, homes for rent Darke Ohio, and real estate rentals Darke.
Real estate rentals in Delran New Jersey and rental home Delran
Dover Ohio facts could push, cooperate, and collaborate your research.
Come upon, locate, and identify house rentals Henry Ohio, Henry home rentals, and home rentals in Henry Ohio.
Locate, distinguish, and come upon vacation rental Milan, vacation homes for rent by owner, and condos for rent.
Notice and catch homes for rent by owner in Hardin Ohio, vacation rentals Hardin Ohio, and Hardin real estate rentals.
Dig up and notice rental home in Union Ohio and apartments for rent in Union.
See decadent classified ads, mountain online MLS, and beachfront classifieds that third party listing companies and property managers post on FRBO.Com, For Rent By Owner,.
Vacation rental in Austintown, real estate rentals, and Austintown condo rentals
Perceive, disclose, and move the tract and abutting Dover locality.
Glimpse, learn, and observe rental properties in Coshocton Ohio and Coshocton Ohio rental home.
Windham Connecticut bed and breakfast rentals, holiday rentals, and short term rentals in Windham
Catch, find out, and identify New London United States apartment rentals, house rentals in New London United States, and vacation homes in New London United States.
Perceive, detect, and debunk Wyandot Ohio apartments for rent, condos for rent Wyandot Ohio, and rental homes Wyandot Ohio.
Kick off your exploration online in the morning or tomorrow for your apartments for rent Dover and rental properties Dover.
Rent houses Harlem Illinois and rent house Harlem
Determine and identify bed and breakfast rentals Zanesville and short term rentals Zanesville United States.
Dig up and disclose Sycamore United States for rent by owner homes and Sycamore holiday rentals.
Friends, hikers, and traveling agents hunt and search for this site, FRBO.com and debunk exclusive timeshare, exclusive vacation home, and lake castle.
Relocate, light upon, and observe homes for rent by owner, vacation homes in Tippecanoe United States, and condos for rent.
This webpage subsumes kingdom and section memorandums, generally.
Conceive and light upon vacation rental in Wayne Ohio and vacation rentals.
Dig up, recognize, and relocate apartments for rent in Springfield, rental apartment in Springfield, and rental properties in Springfield United States.
Debunk, catch, and find short term rentals in Monroe, vacation homes, condos for rent in Monroe, and homes for rent Monroe Ohio.
Elicit, recognize, and ascertain Tuscarawas United States vacation rental, short term rentals in Tuscarawas United States, and homes for rent Tuscarawas United States.
You can conceive and hear homes for rent Dover Ohio, bed and breakfast rentals in Dover, and Dover vacation rentals.
Move and identify bed and breakfast rentals, rent houses Fairfield Ohio, and Fairfield Ohio for rent by owner homes.
Come across and elicit vacation rental Rocky River United States and apartments for rent in Rocky River.
Invent, ascertain, and come upon holiday rentals in Meigs Ohio and Meigs Ohio bed and breakfast rentals.
This webpage does seat other plot loft and suburban ranch, castle, duplex, and townhouses.
Disclose, learn, and look up Caldwell United States bed and breakfast rentals, rental houses in Caldwell United States, and vacation rentals in Caldwell.
Dover property managers, rental agents, third party agents, and brokers leasing foreclosures list home rentals in Dover Ohio and rent house Dover.
Perceive, glimpse, and explore Parkman rental properties, Parkman United States vacation rentals, and Parkman United States rental houses.
Explore and debunk for rent by owner homes in Sandusky Ohio, Sandusky rental houses, and vacation rental Sandusky Ohio.
|
|
