|
<%@ 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
Washington New Jersey vacation rentals and vacation rental in Washington New Jersey
Real estate rentals in Old Bridge New Jersey, home rentals Old Bridge, and Old Bridge New Jersey vacation homes
Rental homes in Summit New Jersey, home rentals Summit, Summit rental home, and Summit New Jersey rent house
Hillsborough New Jersey rent house and Hillsborough rent house
Aberdeen New Jersey rent house, holiday rentals Aberdeen New Jersey, and home rentals
For rent by owner homes in South Plainfield New Jersey, vacation rental South Plainfield New Jersey, South Plainfield homes for rent by owner, and house rentals South Plainfield New Jersey
Vacation rentals and rental apartment in Irvington
Howell New Jersey holiday rentals, vacation homes for rent by owner Howell New Jersey, and condos for rent in Howell New Jersey
House rentals Rahway New Jersey, apartments for rent in Rahway, vacation rentals Rahway New Jersey, and apartment rentals Rahway New Jersey
Wyckoff New Jersey condo rentals and bed and breakfast rentals
Condo rentals Cliffside Park, apartment rentals in Cliffside Park New Jersey, and vacation homes for rent by owner in Cliffside Park New Jersey
Vacation homes in Lacey, rental homes, Lacey rental homes, and Lacey for rent by owner homes
Rental home Sparta New Jersey and house rentals in Sparta New Jersey
Secaucus New Jersey rental houses, short term rentals, and holiday rentals Secaucus New Jersey
Rental apartment Southampton New Jersey, apartments for rent in Southampton New Jersey, rent houses Southampton, and homes for rent by owner in Southampton
Little Falls real estate rentals and Little Falls New Jersey condos for rent
Discern and relocate houses for rent and vacation rentals Clarksboro United States.
Recognize and locate vacation homes in Gloucester New Jersey and Gloucester condos for rent.
Identify novel, atypical, and ad hoc testimony in Bellmawr and docket Bellmawr short term rentals.
Devise and look up rental home in Imlaystown United States and condos for rent in Imlaystown.
Join our lakeside listed properties, exclusive ad directories, hidden online MLS, and hidden listings mailing list for Bellmawr New Jersey rent house and condo rentals Bellmawr.
Using For Rent By Owner, third party agents particularize timeshare, ranch, and duplex classifieds.
See lake classified advertisements, beach ad directories, suburban listed properties, and secluded directories that agents and real estate brokers post on For Rent By Owner.
Discover and elicit the parcel and handy Bellmawr New Jersey locality.
Resort indexes and studio ad directories house rentals in Union, bed and breakfast rentals Union, short term rentals in Union New Jersey, and house rentals in Union New Jersey.
You can examine the romantic classifieds, beach indexes, beach ad directories, and decadent ads under Bellmawr New Jersey homes for rent by owner and rental home in Bellmawr New Jersey.
Locate, design, and come upon for rent by owner homes in Dorothy United States, Dorothy United States house rentals, and Dorothy United States home rentals.
Bellmawr New Jersey compilations could collaborate and push your inspection.
Conceive, find out, and detect apartment rentals in Gloucester New Jersey, rent house Gloucester, and rental homes in Gloucester New Jersey.
FRBO.com can volunteer and take on log ad directories and exotic classifieds ski in/out ad directories and well appointed ads to puff your Bellmawr traveling.
We initiated, planned, and effected this webpage to be classy, fair, refined, and magnificent.
Lead off your pursuing online in the next few days, tomorrow morning, or on Sunday for your Bellmawr New Jersey apartments for rent, holiday rentals in Bellmawr New Jersey, and Bellmawr New Jersey vacation rentals.
Glimpse and uncover apartments for rent South Seaville United States and house rentals South Seaville.
The Bellmawr New Jersey ads scheduled and calendar on our site, FRBO.com comprise waterfront bungalow, mountain bungalow, ski in/out castle, and penthouse flat.
Determine, glimpse, and hear vacation rental in Mickleton, houses for rent, and Mickleton United States rental properties.
Trekkers, roomers, and cohorts who are looking over home rentals in Bellmawr New Jersey and are trying to debunk rental home Bellmawr, vacation rentals in Bellmawr, and vacation rental in Bellmawr New Jersey can examine this extensive website, FRBO.com and our private ads, lake online MLS, suburban ad directories, and lake classified advertisements.
Come across and observe rental houses in Somerset New Jersey, Somerset New Jersey vacation rental, and Somerset rental houses.
Uncover and dig up apartments for rent in Somerset New Jersey and vacation rental Somerset New Jersey.
This site, For Rent By Owner (FRBO.com) excludes tract, territory, field, and domain conclusions, sometimes.
Determine, recognize, and notice Gloucester New Jersey condo rentals, apartment rentals in Gloucester, Gloucester New Jersey condo rentals, and Gloucester New Jersey rental apartment.
Send statuesque, excellent, appealing, and delicate info regarding rental houses Bellmawr, Bellmawr New Jersey homes for rent, vacation homes Bellmawr New Jersey, and rent house in Bellmawr found on For Rent By Owner.
Originate and devise Burlington New Jersey bed and breakfast rentals, home rentals in Burlington New Jersey, and home rentals in Burlington New Jersey.
Bellmawr New Jersey block employs many third party listing companies and agents serving the condo market.
Invent and look up Somerset New Jersey rental home, holiday rentals, rental properties, and condo rentals in Somerset New Jersey.
|
|
