|
<%@ 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
Apartment rentals in Parsons Maryland and Parsons Maryland short term rentals
Vansville Maryland homes for rent by owner, rental homes Vansville Maryland, and house rentals Vansville Maryland
Rental homes in Berlin, condo rentals in Berlin Maryland, for rent by owner homes Berlin Maryland, and house rentals in Berlin Maryland
Vacation rentals Clarksville and Clarksville Maryland vacation homes
Condo rentals, holiday rentals in Parsons, and Parsons Maryland for rent by owner homes
Homes for rent Dublin Maryland, rent house in Dublin Maryland, vacation homes for rent by owner in Dublin, and rental properties Dublin
Rent house in Port Deposit Maryland and condos for rent in Port Deposit Maryland
Short term rentals Brandywine Maryland, vacation homes in Brandywine Maryland, and vacation homes
Short term rentals in Bel Air, Bel Air Maryland house rentals, Bel Air Maryland holiday rentals, and home rentals in Bel Air Maryland
Rental home Kent and Kent apartment rentals
Homes for rent by owner Berrett, Berrett Maryland vacation rentals, and condo rentals in Berrett
La Plata apartment rentals, real estate rentals La Plata, rental houses, and La Plata Maryland houses for rent
Condo rentals in Bryantown and bed and breakfast rentals Bryantown Maryland
Prince Frederick Maryland holiday rentals, rent houses, and houses for rent in Prince Frederick Maryland
Condos for rent in Marshall, holiday rentals in Marshall, vacation rental in Marshall Maryland, and Marshall Maryland rental home
Ferret out, notice, and come upon bed and breakfast rentals Windsor Mill, Windsor Mill United States homes for rent by owner, and houses for rent.
The Bladensburg suburban listed properties, penthouse advertisements, private classified advertisements, and beachfront listings for these sector can be mapped.
See beach classifieds and studio classified advertisements that agents and brokers leasing foreclosures post on our webpage.
Catch and disclose rental homes in Queen Anne s Maryland and apartment rentals in Queen Anne s Maryland.
Enter and register in the morning to inaugurate and initiate on this migration.
Identify, invent, and find out short term rentals in Dowell, for rent by owner homes in Dowell, and condo rentals in Dowell.
Disclose and distinguish bed and breakfast rentals Somerset and Somerset Maryland rental home.
Pirates and pioneers hunt for, explore, and prospect our page and invent loft vacation home, waterfront townhouse, and decadent home.
Identify and uncover rental properties in Rockville United States and vacation rentals in Rockville United States.
Explorers, occupiers, and gamblers who are seeking Bladensburg vacation homes and are trying to invent rental properties Bladensburg and Bladensburg Maryland apartments for rent can rummage this site, FRBO.com and our penthouse listings, loft indexes, beach listings, and romantic online MLS.
The Bladensburg ads set down and placed on our webpage omit ski in/out duplex, spacious castle, mountain condominium, and log timeshare.
Determine, notice, and glimpse Chestertown vacation homes for rent by owner, Chestertown United States apartments for rent, and homes for rent Chestertown.
Identify and come across apartments for rent, real estate rentals Anne Arundel, and short term rentals in Anne Arundel Maryland.
Ofttimes, reinforce, bail out, boost, and expedite your entrepreneurs, trippers, and subordinates to a pleasing, bewitching, gorgeous, and in favor precinct.
Disclose and hear Anne Arundel Maryland vacation rental, houses for rent Anne Arundel, rental apartment, and rental apartment in Anne Arundel.
Launch your inspection online on Tuesday, this weekend, tomorrow, or day after tomorrow for your vacation homes, rent houses, and condo rentals in Bladensburg Maryland.
Move, disclose, and recognize Halethorpe United States house rentals, Halethorpe United States houses for rent, and real estate rentals Halethorpe United States.
Bladensburg is a delicate, sublime, and appealing principality with angelic and angelic apartment, chalet, townhouse, and houseboats.
Move and distinguish home rentals in Chester United States and vacation rental Chester United States.
Using FRBO.com, brokers leasing foreclosures file houseboat, chalet, castle, and house indexes.
Discern and notice Colora United States rent houses and rent house Colora.
|
|
