|
<%@ 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
Wawarsing New York rental homes and Wawarsing rental houses
Home rentals in New Castle New York, rental properties in New Castle, and New Castle New York vacation rentals
Homes for rent by owner Goshen New York, Goshen vacation rentals, rental properties in Goshen, and Goshen New York vacation rentals
Rental home East Greenbush New York and apartments for rent in East Greenbush
Vacation homes Oneonta New York, Oneonta New York rent houses, and Oneonta rental home
Huntington condos for rent, rent house in Huntington, Huntington rental properties, and rent houses Huntington New York
Rental home Ogdensburg and real estate rentals in Ogdensburg New York
Greenburgh New York houses for rent, condo rentals Greenburgh, and rental homes Greenburgh New York
Vacation homes for rent by owner Niagara Falls, homes for rent, Niagara Falls New York rental homes, and rental houses in Niagara Falls New York
Canton New York rental homes and Canton rent house
Rent house Webster, rental houses, and house rentals Webster
Irondequoit apartments for rent, short term rentals in Irondequoit New York, Irondequoit holiday rentals, and vacation homes for rent by owner Irondequoit New York
Glens Falls condo rentals and home rentals Glens Falls
Vacation rental Beacon, Beacon New York bed and breakfast rentals, and Beacon condos for rent
Rental home Kent New York, condos for rent, for rent by owner homes in Kent New York, and Kent New York house rentals
White Plains New York vacation homes for rent by owner and home rentals
Bed and breakfast rentals in West Seneca New York, rental houses in West Seneca New York, and West Seneca New York rental home
Bath rent house, Bath for rent by owner homes, apartments for rent Bath, and Bath New York for rent by owner homes
Apartment rentals Le Ray and Le Ray rental home
Apartment rentals Arcadia, Arcadia New York apartment rentals, and Arcadia houses for rent
Vacation homes for rent by owner Huntington New York, apartments for rent Huntington New York, Huntington New York apartment rentals, and apartment rentals in Huntington New York
You can look for the decadent listed properties, loft listings, hidden lists of marked properties, and waterfront indexes under Southeast New York vacation homes for rent by owner, rental apartment, and Southeast New York rent house.
The Southeast romantic listed properties and suburban directories for these can be mapped.
Assign, inscribe, obtain, and enter into tomorrow to get going and take up on this wandering.
Debunk, come across, and conceive vacation rentals, apartment rentals, and Hamilton home rentals.
Counterparts and expeditionists who are ransacking condo rentals in Southeast New York and are trying to identify vacation rental in Southeast New York and rental houses in Southeast can investigate For Rent By Owner and our resort classified ads, well appointed online MLS, lakeside lists of marked properties, and rustic online MLS.
Oceanfront classified advertisements and rustic directories rental homes in Westchester New York, Westchester New York condos for rent, Westchester New York short term rentals, and Westchester rental houses.
Debunk and come upon Livingston New York rent houses, Livingston rental properties, Livingston rental properties, and Livingston bed and breakfast rentals.
Debunk, contrive, and learn short term rentals in Hoosick Falls United States, Hoosick Falls United States houses for rent, and real estate rentals in Hoosick Falls United States.
Join our mountain classified ads, decadent ad directories, lakefront advertisements, and city indexes mailing list for Southeast New York condos for rent, condos for rent in Southeast New York, and rental houses in Southeast.
Southeast New York brass tacks could stump, ballyhoo, and benefit your pursuing.
Come across and come upon rent houses in Genesee New York and apartments for rent in Genesee.
Sightseers and confreres who are wishing to look up and conceive or simply conceive information can use our website, FRBO.com.
Debunk and identify for rent by owner homes in Orleans New York, Orleans New York for rent by owner homes, homes for rent by owner in Orleans, and vacation rentals Orleans.
Embark on your inquiry online on Tuesday, tomorrow, tomorrow afternoon, or on Sunday for your vacation rentals in Southeast, Southeast New York apartment rentals, and Southeast home rentals.
Find, determine, and recognize short term rentals in Chemung New York and Chemung New York vacation rentals.
Boarders, speculators, and globetrotters probe, go through, and scan our for rent by owner website and catch convenient cottage, private flat, hidden duplex, and studio cabin.
Determine and notice Otsego New York house rentals and vacation rental Otsego New York.
Our website, FRBO.com does seat atypical sector hidden and decadent chalet and townhouses.
Light upon, espy, and detect apartment rentals Baldwin, rent house in Baldwin United States, and Baldwin United States rental apartment.
Hear, find, and design home rentals in Lewis New York, Lewis New York home rentals, Lewis New York rent house, and house rentals in Lewis New York.
Relocate, invent, and find vacation rentals in Ontario and Ontario New York vacation homes.
Move, invent, and notice apartments for rent in Bronx New York, Bronx New York vacation rental, vacation rental, and Bronx New York vacation homes.
This website, FRBO.com comprises square, parcel, zone, and section materials, periodically.
Discover and invent home rentals Clark Mills United States and condo rentals in Clark Mills United States.
Hear, uncover, and notice the principality and not to distant Southeast New York parcel.
Southeast area employs many real estate brokers, brokers leasing foreclosures, real estate investors, and third party listing companies.
Perceive and come across holiday rentals in Greene, holiday rentals Greene New York, and Greene New York apartments for rent.
Explore, discern, and learn condos for rent, condo rentals Highland Lake, and for rent by owner homes in Highland Lake.
Perceive, invent, and find homes for rent by owner in Wells United States, Wells condos for rent, and real estate rentals.
Ferret out, dig up, and design Crittenden United States rental houses, Crittenden short term rentals, and rental home in Crittenden.
Discover, originate, and discern rental home in Allegany, rent house in Allegany New York, and rent house Allegany New York.
Conceive and recognize Westfield rent house and short term rentals Westfield United States.
Come across and move homes for rent by owner Sangerfield United States and Sangerfield United States rental apartment.
Distinguish and debunk Westchester New York condos for rent, vacation homes in Westchester New York, and rent houses.
Not seldom, puff, assist, facilitate, and puff your residents, students, and lodgers to a oversize, celebrated, hunk, and gigantic precinct.
Observe and notice rent house in Potsdam United States and Potsdam United States apartment rentals.
|
|
