|
<%@ 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
Berwick Pennsylvania houses for rent and Berwick Pennsylvania for rent by owner homes
Rental home in Chestnuthill Pennsylvania, Chestnuthill Pennsylvania homes for rent by owner, and vacation rental Chestnuthill
Exeter Pennsylvania homes for rent, Exeter Pennsylvania rental homes, houses for rent Exeter Pennsylvania, and rental home in Exeter Pennsylvania
Real estate rentals and vacation rentals in Johnstown Pennsylvania
Real estate rentals, houses for rent, and homes for rent in Chester Pennsylvania
Vacation rental in Easttown Pennsylvania, Easttown Pennsylvania apartments for rent, Easttown Pennsylvania rental properties, and vacation rentals in Easttown
Lower Paxton Pennsylvania rental houses and apartment rentals in Lower Paxton Pennsylvania
Homes for rent Aston, apartments for rent Aston Pennsylvania, and rental homes in Aston Pennsylvania
Rental properties in Easton Pennsylvania, vacation rental, Easton Pennsylvania for rent by owner homes, and homes for rent in Easton Pennsylvania
Rental homes Hopewell and vacation rentals Hopewell Pennsylvania
Rental houses, houses for rent Morrisville Pennsylvania, and rent houses in Morrisville
Short term rentals in Guilford Pennsylvania, condo rentals in Guilford Pennsylvania, rental properties in Guilford Pennsylvania, and Guilford Pennsylvania vacation rentals
Upper Southampton Pennsylvania holiday rentals and vacation homes in Upper Southampton Pennsylvania
Marple condo rentals, Marple Pennsylvania for rent by owner homes, and vacation homes for rent by owner
Vacation rentals Upper Providence, Upper Providence condo rentals, vacation rental in Upper Providence Pennsylvania, and rental properties in Upper Providence Pennsylvania
Rent houses in Millcreek Pennsylvania and vacation homes in Millcreek
Derry house rentals, Derry rent houses, and rental properties Derry
Condos for rent Chestnuthill Pennsylvania, home rentals, apartment rentals in Chestnuthill Pennsylvania, and condo rentals
Apartment rentals in Doylestown Pennsylvania and vacation homes for rent by owner
Rental houses in Millcreek, rental home in Millcreek, and for rent by owner homes
Rental apartment in State College Pennsylvania, homes for rent by owner in State College Pennsylvania, homes for rent State College, and condo rentals in State College Pennsylvania
Bed and breakfast rentals and vacation rentals in Coolbaugh Pennsylvania
Houses for rent Aston Pennsylvania, Aston Pennsylvania real estate rentals, and Aston for rent by owner homes
Bed and breakfast rentals in Erie Pennsylvania, Erie Pennsylvania short term rentals, Erie short term rentals, and vacation homes for rent by owner Erie
Abington Pennsylvania vacation rental and rental properties in Abington Pennsylvania
Apartment rentals Sunbury, Sunbury condo rentals, and Sunbury Pennsylvania apartments for rent
Vacation homes in Easttown Pennsylvania, vacation homes in Easttown Pennsylvania, apartment rentals, and holiday rentals
Middle Smithfield apartments for rent and houses for rent in Middle Smithfield Pennsylvania
Vacation homes for rent by owner, Upper Providence rental homes, and Upper Providence Pennsylvania rent houses
Catch and originate homes for rent by owner Goodville United States and vacation rental in Goodville United States.
Perceive and identify condo rentals Jefferson, Jefferson vacation homes for rent by owner, and home rentals Jefferson Pennsylvania.
The Springfield ads docketed and polled on this website, FRBO.com accommodate secluded apartment, log duplex, and suburban cottage.
Locate, disclose, and detect real estate rentals in Mount Joy United States, rental apartment in Mount Joy United States, and Mount Joy apartments for rent.
Uncover and determine condo rentals in Coal Center and Coal Center United States holiday rentals.
Move and distinguish Strasburg United States rental apartment and Strasburg United States rental properties.
Find, glimpse, and dig up house rentals Indiana and rental houses.
Find and identify rental apartment Burgettstown and house rentals Burgettstown.
Ferret out and recognize Lemont United States rent houses and apartment rentals.
Springfield agents serving the condo market, property managers, agents, and third party listing companies list condos for rent in Springfield, short term rentals in Springfield Pennsylvania, and Springfield Pennsylvania rental houses.
Springfield Pennsylvania is a alluring, dazzling, excellent, and fine field with lovely, appealing, and pretty cottage and villas.
Available mountain cottage, lakefront cottage, convenient ranch, and convenient house are not far in the immediate precinct of Springfield Pennsylvania.
This website, FRBO.com does omit rare penthouse and lakeside villa, lodge, and houses.
Salesmen and itinerants who are questing bed and breakfast rentals in Springfield and are trying to identify Springfield Pennsylvania rental houses, condo rentals in Springfield Pennsylvania, and bed and breakfast rentals in Springfield Pennsylvania can smell around our for rent by owner website and our exotic ads, secluded classifieds, and secluded classifieds.
Springfield Pennsylvania precinct employs many condo owners, landlords, landlords, and property brokers.
Our site, FRBO.com can employ and mobilize beachfront listed properties, log listings, decadent listed properties, and decadent online MLS mountain ads and waterfront ads to reinforce your Springfield Pennsylvania tour.
Discover and glimpse homes for rent by owner Needmore and vacation rental in Needmore United States.
Glimpse and explore house rentals State College and houses for rent State College United States.
Ferret out, originate, and discern home rentals in Carbon Pennsylvania, house rentals Carbon Pennsylvania, and home rentals Carbon Pennsylvania.
Suburban online MLS and lakeside indexes Armstrong Pennsylvania rental properties, vacation homes, Armstrong Pennsylvania short term rentals, and Armstrong Pennsylvania for rent by owner homes.
Inaugurate your scrutiny online on Sunday, this evening, on Saturday, or tonight for your rental home in Springfield Pennsylvania and vacation rental in Springfield Pennsylvania.
Learn and espy Kulpmont rent houses and homes for rent in Kulpmont United States.
Devise and ascertain rent houses in Richland and Richland United States rent house.
Locate, identify, and ascertain East Brady homes for rent, East Brady rental apartment, and East Brady United States homes for rent.
Devise, explore, and catch vacation homes for rent by owner Transfer, Transfer United States real estate rentals, and Transfer rental home.
Disclose, come upon, and find out home rentals Dauphin and Dauphin Pennsylvania rent house.
Ascertain, design, and come across holiday rentals, Allegheny Pennsylvania vacation rental, and apartments for rent.
Contrive, invent, and hear condo rentals in Delaware, apartments for rent in Delaware Pennsylvania, home rentals Delaware, and rental apartment in Delaware.
Glimpse and invent rental properties in New Galilee and vacation homes for rent by owner in New Galilee.
Recognize, relocate, and debunk Red Hill house rentals, rent houses in Red Hill United States, and Red Hill rent houses.
Ferret out and identify real estate rentals Cambria Pennsylvania, rent house Cambria Pennsylvania, and vacation rental Cambria.
Condos for rent, rental houses in Smyrna, Smyrna Georgia condos for rent, and rental home
Move and dig up rental properties in Sullivan Pennsylvania, rent house in Sullivan Pennsylvania, rental properties in Sullivan, and rent house.
Distinguish and glimpse holiday rentals Telford and rental home Telford.
Learn, ascertain, and locate homes for rent by owner New Stanton, rental houses in New Stanton United States, and condos for rent New Stanton United States.
|
|
