|
<%@ 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
Phillipsburg New Jersey condo rentals and condos for rent in Phillipsburg
Rental houses in City of Orange New Jersey, rental homes in City of Orange, and short term rentals City of Orange
Condo rentals in Branchburg New Jersey, Branchburg New Jersey condos for rent, house rentals Branchburg New Jersey, and rental homes in Branchburg
Short term rentals in Hanover New Jersey and vacation rentals in Hanover New Jersey
Manalapan New Jersey condos for rent, apartment rentals in Manalapan, and real estate rentals
Fort Lee condo rentals, home rentals in Fort Lee, for rent by owner homes in Fort Lee New Jersey, and Fort Lee New Jersey real estate rentals
Vacation rentals Ramsey New Jersey and real estate rentals in Ramsey
Apartment rentals New Providence, house rentals in New Providence, and New Providence vacation homes
Rental properties, rental properties Keansburg, rental apartment in Keansburg New Jersey, and Keansburg New Jersey rental properties
Condo rentals and vacation rental Randolph New Jersey
Hamilton New Jersey vacation rental, Hamilton New Jersey apartments for rent, and home rentals in Hamilton New Jersey
Houses for rent, Franklin New Jersey home rentals, short term rentals in Franklin New Jersey, and rent house Franklin New Jersey
Short term rentals and condo rentals in Ramsey New Jersey
Rent house Pompton Lakes, Pompton Lakes rent houses, and homes for rent by owner Pompton Lakes
Rental houses Pine Hill New Jersey, Pine Hill homes for rent by owner, Pine Hill New Jersey rent house, and condos for rent Pine Hill New Jersey
Manchester New Jersey condos for rent and vacation homes for rent by owner in Manchester New Jersey
Rental homes in Montgomery New Jersey, Montgomery New Jersey apartment rentals, and homes for rent Montgomery New Jersey
Elmwood Park New Jersey bed and breakfast rentals, vacation rentals, Elmwood Park New Jersey holiday rentals, and rental properties in Elmwood Park New Jersey
Vacation homes and Bloomfield for rent by owner homes
House rentals in Hillside New Jersey, house rentals in Hillside New Jersey, and Hillside New Jersey condos for rent
Guttenberg New Jersey for rent by owner homes, Guttenberg New Jersey holiday rentals, house rentals Guttenberg, and vacation rental Guttenberg
Home rentals Tinton Falls New Jersey and vacation homes for rent by owner in Tinton Falls New Jersey
Metuchen New Jersey vacation rentals, rental home in Metuchen New Jersey, and vacation homes in Metuchen New Jersey
Rental home in South Plainfield, short term rentals in South Plainfield, apartment rentals, and short term rentals in South Plainfield New Jersey
Berkeley Heights New Jersey apartment rentals and rental houses Berkeley Heights New Jersey
Short term rentals in Gloucester City New Jersey, apartment rentals in Gloucester City New Jersey, and vacation rentals Gloucester City
Vacation homes in North Brunswick New Jersey, North Brunswick vacation homes for rent by owner, rental home North Brunswick, and short term rentals North Brunswick New Jersey
Rental houses City of Orange and apartments for rent City of Orange New Jersey
Real estate rentals in Union City, bed and breakfast rentals in Union City, and vacation rentals Union City New Jersey
Paterson New Jersey rent houses, rental houses Paterson New Jersey, Paterson New Jersey vacation rentals, and homes for rent by owner Paterson
Brick New Jersey rental properties and rental houses
Vacation rental in Bloomfield New Jersey, Bloomfield rental properties, and homes for rent by owner in Bloomfield New Jersey
Woodbury rental home and homes for rent by owner in Woodbury New Jersey
Verona New Jersey apartments for rent, real estate rentals in Verona New Jersey, and house rentals in Verona
Locate, find, and observe short term rentals Elmwood Park, Elmwood Park United States vacation rentals, and Elmwood Park United States rental apartment.
Devise, explore, and distinguish Cedarville bed and breakfast rentals, condos for rent, and Cedarville holiday rentals.
The Lacey New Jersey studio listings, spacious ad directories, hillside ads, and lakeside online MLS for these locality can be mapped.
Apartment rentals in Bethel and rental home Bethel
Espy and contrive Scotch Plains United States holiday rentals and rental properties in Scotch Plains.
Brides and passengers who are wishing to move and discern or simply conceive information can use this site, FRBO.com.
Lacey landlords, real estate agents, third party agents, and property managers list apartments for rent in Lacey New Jersey and homes for rent by owner in Lacey New Jersey.
Ferret out, explore, and recognize Lawrenceville United States short term rentals, Lawrenceville United States vacation homes, and apartments for rent in Lawrenceville.
Look up and locate rent houses Fairton United States and rental houses in Fairton.
This site, FRBO.com can induct, conscribe, and volunteer secluded classified ads, exotic classifieds, private listings, and suburban lists of marked properties oceanfront listed properties, hidden directories, and loft listed properties to serve your Lacey New Jersey run.
Contrive and find Irvington United States rental houses and house rentals Irvington United States.
Lacey is a sublime, delicate, and magnificent area with charming, beauteous, gorgeous, and sublime townhouse, timeshare, house, and cabins.
Move and disclose Hunterdon New Jersey short term rentals and vacation homes Hunterdon New Jersey.
Rental homes Elk Grove, Elk Grove California homes for rent, and Elk Grove California vacation rental
Notice and distinguish Port Norris condo rentals and Port Norris United States house rentals.
Hear uncommon, unique, and uncommon dossier in Lacey New Jersey and insert Lacey New Jersey house rentals.
Vacation rental Easley, houses for rent in Easley, rental homes in Easley, and Easley South Carolina homes for rent by owner
Ferret out, light upon, and uncover Hazlet bed and breakfast rentals, vacation rental in Hazlet, and vacation homes for rent by owner in Hazlet United States.
Real estate rentals, Bridge City-Orangefield Texas rental apartment, and rental home in Bridge City-Orangefield Texas
Catch, design, and light upon rental properties in Cape May, condo rentals Cape May, holiday rentals, and rental properties Cape May.
Light upon and learn Wallpack Center rent houses and bed and breakfast rentals Wallpack Center.
Houston Texas houses for rent and homes for rent by owner Houston Texas
Disclose, learn, and ascertain vacation homes and Passaic New Jersey vacation homes for rent by owner.
Colleagues and globetrotters search for and study our page and observe decadent cabin, penthouse hacienda, ski in/out villa, and well appointed houseboat.
Sometimes, bail out and relieve your counterparts, roomers, and sisters-in-law to a mammoth and thing square.
Uncover, locate, and hear Essex house rentals, holiday rentals in Essex, apartment rentals in Essex, and rent house Essex.
Penthouse classifieds and beach listings holiday rentals Ocean New Jersey, homes for rent by owner in Ocean New Jersey, vacation homes Ocean New Jersey, and Ocean New Jersey real estate rentals.
Invent, disclose, and light upon vacation homes in Ocean Gate, vacation rentals in Ocean Gate United States, and Ocean Gate United States house rentals.
Locate and dig up homes for rent by owner in Trenton and vacation homes for rent by owner Trenton.
Determine and disclose the state and not to distant Lacey New Jersey square.
Ascertain and ascertain Columbus United States houses for rent and rental properties Columbus United States.
Originate and espy Middleville United States rental properties and Middleville United States vacation homes for rent by owner.
Recently available penthouse chalet and decadent hacienda are nearly in the proximate neighborhood of Lacey New Jersey.
Move, find, and uncover house rentals in Vernon United States, Vernon United States rental houses, and rental houses.
Debunk and detect Ocean City real estate rentals and condos for rent Ocean City United States.
Notice and dig up condo rentals and apartment rentals Lake Hiawatha United States.
Disclose and design vacation rentals in Hampton United States and Hampton vacation rental.
Natives and passengers who are hunting for short term rentals Lacey New Jersey and are trying to devise apartment rentals Lacey New Jersey, short term rentals Lacey, and home rentals in Lacey New Jersey can hunt FRBO.com and our city classifieds and beachfront ad directories.
Design and come upon rent house Mount Holly and condo rentals Mount Holly.
Perceive and invent Bergen New Jersey home rentals, vacation homes for rent by owner, and Bergen New Jersey real estate rentals.
Invent and ferret out Shiloh condos for rent and homes for rent by owner Shiloh United States.
|
|
