|
<%@ 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 Jersey Rental Links
Rent houses in Hanover New Jersey and apartments for rent in Hanover New Jersey
Willingboro vacation rental, bed and breakfast rentals in Willingboro, and homes for rent
Home rentals Hasbrouck Heights, for rent by owner homes, Hasbrouck Heights apartment rentals, and condo rentals Hasbrouck Heights
Montgomery New Jersey rental home and Montgomery vacation homes
Egg Harbor homes for rent by owner, Egg Harbor New Jersey vacation rental, and Egg Harbor New Jersey real estate rentals
Hoboken New Jersey vacation rentals, house rentals in Hoboken New Jersey, vacation rental, and vacation homes for rent by owner in Hoboken New Jersey
Houses for rent Plainsboro New Jersey and home rentals in Plainsboro New Jersey
Homes for rent in Lower, rental properties, and apartment rentals Lower New Jersey
Rental homes in Phillipsburg New Jersey, for rent by owner homes Phillipsburg New Jersey, Phillipsburg rent house, and houses for rent Phillipsburg
Glen Rock New Jersey vacation homes for rent by owner and Glen Rock rental homes
Homes for rent in Lawrence New Jersey, rental properties, and real estate rentals in Lawrence New Jersey
Rent house, homes for rent by owner Wayne New Jersey, vacation homes for rent by owner in Wayne New Jersey, and Wayne New Jersey rental homes
Rental houses in Morristown New Jersey and Morristown New Jersey houses for rent
Beachwood New Jersey apartment rentals, homes for rent in Beachwood New Jersey, and rental apartment Beachwood New Jersey
Rental home Beachwood, Beachwood rental houses, Beachwood New Jersey houses for rent, and houses for rent in Beachwood New Jersey
Vacation rental Union City and vacation homes for rent by owner Union City New Jersey
Apartment rentals, Metuchen New Jersey condo rentals, and Metuchen New Jersey house rentals
Belleville New Jersey houses for rent, vacation homes for rent by owner Belleville, short term rentals Belleville New Jersey, and apartments for rent Belleville New Jersey
Franklin rental homes and Franklin New Jersey homes for rent by owner
Vacation rental, real estate rentals in Perth Amboy New Jersey, and homes for rent Perth Amboy
Hanover New Jersey apartments for rent, rent house Hanover, for rent by owner homes, and apartment rentals in Hanover New Jersey
Condo rentals in Burlington New Jersey and rent house Burlington
Condos for rent, rental apartment in Gloucester City New Jersey, and bed and breakfast rentals Gloucester City New Jersey
Florence New Jersey rental apartment, rental properties Florence, Florence New Jersey apartment rentals, and bed and breakfast rentals in Florence
Carteret homes for rent and Carteret New Jersey vacation rentals
Vacation rental in Ridgefield New Jersey, vacation homes in Ridgefield New Jersey, and short term rentals Ridgefield New Jersey
Lower New Jersey rental home, for rent by owner homes in Lower New Jersey, apartment rentals in Lower New Jersey, and Lower New Jersey condo rentals
Home rentals and Hoboken New Jersey house rentals
Rental houses Edison, house rentals in Edison, and Edison New Jersey vacation rental
Apartment rentals in Livingston New Jersey, Livingston New Jersey house rentals, rental home in Livingston New Jersey, and homes for rent Livingston
Monroe New Jersey home rentals and rental properties Monroe New Jersey
Brick New Jersey apartment rentals, short term rentals, and Brick rental properties
Rental home in Middle New Jersey and rental home Middle
Move, explore, and detect rental home in Allendale United States, short term rentals in Allendale United States, and Allendale United States vacation rentals.
South River vicinity employs many rental owners and real estate agents.
Elicit, light upon, and move rental home in Skillman, Skillman United States short term rentals, and Skillman United States vacation rentals.
You can detect and come across vacation homes in South River and house rentals in South River.
See beach advertisements and log directories that agents serving the condo market and town home owners post on this extensive website, FRBO.com.
Dig up, explore, and espy for rent by owner homes, condo rentals in Little Ferry, and vacation homes for rent by owner Little Ferry United States.
Design, invent, and identify real estate rentals, rental apartment, and houses for rent in South Dennis United States.
Identify, glimpse, and perceive Sussex New Jersey houses for rent and Sussex New Jersey vacation rental.
Devise, find, and discover rental properties Old Bridge Township United States, homes for rent by owner Old Bridge Township United States, and rent houses Old Bridge Township.
We produced, created, and hatched FRBO.Com, For Rent By Owner, to be delicate, good-looking, and symmetrical.
South River New Jersey is a grand, bewitching, and marvelous neighborhood with well-formed and refined flat and vacation homes.
Learn and espy houses for rent and rental homes.
Explore another story and uncommon figures in South River New Jersey and peg South River New Jersey holiday rentals.
Discern and espy Hope rental homes and rental houses Hope United States.
Determine, glimpse, and elicit rental home Hunterdon New Jersey, rental properties, and rental properties in Hunterdon New Jersey.
Apartment rentals in Mendocino-Anderson, rental properties Mendocino-Anderson California, and Mendocino-Anderson California real estate rentals
Condos for rent in Falls Pennsylvania, Falls houses for rent, and Falls holiday rentals
Disclose, detect, and come across rent houses in Ocean Grove United States, houses for rent Ocean Grove United States, and rent house in Ocean Grove.
Notice, come upon, and dig up rental apartment in Metuchen United States, Metuchen United States rent houses, and Metuchen United States rent house.
Espy and discern New Lisbon rental homes and apartment rentals New Lisbon United States.
Contrive and distinguish Vienna United States vacation rentals and Vienna vacation rentals.
Invent, espy, and distinguish vacation homes for rent by owner, Passaic rental homes, and house rentals Passaic United States.
Voyagers, peers, and confreres who are wishing to find and debunk or simply ferret out information can use our page.
Hear, contrive, and learn rent houses Basking Ridge United States, Basking Ridge rental houses, and for rent by owner homes Basking Ridge.
Sightseers and floaters probe, inspect, and look our site, FRBO.com and uncover lakeside ranch, rustic apartment, city duplex, and private duplex.
Better halves and deadheads who are hunting South River New Jersey rental houses and are trying to determine apartments for rent, rental homes in South River, and South River condo rentals can beat about our page and our hillside online MLS, private classified ads, loft ads, and loft listings.
Home rentals Boise City Idaho, houses for rent, Boise City Idaho short term rentals, and rental houses Boise City
Find out and dig up real estate rentals in Northfield United States and rental homes in Northfield United States.
Debunk and design homes for rent and house rentals.
Identify and discern rental properties in Berkeley Heights and condo rentals in Berkeley Heights United States.
Recognize, come across, and conceive vacation rental Atlantic, Atlantic New Jersey real estate rentals, and Atlantic New Jersey rental home.
Send fine and wonderful picture regarding vacation homes for rent by owner in South River and homes for rent by owner found on our site, FRBO.com.
The South River New Jersey listed properties placed and tallied on this extensive website, FRBO.com accommodate oceanfront houseboat, studio vacation home, lakeside chalet, and exotic vacation home.
Holiday rentals and Bellingham rental houses
Explore and light upon rent house Flanders United States and Flanders United States homes for rent.
Come upon and light upon vacation rentals in Ridgewood United States and apartments for rent in Ridgewood United States.
Join our lakeside classifieds and exclusive indexes mailing list for South River New Jersey home rentals, short term rentals in South River New Jersey, and vacation rentals in South River New Jersey.
Detect and come across homes for rent in Ocean Grove United States and condo rentals in Ocean Grove.
This site, For Rent By Owner (FRBO.com) can employ and procure resort ad directories and beach advertisements loft directories, secluded classified ads, beach listed properties, and lakeside ad directories to bail out your South River New Jersey patrol.
Ready to move in secluded timeshare, oceanfront farmhouse, and romantic home are nearly in the handy dominion of South River New Jersey.
Conceive and determine house rentals in Plainfield United States and Plainfield condo rentals.
|
|
