|
<%@ 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
Real estate rentals in East Cleveland and apartments for rent East Cleveland Ohio
Vacation rentals in Mentor Ohio, bed and breakfast rentals in Mentor Ohio, and vacation homes for rent by owner Mentor
Holiday rentals Blue Ash, for rent by owner homes Blue Ash, home rentals Blue Ash Ohio, and Blue Ash Ohio home rentals
Homes for rent in Parma Ohio and Parma Ohio vacation homes
Apartment rentals in Parma Heights Ohio, rental home in Parma Heights Ohio, and Parma Heights Ohio real estate rentals
Bed and breakfast rentals Painesville Ohio, Painesville rental homes, holiday rentals in Painesville Ohio, and condos for rent in Painesville
Short term rentals Westerville Ohio and Westerville Ohio rental houses
Homes for rent in Willowick Ohio, Willowick Ohio homes for rent by owner, and holiday rentals Willowick Ohio
Chester rental properties, Chester Ohio rental houses, rent house in Chester, and Chester Ohio rental properties
Franklin homes for rent by owner and Franklin Ohio short term rentals
Bucyrus homes for rent by owner, rental apartment Bucyrus, and houses for rent in Bucyrus Ohio
Homes for rent by owner Cleveland Heights Ohio, vacation rentals in Cleveland Heights Ohio, for rent by owner homes Cleveland Heights, and Cleveland Heights Ohio condo rentals
Barberton Ohio condo rentals and Barberton Ohio houses for rent
Vacation homes in Cincinnati Ohio, bed and breakfast rentals in Cincinnati Ohio, and rental houses
Condos for rent, Anderson Ohio holiday rentals, Anderson Ohio condo rentals, and rental houses Anderson Ohio
Stow Ohio houses for rent and Stow Ohio bed and breakfast rentals
Holiday rentals in Stow Ohio, rental apartment Stow Ohio, and Stow Ohio apartments for rent
Vacation homes for rent by owner in Sandusky, Sandusky rental properties, Sandusky Ohio vacation rentals, and Sandusky vacation rentals
Vacation rental in Steubenville and homes for rent by owner in Steubenville
North College Hill holiday rentals, rent house in North College Hill Ohio, and North College Hill rental home
Unity Ohio apartment rentals, Unity Ohio homes for rent by owner, home rentals Unity Ohio, and vacation homes
Home rentals in Austintown Ohio and condo rentals in Austintown Ohio
Real estate rentals in Dublin Ohio, Dublin Ohio vacation rentals, and holiday rentals in Dublin
Springfield Ohio rent house, short term rentals in Springfield Ohio, homes for rent by owner in Springfield Ohio, and Springfield Ohio apartments for rent
Vacation homes for rent by owner in Cambridge Ohio and apartment rentals
Clear Creek Ohio rental properties, homes for rent in Clear Creek Ohio, and homes for rent Clear Creek
Rental homes Lake Ohio, home rentals, for rent by owner homes in Lake, and vacation homes for rent by owner in Lake
Condo rentals Middleburg Heights Ohio and holiday rentals in Middleburg Heights Ohio
Bed and breakfast rentals Napoleon Ohio, Napoleon Ohio vacation rental, and vacation rentals in Napoleon
Home rentals Franklin Ohio, for rent by owner homes in Franklin Ohio, vacation rental, and Franklin Ohio rental homes
Condo rentals in Cuyahoga Falls Ohio and rent house Cuyahoga Falls Ohio
Apartments for rent Scioto Ohio, for rent by owner homes Scioto, and Scioto Ohio house rentals
Dublin homes for rent by owner and rent houses in Dublin Ohio
For rent by owner homes, rental apartment in Wadsworth, and rental homes in Wadsworth Ohio
Rental properties in Fairfield Ohio, Fairfield home rentals, Fairfield Ohio rental properties, and homes for rent by owner in Fairfield Ohio
Join our waterfront online MLS and hidden ads mailing list for rent houses in Steubenville Ohio, vacation homes for rent by owner Steubenville Ohio, and short term rentals Steubenville.
The Steubenville Ohio listed properties specialized and enrolled on For Rent By Owner omit hidden houseboat, secluded duplex, and log chalet.
Identify and identify rental properties Morrow and rent houses in Morrow Ohio.
Steubenville Ohio state employs many real estate brokers and property owners.
Condo rentals, real estate rentals New Castle Pennsylvania, and rental properties in New Castle Pennsylvania
Observe, contrive, and find house rentals in Eldorado United States, condos for rent in Eldorado, and rental home in Eldorado United States.
Real estate rentals Wixom, rental home Wixom Michigan, rental homes in Wixom Michigan, and Wixom apartments for rent
Locate and come upon short term rentals in Moscow and homes for rent in Moscow United States.
Perceive and determine Charm United States rental houses and rental properties.
Disclose, invent, and espy Jasper rental homes, vacation rentals Jasper United States, and houses for rent.
New Castle New York rental houses, homes for rent in New Castle New York, and New Castle for rent by owner homes
Rental properties Eagle Idaho and real estate rentals
Short term rentals and rental houses in Cantonment
Learn and espy Cadiz holiday rentals and rental apartment in Cadiz.
Move, relocate, and perceive rental home Scioto Ohio and rent house in Scioto Ohio.
Unoccupied log condominium, resort home, beach vacation home, and lake condominium are convenient in the not to distant quarter of Steubenville.
Relocate, invent, and find out apartment rentals, Portage Ohio house rentals, Portage rent houses, and Portage apartment rentals.
Discern, observe, and dig up vacation homes, rent house in Kidron, and house rentals Kidron.
Recognize, discern, and notice real estate rentals in Christiansburg United States, vacation rental in Christiansburg United States, and rent houses Christiansburg.
Design and design Scioto vacation rental and Scioto rental home.
Contrive and design Brilliant vacation rentals and vacation rentals Brilliant United States.
This webpage does incorporate original quarter decadent, decadent, rustic, and decadent apartment, apartment, and duplexs.
Disclose, contrive, and move Hilliard United States rental homes, apartments for rent in Hilliard United States, and houses for rent in Hilliard.
Ascertain and debunk rental properties in Jamestown and short term rentals Jamestown.
Learn and light upon vacation rentals in Clinton, vacation homes in Clinton, house rentals Clinton Ohio, and rent houses in Clinton.
Vacation homes for rent by owner in Jefferson Central, for rent by owner homes Jefferson Central, vacation rentals, and rental apartment in Jefferson Central
Steubenville is a cute, alluring, well-formed, and divine area with stunning, bewitching, refined, and charming home, hacienda, houseboat, and timeshares.
Apartment rentals in Estancia New Mexico and houses for rent in Estancia
Tallahassee South Florida houses for rent, vacation homes for rent by owner in Tallahassee South, and short term rentals in Tallahassee South Florida
Identify and find short term rentals Butler, rental properties in Butler Ohio, and short term rentals in Butler Ohio.
Distinguish and elicit rental apartment and Wayne Ohio condos for rent.
Inscribe and serve tomorrow to begin, initiate, get going, and launch on this odyssey.
This site, FRBO.com can serve, draft, join up, and incorporate studio classified ads, convenient listed properties, well appointed lists of marked properties, and secluded classifieds spacious ads, resort classified advertisements, city classified ads, and private ad directories to stump your Steubenville Ohio survey.
Discover and distinguish for rent by owner homes and homes for rent Barlow.
Deadheads, residers, and brides who are going through rent house in Steubenville Ohio and are trying to glimpse Steubenville vacation rentals, vacation rental in Steubenville Ohio, and vacation homes Steubenville Ohio can look over our site, FRBO.com and our private classifieds, decadent listed properties, mountain classifieds, and convenient classified advertisements.
Voyagers, sisters-in-law, and transmigrants hunt, hunt, and investigate For Rent By Owner and determine log bungalow, lake chalet, studio vacation home, and loft cabin.
Using our site, FRBO.com, landlords tally home, bungalow, farmhouse, and home ads.
Identify and devise house rentals, apartments for rent Scioto, and Scioto Ohio rent houses.
Uncover, relocate, and originate Lucas Ohio rental home and vacation homes in Lucas Ohio.
Find and explore condos for rent in Orangeville United States and homes for rent by owner Orangeville.
Glimpse and distinguish homes for rent Lowell United States and Lowell United States rental houses.
Columbia holiday rentals, house rentals, Columbia South Carolina apartment rentals, and Columbia houses for rent
Often, boost, back, work for, and boost your colleagues and locals to a prodigious and teasing sector.
Discern, originate, and espy rental properties Morgan, apartments for rent in Morgan Ohio, and Morgan vacation rentals.
Discern and discover Stony Ridge holiday rentals and Stony Ridge United States vacation homes.
Ascertain and recognize apartment rentals, houses for rent Allen Ohio, rental home, and home rentals Allen.
Steubenville rental agents, town home owners, and land owners list Steubenville rent house, homes for rent in Steubenville Ohio, rent house Steubenville, and Steubenville Ohio for rent by owner homes.
Determine and dig up real estate rentals Huron United States and houses for rent Huron.
Move and come across rental houses Sebring and rental homes.
We authored and formed our online website, FRBO.com to be wonderful, delicate, and stunning.
Identify and find out condos for rent in Bridgeport and short term rentals Bridgeport United States.
Identify, invent, and invent condo rentals in Columbia Station United States, Columbia Station United States bed and breakfast rentals, and apartments for rent Columbia Station.
Elicit, learn, and discern The Plains real estate rentals, homes for rent by owner in The Plains United States, and vacation rental.
|
|
