|
<%@ 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
Holiday rentals Bronx New York and rental properties Bronx New York
Plattsburgh New York rental apartment, rental homes in Plattsburgh, and for rent by owner homes in Plattsburgh New York
Vacation rentals Buffalo, Buffalo homes for rent by owner, homes for rent in Buffalo, and homes for rent by owner Buffalo New York
Gloversville New York apartment rentals and Gloversville New York house rentals
Rental properties in Watertown New York, apartment rentals in Watertown, and Watertown New York bed and breakfast rentals
De Witt New York short term rentals, De Witt house rentals, vacation rental in De Witt New York, and rent houses De Witt New York
Fallsburg New York rental homes and holiday rentals Fallsburg New York
Lackawanna New York rental home, rental homes in Lackawanna, and vacation rentals in Lackawanna New York
Elmira New York home rentals, vacation rentals in Elmira New York, Elmira homes for rent, and short term rentals in Elmira New York
Holiday rentals and Ithaca New York holiday rentals
Penfield New York for rent by owner homes, real estate rentals Penfield New York, and rent houses Penfield New York
Vacation homes for rent by owner in Utica New York, Utica condo rentals, condo rentals Utica, and Utica vacation rental
Homes for rent by owner Clarence New York and house rentals
Hamburg New York homes for rent by owner, Hamburg New York vacation homes, and condo rentals in Hamburg
Beachfront online MLS and studio ad directories Cayuga New York vacation homes, rent houses Cayuga, Cayuga New York homes for rent, and short term rentals Cayuga New York.
You can catch, disclose, and ferret out Goshen New York real estate rentals and short term rentals in Goshen New York.
Using our website, FRBO.com, property brokers enter duplex, bungalow, flat, and flat classified ads.
Pre-rented log home and romantic timeshare are contiguous in the not to distant field of Goshen New York.
Discern and debunk short term rentals Rock City Falls and Rock City Falls real estate rentals.
Uncover, explore, and discover rental apartment Herkimer New York, bed and breakfast rentals in Herkimer New York, and homes for rent in Herkimer New York.
Goshen New York is a nice, taking, and comely field with handsome, fair, and nice townhouse, apartment, cottage, and lodges.
Originate and devise rental properties in Essex, rent houses Essex, rental homes, and Essex New York rental properties.
Determine and contrive South Dayton United States condo rentals and South Dayton United States holiday rentals.
Come upon, determine, and notice houses for rent in Silver Bay, rental houses in Silver Bay United States, and Silver Bay bed and breakfast rentals.
Open your inspection online on Sunday, day after tomorrow, or in the next few days for your Goshen bed and breakfast rentals, houses for rent, and real estate rentals in Goshen New York.
Sorority sisters, ramblers, and rent payers who are wishing to discern and move or simply conceive information can use our site, FRBO.com.
Contrive, espy, and ferret out St. Lawrence New York bed and breakfast rentals and rental home St. Lawrence.
Discern, detect, and determine Skaneateles Falls real estate rentals, vacation homes, and homes for rent by owner in Skaneateles Falls.
Observe and identify vacation homes for rent by owner and Wayne New York condos for rent.
Goshen score could benefit, sustain, help, and relieve your examination.
Pirates and coeds check, frisk, and cast about our for rent by owner site, FRBO.com and perceive ski in/out townhouse, mountain houseboat, spacious cottage, and exclusive cottage.
Espy and notice rental properties Clinton New York and for rent by owner homes in Clinton.
Invent peculiar, extraordinary, and something else dossier in Goshen and inventory houses for rent in Goshen.
See ski in/out lists of marked properties, penthouse ad directories, and loft listed properties that agents and property brokers post on FRBO.Com, For Rent By Owner,.
Ferret out and catch vacation homes for rent by owner in Essex New York and rental properties.
Notice and invent Chautauqua New York rental homes, vacation homes for rent by owner in Chautauqua New York, and Chautauqua New York holiday rentals.
Invent, perceive, and explore vacation rentals in Leicester United States, homes for rent in Leicester, and Leicester United States rental home.
The Goshen indexes catalogued and manifested on our website, FRBO.com subsume suburban condominium, oceanfront houseboat, exotic chalet, and resort duplex.
Come across, learn, and notice homes for rent by owner in Washington New York, Washington real estate rentals, house rentals in Washington New York, and real estate rentals in Washington New York.
Catch, find, and ascertain real estate rentals Livingston New York and Livingston house rentals.
|
|
