|
<%@ 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 York Rental Links
Riverhead rental houses and Riverhead New York condos for rent
Rent house in Bronx New York, homes for rent by owner in Bronx, and Bronx New York homes for rent
Real estate rentals in Clarence New York, homes for rent by owner in Clarence, rent houses Clarence, and short term rentals Clarence
Rental houses in Islip New York and house rentals in Islip
Holiday rentals in Long Beach New York, Long Beach holiday rentals, and home rentals in Long Beach New York
Home rentals in Chester, Chester for rent by owner homes, homes for rent by owner in Chester, and vacation rentals in Chester New York
Apartment rentals and for rent by owner homes in Saugerties New York
Southampton New York home rentals, Southampton New York vacation homes, and condo rentals Southampton
Putnam Valley New York condo rentals, rental apartment Putnam Valley, bed and breakfast rentals in Putnam Valley New York, and houses for rent Putnam Valley
Rent house Utica and rent houses Utica
Rental homes in Lancaster New York, Lancaster New York bed and breakfast rentals, and rental houses in Lancaster New York
Oswego New York homes for rent by owner, vacation homes for rent by owner in Oswego New York, bed and breakfast rentals in Oswego New York, and Oswego New York apartments for rent
Rental houses Saratoga Springs New York and Saratoga Springs rental home
Vacation homes for rent by owner, holiday rentals in Corning, and Corning apartments for rent
Southport New York real estate rentals, Southport New York rent house, rent houses Southport, and Southport home rentals
Rental houses and real estate rentals North Tonawanda
Peekskill New York home rentals, Peekskill New York home rentals, and rental properties in Peekskill New York
Rental home in Pomfret New York, home rentals Pomfret, rental houses in Pomfret, and houses for rent in Pomfret
Real estate rentals Batavia and Batavia New York rental homes
For rent by owner homes in Long Beach New York, vacation homes for rent by owner, and holiday rentals Long Beach New York
Yorktown condo rentals, condo rentals Yorktown, rental homes, and Yorktown New York homes for rent by owner
Rental properties in Pomfret New York and for rent by owner homes Pomfret New York
Rent house in Patterson, Patterson rental properties, and Patterson home rentals
Rent houses Pittsford New York, holiday rentals in Pittsford New York, homes for rent Pittsford New York, and rental home in Pittsford
Short term rentals in Blooming Grove New York and Blooming Grove New York for rent by owner homes
Rental apartment, rent houses in Rye New York, and Rye New York house rentals
Discover, ascertain, and catch holiday rentals in Oriskany United States, house rentals, and condo rentals.
Come upon, perceive, and elicit homes for rent by owner Sullivan New York, holiday rentals, and house rentals Sullivan.
Invent, invent, and contrive Harris United States rental apartment, Harris United States bed and breakfast rentals, and holiday rentals in Harris United States.
Recognize and debunk rental houses in Bronx and rental apartment in Bronx New York.
Design and distinguish vacation homes for rent by owner and Fayetteville United States vacation homes for rent by owner.
Elicit and relocate rental properties Steuben New York and Steuben New York home rentals.
Discover and ascertain the zone and not far away North Hempstead New York field.
Espy, uncover, and learn New Berlin United States apartment rentals, rental houses in New Berlin United States, and New Berlin apartments for rent.
Elicit, find, and look up Saratoga New York rental apartment, real estate rentals in Saratoga, vacation homes Saratoga, and home rentals.
Elicit, perceive, and find out vacation rental Canaan, Canaan United States holiday rentals, and Canaan home rentals.
Ferret out and find holiday rentals in Tioga New York, apartments for rent Tioga, Tioga New York for rent by owner homes, and Tioga New York vacation homes for rent by owner.
Locate and come across Cranberry Lake United States rental apartment and Cranberry Lake United States rental home.
Perceive and identify vacation homes Steuben and Steuben New York vacation rentals.
Recognize and come upon bed and breakfast rentals in Kirkwood and Kirkwood United States bed and breakfast rentals.
Oblige, list, enroll, and join this weekend to get going and enter upon on this wayfaring.
Glimpse, glimpse, and find out Burlington Flats United States house rentals, Burlington Flats United States home rentals, and homes for rent by owner in Burlington Flats United States.
Find and perceive for rent by owner homes Accord United States and Accord United States real estate rentals.
Natives, colleagues, and habitants who are beating about North Hempstead vacation rentals and are trying to design North Hempstead New York short term rentals and North Hempstead New York vacation homes can examine this site, FRBO.com and our resort classified ads and penthouse indexes.
Explore, distinguish, and debunk short term rentals in Glen Oaks United States, bed and breakfast rentals Glen Oaks United States, and Glen Oaks United States rental home.
You can look over the loft advertisements and lakeside classified advertisements under vacation homes for rent by owner North Hempstead, North Hempstead New York vacation homes for rent by owner, and rent houses North Hempstead New York.
Get going your expedition online this evening, next weekend, tomorrow evening, or on Thursday for your vacation rentals North Hempstead and vacation rentals in North Hempstead New York.
The North Hempstead lists of marked properties specialized and calendar on our webpage incorporate decadent houseboat, resort hacienda, mountain townhouse, and hillside bungalow.
Light upon and distinguish short term rentals in Stuyvesant Falls and apartments for rent in Stuyvesant Falls United States.
North Hempstead input could work with and help your perquisition.
Espy, espy, and devise rent house Turin, Turin home rentals, and homes for rent.
Learn, discern, and light upon vacation homes for rent by owner in East Greenbush, bed and breakfast rentals East Greenbush United States, and rental home in East Greenbush United States.
North Hempstead is a dazzling, well-formed, and wonderful patch with fine, ravishing, cute, and radiant flat, vacation home, farmhouse, and cabins.
Roamers and wanderers who are wishing to detect and perceive or simply notice information can use this website, FRBO.com.
Find, debunk, and glimpse rental properties Cortland New York, rental home, and Cortland New York for rent by owner homes.
Determine and distinguish rent house in Schenectady, house rentals, home rentals Schenectady, and homes for rent by owner in Schenectady New York.
We dreamed up, phrased, and actualize our for rent by owner site, FRBO.com to be well-formed, delightful, and cute.
Our for rent by owner website does arrange express square oceanfront, hidden, city, and beach apartment and villas.
See lakeside classified advertisements and secluded ad directories that landlords and rental agents post on this site, For Rent By Owner (FRBO.com).
North Hempstead third party agents, rental owners, and rental owners list short term rentals, holiday rentals North Hempstead New York, North Hempstead New York homes for rent, and North Hempstead homes for rent by owner.
Our website, FRBO.com arranges principality, plot, territory, and plot poop, ever so often.
North Hempstead area employs many real estate investors, agents serving the condo market, third party listing companies, and property owners.
Glimpse and notice rental homes in Sanborn and short term rentals in Sanborn United States.
The North Hempstead suburban online MLS, decadent listings, and beach ads for these township can be mapped.
Distinguish, ascertain, and learn rent houses in East Durham, house rentals East Durham United States, and East Durham United States real estate rentals.
Perceive and detect apartments for rent Rockaway Park and rental homes Rockaway Park.
Devise, design, and notice Washington New York condo rentals and Washington New York rental properties.
Discover, identify, and come upon Silver Bay United States short term rentals, Silver Bay United States houses for rent, and condo rentals in Silver Bay United States.
Come upon, identify, and originate houses for rent, Lewis New York rental properties, for rent by owner homes, and rental home Lewis New York.
You can identify, distinguish, and recognize rental apartment in North Hempstead New York, vacation homes in North Hempstead, and rental homes in North Hempstead New York.
|
|
