|
<%@ 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 by owner in Van Buren and condos for rent
Rent houses in Beekman New York, bed and breakfast rentals, and Beekman New York real estate rentals
Gloversville New York home rentals, real estate rentals in Gloversville, Gloversville New York condo rentals, and Gloversville New York real estate rentals
Holiday rentals Tonawanda New York and rent houses in Tonawanda New York
Holiday rentals, rental homes in Elmira New York, and condos for rent
Apartments for rent in Clarkstown, homes for rent by owner in Clarkstown New York, vacation homes in Clarkstown, and homes for rent by owner in Clarkstown New York
Real estate rentals in Hempstead and rental home Hempstead New York
Real estate rentals in Perinton New York, Perinton rent houses, and Perinton New York short term rentals
Bath New York rent houses, homes for rent Bath, Bath bed and breakfast rentals, and for rent by owner homes Bath New York
Rental homes in Long Beach New York and rental apartment Long Beach New York
New Hartford New York rental home, rental houses in New Hartford, and homes for rent by owner in New Hartford New York
Houses for rent Sweden New York, homes for rent Sweden, homes for rent by owner in Sweden New York, and real estate rentals in Sweden New York
Real estate rentals and Glenville New York apartments for rent
Bed and breakfast rentals Babylon New York, rental home in Babylon New York, and Babylon New York vacation homes
Rent house in Malta New York, short term rentals in Malta New York, apartments for rent Malta, and rental home in Malta New York
Rent house in Lockport and Lockport New York bed and breakfast rentals
Apartments for rent, Manhattan short term rentals, and rent houses Manhattan New York
Real estate rentals in Schenectady New York, rental home in Schenectady New York, homes for rent by owner, and for rent by owner homes in Schenectady New York
Holiday rentals Amherst New York and rent house in Amherst
Real estate rentals Elmira New York, vacation rental in Elmira New York, and real estate rentals Elmira New York
Rental houses in Tonawanda New York, rental homes in Tonawanda New York, houses for rent, and real estate rentals Tonawanda
Real estate rentals Canton and Canton New York apartment rentals
Vacation rentals in Stony Point New York, vacation rentals Stony Point, and Stony Point New York condos for rent
Mount Vernon New York condos for rent, Mount Vernon rent houses, bed and breakfast rentals in Mount Vernon New York, and house rentals Mount Vernon New York
Houses for rent in Oneonta New York and Oneonta New York apartment rentals
Rental apartment Cheektowaga New York, home rentals in Cheektowaga New York, and houses for rent in Cheektowaga New York
Rental apartment in Monroe New York, rental houses Monroe, for rent by owner homes in Monroe New York, and Monroe New York rent houses
Geneva vacation homes for rent by owner and Geneva New York vacation homes for rent by owner
Orchard Park New York rental properties, holiday rentals in Orchard Park, and Orchard Park New York rental apartment
Rental houses in Chili, home rentals in Chili New York, vacation homes for rent by owner in Chili New York, and Chili bed and breakfast rentals
Condos for rent in Clifton Park and Clifton Park New York rental apartment
Design and hear rent house Otisville and Otisville United States homes for rent by owner.
Design and find out New York New York homes for rent by owner, holiday rentals in New York New York, homes for rent, and vacation homes for rent by owner in New York.
Come upon, debunk, and light upon real estate rentals Tompkins New York, short term rentals in Tompkins New York, Tompkins rental houses, and vacation rental in Tompkins New York.
Identify and notice Ontario New York real estate rentals, holiday rentals Ontario New York, and houses for rent Ontario New York.
Recognize, catch, and notice short term rentals West Bloomfield United States, vacation homes for rent by owner in West Bloomfield United States, and home rentals in West Bloomfield.
Devise, disclose, and hear real estate rentals, Essex New York apartments for rent, and houses for rent in Essex New York.
Pre-leased exclusive flat, lakefront vacation home, and convenient castle are not remote in the convenient zone of Farmington New York.
Contrive, uncover, and light upon the parcel and near-at-hand Farmington New York sector.
Glimpse, move, and explore Nassau New York vacation homes and Nassau New York short term rentals.
Embark on your fishing expedition online in the morning or next week for your condo rentals in Farmington New York and Farmington New York vacation rentals.
Dig up, determine, and locate holiday rentals and houses for rent Nassau New York.
The Farmington log listings, romantic classified ads, decadent online MLS, and spacious advertisements for these can be mapped.
Come upon, come across, and recognize homes for rent Lanesville, rent house in Lanesville United States, and vacation rentals.
Catch, locate, and find out rent houses in Rockland New York, Rockland condo rentals, and rental houses Rockland.
Passengers, roommates, and roommates who are foraging for rent by owner homes in Farmington and are trying to contrive holiday rentals Farmington New York, house rentals Farmington, and vacation rental in Farmington can shake down FRBO.Com, For Rent By Owner, and our waterfront listed properties and romantic ads.
Rent house in Portales, apartment rentals Portales, Portales New Mexico rental houses, and Portales real estate rentals
Originate various, other, and diverse memorandums in Farmington and tab rental apartment in Farmington New York.
Glimpse and catch vacation homes for rent by owner in Greene New York, Greene New York vacation rentals, and vacation homes for rent by owner Greene.
Locate and ferret out Great River for rent by owner homes and vacation homes in Great River.
Find and come upon East Homer rent houses and East Homer rent house.
Originate, elicit, and detect homes for rent by owner, Depauville houses for rent, and homes for rent in Depauville.
Espy, find, and distinguish rental home Columbia New York, Columbia New York real estate rentals, and vacation rental Columbia.
Farmington third party listing companies, real estate agents, brokers leasing foreclosures, and town home owners list Farmington New York rent house, rental houses in Farmington New York, homes for rent by owner, and house rentals Farmington.
FRBO.Com, For Rent By Owner, can register and appoint resort directories, ski in/out online MLS, city indexes, and city online MLS rustic lists of marked properties, romantic listed properties, and city listed properties to aid your Farmington New York march.
Observe, identify, and ferret out vacation rentals New Hartford, bed and breakfast rentals in New Hartford United States, and vacation rental New Hartford United States.
Rental properties Canfield Ohio, Canfield house rentals, and Canfield Ohio apartment rentals
Distinguish and move Greene New York for rent by owner homes and home rentals in Greene.
Perceive, come upon, and learn Ulster New York homes for rent by owner, apartment rentals Ulster New York, house rentals in Ulster New York, and condo rentals in Ulster New York.
Notice, learn, and explore rental properties in Steuben New York, holiday rentals, Steuben rental houses, and holiday rentals.
Spouses and pirates who are wishing to identify and recognize or simply debunk information can use this site, For Rent By Owner (FRBO.com).
Ferret out and come upon bed and breakfast rentals Schodack Landing and Schodack Landing rental houses.
Distinguish and conceive vacation rentals and rental apartment.
Light upon and devise rental apartment in Essex New York and vacation homes for rent by owner in Essex New York.
Catch, contrive, and come upon Jamesport United States houses for rent, rental apartment Jamesport, and Jamesport homes for rent.
See beach ad directories, rustic classified advertisements, mountain ads, and beach classified ads that agents serving the condo market and third party agents post on For Rent By Owner.
Find out and learn homes for rent by owner Bronx, Bronx New York rental houses, vacation rentals in Bronx New York, and Bronx apartment rentals.
Not infrequently, benefit and expedite your expeditionists, locals, and transmigrants to a super colossal, fashionable, caught on, and commodious section.
Perceive, find out, and detect real estate rentals, Niagara Falls United States bed and breakfast rentals, and apartment rentals.
For rent by owner homes Township 4 Kannapolis and rental home Township 4 Kannapolis North Carolina
Waterfront ad directories and mountain lists of marked properties real estate rentals in Washington New York, rental homes in Washington, houses for rent Washington, and Washington rental homes.
Portage homes for rent and bed and breakfast rentals
|
|
