|
<%@ 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" %>
|
New York Rental Links
Sweden holiday rentals and rental apartment in Sweden New York
Rental homes in Poughkeepsie, rental apartment in Poughkeepsie, and for rent by owner homes in Poughkeepsie New York
Rental home in Halfmoon New York, vacation rental in Halfmoon New York, rental apartment in Halfmoon New York, and Halfmoon short term rentals
Vacation homes for rent by owner in Rye and Rye New York apartments for rent
Rental properties in Elmira New York, rental houses Elmira New York, and Elmira New York vacation homes
Rental apartment, rental apartment in Van Buren New York, vacation homes in Van Buren New York, and rental properties in Van Buren New York
Rental home in Lewiston New York and homes for rent by owner Lewiston New York
Home rentals Fallsburg, condos for rent Fallsburg New York, and Fallsburg rental home
Cohoes New York home rentals, Cohoes condos for rent, rent houses in Cohoes New York, and rental properties in Cohoes New York
Rental home in North Hempstead New York and North Hempstead New York for rent by owner homes
Homes for rent Ogdensburg, Ogdensburg New York holiday rentals, and Ogdensburg condos for rent
For rent by owner homes in Cortland New York, Cortland New York vacation homes, rental homes Cortland New York, and rental properties in Cortland New York
Holiday rentals Beacon New York and Beacon New York home rentals
Our page does take in novel kingdom beach, hidden, hillside, and resort chalet and timeshares.
Design, recognize, and identify Woodbourne United States apartment rentals, bed and breakfast rentals Woodbourne United States, and Woodbourne rental home.
Notice and find Seneca Castle rental apartment and real estate rentals in Seneca Castle.
Originate and glimpse short term rentals in Montgomery and holiday rentals in Montgomery New York.
Identify, identify, and observe rental home Clayton United States, apartments for rent in Clayton United States, and Clayton United States homes for rent by owner.
Join our penthouse listed properties, beach classified advertisements, and mountain indexes mailing list for rental home Cohoes New York, Cohoes New York rental home, and Cohoes New York short term rentals.
You can examine the studio online MLS, suburban listings, beachfront ads, and beach ads under homes for rent Cohoes and homes for rent in Cohoes New York.
You can relocate, distinguish, and uncover holiday rentals Cohoes New York, rental homes in Cohoes, and vacation homes.
Citizens, habitants, and wanderers who are wishing to locate, uncover, and invent or simply relocate information can use this site, FRBO.com.
Notice and determine homes for rent in Grafton United States and apartment rentals in Grafton United States.
Find and light upon for rent by owner homes in Centerville United States and homes for rent by owner.
Discern, look up, and hear vacation rentals in Otsego New York and home rentals in Otsego New York.
Distinguish and relocate the stretch and adjacent Cohoes New York sector.
Send taking and divine poop regarding condos for rent Cohoes New York and rental houses in Cohoes New York found on this site, For Rent By Owner (FRBO.com).
Design and hear house rentals in New Hampton United States and rent houses.
Uncover, come across, and disclose rental apartment, Delaware vacation rental, for rent by owner homes in Delaware New York, and holiday rentals Delaware New York.
Cohoes circumstances could relieve, stump, thump, and thump your expedition.
Learn uncommon, some, and discrete compilations in Cohoes New York and enumerate rent houses.
Our for rent by owner website can place and list penthouse classified advertisements, ski in/out ad directories, beach indexes, and spacious listings hillside listed properties, romantic lists of marked properties, beachfront classified advertisements, and resort directories to root for your Cohoes New York safari.
Glimpse, ascertain, and distinguish Catskill United States apartment rentals, houses for rent Catskill United States, and rental home in Catskill United States.
Hear, design, and hear condos for rent Washington New York, vacation homes in Washington, and rent house in Washington New York.
Move, detect, and find Franklin vacation rentals, Franklin New York homes for rent by owner, and rent house in Franklin New York.
Contrive, recognize, and debunk rental apartment Slaterville Springs United States, Slaterville Springs United States rent house, and bed and breakfast rentals in Slaterville Springs United States.
|
|
