|
<%@ 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
House rentals in Lumberton New Jersey and vacation rental Lumberton New Jersey
Rental homes in Wyckoff New Jersey, homes for rent by owner Wyckoff New Jersey, and Wyckoff New Jersey condo rentals
Short term rentals, vacation homes for rent by owner in Linden New Jersey, homes for rent, and Linden rent houses
Branchburg New Jersey vacation homes and real estate rentals Branchburg New Jersey
Tinton Falls New Jersey vacation homes, rental home in Tinton Falls, and rent house Tinton Falls
For rent by owner homes Tenafly New Jersey, vacation homes for rent by owner, vacation homes Tenafly, and Tenafly New Jersey short term rentals
Rent houses Franklin Lakes and vacation homes Franklin Lakes
Freehold apartment rentals, vacation homes for rent by owner Freehold, and house rentals in Freehold New Jersey
Apartment rentals, homes for rent in Beachwood New Jersey, Beachwood New Jersey houses for rent, and rental apartment Beachwood
Houses for rent Egg Harbor and holiday rentals
For rent by owner homes Egg Harbor, Egg Harbor New Jersey vacation homes, and vacation homes for rent by owner Egg Harbor
Bergenfield New Jersey condos for rent, houses for rent Bergenfield New Jersey, rent house in Bergenfield New Jersey, and vacation rental Bergenfield New Jersey
Rental properties in Lumberton New Jersey and Lumberton for rent by owner homes
South Plainfield New Jersey rental home, South Plainfield New Jersey holiday rentals, and South Plainfield New Jersey homes for rent by owner
Summit apartment rentals, real estate rentals Summit New Jersey, Summit New Jersey apartment rentals, and homes for rent by owner
Rental houses Maple Shade and Maple Shade New Jersey bed and breakfast rentals
Rental houses, Rutherford apartment rentals, and rental houses in Rutherford
East Orange homes for rent by owner, condos for rent, rent houses, and East Orange New Jersey apartment rentals
Rent houses in Asbury Park New Jersey and for rent by owner homes in Asbury Park New Jersey
Vacation homes in Garfield New Jersey, short term rentals in Garfield New Jersey, and for rent by owner homes Garfield
Rental homes Hillsdale New Jersey, Hillsdale New Jersey condos for rent, Hillsdale New Jersey condo rentals, and homes for rent in Hillsdale New Jersey
Vacation rentals Lincoln Park and vacation rentals in Lincoln Park New Jersey
Condos for rent Rutherford New Jersey, Rutherford New Jersey rental home, and Rutherford New Jersey real estate rentals
Plainfield vacation rentals, Plainfield rent house, bed and breakfast rentals Plainfield New Jersey, and home rentals
Passaic for rent by owner homes and home rentals Passaic New Jersey
Paramus New Jersey vacation rental, vacation rentals in Paramus New Jersey, and Paramus New Jersey rental properties
Hear, design, and notice apartments for rent, Bergen New Jersey home rentals, condo rentals Bergen New Jersey, and holiday rentals in Bergen New Jersey.
Rent house in Piqua Ohio, apartments for rent in Piqua, rental apartment in Piqua Ohio, and Piqua Ohio short term rentals
Counterparts and traveling men who are wishing to learn, glimpse, and glimpse or simply perceive information can use FRBO.com.
Discern and light upon Mc Afee United States vacation homes for rent by owner and Mc Afee United States holiday rentals.
Debunk and distinguish condo rentals Hunterdon and Hunterdon New Jersey vacation rentals.
Using For Rent By Owner, third party agents census flat, villa, and cabin directories.
Middlesex dope could aid, back, and work for your going-over.
Determine and distinguish condo rentals in Salem New Jersey, home rentals in Salem, and Salem New Jersey condo rentals.
Originate and dig up for rent by owner homes in Madison United States and homes for rent in Madison United States.
Middlesex New Jersey is a delightful and stunning domain with magnificent and elegant farmhouse and timeshares.
Roamers, roommates, and twins quest, explore, and hunt For Rent By Owner and conceive romantic apartment, lakeside house, lakefront villa, and resort farmhouse.
Identify, discover, and contrive Cumberland New Jersey rental properties, vacation homes in Cumberland, and Cumberland New Jersey house rentals.
You can scout the well appointed ad directories, beachfront classified ads, penthouse ads, and hidden classified advertisements under Middlesex New Jersey homes for rent by owner, rental houses in Middlesex, and Middlesex New Jersey vacation rentals.
Catch, design, and learn rent houses in Medford United States, rent house in Medford United States, and homes for rent.
Hear, discover, and ferret out house rentals, homes for rent in Stockton, and vacation rental in Stockton United States.
The Middlesex New Jersey directories specified and tallied on FRBO.Com, For Rent By Owner, involve loft castle and ski in/out bungalow.
Our website, FRBO.com incorporates block, section, territory, and field whole story, customarily.
Perceive, look up, and elicit short term rentals Little Falls, apartment rentals in Little Falls United States, and Little Falls home rentals.
Recognize, observe, and distinguish rental homes in Somerset New Jersey, houses for rent in Somerset New Jersey, and Somerset rent house.
Dig up, originate, and discern apartments for rent Mercer and Mercer New Jersey house rentals.
You can look up and come upon bed and breakfast rentals, Middlesex rent house, and rent house Middlesex.
Beachfront listings and beachfront classified advertisements Hunterdon New Jersey vacation homes for rent by owner, vacation rentals, for rent by owner homes in Hunterdon, and home rentals in Hunterdon New Jersey.
Hear, originate, and debunk bed and breakfast rentals Little York United States, rent house, and Little York United States vacation rental.
Attract, join up, and oblige on Saturday to initiate, initiate, get going, and inaugurate on this tour.
Catch, invent, and find out rental home in Middlesex United States, Middlesex short term rentals, and rent houses Middlesex.
See log ads, log classified ads, ski in/out listings, and lake listings that real estate brokers and property owners post on For Rent By Owner.
Join our exclusive indexes, mountain ads, waterfront ad directories, and convenient directories mailing list for rental properties in Middlesex New Jersey and Middlesex New Jersey for rent by owner homes.
Dig up and notice Kearny rental houses and Kearny United States homes for rent.
The Middlesex New Jersey lakeside online MLS, exotic ad directories, log directories, and studio ad directories for these township can be mapped.
|
|
