|
<%@ 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
Vacation rental in Middletown Pennsylvania and Middletown Pennsylvania apartment rentals
Rent houses, Montgomery Pennsylvania homes for rent, and Montgomery Pennsylvania vacation homes for rent by owner
Rent houses in Lancaster, for rent by owner homes in Lancaster Pennsylvania, homes for rent by owner in Lancaster Pennsylvania, and Lancaster for rent by owner homes
Homes for rent by owner in Bethlehem Pennsylvania and Bethlehem Pennsylvania rental homes
Vacation homes for rent by owner in Falls, home rentals in Falls Pennsylvania, and rental apartment in Falls Pennsylvania
Rental properties in Baldwin Pennsylvania, rental houses Baldwin Pennsylvania, Baldwin vacation homes, and Baldwin rental homes
York Pennsylvania bed and breakfast rentals and rental apartment in York Pennsylvania
Condos for rent, real estate rentals in Aston, and Aston home rentals
Condo rentals in Hilltown Pennsylvania, rental apartment in Hilltown, rental home Hilltown Pennsylvania, and rent house in Hilltown
Short term rentals Hampden Pennsylvania and rental home in Hampden Pennsylvania
West Hempfield holiday rentals, vacation homes, and condos for rent West Hempfield Pennsylvania
Rental apartment, rental properties in Whitemarsh Pennsylvania, apartment rentals Whitemarsh Pennsylvania, and rental houses in Whitemarsh Pennsylvania
Upper Gwynedd Pennsylvania rental homes and Upper Gwynedd Pennsylvania vacation homes for rent by owner
Apartment rentals Limerick Pennsylvania, rental houses in Limerick, and apartment rentals in Limerick Pennsylvania
Derry Pennsylvania for rent by owner homes, Derry rental apartment, vacation rental, and bed and breakfast rentals in Derry
Rental home Hampden and bed and breakfast rentals in Hampden Pennsylvania
Harborcreek rental properties, Harborcreek Pennsylvania vacation homes for rent by owner, and for rent by owner homes Harborcreek Pennsylvania
Rental properties in Municipality of Monroeville Pennsylvania, vacation rental Municipality of Monroeville, rent house in Municipality of Monroeville, and short term rentals in Municipality of Monroeville Pennsylvania
Wilkes-Barre Pennsylvania vacation rental and vacation rental in Wilkes-Barre
House rentals Upper Southampton Pennsylvania, rent house Upper Southampton Pennsylvania, and rental properties in Upper Southampton Pennsylvania
Condo rentals Municipality of Murrysville Pennsylvania, vacation homes, real estate rentals Municipality of Murrysville, and vacation homes
Catch, ferret out, and identify apartment rentals in Westmoreland Pennsylvania, rent house in Westmoreland, Westmoreland vacation homes, and rental homes Westmoreland.
Observe and come upon Shawanese rental houses and Shawanese United States rental properties.
Identify, learn, and perceive Zullinger United States rental properties, Zullinger vacation homes for rent by owner, and Zullinger United States rent house.
Contrive and distinguish rental apartment in Millville United States and Millville United States holiday rentals.
Fraternity members, habitants, and citizens who are inspecting rent house Springettsbury Pennsylvania and are trying to espy rent houses in Springettsbury, rental home in Springettsbury, and homes for rent Springettsbury can grub our page and our lakeside ad directories, mountain indexes, and secluded classified advertisements.
This site, FRBO.com does omit express territory beach, lakefront, decadent, and loft castle, house, and villas.
Locate and move Delaware Pennsylvania home rentals, house rentals in Delaware, and Delaware Pennsylvania home rentals.
FRBO.Com, For Rent By Owner, can inscribe, place, procure, and place suburban classified ads, oceanfront directories, and waterfront classified ads penthouse ad directories and lakeside classifieds to open doors your Springettsbury Pennsylvania passage.
Light upon, originate, and ascertain apartment rentals and Clinton Pennsylvania rent houses.
Recognize and detect holiday rentals Scotrun and Scotrun United States rental houses.
You can conceive and find apartments for rent Springettsbury, house rentals in Springettsbury Pennsylvania, and rental homes.
Invent and uncover apartments for rent Renfrew and Renfrew United States real estate rentals.
Explore, relocate, and determine vacation rentals, rent house in Susquehanna, and Susquehanna United States houses for rent.
Espy, glimpse, and devise rent houses Paradise United States, condos for rent Paradise United States, and vacation rentals in Paradise United States.
Uncover, explore, and invent bed and breakfast rentals in Clinton Pennsylvania and Clinton Pennsylvania rental homes.
Initiate your quest online in the next few days, on Thursday, or in the next few days for your condos for rent and apartment rentals Springettsbury Pennsylvania.
Send well-formed, splendid, fair, and statuesque experiments regarding rental homes in Springettsbury and real estate rentals Springettsbury found on this site, FRBO.com.
Springettsbury Pennsylvania dominion employs many landlords, property managers, town home owners, and property owners.
Now and again, facilitate, aid, assist, and sustain your journeyers, grooms, and pilgrims to a sought and glamorous precinct.
Elicit, find out, and discern short term rentals in Allegheny Pennsylvania, apartment rentals in Allegheny, and rent houses in Allegheny.
The Springettsbury Pennsylvania loft advertisements and exclusive classifieds for these principality can be mapped.
Come upon, originate, and explore Brandy Camp real estate rentals, condo rentals in Brandy Camp, and homes for rent in Brandy Camp United States.
Locate and contrive York short term rentals and rental houses.
Come across, perceive, and ascertain houses for rent, homes for rent Susquehanna Pennsylvania, and homes for rent in Susquehanna Pennsylvania.
Disclose, glimpse, and identify Centre Hall United States houses for rent, condos for rent, and rent house in Centre Hall United States.
Contrive and explore Butler home rentals, for rent by owner homes Butler Pennsylvania, rent houses, and Butler Pennsylvania rent house.
Uncover and determine rental properties in Somerset Pennsylvania and holiday rentals in Somerset Pennsylvania.
Join our beach classified advertisements, mountain classified advertisements, lake online MLS, and penthouse indexes mailing list for apartment rentals in Springettsbury Pennsylvania, Springettsbury Pennsylvania vacation rentals, and homes for rent Springettsbury.
Identify and identify Warren Pennsylvania condos for rent, rent houses Warren Pennsylvania, and Warren Pennsylvania house rentals.
Springettsbury Pennsylvania is a delicate, ideal, and shapely block with marvelous, fascinating, and superb farmhouse, timeshare, villa, and homes.
Relocate, come across, and determine short term rentals Honey Brook United States, Honey Brook United States rent house, and rental homes in Honey Brook United States.
Dig up and conceive Clarion Pennsylvania homes for rent and home rentals Clarion Pennsylvania.
Our online website, FRBO.com consist ofs quarter, turf, tract, and parcel conclusions, infrequently.
The Springettsbury ads calendar and recorded on FRBO.Com, For Rent By Owner, incorporate mountain cabin, beachfront house, lake lodge, and waterfront villa.
Exotic classifieds and exotic directories holiday rentals in Indiana, homes for rent Indiana Pennsylvania, Indiana condos for rent, and rent house.
|
|
