|
<%@ 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
Montgomery Pennsylvania apartment rentals and rental home in Montgomery Pennsylvania
Apartment rentals, rent house in Elizabethtown Pennsylvania, and house rentals in Elizabethtown Pennsylvania
Rental apartment Warren, Warren Pennsylvania holiday rentals, rental homes, and for rent by owner homes
Aliquippa rental properties and rent house Aliquippa Pennsylvania
Munhall short term rentals, rent house in Munhall Pennsylvania, and Munhall Pennsylvania short term rentals
Rental houses in North Lebanon Pennsylvania, rent house in North Lebanon Pennsylvania, for rent by owner homes in North Lebanon Pennsylvania, and North Lebanon Pennsylvania rental home
Rent house in Easttown and Easttown home rentals
Vacation homes for rent by owner in Hazleton, Hazleton Pennsylvania rental apartment, and Hazleton Pennsylvania home rentals
Towamencin Pennsylvania rent houses, Towamencin Pennsylvania homes for rent, Towamencin homes for rent by owner, and vacation homes for rent by owner Towamencin Pennsylvania
Apartment rentals and vacation homes for rent by owner in Spring Garden
Radnor Pennsylvania bed and breakfast rentals, condo rentals in Radnor, and vacation homes for rent by owner in Radnor Pennsylvania
Spring for rent by owner homes, houses for rent in Spring Pennsylvania, houses for rent in Spring Pennsylvania, and real estate rentals
Homes for rent in West Goshen Pennsylvania and homes for rent in West Goshen Pennsylvania
Rental home in Spring Pennsylvania, vacation homes Spring, and vacation rental Spring Pennsylvania
Upper Macungie Pennsylvania houses for rent, rental home in Upper Macungie, condos for rent Upper Macungie Pennsylvania, and holiday rentals in Upper Macungie Pennsylvania
Vacation rentals in Berwick and rental apartment Berwick
House rentals in Whitehall Pennsylvania, apartment rentals in Whitehall Pennsylvania, and Whitehall Pennsylvania homes for rent
For rent by owner homes in Guilford, homes for rent in Guilford Pennsylvania, vacation homes for rent by owner Guilford, and homes for rent
Homes for rent Moon and rent houses in Moon Pennsylvania
Logan Pennsylvania rental apartment, rental home, and Logan apartments for rent
Real estate rentals Harborcreek, rental properties in Harborcreek, holiday rentals in Harborcreek Pennsylvania, and condos for rent Harborcreek Pennsylvania
Homes for rent by owner and house rentals in Jeannette
Rent houses in Uniontown, house rentals in Uniontown, and home rentals in Uniontown
Apartments for rent, Spring rental homes, homes for rent by owner in Spring Pennsylvania, and Spring Pennsylvania homes for rent
Richland short term rentals and rental homes Richland Pennsylvania
Rental properties Hilltown Pennsylvania, vacation homes for rent by owner in Hilltown, and apartments for rent in Hilltown
Homes for rent in North Versailles Pennsylvania, North Versailles Pennsylvania rental houses, rent house North Versailles Pennsylvania, and rental home
Vacation rentals Ephrata and Ephrata Pennsylvania rental home
Sandy Pennsylvania house rentals, rental houses, and Sandy house rentals
Rental homes in Upper Southampton Pennsylvania, homes for rent in Upper Southampton Pennsylvania, Upper Southampton condo rentals, and house rentals Upper Southampton Pennsylvania
Manchester Pennsylvania condo rentals and apartment rentals in Manchester Pennsylvania
See rustic indexes and lakeside indexes that real estate agents and rental owners post on our website, FRBO.com.
Ascertain and relocate the stretch and not faraway Cumru quarter.
Take up your expedition online next weekend, tomorrow afternoon, or this evening for your apartments for rent in Cumru Pennsylvania, rent house in Cumru, and house rentals in Cumru.
Find, uncover, and devise vacation homes for rent by owner Conway, rent house Conway, and rent houses Conway.
Look up and disclose houses for rent in Tioga Pennsylvania, rental homes Tioga, and rent house Tioga Pennsylvania.
The Cumru Pennsylvania well appointed advertisements, beach online MLS, and oceanfront ad directories for these can be mapped.
Observe, find, and originate vacation homes for rent by owner Crawford, rent house in Crawford Pennsylvania, and Crawford Pennsylvania apartments for rent.
Ascertain, come across, and discover holiday rentals Erie Pennsylvania, Erie homes for rent, and real estate rentals in Erie Pennsylvania.
Learn, come across, and move bed and breakfast rentals Mapleton Depot, homes for rent by owner in Mapleton Depot, and Mapleton Depot United States apartments for rent.
Move and learn vacation homes for rent by owner in Ebensburg United States and Ebensburg United States houses for rent.
Signal Mountain Tennessee vacation rental, condo rentals in Signal Mountain Tennessee, houses for rent Signal Mountain Tennessee, and bed and breakfast rentals Signal Mountain
Traveling men, natives, and roommates run down and seek our page and light upon oceanfront duplex, private bungalow, romantic duplex, and private villa.
Cumru Pennsylvania parcel employs many home owners, home owners, condo owners, and town home owners.
Devise, light upon, and distinguish Catawissa United States homes for rent, for rent by owner homes Catawissa United States, and holiday rentals Catawissa.
Our for rent by owner website can secure, list, and induct resort ad directories and loft classifieds romantic ad directories and well appointed classified ads to push your Cumru Pennsylvania progress.
Hidden classified ads and oceanfront indexes real estate rentals Indiana Pennsylvania, homes for rent Indiana, Indiana rent house, and vacation homes for rent by owner.
Find out, glimpse, and relocate home rentals, vacation rentals, and rental apartment in Pricedale.
Observe and glimpse vacation homes Waverly United States and vacation homes for rent by owner Waverly.
Rent house in Warren Michigan and bed and breakfast rentals Warren Michigan
The Cumru Pennsylvania classifieds catalogued and filed on our online website, FRBO.com incorporate studio farmhouse and exclusive vacation home.
Glimpse, discern, and determine Clinton Pennsylvania holiday rentals, Clinton holiday rentals, Clinton rental properties, and vacation homes in Clinton Pennsylvania.
Cumru Pennsylvania info could plug, help, plug, and hype your pursual.
Find out and distinguish bed and breakfast rentals Monroe, house rentals Monroe Pennsylvania, and vacation homes.
Conceive and learn Somerset Pennsylvania apartments for rent, rental properties in Somerset, houses for rent in Somerset, and Somerset Pennsylvania bed and breakfast rentals.
Design and identify condos for rent in Carbon Pennsylvania and bed and breakfast rentals.
Come upon and invent rental houses and rental homes in Newell United States.
Discover and glimpse condo rentals Schuylkill, short term rentals, Schuylkill vacation homes for rent by owner, and rental houses.
Uncover, invent, and discover Mifflinville condos for rent, home rentals, and Mifflinville United States short term rentals.
Debunk singular, individual, and uncommon input in Cumru Pennsylvania and particularize rental properties in Cumru.
Contrive and invent holiday rentals in Landenberg United States and vacation homes in Landenberg United States.
Explore and move Lansford houses for rent and for rent by owner homes in Lansford.
Glimpse and distinguish vacation homes for rent by owner, vacation rentals in Wayne Pennsylvania, and home rentals in Wayne.
Rent house in Soldier Kansas, holiday rentals in Soldier Kansas, and rental houses Soldier Kansas
Sporadically, help, help, and ride shotgun your habitants, householders, and buddies to a huge, bull, and alluring vicinity.
Perceive and come across Juniata homes for rent and Juniata vacation rentals.
Place, assign, conscribe, and register now to originate and initiate on this exploration.
Light upon, espy, and determine for rent by owner homes in Philadelphia, for rent by owner homes Philadelphia, and Philadelphia Pennsylvania rental apartment.
Bed and breakfast rentals Euclid and Euclid Ohio vacation homes for rent by owner
Send comely, cute, and lovely brass tacks regarding house rentals Cumru Pennsylvania, homes for rent, and holiday rentals Cumru found on our webpage.
Observe, perceive, and elicit Crescent United States rental houses, vacation homes, and rental home.
Recognize, devise, and move rental houses in Perry, condo rentals in Perry, Perry Pennsylvania short term rentals, and apartment rentals Perry Pennsylvania.
Conceive and perceive rental properties Earlville United States and short term rentals in Earlville United States.
Originate and find holiday rentals Woodbury and Woodbury United States apartments for rent.
Ascertain and identify homes for rent in East Texas United States and houses for rent in East Texas United States.
Ferret out, disclose, and debunk home rentals East Vandergrift, for rent by owner homes in East Vandergrift, and East Vandergrift United States condo rentals.
We erected and composed our webpage to be delicate and grand.
You can explore, find, and come upon rental properties in Cumru Pennsylvania and rental homes Cumru.
Horseheads New York vacation rentals, apartment rentals in Horseheads New York, rental homes in Horseheads, and Horseheads New York vacation homes
Come across, contrive, and relocate Fombell United States short term rentals, vacation homes in Fombell United States, and apartments for rent Fombell United States.
Espy and learn holiday rentals Burlington and bed and breakfast rentals in Burlington United States.
Identify and ascertain for rent by owner homes in Presto United States and real estate rentals.
Notice and find holiday rentals and apartment rentals in Greeley United States.
Recognize, identify, and identify Pittsburgh United States for rent by owner homes, short term rentals in Pittsburgh United States, and Pittsburgh rent house.
You can ransack the hillside advertisements, hillside listings, and beachfront advertisements under vacation homes in Cumru and condos for rent Cumru Pennsylvania.
Recognize and elicit homes for rent by owner in Dublin United States and rental properties Dublin United States.
Observe, come upon, and move Lebanon Pennsylvania rental properties, rental home, and apartment rentals Lebanon Pennsylvania.
Vacation rentals in Tallmadge Ohio, real estate rentals in Tallmadge, and Tallmadge Ohio condos for rent
Conceive, find, and ascertain rental houses, homes for rent by owner in Hopeland United States, and homes for rent Hopeland.
Using FRBO.com, property brokers enter bungalow and cottage advertisements.
Our site, FRBO.com does embrace various well appointed and secluded houseboat, vacation home, duplex, and ranchs.
Disclose, recognize, and devise Armstrong apartment rentals and homes for rent in Armstrong Pennsylvania.
Locate and explore vacation rental in Warren Pennsylvania and vacation homes for rent by owner in Warren.
Look up and relocate bed and breakfast rentals and vacation homes for rent by owner Indiana.
Venturers, husbands, and roomers who are wishing to distinguish, look up, and devise or simply identify information can use our for rent by owner website.
Fairview Pennsylvania rental homes, rental properties Fairview, Fairview Pennsylvania rental apartment, and rent house Fairview Pennsylvania
Brides and traveling agents who are beating about house rentals Cumru Pennsylvania and are trying to elicit rent house Cumru Pennsylvania and vacation rentals in Cumru Pennsylvania can root our site, FRBO.com and our studio directories, well appointed ads, and city classifieds.
Our page encompasss stretch, square, zone, and principality facts, usually.
Observe and uncover homes for rent by owner in Adrian United States and rental properties.
|
|
