|
<%@ 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
Rental properties in Rotterdam and houses for rent in Rotterdam New York
Rental homes Auburn New York, Auburn real estate rentals, and rental houses in Auburn
Houses for rent, Utica New York real estate rentals, apartments for rent, and real estate rentals Utica
Holiday rentals in Plattsburgh and apartments for rent
Rental home in Hempstead New York, Hempstead New York homes for rent, and rental apartment Hempstead
Vacation rental in Le Ray New York, Le Ray New York houses for rent, rental apartment Le Ray, and Le Ray New York home rentals
Rental houses in Manhattan New York and vacation homes for rent by owner Manhattan New York
Real estate rentals in Amherst, rental homes, and homes for rent by owner in Amherst New York
New Hartford New York home rentals, condos for rent in New Hartford New York, bed and breakfast rentals New Hartford New York, and short term rentals New Hartford
Rent house in Tonawanda and homes for rent in Tonawanda New York
Bed and breakfast rentals Long Beach, rental homes in Long Beach, and Long Beach New York homes for rent by owner
Rental home in Olean, Olean rent house, real estate rentals Olean New York, and Olean New York rental houses
Rental home Kingston New York and homes for rent in Kingston New York
House rentals, Newburgh New York vacation rental, and apartment rentals
Condo rentals in Saratoga Springs, bed and breakfast rentals in Saratoga Springs New York, vacation rental Saratoga Springs New York, and rent houses in Saratoga Springs New York
Chenango apartment rentals and homes for rent in Chenango New York
Orangetown vacation rentals, home rentals Orangetown, and Orangetown apartments for rent
Homes for rent by owner in Rotterdam New York, holiday rentals in Rotterdam New York, house rentals, and bed and breakfast rentals in Rotterdam New York
Homes for rent Olean New York and Olean New York rental properties
Rent house in Whitestown, rental home Whitestown New York, and Whitestown New York homes for rent by owner
Originate, ascertain, and espy vacation rental in Warnerville United States, rent house in Warnerville, and apartments for rent in Warnerville United States.
Pittsford New York section employs many property brokers, rental agents, agents, and real estate agents.
The Pittsford New York mountain advertisements, city classifieds, beach lists of marked properties, and secluded classifieds for these can be mapped.
Invent and catch bed and breakfast rentals Orange, Orange New York bed and breakfast rentals, for rent by owner homes Orange New York, and Orange New York rental properties.
Hikers and townies who are wishing to look up and observe or simply originate information can use our site, FRBO.com.
Pittsford New York documents could back and open doors your pursuing.
Detect, explore, and debunk homes for rent in Amawalk United States, bed and breakfast rentals Amawalk United States, and homes for rent.
We occasioned and fabricated our for rent by owner site, FRBO.com to be nice, symmetrical, taking, and enticing.
Design and identify rental apartment Bridgewater United States and Bridgewater United States condos for rent.
Enter upon your pursuance online now, on Saturday, this evening, or next weekend for your Pittsford New York home rentals, Pittsford vacation rentals, and vacation homes for rent by owner in Pittsford New York.
Secluded classified ads and spacious classified advertisements condos for rent, vacation rentals, home rentals in Schuyler, and rental home.
Explore and come upon Putnam New York holiday rentals and short term rentals in Putnam.
Ferret out, uncover, and relocate vacation rentals Ulster and rent house in Ulster.
Elicit and learn apartments for rent in Jefferson New York and homes for rent in Jefferson.
Pittsford is a appealing and fair section with bewitching and graceful cottage and timeshares.
Determine, come across, and dig up homes for rent by owner in Rush, real estate rentals in Rush, and real estate rentals in Rush United States.
Find, explore, and discern apartment rentals and rent houses Allegany New York.
Roomers, traveling agents, and traveling sales representatives investigate and run down this extensive website, FRBO.com and notice exotic townhouse, well appointed cabin, ski in/out home, and beach house.
Detect, come across, and uncover holiday rentals in Schuyler, homes for rent, Schuyler New York house rentals, and apartment rentals.
Discern, ferret out, and move rental home, rental apartment Montgomery New York, and Montgomery rental properties.
Obtain and enter into in the next few days to initiate, enter upon, get going, and begin on this drive.
Coeds, grooms, and adventurers who are rummaging apartment rentals Pittsford and are trying to detect short term rentals in Pittsford New York and condo rentals Pittsford New York can hunt for this extensive website, FRBO.com and our decadent classified ads, hidden classified advertisements, secluded listings, and well appointed online MLS.
Ascertain, determine, and identify condos for rent, Brownville United States home rentals, and rental properties Brownville United States.
Send pretty, divine, and angelic dope regarding for rent by owner homes Pittsford New York, Pittsford house rentals, condos for rent Pittsford New York, and Pittsford New York rental properties found on this website, FRBO.com.
Pittsford town home owners and brokers leasing foreclosures list bed and breakfast rentals in Pittsford New York, rental homes Pittsford New York, and condo rentals Pittsford New York.
Invent, uncover, and design rental houses Coxsackie United States, Coxsackie United States rent house, and Coxsackie United States rent house.
Ferret out, relocate, and perceive rental homes in Saint Albans United States, homes for rent by owner Saint Albans United States, and rental home in Saint Albans.
Catch, perceive, and design Syosset United States rent house, rental home, and rental apartment in Syosset United States.
|
|
