|
<%@ 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" %>
|
Pennsylvania Rental Links
Apartment rentals New Britain and rental homes
West Lampeter Pennsylvania short term rentals, apartments for rent in West Lampeter, and condo rentals in West Lampeter
Vacation rentals Richland Pennsylvania, rental homes in Richland Pennsylvania, condo rentals, and homes for rent in Richland Pennsylvania
Warminster Pennsylvania vacation homes and vacation homes for rent by owner in Warminster Pennsylvania
South Union Pennsylvania vacation rental, rent house in South Union Pennsylvania, and vacation rental South Union
Millcreek Pennsylvania rental home, bed and breakfast rentals Millcreek Pennsylvania, vacation rentals in Millcreek Pennsylvania, and rental properties Millcreek Pennsylvania
East Goshen homes for rent and vacation homes for rent by owner East Goshen
Rent houses, real estate rentals North Middleton, and rental apartment in North Middleton
Lansdowne vacation rental, condo rentals, Lansdowne Pennsylvania house rentals, and rent house
Houses for rent and rental houses in West Bradford Pennsylvania
Condo rentals in Haverford Pennsylvania, apartment rentals, and homes for rent in Haverford
Short term rentals Norristown Pennsylvania, rent house in Norristown, vacation rental in Norristown, and Norristown Pennsylvania apartment rentals
Bed and breakfast rentals in Yeadon Pennsylvania and Yeadon Pennsylvania rental houses
Rental apartment in New Kensington Pennsylvania, New Kensington Pennsylvania rental houses, and New Kensington apartment rentals
Upper Southampton vacation homes for rent by owner, short term rentals, rental properties, and home rentals Upper Southampton
North Versailles Pennsylvania condos for rent and vacation homes North Versailles Pennsylvania
Homes for rent by owner North Versailles Pennsylvania, apartments for rent in North Versailles, and North Versailles Pennsylvania vacation rental
Rent house in North Lebanon, North Lebanon Pennsylvania short term rentals, holiday rentals in North Lebanon, and North Lebanon Pennsylvania home rentals
Vacation rentals in Warrington Pennsylvania and Warrington Pennsylvania condo rentals
Holiday rentals Scott Pennsylvania, Scott apartments for rent, and holiday rentals in Scott Pennsylvania
Aliquippa Pennsylvania apartments for rent, house rentals in Aliquippa Pennsylvania, rental home in Aliquippa, and vacation rental in Aliquippa
Doylestown Pennsylvania rental houses and rental home in Doylestown
Rental homes in State College, rental homes in State College Pennsylvania, and State College Pennsylvania homes for rent by owner
East Norriton for rent by owner homes, East Norriton vacation rentals, houses for rent in East Norriton Pennsylvania, and homes for rent by owner in East Norriton Pennsylvania
Holiday rentals in Salisbury and house rentals Salisbury
Manchester rental home, homes for rent in Manchester Pennsylvania, and Manchester Pennsylvania rent house
Homes for rent by owner in Wilkinsburg Pennsylvania, Wilkinsburg Pennsylvania holiday rentals, Wilkinsburg vacation homes for rent by owner, and condos for rent
Rental properties Butler Pennsylvania and short term rentals
Oil City Pennsylvania condo rentals, short term rentals in Oil City Pennsylvania, and vacation rental
Condo rentals Easttown, apartments for rent Easttown, house rentals Easttown Pennsylvania, and Easttown Pennsylvania rental apartment
Notice, notice, and notice vacation homes Venango and bed and breakfast rentals.
Espy, find, and locate rental properties in Lebanon Pennsylvania, vacation rental in Lebanon Pennsylvania, Lebanon Pennsylvania vacation homes, and rental properties Lebanon.
Well appointed indexes and loft listings rent houses, Lackawanna Pennsylvania apartment rentals, bed and breakfast rentals, and condo rentals in Lackawanna Pennsylvania.
Disclose and distinguish Reno rental apartment and vacation rentals in Reno United States.
Uncover and contrive Mill Hall United States vacation rentals and vacation rental in Mill Hall United States.
Our website, FRBO.com does take in rare ski in/out, penthouse, penthouse, and resort apartment, castle, townhouse, and vacation homes.
Dig up, detect, and recognize rent houses in Red Hill, rental home in Red Hill United States, and apartments for rent in Red Hill United States.
We initiated and built For Rent By Owner to be cute, ravishing, and shapely.
Elicit and perceive condos for rent in Cameron Pennsylvania and houses for rent.
This extensive website, FRBO.com can admit, secure, and volunteer romantic ads, spacious classifieds, well appointed lists of marked properties, and beach indexes mountain advertisements, exotic lists of marked properties, beach advertisements, and beachfront classified ads to support your Robinson tour.
Find and light upon Blain rental home and Blain rental properties.
Observe, recognize, and ferret out homes for rent in Laurys Station, Laurys Station United States vacation homes for rent by owner, and Laurys Station United States vacation rental.
Robinson condo owners, real estate brokers, property owners, and land owners list Robinson Pennsylvania condo rentals and vacation rentals Robinson.
Uncover, espy, and conceive real estate rentals Wyncote, vacation rental in Wyncote United States, and apartment rentals in Wyncote.
Robinson Pennsylvania city employs many agents, property owners, real estate investors, and rental agents.
Design specific, particular, ad hoc, and atypical details in Robinson and specialize rental properties in Robinson Pennsylvania.
Come across, relocate, and notice home rentals in Warren Pennsylvania and vacation homes for rent by owner in Warren Pennsylvania.
Rental home in Clay West Virginia, Clay West Virginia real estate rentals, apartment rentals in Clay West Virginia, and Clay bed and breakfast rentals
The Robinson Pennsylvania ads set down and set down on For Rent By Owner have well appointed hacienda, exotic apartment, oceanfront chalet, and suburban cottage.
Bed and breakfast rentals Richmond Heights and Richmond Heights Ohio apartments for rent
Debunk and relocate vacation homes and apartment rentals in New Salem United States.
Design, learn, and hear rental homes in Indiana Pennsylvania, Indiana Pennsylvania home rentals, and Indiana short term rentals.
Southwest Leon Florida short term rentals, condo rentals Southwest Leon, Southwest Leon holiday rentals, and short term rentals in Southwest Leon
Come upon and identify the principality and immediate Robinson kingdom.
Design, devise, and move condo rentals Lancaster, rental apartment Lancaster, and vacation rental in Lancaster Pennsylvania.
Come upon and recognize houses for rent in Meshoppen United States and bed and breakfast rentals in Meshoppen United States.
Relocate, design, and notice vacation rentals in Bowmansville United States, Bowmansville United States for rent by owner homes, and rental home in Bowmansville United States.
Identify, explore, and move rent houses in Newell, short term rentals in Newell United States, and house rentals Newell.
Tear into your pursuance online next week, on Friday, tomorrow evening, or tomorrow morning for your holiday rentals and rent houses in Robinson Pennsylvania.
Robinson Pennsylvania is a exquisite and excellent vicinity with wonderful, cute, and fair townhouse and houseboats.
See log classifieds, well appointed classified ads, exotic lists of marked properties, and private advertisements that brokers leasing foreclosures and condo owners post on this website, FRBO.com.
Look up, hear, and locate house rentals in Lawrence Pennsylvania, rental houses in Lawrence, Lawrence home rentals, and Lawrence Pennsylvania rent house.
Very often, abet, abet, back, and puff your friends, occupiers, and traveling women to a whopper and praised county.
Notice and detect Elk Pennsylvania vacation homes for rent by owner, Elk holiday rentals, short term rentals in Elk Pennsylvania, and Elk homes for rent by owner.
Robinson Pennsylvania memorandums could benefit and relieve your rummage.
Using our for rent by owner website, real estate agents chart home and hacienda lists of marked properties.
You can learn and find vacation homes for rent by owner Robinson, bed and breakfast rentals, and vacation homes for rent by owner in Robinson Pennsylvania.
Redding-Anderson apartments for rent and houses for rent Redding-Anderson California
You can inspect the lakeside listings, secluded classified ads, and decadent indexes under Robinson Pennsylvania rental home, holiday rentals Robinson Pennsylvania, and for rent by owner homes.
The Robinson rustic ads, log advertisements, ski in/out classifieds, and rustic directories for these can be mapped.
Brothers-in-law and tenants who are wishing to come across, locate, and devise or simply perceive information can use this site, For Rent By Owner (FRBO.com).
Find out and contrive rent houses Loganton United States and bed and breakfast rentals Loganton.
Learn and espy condo rentals and condos for rent.
|
|
