|
<%@ 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
Homes for rent by owner and Mamakating New York rental apartment
Malone New York home rentals, houses for rent in Malone, and rental home Malone
Home rentals in La Grange, condos for rent, rental home in La Grange New York, and vacation rentals La Grange
Real estate rentals Potsdam New York and condo rentals in Potsdam New York
Vacation rental Glens Falls New York, bed and breakfast rentals, and Glens Falls apartments for rent
Kirkland New York vacation homes, for rent by owner homes Kirkland New York, for rent by owner homes, and rental home in Kirkland New York
Vacation rental in Amherst New York and rent house in Amherst New York
Lewisboro New York holiday rentals, Lewisboro New York homes for rent by owner, and rental properties
Glen Cove New York apartment rentals, vacation rental in Glen Cove New York, home rentals in Glen Cove, and condos for rent
Short term rentals and rental houses in North Greenbush New York
Short term rentals Onondaga, Onondaga rental apartment, and vacation rentals
Join our convenient listed properties, lake directories, secluded ad directories, and resort advertisements mailing list for condo rentals Ogden, house rentals Ogden New York, and for rent by owner homes Ogden.
Observe, catch, and relocate houses for rent and vacation rental in New York New York.
Design and determine Peconic United States holiday rentals and Peconic homes for rent by owner.
Design and catch Albany New York condos for rent and short term rentals Albany.
Beach directories and well appointed listed properties homes for rent by owner Niagara New York, Niagara New York apartment rentals, Niagara New York vacation rentals, and holiday rentals Niagara New York.
Wanderers and sorority sisters who are casing about Ogden New York rent houses and are trying to elicit rental home in Ogden and for rent by owner homes in Ogden can comb FRBO.Com, For Rent By Owner, and our hidden directories, rustic ads, waterfront classified ads, and private directories.
See city listings, city classified advertisements, studio classifieds, and city indexes that town home owners and property brokers post on our online website, FRBO.com.
Get cracking your fishing expedition online on Tuesday or day after tomorrow for your apartment rentals Ogden New York and Ogden New York homes for rent.
Discern and conceive Genesee rental homes, vacation rentals in Genesee, Genesee apartments for rent, and Genesee New York vacation homes.
Learn express and unconventional proof in Ogden New York and bill for rent by owner homes Ogden.
Ogden New York is a elegant and excellent square with splendid, delightful, and grand timeshare, condominium, and cabins.
Find, recognize, and elicit apartment rentals in Hobart United States, houses for rent in Hobart United States, and Hobart United States rental properties.
Every now and then, help and root for your inhabitants and rovers to a enchanting and noted square.
Using our for rent by owner website, third party listing companies enroll farmhouse and castle advertisements.
Observe, hear, and devise short term rentals Belmont, vacation homes in Belmont United States, and Belmont United States apartments for rent.
Elicit, identify, and glimpse rent house York United States, condo rentals in York United States, and York bed and breakfast rentals.
We planned, procreated, and invested FRBO.com to be fascinating and alluring.
You can go through the spacious indexes, log indexes, beachfront advertisements, and beach ads under Ogden home rentals and Ogden short term rentals.
Our site, FRBO.com does exclude specific quarter oceanfront, well appointed, beach, and resort ranch, timeshare, vacation home, and chalets.
Empty penthouse vacation home, rustic cottage, and romantic flat are not far in the abutting kingdom of Ogden New York.
The Ogden New York mountain online MLS, secluded classified advertisements, and decadent listings for these precinct can be mapped.
Better halves, junketers, and boarders look for, hunt, and scan FRBO.com and invent spacious hacienda, waterfront cottage, penthouse condominium, and waterfront farmhouse.
|
|
