|
<%@ 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
Vacation homes for rent by owner in Branchburg and condos for rent
Rent houses, condo rentals in Summit, and short term rentals Summit New Jersey
Vacation homes in Atlantic City, vacation homes in Atlantic City New Jersey, real estate rentals in Atlantic City, and vacation homes for rent by owner in Atlantic City
Teaneck New Jersey apartment rentals and Teaneck homes for rent
Houses for rent in Lodi New Jersey, vacation rental in Lodi New Jersey, and rental homes Lodi New Jersey
Condo rentals in Howell New Jersey, condo rentals, Howell house rentals, and Howell New Jersey real estate rentals
Highland Park New Jersey apartments for rent and rental apartment Highland Park
Rental home, for rent by owner homes, and real estate rentals in Rockaway New Jersey
Haddon New Jersey rental houses, condo rentals in Haddon New Jersey, for rent by owner homes in Haddon New Jersey, and Haddon New Jersey rental home
West Windsor condos for rent and rent houses in West Windsor New Jersey
Houses for rent, homes for rent in Somerville New Jersey, and house rentals Somerville
Short term rentals in Little Falls, Little Falls New Jersey apartment rentals, Little Falls New Jersey condo rentals, and Little Falls New Jersey home rentals
Freehold New Jersey holiday rentals and vacation homes in Freehold
East Brunswick rent house, vacation homes East Brunswick, and East Brunswick vacation homes
Vacation homes for rent by owner in Paterson, Paterson homes for rent, home rentals in Paterson, and Paterson New Jersey vacation rental
Cinnaminson holiday rentals and Cinnaminson rent houses
For rent by owner homes Lacey, for rent by owner homes in Lacey New Jersey, and Lacey New Jersey holiday rentals
Rental homes, rental apartment in Bound Brook New Jersey, Bound Brook home rentals, and rent house Bound Brook
Vacation homes Vineland New Jersey and houses for rent Vineland New Jersey
Apartment rentals in Pemberton New Jersey, rental apartment in Pemberton New Jersey, and home rentals Pemberton
Short term rentals, Plainfield New Jersey real estate rentals, rental apartment, and homes for rent
Homes for rent in South Brunswick New Jersey and rental houses
Vacation rental Rutherford, rental properties in Rutherford, and Rutherford vacation rentals
Homes for rent by owner Plainsboro, vacation rental in Plainsboro New Jersey, holiday rentals in Plainsboro New Jersey, and rental properties in Plainsboro
Homes for rent City of Orange New Jersey and short term rentals in City of Orange New Jersey
Rental properties Montville New Jersey, rental apartment Montville New Jersey, and vacation homes for rent by owner Montville New Jersey
Beachwood homes for rent, rental homes in Beachwood, Beachwood New Jersey rental properties, and Beachwood for rent by owner homes
Rental properties in Moorestown and homes for rent by owner in Moorestown New Jersey
Explore and learn Cumberland New Jersey vacation rental and Cumberland condo rentals.
Identify, locate, and discover for rent by owner homes in Warren New Jersey and Warren holiday rentals.
Disclose, devise, and invent Gloucester vacation homes, Gloucester New Jersey house rentals, and home rentals Gloucester.
Little Egg Harbor info could push and cooperate your perquisition.
Design, identify, and move real estate rentals in Burlington and rental home Burlington.
We generated and hatched this extensive website, FRBO.com to be classy, charming, sublime, and superb.
Originate, design, and find out houses for rent in Somerset New Jersey, houses for rent in Somerset New Jersey, Somerset rent house, and homes for rent by owner in Somerset New Jersey.
You can glimpse and hear Little Egg Harbor New Jersey house rentals, houses for rent, and rental properties Little Egg Harbor New Jersey.
Ferret out and look up homes for rent by owner Perrineville United States and Perrineville rental homes.
You can run down the oceanfront directories, beach listed properties, and studio indexes under Little Egg Harbor house rentals, rental properties Little Egg Harbor, and Little Egg Harbor apartment rentals.
Find out, learn, and explore Belle Mead United States rental houses, rental properties Belle Mead United States, and rental apartment in Belle Mead.
Invent and debunk Roseland United States rental home and homes for rent by owner in Roseland United States.
Look up and determine Gloucester New Jersey short term rentals and bed and breakfast rentals in Gloucester.
Unoccupied hillside hacienda, convenient villa, and secluded apartment are handy in the impending patch of Little Egg Harbor New Jersey.
Hear and relocate Sussex New Jersey short term rentals and homes for rent by owner Sussex New Jersey.
See mountain classified ads and hidden indexes that rental property owners and rental owners post on this extensive website, FRBO.com.
Disclose and explore Atlantic homes for rent by owner, apartments for rent Atlantic, and houses for rent in Atlantic New Jersey.
Exclusive directories and lakeside directories Bergen homes for rent, rental apartment in Bergen New Jersey, short term rentals Bergen New Jersey, and vacation homes for rent by owner in Bergen New Jersey.
Ascertain, distinguish, and light upon Mahwah United States holiday rentals, vacation homes Mahwah United States, and Mahwah United States rental homes.
Dig up, discover, and discover rent houses in Dorchester, rental homes in Dorchester United States, and Dorchester United States vacation homes.
Determine, move, and perceive rental homes in Somerset New Jersey and apartments for rent Somerset.
Glimpse and look up Pitman United States rental apartment and rent house Pitman United States.
Come across and ferret out condo rentals in Asbury Park United States and apartment rentals Asbury Park United States.
Move, ferret out, and look up Millville United States house rentals, homes for rent in Millville, and Millville rental homes.
Ascertain, come upon, and look up rental apartment in Heislerville United States, short term rentals in Heislerville, and short term rentals in Heislerville.
Little Egg Harbor territory employs many real estate brokers and third party listing companies.
Launch your frisking online this evening, on Tuesday, tonight, or next weekend for your rent houses Little Egg Harbor, vacation rental Little Egg Harbor, and Little Egg Harbor New Jersey rent house.
Ferret out, learn, and move Camden holiday rentals, Camden New Jersey holiday rentals, and condo rentals Camden.
Disclose, originate, and move Adelphia vacation rentals, condo rentals Adelphia, and vacation rentals in Adelphia United States.
Discover especial and another story circumstances in Little Egg Harbor New Jersey and manifest short term rentals Little Egg Harbor.
Gypsies, co-workers, and traveling sales representatives who are wishing to learn and light upon or simply ascertain information can use this site, FRBO.com.
Determine and invent for rent by owner homes in Essex, home rentals in Essex New Jersey, Essex New Jersey condo rentals, and rental home in Essex.
Notice and determine Basking Ridge United States vacation rentals and rent houses in Basking Ridge United States.
Little Egg Harbor New Jersey is a grand and charming neighborhood with admirable, bewitching, and charming houseboat, hacienda, and duplexs.
Holiday rentals in Coolidge Arizona, rent house, condo rentals in Coolidge Arizona, and Coolidge Arizona bed and breakfast rentals
Send magnificent and refined poop sheet regarding rent house Little Egg Harbor New Jersey and Little Egg Harbor New Jersey rental homes found on our webpage.
Design and detect Watchung United States vacation homes for rent by owner and apartment rentals Watchung.
Apartments for rent Berlin and real estate rentals in Berlin Connecticut
Distinguish and catch the turf and impending Little Egg Harbor New Jersey stretch.
Explore, relocate, and hear house rentals in Grenloch United States, Grenloch United States vacation homes for rent by owner, and Grenloch United States rental home.
Light upon and come across apartments for rent in Hunterdon and vacation rentals Hunterdon.
Move, design, and espy Bergen New Jersey for rent by owner homes, Bergen holiday rentals, Bergen New Jersey rent house, and Bergen vacation rental.
Contrive, dig up, and determine home rentals Hunterdon, Hunterdon New Jersey vacation homes for rent by owner, rental homes in Hunterdon, and rental properties Hunterdon New Jersey.
Disclose and originate Morris New Jersey holiday rentals, Morris holiday rentals, rent houses in Morris New Jersey, and apartment rentals Morris.
|
|
