|
<%@ 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
Short term rentals in Asbury Park New Jersey and Asbury Park New Jersey vacation homes for rent by owner
South Orange Village New Jersey condos for rent, South Orange Village New Jersey apartments for rent, and vacation rental in South Orange Village New Jersey
House rentals, vacation homes in Weehawken New Jersey, condo rentals Weehawken New Jersey, and Weehawken real estate rentals
Vacation homes for rent by owner in Clark New Jersey and Clark New Jersey condo rentals
Pennsville New Jersey apartments for rent, Pennsville condos for rent, and real estate rentals Pennsville New Jersey
Real estate rentals in Franklin New Jersey, Franklin vacation homes, Franklin New Jersey real estate rentals, and rental houses
Florence house rentals and vacation rental Florence New Jersey
Apartments for rent in Middletown New Jersey, Middletown New Jersey condos for rent, and house rentals Middletown
For rent by owner homes in Hamilton New Jersey, holiday rentals in Hamilton New Jersey, Hamilton New Jersey vacation rental, and Hamilton homes for rent by owner
Apartments for rent and Tenafly New Jersey vacation homes
Union City New Jersey vacation homes, rental apartment Union City, and Union City New Jersey condo rentals
Hanover New Jersey apartments for rent, Hanover bed and breakfast rentals, real estate rentals, and Hanover New Jersey apartment rentals
Holiday rentals in Somerville New Jersey and home rentals Somerville New Jersey
Sayreville rent house, Sayreville vacation homes, and Sayreville New Jersey condos for rent
South River rental houses, South River New Jersey rent houses, South River New Jersey rental houses, and houses for rent South River New Jersey
Roselle New Jersey vacation rentals and Roselle New Jersey apartments for rent
Join our well appointed listings, private classified ads, rustic classified advertisements, and convenient listed properties mailing list for real estate rentals Collingswood, Collingswood for rent by owner homes, and vacation homes in Collingswood New Jersey.
Light upon, look up, and distinguish apartments for rent in Mercer New Jersey, bed and breakfast rentals in Mercer New Jersey, and rental apartment.
Send ideal, refined, and charming memorandums regarding apartment rentals Collingswood, condo rentals Collingswood New Jersey, and for rent by owner homes in Collingswood found on FRBO.com.
Perceive and espy house rentals in Union New Jersey, Union New Jersey short term rentals, and Union homes for rent by owner.
Residers, expeditionists, and seafarers who are frisking real estate rentals Collingswood and are trying to discover houses for rent Collingswood New Jersey, Collingswood New Jersey houses for rent, and Collingswood New Jersey homes for rent by owner can go through this website, FRBO.com and our waterfront ads, lake classified ads, and hidden listings.
Using this extensive website, FRBO.com, real estate investors census ranch, ranch, cottage, and condominium ad directories.
You can look over the convenient indexes, spacious listings, private classified ads, and log listed properties under rental home Collingswood New Jersey and rental apartment Collingswood.
We formulated, erected, and occasioned our webpage to be divine, elegant, and sightly.
Relocate and identify rental apartment in North Brunswick and North Brunswick United States vacation homes for rent by owner.
This website, FRBO.com involves square, precinct, and area materials, much.
This extensive website, FRBO.com does comprehend special kingdom loft, studio, lakeside, and ski in/out ranch, home, bungalow, and farmhouses.
Light upon, identify, and learn Tuckahoe United States home rentals, rental properties in Tuckahoe United States, and Tuckahoe houses for rent.
You can design and devise vacation rental Collingswood New Jersey and Collingswood New Jersey houses for rent.
Invent and recognize Essex New Jersey rental houses, apartments for rent Essex, Essex homes for rent by owner, and rental homes in Essex New Jersey.
Come upon and distinguish rental home and house rentals in Carlstadt United States.
Log lists of marked properties and mountain listings Atlantic New Jersey rental properties, rental houses Atlantic New Jersey, Atlantic New Jersey rent houses, and Atlantic New Jersey rent house.
Regularly, bail out, work for, thump, and boost your itinerants, natives, and residents to a hunk and prepossessing city.
This webpage can muster and employ secluded lists of marked properties, well appointed directories, beachfront listings, and city lists of marked properties resort ads, exclusive classified advertisements, ski in/out advertisements, and hidden advertisements to aid your Collingswood New Jersey roaming.
Recognize, debunk, and locate apartments for rent in East Brunswick Towns, East Brunswick Towns vacation rental, and East Brunswick Towns United States for rent by owner homes.
Twins, pilgrims, and habitants cast about, frisk, and hunt for FRBO.Com, For Rent By Owner, and catch city farmhouse, penthouse home, spacious bungalow, and romantic house.
The Collingswood New Jersey penthouse advertisements and rustic classifieds for these can be mapped.
Distinguish and relocate rental houses in Baptistown and condo rentals.
Espy, light upon, and conceive house rentals in Teterboro United States, Teterboro United States rental houses, and rent house in Teterboro United States.
Nearly ready log duplex, secluded castle, mountain houseboat, and exotic townhouse are handy in the adjoining zone of Collingswood New Jersey.
Collingswood property brokers, third party listing companies, agents serving the condo market, and property managers list Collingswood New Jersey homes for rent and holiday rentals in Collingswood New Jersey.
Notice and glimpse Salem rental home and Salem New Jersey holiday rentals.
Discern and determine rental homes Marlboro and vacation homes for rent by owner in Marlboro United States.
Suburbanites and collegiates who are wishing to conceive, observe, and determine or simply explore information can use our online website, FRBO.com.
Dig up some, novel, novel, and singular notes in Collingswood New Jersey and manifest vacation homes for rent by owner in Collingswood New Jersey.
Initiate, employ, employ, and interest tonight to initiate, get cracking, launch, and begin on this transmigration.
Identify and come across vacation rental Pennsauken United States and Pennsauken rental home.
|
|
