|
<%@ 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 homes for rent by owner in West Bradford Pennsylvania and West Bradford Pennsylvania homes for rent by owner
Rental home in Lower Gwynedd, vacation homes for rent by owner Lower Gwynedd Pennsylvania, and Lower Gwynedd holiday rentals
Condos for rent in Derry, Derry Pennsylvania homes for rent, Derry Pennsylvania rent houses, and apartment rentals Derry
Short term rentals Doylestown Pennsylvania and homes for rent by owner in Doylestown
West Hempfield Pennsylvania houses for rent, condo rentals in West Hempfield Pennsylvania, and condos for rent in West Hempfield Pennsylvania
Short term rentals in Upper Gwynedd Pennsylvania, apartment rentals in Upper Gwynedd Pennsylvania, homes for rent by owner Upper Gwynedd, and real estate rentals Upper Gwynedd
Susquehanna homes for rent and homes for rent by owner Susquehanna
House rentals in Middle Smithfield Pennsylvania, Middle Smithfield Pennsylvania homes for rent, and vacation rentals in Middle Smithfield Pennsylvania
Home rentals in Ferguson Pennsylvania, vacation rental Ferguson Pennsylvania, Ferguson bed and breakfast rentals, and holiday rentals
Vacation rentals Falls Pennsylvania and holiday rentals Falls Pennsylvania
Condo rentals Washington Pennsylvania, Washington rental home, and Washington Pennsylvania homes for rent
Cheltenham condo rentals, Cheltenham Pennsylvania home rentals, houses for rent, and vacation rental in Cheltenham
Holiday rentals Upper Saucon Pennsylvania and condo rentals in Upper Saucon Pennsylvania
Apartments for rent Erie Pennsylvania, bed and breakfast rentals Erie Pennsylvania, and for rent by owner homes in Erie Pennsylvania
Stroud vacation rentals, condo rentals Stroud, rent houses in Stroud Pennsylvania, and rent houses Stroud
Sandy Pennsylvania condos for rent and rental homes in Sandy
Philadelphia homes for rent by owner, Philadelphia Pennsylvania houses for rent, and bed and breakfast rentals in Philadelphia
Lower Burrell real estate rentals, vacation homes in Lower Burrell Pennsylvania, houses for rent in Lower Burrell Pennsylvania, and rental apartment
Condos for rent in Lower Paxton Pennsylvania and rent house in Lower Paxton Pennsylvania
Middletown Pennsylvania for rent by owner homes, vacation rentals in Middletown, and homes for rent by owner in Middletown
McCandless rental agents and brokers leasing foreclosures list McCandless bed and breakfast rentals, rental apartment McCandless, and vacation rentals in McCandless.
Recognize, hear, and detect Twin Rocks United States holiday rentals, houses for rent Twin Rocks United States, and condos for rent Twin Rocks United States.
Invent and distinguish Imperial vacation rentals and rent house in Imperial United States.
Convenient directories and loft ad directories Venango Pennsylvania vacation homes, Venango Pennsylvania rent houses, Venango Pennsylvania rental houses, and Venango Pennsylvania home rentals.
Find and originate for rent by owner homes in Clarion Pennsylvania, apartments for rent Clarion Pennsylvania, rental home Clarion Pennsylvania, and vacation rental in Clarion Pennsylvania.
Husbands, lodgers, and troupers forage and scour FRBO.com and uncover lake flat, studio house, city duplex, and studio flat.
Often, boost and benefit your fortune-hunters, cohorts, and fellow workers to a stylish, agreeable, luring, and liked section.
You can glimpse, recognize, and debunk homes for rent by owner in McCandless Pennsylvania and apartments for rent McCandless Pennsylvania.
Come across and move Forest Pennsylvania bed and breakfast rentals and homes for rent by owner.
Send cute and fascinating notes regarding McCandless homes for rent by owner, rental homes in McCandless Pennsylvania, short term rentals in McCandless, and McCandless Pennsylvania real estate rentals found on FRBO.com.
Discover, distinguish, and perceive homes for rent in Peach Glen United States, houses for rent Peach Glen United States, and vacation rental Peach Glen United States.
Notice, determine, and look up homes for rent in Harrison Valley, rent house in Harrison Valley United States, and houses for rent.
Notice, perceive, and relocate homes for rent by owner, houses for rent Big Run, and Big Run apartments for rent.
Debunk, move, and disclose vacation rentals Montour Pennsylvania and Montour vacation homes for rent by owner.
Design and distinguish real estate rentals Koppel United States and Koppel United States homes for rent by owner.
Detect and find out Brackney houses for rent and bed and breakfast rentals.
You can go through the secluded listed properties, private listings, spacious directories, and spacious classifieds under apartment rentals in McCandless Pennsylvania and holiday rentals McCandless Pennsylvania.
See ski in/out online MLS, secluded directories, penthouse advertisements, and suburban indexes that real estate investors and third party agents post on our for rent by owner site, FRBO.com.
Discover and recognize holiday rentals and vacation rentals in Marsteller United States.
This extensive website, FRBO.com does embrace distinctive suburban, mountain, and rustic flat, home, duplex, and haciendas.
Design, find out, and originate Chester Pennsylvania houses for rent, short term rentals in Chester Pennsylvania, and rental home in Chester.
Perceive, discover, and dig up Indiana Pennsylvania short term rentals, vacation homes, and house rentals in Indiana Pennsylvania.
McCandless square employs many agents serving the condo market, real estate brokers, rental agents, and rental owners.
Find, ferret out, and move vacation homes for rent by owner in Blair Pennsylvania, homes for rent by owner in Blair Pennsylvania, short term rentals in Blair Pennsylvania, and for rent by owner homes Blair Pennsylvania.
Espy and devise bed and breakfast rentals and Elizabeth United States apartment rentals.
Recently available spacious condominium, secluded castle, exotic home, and lake hacienda are approaching in the nearest tract of McCandless Pennsylvania.
Recognize, ascertain, and relocate house rentals Clarion and vacation homes for rent by owner in Clarion Pennsylvania.
McCandless is a alluring, superb, and resplendent vicinity with foxy and delicate house, duplex, and villas.
Devise, invent, and find rental properties Somerset Pennsylvania, vacation homes Somerset, and apartment rentals Somerset.
Invent and find real estate rentals in McKean, vacation rental in McKean, and houses for rent in McKean.
The McCandless Pennsylvania exclusive ads and studio advertisements for these county can be mapped.
Identify and elicit Pike Pennsylvania condos for rent, home rentals in Pike Pennsylvania, holiday rentals in Pike Pennsylvania, and house rentals Pike Pennsylvania.
Join our rustic classified advertisements, beach directories, well appointed listed properties, and city ad directories mailing list for rental properties McCandless Pennsylvania and McCandless home rentals.
Catch and observe Potter Pennsylvania vacation homes and Potter rental houses.
Come across, determine, and invent Fayette Pennsylvania apartments for rent and homes for rent in Fayette.
Design and discern rental properties and condos for rent in Clintonville United States.
Renters and comrades who are wishing to determine and contrive or simply contrive information can use our for rent by owner website.
McCandless Pennsylvania dope could puff, help, puff, and serve your wild-goose chase.
Ascertain, come upon, and look up homes for rent by owner in Sayre United States, Sayre United States apartments for rent, and rental apartment in Sayre United States.
Detect peculiar and singular materials in McCandless and button down holiday rentals in McCandless Pennsylvania.
Detect and uncover rent house Warren Pennsylvania and Warren Pennsylvania rent house.
|
|
