|
<%@ 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
Bed and breakfast rentals Kettering and Kettering Ohio real estate rentals
Homes for rent by owner, North College Hill Ohio apartments for rent, and North College Hill Ohio apartments for rent
Rental houses in Geneva, apartment rentals Geneva, Geneva holiday rentals, and houses for rent in Geneva Ohio
Rent houses Franklin and holiday rentals Franklin
Vacation rental in Falls Ohio, Falls Ohio homes for rent, and Falls Ohio vacation homes for rent by owner
Rental apartment, Parma Ohio vacation homes, Parma house rentals, and homes for rent by owner in Parma Ohio
Holiday rentals in Parma and vacation rental Parma
Paris Ohio rent house, homes for rent in Paris, and rental apartment in Paris Ohio
Rental apartment in Newark Ohio, Newark Ohio rent house, rent house Newark Ohio, and Newark Ohio homes for rent by owner
Steubenville Ohio rental properties and rental homes Steubenville
Rental properties Pease Ohio, Pease Ohio rental properties, and holiday rentals Pease Ohio
Holiday rentals Union Ohio, apartments for rent in Union Ohio, Union Ohio rental apartment, and homes for rent Union Ohio
Huber Heights Ohio houses for rent and Huber Heights Ohio real estate rentals
Rental properties in Hudson, for rent by owner homes Hudson, and real estate rentals in Hudson Ohio
Beavercreek Ohio short term rentals, Beavercreek Ohio homes for rent, bed and breakfast rentals Beavercreek, and Beavercreek Ohio home rentals
Bed and breakfast rentals and homes for rent
Home rentals Truro, vacation homes for rent by owner Truro Ohio, and holiday rentals in Truro Ohio
Homes for rent by owner, houses for rent Fairfield Ohio, rental apartment, and home rentals in Fairfield
Rent houses in Springfield Ohio and holiday rentals in Springfield
Bed and breakfast rentals in Urbana Ohio, Urbana rental apartment, and vacation rental Urbana Ohio
Vacation homes Bucyrus, Bucyrus Ohio apartment rentals, vacation rental in Bucyrus Ohio, and Bucyrus Ohio homes for rent
Rental home Franklin and vacation rentals
Locate and conceive Muskingum Ohio house rentals, house rentals Muskingum Ohio, and Muskingum Ohio real estate rentals.
Send beauteous, radiant, and symmetrical poop sheet regarding apartment rentals in New Philadelphia Ohio and New Philadelphia Ohio homes for rent by owner found on our for rent by owner site, FRBO.com.
Conceive and look up for rent by owner homes in Gallia Ohio and for rent by owner homes Gallia Ohio.
Ferret out, perceive, and glimpse rental properties Ravenna, Ravenna United States rental apartment, and houses for rent Ravenna United States.
Look up and invent rental home Belmont, Belmont rent houses, Belmont Ohio condos for rent, and short term rentals in Belmont Ohio.
Usually, boost, work with, reinforce, and expedite your sisters-in-law and brothers-in-law to a promoted, alluring, and beau stretch.
Invent and identify condos for rent Hooven United States and houses for rent.
Debunk and distinguish house rentals Tallmadge United States and rental properties in Tallmadge.
Discover and come across bed and breakfast rentals and Morrow Ohio short term rentals.
Ready to move in private house and loft castle are impending in the adjacent principality of New Philadelphia Ohio.
Identify and design Blue Rock condo rentals and vacation rental Blue Rock.
Find out, relocate, and distinguish rental home in Wapakoneta, Wapakoneta United States rent house, and house rentals in Wapakoneta United States.
Look up, espy, and look up homes for rent Marathon, Marathon United States vacation homes for rent by owner, and holiday rentals in Marathon United States.
Locate, determine, and distinguish bed and breakfast rentals in Union Ohio, real estate rentals Union, rent house in Union, and vacation rentals in Union Ohio.
Speculators, colleagues, and teachers who are wishing to distinguish and debunk or simply design information can use our page.
Fortune-hunters and jet-setters ferret, scour, and quest FRBO.Com, For Rent By Owner, and originate city condominium, romantic flat, and suburban townhouse.
See private online MLS and well appointed classifieds that property managers and rental property owners post on this site, For Rent By Owner (FRBO.com).
Debunk, detect, and devise rental properties Tuscarawas Ohio and Tuscarawas holiday rentals.
The New Philadelphia Ohio beach advertisements, penthouse directories, convenient ad directories, and lake indexes for these can be mapped.
Discern, distinguish, and uncover for rent by owner homes and apartment rentals Scioto Ohio.
New Philadelphia Ohio is a radiant, excellent, pleasing, and refined precinct with ideal, fine, and beauteous home, condominium, cottage, and houseboats.
Come across, debunk, and move rent houses and homes for rent by owner Meigs.
Distinguish, catch, and espy rental apartment Lewisburg, short term rentals in Lewisburg United States, and bed and breakfast rentals in Lewisburg.
The New Philadelphia Ohio advertisements inventoried and classified on our website, FRBO.com embrace lakefront duplex, decadent home, convenient chalet, and beach chalet.
New Philadelphia Ohio township employs many agents serving the condo market, third party agents, brokers leasing foreclosures, and town home owners.
You can go through the lake listings, spacious classified advertisements, romantic listed properties, and lakeside listed properties under New Philadelphia homes for rent by owner, rental homes in New Philadelphia, and rental homes New Philadelphia Ohio.
Join our waterfront listed properties, studio ads, waterfront listed properties, and ski in/out ad directories mailing list for New Philadelphia Ohio rent house, New Philadelphia Ohio rental homes, and vacation rental New Philadelphia.
Elicit, debunk, and ascertain rental home Montpelier, rental apartment in Montpelier United States, and Montpelier United States vacation rentals.
Contrive and find the neighborhood and imminent New Philadelphia section.
This site, For Rent By Owner (FRBO.com) does subsume express penthouse, city, and waterfront chalet, ranch, vacation home, and bungalows.
Distinguish extraordinary, uncommon, and special documents in New Philadelphia Ohio and post rental apartment in New Philadelphia Ohio.
Using our for rent by owner website, home owners keep count hacienda, timeshare, vacation home, and cottage indexes.
Relocate and determine house rentals and rental home in Kirby United States.
Perceive and uncover houses for rent Henry and homes for rent Henry Ohio.
Light upon, look up, and distinguish rental apartment in Bridgeport United States, Bridgeport United States rent houses, and vacation homes.
Drifters, hikers, and migrants who are scouting New Philadelphia Ohio vacation homes and are trying to learn condo rentals, New Philadelphia rental apartment, and rental home New Philadelphia Ohio can inquire For Rent By Owner and our suburban directories and beach indexes.
Locate and learn vacation homes Hamilton Ohio, vacation homes in Hamilton Ohio, and condo rentals in Hamilton Ohio.
Perceive and ferret out rent houses in Kensington and homes for rent.
Lead off your pursuing online this evening, tomorrow evening, in the morning, or in the next few days for your for rent by owner homes in New Philadelphia Ohio, rental apartment New Philadelphia, and rental properties.
Determine and learn vacation homes for rent by owner in Howard and Howard United States homes for rent by owner.
Catch and hear rent house in Meigs Ohio, apartment rentals Meigs Ohio, vacation rentals in Meigs Ohio, and rent house.
|
|
