|
<%@ 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 Brighton New York and apartment rentals Brighton
Vacation rentals, condos for rent in Staten Island, and Staten Island New York apartment rentals
Rent houses in North Castle New York, North Castle New York rental houses, North Castle rental homes, and real estate rentals North Castle New York
De Witt holiday rentals and De Witt New York home rentals
Plattsburgh New York houses for rent, homes for rent in Plattsburgh, and Plattsburgh rental homes
Apartment rentals in Tonawanda New York, real estate rentals, homes for rent by owner Tonawanda New York, and rental houses in Tonawanda New York
Homes for rent in Dryden New York and Dryden New York real estate rentals
Clay New York for rent by owner homes, houses for rent Clay New York, and apartment rentals in Clay
Farmington homes for rent by owner, homes for rent by owner Farmington New York, for rent by owner homes, and vacation rentals in Farmington
Rental home in Rye New York and Rye New York rental houses
Rent houses, rental homes, and for rent by owner homes in New Windsor New York
Hyde Park New York rental apartment, bed and breakfast rentals in Hyde Park New York, Hyde Park rent houses, and vacation homes for rent by owner
Carmel New York rent houses and Carmel New York bed and breakfast rentals
Homes for rent by owner Malta New York, Malta New York condos for rent, and Malta home rentals
Rye New York rent house, rental apartment in Rye New York, Rye rental home, and apartments for rent Rye New York
Beacon New York short term rentals and homes for rent by owner in Beacon New York
Rent houses in Sweden, rent house in Sweden, and homes for rent in Sweden New York
Montgomery condos for rent, holiday rentals in Montgomery New York, Montgomery New York rental home, and home rentals in Montgomery New York
Homes for rent in Ossining and Ossining rental homes
Rental home in White Plains New York, for rent by owner homes in White Plains, and White Plains New York real estate rentals
Vacation rental in Geddes New York, short term rentals Geddes, rent houses in Geddes New York, and holiday rentals Geddes
Peekskill condo rentals and Peekskill vacation rental
Condos for rent Union New York, Union New York rental apartment, and homes for rent in Union New York
Short term rentals in Hamburg New York, holiday rentals in Hamburg, Hamburg New York homes for rent by owner, and Hamburg New York rent houses
Scarsdale houses for rent and Scarsdale New York condos for rent
Bath New York rental houses, apartments for rent in Bath New York, and rental houses Bath
Tonawanda New York home rentals, rental home in Tonawanda New York, Tonawanda New York vacation homes for rent by owner, and rent house Tonawanda New York
Rent house Solomons Island, rent houses, vacation homes in Solomons Island Maryland, and home rentals Solomons Island
We imagined, invented, and originated this site, For Rent By Owner (FRBO.com) to be ravishing, ideal, pleasing, and exquisite.
Come upon and light upon condo rentals in Oswego, Oswego New York rental home, and Oswego condos for rent.
Columbia South Carolina house rentals and vacation homes for rent by owner Columbia
Locate and ferret out homes for rent by owner, rental home in Schuyler New York, vacation rental Schuyler, and for rent by owner homes Schuyler New York.
Come upon and find out vacation homes for rent by owner Ransomville United States and Ransomville United States rent house.
Recognize and debunk condos for rent Malone United States and Malone homes for rent.
Kingsbury New York is a elegant, foxy, comely, and sightly precinct with beauteous, shapely, enticing, and well-formed home, townhouse, apartment, and ranchs.
Originate and discern rental home Glenwood Landing and vacation homes in Glenwood Landing United States.
Almost ready to be occupied lakeside cottage, ski in/out cottage, and romantic townhouse are nearest in the convenient state of Kingsbury New York.
You can explore and perceive vacation rental in Kingsbury New York and apartments for rent Kingsbury.
Come across, identify, and uncover rental houses Baldwin United States, bed and breakfast rentals Baldwin, and Baldwin United States vacation homes for rent by owner.
You can search for the studio lists of marked properties, suburban indexes, penthouse ad directories, and exclusive ads under Kingsbury holiday rentals, condo rentals Kingsbury, and for rent by owner homes in Kingsbury New York.
Admit, register, and conscribe tomorrow to get going, tear into, and tear into on this voyage.
Detect, find, and originate condo rentals in Alder Creek United States, rent house in Alder Creek, and vacation rental.
Hear and move West Chazy United States apartment rentals and West Chazy United States rental apartment.
See beachfront online MLS, loft listings, loft indexes, and loft classifieds that property agents and property owners post on this website, FRBO.com.
Perceive, recognize, and detect for rent by owner homes, condo rentals New York New York, and rental apartment.
Explore original and specific brass tacks in Kingsbury New York and enumerate Kingsbury New York houses for rent.
Notice and identify rent houses in Franklin, Franklin New York rental houses, short term rentals in Franklin New York, and vacation homes.
Uncover, identify, and discern apartments for rent in Bethel United States, Bethel vacation rentals, and Bethel rental apartment.
Design, identify, and identify Kings New York condo rentals, Kings New York bed and breakfast rentals, Kings vacation rentals, and vacation rental in Kings New York.
Kingsbury stretch employs many real estate investors, real estate investors, third party listing companies, and property managers.
Uncover, relocate, and explore Onondaga real estate rentals, rent house Onondaga, vacation homes for rent by owner in Onondaga New York, and vacation rental Onondaga New York.
Hear, notice, and find out vacation rental Ulster New York, Ulster New York vacation rentals, and Ulster New York rental home.
Espy and find out rental apartment in Westmoreland and vacation homes for rent by owner.
Determine, perceive, and espy East Elmhurst United States house rentals, rent houses in East Elmhurst United States, and vacation rentals East Elmhurst.
Send elegant, foxy, comely, and sightly notes regarding Kingsbury New York apartments for rent, real estate rentals, and Kingsbury New York real estate rentals found on FRBO.com.
Debunk, discern, and find out holiday rentals in Delaware New York, homes for rent by owner, Delaware bed and breakfast rentals, and vacation homes in Delaware.
The Kingsbury New York classifieds registered and placed on our for rent by owner site, FRBO.com comprise resort duplex, lakefront duplex, ski in/out duplex, and log condominium.
|
|
