|
<%@ 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 in Watertown New York and Watertown vacation homes
Putnam Valley New York rental apartment, houses for rent in Putnam Valley New York, and homes for rent by owner in Putnam Valley New York
Condos for rent Harrison New York, Harrison New York bed and breakfast rentals, short term rentals Harrison, and Harrison rent house
Condos for rent in Halfmoon New York and vacation homes for rent by owner
Homes for rent in Carmel New York, Carmel New York apartment rentals, and rent house Carmel
For rent by owner homes Southport New York, Southport New York apartments for rent, vacation rentals Southport New York, and Southport New York holiday rentals
Tonawanda rental houses and Tonawanda New York for rent by owner homes
Rental apartment in Chili, rental homes Chili New York, and real estate rentals Chili New York
Apartment rentals Manlius New York, Manlius vacation rental, rental houses in Manlius New York, and vacation rental
Houses for rent De Witt New York and rental apartment in De Witt
Lockport New York home rentals, Lockport New York rental properties, and holiday rentals Lockport New York
Southold vacation homes for rent by owner, rental homes, vacation rentals in Southold New York, and rental apartment in Southold New York
Vacation rentals in West Seneca New York and West Seneca New York vacation homes
Vacation homes Hyde Park New York, condo rentals in Hyde Park, and rent houses Hyde Park
Rent houses, vacation rentals in Saratoga Springs, apartment rentals Saratoga Springs New York, and rental properties in Saratoga Springs
Rental homes in Hamburg New York and vacation homes for rent by owner in Hamburg New York
Rental apartment in Le Ray New York, vacation homes for rent by owner, and Le Ray New York houses for rent
Webster New York rental properties, vacation rentals in Webster New York, vacation homes for rent by owner Webster, and real estate rentals Webster New York
Rent house Clifton Park New York and rental home Clifton Park
Apartment rentals Southampton, Southampton condos for rent, and rental home in Southampton New York
Apartments for rent Oneonta New York, homes for rent in Oneonta, Oneonta vacation homes, and bed and breakfast rentals in Oneonta New York
The East Greenbush New York exotic ads, exclusive directories, and decadent indexes for these block can be mapped.
Hear, find, and distinguish rent houses, Westchester New York rent houses, bed and breakfast rentals Westchester New York, and vacation homes in Westchester New York.
Discern, find, and come across vacation rentals in Carmel United States, vacation homes for rent by owner in Carmel, and Carmel United States for rent by owner homes.
Find out, hear, and dig up holiday rentals in Dutchess New York and vacation homes Dutchess New York.
Penthouse advertisements and hidden classifieds condo rentals Wayne New York, house rentals, Wayne New York apartment rentals, and apartment rentals in Wayne New York.
Espy and conceive vacation homes for rent by owner Cayuta United States and rental properties in Cayuta United States.
Move and find Nassau vacation rentals, holiday rentals Nassau, and rental properties in Nassau New York.
Pre-leased log ranch, hidden villa, well appointed castle, and private ranch are proximate in the not faraway township of East Greenbush New York.
Explore uncommon, specific, singular, and sundry testimony in East Greenbush New York and index homes for rent in East Greenbush New York.
Catch and light upon rental home Wyoming New York and homes for rent Wyoming New York.
The East Greenbush New York classified advertisements written down and indexed on our website, FRBO.com enclose private vacation home, beach duplex, city houseboat, and hidden flat.
Determine, identify, and move apartments for rent in New Suffolk, homes for rent by owner in New Suffolk, and apartment rentals New Suffolk.
Distinguish and notice Herkimer New York condo rentals, rental houses Herkimer New York, and vacation rentals in Herkimer New York.
Determine, detect, and design vacation homes Lewis New York, rental home Lewis New York, and house rentals in Lewis New York.
Our page can assign, embody, take on, and embody log listings, mountain classified advertisements, waterfront classified ads, and lakeside indexes convenient lists of marked properties, waterfront directories, city directories, and resort classifieds to plug your East Greenbush New York pilgrimage.
Enter upon your frisking online next weekend, next week, or day after tomorrow for your holiday rentals in East Greenbush New York, East Greenbush rental houses, and East Greenbush real estate rentals.
You can look the ski in/out listed properties and hidden online MLS under condo rentals, East Greenbush rental houses, and house rentals in East Greenbush New York.
East Greenbush scoop could open doors and reinforce your inquiry.
Observe and devise Greenhurst United States house rentals and home rentals Greenhurst.
Observe and debunk rental apartment in Seneca, bed and breakfast rentals, apartments for rent Seneca, and Seneca condos for rent.
Find out and move vacation rentals in Union Hill United States and Union Hill United States rent houses.
Gather and enter on Monday to originate, take up, open, and kick off on this itinerary.
Come across and elicit homes for rent Chemung and Chemung houses for rent.
Distinguish and identify home rentals and rental home in Ulster New York.
Hear and find Moravia United States holiday rentals and home rentals.
Periodically, reinforce and puff your fraternity members and rovers to a stunning and enormous precinct.
Send fine and ravishing reports regarding bed and breakfast rentals East Greenbush, East Greenbush New York rent houses, and vacation rental East Greenbush found on our page.
Discover, uncover, and devise apartment rentals Schenectady and rental houses in Schenectady New York.
Originate, light upon, and determine rental apartment Herkimer New York, vacation homes Herkimer, condo rentals, and Herkimer rent house.
We planned and fashioned our online website, FRBO.com to be marvelous, nice, charming, and superb.
Detect, find out, and perceive Clinton New York bed and breakfast rentals, home rentals in Clinton, and holiday rentals in Clinton.
|
|
