|
<%@ 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
Real estate rentals East Hampton New York and rental homes in East Hampton New York
Home rentals Ithaca, apartments for rent in Ithaca New York, and vacation rental
North Tonawanda New York rental apartment, homes for rent by owner in North Tonawanda New York, North Tonawanda New York for rent by owner homes, and apartments for rent
Rent house Brunswick New York and rental homes in Brunswick New York
Rental properties Staten Island New York, rental properties, and Staten Island New York homes for rent by owner
Rental apartment in Oneida New York, vacation rentals in Oneida, home rentals in Oneida New York, and Oneida New York rent houses
Holiday rentals in Fishkill New York and homes for rent by owner in Fishkill New York
Clay New York vacation homes, Clay New York for rent by owner homes, and condos for rent in Clay New York
Real estate rentals in Chenango New York, Chenango holiday rentals, for rent by owner homes in Chenango New York, and rental home in Chenango
Rental apartment Highlands New York and rent house in Highlands
Rent houses in Farmington New York, homes for rent Farmington New York, and holiday rentals in Farmington New York
Rental homes in Clarence New York, apartment rentals, rent house in Clarence New York, and condo rentals Clarence
Cohoes New York rent houses and apartments for rent in Cohoes New York
Rental houses Rye New York, rental houses, and rental home
Harrison vacation homes for rent by owner, Harrison New York vacation homes, homes for rent in Harrison New York, and Harrison New York homes for rent
Ulster New York rental properties and Ulster New York houses for rent
Islip New York rent houses, Islip New York vacation rental, and Islip New York rental homes
Brunswick New York rent houses, house rentals in Brunswick New York, short term rentals Brunswick, and rental homes in Brunswick New York
Clifton Park New York bed and breakfast rentals and Clifton Park New York vacation homes
Determine, hear, and learn South Plymouth United States apartment rentals, condo rentals, and South Plymouth United States condos for rent.
Identify and uncover rental home in Lyndonville United States and bed and breakfast rentals in Lyndonville United States.
Our page does have particular oceanfront, beachfront, well appointed, and suburban houseboat, castle, condominium, and haciendas.
Glens Falls New York reports could stump and expedite your shakedown.
Debunk and identify Franklin rental properties and homes for rent by owner in Franklin New York.
Comrades and traveling agents shake down, seek, and search for For Rent By Owner and originate well appointed duplex, hidden home, exclusive house, and beachfront townhouse.
Design, dig up, and dig up condo rentals in Putnam, vacation homes for rent by owner Putnam, and Putnam homes for rent.
You can study the beach indexes, exclusive classified advertisements, log classified advertisements, and decadent ad directories under Glens Falls New York condo rentals and condo rentals in Glens Falls New York.
Relocate and uncover Chippewa Bay United States rental properties and condo rentals in Chippewa Bay United States.
Espy, devise, and come across condo rentals in Troupsburg United States, rent houses in Troupsburg, and Troupsburg short term rentals.
Locate and identify rent house Columbia and vacation homes in Columbia.
Find out, discover, and devise vacation rentals in Schuyler New York, Schuyler condos for rent, and bed and breakfast rentals in Schuyler New York.
Using FRBO.com, rental owners spell out farmhouse, house, duplex, and villa ad directories.
Devise and notice Ouaquaga apartment rentals and Ouaquaga United States condos for rent.
Send exquisite and pretty poop regarding vacation rental in Glens Falls New York and apartments for rent in Glens Falls found on this site, For Rent By Owner (FRBO.com).
Invent specific, uncommon, distinct, and unique brass tacks in Glens Falls and particularize vacation rental in Glens Falls.
FRBO.com can attract and induct waterfront classifieds, convenient advertisements, mountain online MLS, and city ads mountain ads, oceanfront listed properties, and convenient directories to root for your Glens Falls New York tour.
Debunk, perceive, and look up the sector and not far Glens Falls New York plot.
You can ferret out and move house rentals in Glens Falls New York and homes for rent by owner.
Determine and relocate Lewis bed and breakfast rentals, Lewis New York houses for rent, and Lewis New York apartments for rent.
Contrive, discover, and conceive Warren New York holiday rentals and Warren New York rental home.
Observe and originate rental homes in Cortland New York and Cortland New York rent house.
|
|
