Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:29:20.167' ,`MLSNumber` = '18974392' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.437832' ,`Longitude` = '-95.403370' ,`PhotoCount` = '13' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Peloton' ,`StreetNumber` = '4411' ,`StreetSuffix` = 'Road' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2267' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Extended entry with 12-foot coffered ceiling leads past formal dining room to open family room, kitchen and morning area. Family room features wall of windows. Kitchen features generous island with built-in seating space. Primary suite includes bedroom with wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and oversized walk-in closet in primary bath. Secondary bedrooms feature walk-in closets. Extended covered backyard patio. Two-car garage.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 60 (A0287) (IOWA COLONY) BLK 2 LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6650' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.57' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527769' WHERE `Matrix_Unique_ID` = '202565596' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:58:09.127' ,`MLSNumber` = '10876424' ,`ListAgentFullName` = 'Seeta Badal' ,`ListOfficeName` = 'Texas Real Estate & Co.' ,`SellingAgentFullName` = 'Loan Hoang' ,`SellingOfficeName` = 'Nextgen Real Estate Properties' ,`Latitude` = '29.743603' ,`Longitude` = '-95.365142' ,`PhotoCount` = '26' ,`PostalCode` = '77003' ,`RoomCount` = '6' ,`ListPrice` = '420000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Chenevert' ,`StreetNumber` = '2211' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location! Stunning 3 Bedroom 3.5 bathroom home in a gated community. Open concept perfect for entertaining! The first floor bedroom with en-suite bath is ideal for roommates or a home office. The second floor features your living area with high ceiling and oversized window, dining and kitchen with granite counters, and a Center Island with wine cooler and stainless appliances. Balcony on 2nd floor. The third floor primary suite boasts an en-suite bath with dual vanities, a walk-in shower, separate bathtub and spacious walk-in closet. The third floor is complete with an additional bedroom with en-suite bath. Gated entrance to 2-car garage. Patio on 1st floor for Bar-b-que or pet. Located close to all that Midtown has to offer with many shopping, dining and entertainment options. . Close proximity to Downtown, Medical Center, Museum District, Montrose, with easy access to I-45, I-69, I10 & 288. Don’t wait this one won’t last long!' ,`Acres` = '0.0346' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 CHENEVERT LANDING' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1509' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1785' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GREGORY-LINCOLN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Chenevert Lndg' ,`TaxAmount` = '8347' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527770' WHERE `Matrix_Unique_ID` = '211440993' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:59:06.253' ,`MLSNumber` = '54621667' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996418' ,`Longitude` = '-95.144637' ,`PhotoCount` = '12' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Discus' ,`StreetNumber` = '8523' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3193' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2-story located in the Olympic Village community of Walden on Lake Houston. Open plan is perfect for entertaining both intimate gatherings or larger parties. Room at entry could be used as a formal liviing or study with a double sided fireplace separating it from the dining room. Spacious family room is open to the kitchen & breakfast room. Kitchen features granite counters with stainless steel appliances including a new dishwasher and new microwave. Private primary suite down. Ensuite features dual vanities plus a large tub & separate shower. Gameroom plus three bedrooms and a shared bath upstairs. Fenced backyard w/two covered patios, one with a summer kitchen. Move-In Ready with new carpet & fresh paint throughout the interior. Community amenities include 2 Boat Ramps, a Children\'s Baseball and Soccer Practice Field, Fitness Center, Racquet & Tennis Center and Hike & Bike Trails plus the Walden Golf Club, Marina and Yacht Club. Close to shopping, dining and major freeways.' ,`Acres` = '0.2204' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 21 OLYMPIC VILLAGE WALDEN ON LAKE HOUSTON PH 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston' ,`TaxAmount` = '6717' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527770' WHERE `Matrix_Unique_ID` = '211736536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:56:21.677' ,`MLSNumber` = '15872751' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.985840' ,`Longitude` = '-95.167162' ,`PhotoCount` = '17' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Mabels Island' ,`StreetNumber` = '18506' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on cul-de-sac street in the beautiful community of Atasca Woods. 4 bedroom, 2.5 bath home features an amazing open floor plan with great windows & natural light! A formal entry w/soaring ceilings welcomes you & opens to a dining room & study w/French doors for privacy. New wood-look Luxury Vinyl Plank floors flow through the downstairs living spaces. The kitchen has been updated w/new granite counters & new subway tile backsplash. Stainless steel appliance package includes a new microwave & dishwasher. Kitchen opens to the breakfast & living room w/vaulted ceiling & cozy fireplace. Large, first-floor primary features an ensuite with w/double sinks, jetted tub & separate shower. Upstairs, 3 bedrooms share a bath along with a huge gameroom. New carpet in bedrooms & gameroom. Fresh interior paint plus new HVAC systems. Community amenities include a swimming pool, playground & park. Located near FM 1960 & 59. Lake Houston is only minutes away. Schools are zoned to Humble ISD.' ,`Acres` = '0.1521' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 3 ATASCA WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6624' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atasca Woods' ,`TaxAmount` = '6584' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527770' WHERE `Matrix_Unique_ID` = '211760509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:35:42.527' ,`MLSNumber` = '70272534' ,`ListAgentFullName` = 'Christina Boston' ,`ListOfficeName` = 'Boston Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028938' ,`Longitude` = '-95.573338' ,`PhotoCount` = '35' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Birdsnest' ,`StreetNumber` = '9743' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in before the Holidays! Zoned to excellent Klein ISD Schools. Tucked in the back of the community and on a cul de sac lot, there is very little traffic & a nice long driveway leading to your attached garage. This popular Pulte Sheldon plan is great for any stage in life with its 3 bedrooms, 2 baths, spacious study, MUD Space off the garage & a bonus desk space just off the kitchen - perfect for work for home, home-work, or it could even be modified to be a chic bar space! This is the open plan you are looking for with the central island (which is where everyone tends to gather!) open to the dining space (which is a great size for many table options) & then onto the living room (this is great for entertaining and day to day living). Additional upgrades incl. solid surface flooring throughout, stacked stone accents in the kitchen, & extended back patio slab w/ screen door. Location is ideal for commute from The Woodlands, to Downtown, to anywhere NW Houston.' ,`Acres` = '0.1945' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 GROVE AT GLEANNLOCH FARMS SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8471' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grove at Gleannloch Farms' ,`TaxAmount` = '8173' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527770' WHERE `Matrix_Unique_ID` = '211761770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:36:13.197' ,`MLSNumber` = '58354600' ,`ListAgentFullName` = 'Liz Guevara Backman' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.568582' ,`Longitude` = '-95.764792' ,`PhotoCount` = '41' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Long' ,`StreetNumber` = '1702' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled on a tree-lined street, this recently remodeled home welcomes you with a wide open floor plan, perfect for entertaining. Super cute kitchen with tons of storage and lots of counter space for all your prep work. Eat meals in the breakfast area next to the kitchen or right at the kitchen bar. Large bedrooms with original hardwood floors and lots of natural light. No carpet in the home! Don’t forget the enclosed back patio area that allows for backyard entertaining without worries about weather or bugs. Huge yard with shed for all outdoor extras or convert it to fun space for hobbies. Important improvements completed by the sellers include new AC and ductwork (5/2017), kitchen and living rooms floors replaced (12/2020), exterior painting and fence (2/2020), interior painting (9/2022), and all new plumbing under the house (10/2020) to connect to the city line. Never flooded and no HOA. Conveniently located minutes from Brazos Town Center for shopping, dining, and entertainment.' ,`Acres` = '0.2537' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WINSTON TERRACE SEC 2, BLOCK 11, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Winston Terrace Sec 2' ,`TaxAmount` = '4314' ,`TaxRate` = '2.3748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527770' WHERE `Matrix_Unique_ID` = '212245847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T05:04:03.810' ,`MLSNumber` = '24918409' ,`ListAgentFullName` = 'Janice Poscovsky' ,`ListOfficeName` = 'Spouses Selling Houses' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572536' ,`Longitude` = '-95.579315' ,`PhotoCount` = '37' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '358500.00' ,`Status` = 'Active' ,`StreetName` = 'Cotter Lake' ,`StreetNumber` = '4919' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The security of suburbia with the accessibility typically found in the city, this prime location in highly sought after First Colony is conveniently located to local and national groceries, coffee shops, a movie theater, wonderful restaurants and retail shopping. Zoned to highly rated schools it\'s been recently refreshed with full interior paint and new upstairs carpet. An east facing home, its primary bedroom is down with ensuite bath. New 3 inch blinds on all windows and a spacious kitchen with granite counters, lots of cabinets plus an island workspace. The kitchen sink window looks out into the fenced back yard and the driveway door to the kitchen makes grocery unloading a breeze. HOA amenities include the Aquatic center with Olympic lap pool and leisure pool that has lazy river, splash pad, vortex pool and tube slide within walking distance and a Pickleball court not too far away.' ,`Acres` = '0.1799' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE COLONY SEC 2, BLOCK 1, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7836' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Colony Sec 2' ,`TaxAmount` = '6468' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527771' WHERE `Matrix_Unique_ID` = '212442981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:04:49.613' ,`MLSNumber` = '21508667' ,`ListAgentFullName` = 'Jackie Zehl' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659813' ,`Longitude` = '-95.481298' ,`PhotoCount` = '34' ,`PostalCode` = '77096' ,`RoomCount` = '12' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Burdine' ,`StreetNumber` = '11102' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Restoration Hardware Inspired Updates are Showcased throughout this Open Concept Never Flooded* Transitional Style Residence, Featuring 3 Living Areas! Smartly Appointed w/ Refinished Oak Hardwood Floors*, Recessed Lighting, Crown Molding, Designer Paint, & Plantation Shutters.Casually Elegant Dining Area opens to the Front Living Area. Epicurean Kitchen touts White/Grey Granite Couners, White Morrocan Style Tile Backsplash, Shaker Style Cabinets (Glass Front) & Drawers, Breakfast Bar (w/Dual Pendant Lights), Apron Farmhouse SS Sink, & SS Appliance Package with 5 Burner Gas Range, SS VentHood, Kenmore SS Dishwasher, & SS Side-by-Side Refrigerator. Inviting Den features Staggered Tile Floors & French Doors, which open to the Wonderfully Sized Family Room/Gameroom, offering a Wall of Windows, viewing the Patio Area & Yard. The Primary Suite boasts 2 Closets, Nantucket Style Vanity, & Walk-in Shower. Hall Bath with Travertine Topped Vanity & Full Tub/Shower. Large Corner Lot! *Per Seller' ,`Acres` = '0.1928' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 49 WESTBURY SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury' ,`TaxAmount` = '4862' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527771' WHERE `Matrix_Unique_ID` = '212517729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T05:24:08.410' ,`MLSNumber` = '57208881' ,`ListAgentFullName` = 'Charlotte Norambuena' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545349' ,`Longitude` = '-95.485748' ,`PhotoCount` = '34' ,`PostalCode` = '77545' ,`RoomCount` = '6' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Bravos Manor' ,`StreetNumber` = '2126' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This stunning DR Horton home offers energy features for savings on utilities, HERS Energy Rated, tankless water heater and so much more. 2\" blinds, rounded corners, high ceilings & tile flooring. The gourmet kitchen is a chef\'s delight with gorgeous granite countertops and tile backsplash. The water filtration system is an added bonus. The extra large living area is perfect for entertaining friends and family. The primary bedroom/bath are huge with a shower tub combo and double sinks. Schedule your showing today! This home will not last.' ,`Acres` = '0.1291' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CAMBRIDGE FALLS SEC 10, BLOCK 3, LOT 60' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cambridge Falls' ,`TaxAmount` = '5118' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527771' WHERE `Matrix_Unique_ID` = '212832986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:14:32.787' ,`MLSNumber` = '98668175' ,`ListAgentFullName` = 'Amy Raper' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152895' ,`Longitude` = '-95.405598' ,`PhotoCount` = '36' ,`PostalCode` = '77385' ,`RoomCount` = '7' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Park' ,`StreetNumber` = '31847' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish 3 bedroom, 2 bath, one-story Perry home in popular Imperial Oaks neighborhood boasts an expansive kitchen island, high ceilings, neutral color palette, and NO REAR NEIGHBORS. Warm and inviting the home is filled with natural light beaming through beautifully designed windows with wood laminate flooring in main living areas and primary bedroom. The open floor plan is perfect for entertaining. Elegantly appointed kitchen has abundant 42\" cabinetry, tile backsplash, gas cooktop, 19\" tile flooring, and a charming window seat. Serene primary bedroom has an en-suite bath with double sinks, garden tub, separate shower, and spacious closet. Secondary bedrooms share one full bath with shower/tub combo. Gabled ceiling accentuates the study, a flex space for a formal dining, game room, fitness room, or living area. Back yard has room for play or pool! Washer, dryer, and refrigerator included. Conveniently located near shopping, dining, and entertainment. Close to 99/Hardy. Never flooded.' ,`Acres` = '0.124' ,`Area` = '15' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S612180 - IMPERIAL OAKS PARK 12A, BLOCK 1, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Park 12a' ,`TaxAmount` = '6922' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527771' WHERE `Matrix_Unique_ID` = '212838196' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:45:11.800' ,`MLSNumber` = '88314954' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042813' ,`Longitude` = '-95.796648' ,`PhotoCount` = '12' ,`PostalCode` = '77447' ,`RoomCount` = '8' ,`ListPrice` = '258000.00' ,`Status` = 'Active' ,`StreetName` = 'Steep Climb' ,`StreetNumber` = '24043' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Gulf Coast Series, \'\'Cameron II\'\' Plan with Elevation \'\'A\" in Beautiful Becker Meadows! Inviting Two Story with 4 Beds/2.5 Baths/2 Car Garage! Foyer opens to Family Room! Amazing Kitchen w/ 36\'\' Designer Cabinets, Sparkling Countertops, Breakfast/Dining Area & Great Appliance Pkg! Master Bedroom has Master Bath w/ Shower and Walk-in Closet! Lovely Resilient Wood-look Hard Surface Flooring in Main & Wet Areas; Walk-in Utility Room! Fully Sodded Yards and Landscape Pkg! Energy Efficient w/ 16 SEER HVAC System, & MORE!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0004 BLK 001 LOT 010' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Becker Meadows' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527772' WHERE `Matrix_Unique_ID` = '213285080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T05:25:28.373' ,`MLSNumber` = '85925780' ,`ListAgentFullName` = 'Charlotte Norambuena' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531222' ,`Longitude` = '-95.395387' ,`PhotoCount` = '48' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '710000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Oak' ,`StreetNumber` = '2831' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2831 Maple Oak Lane in the tranquil community of Pomona.Built by Highland Homes this spectacular gem has it all.Owners pride boasts both inside and out.The many windows allow for beautiful natural light throughout the home.5 spacious bedrooms, 4.5 bath, soaring high ceilings,convenient home office,home theater room,upstairs sitting/game room and a kitchen that any chef would take pride in.Oversized primary suite with an en-suite that features an oversized shower,double sinks with vanity and a soaking tub perfect for relaxing after a long day.Enjoy the owner custom designed closet providing plenty of space for it all.Primary closet has access to laundry area.Step out back to the covered patio area,perfect for outdoor entertaining/gatherings, with no back neighbors.Custom plantation shutters&upgraded lighting are an added bonus.The epoxy flooring in the tandem sized garage including custom built storage make for a great workshop area.This home is pristine from top to bottom.' ,`Acres` = '0.1865' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 2 (A0417 ACH&B & A0540 ACH&B) BLK 2 LOT 27' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8124' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pomona Sec 2 A0417 Ach&B & A0' ,`TaxAmount` = '17410' ,`TaxRate` = '3.6594' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527772' WHERE `Matrix_Unique_ID` = '213834443' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:46:23.560' ,`MLSNumber` = '61028493' ,`ListAgentFullName` = 'Brandi Jackson' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.377550' ,`Longitude` = '-95.635246' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '739750.00' ,`Status` = 'Active' ,`StreetName` = 'Shore' ,`StreetNumber` = '2025' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3235' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic style and timeless elegance, paired with breathtaking Lake Conroe waterfront views! This luxurious lake home is located in the prestigious gated enclave of South Shore Estates. The outdoor oasis delivers a newly refinished & painted dock, a newly covered 39-foot boat slip with a lift, & you\'re very own pool! A desirable open plan offers a large family room with soaring ceilings, travertine flooring throughout, a chef\'s kitchen with generous storage, stainless steel appliances, breakfast room & walk-in pantry. The primary retreat is complete with a sitting area, dual vanities, soaking jet tub, separate walk-in shower, & generous walk-in closet. The second floor provides two additional bedrooms with en-suite baths. Featuring all new carpet, newly painted interior walls, exterior wood replaced & painted, move in today! Zoned to the highly acclaimed Montgomery ISD & minutes to restaurants, shopping, The Woodlands & more. Come enjoy luxury lake style living, here!' ,`Acres` = '0.1551' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTH SHORE ESTATES 02, BLOCK 1, LOT 11' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6757' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Estates 02' ,`TaxAmount` = '13355' ,`TaxRate` = '2.3542' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527772' WHERE `Matrix_Unique_ID` = '214157409' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:45:30.863' ,`MLSNumber` = '324817' ,`ListAgentFullName` = 'Yesenia Morales-Garza' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.807574' ,`Longitude` = '-94.897556' ,`PhotoCount` = '26' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Squire' ,`StreetNumber` = '10423' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful move-in ready home! Has been completely remodeled w/many upgrades throughout and has a 30-yr roof. Stainless steel kitchen appliances, Calacatta Quartz countertops w/designer backsplash & updated cabinets & fixtures. Kitchen has a breakfast bar & open concept to living area. Spacious living room w/large windows for plenty of natural light. Breakfast nook w/sliding doors leading to backyard and a separate formal dining area. 2-inch blinds, fresh paint, and neutral colors throughout. Large master suite w/walk-in closet. Master bath has an upgraded double vanity, updated fixtures, and remodeled shower with separate soaking tub. Three spacious secondary bedrooms have fresh paint, new carpet, ceiling fans and ample closet space. Backyard has a covered porch and large 12x16 shed/workshop. Fresh exterior paint & new fence. NOT in a flood hazard area. Convenient location, close to schools, stores, restaurants & easy access to I-10 and 99. Must see!' ,`Acres` = '0.133' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 HUNTERS CHASE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Chase Sec 02' ,`TaxAmount` = '6771' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527772' WHERE `Matrix_Unique_ID` = '214174921' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T05:19:01.300' ,`MLSNumber` = '92341767' ,`ListAgentFullName` = 'Brianna Sharum' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737780' ,`Longitude` = '-95.548813' ,`PhotoCount` = '20' ,`PostalCode` = '77042' ,`RoomCount` = '6' ,`ListPrice` = '624900.00' ,`Status` = 'Active' ,`StreetName` = 'Locke' ,`StreetNumber` = '10006' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely, single story, 4 bed, 3 bath home in Briargrove Park just a short walk from shopping and restaurants! The home has granite countertops, travertine and hardwood floors, and a covered backyard seating area. The primary bedroom features two closets, and the fourth bedroom could also double as a game room. The neighborhood is quiet and secluded with peacocks roaming free. The Briargrove Park pool and tennis courts are only a couple of streets over from the house. The Galleria, Town and Country Shopping Center, Memorial City Mall, and Terry Hershey Park are within a few minutes’ drive.' ,`Acres` = '0.1809' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 & TR 41A BLK 2 BRIARGROVE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Briargrove Park Sec 01' ,`TaxAmount` = '12943' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527772' WHERE `Matrix_Unique_ID` = '214202692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:45:28.947' ,`MLSNumber` = '50676458' ,`ListAgentFullName` = 'Andrea Keiller' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.141485' ,`Longitude` = '-95.537476' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '12' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Liberty Branch' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Spring' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4546' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive Liberty Branch home. Traditional English styling with brick exterior. Many updates including extensive wood tile flooring throughout most of the ground floor, painted kitchen cabinets, oven/microwave combo, interior and exterior paint, upgraded sprinkler system & landscaping, AT & T Fiber, pool pump & aqua link & outdoor fans. Dramatic entry with wine grotto, high ceilings, study with French doors and dining room with ceiling beams. Two story family room with stone fireplace & built-ins, large island kitchen, mud room, split plan with private downstairs guest suite, iron staircase leading up to spacious game room & media room, three large secondary bedrooms upstairs, two with en-suite baths and one with full bath shared with game/media room. Beautiful back yard with sparkling pool / spa, summer kitchen & covered patio. Oversized three car tandem garage with storage & epoxy floor coating. Desirable location, close to parks, pools, shopping and exemplary schools.' ,`Acres` = '0.2337' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Exclusions,Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10179' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park 32' ,`TaxAmount` = '20775' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527773' WHERE `Matrix_Unique_ID` = '214512046' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T05:56:05.360' ,`MLSNumber` = '26664406' ,`ListAgentFullName` = 'Joan Townsend' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.400994' ,`Longitude` = '-95.603682' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '995000.00' ,`Status` = 'Active' ,`StreetName` = 'Walden Estates' ,`StreetNumber` = '3726' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2739' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning lakefront views on this updated and remodeled Walden home. Lakefront living doesn\'t get better than this! Fabulous views and location are not all this one has to offer as seller has updated almost every square inch of this home! Upon entering front door there are views to the lake through the family area with vaulted ceilings and massive stack stone electric fireplace! Dining room boasts same lakefront views. Kitchen has updated stainless appliances, induction cooktop and oversized island w/ quartz c-tops too and wall of cabinetry. Primary bedroom has recent addition to provide private sitting area for owners and more hidden closets/storage with more stunning views of the lake. Bedrooms up have updated private baths. Replaced windows with Anderson windows. Outdoor spaces include stunning landscaping, mature oak trees, boat slips/cover, jet ski slips, improved bulkhead, decks, sprinkler system, artificial turn & whole house generator! Too much to list must see!' ,`Acres` = '0.2577' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S945507 - WALDEN 07, BLOCK 1, LOT 7, SECTION 7-A' ,`LotDesciption` = 'In Golf Course Community,Water View,Waterfront' ,`LotSize` = '11224' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '968' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Walden 07' ,`TaxAmount` = '16244' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527773' WHERE `Matrix_Unique_ID` = '214518140' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T05:54:41.217' ,`MLSNumber` = '32295984' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801750' ,`Longitude` = '-95.853130' ,`PhotoCount` = '39' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'River Birch' ,`StreetNumber` = '7522' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular new one-story home! This expansive 4-bedroom, 3 1/2 bath home features vaulted ceilings in the family room, which opens to the kitchen and dining areas. The kitchen features lots of preparation space and a large walk-in pantry. Double ovens and a large island make this the gathering spot. Spacious family room has vaulted ceilings. The outdoor living patio makes this a perfect home to entertain with no rear neighbors and room for a pool. The owner\'s retreat features a vaulted bedroom ceiling, super shower and the expansive closet, this makes a great place to escape. Three secondary bedrooms, one with an in-suite bath and a connected bath on the others. Private study with French doors. The family foyer is a must have with additional storage and mud area. 4-car garage! Guaranteed energy savings through our Environments for Living Diamond Program. Katy ISD schools.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '11188' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527773' WHERE `Matrix_Unique_ID` = '214532303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:26:36.060' ,`MLSNumber` = '65300767' ,`ListAgentFullName` = 'Glenn Barnes' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467673' ,`Longitude` = '-95.466416' ,`PhotoCount` = '25' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '274988.00' ,`Status` = 'Active' ,`StreetName` = 'Ashley Falls' ,`StreetNumber` = '602' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home has an assumable 2.99% mortgage. Live comfortably in this lovely 3 bedroom, 2-bathroom home in Southern Colony. High ceilings, wood flooring, formal living room, dining room, and a covered patio in the expansive backyard. The primary suite is large ( as pictured the room easily accommodates a king size bed, two night stands, two wardrobe chests, and still has plenty of room to move around). The home features several options for storage with a large shed in the rear, and several garage storage options. Smart features, include a smart garage, thermostat, locks, and a Rachio managed sprinkler system (that automatically adjusts for weather and soil saturation levels). You willbe minutes from the new 288 Highway 6 shopping center. New High school currently being built in the area. Take advantage now.' ,`Acres` = '0.1377' ,`Area` = '38' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 4A, BLOCK 6, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southern Colony Sec 4a' ,`TaxAmount` = '6457' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527773' WHERE `Matrix_Unique_ID` = '214552254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T05:42:25.680' ,`MLSNumber` = '16695706' ,`ListAgentFullName` = 'Helen Pac Franco' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780575' ,`Longitude` = '-95.429712' ,`PhotoCount` = '46' ,`PostalCode` = '77007' ,`RoomCount` = '4' ,`ListPrice` = '545500.00' ,`Status` = 'Active' ,`StreetName` = 'Petty' ,`StreetNumber` = '5932' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning, modern new construction in Cottage Grove Area. This beautiful, free-standing unit is ready to move in. It has 4 beds, 3.5 baths. This home features an amazing kitchen with a large island bar, quartz countertops, Stainless Steel Appliances, and a gas range. 10 Foot Ceilings on every level, Primary Bath with dual vanities, frameless walk-in glass shower, and a beautiful freestanding bathtub. Engineered Wood Floors, Double-Pane Sound Proof Windows, High Efficient Trane HVAC, Tank-less Water Heater and a Large Balcony. NO HOA. This home is conveniently located close to the Houston coolest Shops, Patio Cafés, Art Galleries, Trendy Eatery Places. Easy access to I-10. Close to Downtown Houston, Galleria Area, River Oaks, Memorial Park, Rice Military/Washington and The Heights. Don\'t Miss This Opportunity!' ,`Acres` = '0.0473' ,`Area` = '9' ,`BuilderName` = 'Clariss Group LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 1 TOWNHOMES AT PETTY STREET' ,`LotDesciption` = 'Corner' ,`LotSize` = '2062' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Townhomes/Petty Street' ,`TaxAmount` = '2547' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527774' WHERE `Matrix_Unique_ID` = '214601507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:54:03.683' ,`MLSNumber` = '21031900' ,`ListAgentFullName` = 'Toni McCurley' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Sandra Rubalcava' ,`SellingOfficeName` = 'Vive Realty LLC' ,`Latitude` = '29.947598' ,`Longitude` = '-95.566240' ,`PhotoCount` = '15' ,`PostalCode` = '77070' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Vita' ,`StreetNumber` = '11914' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely & well maintained 3 bedroom & 2-1/2 baths with a game room. Recently updated kitchen with granite counters, Quartz backsplash, freshly painted cabinets with new hardware with a cast iron farmhouse sink. In addition all windows have been updated with 2-1/2 each faux wood blinds. Also, conveniently located to major freeways, shopping and dining.' ,`Acres` = '0.0803' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 GREEN CREEK ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DANISH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Creek Estates Sec 02' ,`TaxAmount` = '5007' ,`TaxRate` = '2.8087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527774' WHERE `Matrix_Unique_ID` = '214608355' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214609906','1668527774','214609906','2022-11-15T05:16:33.057','68358143','Lacy Lewis','Mr. Real Estate','','','29.621917','-95.359817','15','77047','5','370000.00','Active','Donegal','12933','Way','Houston','2','1','3','1976','Single-Family','Elegant New custom home beauty on a large corner lot! Beautiful front stone elevation with covered front entryway. High ceilings & built in\'s throughout! Engineered wood flooring. This 3 bedroom 2.5 bath home is a one of kind with open layout and high end kitchen with a waterfall island. This is the largest lot of 3 homes to be built, its a must see home!','0.1639','3','Private Builder','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Medical Center South','Central Gas','0','LT 5 BLK 16 SHAMROCK MANOR','Cleared,Corner','7140','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','LAW ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','THOMAS MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Shamrock Manor','494','2.3307','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:49:17.243' ,`MLSNumber` = '13087504' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043004' ,`Longitude` = '-95.796362' ,`PhotoCount` = '6' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Hilltop Climb' ,`StreetNumber` = '18511' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Gulf Coast Series, \"Arcola II\'\' Plan with Elevation \'\'B\" in Becker Meadows! Charming One Story with 3 Beds/2 Baths/2 Car Garage! Front Porch/Entry Foyer opens to Family Room! Fantastic Kitchen has 36\'\' Designer Cabinets, Sparkling Countertops, Breakfast/Dining Area and Great Appliance Pkg! Master Bedroom has Master Bath w/ Tub & Shower Combo, Large Walk-in Closet! Walk-in Utility Room! Lovely Hard Surface Floors; Fully Sodded Yard and Landscape Pkg! Energy Efficient w/16 SEER HVAC System & MORE!*ESTIMATED COMPLETION FEBRUARY 2023*' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0004 BLK 001 LOT 002' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Becker Meadows' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668527774' WHERE `Matrix_Unique_ID` = '214629755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-15T06:40:09.250' ,`MLSNumber` = '77744510' ,`ListAgentFullName` = 'Iliana Sanchez' ,`ListOfficeName` = 'NuWay Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738196' ,`Longitude` = '-95.456171' ,`PhotoCount` = '45' ,`PostalCode` = '77027' ,`RoomCount` = '5' ,`ListPrice` = '1099995.00' ,`Status` = 'Active' ,`StreetName` = 'Alabama' ,`StreetNumber` = '4710' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION!! Completely remodeled 3 bedroom 2 bath 2 car garage home in the heart of the Houston Galleria and RIVER OAKS. AVAILABLE FOR MOVE IN TODAY! Home features OPEN CONCEPT FLOOR PLAN, laminate flooring throughout, NO CARPET! Recessed lighting throughout, designer kitchen with QUARTZ COUNTER TOPS AND BREAKFAST BAR, all stainless steel appliances included. The laundry room is conveniently located inside the home, REFRIGERATOR, WASHER AND DRYER INCLUDED! Primary bedroom with en-suite bath. The bathrooms also have quartz counter tops. After a long day, relax in your COVERED BACK PATIO! There is extra parking in front of home along with a long driveway leading to the 2 car detached garage. Schedule your showing today!' ,`Acres` = '0.2208' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Royden Oaks/Afton Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 1A & 2A BLK 1 GREENWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9620' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668527774' WHERE `Matrix_Unique_ID` = '214631685' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214726176','1668527775','214726176','2022-11-15T06:24:57.017','77772708','Wenqian Zhao','Keller Williams Realty - Memorial','','','29.894825','-95.509484','0','77040','10','359900.00','Active','Red Spruce','10606','Lane','Houston','3','0','5','2690','Single-Family','Great location close to cypress and Jersey village, located in woodland oaks subdivision. Renovated recently, including floors, fresh paintings and doing replacing all carpets. Very good size which has 4 bedrooms and 1 studio (could be bedroom) and game room. 3 Full bathrooms are very good for big family. Primary bedroom features hardwood floors, and shower with separate tub. The second story has big game room. The yard is cozy and big with comfortable patio. All appliances included refrigerator, microwave, stove and oven, dishwasher. The workers are installing carpets, will be finished around Nov 20th 2022.','0.1719','11','','','','','Sellers Disclosure','','','','Northwest Houston','Central Electric','1','LT 1277 BLK 27 WOODLAND OAKS SEC 6','Cleared','7487','Appraisal District','','400','0','','2','','0','','','','','Other','13 - Cypress-Fairbanks','REED ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','JERSEY VILLAGE HIGH SCHOOL','DEAN MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Other Style','Woodland Oaks Sec 06','5253','2.091','Public Sewer,Public Water,Water District','2010','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214764035','1668527775','214764035','2022-11-15T06:40:23.193','70353221','Destiny Gallion','Main Properties','','','29.659584','-95.022665','42','77571','4','179900.00','Active','3rd','510','Street','La Porte','2','0','2','1228','Single-Family','Adorable cottage style home. Oversized den with built ins, large dining area, and updated kitchen with granite counter tops. Utility room in kitchen beside the pantry. Cozy breakfast area in kitchen. Carpet in bedrooms and den. Laminate flooring in dining area, kitchen, and hallway. Both bathrooms updated. Master bathroom has shower only. Covered patio and detached garage. Plumbing is approx. 2yrs, roof is approx. 4 yrs, updated flooring, and water heater is approx. 2yrs old. This is a must see! Lots of character and charm.','0.1291','7','','','','','Sellers Disclosure','0','','','La Porte/Shoreacres','Central Gas','0','LT 25 & N 20 FT OF LT 24 BLK 112 LA PORTE','Subdivision Lot','5625','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Cooktop','','Composition','35 - La Porte','LA PORTE ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Town/Laporte','2568','2.9045','Public Sewer,Public Water','1958','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214764114','1668527775','214764114','2022-11-15T06:43:14.493','63210910','Destiny Gallion','Main Properties','','','29.645555','-95.130187','48','77505','9','339000.00','Active','Royal Manor','4243','Drive','Pasadena','2','1','3','3014','Single-Family','Beautiful home on corner lot in quiet neighborhood. Fromal living and formal dining room, spacious den with fireplace, oversized kitchen with two breakfast/dining areas. All bedrooms up with game room. Large primary bedroom with walk-in closet, primary bathroom with double sinks, soaking tub, and separate shower. Lots of storage, lots of natural light, freshly painted interior, generator stays. This is a must see!','0.1923','6','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Pasadena','Central Gas','1','LT 29 BLK 8 VILLAGE GROVE SEC 2B R/P','Corner,Subdivision Lot','8376','Appraisal District','','295','0','','1','Gas Oven','0','','','Gas Cooktop','','Composition','16 - Deer Park','FAIRMONT ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','FAIRMONT JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Village Grove Sec 02b R/P','8603','2.8798','Public Sewer,Public Water','1989','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214764176','1668527775','214764176','2022-11-15T06:50:52.480','84988713','Rosa Maria Williams','Main Properties','','','29.622853','-95.031221','0','77571','8','389900.00','Active','Windleaf','1307','Drive','Shoreacres','2','0','4','2415','Single-Family','Beautiful Atlantis custom home with 4 bdrms 2 baths, pride of ownership shows through out from custom kitchen cabinets, to 2 sided fireplace, granite counter tops, high ceilings, formal dinning, open covered patio, pond for your fishing enjoyment. No back neighbors. Easy commute to Hwy 146, Seabrook, Kemah, Space Center.','0.2572','7','','','','','Sellers Disclosure','1','','1','La Porte/Shoreacres','Central Electric,Central Gas','1','LT 8 BLK B BAYOU FOREST PH 1 SEC 1','Subdivision Lot','11205','Appraisal District','','295','0','','2','','0','','','','','Composition','35 - La Porte','BAYSHORE ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LA PORTE J H','Appointment Required,Leave Business Card','Appraisal District','1','Traditional','Bayou Forest Ph 01 Sec 01','8826','2.8597','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully