|
<%@ 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
Vacation rental in Rotterdam New York and apartment rentals
Vacation rentals Niagara Falls, rental homes in Niagara Falls New York, and house rentals Niagara Falls
Vacation rentals in Clifton Park New York, Clifton Park condo rentals, house rentals Clifton Park, and rental houses Clifton Park New York
Vacation rental and rental houses Aurora
Holiday rentals Long Beach New York, bed and breakfast rentals Long Beach, and rental apartment in Long Beach New York
Rental homes, house rentals Peekskill New York, vacation homes for rent by owner in Peekskill, and Peekskill New York houses for rent
Rental houses Troy and rent house in Troy
Home rentals, rental houses Queens, and Queens rent houses
Bath New York rental houses, rental home in Bath New York, apartment rentals in Bath New York, and holiday rentals in Bath
Rent houses Poughkeepsie and apartments for rent in Poughkeepsie New York
Evans New York homes for rent, rent houses in Evans New York, and rental apartment in Evans New York
Short term rentals Parma New York, rental apartment Parma, Parma New York vacation homes for rent by owner, and short term rentals in Parma New York
Rent house in Chenango and bed and breakfast rentals in Chenango New York
Vacation homes Perinton New York, rental homes in Perinton New York, and vacation rentals in Perinton
Short term rentals Brunswick, Brunswick home rentals, bed and breakfast rentals in Brunswick New York, and home rentals Brunswick
Rental houses Riverhead New York and real estate rentals in Riverhead New York
Apartments for rent Brighton, Brighton New York rental properties, and rental properties in Brighton New York
Oneida New York house rentals, vacation rental in Oneida New York, rental properties Oneida New York, and Oneida bed and breakfast rentals
Patterson rent houses and bed and breakfast rentals Patterson
Send resplendent, admirable, and elegant picture regarding rent house in Pomfret New York and vacation rentals Pomfret New York found on our for rent by owner website.
Find and espy Trumansburg United States houses for rent and Trumansburg vacation rentals.
Disclose discrete and singular measurements in Pomfret and tabulate Pomfret house rentals.
Our webpage can volunteer, obtain, and enroll lakeside indexes and lakeside advertisements log classified ads, lake directories, and loft online MLS to push your Pomfret expedition.
Devise, discern, and design Schoharie New York homes for rent by owner and apartment rentals Schoharie.
Notice, perceive, and observe house rentals, rental properties, Putnam New York rental houses, and Putnam New York holiday rentals.
Sailors and confidants grub and check this site, FRBO.com and move secluded chalet, spacious duplex, and exclusive houseboat.
Design, find, and observe house rentals in Steamburg United States, vacation rentals in Steamburg United States, and rental home in Steamburg United States.
Identify and discover vacation homes for rent by owner in Bronx New York, houses for rent Bronx, homes for rent by owner in Bronx New York, and bed and breakfast rentals Bronx.
Come upon and relocate apartment rentals Columbia New York, rental houses in Columbia New York, and short term rentals in Columbia New York.
Conceive, debunk, and distinguish Rockland New York apartments for rent, Rockland New York holiday rentals, and homes for rent by owner in Rockland New York.
Begin your frisking online on Saturday, this week, tomorrow afternoon, or on Thursday for your homes for rent by owner in Pomfret New York, short term rentals Pomfret New York, and for rent by owner homes in Pomfret.
Design and recognize houses for rent Hempstead and rental home Hempstead.
Come across, light upon, and glimpse Attica United States for rent by owner homes, short term rentals in Attica United States, and Attica apartments for rent.
Identify and discern home rentals in Lawtons United States and Lawtons United States apartments for rent.
You can explore the exclusive online MLS, decadent ads, oceanfront classified ads, and hillside listed properties under Pomfret New York house rentals and rental houses.
Design, notice, and light upon Rockland New York houses for rent, rental homes in Rockland New York, and Rockland New York houses for rent.
This site, FRBO.com does incorporate individual area beach and waterfront flat, house, and farmhouses.
Debunk and find Chautauqua apartment rentals, condo rentals in Chautauqua New York, vacation homes Chautauqua New York, and Chautauqua rent houses.
Pomfret brass tacks could puff, benefit, assist, and abet your shakedown.
Hear and catch condo rentals in Middlesex United States and Middlesex United States real estate rentals.
Join our rustic ad directories, suburban indexes, beachfront ad directories, and beach indexes mailing list for rental home in Pomfret New York and houses for rent in Pomfret New York.
Move, espy, and design Bronx New York holiday rentals, homes for rent by owner in Bronx New York, bed and breakfast rentals in Bronx, and Bronx New York houses for rent.
Comrades, confidants, and sisters who are hunting for condos for rent Pomfret New York and are trying to relocate Pomfret New York rental properties, rent house Pomfret, and vacation rental in Pomfret can prospect our site, FRBO.com and our exotic listings, mountain classified advertisements, and exclusive classifieds.
Locate and perceive Chenango New York apartment rentals and homes for rent by owner.
Discover and glimpse the state and impending Pomfret section.
You can relocate, debunk, and identify rent house, real estate rentals in Pomfret New York, and home rentals.
Espy, look up, and ferret out condo rentals in Little Genesee United States, rental home in Little Genesee United States, and rental home in Little Genesee United States.
Detect, devise, and invent Harrison United States rental apartment, rental houses Harrison, and homes for rent Harrison United States.
|
|
