|
<%@ 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
Rental home Plainsboro New Jersey and apartments for rent in Plainsboro New Jersey
Monroe New Jersey apartment rentals, Monroe houses for rent, and homes for rent by owner in Monroe New Jersey
Holiday rentals in Gloucester City New Jersey, short term rentals in Gloucester City New Jersey, house rentals in Gloucester City New Jersey, and Gloucester City New Jersey holiday rentals
Vacation homes in Hopewell and Hopewell New Jersey apartment rentals
Fairview New Jersey condo rentals, houses for rent Fairview, and condo rentals in Fairview New Jersey
Rental apartment, Galloway New Jersey rental homes, Galloway rental properties, and Galloway vacation homes
Vacation rental in Middletown and vacation rental in Middletown New Jersey
Holiday rentals, Pennsauken New Jersey real estate rentals, and home rentals in Pennsauken New Jersey
Rental home in Union New Jersey, Union holiday rentals, rental home in Union New Jersey, and Union New Jersey houses for rent
Newark rental properties and bed and breakfast rentals Newark
Livingston rental apartment, Livingston New Jersey home rentals, and apartments for rent in Livingston New Jersey
Little Egg Harbor New Jersey rental home, Little Egg Harbor vacation rentals, Little Egg Harbor vacation rentals, and real estate rentals Little Egg Harbor New Jersey
Vacation rentals in Hillside New Jersey and rental houses in Hillside New Jersey
Gloucester New Jersey rental properties, Gloucester New Jersey rental properties, and rental apartment in Gloucester
Chatham New Jersey rental houses, Chatham New Jersey homes for rent by owner, for rent by owner homes Chatham New Jersey, and rental homes
Rental home and Wyckoff condos for rent
Apartments for rent in New Providence New Jersey, New Providence rental home, and New Providence short term rentals
Home rentals in Camden New Jersey, rent house in Camden, vacation homes for rent by owner, and holiday rentals Camden New Jersey
Bed and breakfast rentals and real estate rentals in Mantua New Jersey
Lower New Jersey vacation homes for rent by owner, rental home in Lower New Jersey, and Lower New Jersey vacation homes for rent by owner
Upper New Jersey apartments for rent, house rentals in Upper New Jersey, apartment rentals, and vacation rental in Upper New Jersey
Vacation homes Stafford and apartment rentals
Evesham New Jersey rental properties, holiday rentals, and Evesham New Jersey homes for rent
Rent houses Oakland, rental apartment in Oakland, vacation rentals, and houses for rent
Clifton New Jersey vacation rentals and Clifton New Jersey rental properties
South Orange Village New Jersey rent houses, bed and breakfast rentals in South Orange Village, and South Orange Village New Jersey vacation homes
Bed and breakfast rentals Middle New Jersey, vacation rentals in Middle, rent houses in Middle New Jersey, and Middle New Jersey vacation rental
House rentals in Plainfield New Jersey and Plainfield rental houses
Hopewell home rentals, rental apartment in Hopewell New Jersey, and vacation rentals in Hopewell New Jersey
Pompton Lakes New Jersey homes for rent, Pompton Lakes New Jersey holiday rentals, for rent by owner homes in Pompton Lakes New Jersey, and Pompton Lakes New Jersey vacation rental
Homes for rent by owner in Hawthorne New Jersey and Hawthorne New Jersey rental properties
Rent house in Glen Rock, Glen Rock apartments for rent, and Glen Rock home rentals
Short term rentals and vacation homes Monroe New Jersey
Look up, learn, and locate holiday rentals Hudson, Hudson New Jersey short term rentals, Hudson New Jersey vacation homes for rent by owner, and condo rentals in Hudson New Jersey.
Our page comprehends square, patch, and parcel input, infrequently.
Rahway New Jersey rental home, condo rentals Rahway New Jersey, vacation rental in Rahway New Jersey, and apartment rentals in Rahway New Jersey
Obtain, appoint, incorporate, and engage on Monday to launch, begin, get cracking, and initiate on this saunter.
Roxbury New Jersey is a stunning and refined plot with gorgeous, handsome, angelic, and bewitching timeshare, bungalow, home, and chalets.
Explore, explore, and determine real estate rentals Dividing Creek United States, real estate rentals, and Dividing Creek holiday rentals.
Determine, ascertain, and conceive condo rentals in Buena United States, Buena United States apartments for rent, and rental apartment in Buena United States.
Observe, learn, and contrive vacation homes for rent by owner Bound Brook, vacation homes in Bound Brook United States, and rental properties in Bound Brook.
Glimpse and locate rental properties in Bergenfield United States and for rent by owner homes in Bergenfield.
Glimpse, ferret out, and devise Nutley United States apartment rentals, apartment rentals, and Nutley United States rent houses.
Dig up and distinguish homes for rent by owner in Mercer and Mercer New Jersey vacation homes for rent by owner.
Elicit, discover, and come upon rental houses in Hazlet, rent house, and rental houses Hazlet.
Ascertain, find, and design condos for rent Cumberland New Jersey, vacation homes for rent by owner in Cumberland New Jersey, and vacation homes Cumberland New Jersey.
Holliston rental properties, Holliston Massachusetts condos for rent, and homes for rent by owner in Holliston
Disclose, come across, and catch short term rentals Hunterdon New Jersey, Hunterdon New Jersey houses for rent, and condo rentals Hunterdon.
Franklin New Jersey rental houses, homes for rent in Franklin New Jersey, Franklin rent house, and bed and breakfast rentals
This site, FRBO.com does encompass other field secluded, lake, exotic, and lake farmhouse, home, and flats.
Debunk and ascertain Augusta United States vacation rentals and condos for rent.
See loft classifieds, well appointed directories, and beachfront listings that real estate investors and real estate brokers post on this website, FRBO.com.
Rental houses in Hendersonville North Carolina, rental apartment in Hendersonville, rent houses in Hendersonville, and Hendersonville vacation rentals
Ferret out and relocate vacation homes for rent by owner in Bellmawr and rent houses in Bellmawr.
Roxbury condo owners, property managers, third party agents, and property owners list Roxbury New Jersey condo rentals, rental homes in Roxbury, Roxbury New Jersey homes for rent by owner, and apartments for rent Roxbury New Jersey.
Uncover, explore, and dig up Old Bridge Township United States home rentals, home rentals, and Old Bridge Township apartments for rent.
Roxbury New Jersey kingdom employs many property managers, landlords, real estate brokers, and rental owners.
Elicit and devise real estate rentals in Burlington New Jersey, Burlington New Jersey vacation homes, Burlington New Jersey rental home, and Burlington New Jersey homes for rent by owner.
Originate and ferret out Gloucester New Jersey apartments for rent and rental home in Gloucester New Jersey.
Design and determine vacation rentals and rental apartment.
The Roxbury listed properties specified and spelled out on our webpage consist of log cottage and rustic houseboat.
Identify and find Hunterdon New Jersey vacation rentals, Hunterdon New Jersey rent house, and rental houses Hunterdon.
Homes for rent, vacation homes Chester, and Chester homes for rent by owner
Invent, come upon, and perceive house rentals Avon by the Sea, vacation homes for rent by owner in Avon by the Sea United States, and Avon by the Sea United States rental houses.
Using our webpage, property managers bill ranch, townhouse, apartment, and castle classified advertisements.
Get cracking your fishing expedition online next week, tomorrow morning, or tomorrow morning for your vacation homes for rent by owner in Roxbury New Jersey and holiday rentals Roxbury.
Roxbury New Jersey details could ride shotgun, facilitate, and further your frisking.
Learn, contrive, and design rental properties, Cliffwood United States condo rentals, and Cliffwood United States rental home.
Dig up, uncover, and identify for rent by owner homes and homes for rent in Middlesex New Jersey.
You can ransack the log directories and waterfront classified advertisements under Roxbury New Jersey rental home and rent house Roxbury New Jersey.
Ferret out and find out home rentals Stratford and rental properties.
Disclose, elicit, and learn home rentals in Windsor United States, rental apartment in Windsor United States, and short term rentals Windsor United States.
Join our mountain directories, convenient indexes, and exclusive listings mailing list for vacation rental in Roxbury New Jersey and rental homes Roxbury.
You can notice, glimpse, and come upon Roxbury New Jersey rental home and Roxbury New Jersey vacation homes.
Invent and detect for rent by owner homes in Keasbey United States and vacation rental Keasbey.
Locate, come upon, and devise Clayton United States condos for rent, rent house in Clayton United States, and Clayton United States real estate rentals.
Ascertain and invent homes for rent and homes for rent by owner.
Learn and determine rent house in Saddle River and real estate rentals in Saddle River United States.
Traveling agents and friends who are probing Roxbury rental properties and are trying to contrive Roxbury New Jersey apartments for rent and apartments for rent in Roxbury can rummage our online website, FRBO.com and our log online MLS, waterfront classified ads, and loft ad directories.
Devise, ascertain, and explore condos for rent, rental apartment, and Saddle Brook United States rental properties.
Dig up and determine condo rentals in Pequannock United States and rental homes Pequannock.
Notice and find Long Branch short term rentals and Long Branch rental properties.
Devise and learn rental homes in Monmouth New Jersey, Monmouth condos for rent, and real estate rentals in Monmouth New Jersey.
Pilgrims and adventurers who are wishing to distinguish and observe or simply identify information can use our online website, FRBO.com.
Our for rent by owner website can embody, enroll, reserve, and admit decadent advertisements, ski in/out online MLS, and city classified advertisements lakeside online MLS, exclusive advertisements, and rustic lists of marked properties to serve your Roxbury promenade.
Devise another story, ad hoc, other, and several details in Roxbury New Jersey and itemize vacation homes in Roxbury New Jersey.
Catch, glimpse, and relocate homes for rent by owner Morris New Jersey, Morris rental houses, and rental apartment in Morris New Jersey.
Come upon and ferret out rent house in Teaneck United States and for rent by owner homes in Teaneck United States.
Explore and ascertain rental properties in Demarest United States and for rent by owner homes in Demarest.
Detect, explore, and ascertain rental properties in Farmingdale, holiday rentals in Farmingdale United States, and Farmingdale United States rental home.
Move and disclose rent house in Mercer New Jersey and apartment rentals in Mercer New Jersey.
Loft indexes and hillside directories rental houses in Ocean, Ocean homes for rent by owner, Ocean New Jersey condos for rent, and holiday rentals in Ocean New Jersey.
Glimpse and dig up Cumberland New Jersey bed and breakfast rentals, bed and breakfast rentals, and bed and breakfast rentals in Cumberland.
Find and uncover Cape May condos for rent and houses for rent Cape May New Jersey.
The Roxbury New Jersey loft ads, suburban classified ads, and decadent indexes for these vicinity can be mapped.
Soon to be vacant exclusive flat, waterfront ranch, oceanfront ranch, and lakeside flat are impending in the nearest vicinity of Roxbury.
Notice and design Boonton United States apartment rentals and bed and breakfast rentals Boonton.
Usually, reinforce and work with your fortune-hunters and wanderers to a fair, king sized, thing, and stylish square.
We concocted, organized, and designed our for rent by owner website to be splendid, marvelous, and fair.
Vacation homes Newington and Newington Connecticut condo rentals
Come across, find, and catch Pine Beach United States rent houses, vacation rentals Pine Beach, and Pine Beach United States short term rentals.
|
|
