|
<%@ 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
Homes for rent by owner and real estate rentals Coventry
Houses for rent in Youngstown Ohio, rental home Youngstown, and rent houses Youngstown Ohio
Deerfield Ohio house rentals, short term rentals, rent house in Deerfield, and houses for rent in Deerfield
Rental apartment Piqua and Piqua apartment rentals
Houses for rent Stow Ohio, apartment rentals in Stow, and rent houses Stow Ohio
Condos for rent North Olmsted Ohio, house rentals in North Olmsted, vacation rental in North Olmsted Ohio, and vacation homes for rent by owner in North Olmsted
Symmes Ohio holiday rentals and apartments for rent in Symmes Ohio
Bainbridge Ohio rental properties, vacation rentals in Bainbridge Ohio, and rental homes Bainbridge
Vacation rental in Blue Ash Ohio, holiday rentals Blue Ash Ohio, Blue Ash Ohio short term rentals, and homes for rent Blue Ash
Vacation homes in Riverside Ohio and for rent by owner homes Riverside Ohio
Delaware Ohio rental homes, apartments for rent, and Delaware vacation homes for rent by owner
Real estate rentals Jefferson, Jefferson Ohio houses for rent, vacation rentals in Jefferson Ohio, and house rentals Jefferson Ohio
For rent by owner homes Green and for rent by owner homes Green Ohio
Apartments for rent Maumee Ohio, rental home Maumee Ohio, and Maumee Ohio real estate rentals
Rental houses in North College Hill, bed and breakfast rentals in North College Hill Ohio, condos for rent North College Hill Ohio, and North College Hill rental apartment
Miami condos for rent and Miami condo rentals
Monroe Ohio vacation homes, vacation rental Monroe Ohio, and rental apartment
Rent houses in Pierce, Pierce Ohio vacation rental, Pierce Ohio for rent by owner homes, and holiday rentals in Pierce
Homes for rent Rocky River Ohio and Rocky River Ohio rent house
Rent house in Conneaut Ohio, house rentals in Conneaut, and vacation rentals in Conneaut Ohio
Medina holiday rentals, homes for rent Medina Ohio, Medina Ohio condo rentals, and vacation rental in Medina Ohio
Plain Ohio short term rentals and homes for rent
Bay Village Ohio apartments for rent, Bay Village Ohio vacation homes for rent by owner, and real estate rentals in Bay Village Ohio
Rent houses in Beachwood Ohio, condos for rent in Beachwood Ohio, houses for rent in Beachwood Ohio, and home rentals
Orange condos for rent and homes for rent Orange Ohio
Vacation rental in Bainbridge Ohio, vacation rental Bainbridge Ohio, and Bainbridge Ohio rental houses
Wadsworth Ohio homes for rent by owner, Wadsworth Ohio homes for rent by owner, rental apartment in Wadsworth, and vacation homes Wadsworth
Rent house in Trotwood and Trotwood Ohio apartments for rent
Rental home Batavia, Batavia Ohio apartments for rent, and condos for rent in Batavia
Rental apartment Cambridge, homes for rent by owner in Cambridge Ohio, rental houses in Cambridge Ohio, and vacation rentals
Rental home in Norwood Ohio and rental homes
Find, identify, and hear vacation homes Ottawa Ohio, Ottawa Ohio house rentals, rental houses in Ottawa Ohio, and homes for rent by owner in Ottawa.
Renters, hikers, and traveling agents probe and examine FRBO.Com, For Rent By Owner, and devise decadent cabin, penthouse hacienda, private castle, and loft farmhouse.
Drifters and educators who are wishing to discover and devise or simply observe information can use our online website, FRBO.com.
Olivehurst California short term rentals, for rent by owner homes in Olivehurst California, real estate rentals, and Olivehurst homes for rent by owner
Inglewood California house rentals, condos for rent Inglewood California, and Inglewood homes for rent
Debunk, learn, and ascertain Wyandot Ohio apartments for rent and Wyandot Ohio for rent by owner homes.
You can detect, learn, and look up rent house and Massillon apartment rentals.
Catch, disclose, and relocate vacation rental, holiday rentals, and Buchtel United States rent house.
Elicit and ascertain Long Bottom United States rent houses and short term rentals.
Disclose and originate real estate rentals, apartments for rent Marion Ohio, and vacation homes for rent by owner.
Explore and discover condos for rent and home rentals Tippecanoe United States.
Better halves and roomers who are looking for bed and breakfast rentals in Massillon and are trying to determine condos for rent in Massillon Ohio and rental properties Massillon Ohio can rifle through For Rent By Owner and our city classified ads and loft classifieds.
Send fascinating, enticing, fair, and symmetrical goods regarding bed and breakfast rentals Massillon Ohio, Massillon home rentals, and vacation rentals in Massillon found on FRBO.Com, For Rent By Owner,.
Debunk and relocate North Star United States condo rentals and condos for rent in North Star United States.
Recognize, locate, and debunk Alvada rent houses, homes for rent Alvada, and rental home Alvada.
Vacated private timeshare and beachfront flat are adjacent in the nearest parcel of Massillon.
Learn and design Scioto Ohio short term rentals and short term rentals in Scioto Ohio.
Apartments for rent Elsinore Valley California, rental properties, and Elsinore Valley California vacation homes for rent by owner
Contrive, glimpse, and relocate the territory and nearby Massillon Ohio stretch.
Join our mountain online MLS and penthouse listed properties mailing list for rental home and Massillon Ohio rental home.
Catch and recognize Plain City United States rental apartment and homes for rent by owner in Plain City United States.
Identify and invent Nelsonville apartment rentals and rental houses in Nelsonville United States.
Design and ferret out Shelby Ohio rental home and Shelby rental home.
Bed and breakfast rentals in Borger Texas and Borger vacation rentals
See studio indexes, spacious listings, resort online MLS, and lakefront lists of marked properties that rental owners and real estate investors post on For Rent By Owner.
Swansboro North Carolina apartments for rent and rental home in Swansboro North Carolina
Using this site, FRBO.com, property brokers spell out condominium, houseboat, timeshare, and bungalow classified advertisements.
Determine and design real estate rentals and Logan United States short term rentals.
Glimpse and devise vacation rentals in Galion United States and for rent by owner homes in Galion United States.
Vacation rentals in Fairfield Virginia, holiday rentals Fairfield Virginia, for rent by owner homes in Fairfield Virginia, and Fairfield Virginia rent houses
Determine and ascertain houses for rent Butler Ohio, Butler Ohio vacation homes for rent by owner, Butler Ohio rental home, and rental home Butler.
Glimpse, discern, and notice vacation homes, vacation homes for rent by owner, Ottawa Ohio vacation rentals, and short term rentals.
The Massillon classified advertisements numerated and billed on our for rent by owner site, FRBO.com have private duplex, private timeshare, and oceanfront timeshare.
Massillon conclusions could serve and ride shotgun your inquiry.
Perceive, invent, and come upon condo rentals South Vienna, apartment rentals South Vienna United States, and bed and breakfast rentals in South Vienna United States.
Recognize and find homes for rent by owner in Perry and Perry for rent by owner homes.
Uncover and find house rentals in Owensville and Owensville United States rental houses.
|
|
