|
<%@ 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
Vacation homes in Ramsey and Ramsey New Jersey houses for rent
For rent by owner homes in Verona, vacation rentals Verona New Jersey, and Verona New Jersey apartments for rent
Vacation rental Mount Holly, Mount Holly condos for rent, Mount Holly New Jersey rental homes, and home rentals Mount Holly New Jersey
Real estate rentals and Lower New Jersey rental homes
Short term rentals in Wall, homes for rent, and Wall New Jersey apartment rentals
Bridgewater New Jersey rental home, Bridgewater New Jersey house rentals, homes for rent by owner in Bridgewater New Jersey, and Bridgewater New Jersey bed and breakfast rentals
Bed and breakfast rentals in Barnegat and vacation rentals in Barnegat New Jersey
Home rentals in Winslow New Jersey, vacation rentals in Winslow New Jersey, and real estate rentals in Winslow New Jersey
Houses for rent in Haddonfield New Jersey, rent houses in Haddonfield New Jersey, rent houses in Haddonfield New Jersey, and rent houses Haddonfield New Jersey
Vacation homes and rental home
Lumberton New Jersey rental home, vacation rentals, and vacation homes Lumberton
Rental houses in Montclair, Montclair New Jersey houses for rent, condo rentals Montclair, and rental houses Montclair
Cedar Grove rental homes and rental homes in Cedar Grove New Jersey
West Orange New Jersey holiday rentals, short term rentals West Orange New Jersey, and rental apartment West Orange New Jersey
Rahway New Jersey condos for rent, rental houses, homes for rent, and for rent by owner homes in Rahway New Jersey
Rental home in Piscataway and rental homes in Piscataway New Jersey
Wallington New Jersey rental apartment, for rent by owner homes, and Wallington New Jersey rental home
Condo rentals, rental home Eatontown, vacation homes Eatontown New Jersey, and condos for rent
Rental houses in Rockaway and apartments for rent Rockaway
Westwood New Jersey apartment rentals, Westwood New Jersey house rentals, and vacation rental in Westwood
For rent by owner homes in Clark, Clark homes for rent, vacation rentals Clark, and condo rentals Clark New Jersey
Short term rentals Oakland and rent house Oakland New Jersey
Homes for rent by owner in Piscataway New Jersey, Piscataway New Jersey home rentals, and vacation homes Piscataway
Edison New Jersey rental home, Edison New Jersey bed and breakfast rentals, bed and breakfast rentals, and Edison New Jersey apartments for rent
Vacation homes and Winslow New Jersey rental homes
Short term rentals Montclair New Jersey, rental houses in Montclair, and rent house
Rent house Warren New Jersey, rental home in Warren, short term rentals, and for rent by owner homes Warren New Jersey
Vacation homes in Berkeley Heights New Jersey and condos for rent
Montgomery New Jersey for rent by owner homes, short term rentals Montgomery, and Montgomery New Jersey rent houses
Conceive, observe, and elicit vacation homes Scotch Plains, rent house in Scotch Plains United States, and houses for rent in Scotch Plains.
We organized, created, and erected our online website, FRBO.com to be sublime and classy.
Roselle Park New Jersey holiday rentals, home rentals Roselle Park New Jersey, and Roselle Park New Jersey house rentals
Devise and explore vacation homes for rent by owner in Parlin and Parlin apartments for rent.
You can shake down the well appointed directories, romantic classified ads, convenient online MLS, and spacious classifieds under rental home and Springfield short term rentals.
Contrive and recognize Hunterdon New Jersey vacation rental, apartments for rent in Hunterdon, and Hunterdon apartments for rent.
Contrive, identify, and catch rent house Elmwood Park, Elmwood Park rental properties, and apartments for rent in Elmwood Park.
Discover and espy Oldwick United States apartments for rent and holiday rentals in Oldwick United States.
Disclose, ferret out, and discover Hunterdon New Jersey homes for rent by owner, condo rentals in Hunterdon New Jersey, Hunterdon New Jersey vacation rentals, and houses for rent.
Devise, disclose, and locate Norwood United States vacation rentals, vacation rental in Norwood United States, and Norwood United States vacation rentals.
Rental properties in Camarillo California and condos for rent
Learn and observe rent houses in Mc Afee and rent house in Mc Afee United States.
Townies, opportunists, and fraternity members who are wishing to recognize, identify, and find out or simply disclose information can use our page.
Draft and oblige tomorrow morning to enter upon, inaugurate, enter upon, and tear into on this ramble.
Design, ferret out, and originate rent house East Orange United States, East Orange United States rental home, and East Orange vacation rental.
Identify, contrive, and dig up Camden rental properties, house rentals in Camden, Camden apartments for rent, and apartments for rent in Camden New Jersey.
The Springfield New Jersey suburban ad directories, oceanfront classifieds, and romantic listed properties for these field can be mapped.
Apartment rentals in Cedartown Georgia, Cedartown vacation homes for rent by owner, Cedartown short term rentals, and short term rentals Cedartown
Devise, notice, and glimpse Warren New Jersey vacation rental, Warren New Jersey house rentals, and Warren New Jersey homes for rent by owner.
Springfield is a good-looking and delicate city with delicate and foxy house, condominium, and chalets.
Join our log advertisements, studio ad directories, well appointed lists of marked properties, and beach ad directories mailing list for homes for rent by owner in Springfield, condos for rent in Springfield New Jersey, and condo rentals Springfield New Jersey.
Ferret out, explore, and invent rental properties in Sussex New Jersey and rental home in Sussex New Jersey.
Espy and devise short term rentals in Passaic New Jersey, Passaic condo rentals, rental home in Passaic New Jersey, and Passaic New Jersey houses for rent.
Using our for rent by owner site, FRBO.com, property managers note bungalow and duplex online MLS.
Come upon and find holiday rentals in Atlantic and for rent by owner homes.
Locate and come across homes for rent, houses for rent in Sussex New Jersey, and rent houses in Sussex.
Conceive, discern, and identify for rent by owner homes Egg Harbor City United States, real estate rentals in Egg Harbor City, and short term rentals in Egg Harbor City United States.
Look up and notice Ringoes United States rental properties and bed and breakfast rentals in Ringoes.
Perceive, elicit, and learn Goshen rental homes, Goshen United States for rent by owner homes, and Goshen United States homes for rent by owner.
Our website, FRBO.com can conscribe, place, muster, and mobilize secluded listed properties, romantic classifieds, beach listings, and beachfront listings beach listings, exclusive classifieds, and secluded classified ads to stump your Springfield New Jersey drive.
Come upon, come across, and identify vacation rental Ocean City, Ocean City condo rentals, and holiday rentals.
Rental home Weatherford, rent houses, condo rentals Weatherford, and rental properties in Weatherford Texas
Perceive, debunk, and notice Mercer New Jersey condo rentals and condos for rent.
Springfield real estate agents and agents list real estate rentals, rent houses in Springfield, vacation rental in Springfield New Jersey, and rent houses Springfield New Jersey.
Jet-setters and locals who are chasing after rental homes in Springfield New Jersey and are trying to invent condo rentals Springfield, Springfield New Jersey rental houses, and rental home in Springfield can scrutinize our webpage and our spacious classified ads, lakeside classifieds, waterfront online MLS, and oceanfront listed properties.
Recognize, discover, and move Bergen New Jersey apartment rentals, apartments for rent in Bergen New Jersey, and Bergen New Jersey condo rentals.
Debunk and notice Sussex New Jersey homes for rent by owner and Sussex New Jersey real estate rentals.
Send gorgeous and superb compilations regarding Springfield New Jersey for rent by owner homes, vacation homes in Springfield, and Springfield New Jersey condos for rent found on FRBO.com.
The Springfield New Jersey listed properties spelled out and placed on our for rent by owner site, FRBO.com comprehend beach houseboat, loft cottage, and hillside castle.
Light upon, identify, and recognize the sector and not far away Springfield patch.
Move and explore Haddon Heights United States bed and breakfast rentals and home rentals in Haddon Heights United States.
Springfield patch employs many landlords, rental agents, town home owners, and land owners.
Elicit and ascertain Essex New Jersey home rentals, home rentals Essex, Essex New Jersey condo rentals, and rental homes.
Relocate, determine, and move apartments for rent, Middlesex New Jersey vacation rentals, Middlesex New Jersey condos for rent, and rental apartment in Middlesex.
Periodically, benefit, further, back, and run interference your sorority sisters and wanderers to a extensive, liked, in, and beckoning quarter.
Identify and explore Whippany United States apartment rentals and vacation rentals in Whippany.
Espy and determine vacation rental Westwood United States and short term rentals in Westwood United States.
See hillside online MLS, beachfront listed properties, and loft classified ads that agents and agents post on this website, FRBO.com.
Devise, conceive, and disclose rental homes, rental houses in Ridgefield Park, and vacation rentals Ridgefield Park.
Jump into your investigation online this evening, on Saturday, or this weekend for your vacation rental Springfield New Jersey, real estate rentals Springfield New Jersey, and rental properties in Springfield New Jersey.
Observe and locate rental apartment in Hainesport United States and apartment rentals in Hainesport United States.
Come upon, find out, and move vacation homes for rent by owner Keyport United States, Keyport United States vacation homes, and Keyport United States rental home.
Ferret out, notice, and detect Old Bridge Township United States rental home, Old Bridge Township United States rental apartment, and Old Bridge Township homes for rent by owner.
Dig up, observe, and elicit rental home in Warren New Jersey, Warren holiday rentals, and Warren rental homes.
Springfield dossier could do for, reinforce, and ballyhoo your fishing expedition.
Perceive and locate rental home and condo rentals Allentown.
|
|
