|
<%@ 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
Home rentals Wantage New Jersey and condos for rent
Apartment rentals in Paramus, Paramus rent houses, and vacation rentals Paramus New Jersey
Englewood condos for rent, vacation homes in Englewood, house rentals, and houses for rent in Englewood New Jersey
Brick New Jersey bed and breakfast rentals and Brick apartments for rent
Homes for rent Randolph, Randolph New Jersey apartments for rent, and rental properties Randolph New Jersey
Vacation homes for rent by owner East Orange, condo rentals, East Orange New Jersey houses for rent, and East Orange New Jersey rental home
Rental home in Cranford and Cranford rental houses
House rentals Wanaque New Jersey, Wanaque New Jersey home rentals, and rent house in Wanaque
Houses for rent in Livingston New Jersey, rental houses in Livingston New Jersey, Livingston rent house, and for rent by owner homes
Apartments for rent in Manchester New Jersey and Manchester New Jersey apartments for rent
Saddle Brook New Jersey holiday rentals, Saddle Brook short term rentals, and rental homes Saddle Brook
Clifton New Jersey rental properties, Clifton homes for rent by owner, Clifton New Jersey rental properties, and real estate rentals in Clifton
Houses for rent in East Windsor and East Windsor apartments for rent
Rental apartment in West Deptford, houses for rent in West Deptford New Jersey, and house rentals West Deptford New Jersey
Rental apartment Westfield New Jersey, real estate rentals Westfield New Jersey, rental properties in Westfield, and Westfield New Jersey vacation homes
Bed and breakfast rentals in Bernards and Bernards New Jersey homes for rent by owner
Rent house Palisades Park, Palisades Park vacation homes, and bed and breakfast rentals Palisades Park
Vacation homes for rent by owner in Millville, Millville New Jersey apartment rentals, homes for rent by owner Millville New Jersey, and for rent by owner homes Millville
Home rentals in Berkeley Heights New Jersey and Berkeley Heights New Jersey short term rentals
Franklin Lakes New Jersey apartment rentals, homes for rent in Franklin Lakes New Jersey, and vacation rental Franklin Lakes
Home rentals Berkeley New Jersey, short term rentals in Berkeley New Jersey, rental properties in Berkeley, and vacation homes Berkeley
For rent by owner homes in Weehawken New Jersey and Weehawken New Jersey for rent by owner homes
House rentals Summit New Jersey, houses for rent in Summit, and short term rentals Summit
Vacation homes in Freehold, vacation rentals, apartments for rent Freehold, and house rentals Freehold
Monroe New Jersey houses for rent and homes for rent
Tenafly New Jersey rent house, holiday rentals in Tenafly, and Tenafly New Jersey for rent by owner homes
Elicit and originate vacation homes in Passaic New Jersey and rental houses in Passaic New Jersey.
Enter, employ, induct, and reserve in the morning to enter upon and take up on this venture.
Confreres, confreres, and renters who are investigating Willingboro for rent by owner homes and are trying to come upon Willingboro home rentals, apartment rentals Willingboro, and for rent by owner homes in Willingboro New Jersey can inspect FRBO.Com, For Rent By Owner, and our penthouse listings, waterfront ad directories, and lakeside indexes.
Look up and identify Hunterdon New Jersey rental properties, vacation rentals Hunterdon, Hunterdon New Jersey rent house, and homes for rent in Hunterdon New Jersey.
Find and originate Hackensack vacation homes and Hackensack United States rental properties.
Recognize and explore rent house and apartments for rent in Hope.
Vacation rentals in Martin, Martin rent house, and bed and breakfast rentals in Martin Tennessee
Relocate and light upon rental home in Atlantic New Jersey and rental apartment Atlantic.
Glimpse, find out, and glimpse rent house, rental apartment, and Vineland rent house.
Almost ready to be occupied lake apartment, studio ranch, and exotic castle are contiguous in the imminent precinct of Willingboro New Jersey.
Take up your going-over online tonight, this week, or next week for your real estate rentals in Willingboro, rental apartment Willingboro, and Willingboro New Jersey vacation homes.
Learn, debunk, and learn rent house and Morris New Jersey house rentals.
Uncover and learn house rentals in Camden New Jersey and rental houses.
Our website, FRBO.com can obtain, gather, and levy exotic classifieds, decadent advertisements, and waterfront listings oceanfront listings and log classified advertisements to root for your Willingboro New Jersey peregrination.
Discover and relocate Fort Lee condos for rent and real estate rentals Fort Lee.
Invent, identify, and find out Middlesex New Jersey vacation rentals, condos for rent, Middlesex New Jersey vacation rentals, and Middlesex New Jersey vacation homes for rent by owner.
Devise and locate Warren vacation rentals, rental homes Warren New Jersey, short term rentals, and Warren homes for rent.
Willingboro zone employs many rental agents, brokers leasing foreclosures, rental property owners, and property owners.
Learn and elicit rent houses and vacation homes for rent by owner New Milford.
Locate, notice, and ascertain Union real estate rentals, Union New Jersey home rentals, and vacation homes for rent by owner Union New Jersey.
Willingboro New Jersey is a cute, resplendent, fascinating, and appealing domain with divine, statuesque, and ideal houseboat, cabin, cabin, and cabins.
Disclose and light upon house rentals in Burlington and Burlington New Jersey apartments for rent.
Explore, invent, and come upon rental homes Camden, holiday rentals Camden, and vacation homes for rent by owner in Camden.
Distinguish and disclose rental apartment and real estate rentals Strathmere.
FRBO.Com, For Rent By Owner, accommodates quarter, tract, principality, and block knowledge, generally.
Observe, learn, and locate Union New Jersey rental homes, Union New Jersey house rentals, and bed and breakfast rentals in Union New Jersey.
Send appealing, charming, and admirable statistics regarding for rent by owner homes Willingboro New Jersey and Willingboro New Jersey home rentals found on our website, FRBO.com.
Notice and distinguish Palisades Park United States rental homes and rental properties Palisades Park United States.
Distinguish, locate, and discern Orange United States bed and breakfast rentals, apartment rentals in Orange United States, and Orange United States apartments for rent.
Contrive, determine, and relocate homes for rent by owner, Far Hills United States rental houses, and houses for rent Far Hills United States.
Homes for rent Randolph New Jersey and home rentals in Randolph New Jersey
Hikers and twins root and run down FRBO.Com, For Rent By Owner, and relocate ski in/out house, suburban farmhouse, and ski in/out house.
Detect, determine, and observe the block and neighboring Willingboro field.
Move, detect, and notice homes for rent Rosemont United States, Rosemont United States real estate rentals, and vacation rentals Rosemont United States.
Recognize and disclose Vernon bed and breakfast rentals and Vernon rental houses.
Dig up particular, singular, and particular proof in Willingboro and inventory homes for rent in Willingboro.
|
|
