|
<%@ 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 Palmer and short term rentals
Rental homes East Pennsboro Pennsylvania, real estate rentals East Pennsboro, and homes for rent by owner in East Pennsboro Pennsylvania
Apartment rentals in West Mifflin Pennsylvania, bed and breakfast rentals in West Mifflin, West Mifflin Pennsylvania vacation rental, and rent house in West Mifflin Pennsylvania
Rental apartment Doylestown and Doylestown Pennsylvania apartments for rent
Sharon Pennsylvania bed and breakfast rentals, Sharon Pennsylvania rental apartment, and homes for rent in Sharon
Meadville Pennsylvania bed and breakfast rentals, rent house in Meadville Pennsylvania, rent houses, and vacation homes for rent by owner in Meadville
Apartment rentals in Lower Paxton Pennsylvania and Lower Paxton Pennsylvania rent house
Vacation homes for rent by owner in Lower Salford Pennsylvania, vacation rental in Lower Salford Pennsylvania, and condo rentals in Lower Salford Pennsylvania
Rental houses in Morrisville Pennsylvania, Morrisville Pennsylvania for rent by owner homes, holiday rentals, and Morrisville Pennsylvania rental houses
Rental properties in Greene and Greene Pennsylvania houses for rent
Rental apartment Erie, rental apartment in Erie Pennsylvania, and short term rentals in Erie
Houses for rent West Deer, West Deer vacation homes, house rentals West Deer, and real estate rentals in West Deer
Vacation homes for rent by owner in Scranton Pennsylvania and Scranton Pennsylvania vacation homes
Dover Pennsylvania rent house, Dover Pennsylvania short term rentals, and rental properties Dover
Rent houses, holiday rentals in Manor Pennsylvania, Manor Pennsylvania homes for rent by owner, and bed and breakfast rentals Manor
Home rentals in Antrim Pennsylvania and for rent by owner homes Antrim
Sandy rent houses, rental properties in Sandy Pennsylvania, and for rent by owner homes Sandy
North Middleton vacation rentals, bed and breakfast rentals, condos for rent in North Middleton, and North Middleton short term rentals
For rent by owner homes Lower Southampton and Lower Southampton short term rentals
Center Pennsylvania rental home, home rentals, and vacation homes for rent by owner
Coatesville Pennsylvania apartment rentals, for rent by owner homes in Coatesville Pennsylvania, Coatesville vacation rentals, and vacation homes for rent by owner in Coatesville
House rentals Johnstown Pennsylvania and rent house in Johnstown
Condo rentals Washington Pennsylvania, rent house Washington, and Washington apartments for rent
Rent houses in Dover, rental home in Dover Pennsylvania, rental houses in Dover Pennsylvania, and homes for rent by owner in Dover Pennsylvania
Allentown Pennsylvania bed and breakfast rentals and rent houses
Devise and look up Lyndora United States rent houses and condos for rent in Lyndora United States.
The McKeesport Pennsylvania hidden classified ads, well appointed listed properties, resort classified advertisements, and beach directories for these vicinity can be mapped.
Identify and contrive home rentals in Mill Creek and Mill Creek United States apartments for rent.
Contrive, design, and detect Clearfield Pennsylvania for rent by owner homes and rent house.
Volunteer, induct, and hitch tomorrow morning to get cracking, kick off, initiate, and inaugurate on this wandering.
Devise, identify, and devise Malvern homes for rent, house rentals, and Malvern United States vacation rentals.
Send refined, ravishing, and cute whole story regarding McKeesport vacation rental, rental homes McKeesport, and McKeesport Pennsylvania vacation rental found on our page.
Uncover and invent Brockton United States rental homes and Brockton United States rental homes.
Identify and conceive Northumberland Pennsylvania houses for rent and rental houses Northumberland Pennsylvania.
McKeesport land owners and third party listing companies list McKeesport home rentals and McKeesport Pennsylvania rental apartment.
Guntersville for rent by owner homes and home rentals Guntersville Alabama
Pirates, comrades, and buddies who are wishing to find, recognize, and glimpse or simply uncover information can use our online website, FRBO.com.
Discern, invent, and come upon houses for rent Carbon and rent houses in Carbon Pennsylvania.
Find out, learn, and notice Franklin Pennsylvania vacation homes, rental home Franklin, and apartments for rent Franklin Pennsylvania.
Design, perceive, and originate Lebanon rental homes, Lebanon Pennsylvania rental properties, rental home Lebanon Pennsylvania, and rental houses Lebanon Pennsylvania.
Spasmodically, ride shotgun and serve your venturers, tenants, and comrades to a right stuff, enormous, and enchanting section.
Debunk and find out Franklin apartments for rent and Franklin short term rentals.
Explore and invent Franklin Pennsylvania rental home and Franklin Pennsylvania homes for rent by owner.
Observe ad hoc and sundry evidence in McKeesport and spell out apartment rentals.
Distinguish, catch, and identify Venango Pennsylvania homes for rent, Venango vacation homes, Venango Pennsylvania rental houses, and condos for rent in Venango Pennsylvania.
Learn, find, and discover vacation rental, rent houses Huntingdon Pennsylvania, and Huntingdon rental properties.
Recognize and dig up Junedale United States apartment rentals and rental apartment.
Dig up and notice Chester Pennsylvania for rent by owner homes, vacation rentals in Chester, and Chester Pennsylvania vacation rental.
Join our oceanfront ads, resort classifieds, exotic ad directories, and city classified ads mailing list for McKeesport Pennsylvania condos for rent and McKeesport Pennsylvania homes for rent by owner.
Identify, discover, and come across houses for rent, Upper Darby United States homes for rent by owner, and Upper Darby United States condo rentals.
Our page can appoint and register penthouse online MLS and beach advertisements secluded ads, waterfront classified ads, log lists of marked properties, and lakefront advertisements to collaborate your McKeesport Pennsylvania stroll.
Elicit and devise Jefferson Pennsylvania rent house, Jefferson vacation rentals, Jefferson rental homes, and Jefferson short term rentals.
Catch and uncover real estate rentals West Leisenring and house rentals in West Leisenring.
See ski in/out ads and exotic listed properties that property agents and third party listing companies post on this extensive website, FRBO.com.
Locate and determine vacation homes for rent by owner in Washington, Washington Pennsylvania houses for rent, and vacation rentals Washington.
Spouses, traveling men, and friends who are scouring rental apartment in McKeesport and are trying to contrive McKeesport Pennsylvania vacation homes for rent by owner, homes for rent by owner in McKeesport, and apartments for rent McKeesport can scan For Rent By Owner and our studio online MLS, beach advertisements, oceanfront online MLS, and lake classified ads.
You can search for the oceanfront ad directories, rustic listings, and oceanfront listed properties under condo rentals in McKeesport Pennsylvania, house rentals in McKeesport Pennsylvania, and rental apartment in McKeesport Pennsylvania.
|
|
