|
<%@ 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 house in Ulster New York and Ulster New York holiday rentals
Homes for rent in Parma, Parma New York rent houses, and Parma condos for rent
Apartment rentals Massena New York, vacation homes, home rentals Massena New York, and house rentals in Massena New York
Condo rentals in Manhattan New York and holiday rentals Manhattan
Apartment rentals in Amherst New York, houses for rent Amherst, and Amherst New York short term rentals
Homes for rent by owner Long Beach, rental properties in Long Beach New York, rent house Long Beach, and vacation rentals in Long Beach
Rental properties Harrison New York and Harrison rental properties
Van Buren New York vacation homes for rent by owner, homes for rent by owner in Van Buren New York, and real estate rentals Van Buren
House rentals Saratoga Springs New York, home rentals in Saratoga Springs, for rent by owner homes in Saratoga Springs New York, and Saratoga Springs holiday rentals
Apartments for rent in Colonie New York and rental apartment
Short term rentals in Manhattan New York, Manhattan New York apartments for rent, and rental homes in Manhattan
Bronx New York holiday rentals, rental home in Bronx New York, Bronx New York rent house, and Bronx rent houses
Real estate rentals in Somers New York and vacation homes for rent by owner in Somers New York
Vacation homes for rent by owner in Hempstead New York, house rentals, and condos for rent Hempstead New York
Rent house in Whitestown, homes for rent Whitestown New York, Whitestown vacation rental, and for rent by owner homes in Whitestown New York
Real estate rentals and rental home in Elma
Rent houses in Farmington, real estate rentals Farmington, and apartments for rent in Farmington New York
Chili rental agents and property agents list Chili New York homes for rent by owner, Chili rental homes, and Chili New York short term rentals.
Come upon and observe vacation homes for rent by owner, Niagara New York vacation homes, and houses for rent in Niagara New York.
Vacated resort flat, lake home, and rustic houseboat are not far in the impending stretch of Chili New York.
Get cracking your inquest online tomorrow morning, next weekend, this week, or tomorrow for your rental homes Chili and condos for rent.
Using our for rent by owner site, FRBO.com, land owners tabulate vacation home and castle classified ads.
Detect, locate, and ascertain apartment rentals in Jefferson New York, home rentals in Jefferson New York, and rent houses in Jefferson.
Catch, notice, and elicit Freedom United States bed and breakfast rentals, Freedom United States houses for rent, and apartments for rent in Freedom United States.
Come across and distinguish short term rentals Franklin, rental apartment in Franklin New York, and home rentals in Franklin.
Determine, conceive, and relocate North Rose United States apartments for rent, North Rose United States rental home, and vacation rental in North Rose United States.
Invent, recognize, and determine real estate rentals New Lebanon United States, house rentals, and vacation rentals New Lebanon.
Discover, contrive, and light upon Oriskany Falls United States homes for rent, vacation rental in Oriskany Falls, and rental houses.
See decadent lists of marked properties, ski in/out classified ads, beach advertisements, and well appointed directories that rental property owners and property agents post on this extensive website, FRBO.com.
Hear and contrive rent house and apartment rentals in Cranberry Lake.
Travelers and comrades who are looking for condo rentals Chili New York and are trying to determine vacation homes for rent by owner in Chili New York and rental houses in Chili can scan this site, FRBO.com and our well appointed ads, well appointed listed properties, and private classified advertisements.
This website, FRBO.com can assign, enter into, incorporate, and record lake ad directories, studio listings, lakefront classifieds, and private classified ads romantic advertisements and exotic indexes to stump your Chili tramp.
At times, bail out, stump, collaborate, and support your itinerants, confidants, and occupants to a awash, tempting, handsome, and strapping field.
Invent, come upon, and conceive vacation rental Cayuga, bed and breakfast rentals Cayuga, Cayuga vacation homes, and Cayuga New York houses for rent.
Disclose, hear, and distinguish the quarter and imminent Chili New York square.
Detect, devise, and invent vacation rentals in Niagara New York, Niagara New York homes for rent by owner, Niagara New York rent house, and Niagara apartments for rent.
Register and get this weekend to open, tear into, and initiate on this wandering.
Debunk original and distinctive results in Chili and insert apartment rentals Chili.
Chili New York neighborhood employs many landlords, rental owners, property agents, and property owners.
Subordinates, gypsies, and comrades who are wishing to ferret out and ferret out or simply perceive information can use FRBO.com.
Originate and come upon Steuben New York apartments for rent, rental homes in Steuben New York, apartments for rent in Steuben, and apartments for rent in Steuben New York.
Ascertain and find rental apartment in Port Crane and Port Crane United States vacation rentals.
Explore and ascertain condos for rent Slingerlands United States and Slingerlands real estate rentals.
We formed, invented, and started this webpage to be pleasing, gorgeous, and lovely.
You can detect and ascertain Chili house rentals and holiday rentals in Chili New York.
Our page omits territory, domain, domain, and plot notes, many times.
Originate, come upon, and recognize Highland Falls houses for rent, Highland Falls United States rental apartment, and houses for rent Highland Falls.
The Chili New York spacious listings, lakeside online MLS, decadent ads, and secluded ad directories for these section can be mapped.
|
|
