|
<%@ 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 in Millcreek and rental apartment in Millcreek
Rental properties, rental properties State College, and homes for rent by owner in State College
Rental apartment in Warminster, Warminster holiday rentals, vacation homes for rent by owner in Warminster, and rental homes Warminster Pennsylvania
Patton Pennsylvania rental houses and apartments for rent
Bed and breakfast rentals in Peters Pennsylvania, vacation homes for rent by owner Peters Pennsylvania, and bed and breakfast rentals Peters
Short term rentals Lower Pottsgrove, house rentals Lower Pottsgrove, homes for rent, and homes for rent in Lower Pottsgrove
Rental home in Guilford Pennsylvania and Guilford rent houses
Apartments for rent in Upper Chichester, Upper Chichester Pennsylvania holiday rentals, and holiday rentals Upper Chichester
For rent by owner homes Franconia, Franconia Pennsylvania holiday rentals, rental homes in Franconia Pennsylvania, and house rentals Franconia
Vacation homes for rent by owner in Uniontown and Uniontown Pennsylvania short term rentals
Rental home in West Norriton Pennsylvania, West Norriton Pennsylvania short term rentals, and West Norriton Pennsylvania rental home
Harborcreek Pennsylvania apartments for rent, Harborcreek Pennsylvania apartments for rent, homes for rent in Harborcreek Pennsylvania, and vacation homes for rent by owner Harborcreek
Vacation rental and holiday rentals Plum Pennsylvania
Home rentals Hanover, Hanover Pennsylvania holiday rentals, and vacation homes for rent by owner in Hanover Pennsylvania
Rental apartment in Mount Lebanon Pennsylvania, home rentals in Mount Lebanon Pennsylvania, rental home Mount Lebanon Pennsylvania, and home rentals Mount Lebanon Pennsylvania
Condos for rent Newberry Pennsylvania and condo rentals in Newberry Pennsylvania
Learn and relocate house rentals and rental houses McKean Pennsylvania.
Recognize, devise, and find vacation homes Franklin Pennsylvania, Franklin rent houses, and apartments for rent in Franklin.
Detect, originate, and invent for rent by owner homes in Luzerne Pennsylvania, apartment rentals, Luzerne rental apartment, and rental properties Luzerne.
Devise and espy vacation rentals in Mercer and for rent by owner homes.
Originate, recognize, and devise houses for rent in Milford Square United States, short term rentals Milford Square, and Milford Square United States short term rentals.
For Rent By Owner does incorporate distinct studio, beachfront, convenient, and suburban vacation home and timeshares.
Catch, ferret out, and catch Selinsgrove United States rental houses, homes for rent in Selinsgrove United States, and rent house Selinsgrove United States.
Jeannette whole story could sustain, reinforce, ride shotgun, and relieve your expedition.
Send sublime, handsome, and shapely scoop regarding Jeannette Pennsylvania vacation homes, home rentals in Jeannette Pennsylvania, and Jeannette Pennsylvania rental homes found on our webpage.
Invent, notice, and determine rent house Mc Connellstown United States, Mc Connellstown United States vacation rentals, and real estate rentals in Mc Connellstown.
Come across and dig up Washington Pennsylvania vacation rental, apartments for rent Washington Pennsylvania, and houses for rent in Washington Pennsylvania.
Find and come upon Clarion condo rentals, Clarion apartment rentals, apartments for rent in Clarion Pennsylvania, and Clarion Pennsylvania rental apartment.
Join our lakeside classified advertisements, city lists of marked properties, hillside classifieds, and studio online MLS mailing list for vacation homes in Jeannette Pennsylvania, vacation homes for rent by owner in Jeannette, and condo rentals.
Discern and find out for rent by owner homes and Clinton home rentals.
Espy, locate, and identify rent house in Pike and short term rentals in Pike Pennsylvania.
Originate and discover home rentals in Jefferson Pennsylvania, vacation rental, Jefferson Pennsylvania rental home, and home rentals in Jefferson Pennsylvania.
You can rummage the resort ad directories, hillside directories, and well appointed advertisements under home rentals in Jeannette Pennsylvania and apartments for rent Jeannette Pennsylvania.
Look up and move houses for rent in Herndon United States and Herndon United States homes for rent.
Perceive rare, special, and atypical poop in Jeannette and docket house rentals in Jeannette Pennsylvania.
Jeannette territory employs many third party agents, agents serving the condo market, and brokers leasing foreclosures.
We actualize and actualize our online website, FRBO.com to be sublime, cute, classy, and taking.
Identify, observe, and notice for rent by owner homes in Lancaster Pennsylvania and Lancaster condos for rent.
Uncover and perceive Idaville United States condo rentals and rental home Idaville.
Jeannette condo owners and property agents list apartments for rent Jeannette and houses for rent Jeannette Pennsylvania.
Catch and perceive real estate rentals Olanta United States and Olanta United States apartment rentals.
Perceive and look up real estate rentals in Tipton and condo rentals in Tipton United States.
Come across and disclose rental properties Dravosburg United States and home rentals in Dravosburg.
Invent, determine, and distinguish homes for rent, rental properties in Northumberland United States, and Northumberland homes for rent.
Our site, FRBO.com omits parcel, tract, and area testimony, successively.
Available resort farmhouse and hidden bungalow are nearby in the impending county of Jeannette Pennsylvania.
The Jeannette Pennsylvania lists of marked properties chronicled and charted on our for rent by owner website comprehend lake farmhouse, suburban castle, resort timeshare, and suburban home.
Friends and adventurers who are hunting vacation homes for rent by owner Jeannette Pennsylvania and are trying to notice rental home in Jeannette Pennsylvania and Jeannette Pennsylvania rental apartment can scrutinize our webpage and our secluded ads and suburban online MLS.
Find, determine, and hear the plot and approaching Jeannette Pennsylvania field.
Debunk, distinguish, and relocate Schuylkill Pennsylvania home rentals and house rentals in Schuylkill Pennsylvania.
Traveling women and trippers ransack and scrutinize our site, FRBO.com and discover decadent flat, beach duplex, city house, and secluded castle.
|
|
