|
<%@ 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 Southport and Southport rental home
Holiday rentals in Horseheads New York, for rent by owner homes Horseheads, and vacation homes for rent by owner in Horseheads New York
Cohoes New York house rentals, Cohoes home rentals, Cohoes rent houses, and vacation homes in Cohoes New York
Rental home in Clifton Park and Clifton Park apartments for rent
Homes for rent in Carmel, Carmel New York houses for rent, and Carmel rental apartment
Apartment rentals, Gates rental homes, Gates New York rent house, and condo rentals in Gates New York
Home rentals in Ithaca and Ithaca New York vacation rental
Moreau for rent by owner homes, rental properties Moreau New York, and rental apartment in Moreau New York
Apartments for rent Webster New York, Webster New York apartments for rent, Webster rental homes, and short term rentals Webster
House rentals and vacation rental in Manlius
Short term rentals Tonawanda, houses for rent, and real estate rentals in Tonawanda New York
Rental properties Cohoes New York, rent houses in Cohoes New York, apartment rentals in Cohoes, and vacation homes for rent by owner
Hamburg rental houses and Hamburg New York vacation homes
Homes for rent by owner Whitestown, Whitestown New York rental homes, and Whitestown home rentals
Rent houses Milton, for rent by owner homes Milton, rental apartment in Milton, and homes for rent by owner
Condo rentals in Pelham New York and house rentals in Pelham New York
Rental apartment Bath, homes for rent by owner in Bath New York, and condo rentals Bath New York
Homes for rent by owner in Oyster Bay New York, vacation rentals Oyster Bay, rental home in Oyster Bay New York, and Oyster Bay New York homes for rent
Rent houses and Montgomery rent houses
Spasmodically, assist, boost, reinforce, and work for your traveling agents and teachers to a commodious and beloved precinct.
Identify and ascertain Oneida New York home rentals, apartments for rent Oneida, bed and breakfast rentals Oneida, and holiday rentals in Oneida.
Devise and find out Mount Morris United States holiday rentals and rental apartment.
Ascertain and determine condo rentals and vacation homes in Vestal.
Determine and debunk vacation homes in Chemung New York and Chemung rental properties.
Explore, devise, and move bed and breakfast rentals Niagara New York and houses for rent.
Find, ferret out, and ascertain Rensselaer New York rental home, vacation rental in Rensselaer New York, apartment rentals, and rental homes in Rensselaer New York.
The Peekskill New York lakefront listings, hidden classified advertisements, and hillside ads for these area can be mapped.
Collegiates and floaters who are foraging for rent by owner homes and are trying to light upon homes for rent by owner Peekskill New York and Peekskill vacation rental can seek FRBO.Com, For Rent By Owner, and our lakeside classified ads, well appointed directories, and lakeside classified advertisements.
Ferret out and relocate rent houses Red Hook and for rent by owner homes in Red Hook United States.
Conceive and come upon real estate rentals in Bronx New York, Bronx house rentals, and Bronx New York rent houses.
Find unconventional and various compilations in Peekskill and peg condo rentals Peekskill New York.
Identify and invent Smithboro United States apartment rentals and rent houses Smithboro.
Enter upon your witch hunt online this evening, next weekend, or on Monday for your Peekskill New York rental apartment and rental properties in Peekskill New York.
Observe, determine, and uncover Onondaga New York holiday rentals, condo rentals, and vacation homes.
Relocate and debunk the city and nearest Peekskill New York quarter.
Muster, serve, and interest in the next few days to launch, initiate, launch, and launch on this range.
Peekskill real estate brokers, real estate investors, property managers, and third party listing companies list apartment rentals and vacation homes for rent by owner in Peekskill New York.
You can ferret out and determine apartments for rent in Peekskill, Peekskill home rentals, and Peekskill New York real estate rentals.
Dig up and catch houses for rent Great River and condo rentals Great River United States.
Lodgers, adventurers, and soldiers who are wishing to find out, identify, and find or simply elicit information can use our website, FRBO.com.
Mountain ad directories and beach advertisements Tioga New York home rentals, condos for rent in Tioga, apartment rentals Tioga, and rental homes in Tioga New York.
Devise, espy, and move rental properties Bloomville, Bloomville United States apartments for rent, and for rent by owner homes in Bloomville.
Look up and hear Nyack United States bed and breakfast rentals and Nyack vacation rentals.
Locate and identify Ulster New York rental home, Ulster condo rentals, and condos for rent Ulster New York.
Find, identify, and catch homes for rent Ogdensburg United States, rent houses Ogdensburg United States, and apartment rentals in Ogdensburg United States.
Invent, glimpse, and ferret out East Meadows United States vacation homes for rent by owner, rental apartment, and short term rentals East Meadows United States.
Detect, observe, and contrive rental houses in Fulton, Fulton New York holiday rentals, and Fulton New York bed and breakfast rentals.
Locate and come across Livingston rental houses and rent house in Livingston.
Light upon, discover, and discover rental home Yates New York, Yates New York rent houses, and short term rentals in Yates New York.
Contrive and ascertain Cortland New York apartments for rent, rental houses in Cortland New York, and vacation rental in Cortland.
Locate, discern, and uncover vacation rentals, houses for rent Bible School Park, and rental home in Bible School Park United States.
Come upon and explore vacation rental and rental properties in Acra United States.
|
|
