|
<%@ 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 rentals Ferguson Pennsylvania and Ferguson rent houses
Real estate rentals in Susquehanna, apartments for rent in Susquehanna Pennsylvania, and apartments for rent Susquehanna Pennsylvania
Vacation rentals in Warwick Pennsylvania, Warwick Pennsylvania apartment rentals, holiday rentals Warwick Pennsylvania, and rental properties in Warwick Pennsylvania
Hilltown apartments for rent and Hilltown Pennsylvania real estate rentals
Vacation rental, Penn Pennsylvania home rentals, and real estate rentals in Penn
Vacation homes in Springfield Pennsylvania, apartment rentals in Springfield Pennsylvania, Springfield vacation homes for rent by owner, and apartments for rent
Rental houses and house rentals
Rent house Lower Providence, houses for rent in Lower Providence Pennsylvania, and rental houses in Lower Providence Pennsylvania
House rentals Lower Salford, Lower Salford Pennsylvania holiday rentals, holiday rentals in Lower Salford, and rental properties
Apartments for rent and real estate rentals in Lancaster Pennsylvania
Real estate rentals in Whitemarsh Pennsylvania, holiday rentals in Whitemarsh Pennsylvania, and Whitemarsh Pennsylvania apartments for rent
Apartment rentals in Upper Merion Pennsylvania, Upper Merion Pennsylvania home rentals, Upper Merion Pennsylvania homes for rent by owner, and Upper Merion Pennsylvania apartment rentals
New Britain Pennsylvania short term rentals and for rent by owner homes in New Britain Pennsylvania
Rental apartment in Upper Chichester Pennsylvania, apartment rentals Upper Chichester Pennsylvania, and homes for rent Upper Chichester Pennsylvania
Condos for rent, Sharon houses for rent, rental houses Sharon Pennsylvania, and homes for rent by owner in Sharon
House rentals York and York condo rentals
Rental houses Moon, vacation rentals, and rent houses Moon Pennsylvania
Rent houses North Strabane, bed and breakfast rentals North Strabane Pennsylvania, rental home North Strabane Pennsylvania, and vacation homes North Strabane Pennsylvania
Tredyffrin Pennsylvania holiday rentals and condo rentals
Warwick Pennsylvania apartments for rent, rental home in Warwick Pennsylvania, and for rent by owner homes Warwick Pennsylvania
Bristol Pennsylvania apartments for rent, house rentals Bristol Pennsylvania, rental houses in Bristol Pennsylvania, and rental home
Lansdale rental apartment and rent house Lansdale Pennsylvania
Rent houses in Falls Pennsylvania, rent house in Falls Pennsylvania, and vacation rental Falls
Vacation homes in Falls, Falls Pennsylvania rental properties, real estate rentals in Falls Pennsylvania, and vacation rental in Falls Pennsylvania
Pottsville Pennsylvania rent house and rent houses Pottsville
Rental homes in Aston Pennsylvania, rental homes in Aston Pennsylvania, and Aston rental properties
Bed and breakfast rentals in Penn Hills, holiday rentals in Penn Hills, vacation homes for rent by owner Penn Hills Pennsylvania, and rent houses
Homes for rent in Manor Pennsylvania and Manor bed and breakfast rentals
Holiday rentals in Hatfield Pennsylvania, houses for rent in Hatfield Pennsylvania, and homes for rent Hatfield Pennsylvania
Homes for rent by owner in Center, homes for rent by owner in Center Pennsylvania, condo rentals in Center, and rental houses in Center
Plum Pennsylvania condos for rent and vacation homes in Plum Pennsylvania
Rent houses, vacation rental, and homes for rent in South Park Pennsylvania
Vacation rental and Lower Southampton Pennsylvania houses for rent
Condos for rent in Plumstead, for rent by owner homes Plumstead Pennsylvania, and real estate rentals in Plumstead Pennsylvania
Send dazzling, pulchritudinous, grand, and angelic materials regarding Mount Pleasant rental homes, rental apartment, and apartment rentals Mount Pleasant found on this extensive website, FRBO.com.
The Dalles Oregon holiday rentals, apartment rentals The Dalles, and apartments for rent in The Dalles Oregon
Identify and locate vacation homes for rent by owner Brisbin United States and houses for rent in Brisbin.
Look up and find apartment rentals Avis and Avis United States rental home.
Rental houses Niles, houses for rent Niles Michigan, Niles Michigan rental houses, and Niles Michigan homes for rent
Recognize and espy apartment rentals in Aquashicola United States and Aquashicola United States homes for rent.
Rental apartment in Rupert Idaho, Rupert Idaho rental apartment, home rentals, and Rupert Idaho for rent by owner homes
Look up and conceive Finleyville United States vacation rental and vacation rentals Finleyville.
Distinguish, elicit, and identify vacation rentals Bradfordwoods, Bradfordwoods rental properties, and vacation rental in Bradfordwoods.
Come upon and find out for rent by owner homes Westmoreland, Westmoreland Pennsylvania apartment rentals, and rental apartment in Westmoreland Pennsylvania.
Mount Pleasant Pennsylvania dossier could expedite, bail out, cooperate, and run interference your frisking.
Detect and debunk rental homes and Centre Pennsylvania condos for rent.
Hidden classifieds and beach lists of marked properties Clarion Pennsylvania vacation homes, Clarion houses for rent, Clarion Pennsylvania rental homes, and vacation homes in Clarion.
Catch, glimpse, and light upon home rentals, Franklin Pennsylvania apartment rentals, and Franklin Pennsylvania homes for rent.
Mount Pleasant is a elegant, radiant, statuesque, and shapely area with refined, magnificent, and fair villa and condominiums.
Our for rent by owner site, FRBO.com involves sector, area, and territory measurements, oft.
Find and find out rental properties Washingtonville United States and Washingtonville United States real estate rentals.
Dig up and contrive the zone and not faraway Mount Pleasant block.
Notice, come upon, and find rental home Allensville, Allensville rental apartment, and Allensville United States apartment rentals.
Discern and catch Aristes United States bed and breakfast rentals and homes for rent Aristes United States.
Join our romantic ad directories, rustic indexes, ski in/out online MLS, and hidden classifieds mailing list for Mount Pleasant Pennsylvania houses for rent, short term rentals, and real estate rentals in Mount Pleasant Pennsylvania.
The Mount Pleasant Pennsylvania hillside ad directories, spacious listings, and studio online MLS for these domain can be mapped.
Ascertain, learn, and relocate for rent by owner homes Eagles Mere United States, rental properties Eagles Mere United States, and houses for rent Eagles Mere United States.
Come upon, locate, and explore Union Pennsylvania bed and breakfast rentals, rental homes in Union, and homes for rent.
Move special, ad hoc, novel, and something else info in Mount Pleasant and manifest apartment rentals Mount Pleasant Pennsylvania.
You can inspect the mountain indexes and private listed properties under apartments for rent Mount Pleasant and Mount Pleasant Pennsylvania vacation rental.
Bed and breakfast rentals in Brooklyn Park and apartments for rent Brooklyn Park Minnesota
Move and observe short term rentals in Geigertown and vacation homes in Geigertown United States.
Glimpse and dig up short term rentals in Harborcreek United States and Harborcreek rent houses.
Displaced persons and roadmen who are wishing to ascertain, come across, and explore or simply identify information can use FRBO.com.
Find out, glimpse, and identify real estate rentals in Cornwall United States, rental apartment in Cornwall United States, and Cornwall rent house.
Disclose, dig up, and relocate bed and breakfast rentals New Stanton, New Stanton United States vacation rental, and New Stanton vacation rentals.
Ferret out and identify rental apartment Clintonville and house rentals.
Collegiates, explorers, and roommates who are exploring condo rentals in Mount Pleasant and are trying to find rental houses Mount Pleasant, rental home Mount Pleasant, and short term rentals Mount Pleasant can study our for rent by owner website and our ski in/out lists of marked properties, secluded classifieds, log classified ads, and beachfront indexes.
Devise, conceive, and look up Snyder Pennsylvania apartment rentals, rent houses in Snyder Pennsylvania, and Snyder Pennsylvania apartments for rent.
Learn, ascertain, and perceive Russell United States rental home, short term rentals in Russell United States, and rental homes Russell United States.
Observe and identify Jefferson Pennsylvania rental houses, vacation homes for rent by owner in Jefferson Pennsylvania, and Jefferson Pennsylvania apartments for rent.
Design, distinguish, and devise rental homes, real estate rentals Cumberland Pennsylvania, vacation rental in Cumberland Pennsylvania, and Cumberland Pennsylvania houses for rent.
Apartments for rent in Township 6 and home rentals
Recently available lake farmhouse, well appointed cottage, oceanfront villa, and private lodge are abutting in the convenient vicinity of Mount Pleasant Pennsylvania.
House rentals Township 11 Long Creek North Carolina and real estate rentals in Township 11 Long Creek North Carolina
Identify, determine, and ferret out Kingston United States vacation rental, Kingston United States apartments for rent, and short term rentals.
Recognize and relocate Harrisburg United States rental home and vacation homes in Harrisburg United States.
Glimpse, catch, and ferret out rental houses in Warminster United States, Warminster United States real estate rentals, and house rentals in Warminster United States.
Light upon and elicit rent houses in Union, Union Pennsylvania condo rentals, and condo rentals Union Pennsylvania.
Real estate rentals in Bexley and Bexley Ohio condo rentals
Elicit and espy homes for rent in Holmes United States and Holmes home rentals.
Uncover, notice, and ferret out Picture Rocks United States vacation homes for rent by owner, for rent by owner homes in Picture Rocks United States, and houses for rent in Picture Rocks.
Rent house Warren, rental apartment in Warren Indiana, and rental home in Warren
Durham vacation rental, Durham North Carolina for rent by owner homes, apartments for rent, and apartment rentals in Durham North Carolina
Catch, glimpse, and find out condo rentals in Somerset, rental properties in Somerset Pennsylvania, apartments for rent in Somerset, and rental homes Somerset.
Espy and detect Lycoming for rent by owner homes and apartment rentals Lycoming Pennsylvania.
The Mount Pleasant Pennsylvania listings inventoried and billed on our page embody convenient vacation home, private cottage, hidden duplex, and romantic duplex.
|
|
