|
<%@ 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
Condo rentals and West Orange New Jersey rent house
Millburn New Jersey bed and breakfast rentals, Millburn New Jersey rent house, and Millburn for rent by owner homes
West New York condos for rent, West New York New Jersey houses for rent, rental properties, and holiday rentals West New York
Paramus New Jersey rental apartment and Paramus New Jersey homes for rent
For rent by owner homes in Union New Jersey, vacation rental Union New Jersey, and Union home rentals
Vacation rental, Elmwood Park New Jersey short term rentals, Elmwood Park New Jersey apartment rentals, and vacation rental in Elmwood Park New Jersey
Rental apartment in Bernards New Jersey and houses for rent in Bernards
Holiday rentals Elmwood Park New Jersey, houses for rent in Elmwood Park New Jersey, and rental home in Elmwood Park New Jersey
Rental home in Rockaway New Jersey, condo rentals Rockaway, homes for rent by owner, and Rockaway New Jersey houses for rent
Barnegat New Jersey vacation homes and rental houses
Send enticing and ravishing score regarding apartments for rent, condos for rent in Winslow New Jersey, and Winslow New Jersey rental apartment found on this website, FRBO.com.
Dig up, learn, and contrive the section and handy Winslow New Jersey state.
Determine and look up rent houses and for rent by owner homes in Wrightstown United States.
Locate, identify, and discern vacation rental in Morris New Jersey, rent houses in Morris New Jersey, vacation rental, and rent house.
This extensive website, FRBO.com can induct, muster, and incorporate suburban online MLS, ski in/out classified advertisements, lakeside ad directories, and penthouse advertisements beachfront lists of marked properties and lake online MLS to assist your Winslow New Jersey junket.
Winslow property brokers and home owners list for rent by owner homes in Winslow New Jersey, rental home Winslow New Jersey, rent houses in Winslow New Jersey, and homes for rent by owner.
Sightseers, renters, and colleagues chase after, investigate, and explore FRBO.com and find out rustic home, hillside townhouse, lakefront castle, and private duplex.
Ascertain, debunk, and ascertain Atco United States vacation homes for rent by owner, real estate rentals, and homes for rent in Atco United States.
Discern, relocate, and find Stockholm United States homes for rent, Stockholm bed and breakfast rentals, and rental properties in Stockholm.
FRBO.Com, For Rent By Owner, does embrace distinctive city resort and hidden home, castle, castle, and condominiums.
Travelers, comrades, and citizens who are beating about vacation homes Winslow New Jersey and are trying to determine vacation homes for rent by owner in Winslow and Winslow house rentals can probe our online website, FRBO.com and our city listed properties, private ads, and loft directories.
You can cast about the penthouse lists of marked properties, secluded listings, and lakeside indexes under condos for rent Winslow New Jersey, house rentals Winslow New Jersey, and Winslow New Jersey rental houses.
Design and find out condos for rent in Franklinville United States and Franklinville United States apartments for rent.
Detect, elicit, and uncover Cape May New Jersey vacation homes, Cape May homes for rent, and rental homes in Cape May New Jersey.
Identify, find out, and determine house rentals in Cape May, Cape May rent house, and Cape May real estate rentals.
Winslow New Jersey quarter employs many home owners, agents, and real estate agents.
|
|
