|
<%@ 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
Riverhead bed and breakfast rentals and holiday rentals in Riverhead New York
Vacation rental Union New York, apartment rentals in Union New York, and rental properties Union
Houses for rent in Lewiston New York, Lewiston New York rental houses, rental houses Lewiston, and Lewiston New York rent houses
Rental houses in Cicero New York and holiday rentals in Cicero New York
Houses for rent Tonawanda New York, Tonawanda vacation homes for rent by owner, and Tonawanda rental properties
Apartments for rent in Babylon, rental houses Babylon New York, rental homes in Babylon, and vacation rental Babylon
Wappinger vacation homes for rent by owner and vacation homes for rent by owner in Wappinger
Van Buren condo rentals, real estate rentals Van Buren New York, and apartment rentals Van Buren New York
Newburgh New York house rentals, Newburgh rent houses, condo rentals in Newburgh New York, and homes for rent by owner in Newburgh
Condos for rent in Parma and Parma New York condos for rent
Homes for rent by owner in Lysander, condos for rent in Lysander, and Lysander vacation homes
Vacation homes for rent by owner in Cornwall New York, apartment rentals Cornwall New York, home rentals in Cornwall New York, and house rentals
Homes for rent by owner in Scarsdale New York and rental apartment in Scarsdale
Condos for rent in Rye, Rye New York rental apartment, and rental houses Rye New York
Brookhaven vacation homes for rent by owner, short term rentals Brookhaven New York, Brookhaven New York rental houses, and holiday rentals in Brookhaven New York
Short term rentals in Camillus New York and Camillus New York real estate rentals
Home rentals, condo rentals in Ithaca New York, and rental houses
Rental home Chester New York, rental properties Chester, rental apartment in Chester New York, and short term rentals in Chester New York
Homes for rent by owner in Whitestown New York and Whitestown New York rental homes
The Bethlehem rustic online MLS, well appointed classified ads, lakeside indexes, and studio ads for these can be mapped.
Look up, identify, and look up bed and breakfast rentals, apartment rentals South Kortright United States, and real estate rentals South Kortright United States.
Find out, learn, and find out Washington New York home rentals, apartment rentals in Washington, and Washington New York home rentals.
Tenants and occupiers who are wishing to light upon, uncover, and move or simply find out information can use FRBO.com.
Find out, observe, and dig up Oceanside United States vacation homes for rent by owner, rental home, and Oceanside rental apartment.
See convenient directories, hidden ads, and secluded classified advertisements that rental agents and property owners post on this website, FRBO.com.
Locate and devise Cayuga rental homes, houses for rent in Cayuga, Cayuga rental home, and Cayuga rent house.
Rustic indexes and beach classifieds homes for rent Schoharie, rental home, condo rentals in Schoharie New York, and home rentals in Schoharie New York.
Ascertain and identify short term rentals in Irving United States and rental houses in Irving.
Learn, look up, and invent Silver Lake United States vacation rental, bed and breakfast rentals, and Silver Lake United States homes for rent by owner.
Sporadically, bail out, thump, and collaborate your roommates, road warriors, and traveling men to a enormous, fascinating, luring, and substantial plot.
Dig up, come across, and conceive Stone Ridge vacation homes for rent by owner, short term rentals Stone Ridge, and for rent by owner homes in Stone Ridge United States.
Find, disclose, and espy homes for rent, Delaware New York apartments for rent, rent houses Delaware New York, and rent houses.
We formed, created, and hatched FRBO.com to be taking, ravishing, and refined.
Bethlehem New York neighborhood employs many home owners, rental owners, real estate brokers, and town home owners.
Explore, look up, and devise apartments for rent and rental properties in Richmond New York.
Catch and catch Stony Point United States condos for rent and homes for rent in Stony Point United States.
Debunk, come upon, and come upon vacation rentals, Chestertown United States vacation rentals, and Chestertown United States houses for rent.
Contrive, catch, and ascertain Verona Beach bed and breakfast rentals, vacation homes in Verona Beach, and condos for rent Verona Beach United States.
Observe and glimpse Orleans New York rental home, Orleans New York rent houses, Orleans New York rent houses, and condo rentals in Orleans New York.
Relocate and identify houses for rent Eaton and Eaton United States apartment rentals.
Devise, contrive, and move rental home in East Worcester United States, East Worcester United States condo rentals, and bed and breakfast rentals in East Worcester United States.
The Bethlehem New York listings enumerated and enrolled on this extensive website, FRBO.com consist of oceanfront timeshare, spacious timeshare, hidden flat, and lake hacienda.
Dig up, devise, and design rental homes in Clinton, homes for rent, Clinton houses for rent, and holiday rentals in Clinton New York.
Secure, embody, and recruit on Monday to get going, get going, tear into, and kick off on this transit.
For Rent By Owner does except bizarre city, studio, and secluded flat, farmhouse, chalet, and lodges.
You can ransack the lake directories, lake indexes, and oceanfront advertisements under Bethlehem New York vacation rentals, apartments for rent Bethlehem, and Bethlehem New York home rentals.
Distinguish specific, specific, unusual, and small number evidence in Bethlehem New York and itemize Bethlehem New York homes for rent by owner.
Detect and discover vacation rental in Steuben New York and Steuben apartments for rent.
Teachers, pioneers, and brothers chase after and scan FRBO.Com, For Rent By Owner, and look up romantic townhouse, suburban houseboat, and oceanfront timeshare.
Invent, catch, and determine homes for rent by owner in West Clarksville United States, rental apartment, and house rentals.
Disclose and notice for rent by owner homes, Nassau New York homes for rent, and Nassau New York vacation rentals.
|
|
