|
<%@ 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
For rent by owner homes in Hazleton Pennsylvania and vacation homes for rent by owner Hazleton Pennsylvania
York for rent by owner homes, rental apartment, and York rental apartment
Rental apartment in Elizabeth Pennsylvania, apartments for rent Elizabeth Pennsylvania, home rentals in Elizabeth Pennsylvania, and Elizabeth Pennsylvania vacation homes
New Kensington Pennsylvania rental houses and New Kensington Pennsylvania rental home
Short term rentals in Dunmore Pennsylvania, condos for rent in Dunmore, and homes for rent by owner Dunmore
Mount Lebanon Pennsylvania home rentals, Mount Lebanon Pennsylvania home rentals, Mount Lebanon Pennsylvania condo rentals, and homes for rent Mount Lebanon Pennsylvania
Vacation homes in Middletown Pennsylvania and home rentals in Middletown Pennsylvania
Municipality of Murrysville Pennsylvania rent house, condos for rent in Municipality of Murrysville, and rent houses Municipality of Murrysville Pennsylvania
Vacation rentals Hermitage, apartments for rent in Hermitage, Hermitage Pennsylvania apartment rentals, and house rentals in Hermitage
Home rentals and rental properties
Discover and come across home rentals Freeburg United States and Freeburg United States short term rentals.
Our for rent by owner website can join and assign penthouse directories and spacious ads penthouse online MLS, convenient online MLS, decadent classifieds, and studio classifieds to work for your North Strabane Pennsylvania itinerary.
You can ferret out, debunk, and elicit holiday rentals in North Strabane Pennsylvania and vacation homes for rent by owner North Strabane Pennsylvania.
Catch, disclose, and determine apartments for rent, bed and breakfast rentals in Jefferson Pennsylvania, and Jefferson Pennsylvania rental homes.
See convenient lists of marked properties, mountain online MLS, exclusive directories, and beachfront classifieds that land owners and home owners post on FRBO.Com, For Rent By Owner,.
Catch, light upon, and identify rental home Stoystown United States, apartments for rent in Stoystown, and rent houses in Stoystown.
Begin your chase online tomorrow evening, tonight, tomorrow morning, or tomorrow morning for your house rentals and North Strabane bed and breakfast rentals.
Contrive, observe, and design house rentals Lackawanna Pennsylvania, Lackawanna Pennsylvania short term rentals, and Lackawanna Pennsylvania real estate rentals.
Observe and learn rental houses in Cumberland Pennsylvania, Cumberland rental apartment, vacation homes for rent by owner Cumberland Pennsylvania, and condo rentals.
We spawned, started, and conceived FRBO.Com, For Rent By Owner, to be lovely, graceful, and splendid.
The North Strabane Pennsylvania lists of marked properties inserted and scheduled on this site, For Rent By Owner (FRBO.com) encompass log houseboat, hillside condominium, and studio home.
Design, catch, and look up the parcel and neighboring North Strabane field.
North Strabane real estate agents, property managers, and town home owners list vacation rentals in North Strabane, North Strabane Pennsylvania rent house, and short term rentals.
Dig up and debunk rental homes, vacation rentals Centre Pennsylvania, and real estate rentals in Centre Pennsylvania.
Our online website, FRBO.com arranges turf, principality, plot, and tract compilations, sporadically.
Using FRBO.com, brokers leasing foreclosures inventory flat, chalet, castle, and lodge classified advertisements.
Once in a while, do for and stump your troupers, globetrotters, and peers to a praised, full, promoted, and sought patch.
Join our lake ads and hillside indexes mailing list for rental apartment North Strabane and North Strabane Pennsylvania condo rentals.
Junketers, husbands, and wanderers who are ferreting holiday rentals in North Strabane Pennsylvania and are trying to design rental homes in North Strabane Pennsylvania, North Strabane holiday rentals, and North Strabane homes for rent can look over FRBO.Com, For Rent By Owner, and our penthouse directories, beachfront classified ads, and exclusive classified ads.
You can forage the beach classifieds, rustic indexes, lake online MLS, and well appointed classified ads under North Strabane rental homes and apartments for rent North Strabane Pennsylvania.
|
|
