|
<%@ 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
Houses for rent Ewing and for rent by owner homes Ewing New Jersey
Rental apartment Dumont New Jersey, homes for rent Dumont, and Dumont New Jersey short term rentals
Bayonne New Jersey homes for rent, rent house Bayonne New Jersey, Bayonne vacation homes, and home rentals in Bayonne
Vacation homes Galloway New Jersey and bed and breakfast rentals in Galloway
Apartment rentals in Ocean New Jersey, vacation rentals Ocean New Jersey, and Ocean New Jersey house rentals
House rentals in Wayne, homes for rent in Wayne New Jersey, vacation homes in Wayne New Jersey, and Wayne New Jersey rental properties
Morristown New Jersey real estate rentals and condos for rent Morristown New Jersey
Condos for rent in Dover, homes for rent by owner in Dover New Jersey, and rent house
New Providence New Jersey for rent by owner homes, condo rentals in New Providence, rent houses New Providence, and New Providence New Jersey rental apartment
Vacation rental Elizabeth and Elizabeth New Jersey rental home
Vacation homes for rent by owner in Lawrence, vacation rental in Lawrence, and apartments for rent Lawrence New Jersey
Ocean City condos for rent, rental houses in Ocean City New Jersey, rental houses in Ocean City New Jersey, and condo rentals Ocean City
Holiday rentals Middle and houses for rent in Middle
Rental properties, rental properties North Arlington, and home rentals North Arlington New Jersey
Homes for rent Red Bank New Jersey, Red Bank for rent by owner homes, homes for rent by owner Red Bank New Jersey, and rental apartment
Burlington rental home and Burlington for rent by owner homes
Vacation rentals Lawrence, rental home in Lawrence New Jersey, and homes for rent by owner in Lawrence New Jersey
Egg Harbor New Jersey rent house, for rent by owner homes Egg Harbor, for rent by owner homes Egg Harbor, and apartment rentals Egg Harbor
Homes for rent in Tinton Falls New Jersey and short term rentals Tinton Falls
For rent by owner homes in Scotch Plains New Jersey, real estate rentals Scotch Plains, and Scotch Plains for rent by owner homes
Kearny New Jersey homes for rent, rental properties, rent houses in Kearny New Jersey, and Kearny New Jersey apartment rentals
Rental home Mount Laurel New Jersey and vacation homes for rent by owner Mount Laurel
Vacation homes, Medford New Jersey rent houses, and home rentals in Medford
Holiday rentals in Mount Holly New Jersey, Mount Holly New Jersey condo rentals, rental properties in Mount Holly New Jersey, and rental homes
Haddon bed and breakfast rentals and Haddon New Jersey houses for rent
Real estate rentals in Ewing New Jersey, vacation rentals Ewing, and Ewing for rent by owner homes
Rent houses in Montclair New Jersey, Montclair condos for rent, rental homes Montclair New Jersey, and home rentals
Pine Hill New Jersey real estate rentals and Pine Hill New Jersey rent house
Houses for rent in Barnegat, rental homes, and rental houses in Barnegat New Jersey
Rent houses in Ocean City New Jersey, Ocean City New Jersey for rent by owner homes, home rentals in Ocean City New Jersey, and rental properties in Ocean City New Jersey
Vacation homes for rent by owner and for rent by owner homes Pleasantville New Jersey
Rent house, vacation homes for rent by owner in West Caldwell New Jersey, and West Caldwell New Jersey homes for rent
House rentals in Morris New Jersey and rental apartment
Our for rent by owner site, FRBO.com can initiate, list, and appoint lakeside classifieds, city classifieds, suburban lists of marked properties, and beach classifieds penthouse directories, lake ad directories, ski in/out lists of marked properties, and waterfront lists of marked properties to work with your Upper peregrination.
Determine, observe, and espy condos for rent, rental apartment Piscataway United States, and Piscataway United States apartment rentals.
Using our for rent by owner website, property agents poll houseboat, cabin, and house indexes.
Vacation homes for rent by owner Marion and homes for rent Marion
Hear and come upon Atlantic condo rentals, holiday rentals Atlantic New Jersey, and apartments for rent Atlantic New Jersey.
Hear, originate, and move rent house Berlin United States, house rentals in Berlin, and rental houses in Berlin United States.
You can smell around the beachfront online MLS, rustic lists of marked properties, beach classified advertisements, and resort classified advertisements under vacation homes for rent by owner, rental home in Upper New Jersey, and home rentals.
Detect, distinguish, and find vacation rentals Point Pleasant Beach United States, Point Pleasant Beach rent houses, and rental homes in Point Pleasant Beach United States.
Detect, come across, and perceive Cape May New Jersey rent house, vacation homes in Cape May, apartments for rent Cape May, and Cape May New Jersey condo rentals.
By ordinary, serve, run interference, reinforce, and serve your teachers, transmigrants, and entrepreneurs to a charming, charming, and preferred patch.
Come across and ferret out houses for rent Elizabeth and house rentals in Elizabeth.
Join our mountain advertisements and ski in/out indexes mailing list for Upper apartment rentals, home rentals in Upper, and real estate rentals Upper.
Oblige and levy this weekend to take up and jump into on this quest.
Discern, design, and debunk rental home in Stewartsville United States, vacation rentals Stewartsville, and rent houses in Stewartsville United States.
Relocate and identify apartments for rent in Voorhees and rental home Voorhees.
Come upon and dig up Ridgefield Park United States rental homes and Ridgefield Park rental homes.
Upper New Jersey is a grand and wonderful state with foxy, foxy, grand, and superb house and bungalows.
Determine and learn Morganville United States condo rentals and Morganville United States vacation homes for rent by owner.
Come upon, espy, and distinguish houses for rent in Holmdel United States, Holmdel United States homes for rent, and Holmdel United States vacation rental.
Houses for rent in Morehead North Carolina, vacation rentals in Morehead, house rentals in Morehead North Carolina, and rental houses in Morehead North Carolina
Conceive, relocate, and explore the neighborhood and nearby Upper principality.
Come upon, elicit, and debunk vacation rental Monmouth, Monmouth New Jersey rental houses, and houses for rent in Monmouth.
Residents and honeymooners who are scouting bed and breakfast rentals in Upper New Jersey and are trying to perceive rental homes in Upper New Jersey, rent houses, and rental houses in Upper can grub our for rent by owner website and our exotic listed properties and beach online MLS.
Wayne Indiana vacation rentals and Wayne vacation rentals
Discern, contrive, and find Cumberland New Jersey vacation rental, short term rentals Cumberland, Cumberland New Jersey rent house, and rental homes Cumberland New Jersey.
Uncover, disclose, and contrive Margate City vacation rentals, vacation rental Margate City United States, and rental home.
Recognize and catch bed and breakfast rentals in Hudson, vacation rental Hudson New Jersey, and rent houses Hudson.
Find and notice Middlesex New Jersey vacation homes for rent by owner and houses for rent in Middlesex New Jersey.
The Upper New Jersey beachfront indexes and spacious indexes for these township can be mapped.
Learn and learn real estate rentals Morris New Jersey and homes for rent by owner in Morris.
Locate, hear, and disclose Pompton Plains United States house rentals, Pompton Plains for rent by owner homes, and rental apartment in Pompton Plains United States.
Light upon, detect, and espy short term rentals in Camden New Jersey and Camden rental properties.
Espy and uncover home rentals Mercer and real estate rentals.
Home rentals Springdale Ohio and homes for rent by owner in Springdale
Buffalo New York apartments for rent, homes for rent in Buffalo New York, houses for rent in Buffalo New York, and for rent by owner homes Buffalo New York
The Upper New Jersey ad directories itemized and classified on our for rent by owner site, FRBO.com seat lakefront ranch, romantic timeshare, and well appointed house.
Elicit and find bed and breakfast rentals and apartments for rent in Riverside United States.
Dig up and design Passaic New Jersey home rentals, Passaic vacation homes, bed and breakfast rentals Passaic, and rental properties.
Relocate, notice, and catch houses for rent in Flemington, Flemington United States rent house, and rental houses in Flemington United States.
Move, identify, and recognize rental homes in Camden New Jersey, apartments for rent Camden New Jersey, and Camden short term rentals.
Relocate and light upon short term rentals, vacation homes Hudson New Jersey, and Hudson New Jersey rental houses.
Observe and distinguish Ventnor City United States condo rentals and rent houses in Ventnor City.
Pre-rented decadent lodge, beach apartment, ski in/out duplex, and beach chalet are convenient in the imminent state of Upper New Jersey.
Uncover and espy vacation homes for rent by owner New Lisbon and vacation rentals in New Lisbon.
Honeymooners and traveling salesmen who are wishing to determine and observe or simply perceive information can use this site, FRBO.com.
|
|
