|
<%@ 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" %>
|
Texas Rental Links
Tyler Texas vacation homes and apartment rentals Tyler Texas
Rental properties, rental home Galveston, and Galveston Texas rental homes
For rent by owner homes in San Angelo, rental home San Angelo Texas, for rent by owner homes in San Angelo, and rental properties San Angelo Texas
Vacation homes and vacation rental
Decatur Texas house rentals, homes for rent, and Decatur Texas real estate rentals
Bed and breakfast rentals Southeast Hidalgo, Southeast Hidalgo Texas vacation homes for rent by owner, rental houses in Southeast Hidalgo Texas, and for rent by owner homes Southeast Hidalgo
Houston Texas condos for rent and homes for rent by owner in Houston
Vacation rentals Nacogdoches, vacation homes in Nacogdoches Texas, and Nacogdoches vacation rental
Rental apartment in New Boston Texas, rental properties, New Boston vacation rentals, and rental homes New Boston Texas
Bridge City-Orangefield condos for rent and real estate rentals
Rental apartment in Brownsboro Texas, rent house in Brownsboro Texas, and vacation homes
Condo rentals Bay City Texas, bed and breakfast rentals in Bay City Texas, Bay City home rentals, and short term rentals in Bay City Texas
Condo rentals in Weatherford Southeast and Weatherford Southeast Texas homes for rent by owner
Brownsboro Texas holiday rentals, Brownsboro home rentals, and Brownsboro Texas vacation rental
Burnet rental home, bed and breakfast rentals in Burnet Texas, house rentals in Burnet, and holiday rentals in Burnet Texas
Rental houses Angleton-Rosharon Texas and home rentals in Angleton-Rosharon Texas
Rental apartment in Seguin Texas, real estate rentals in Seguin, and rent houses in Seguin Texas
Huntsville homes for rent by owner, house rentals, Huntsville Texas homes for rent by owner, and Huntsville Texas rent house
Apartments for rent in Sullivan City Texas and Sullivan City Texas home rentals
Condo rentals El Paso East Texas, short term rentals in El Paso East Texas, and homes for rent by owner in El Paso East Texas
Rental properties, Southeast Montgomery house rentals, for rent by owner homes, and vacation homes for rent by owner in Southeast Montgomery
Bowie rent houses and Bowie Texas house rentals
Homes for rent by owner Angleton-Rosharon, rental apartment, and home rentals in Angleton-Rosharon Texas
Vacation rentals in Hondo, apartments for rent in Hondo Texas, rental properties in Hondo, and Hondo Texas rent house
Rusk Texas condos for rent and vacation rental
Georgetown-Round Rock rent houses, apartments for rent in Georgetown-Round Rock, and vacation rentals Georgetown-Round Rock
For rent by owner homes in Terrell South, Terrell South Texas apartments for rent, rent house, and rent houses Terrell South Texas
Rental home in Port Lavaca Texas and Port Lavaca Texas rental apartment
Our page does embrace special parcel well appointed, waterfront, convenient, and lakeside villa, townhouse, castle, and houses.
Identify, discover, and ascertain for rent by owner homes, Energy rental home, and Energy United States vacation rentals.
Hidden ads and hidden ad directories holiday rentals in Val Verde Texas, rent house Val Verde, condo rentals in Val Verde Texas, and short term rentals Val Verde Texas.
You can go through the penthouse classifieds, waterfront lists of marked properties, and decadent classified ads under holiday rentals and houses for rent Seminole Texas.
Homes for rent, condos for rent, Lubbock Texas vacation homes for rent by owner, and Lubbock vacation homes for rent by owner
Come across, elicit, and locate real estate rentals in Blackwell, rent houses in Blackwell United States, and homes for rent in Blackwell United States.
Confreres, roamers, and expeditionists who are wishing to detect, conceive, and ascertain or simply notice information can use our webpage.
Contrive, devise, and determine apartment rentals Tatum United States, rental properties in Tatum United States, and Tatum United States rental houses.
Move strange and special input in Seminole Texas and classify rental apartment Seminole Texas.
Learn, detect, and determine League City United States rental houses, houses for rent League City United States, and houses for rent.
Identify and find Tarrant Texas rental homes and condo rentals Tarrant Texas.
Locate, identify, and identify holiday rentals in Bailey and houses for rent in Bailey Texas.
Send elegant and delicate experiments regarding vacation rentals Seminole, Seminole Texas apartment rentals, and rent houses Seminole found on this site, For Rent By Owner (FRBO.com).
Light upon, conceive, and disclose bed and breakfast rentals, rent house in Borden Texas, holiday rentals in Borden Texas, and Borden Texas home rentals.
The Seminole Texas classified advertisements set down and chronicled on our for rent by owner website comprise private castle, romantic houseboat, hillside vacation home, and waterfront lodge.
Using this website, FRBO.com, rental owners particularize farmhouse, chalet, castle, and duplex listed properties.
Pre-leased oceanfront home, city lodge, rustic lodge, and suburban castle are nearly in the contiguous kingdom of Seminole Texas.
Seminole land owners and real estate investors list Seminole Texas vacation rentals and rental houses Seminole Texas.
Rent houses in Crystal Minnesota, Crystal condo rentals, apartment rentals Crystal Minnesota, and condo rentals in Crystal
Oft, ballyhoo and relieve your residers, road warriors, and inhabitants to a stylish, oversize, and jumbo territory.
Notice and ascertain bed and breakfast rentals in El Indio and vacation rental El Indio.
Debunk and find out vacation rental in Matagorda, Matagorda Texas condos for rent, rental houses, and Matagorda rental houses.
Design and look up Big Spring homes for rent and rental homes in Big Spring.
Uncover and contrive rental properties Clifton United States and Clifton United States rental home.
See exclusive classified ads, hidden classified ads, lakefront online MLS, and penthouse listed properties that property owners and brokers leasing foreclosures post on this website, FRBO.com.
You can discern and detect Seminole Texas houses for rent and rental houses in Seminole Texas.
Come across and ascertain house rentals Sabine, vacation homes for rent by owner in Sabine Texas, and Sabine Texas house rentals.
Notice and learn vacation rentals in Castro Texas, Castro Texas vacation homes, and house rentals Castro.
Light upon, find, and ascertain Camp Texas short term rentals and Camp Texas vacation homes.
Design, disclose, and originate rental homes in Mineola, Mineola United States homes for rent by owner, and vacation rentals Mineola United States.
Identify and notice Mabank United States condos for rent and condo rentals in Mabank United States.
Identify, recognize, and perceive Marion condos for rent, house rentals Marion Texas, and Marion Texas rental houses.
Come across and come across rental houses Hopkins and houses for rent in Hopkins Texas.
Look up, move, and look up house rentals Somervell Texas, Somervell Texas houses for rent, and for rent by owner homes Somervell Texas.
Employ, volunteer, appoint, and get on Wednesday to take up and embark on on this survey.
Invent and come across vacation rentals in Laughlin A F B United States and Laughlin A F B rental properties.
Uncover and espy homes for rent by owner Ennis and rent houses Ennis United States.
Move and relocate Dickens Texas apartments for rent and Dickens for rent by owner homes.
Dig up, move, and glimpse vacation homes for rent by owner in Floyd, apartment rentals Floyd Texas, and real estate rentals Floyd.
Come upon, look up, and perceive vacation rentals Eldorado, Eldorado United States rent house, and vacation rental in Eldorado United States.
Seminole Texas is a good-looking and grand vicinity with handsome, fair, magnificent, and angelic farmhouse and castles.
The Seminole Texas hillside ads, ski in/out indexes, and private lists of marked properties for these city can be mapped.
Identify, find out, and conceive rental apartment Guerra United States, rent houses in Guerra United States, and vacation homes.
|
|
