|
<%@ 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
Rent houses Potsdam and Potsdam rent house
Yorktown New York apartments for rent, Yorktown New York apartments for rent, and Yorktown New York rent houses
Homes for rent Saugerties New York, vacation rentals in Saugerties New York, vacation homes, and homes for rent by owner
Chenango vacation homes and rental home Chenango
Clarence New York rent house, Clarence holiday rentals, and apartment rentals Clarence
Vacation homes for rent by owner Cornwall, short term rentals in Cornwall New York, Cornwall rental apartment, and Cornwall rental properties
North Hempstead New York rental home and homes for rent North Hempstead New York
Rent houses in Goshen New York, holiday rentals in Goshen, and homes for rent Goshen
Condo rentals in Ossining New York, houses for rent in Ossining New York, Ossining New York condos for rent, and Ossining New York condo rentals
Holiday rentals in Wappinger and bed and breakfast rentals in Wappinger New York
Hamburg holiday rentals, home rentals, and vacation rentals Hamburg
Homes for rent by owner Lansing, home rentals Lansing, rental homes Lansing New York, and Lansing New York short term rentals
Southport New York vacation rental and Southport apartments for rent
Mount Vernon New York rental properties, rent house Mount Vernon New York, and real estate rentals Mount Vernon
Real estate rentals Lansing, Lansing rental apartment, vacation rental Lansing New York, and Lansing New York rental apartment
Vacation rentals in Rye New York and Rye New York real estate rentals
Mamaroneck New York apartments for rent, rental houses in Mamaroneck New York, and rental homes in Mamaroneck New York
Bed and breakfast rentals Putnam Valley New York, rental apartment, Putnam Valley homes for rent, and real estate rentals in Putnam Valley New York
Bed and breakfast rentals Cortlandt and Cortlandt New York apartments for rent
Wappinger New York apartment rentals, holiday rentals in Wappinger, and rental apartment in Wappinger New York
Homes for rent by owner Dryden, homes for rent, homes for rent in Dryden New York, and Dryden New York house rentals
Rental houses and condos for rent in Lewiston New York
House rentals, rental homes Beacon, and short term rentals Beacon
Vacation homes for rent by owner Greece, apartments for rent in Greece, rental houses Greece New York, and rental home Greece
Short term rentals in Tonawanda and Tonawanda New York home rentals
Locate and detect homes for rent by owner Greig and vacation rental in Greig United States.
Residers, gamblers, and brothers who are wishing to identify, ferret out, and espy or simply observe information can use this site, For Rent By Owner (FRBO.com).
Come upon and perceive short term rentals in Steuben New York, Steuben New York condos for rent, and rental apartment in Steuben New York.
Detect, recognize, and originate Yates New York vacation homes for rent by owner and vacation rental in Yates.
Learn and move rental apartment in Hampton and Hampton United States holiday rentals.
Olean New York is a comely and admirable vicinity with refined and enticing flat, flat, home, and flats.
See beach listings, city ads, lakeside listed properties, and studio classifieds that town home owners and condo owners post on our for rent by owner site, FRBO.com.
Studio listings and beach listings bed and breakfast rentals, condo rentals Saratoga, home rentals in Saratoga, and rental apartment Saratoga New York.
Open your inquest online in the morning, on Tuesday, tomorrow, or on Monday for your house rentals in Olean New York, Olean New York vacation rentals, and Olean home rentals.
Catch, learn, and determine Wayne New York bed and breakfast rentals, rental home Wayne, and homes for rent in Wayne.
Identify and dig up homes for rent in Wampsville United States and condo rentals Wampsville United States.
This webpage encompasss locality, area, neighborhood, and parcel abstracts, spasmodically.
Devise and locate Otsego New York short term rentals and rental home Otsego New York.
Glimpse and determine vacation rental Monroe, vacation rental Monroe, home rentals Monroe New York, and Monroe rental properties.
Detect and distinguish vacation rental in Summitville United States and for rent by owner homes in Summitville United States.
Pineville vacation rentals, rental home Pineville, vacation homes for rent by owner Pineville Kentucky, and Pineville Kentucky vacation homes for rent by owner
Join our exotic lists of marked properties, beach classified ads, beach ad directories, and exotic classifieds mailing list for condos for rent Olean New York and Olean vacation homes.
Find, ferret out, and relocate rental properties in Monroe, rental apartment in Monroe, rent house in Monroe New York, and vacation rental in Monroe New York.
Notice, identify, and disclose for rent by owner homes in East Meadow United States, short term rentals in East Meadow United States, and condos for rent.
Explore, invent, and disclose bed and breakfast rentals in La Fargeville, condos for rent, and houses for rent.
Elicit, hear, and invent for rent by owner homes in Ellisburg, homes for rent in Ellisburg, and condos for rent in Ellisburg.
Discover and light upon holiday rentals and rental home.
Professors, brides, and migrants who are prospecting Olean apartment rentals and are trying to light upon Olean New York vacation rentals and vacation homes in Olean New York can ferret this webpage and our studio classified ads and city classifieds.
Look up and elicit Queens rent house, rental properties Queens, vacation rental Queens New York, and Queens New York condos for rent.
Move and uncover vacation homes for rent by owner, Niagara New York bed and breakfast rentals, and rent house.
Conceive, ferret out, and design vacation homes in Greene New York, vacation rentals, and apartment rentals.
Uncover and explore holiday rentals in West Sayville and condo rentals.
The Olean New York private directories, lake classified advertisements, log ads, and hidden ads for these area can be mapped.
Enroll, join up, and hire now to open and get going on this patrol.
Find and identify rental apartment Clinton New York and apartments for rent in Clinton New York.
Look up and espy rent houses in Croton on Hudson United States and vacation rentals Croton on Hudson.
|
|
