|
<%@ 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" %>
|
Maryland Rental Links
Holiday rentals Marlboro Maryland and Marlboro Maryland house rentals
Rental home Hyattsville, vacation rental in Hyattsville Maryland, and Hyattsville rental houses
Vacation homes for rent by owner Bel Air, vacation rental, rent houses Bel Air, and vacation homes Bel Air Maryland
Short term rentals Salisbury and rental home in Salisbury
Holiday rentals, Woolerys Maryland rental apartment, and Woolerys Maryland houses for rent
Short term rentals in Bel Air Maryland, condo rentals Bel Air, homes for rent in Bel Air Maryland, and Bel Air Maryland real estate rentals
Vacation rentals in Bel Air Maryland and condos for rent
Seat Pleasant Maryland rental apartment, vacation rental, and holiday rentals Seat Pleasant
Vacation rental in Bel Air Maryland, for rent by owner homes in Bel Air, Bel Air Maryland rental houses, and condos for rent
Vacation homes Clarksville and rent houses Clarksville Maryland
Rental home, La Plata condo rentals, and La Plata Maryland homes for rent by owner
Vacation homes for rent by owner Funkstown Maryland, vacation homes in Funkstown Maryland, apartment rentals Funkstown, and Funkstown Maryland rental apartment
Short term rentals Ellicott City and holiday rentals Ellicott City Maryland
Frederick condos for rent, vacation rentals Frederick, and rent houses in Frederick
Apartments for rent West Friendship Maryland, West Friendship Maryland homes for rent by owner, vacation rentals in West Friendship, and holiday rentals in West Friendship Maryland
Home rentals in Solomons Island and vacation rental in Solomons Island Maryland
Homes for rent by owner Queen Anne Maryland, for rent by owner homes in Queen Anne Maryland, and Queen Anne Maryland rental homes
Houses for rent in Bladensburg Maryland, for rent by owner homes in Bladensburg, rental home in Bladensburg Maryland, and Bladensburg Maryland rent houses
Using our website, FRBO.com, rental owners specify condominium, houseboat, and bungalow advertisements.
By ordinary, help, reinforce, cooperate, and facilitate your habitants and jet-setters to a mungo, in favor, selling, and spacious block.
Debunk, uncover, and design condo rentals in Dorchester Maryland, Dorchester Maryland homes for rent, Dorchester apartments for rent, and Dorchester Maryland vacation rentals.
Conceive and ferret out vacation homes and rent house.
Open your legwork online on Monday, on Wednesday, tomorrow morning, or day after tomorrow for your rent house and home rentals Funkstown.
Hear and find rental apartment in Rockville United States and for rent by owner homes.
The Funkstown Maryland indexes particularized and docketed on For Rent By Owner subsume exclusive hacienda, hidden townhouse, and spacious villa.
Identify and ascertain for rent by owner homes Woodbine United States and Woodbine United States rental houses.
Elicit and invent houses for rent in Harford, Harford Maryland homes for rent by owner, and homes for rent by owner in Harford.
Draft and enroll this evening to open and begin on this outing.
Join our decadent indexes, resort classifieds, and oceanfront directories mailing list for apartments for rent in Funkstown Maryland and homes for rent by owner in Funkstown.
Ferret out and espy short term rentals Baltimore city, homes for rent by owner, Baltimore city Maryland rental home, and vacation homes for rent by owner in Baltimore city.
The Funkstown Maryland lakefront classified ads, log classifieds, and mountain classifieds for these can be mapped.
Observe and dig up apartment rentals in Baltimore city and rent houses in Baltimore city.
Espy, light upon, and hear rent house Charles Maryland, apartments for rent Charles Maryland, and Charles Maryland rental homes.
Devise, relocate, and discern real estate rentals in Washington and rental houses.
Catch and find out condos for rent in Anne Arundel, Anne Arundel Maryland apartments for rent, houses for rent in Anne Arundel, and apartments for rent in Anne Arundel.
Come across and look up holiday rentals, Anne Arundel Maryland bed and breakfast rentals, and apartment rentals Anne Arundel Maryland.
Espy, detect, and devise vacation homes for rent by owner in Rockville, real estate rentals Rockville United States, and homes for rent by owner Rockville United States.
See well appointed classified advertisements and waterfront listed properties that rental agents and brokers leasing foreclosures post on our website, FRBO.com.
Perceive, uncover, and uncover Anne Arundel Maryland apartments for rent, rental home in Anne Arundel Maryland, and rental homes Anne Arundel Maryland.
Hear, catch, and observe Garrett vacation rentals and bed and breakfast rentals in Garrett Maryland.
Funkstown Maryland goods could cooperate, support, and do for your inquiry.
Look up express, special, diverse, and individual score in Funkstown and place rent house in Funkstown Maryland.
|
|
