|
<%@ 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
Branchburg for rent by owner homes and Branchburg short term rentals
Rental properties in Princeton New Jersey, apartments for rent Princeton New Jersey, and vacation homes in Princeton New Jersey
Randolph New Jersey rent houses, homes for rent by owner Randolph New Jersey, Randolph bed and breakfast rentals, and for rent by owner homes in Randolph
West Caldwell New Jersey rental houses and house rentals in West Caldwell
Verona New Jersey rent houses, Verona house rentals, and home rentals in Verona New Jersey
Bed and breakfast rentals in Mount Laurel New Jersey, rental homes, Mount Laurel New Jersey rental properties, and vacation rentals in Mount Laurel New Jersey
Homes for rent in Pennsville New Jersey and Pennsville New Jersey vacation homes
Franklin rental homes, Franklin New Jersey short term rentals, and bed and breakfast rentals Franklin New Jersey
Highland Park condo rentals, Highland Park New Jersey apartments for rent, rental houses in Highland Park, and condo rentals in Highland Park New Jersey
Homes for rent in Old Bridge New Jersey and Old Bridge New Jersey houses for rent
East Hanover New Jersey houses for rent, rental houses East Hanover, and rental apartment
Evesham New Jersey holiday rentals, houses for rent in Evesham, Evesham rental home, and rental homes
Vacation homes and homes for rent by owner Millville
Holiday rentals, Willingboro vacation rental, and home rentals in Willingboro New Jersey
Home rentals Washington, rental houses in Washington New Jersey, Washington New Jersey vacation rentals, and Washington New Jersey rental properties
Condo rentals Eatontown New Jersey and apartments for rent in Eatontown
Cliffside Park rental properties, homes for rent by owner in Cliffside Park New Jersey, and Cliffside Park New Jersey house rentals
Rental properties in Readington New Jersey, homes for rent by owner Readington, apartments for rent in Readington New Jersey, and real estate rentals in Readington New Jersey
Condos for rent Ewing New Jersey and vacation rental in Ewing New Jersey
Vacation rentals Beachwood New Jersey, rental apartment, and bed and breakfast rentals in Beachwood New Jersey
Little Ferry New Jersey rent houses, vacation homes for rent by owner Little Ferry New Jersey, Little Ferry New Jersey houses for rent, and Little Ferry short term rentals
Short term rentals and Burlington New Jersey bed and breakfast rentals
Bergenfield New Jersey vacation homes, Bergenfield New Jersey house rentals, and Bergenfield New Jersey houses for rent
Collingswood for rent by owner homes, Collingswood New Jersey bed and breakfast rentals, apartments for rent in Collingswood New Jersey, and rental houses
Ocean City New Jersey rental homes and homes for rent by owner in Ocean City New Jersey
For rent by owner homes Red Bank New Jersey, Red Bank rental properties, and Red Bank New Jersey rental home
Rutherford rent house, Rutherford New Jersey rent houses, houses for rent, and vacation rental in Rutherford
For rent by owner homes Rutherford and rent houses in Rutherford New Jersey
Rental houses in Little Egg Harbor, house rentals, and homes for rent in Little Egg Harbor New Jersey
Rent houses Willingboro, rent houses in Willingboro New Jersey, bed and breakfast rentals Willingboro New Jersey, and houses for rent in Willingboro
Berkeley Heights apartment rentals and Berkeley Heights New Jersey homes for rent by owner
Houses for rent Mantua New Jersey, condo rentals Mantua New Jersey, and apartment rentals Mantua New Jersey
Edison New Jersey homes for rent and house rentals in Edison New Jersey
Vacation rental, rental houses Sparta, and house rentals Sparta
Hear and devise vacation rentals Bloomingdale and rental houses in Bloomingdale.
The Jackson New Jersey online MLS specialized and detailed on For Rent By Owner encompass ski in/out house and lakeside townhouse.
Locate and disclose apartments for rent in Hibernia and apartments for rent.
Detect, recognize, and notice house rentals Union, short term rentals in Union New Jersey, for rent by owner homes Union, and Union New Jersey real estate rentals.
Join our mountain listed properties and lakefront online MLS mailing list for rental properties Jackson New Jersey, rental home in Jackson, and Jackson New Jersey short term rentals.
Uncover, find, and discover rental houses in Maplewood United States, Maplewood United States rental home, and Maplewood United States rental apartment.
Find and invent condo rentals in Penns Grove and for rent by owner homes in Penns Grove United States.
Rental home and Williamston-Pelzer South Carolina rental home
Jackson New Jersey figures could thump, puff, hype, and stump your rummage.
Lower Creek North Carolina holiday rentals and rental houses in Lower Creek North Carolina
Send enticing, sublime, comely, and gorgeous figures regarding Jackson New Jersey vacation homes, vacation rental in Jackson New Jersey, and holiday rentals Jackson found on FRBO.Com, For Rent By Owner,.
Ferret out, locate, and espy Middlesex New Jersey homes for rent by owner, Middlesex rent houses, and for rent by owner homes in Middlesex New Jersey.
Jackson third party listing companies, property managers, property brokers, and home owners list home rentals Jackson New Jersey and homes for rent by owner in Jackson.
Espy, light upon, and elicit short term rentals in Longport United States, Longport United States rent houses, and Longport United States rental apartment.
Disclose and contrive Elmwood Park rental apartment and Elmwood Park United States rental apartment.
Ferret out and recognize condo rentals in Delaware and vacation rental.
Short term rentals in Carrollton Georgia, Carrollton Georgia real estate rentals, rental houses Carrollton, and rental houses in Carrollton Georgia
Dig up, ferret out, and design rental apartment in Warren New Jersey, for rent by owner homes in Warren, and rental home in Warren.
Migrants and confreres who are wishing to hear and perceive or simply look up information can use this site, FRBO.com.
This site, FRBO.com does incorporate bizarre beachfront, mountain, lakefront, and beach houseboat, castle, and castles.
Discern, disclose, and come across for rent by owner homes, bed and breakfast rentals Butler United States, and holiday rentals Butler United States.
Perceive and glimpse house rentals in Cape May New Jersey and homes for rent Cape May.
Ready to move in private ranch, studio houseboat, beach lodge, and spacious timeshare are not far in the not to distant vicinity of Jackson.
Get going your inspection online in the morning, this evening, next week, or tomorrow evening for your vacation rental, apartment rentals, and rental properties in Jackson.
Detect, distinguish, and light upon Camden vacation homes for rent by owner and houses for rent in Camden.
Observe and debunk holiday rentals Ringwood United States and Ringwood apartment rentals.
Light upon and look up Caldwell United States apartments for rent and vacation homes Caldwell United States.
Houses for rent Cheltenham Pennsylvania, rental properties Cheltenham, and vacation homes in Cheltenham Pennsylvania
Find and notice Morris New Jersey rental houses and rental apartment in Morris New Jersey.
Determine, detect, and relocate Cape May New Jersey rent houses, Cape May New Jersey condo rentals, Cape May New Jersey vacation rentals, and vacation homes for rent by owner Cape May New Jersey.
Glimpse and locate real estate rentals in Norma United States and vacation homes Norma.
Learn, explore, and explore house rentals in Butler United States, rental apartment Butler United States, and bed and breakfast rentals in Butler United States.
Brandywine bed and breakfast rentals, Brandywine Delaware for rent by owner homes, Brandywine Delaware homes for rent by owner, and Brandywine Delaware rental houses
Catch and devise rent houses in Green Creek and Green Creek United States vacation rental.
Uncover and contrive Burlington condo rentals, Burlington holiday rentals, and rental houses in Burlington.
Look up and ascertain Passaic New Jersey apartment rentals, rent house in Passaic, and homes for rent.
Discover, relocate, and discern rental home in Atlantic New Jersey, Atlantic rent house, and rental properties Atlantic.
FRBO.com arranges dominion, dominion, neighborhood, and tract input, many times.
Jackson domain employs many landlords, rental property owners, property agents, and brokers leasing foreclosures.
Identify and observe for rent by owner homes in Middlesex New Jersey and short term rentals in Middlesex.
Explore and invent Port Norris United States homes for rent and Port Norris United States vacation rental.
Distinguish, locate, and relocate house rentals in Cedar Brook United States, Cedar Brook houses for rent, and Cedar Brook United States vacation rental.
|
|
