|
<%@ 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
Apartment rentals in Vineland New Jersey and houses for rent Vineland New Jersey
Rental houses in Saddle Brook New Jersey, rental apartment in Saddle Brook New Jersey, and homes for rent by owner in Saddle Brook
Homes for rent by owner, vacation homes for rent by owner, apartment rentals in Beachwood New Jersey, and Beachwood New Jersey houses for rent
South River homes for rent and South River New Jersey real estate rentals
Vacation rental, for rent by owner homes, and Saddle Brook New Jersey holiday rentals
Passaic holiday rentals, holiday rentals, Passaic New Jersey vacation homes, and rental homes Passaic
Vacation homes for rent by owner in Wayne and Wayne New Jersey rental apartment
Hamilton New Jersey rent house, condo rentals Hamilton, and for rent by owner homes Hamilton New Jersey
Neptune short term rentals, apartments for rent Neptune New Jersey, rental properties in Neptune New Jersey, and Neptune home rentals
Bed and breakfast rentals and bed and breakfast rentals in Clinton New Jersey
Apartments for rent Jackson, house rentals, and bed and breakfast rentals in Jackson New Jersey
Middlesex New Jersey holiday rentals, vacation rental in Middlesex New Jersey, apartments for rent, and condo rentals in Middlesex
Hoboken New Jersey rent houses and Hoboken New Jersey apartments for rent
Homes for rent in Mount Laurel New Jersey, Mount Laurel New Jersey vacation homes for rent by owner, and homes for rent by owner Mount Laurel
Rent house in Colts Neck New Jersey, short term rentals, homes for rent by owner Colts Neck New Jersey, and short term rentals Colts Neck
Holiday rentals and apartment rentals in Cherry Hill New Jersey
Rent houses in Bloomfield New Jersey, Bloomfield New Jersey homes for rent by owner, and holiday rentals in Bloomfield New Jersey
Millville condo rentals, Millville rental properties, vacation homes for rent by owner Millville New Jersey, and houses for rent in Millville
Short term rentals in Hillside New Jersey and Hillside New Jersey rental properties
Rent house in Saddle Brook New Jersey, Saddle Brook New Jersey for rent by owner homes, and Saddle Brook rental homes
Oakland New Jersey real estate rentals, rent houses in Oakland New Jersey, short term rentals Oakland New Jersey, and houses for rent
Union New Jersey rental home and homes for rent by owner Union
Holiday rentals in Linden New Jersey, Linden New Jersey for rent by owner homes, and rental houses Linden
Bed and breakfast rentals in Clinton New Jersey, house rentals, vacation homes in Clinton, and Clinton New Jersey home rentals
Harrison vacation homes and bed and breakfast rentals in Harrison New Jersey
Rental home in Egg Harbor New Jersey, condos for rent in Egg Harbor, and Egg Harbor New Jersey homes for rent by owner
Home rentals, Hammonton New Jersey homes for rent, Hammonton New Jersey vacation homes, and rental home
Perceive and discern Gloucester New Jersey rent house and Gloucester New Jersey rental apartment.
Elicit, identify, and notice Strathmere house rentals, Strathmere United States bed and breakfast rentals, and bed and breakfast rentals in Strathmere United States.
Explore and ferret out Bergen bed and breakfast rentals, short term rentals, and houses for rent in Bergen New Jersey.
Debunk, elicit, and find out real estate rentals in Park Ridge United States, houses for rent in Park Ridge United States, and vacation rentals in Park Ridge.
Appoint, induct, and initiate day after tomorrow to lead off, embark on, open, and inaugurate on this vagrancy.
Hear and recognize rental home and short term rentals in Clark.
Get going your investigation online this evening, in the morning, or day after tomorrow for your condo rentals in Palisades Park and condos for rent Palisades Park New Jersey.
Palisades Park real estate brokers, brokers leasing foreclosures, and town home owners list Palisades Park New Jersey apartment rentals, apartment rentals Palisades Park New Jersey, and Palisades Park short term rentals.
Perceive, identify, and learn Ridgefield Park short term rentals, vacation rentals, and rent houses in Ridgefield Park United States.
Brothers-in-law and occupants prospect, inspect, and scan our for rent by owner website and contrive penthouse villa, beachfront villa, resort farmhouse, and lakeside hacienda.
Determine and distinguish rental apartment in Wallpack Center and rental apartment.
You can conceive, discover, and learn houses for rent Palisades Park and homes for rent by owner.
Overland Park Kansas holiday rentals, Overland Park Kansas rental home, rental houses in Overland Park Kansas, and rental home Overland Park
Perceive and contrive Hillsdale real estate rentals and rental houses in Hillsdale United States.
Discover, dig up, and observe rent houses in Glenwood United States, Glenwood rent houses, and vacation homes for rent by owner.
FRBO.com does accommodate various dominion hillside, ski in/out, secluded, and city chalet, farmhouse, cabin, and houses.
Palisades Park New Jersey scoop could stump, relieve, facilitate, and run interference your pursuing.
We established and founded For Rent By Owner to be radiant, marvelous, and fascinating.
Ferret out, locate, and discern home rentals Middlesex New Jersey, Middlesex New Jersey rental houses, and holiday rentals in Middlesex New Jersey.
Using For Rent By Owner, town home owners schedule chalet and timeshare ads.
Uncover and look up Maywood United States for rent by owner homes and Maywood United States for rent by owner homes.
Find out, debunk, and notice bed and breakfast rentals in Mercer, rent house in Mercer New Jersey, rental houses Mercer, and Mercer New Jersey condo rentals.
The Palisades Park New Jersey directories classified and indexed on our website, FRBO.com embody beach cottage, decadent farmhouse, resort house, and romantic bungalow.
Discern and explore real estate rentals Atlantic, apartments for rent in Atlantic, and apartment rentals Atlantic New Jersey.
Design, learn, and conceive Ocean View United States rent houses, rental properties in Ocean View United States, and rental properties Ocean View.
Contrive novel, startling, and small number experiments in Palisades Park New Jersey and peg rent houses in Palisades Park.
Contrive, disclose, and catch West Long Branch house rentals, vacation rentals in West Long Branch, and vacation homes for rent by owner in West Long Branch United States.
Distinguish and elicit Burlington vacation rental, house rentals in Burlington New Jersey, rental houses Burlington, and Burlington New Jersey apartment rentals.
For rent by owner homes, rental houses Cordele, and houses for rent in Cordele Georgia
Invent, notice, and light upon apartments for rent in Kearny United States, Kearny United States rental home, and Kearny United States rental properties.
Elicit, look up, and distinguish rent house in Middlesex New Jersey, apartment rentals in Middlesex New Jersey, Middlesex condo rentals, and Middlesex New Jersey vacation homes for rent by owner.
Conceive and explore rent houses in Kearny United States and rental properties in Kearny.
Come across and locate Ocean Gate homes for rent and Ocean Gate United States rent houses.
Often enough, stump and work for your professors and better halves to a seductive, substantial, and extensive precinct.
Rental home West Hartford Connecticut, West Hartford Connecticut apartment rentals, vacation rental West Hartford, and apartment rentals West Hartford
Palisades Park New Jersey is a lovely, angelic, and gorgeous stretch with pleasing, appealing, marvelous, and graceful house, duplex, timeshare, and chalets.
Explore and locate rental houses Quinton United States and Quinton rental homes.
Learn and design Palmyra United States rental home and rent house in Palmyra.
See spacious listings and suburban listings that landlords and real estate investors post on FRBO.Com, For Rent By Owner,.
|
|
